global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

15 rows where country_long = "Spain" and owner = "IBERDROLA E.RENOV. CASTILLA LA MANCHA" sorted by other_fuel3

View and edit SQL

Suggested facets: capacity_mw, latitude, longitude, geolocation_source, estimated_generation_gwh

primary_fuel

owner

  • IBERDROLA E.RENOV. CASTILLA LA MANCHA · 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 generation_data_source estimated_generation_gwh
20521 ESP Spain P. E. CALLEJAS WRI1006755 49.5 39.6 -1.8 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1062017               227.0933407894944
20522 ESP Spain P. E. CAMPALBO WRI1006756 49.3 39.9 -1.2667 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1053814               226.17579193781967
20525 ESP Spain P. E. CERRO DE LA PUNTA WRI1006763 24.42 39.8667 -1.2167 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1047575               112.03271478948393
20526 ESP Spain P. E. CERRO DEL PALO WRI1006764 49.5 39.5 -2.1667 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1058895               227.0933407894944
20527 ESP Spain P. E. CERRO VICENTE WRI1006766 68.85 38.9209 -1.7202 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1055627               315.86619218902405
20531 ESP Spain P. E. CUESTA COLORADA WRI1006774 49.5 39.4085 -2.2017 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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                 227.0933407894944
20533 ESP Spain P. E. DE HIGUERUELA WRI1006778 37.6 39.8667 -1.2167 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1047572               172.49918411484833
20547 ESP Spain P. E. LA CUERDA WRI1006808 31.02 38.8346 -1.4603 Wind       2000.0 IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1049155               142.31182689474986
20563 ESP Spain P. E. MAZA WRI1006840 49.5 39.6 -1.8 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1061251               227.0933407894944
20581 ESP Spain P. E. VIRGEN DE LOS LLANOS I WRI1023528 49.5 38.9722 -1.4518 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1047573|1047574               227.0933407894944
20582 ESP Spain P. E.MUELA DE TORTOSILLA WRI1006888 36.96 38.9667 -1.2167 Wind       2000.0 IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1047576               169.56302778948918
20608 ESP Spain P.E. CERRO DEL CALDERON WRI1006978 49.5 39.4085 -2.2017 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1062624               227.0933407894944
20643 ESP Spain P.E. LA MUELA I WRI1007077 49.5 39.4085 -2.2017 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1062623               227.0933407894944
20692 ESP Spain P.E. SIERRA DE LA OLIVA WRI1023642 46.86 38.7564 -1.0117 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1049156               214.9816959473881
20701 ESP Spain P.E. SIERRA QUEMADA WRI1007239 26.25 38.9147 -3.5369 Wind         IBERDROLA E.RENOV. CASTILLA LA MANCHA 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 1049154               120.42828678230764

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");
Powered by Datasette · Query took 77.245ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette