global-power-plants

Table actions

7 rows where country_long = "Papua New Guinea" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, url

primary_fuel 1

country_long 1

  • Papua New Guinea · 7 ✖
Link rowid ▼ country country_long name gppd_idnr capacity_mw latitude longitude primary_fuel other_fuel1 other_fuel2 other_fuel3 commissioning_year owner source url geolocation_source wepp_id year_of_capacity_data generation_gwh_2013 generation_gwh_2014 generation_gwh_2015 generation_gwh_2016 generation_gwh_2017 generation_data_source estimated_generation_gwh
18266 18266 PNG Papua New Guinea Kanudi WRI1022418 24.0 -9.4318 147.1428 Oil       1999.0 PNG Power Limited PNG Power Limited http://www.pngpower.com.pg/pdfs/PNG-Power-Info-Booklet-2016.pdf WRI 1025259                
18267 18267 PNG Papua New Guinea Lae WRI1022435 30.0 -6.738 146.9912 Oil         Daewoo International Lahmeyer India http://www.lahmeyer.in/30-mw-lae-diesel-power-plant-papua-new-guinea/ WRI 1025264                
18271 18271 PNG Papua New Guinea Ok Tedi WRI1022432 45.0 -5.2095 141.1827 Oil         OK Tedi Mining OK Tedi Mining http://www.oktedi.com/our-operations WRI                  
18273 18273 PNG Papua New Guinea Porgera WRI1022429 13.0 -5.4655 143.1095 Oil         Barrick Mining Barrick http://www.barrick.com/operations/papua-new-guinea/porgera/ WRI 1022270                
18276 18276 PNG Papua New Guinea Tabubil WRI1022433 16.0 -5.2773 141.2323 Oil         OK Tedi Mining OK Tedi Mining http://www.oktedi.com/our-operations WRI 1024752                
18277 18277 PNG Papua New Guinea Tolkuma WRI1023819 3.5 -8.5659 147.1383 Oil         Petromin Mining Petromin http://www.petrominpng.com.pg/assets.html WRI                  
18278 18278 PNG Papua New Guinea Ulagunan WRI1022422 8.4 -4.3557 152.2454 Oil         PNG Power Limited PNG Power Limited http://www.pngpower.com.pg/pdfs/PNG-Power-Info-Booklet-2016.pdf WRI                  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "global-power-plants" (
"country" TEXT,
  "country_long" TEXT,
  "name" TEXT,
  "gppd_idnr" TEXT,
  "capacity_mw" REAL,
  "latitude" REAL,
  "longitude" REAL,
  "primary_fuel" TEXT,
  "other_fuel1" TEXT,
  "other_fuel2" TEXT,
  "other_fuel3" TEXT,
  "commissioning_year" REAL,
  "owner" TEXT,
  "source" TEXT,
  "url" TEXT,
  "geolocation_source" TEXT,
  "wepp_id" TEXT,
  "year_of_capacity_data" INTEGER,
  "generation_gwh_2013" REAL,
  "generation_gwh_2014" REAL,
  "generation_gwh_2015" REAL,
  "generation_gwh_2016" REAL,
  "generation_gwh_2017" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");