global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

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

View and edit SQL

Suggested facets: capacity_mw, geolocation_source, estimated_generation_gwh

primary_fuel

  • Hydro · 17

country_long

  • 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
18315 PHL Philippines AGUS 1 WRI1001957 80.0 8.0046 124.2868 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023463               214.9187027726324
18316 PHL Philippines AGUS 2 WRI1001958 180.0 8.0528 124.2709 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023464               483.5670812384229
18317 PHL Philippines AGUS 4 WRI1001959 158.1 8.1336 124.1983 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023466               424.7330863544148
18318 PHL Philippines AGUS 5 WRI1001960 309.0 8.1937 124.1915 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB                 830.1234894592926
18319 PHL Philippines AMBUKLAO WRI1001902 105.0 16.4588 120.7452 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023471               282.08079738908003
18320 PHL Philippines ANGAT WRI1001900 246.0 14.9098 121.1603 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023474               660.8750110258446
18326 PHL Philippines BAKUN WRI1001904 70.0 16.8861 120.5304 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1022084               188.0538649260533
18329 PHL Philippines BINGA WRI1001903 132.0 16.3944 120.729 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023482               354.61585957484334
18330 PHL Philippines BOTOCAN WRI1001899 22.8 14.1463 121.4729 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants CARMA 1023486               61.251830290200225
18335 PHL Philippines CALIRAYA WRI1001898 35.0 14.2992 121.4705 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023490               94.0269324630267
18337 PHL Philippines CASECNAN (NIA) WRI1001905 165.0 15.8462 121.1998 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB                 443.2698244685543
18363 PHL Philippines KALAYAAN PSPP WRI1001896 739.2 14.3168 121.4739 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023516               1985.8488136191236
18372 PHL Philippines MAGAT WRI1001897 360.0 16.8293 121.4537 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023522               967.1341624768455
18391 PHL Philippines PANTABANGAN-MASIWAY WRI1001901 132.0 15.8107 121.109 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023530               354.61585957484334
18397 PHL Philippines PULANGI 4 WRI1001961 255.0 7.7156 125.0236 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023564               685.0533650877658
18407 PHL Philippines SAN ROQUE WRI1001894 411.0 16.1462 120.6837 Hydro           Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants GEODB 1023567               1104.1448354943989
18421 PHL Philippines San Luis WRI1030472 1.0 15.6854 121.4748 Hydro       2017.0 Epower Technologies Corp. Philippines Department of Energy https://www.doe.gov.ph/list-existing-power-plants WRI 1058810               2.6864837846579044

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");
Powered by Datasette · Query took 53.33ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette