global-power-plants

Table actions

10 rows where country_long = "Sudan" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: longitude

primary_fuel 1

  • Oil · 10 ✖

country_long 1

  • Sudan · 10 ✖

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
21013 21013 SDN Sudan Atbara WRI1023168 15.1 17.7 34.0 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1023372               45.740130365268726
21015 21015 SDN Sudan El Obeid WRI1023170 14.3 13.1833 30.2167 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1023371               43.316812200221385
21018 21018 SDN Sudan Kenana WRI1023172 50.0 14.0333 33.1667 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 151.4573853154593
21019 21019 SDN Sudan Khartoum North WRI1023173 351.0 15.65 32.563 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 1063.2308449145246
21021 21021 SDN Sudan Kilo-X Dit WRI1023175 260.0 15.5881 32.5342 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1053103               787.5784036403885
21022 21022 SDN Sudan Kilo-X Nec WRI1023176 33.5 15.6482 32.563 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 101.47644816135777
21023 21023 SDN Sudan Kuku WRI1023177 23.0 5.8864 31.6856 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 69.67039724511129
21026 21026 SDN Sudan Nyala WRI1023180 15.5 12.05 24.8833 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1023380               46.951789447792386
21027 21027 SDN Sudan Port Sudan WRI1023181 38.1 19.6158 37.2164 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1023381               115.41052761038004
21028 21028 SDN Sudan Rahad WRI1023182 12.6 12.7167 30.65 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 38.16726109949576

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