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 generation_gwh_2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20905 | 20905 | ESP | Spain | TAMBRE II GRUPO 1 | WRI1007952 | 73.04 | 42.8368 | -8.8498 | Hydro | 1975.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 | 1032494 | 248.59 | 248.59 | 120.43 | 249.01 | 108.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20906 | 20906 | ESP | Spain | TANES 1 | WRI1007954 | 124.17 | 43.2207 | -5.4278 | Hydro | 1978.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 | 1018399 | 326.25 | 322.5 | 123.09 | 327.14 | 114.8 | 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 | |||||||||||||
20909 | 20909 | ESP | Spain | TERMENS | WRI1007960 | 11.92 | 41.7167 | 0.7667 | 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 | CARMA | 1017224 | 35.42 | 36.42 | 23.31 | 34.27 | 20.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20913 | 20913 | ESP | Spain | TERRADETS 1 | WRI1007963 | 32.32 | 42.0748 | 0.9162 | Hydro | 1935.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 | 1017225 | 110.67 | 111.66 | 64.74 | 109.07 | 59.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20916 | 20916 | ESP | Spain | TORAN | WRI1007972 | 13.12 | 42.2312 | -7.8303 | Hydro | 1963.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 | 1029330 | 39.14 | 39.3 | 26.54 | 39.24 | 24.65 | 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 | ||||||||||||
20932 | 20932 | ESP | Spain | VALDECANAS 3 | WRI1008009 | 247.17 | 39.7778 | -5.6124 | Hydro | 1964.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 | 1019264 | 781.49 | 832.56 | 235.86 | 949.55 | 203.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20933 | 20933 | ESP | Spain | VALPARAISO 2 | WRI1008019 | 65.1 | 41.9974 | -6.2738 | Hydro | 1988.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 | 1019269 | 200.59 | 225.63 | 88.88 | 218.58 | 37.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20935 | 20935 | ESP | Spain | VELLE GRUPO 2 | WRI1008024 | 86.48 | 42.3589 | -7.851 | Hydro | 1967.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 | 1017245 | 284.47 | 302.89 | 208.95 | 300.95 | 149.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20938 | 20938 | ESP | Spain | VIELHA 1 | WRI1008028 | 21.86 | 42.702 | 0.7956 | Hydro | 1947.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 | 1029331 | 74.0 | 73.88 | 37.14 | 71.74 | 38.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20940 | 20940 | ESP | Spain | VILLANUA | WRI1008032 | 10.9 | 41.2702 | -6.3208 | Hydro | 1978.0 | CORPORACION ACCIONA HIDRAULICA S.L. | 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 | 1014337 | 41.98 | 42.05 | 23.28 | 41.98 | 20.97 | 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 | ||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | ||||||||
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 | |||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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 |
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");