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 latitude
This data as json, CSV (advanced)
owner 10
- ENDESA GENERACION S.A. 6
- VIESGO GENERACION S.L. 4
- HIDROELECTRICA DEL CANTABRICO S.A. 3
- IBERDROLA GENERACION S.A. 3
- CORPORACION ACCIONA HIDRAULICA S.L. 2
- NAVARRO GENERACION S.A. 2
- ACCIONA SALTOS DE AGUA S.L. 1
- GAS NATURAL FENOSA GENERACION S.L.U. 1
- HIDROELECTRICA DEL GIESTA SRL 1
- SALTOS DEL NANSA I S.A. UNIPERSONAL 1
primary_fuel 1
- Hydro · 24 ✖
country_long 1
- Spain · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
20389 | 20389 | ESP | Spain | IP 1 | WRI1006560 | 88.85 | 42.7163 | -0.5256 | Hydro | 1969.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 | 1014321 | 292.3 | 292.3 | 196.42 | 293.11 | 186.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20414 | 20414 | ESP | Spain | LANUZA 1 | WRI1006603 | 52.69 | 42.7238 | -0.2817 | Hydro | 1977.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 | 1016284 | 171.8 | 171.8 | 109.46 | 172.28 | 103.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20203 | 20203 | ESP | Spain | BARRADOS | WRI1006229 | 15.88 | 42.7333 | 0.7167 | Hydro | 1956.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 | 1029322 | 56.11 | 56.12 | 31.41 | 55.67 | 32.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20408 | 20408 | ESP | Spain | LA SARRA | WRI1006594 | 24.0 | 42.7713 | -0.3345 | Hydro | ACCIONA SALTOS DE AGUA 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 | 1016283 | 79.06 | 79.06 | 56.02 | 79.28 | 53.23 | 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 | ||||||||||||
20416 | 20416 | ESP | Spain | LAS ONDINAS GR 1 | WRI1006607 | 82.46000000000001 | 42.8206 | -6.4875 | Hydro | 1966.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 | 1015716 | 245.1 | 242.61 | 100.47 | 252.88 | 94.83 | 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 | ||||||||||||
20821 | 20821 | ESP | Spain | PONT DE REI 1 | WRI1007796 | 46.14 | 42.8384 | 0.739 | Hydro | 1960.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 | 1029328 | 155.65 | 155.41 | 66.61 | 150.41 | 69.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20223 | 20223 | ESP | Spain | C.H. ARNOYA | WRI1006277 | 10.0 | 42.8878 | -8.9567 | Hydro | 2005.0 | HIDROELECTRICA DEL GIESTA SRL | 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 | 1058381 | 32.41 | 32.79 | 20.66 | 32.16 | 15.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20405 | 20405 | ESP | Spain | LA REMOLINA GR 1 | WRI1006591 | 83.19 | 42.9036 | -5.1437 | Hydro | 1990.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 | CARMA | 1015714 | 273.68 | 273.68 | 183.91 | 274.43 | 174.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20142 | 20142 | ESP | Spain | AGUAYO 3 | WRI1006167 | 360.6 | 43.0952 | -4.0004 | Hydro | 1983.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 | 1014379 | 850.45 | 745.62 | 178.6 | 747.66 | 106.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20201 | 20201 | ESP | Spain | BARAZAR 1 | WRI1006226 | 82.7 | 43.1 | -2.75 | Hydro | 1957.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 | 1019084 | 274.01 | 274.01 | 184.76 | 274.76 | 175.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20202 | 20202 | ESP | Spain | BARCENA GR 1 | WRI1006228 | 61.15 | 43.1258 | -4.0566 | Hydro | 1959.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 | 185.2 | 163.9 | 75.48 | 164.35 | 59.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20809 | 20809 | ESP | Spain | PENA DE BEJO | WRI1007734 | 20.8 | 43.1504 | -4.3817 | Hydro | SALTOS DEL NANSA I S.A. UNIPERSONAL | 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 | 1027891 | 61.17 | 68.33 | 35.64 | 63.12 | 31.02 | 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 | ||||||||||||
20462 | 20462 | ESP | Spain | MANDEO-ZARZO | WRI1006666 | 25.6 | 43.2347 | -8.0171 | Hydro | NAVARRO 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 | 1032460 | 81.56 | 81.56 | 57.45 | 81.79 | 54.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
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 | ||||||||||||
20825 | 20825 | ESP | Spain | PROAZA 1 | WRI1007805 | 49.54 | 43.2518 | -6.0163 | Hydro | 1968.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 | CARMA | 1018397 | 150.04 | 150.04 | 61.15 | 160.17 | 60.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20231 | 20231 | ESP | Spain | CAMPORRIONDI | WRI1006297 | 15.2 | 43.3514 | -5.1292 | Hydro | NAVARRO 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 | 1027881 | 51.38 | 51.56 | 29.92 | 51.52 | 22.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20304 | 20304 | ESP | Spain | DOIRAS 1 | WRI1006423 | 61.94 | 43.3891 | -6.8232 | Hydro | 1944.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 | GEODB | 1014386 | 200.38 | 200.6 | 126.23 | 201.15 | 97.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20332 | 20332 | ESP | Spain | EUME GR 1 | WRI1006471 | 54.4 | 43.427 | -8.0671 | Hydro | 1960.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 | 1015713 | 172.5 | 172.5 | 108.13 | 172.97 | 101.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20154 | 20154 | ESP | Spain | ARBON 2 | WRI1006201 | 56.040000000000006 | 43.4486 | -6.7053 | Hydro | 1968.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 | CARMA | 1014381 | 181.29 | 181.49 | 114.2 | 181.99 | 88.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20869 | 20869 | ESP | Spain | SANTIAGO-JARES 2 | WRI1007885 | 53.15 | 43.4949 | -7.2421 | Hydro | 1968.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 | 1019243 | 168.54 | 168.54 | 105.65 | 169.0 | 99.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");