global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
10 rows where country_long = "Ethiopia", estimated_generation_note_2015 = "HYDRO-V1" and geolocation_source = "GEODB"
This data as json, CSV (advanced)
Suggested facets: latitude, longitude, commissioning_year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10083 | 10083 | ETH | Ethiopia | Awash II | WRI1000055 | 64.0 | 8.3932 | 39.352 | Hydro | 1996.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 268.69 | 230.92 | 266.65 | 270.69 | 273.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
10084 | 10084 | ETH | Ethiopia | Beles | WRI1000056 | 460.0 | 11.8196 | 36.9181 | Hydro | 2010.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1044157 | 1717.51 | 1157.2 | 1717.51 | 1617.94 | 1451.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10085 | 10085 | ETH | Ethiopia | Fincha | WRI1000057 | 134.0 | 9.558 | 37.3663 | Hydro | 1973.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1016741 | 513.67 | 401.99 | 513.67 | 526.17 | 534.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10086 | 10086 | ETH | Ethiopia | Fincha Amerti Nesha | WRI1000058 | 100.0 | 9.558 | 37.3663 | Hydro | 2011.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1067845 | 412.33 | 347.53 | 411.47 | 422.72 | 445.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10087 | 10087 | ETH | Ethiopia | Gilgel Gibe I | WRI1000059 | 184.0 | 7.8349 | 37.3236 | Hydro | 2004.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1016742 | 721.73 | 569.18 | 722.79 | 724.77 | 695.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10088 | 10088 | ETH | Ethiopia | Gilgel Gibe II | WRI1000060 | 420.0 | 7.7571 | 37.5624 | Hydro | 2010.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1062538 | 1629.31 | 1382.99 | 1624.37 | 1633.77 | 1508.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10090 | 10090 | ETH | Ethiopia | Koka | WRI1000061 | 43.2 | 8.4684 | 39.1588 | Hydro | 1960.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1016746 | 182.54 | 155.5 | 179.99 | 183.29 | 184.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10091 | 10091 | ETH | Ethiopia | Melka Wekana | WRI1000062 | 153.0 | 7.1761 | 39.4311 | Hydro | 1983.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1016744 | 608.25 | 471.26 | 618.05 | 611.6 | 576.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10092 | 10092 | ETH | Ethiopia | Tekeze | WRI1000063 | 300.0 | 13.3492 | 38.7405 | Hydro | 2009.0 | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1042646 | 1233.05 | 1057.39 | 1215.25 | 1224.18 | 1146.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10093 | 10093 | ETH | Ethiopia | Tis Abay I | WRI1000064 | 84.4 | 11.4887 | 37.5999 | Hydro | Africa Hydropower Resources Database | http://afrec-energy.org/En/administration/hydro/index.php | GEODB | 1016749 | 374.81 | 351.88 | 425.65 | 397.95 | 374.07 | 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");