global-power-plants

Table actions

17 rows where country_long = "Philippines" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, commissioning_year, geolocation_source, estimated_generation_gwh

primary_fuel 1

  • Oil · 17 ✖

country_long 1

  • Philippines · 17 ✖
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
18325 18325 PHL Philippines BAJADA DPP WRI1001966 58.7 7.0731 125.6128 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA                 162.95880550556882
18328 18328 PHL Philippines BAUANG DPP WRI1001879 235.2 16.4907 120.3261 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1010796               652.9456738485483
18334 18334 PHL Philippines CALIBU DPP WRI1001912 30.0 15.1114 120.6053 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1064229               83.2838869704781
18338 18338 PHL Philippines CEBU DPP (Salcon) WRI1001938 43.4 10.2185 123.7577 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB                 120.48402315062496
18340 18340 PHL Philippines COTABATO LIGHT WRI1001965 10.0 7.2236 124.2464 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1013380               27.761295656826032
18345 18345 PHL Philippines Calumangan DPP WRI1023893 23.0 10.581 122.8878 Oil       2016.0 Central Negros Power Reliability Inc. Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants WRI                 63.850980010699864
18358 18358 PHL Philippines GUIMARAS POWER WRI1001936 3.4 10.6584 122.5963 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1061438               9.43884052332085
18367 18367 PHL Philippines LIMAY CCGT WRI1001884 620.0 14.5434 120.5987 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB                 1721.2003307232142
18375 18375 PHL Philippines MALAYA WRI1001883 650.0 14.3959 121.3337 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023523               1804.484217693692
18387 18387 PHL Philippines NAC DPP WRI1030490 10.9 9.7189 125.5081 Oil       2017.0 Nickel Asia Corporation Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants WRI                 30.259812265940376
18389 18389 PHL Philippines PACERM-1 WRI1030491 10.5 8.5577 124.508 Oil       2016.0 PACERM-1 Energy Corporation Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants WRI                 29.14936043966733
18392 18392 PHL Philippines PB 101 WRI1001931 32.0 11.5301 122.3975 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA                 88.8361461018433
18393 18393 PHL Philippines PB 104 WRI1001951 32.0 7.0731 125.6128 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA                 88.8361461018433
18396 18396 PHL Philippines PETERSVILLE DPP WRI1001913 9.0 15.15 120.5833 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1010181               24.98516609114343
18412 18412 PHL Philippines SPPC WRI1001950 59.0 6.1018 125.2905 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1046858               163.7916443752736
18414 18414 PHL Philippines SUBIC DPP WRI1001877 116.0 14.88 120.2343 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1016537               322.03102961918194
18436 18436 PHL Philippines WMPC WRI1001954 113.0 7.0694 122.2014 Oil           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1033310               313.70264092213415

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");