global-power-plants

Table actions

12 rows where country_long = "Madagascar"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, url, geolocation_source

primary_fuel 5

country_long 1

  • Madagascar · 12 ✖
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
17176 17176 MDG Madagascar Ambatolampy WKS0072179 25.0 -19.489 47.445 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                  
17177 17177 MDG Madagascar Ambatovy WRI1023098 120.0 -18.8356 48.3125 Coal           African Development Bank Group http://powerafrica.opendataforafrica.org WRI 1076480                
17178 17178 MDG Madagascar Ambohimanambola WRI1023092 19.71 -19.8 46.6167 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1020142                
17179 17179 MDG Madagascar Andekaleka WRI1023093 58.0 -18.7942 48.6193 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1020143                
17180 17180 MDG Madagascar Antelomita WRI1023097 8.9 -19.0119 47.7033 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1020144                
17181 17181 MDG Madagascar La Mandraka WRI1023094 24.0 -18.9213 47.9295 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1020146                
17182 17182 MDG Madagascar Majunga WRI1023100 13.0 -15.702 46.4027 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                  
17183 17183 MDG Madagascar Mandroseza WRI1023099 40.0 -18.8491 47.4807 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1067276                
17184 17184 MDG Madagascar Sahanivotry WRI1026779 16.5 -20.2003 47.1328 Hydro         HYDELEC Madagascar SA CDM https://cdm.unfccc.int/Projects/DB/TUEV-SUED1269612670.69/view Power Africa 1076389                
17185 17185 MDG Madagascar Tamatave WRI1023095 16.59 -18.1667 49.3833 Gas           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                  
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                
17187 17187 MDG Madagascar Tsiazompaniry WRI1026780 5.25 -19.2478 47.8339 Hydro         HENRI FRAISE FILS & CIE CDM https://cdm.unfccc.int/Projects/DB/RINA1323809385.82/view Power Africa 1076410                

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