global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where estimated_generation_note_2016 = "HYDRO-V1", owner = "CFE" and year_of_capacity_data = 2016
This data as json, CSV (advanced)
Suggested facets: capacity_mw, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17284 | 17284 | MEX | Mexico | Aguamilpa Solidaridad | MEX0001856 | 960.0 | 21.8395 | -104.8038 | Hydro | 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 | 1013007 | 2016 | 3528.04 | 2896.52 | 2882.21 | 2889.2 | 2881.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17286 | 17286 | MEX | Mexico | Alfredo Elías Ayub (La Yesca) | MEX0001859 | 750.0 | 21.1979 | -104.1047 | Hydro | 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 | 1066717 | 2016 | 2765.42 | 2243.9 | 2260.87 | 2189.86 | 2170.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17306 | 17306 | MEX | Mexico | Belisario Domínguez (Angostura) | MEX0001857 | 900.0 | 16.4018 | -92.7784 | Hydro | 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 | 1013012 | 2016 | 4145.44 | 3279.12 | 3628.54 | 3609.28 | 3539.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17320 | 17320 | MEX | Mexico | Carlos Ramírez Ulloa (El Caracol) | MEX0001860 | 600.0 | 17.9505 | -99.9943 | Hydro | 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 | 1013132 | 2016 | 2003.97 | 1780.86 | 1600.33 | 1655.85 | 1629.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17367 | 17367 | MEX | Mexico | Fernando Hiriart Balderrama (Zimapán) | MEX0001865 | 292.0 | 20.8468 | -99.4584 | Hydro | 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 | 1013178 | 2016 | 1042.91 | 1054.35 | 968.68 | 1012.44 | 703.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17390 | 17390 | MEX | Mexico | Infiernillo | MEX0001854 | 1200.0 | 18.2711 | -101.8939 | Hydro | 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 | 1013074 | 2016 | 4546.63 | 3757.23 | 3781.7 | 3749.58 | 3436.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17439 | 17439 | MEX | Mexico | La Villita | MEX0001864 | 320.0 | 18.0457 | -102.1825 | Hydro | 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 | 1013174 | 2016 | 944.16 | 959.98 | 871.2 | 862.26 | 783.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17444 | 17444 | MEX | Mexico | Leonardo Rodríguez Alcaine (El Cajón) | MEX0001858 | 750.0 | 21.4279 | -104.4507 | Hydro | 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 | 1053379 | 2016 | 2765.42 | 2243.9 | 2260.87 | 2267.06 | 2223.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17450 | 17450 | MEX | Mexico | Luis Donaldo Colosio (Huites) | MEX0001861 | 422.0 | 26.8444 | -108.3687 | Hydro | 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 | 1013038 | 2016 | 1253.99 | 1346.88 | 1297.36 | 1119.54 | 1093.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17452 | 17452 | MEX | Mexico | Malpaso | MEX0001855 | 1080.0 | 17.1806 | -93.5973 | Hydro | 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 | 1013097 | 2016 | 4879.14 | 3827.71 | 4247.97 | 4259.61 | 4152.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17454 | 17454 | MEX | Mexico | Manuel Moreno Torres (Chicoasén) | MEX0001853 | 2400.0 | 16.9428 | -93.1012 | Hydro | 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 | 1013106 | 2016 | 11500.45 | 9090.78 | 10497.19 | 10525.95 | 9885.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17458 | 17458 | MEX | Mexico | Mazatepec | MEX0001869 | 220.0 | 20.0144 | -97.4062 | Hydro | 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 | 1013100 | 2016 | 644.73 | 627.45 | 522.19 | 533.54 | 510.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17469 | 17469 | MEX | Mexico | Necaxa | MEX0001873 | 109.0 | 20.2171 | -97.9872 | Hydro | 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 | 1012628 | 2016 | 359.79 | 343.25 | 292.15 | 332.96 | 299.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17493 | 17493 | MEX | Mexico | Plutarco Elías Calles (El Novillo) | MEX0001872 | 135.0 | 28.978 | -109.642 | Hydro | 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 | 1013121 | 2016 | 459.99 | 475.37 | 497.07 | 383.88 | 381.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17509 | 17509 | MEX | Mexico | Raúl J. Marsal (Comedero) | MEX0001880 | 100.0 | 24.5707 | -106.8084 | Hydro | 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 | 1013133 | 2016 | 333.27 | 345.44 | 310.54 | 292.61 | 281.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17532 | 17532 | MEX | Mexico | Temascal | MEX0001863 | 354.0 | 18.2324 | -96.4115 | Hydro | 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 | 1013157 | 2016 | 1234.1 | 1040.03 | 930.4 | 939.47 | 990.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17548 | 17548 | MEX | Mexico | Valentín Gómez Farías (Agua Prieta) | MEX0001867 | 240.0 | 20.7008 | -103.245 | Hydro | 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 | 1013006 | 2016 | 799.76 | 824.76 | 736.57 | 750.49 | 736.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17558 | 17558 | MEX | Mexico | Ángel Albino Corzo (Peñitas) | MEX0001862 | 420.0 | 17.4463 | -93.4628 | Hydro | 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 | 1607.96 | 1496.13 | 1534.47 | 1538.68 | 1497.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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");