global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
124 rows where country_long = "Spain" and primary_fuel = "Hydro" sorted by estimated_generation_gwh_2015
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20862 | 20862 | ESP | Spain | SALIME 4 | WRI1007862 | 157.24 | 43.2364 | -6.8475 | Hydro | 1956.0 | HIDROELECTRICA DEL CANTABRICO 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 | 1014389 | 490.41 | 534.3 | 240.55 | 486.58 | 170.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20918 | 20918 | ESP | Spain | TORREJON 1 | WRI1007974 | 130.36 | 39.5357 | -5.9891 | Hydro | 1967.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 | 1019256 | 284.77 | 291.42 | 246.59 | 385.9 | 224.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20431 | 20431 | ESP | Spain | LOS PEARES GRUPO 2 | WRI1006651 | 181.02 | 42.4637 | -7.7237 | Hydro | 1954.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 | 1032458 | 548.94 | 546.19 | 265.01 | 552.43 | 236.02 | 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 | ||||||||
20904 | 20904 | ESP | Spain | TAJO DE LA ENCANTADA 1 | WRI1007951 | 376.88 | 36.9083 | -4.7631 | Hydro | 1977.0 | ENDESA 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 | 1012844 | 850.37 | 750.05 | 267.09 | 891.26 | 220.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20908 | 20908 | ESP | Spain | TAVASCAN INFERIOR | WRI1007958 | 150.88 | 42.637 | 1.2512 | Hydro | 1971.0 | ENDESA 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 | CARMA | 431.78 | 431.78 | 288.52 | 432.96 | 267.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20241 | 20241 | ESP | Spain | CASTRELO GRUPO 1 | WRI1006320 | 135.59 | 42.2917 | -8.1136 | Hydro | 1969.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 | 406.81 | 429.8 | 302.64 | 430.97 | 209.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20375 | 20375 | ESP | Spain | GUILLENA 1 | WRI1006526 | 207.99 | 37.641 | -6.0724 | Hydro | 1973.0 | ENDESA 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 | 1012801 | 458.88 | 468.9 | 325.65 | 459.04 | 152.89 | 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 | ||||||||
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 | |||||||||
20474 | 20474 | ESP | Spain | MORALETS 1 | WRI1006693 | 219.14 | 42.5787 | 0.7587 | Hydro | 1985.0 | ENDESA 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 | 1015793 | 637.76 | 637.76 | 360.39 | 639.51 | 329.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20351 | 20351 | ESP | Spain | FRIEIRA GRUPO 1 | WRI1006486 | 160.61 | 42.1538 | -8.1933 | Hydro | 1970.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 | 1032441 | 617.47 | 513.39 | 369.78 | 564.01 | 275.97 | 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 | |||||||||
20855 | 20855 | ESP | Spain | RIBA ROJA 1 | WRI1007848 | 261.28 | 41.2422 | 0.4309 | Hydro | 1969.0 | ENDESA 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 | 1015796 | 758.96 | 764.2 | 396.92 | 765.79 | 344.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20831 | 20831 | ESP | Spain | PUENTE BIBEY 4 | WRI1007817 | 312.41 | 42.3921 | -7.2191 | Hydro | 1966.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 | 1019213 | 863.64 | 863.64 | 405.75 | 858.32 | 596.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20467 | 20467 | ESP | Spain | MEQUINENZA 1 | WRI1006676 | 322.36 | 41.3687 | 0.2765 | Hydro | 1964.0 | ENDESA 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 | 1015792 | 933.16 | 893.0 | 426.01 | 892.18 | 424.39 | 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 | ||||||||
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 | |||||||||
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 | |||||||||
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 | ||||||||
20437 | 20437 | ESP | Spain | La Muela II Grupo 4 | WRI1006587 | 877.95 | 39.2438 | -0.9317 | Hydro | 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 | 2492.37 | 2054.93 | 1059.48 | 2825.84 | 991.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
20395 | 20395 | ESP | Spain | JOSE M ORIOL GRUPO 4 | WRI1006571 | 953.32 | 39.2438 | -0.9317 | 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 | 1019076 | 2706.34 | 2231.34 | 1150.43 | 3068.43 | 1076.51 | 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 | ||||||||
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 |
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");