global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
7 rows where generation_data_source = "JRC-PPDB-OPEN", primary_fuel = "Hydro" and url = "https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show"
This data as json, CSV (advanced)
owner 2
primary_fuel 1
- Hydro · 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_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17130 | 17130 | LVA | Latvia | Plavinas HPP | WRI1022436 | 894.0 | 56.583 | 25.2394 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | GEODB | 1021832 | 144.894 | 217.504 | 395.995 | JRC-PPDB-OPEN | 2544.77 | 2575.76 | 2546.52 | 2718.88 | 2721.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
18598 | 18598 | POL | Poland | Porąbka-Żar | WRI1019048 | 540.0 | 49.7809 | 19.2115 | Hydro | 1979.0 | Polska Grupa Energetyczna SA | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | University of Dąbrowa Górnicza | 217.088 | 180.583 | 184.058 | JRC-PPDB-OPEN | 1007.08 | 1812.52 | 286.6 | 1895.48 | 1330.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
18625 | 18625 | POL | Poland | Żarnowiec | WRI1019043 | 716.0 | 54.7224 | 18.0825 | Hydro | 1983.0 | PGE | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | University of Dąbrowa Górnicza | 1015458 | 341.323 | 266.382 | 255.981 | JRC-PPDB-OPEN | 1789.14 | 2488.13 | 1293.63 | 2494.95 | 1789.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
19126 | 19126 | ROU | Romania | HPP Lotru | WRI1019100 | 509.0 | 45.4472 | 23.7683 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | GEODB | 668.532 | 657.794 | 465.374 | JRC-PPDB-OPEN | 1461.23 | 860.39 | 937.54 | 911.3 | 1394.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
19128 | 19128 | ROU | Romania | HPP Portile de Fier I | WRI1019095 | 1161.0 | 44.6733 | 22.532 | Hydro | 1972.0 | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | GEODB | 1027194 | 4779.904 | 5434.684 | 4707.119 | JRC-PPDB-OPEN | 6914.64 | 5291.86 | 5996.66 | 6150.39 | 6804.99 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
19130 | 19130 | ROU | Romania | HPP Raul Mare | WRI1019104 | 335.0 | 45.3391 | 22.7213 | Hydro | 1986.0 | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | GEODB | 426.821 | 386.66 | 224.236 | JRC-PPDB-OPEN | 989.16 | 780.86 | 799.28 | 801.47 | 989.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
19899 | 19899 | SVN | Slovenia | ČHE Avče | WRI1022412 | 180.0 | 46.1027 | 13.6708 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | GEODB | 281.969 | 275.186 | 271.43 | JRC-PPDB-OPEN | 685.87 | 550.43 | 509.06 | 661.15 | 533.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
Advanced export
JSON shape: default, array, newline-delimited
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_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");