global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
12 rows where country_long = "Spain", estimated_generation_note_2014 = "HYDRO-V1" and generation_data_source = "JRC-PPDB-OPEN"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, geolocation_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20145 | 20145 | ESP | Spain | ALDEADAVILA II 2 | WRI1006178 | 1226.43 | 41.2117 | -6.6856 | Hydro | 1986.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1019078 | 2251.653 | 3451.513 | 1196.199 | JRC-PPDB-OPEN | 4817.37 | 4810.3 | 2358.23 | 4794.75 | 3147.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20205 | 20205 | ESP | Spain | BELESAR GRUPO 2 | WRI1006246 | 331.01 | 42.6263 | -7.7135 | Hydro | 1963.0 | GAS NATURAL FENOSA GENERACION S.L.U. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 463.251 | 737.018 | 105.937 | JRC-PPDB-OPEN | 972.62 | 967.6 | 372.82 | 978.93 | 369.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
20242 | 20242 | ESP | Spain | CASTRO II | WRI1006321 | 195.29 | 41.5756 | -6.1891 | Hydro | 1977.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019107 | 358.303 | 425.843 | 182.285 | JRC-PPDB-OPEN | 611.3 | 611.03 | 266.78 | 574.27 | 246.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20245 | 20245 | ESP | Spain | CEDILLO 3 | WRI1006324 | 495.18 | 39.6643 | -7.5332 | Hydro | 1976.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019109 | 329.235 | 604.332 | 294.514 | JRC-PPDB-OPEN | 1399.24 | 1239.99 | 571.56 | 1276.14 | 742.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20364 | 20364 | ESP | Spain | GABRIEL Y GALAN | WRI1006492 | 110.4 | 40.2211 | -6.133 | Hydro | 1982.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019145 | 54.191 | 107.152 | 46.751 | JRC-PPDB-OPEN | 392.69 | 387.53 | 172.06 | 391.38 | 145.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20404 | 20404 | ESP | Spain | LA MUELA CORTES 1 | WRI1006586 | 634.0 | 39.2628 | -0.9192 | Hydro | 1989.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019171 | 2350.322 | 1774.483 | JRC-PPDB-OPEN | 1677.46 | 1361.57 | 642.72 | 1917.94 | 593.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
20857 | 20857 | ESP | Spain | RICOBAYO II 1 | WRI1007850 | 326.57000000000005 | 41.5278 | -5.9877 | Hydro | 1999.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 294.802 | 496.464 | 51.042 | JRC-PPDB-OPEN | 1134.61 | 1056.97 | 358.75 | 1044.32 | 285.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
20872 | 20872 | ESP | Spain | SAUCELLE II 1 | WRI1007891 | 516.39 | 41.045 | -6.8067 | Hydro | 1989.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1019246 | 202.378 | 610.934 | 23.252 | JRC-PPDB-OPEN | 1707.5 | 1704.52 | 676.51 | 1697.09 | 1008.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20887 | 20887 | ESP | Spain | SOUTELO 2 | WRI1007945 | 213.64 | 42.1677 | -7.1744 | Hydro | 1994.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019253 | 131.202 | 154.308 | 59.421 | JRC-PPDB-OPEN | 621.76 | 621.76 | 351.35 | 623.46 | 320.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20893 | 20893 | ESP | Spain | San Esteban II Grupo 1 | WRI1007869 | 438.45 | 42.4143 | -7.6533 | Hydro | 2012.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 103.458 | 404.532 | 40.381 | JRC-PPDB-OPEN | 1200.39 | 1285.51 | 574.4 | 1289.03 | 834.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
20939 | 20939 | ESP | Spain | VILLALCAMPO II | WRI1008030 | 215.81 | 39.2077 | -1.2401 | Hydro | 1977.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019276 | 272.904 | 373.265 | 130.027 | JRC-PPDB-OPEN | 459.07 | 357.79 | 195.26 | 487.12 | 150.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
20941 | 20941 | ESP | Spain | VILLARINO 4 | WRI1008033 | 850.8799999999999 | 41.2669 | -6.3078 | Hydro | 1970.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | WRI | 1019277 | 1235.421 | 1766.051 | 1160.036 | JRC-PPDB-OPEN | 3670.54 | 3636.86 | 1579.98 | 3671.25 | 1308.16 | 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");