global-power-plants

Table actions

13 rows where country_long = "Nigeria"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, source, url, geolocation_source, estimated_generation_gwh

primary_fuel 3

country_long 1

  • Nigeria · 13 ✖
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
17823 17823 NGA Nigeria Alaoji WRI1000030 1074.0 5.067 7.3216 Gas           Nidel Power https://web.archive.org/web/20131103224412/http:/www.nidelpower.com/main/alaoji GEODB 1064776               6183.277241379312
17824 17824 NGA Nigeria Calabar WRI1000025 561.0 5.0702 8.3394 Gas         Calabar Generation Company Nidel Power https://web.archive.org/web/20131103224627/http:/www.nidelpower.com/main/calabar WRI 1064808               3229.812413793104
17825 17825 NGA Nigeria Gbarain WRI1000027 225.0 4.798 5.897 Gas         Gbarain Generation Company Nidel Power https://web.archive.org/web/20131002035726/http:/www.nidelpower.com/main/gbarain GEODB                 1295.3793103448277
17826 17826 NGA Nigeria Ibadan WKS0068714 10.0 7.455 3.885 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
17827 17827 NGA Nigeria Ibom Power WRI1000034 190.0 4.5644 7.568 Gas           Nidel Power https://web.archive.org/web/20131002035947/http:/www.nidelpower.com/main/geregu GEODB 1053623|1063059               1093.8758620689657
17828 17828 NGA Nigeria Ihovbor WRI1000026 450.0 6.4065 5.6828 Gas           Nidel Power https://web.archive.org/web/20131103223838/http:/www.nidelpower.com/main/ihovbor GEODB 1064809               2590.7586206896553
17829 17829 NGA Nigeria Jebba WRI1000037 540.0 9.138 4.7883 Hydro         Government of Nigeria Sarafinchin http://www.sarafinchin.com/index.php/projects/africa/kainji-and-jebba-dams-niger-river-nigeria/ GEODB 1023941               1519.3894736842105
17830 17830 NGA Nigeria Kainji WRI1000036 760.0 9.8641 4.6124 Hydro         Government of Nigeria Sarafinchin http://www.sarafinchin.com/index.php/projects/africa/kainji-and-jebba-dams-niger-river-nigeria/ GEODB 1023942               2138.4
17831 17831 NGA Nigeria Olorunsogo II WRI1000031 750.0 6.8982 3.2041 Gas           Nidel Power https://web.archive.org/web/20131103224542/http:/www.nidelpower.com/main/olorunsogo WRI 1041400               4317.931034482759
17832 17832 NGA Nigeria Omoku WRI1000029 150.0 5.39 6.6632 Gas         Sahara Power Sahara Power http://www.sahara-group.com/sahara-power-acquires-additional-power-generation-assets.html GEODB 1064790               863.5862068965519
17833 17833 NGA Nigeria Omotosho II WRI1000032 500.0 6.7357 4.7106 Gas           Nidel Power https://web.archive.org/web/20131103224542/http:/www.nidelpower.com/main/olorunsogo GEODB 1088448               2878.6206896551726
17834 17834 NGA Nigeria Sapele WRI1000028 450.0 5.9254 5.645 Gas         Ihovbor Generating Company Nidel Power https://web.archive.org/web/20131103223738/http:/www.nidelpower.com/main/sapele GEODB 1088447               2590.7586206896553
17835 17835 NGA Nigeria Shiroro WRI1000035 600.0 9.9724 6.8353 Hydro         Government of Nigeria Sarafinchin http://www.sarafinchin.com/index.php/projects/africa/kainji-and-jebba-dams-niger-river-nigeria/ GEODB 1023945               1688.2105263157896

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");