global-power-plants

Table actions

25 rows where country_long = "Colombia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, url, geolocation_source, estimated_generation_gwh

primary_fuel 5

country_long 1

  • Colombia · 25 ✖
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
9309 9309 COL Colombia Calderas WRI1018560 26.0 7.7918 -74.7732 Hydro         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf CARMA 1019703               193.08903495667764
9310 9310 COL Colombia Cantral La Tasajera WRI1018561 306.0 6.3771 -75.4478 Hydro         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf CARMA 1015822               2272.5094114132057
9311 9311 COL Colombia Cartagena WRI1018562 188.0 10.3555 -75.5109 Oil         ENDESA ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1031234               165.0
9312 9312 COL Colombia Central Guadalupe III WRI1018564 270.0 6.8145 -75.2406 Hydro         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf CARMA 1086333               2005.1553630116525
9313 9313 COL Colombia Central Guatapé WRI1018565 560.0 6.32 -75.1659 Hydro         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf WRI 1015819               4158.840752913056
9314 9314 COL Colombia Chivor WRI1018566 1000.0 4.9008 -73.2969 Hydro         AES Chivor ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1012225               7426.501344487601
9315 9315 COL Colombia El Paso WKS0071873 86.2 9.69 -73.765 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
9316 9316 COL Colombia Gavio WRI1018568 1200.0 4.7247 -73.4831 Hydro         Emgesa ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf WRI 1016262               8911.801613385122
9317 9317 COL Colombia Gecelca power station WRI1075561 164.0 7.9911 -75.5946 Coal       2016.0 Gecelca SAESP GCPT https://endcoal.org/global-coal-plant-tracker/ GCPT                 840.1320890165109
9318 9318 COL Colombia Jaguas WRI1018571 170.0 6.2944 -75.0259 Hydro         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf CARMA 1019705               1262.5052285628924
9319 9319 COL Colombia La Sierra WRI1018572 460.0 6.2345 -74.5614 Gas         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf WRI 1015821               1928.8288288288288
9320 9320 COL Colombia Miel I WRI1018573 396.0 5.5606 -74.8866 Hydro         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1018414               2940.89453241709
9321 9321 COL Colombia Porce III WRI1018575 660.0 6.9394 -75.1398 Hydro         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1057556               4901.490887361817
9322 9322 COL Colombia San Carlos WRI1018576 1246.0 6.2108 -74.8405 Hydro         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1019706               9253.420675231551
9323 9323 COL Colombia Sogamoso WRI1018578 820.0 7.1003 -73.4056 Hydro         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf WRI 1046483               6089.731102479833
9324 9324 COL Colombia Termobarranquilla WRI1018580 918.0 10.9368 -74.7643 Gas         TEBSA ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1031129               3849.2714453584017
9325 9325 COL Colombia Termocentro WRI1018582 300.0 6.4656 -74.3912 Gas         Isagen S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1019708               1257.9318448883666
9326 9326 COL Colombia Termoflores WRI1018583 670.0 11.0253 -74.8112 Gas         Termoflores S.A.E.S.P ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf WRI 1013260               2809.381120250685
9327 9327 COL Colombia Termoguajira power station WRI1075562 330.0 11.2622 -73.4156 Coal       1985.0 Gecelca SAESP GCPT https://endcoal.org/global-coal-plant-tracker/ GCPT                 1690.5096913137115
9328 9328 COL Colombia Termopaipa power station WRI1018584 346.0 5.7682 -73.1472 Coal       1987.0 Empresa de Energía de Boyacá GCPT https://endcoal.org/global-coal-plant-tracker/ GEODB 1015340               1772.4737975592247
9329 9329 COL Colombia Termotasajero power station WRI1018579 323.0 7.8473 -72.6328 Coal       2000.0 Termotasajero SAESP GCPT https://endcoal.org/global-coal-plant-tracker/ GCPT 1013344               1654.650394831299
9330 9330 COL Colombia Termovalle WRI1018585 205.0 3.5649 -76.4532 Gas         Termovalle S.A. ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf GEODB 1020974               859.5867606737172
9331 9331 COL Colombia Termozipa Corral power station WRI1018588 230.0 4.9708 -73.9473 Coal       1975.0 Emgesa SAESP GCPT https://endcoal.org/global-coal-plant-tracker/ GCPT 1016268               1178.2340272792533
9332 9332 COL Colombia Troneras Central WRI1018587 40.0 6.7244 -75.2817 Hydro         EPM ProColombia http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf CARMA 1015830               297.06005377950413
9333 9333 COL Colombia Yumbo WKS0069542 9.8 3.553 -76.498 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0

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