global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

5 rows where country_long = "Mexico" and primary_fuel = "Geothermal"

View and edit SQL

Suggested facets: source, url

primary_fuel

  • Geothermal · 5

owner

country_long

  • Mexico · 5
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 estimated_generation_gwh
14214 MEX Mexico Cerro Prieto MEX0001868 570.0 32.3916 -115.2252 Geothermal         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 1013029 2016           3784.860557768924
14215 MEX Mexico Cerro Prieto I MEX0006611 30.0 32.3985 -115.2379 Geothermal           CFE http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx North American Cooperation on Energy Information and Comisión Reguladora de Energía   2016           199.20318725099602
14326 MEX Mexico Las Tres Vírgenes MEX0006615 10.0 27.5061 -112.5591 Geothermal           CFE http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx North American Cooperation on Energy Information and Comisión Reguladora de Energía 1045578 2016           66.40106241699867
14330 MEX Mexico Los Azufres MEX0001870 225.0 19.791 -100.6669 Geothermal         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 1013011 2016           1494.0239043824704
14331 MEX Mexico Los Humeros MEX0006617 68.6 19.6465 -97.4375 Geothermal           CFE http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx North American Cooperation on Energy Information and Comisión Reguladora de Energía 1013072 2016           455.5112881806109

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,
  "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");
Powered by Datasette · Query took 60.47ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute