global-power-plants

Table actions

11 rows where country_long = "Ethiopia" and primary_fuel = "Hydro"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latitude, longitude, commissioning_year, source, url, geolocation_source

primary_fuel 1

  • Hydro · 11 ✖

country_long 1

  • Ethiopia · 11 ✖

owner 0

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_data_source estimated_generation_gwh
10082 10082 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                 154.35136127576985
10083 10083 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               1109.4004091695956
10084 10084 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               323.17316267114313
10085 10085 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               241.1740019933904
10086 10086 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               443.7601636678383
10087 10087 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               1012.9308083722394
10088 10088 ETH Ethiopia Gilgel Gibe III WRI1022986 1870.0 6.8482 37.3018 Hydro       2015.0   Hydro World http://www.hydroworld.com/articles/2015/10/power-generation-begins-at-1-870-mw-gibe-iii-hydroelectric-project-in-ethiopia.html WRI 1066600               4509.9538372764
10089 10089 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               104.18716886114464
10090 10090 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               368.99622304988725
10091 10091 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               723.522005980171
10092 10092 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               203.55085768242145

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");