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 wepp_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18915 | 18915 | PRT | Portugal | Pereira | WRI1022763 | 5.2 | 40.9199 | -7.9648 | Hydro | 2006.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1073883 | 16.92 | 16.98 | 10.26 | 21.45 | 10.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18927 | 18927 | PRT | Portugal | Ponte do Bico | WRI1022768 | 2.2 | 41.6062 | -8.4271 | Hydro | 1994.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080266 | 7.75 | 7.96 | 6.22 | 9.53 | 6.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18716 | 18716 | PRT | Portugal | Caneiro | WRI1022687 | 1.6 | 41.3728 | -8.3444 | Hydro | 2002.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080269 | 4.82 | 4.71 | 4.78 | 5.81 | 4.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18757 | 18757 | PRT | Portugal | Corvete | WRI1022698 | 2.4 | 41.3965 | -8.1793 | Hydro | 1972.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080272 | 9.33 | 9.42 | 6.78 | 10.63 | 6.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18661 | 18661 | PRT | Portugal | Amieiro/Galego | WRI1022665 | 1.2 | 41.3736 | -8.4142 | Hydro | 2004.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080273 | 3.59 | 3.69 | 3.22 | 4.03 | 3.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18668 | 18668 | PRT | Portugal | Assobio | WRI1022670 | 1.0 | 41.125 | -7.9475 | Hydro | 2004.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080378 | 3.53 | 3.75 | 2.76 | 3.9 | 2.61 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18912 | 18912 | PRT | Portugal | Penhas Altas | WRI1022761 | 1.6 | 41.231 | -8.4136 | Hydro | 1998.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080379 | 4.51 | 4.51 | 3.89 | 5.27 | 3.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18980 | 18980 | PRT | Portugal | Senhora do Salto | WRI1022795 | 3.8 | 41.1274 | -8.4324 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080380 | 13.94 | 13.35 | 8.03 | 15.84 | 7.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18863 | 18863 | PRT | Portugal | Mesa do Galo I | WRI1022735 | 1.6 | 41.6587 | -7.9797 | Hydro | 1996.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080747 | 4.51 | 4.51 | 3.89 | 5.27 | 3.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18698 | 18698 | PRT | Portugal | Bugalheira | WRI1022679 | 1.4 | 37.5497 | -8.7131 | Hydro | 1991.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1080825 | 3.08 | 3.31 | 2.46 | 3.99 | 2.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18956 | 18956 | PRT | Portugal | Roxo | WRI1022785 | 1.7 | 37.9303 | -8.0812 | Hydro | 2010.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088851 | 4.58 | 4.6 | 3.9 | 5.41 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18656 | 18656 | PRT | Portugal | Alvito | WRI1022664 | 3.4 | 38.2788 | -7.9093 | Hydro | 2010.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088859 | 8.11 | 8.11 | 6.63 | 9.72 | 6.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18882 | 18882 | PRT | Portugal | Odivelas | WRI1022747 | 2.5 | 38.1852 | -8.1153 | Hydro | 2010.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088860 | 6.96 | 6.96 | 6.13 | 8.15 | 6.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18813 | 18813 | PRT | Portugal | Janeiro de Cima | WRI1022725 | 7.9 | 40.0655 | -7.8055 | Hydro | 1995.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088901 | 26.54 | 26.13 | 14.93 | 30.45 | 14.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18803 | 18803 | PRT | Portugal | Granja do Tedo | WRI1022718 | 2.2 | 41.0642 | -7.6148 | Hydro | 2008.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088909 | 7.8 | 8.03 | 5.46 | 9.2 | 4.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18934 | 18934 | PRT | Portugal | Prado Novo | WRI1022773 | 2.9 | 41.902 | -6.7389 | Hydro | 1996.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088911 | 8.07 | 8.07 | 7.12 | 9.45 | 7.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18779 | 18779 | PRT | Portugal | Feiticeiro (Baixo Sabor - Jusante) | WRI1022569 | 36.0 | 41.202 | -7.0936 | Hydro | 2015.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1090326 | 105.54 | 110.12 | 49.21 | 130.08 | 57.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18633 | 18633 | PRT | Portugal | Agilde | WRI1022659 | 2.0 | 41.3545 | -8.1028 | Hydro | 2012.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1094696 | 7.18 | 7.69 | 6.04 | 8.22 | 6.01 | 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 | |||||||||||||
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 | |||||||||||||
18774 | 18774 | PRT | Portugal | Fagilde | WRI1022707 | 2.4 | 40.6292 | -7.8255 | Hydro | 1998.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1113356 | 8.77 | 8.79 | 5.91 | 10.04 | 5.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18870 | 18870 | PRT | Portugal | Montezinho | WRI1022741 | 1.4 | 41.9376 | -6.7752 | Hydro | 1996.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1113761 | 3.18 | 3.18 | 2.69 | 3.84 | 2.69 | 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");