global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
7 rows where generation_data_source = "JRC-PPDB-OPEN", geolocation_source = "GEODB" and owner = "ENDESA GENERACION S.A."
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20159 | 20159 | ESP | Spain | ASCO GR | WRI1006213 | 1990.5 | 41.2008 | 0.5679 | Nuclear | 1983.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1011921 | 15802.182 | 16029.262 | 15241.801 | JRC-PPDB-OPEN | 15902.24 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
20208 | 20208 | ESP | Spain | BESOS GRUPO 5 | WRI1006249 | 1670.81 | 41.4196 | 2.2294 | Gas | 2010.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1031231 | 744.13 | 666.045 | 1360.293 | JRC-PPDB-OPEN | 3960.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
20263 | 20263 | ESP | Spain | COMPOSTILLA II GR 5 | WRI1006393 | 1005.14 | 42.6125 | -6.5647 | Coal | 1984.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1015708 | 4269.858 | JRC-PPDB-OPEN | 4585.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
20270 | 20270 | ESP | Spain | CRISTOBAL COLON | WRI1006404 | 390.94 | 37.2156 | -6.943 | Gas | 2006.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1012783 | 289.949 | 0.0 | 195.981 | JRC-PPDB-OPEN | 926.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
20275 | 20275 | ESP | Spain | CTCC AS PONTES GRUPO 5 | WRI1006410 | 855.67 | 43.4451 | -7.8621 | Gas | 2008.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 178.932 | 484.793 | 1472.945 | JRC-PPDB-OPEN | 2028.21 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
20425 | 20425 | ESP | Spain | LITORAL DE ALMERIA GR 2 | WRI1006625 | 1119.59 | 36.9783 | -1.9054 | Coal | 1997.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 1031229 | 7342.939 | 5068.967 | 6119.552 | JRC-PPDB-OPEN | 5107.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
20867 | 20867 | ESP | Spain | SAN ROQUE GRUPO 2 | WRI1007879 | 791.6800000000001 | 36.1955 | -5.4131 | Gas | 2002.0 | ENDESA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | GEODB | 2693.834 | 2313.036 | 1762.875 | JRC-PPDB-OPEN | 1876.54 | 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");