global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
9 rows where estimated_generation_note_2017 = "NO-ESTIMATION", geolocation_source = "Power Africa" and primary_fuel = "Gas"
This data as json, CSV (advanced)
country_long 6
- Equatorial Guinea 2
- Gabon 2
- Madagascar 2
- Cameroon 1
- Malawi 1
- Togo 1
primary_fuel 1
- Gas · 9 ✖
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_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3591 | 3591 | CMR | Cameroon | Kribi | WRI1023033 | 200.0 | 3.01 | 9.96 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | 1065654 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
10059 | 10059 | GNQ | Equatorial Guinea | Bioco Lpg Plant | WRI1023067 | 10.5 | 3.7806 | 8.7196 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | 1042061 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
10061 | 10061 | GNQ | Equatorial Guinea | Malabo | WRI1023069 | 20.0 | 3.75 | 8.79 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | 1056171 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
12453 | 12453 | GAB | Gabon | Owendo | WRI1023073 | 77.0 | 0.3433 | 9.4784 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | 1029146 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
12454 | 12454 | GAB | Gabon | Port-Gentil | WRI1023074 | 68.3 | -0.7539 | 8.7536 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||||
17185 | 17185 | MDG | Madagascar | Tamatave | WRI1023095 | 16.59 | -18.1667 | 49.3833 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||||
17186 | 17186 | MDG | Madagascar | Toliary (Tulear) | WRI1023096 | 12.98 | -23.35 | 43.6667 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | 1020148 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
17188 | 17188 | MWI | Malawi | Chichiri (Blantyre) | WRI1023101 | 15.5 | -15.7833 | 35.0 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||||
21651 | 21651 | TGO | Togo | Tag-Lpo | WRI1023198 | 28.3 | 6.1699 | 1.3496 | Gas | African Development Bank Group | http://powerafrica.opendataforafrica.org | Power Africa | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION |
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");