global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

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 estimated_generation_gwh
15141 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
15142 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
15143 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
15144 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
15145 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
15146 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
15152 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
15155 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
15156 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
15160 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
15162 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
15183 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
15188 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
15204 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
15210 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
15218 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
15228 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,
  "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 51.224ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute