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"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
20873 | 20873 | ESP | Spain | SEIRA II 3 | WRI1007896 | 19.25 | 41.4833 | 0.4667 | Hydro | 1996.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 | CARMA | 68.03 | 69.86 | 39.27 | 70.91 | 38.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20874 | 20874 | ESP | Spain | SEROS II 1 | WRI1023650 | 44.24 | 41.4744 | 0.4534 | Hydro | 1989.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 | 1017220 | 147.39 | 151.06 | 80.82 | 154.0 | 78.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20879 | 20879 | ESP | Spain | SILVON 2 | WRI1007918 | 81.53999999999999 | 40.7149 | -4.0053 | Hydro | 1964.0 | VIESGO GENERACION 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 | WRI | 1014390 | 262.64 | 262.64 | 174.65 | 263.36 | 165.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20881 | 20881 | ESP | Spain | SOBRADELO 2 | WRI1023652 | 44.25 | 42.4139 | -6.9191 | Hydro | 1972.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 | 1019250 | 154.47 | 154.47 | 80.11 | 141.95 | 71.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20882 | 20882 | ESP | Spain | SOBRON 1 | WRI1007924 | 27.78 | 42.7778 | -3.0458 | Hydro | 1961.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 | CARMA | 1019251 | 56.07 | 72.84 | 61.6 | 88.0 | 61.02 | 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 | ||||||||
20889 | 20889 | ESP | Spain | SUSQUEDA 3 | WRI1007949 | 88.55000000000001 | 41.9791 | 2.5274 | Hydro | 1981.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 | 1018381 | 287.52 | 288.51 | 143.28 | 318.3 | 131.39 | 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 | |||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||
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 | ||||||||||||
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");