global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
21 rows where primary_fuel = "Coal" and year_of_capacity_data = 2016 sorted by estimated_generation_note_2014
This data as json, CSV (advanced)
Suggested facets: other_fuel1, estimated_generation_gwh_2017
owner 14
- CFE 3
- E-CL 3
- Saskatchewan Power Corp 3
- AES GENER S.A. 2
- AES GENER 1
- ANGAMOS 1
- CELTA 1
- CGI IANSA 1
- COLBUN S.A. 1
- ELECTRICA VENTANAS 1
- EMPRESA ELECTRICA CAMPICHE S.A. 1
- ENDESA 1
- HORNITOS 1
- Maxim Power Corp 1
primary_fuel 1
- Coal · 21 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3701 | 3701 | CAN | Canada | Boundary Dam | CAN0002027 | 672.0 | 49.0961 | -103.0305 | Coal | Saskatchewan Power Corp | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 32137 | 2016 | 4431.71 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
3998 | 3998 | CAN | Canada | H R Milner | CAN0002052 | 150.0 | 54.0071 | -119.1032 | Coal | Maxim Power Corp | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 12752 | 2016 | 989.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4372 | 4372 | CAN | Canada | Poplar River | CAN0002079 | 582.0 | 49.0579 | -105.4851 | Coal | Saskatchewan Power Corp | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 32153 | 2016 | 3838.18 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4505 | 4505 | CAN | Canada | Shand | CAN0002084 | 276.0 | 49.0751 | -102.8641 | Coal | Saskatchewan Power Corp | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 32155 | 2016 | 1820.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4779 | 4779 | CHL | Chile | BOCAMINA (I-II) | CHL0000057 | 478.0 | -37.0215 | -73.1673 | Coal | ENDESA | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015737 | 2016 | 2637.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4787 | 4787 | CHL | Chile | CAMPICHE | CHL0000108 | 248.9888 | -32.7483 | -71.4833 | Coal | EMPRESA ELECTRICA CAMPICHE S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1076551 | 2016 | 1373.67 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4841 | 4841 | CHL | Chile | DIESEL IQUIQUE(MSIQ_TGIQ) | CHL0000019 | 43.0 | -20.258 | -70.1273 | Coal | Oil | E-CL | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015641 | 2016 | 237.23 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
4875 | 4875 | CHL | Chile | GUACOLDA | CHL0000053 | 760.0 | -28.4673 | -71.2573 | Coal | Petcoke | AES GENER S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015665 | 2016 | 4192.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
4963 | 4963 | CHL | Chile | NUEVA VENTANAS | CHL0000118 | 248.9888 | -32.7498 | -71.4832 | Coal | ELECTRICA VENTANAS | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 2016 | 1373.67 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
4977 | 4977 | CHL | Chile | PLANTA CURICO | CHL0000099 | 2.0 | -35.0207 | -71.2436 | Coal | CGI IANSA | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1062499 | 2016 | 11.03 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5025 | 5025 | CHL | Chile | SANTA MARIA | CHL0000070 | 341.991 | -37.042 | -73.13 | Coal | COLBUN S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1067138 | 2016 | 1886.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5051 | 5051 | CHL | Chile | TERMOELECTRICA ANGAMOS 1(ANG1)_ 2(ANG2) | CHL0000013 | 488.3 | -23.0677 | -70.369 | Coal | ANGAMOS | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1067681 | 2016 | 2693.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5052 | 5052 | CHL | Chile | TERMOELECTRICA HORNITOS (CTH) | CHL0000014 | 153.9 | -32.9006 | -70.2633 | Coal | HORNITOS | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 2016 | 849.06 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5053 | 5053 | CHL | Chile | TERMOELECTRICA MEJILLONES (CTM1) | CHL0000015 | 318.9 | -23.0854 | -70.41 | Coal | Petcoke | E-CL | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015642 | 2016 | 1759.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5054 | 5054 | CHL | Chile | TERMOELECTRICA NORGENER (NTO2) | CHL0000016 | 259.3 | -22.097 | -70.2109 | Coal | Petcoke | AES GENER | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1024261 | 2016 | 1430.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5055 | 5055 | CHL | Chile | TERMOELECTRICA TARAPACA | CHL0000018 | 172.2 | -20.8057 | -70.1928 | Coal | Oil | CELTA | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1057680 | 2016 | 950.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5056 | 5056 | CHL | Chile | TERMOELECTRICA TOCOPILLA (U12) | CHL0000017 | 1001.7 | -22.091 | -70.2126 | Coal | Petcoke | E-CL | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015364 | 2016 | 5526.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5070 | 5070 | CHL | Chile | VENTANAS | CHL0000126 | 322.0 | -32.7493 | -71.4812 | Coal | AES GENER S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1012192 | 2016 | 1776.47 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
17319 | 17319 | MEX | Mexico | Carbón II | MEX0001768 | 1400.0 | 28.4682 | -100.7003 | Coal | CFE | CFE-CENACE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsAllGE100MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013024 | 2016 | 7955.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
17430 | 17430 | MEX | Mexico | José López Portillo (Río Escondido) | MEX0001771 | 1200.0 | 28.4844 | -100.6897 | Coal | CFE | CFE-CENACE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsAllGE100MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 2016 | 6818.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
17494 | 17494 | MEX | Mexico | Plutarco Elías Calles (Petacalco) | MEX0001765 | 2778.4 | 17.9837 | -102.1154 | Coal | CFE | CFE-CENACE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsAllGE100MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013119 | 2016 | 15787.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 |
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");