global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
11 rows where country_long = "Greece", generation_data_source = "JRC-PPDB-OPEN" and primary_fuel = "Hydro" sorted by other_fuel3
This data as json, CSV (advanced)
Suggested facets: capacity_mw, commissioning_year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13803 | 13803 | GRC | Greece | Assomata | WRI1061085 | 108.0 | 40.4738 | 22.2421 | Hydro | 1985.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v23 | WRI | 1026307 | 216.424 | 155.595 | 123.168 | JRC-PPDB-OPEN | 192.11 | 155.1 | 182.78 | 191.98 | 158.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13825 | 13825 | GRC | Greece | Kastraki | WRI1061076 | 320.0 | 38.7413 | 21.3654 | Hydro | 1969.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v31 | WRI | 1026324 | 709.668 | 698.491 | 544.529 | JRC-PPDB-OPEN | 447.97 | 401.1 | 391.73 | 489.32 | 405.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13832 | 13832 | GRC | Greece | Kremasta | WRI1061073 | 437.0 | 38.8904 | 21.4996 | Hydro | 1965.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v30 | WRI | 1026330 | 918.321 | 960.759 | 723.313 | JRC-PPDB-OPEN | 609.27 | 543.74 | 572.5 | 574.07 | 502.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13853 | 13853 | GRC | Greece | Pigae Aoos | WRI1061078 | 210.0 | 39.6871 | 20.8421 | Hydro | 1989.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v26 | WRI | 1026349 | 151.287 | 238.684 | 120.385 | JRC-PPDB-OPEN | 351.86 | 321.91 | 351.86 | 352.82 | 321.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13854 | 13854 | GRC | Greece | Plastiras | WRI1061082 | 130.0 | 39.2413 | 21.7479 | Hydro | 1959.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v27 | WRI | 1026350 | 153.615 | 183.827 | 180.06 | JRC-PPDB-OPEN | 246.74 | 228.21 | 246.74 | 247.42 | 228.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13855 | 13855 | GRC | Greece | Platanovryssi | WRI1061084 | 108.0 | 41.3371 | 24.4546 | Hydro | 1997.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v22 | WRI | 1026351 | 336.596 | 223.87 | 122.341 | JRC-PPDB-OPEN | 198.42 | 177.06 | 210.46 | 181.57 | 173.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13857 | 13857 | GRC | Greece | Polyphyto | WRI1061083 | 124.0 | 40.3013 | 22.1004 | Hydro | 1974.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v25 | WRI | 675.879 | 472.045 | 357.84 | JRC-PPDB-OPEN | 195.31 | 146.59 | 183.51 | 194.8 | 149.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
13858 | 13858 | GRC | Greece | Pournari | WRI1061075 | 334.0 | 39.1871 | 21.0263 | Hydro | 1981.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v28 | WRI | 1026353 | 280.882 | 363.302 | 185.946 | JRC-PPDB-OPEN | 453.07 | 400.97 | 429.12 | 434.98 | 290.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13866 | 13866 | GRC | Greece | Sfikia | WRI1061077 | 315.0 | 40.3954 | 22.1913 | Hydro | 1985.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v24 | WRI | 1026361 | 318.167 | 215.765 | 182.034 | JRC-PPDB-OPEN | 650.8 | 532.73 | 451.95 | 621.95 | 540.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
13871 | 13871 | GRC | Greece | Stratos | WRI1061081 | 150.0 | 38.6788 | 21.3254 | Hydro | 1988.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v32 | WRI | 309.068 | 318.783 | 236.671 | JRC-PPDB-OPEN | 263.43 | 241.46 | 237.07 | 282.96 | 243.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
13878 | 13878 | GRC | Greece | Thissavros | WRI1061074 | 381.0 | 41.3537 | 24.3629 | Hydro | 1996.0 | Global Reservoir and Dam Database | http://sedac.ciesin.columbia.edu/data/collection/grand-v21 | WRI | 1026373 | 577.34 | 382.454 | 240.761 | JRC-PPDB-OPEN | 581.71 | 730.68 | 501.09 | 723.71 | 678.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");