global-power-plants

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

15 rows where country_long = "Spain" and primary_fuel = "Coal" sorted by rowid

View and edit SQL

Suggested facets: commissioning_year, geolocation_source, wepp_id

primary_fuel

  • Coal · 15

country_long

  • Spain · 15
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
16839 ESP Spain ABONO 2 WRI1006157 877.6600000000002 43.5528 -5.7231 Coal       1985.0 HIDROELECTRICA DEL CANTABRICO 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 1018390             4526.039693464082
16847 ESP Spain ALCUDIA 1 GRUPO N 1 WRI1006172 533.8 39.8106 3.0913 Coal Oil     1981.0 GAS Y ELECTRICIDAD GENERACION S.A.U 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 CARMA 1017458             2752.7744096473875
16856 ESP Spain ANLLARES GR 1 WRI1006197 346.84 42.8385 -6.5332 Coal       1982.0 GAS NATURAL FENOSA GENERACION S.L.U. 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 1017199             1788.6329641103412
16922 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             5183.446365891674
16931 ESP Spain CT GUARDO 2 WRI1006407 485.85 42.8261 -4.8463 Coal       1984.0 IBERDROLA 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 CARMA               2505.499151231142
16932 ESP Spain CT LADA 4 WRI1006408 347.7 43.3082 -5.7001 Coal       1981.0 IBERDROLA 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 WRI               1793.0679322487765
16963 ESP Spain ESCATRON GR 5 WRI1006466 65.0 41.2961 -0.3376 Coal       1990.0 VIESGO GENERACION S.L. 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 CARMA               335.20108023057367
17002 ESP Spain LA ROBLA GRUPO 2 WRI1006593 619.06 42.7924 -5.634 Coal       1984.0 GAS NATURAL FENOSA GENERACION S.L.U. 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 1032447             3192.4550881159835
17020 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             5773.658114082276
17022 ESP Spain LOS BARRIOS WRI1006636 570.05 36.1828 -5.42 Coal       1985.0 VIESGO GENERACION S.L. 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 1012811             2939.7134736221306
17035 ESP Spain MEIRAMA GRUPO 1 WRI1006671 557.2 43.1685 -8.4111 Coal       1980.0 GAS NATURAL FENOSA GENERACION S.L.U. 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 1032462             2873.446798530395
17048 ESP Spain NARCEA GRUPO 3 WRI1006702 553.6400000000001 43.2924 -6.3937 Coal       1984.0 GAS NATURAL FENOSA GENERACION S.L.U. 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 1032469             2855.0880932131518
17380 ESP Spain PUENTE NUEVO GR 3 WRI1007820 299.76 38.1108 -4.9354 Coal       1980.0 VIESGO GENERACION S.L. 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 1015893             1545.844243229489
17418 ESP Spain SOTO RIBERA 3 WRI1007944 346.25 43.3122 -5.8739 Coal       1984.0 HIDROELECTRICA DEL CANTABRICO 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 WRI 1031230             1785.5903696897867
17432 ESP Spain TERUEL GR 3 WRI1023654 1055.77 40.9966 -0.3798 Coal       1980.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 WRI 1015728             5444.542222692812

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 110.856ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute