global-power-plants

Table actions

23 rows where country_long = "Mexico" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, estimated_generation_gwh

primary_fuel 1

  • Oil · 23 ✖

country_long 1

  • Mexico · 23 ✖
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
17282 17282 MEX Mexico Adolfo López Mateos (Tuxpan) MEX0001766 2100.0 21.0151 -97.3334 Oil         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             6015.465528014996
17287 17287 MEX Mexico Altamira MEX0001776 500.0 22.4351 -98.0081 Oil         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 1013008 2016             1432.2536971464276
17304 17304 MEX Mexico Baja California Sur I MEX0001845 162.7 32.6024 -115.6276 Oil         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 1090531 2016             466.0553530514475
17307 17307 MEX Mexico Benito Juárez (Samalayuca) MEX0001818 316.0 31.3314 -106.486 Oil         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 1013137 2016             905.1843365965424
17318 17318 MEX Mexico Cancún MEX0001852 102.0 21.069 -86.8467 Oil         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 1013023 2016             292.17975421787116
17321 17321 MEX Mexico Carlos Rodríguez Rivero (Guaymas II) MEX0001802 484.0 27.937 -110.8628 Oil         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 1013064 2016             1386.4215788377421
17369 17369 MEX Mexico Francisco Pérez Ríos (Tula) MEX0001767 1605.6 20.0545 -99.2764 Oil         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             4599.253072276609
17370 17370 MEX Mexico Francisco Villa MEX0001819 300.0 28.1662 -105.4435 Oil         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 1013058 2016             859.3522182878564
17374 17374 MEX Mexico Gral. Agustín Olachea A. (Puerto San Carlos) MEX0001851 104.1 24.8147 -112.0916 Oil         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 1013113 2016             298.1952197458862
17375 17375 MEX Mexico Guadalupe Victoria (Lerdo) MEX0001815 320.0 25.4943 -103.5704 Oil         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 1013063 2016             916.6423661737136
17428 17428 MEX Mexico José Aceves Pozos (Mazatlán II) MEX0001785 616.0 23.1901 -106.3558 Oil         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             1764.5365548843988
17431 17431 MEX Mexico Juan de Dios Bátiz Paredes (Topolobampo) MEX0001817 320.0 25.6079 -109.0515 Oil         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 1013167 2016             916.6423661737136
17445 17445 MEX Mexico Lerma (Campeche) MEX0001849 112.5 19.7956 -90.6128 Oil         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 1013093 2016             322.2570818579462
17455 17455 MEX Mexico Manuel Álvarez Moreno (Manzanillo) MEX0001770 1300.0 19.0278 -104.3192 Oil         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             3723.859612580712
17466 17466 MEX Mexico Mérida II MEX0001836 168.0 20.927 -89.6878 Oil         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 1013101 2016             481.23724224119974
17498 17498 MEX Mexico Poza Rica MEX0001847 117.0 20.5264 -97.4903 Oil         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 1013124 2016             335.14736513226404
17500 17500 MEX Mexico Presidente Juárez (Rosarito) (Vapor) MEX0001816 320.0 32.3698 -117.0685 Oil         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             916.6423661737136
17506 17506 MEX Mexico Puerto Libertad MEX0001783 632.0 29.9068 -112.693 Oil         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 1013130 2016             1810.3686731930843
17508 17508 MEX Mexico Punta Prieta II MEX0001850 112.5 24.2233 -110.3093 Oil         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 1013131 2016             322.2570818579462
17513 17513 MEX Mexico Salamanca MEX0001786 550.0 20.5694 -101.1712 Oil         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 1013136 2016             1575.4790668610706
17535 17535 MEX Mexico Termoeléctrica Peñoles MEX0001823 290.0 22.0694 -98.8469 Oil         Termoeléctrica Peñoles S. De R. L. De C. V. 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             830.707144344928
17536 17536 MEX Mexico Termoeléctrica del Golfo MEX0001822 290.0 22.0694 -98.8469 Oil         Termoeléctrica Del Golfo S. De R. L. De C. V. 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             830.707144344928
17552 17552 MEX Mexico Villa de Reyes MEX0001780 700.0 21.8322 -100.9344 Oil         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 1013143 2016             2005.1551760049988

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