global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
122 rows where country_long = "Portugal" and primary_fuel = "Hydro" sorted by generation_data_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19031 | 19031 | PRT | Portugal | Talhadas | WRI1022801 | 5.2 | 40.647 | -8.3177 | Hydro | 1992.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1017614 | 11.43 | 11.43 | 8.98 | 13.9 | 8.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19034 | 19034 | PRT | Portugal | Teixo | WRI1022804 | 7.0 | 40.5763 | -8.2807 | Hydro | 2008.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1073881 | 15.75 | 15.75 | 11.29 | 19.08 | 11.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19048 | 19048 | PRT | Portugal | Terragido | WRI1022805 | 8.5 | 41.2872 | -7.7495 | Hydro | 1992.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1016496 | 22.23 | 22.23 | 16.81 | 26.27 | 16.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19054 | 19054 | PRT | Portugal | Torga | WRI1022806 | 8.5 | 41.7061 | -7.1175 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1016497 | 22.93 | 28.57 | 13.84 | 29.85 | 14.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19056 | 19056 | PRT | Portugal | Touvedo | WRI1022573 | 22.0 | 41.8126 | -8.3538 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012753 | 71.6 | 69.64 | 41.89 | 77.01 | 40.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19061 | 19061 | PRT | Portugal | Trutas | WRI1022807 | 2.2 | 41.8478 | -6.9361 | Hydro | 2009.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 6.12 | 6.12 | 5.4 | 7.17 | 5.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
19062 | 19062 | PRT | Portugal | Túneis | WRI1022808 | 1.7 | 37.7465 | -25.3072 | Hydro | 1951.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1046026 | 1.38 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19063 | 19063 | PRT | Portugal | Ucanha | WRI1022809 | 5.7 | 41.054 | -7.7462 | Hydro | 2001.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1113352 | 12.53 | 12.53 | 9.84 | 15.23 | 9.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19066 | 19066 | PRT | Portugal | Vale Soeiro | WRI1022813 | 4.4 | 40.8988 | -7.9438 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1017615 | 14.54 | 14.59 | 9.21 | 18.43 | 9.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19069 | 19069 | PRT | Portugal | Vale de Madeira | WRI1022811 | 1.35 | 40.7981 | -7.0148 | Hydro | 2008.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1104813 | 5.34 | 5.1 | 3.32 | 6.06 | 3.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19071 | 19071 | PRT | Portugal | Vale do Gaio | WRI1022812 | 1.0 | 38.2478 | -8.2951 | Hydro | 1949.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012755 | 3.4 | 3.3 | 2.82 | 3.14 | 2.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19072 | 19072 | PRT | Portugal | Vales | WRI1022814 | 3.2 | 41.4419 | -7.4985 | Hydro | 2009.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1069306 | 7.17 | 7.17 | 5.78 | 8.69 | 5.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19075 | 19075 | PRT | Portugal | Varosa | WRI1022570 | 25.0 | 41.1208 | -7.7761 | Hydro | 1934.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1062702 | 69.69 | 69.69 | 55.44 | 82.12 | 55.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19076 | 19076 | PRT | Portugal | Velada | WRI1022816 | 1.9 | 39.5914 | -7.7092 | Hydro | 1935.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012757 | 7.63 | 7.6 | 4.84 | 7.76 | 4.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19077 | 19077 | PRT | Portugal | Venda Nova | WRI1022560 | 90.0 | 41.6794 | -7.9823 | Hydro | 1951.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012759 | 252.15 | 252.15 | 188.51 | 296.9 | 188.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19082 | 19082 | PRT | Portugal | Vila Cova | WRI1022578 | 23.4 | 40.3797 | -7.7283 | Hydro | 2001.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012758 | 66.7 | 65.98 | 29.07 | 79.37 | 20.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19088 | 19088 | PRT | Portugal | Vila Viçosa | WRI1022817 | 4.0 | 40.9952 | -8.2106 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1052638 | 13.42 | 13.74 | 10.55 | 15.43 | 10.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19091 | 19091 | PRT | Portugal | Vilar-Tabuaço | WRI1022563 | 58.0 | 40.9869 | -7.5358 | Hydro | 1965.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012749 | 160.8 | 160.8 | 113.75 | 189.64 | 113.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19095 | 19095 | PRT | Portugal | Águas Frias | WRI1022660 | 2.4 | 40.8094 | -8.0508 | Hydro | 2002.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 6.68 | 6.68 | 5.89 | 7.82 | 5.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
18641 | 18641 | PRT | Portugal | Alto Lindoso | WRI1023233 | 630.0 | 41.8693 | -8.2029 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show?name=&defaultValue=true&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime=01.01.2016+00:00|UTC|YEAR&area.values=CTY|10YPT-REN------W!BZN|10YPT-REN------W&productionType.values=B01&productionType.values=B02&productionType.values=B03&productionType.values=B04&productionType.values=B05&productionType.values=B06&productionType.values=B07&productionType.values=B08&productionType.values=B09&productionType.values=B10&productionType.values=B11&productionType.values=B12&productionType.values=B13&productionType.values=B14&productionType.values=B20&productionType.values=B15&productionType.values=B16&productionType.values=B17&productionType.values=B18&productionType.values=B19&DataTables_Table_0_length=50# | WRI | 1012695 | 430.781 | 1113.961 | 335.16 | JRC-PPDB-OPEN | 1528.38 | 1464.82 | 840.32 | 1990.69 | 1198.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
18790 | 18790 | PRT | Portugal | Frades II | WRI1023232 | 780.0 | 41.6934 | -8.0279 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show?name=&defaultValue=true&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime=01.01.2016+00:00|UTC|YEAR&area.values=CTY|10YPT-REN------W!BZN|10YPT-REN------W&productionType.values=B01&productionType.values=B02&productionType.values=B03&productionType.values=B04&productionType.values=B05&productionType.values=B06&productionType.values=B07&productionType.values=B08&productionType.values=B09&productionType.values=B10&productionType.values=B11&productionType.values=B12&productionType.values=B13&productionType.values=B14&productionType.values=B20&productionType.values=B15&productionType.values=B16&productionType.values=B17&productionType.values=B18&productionType.values=B19&DataTables_Table_0_length=50# | WRI | 440.808 | 701.525 | 207.466 | JRC-PPDB-OPEN | 2230.55 | 2230.55 | 1579.52 | 3000.22 | 1579.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
18961 | 18961 | PRT | Portugal | Salamonde | WRI1022566 | 42.0 | 41.6917 | -8.0912 | Hydro | 1953.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012744 | 448.115 | 187.526 | JRC-PPDB-OPEN | 112.67 | 112.67 | 88.05 | 133.55 | 88.05 | 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");