global-power-plants

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

829 rows where country_long = "Spain" sorted by capacity_mw

View and edit SQL

Suggested facets: other_fuel1, source, url, geolocation_source

primary_fuel

country_long

  • Spain · 829
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
20197 ESP Spain Ataquines A WKS0069237 4.0 41.198 -4.8322 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20448 ESP Spain Lazagurría WKS0065988 4.0 42.496 -2.278 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20488 ESP Spain Mendavia WKS0065990 4.0 42.4684 -2.2781 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20844 ESP Spain Plasencia WKS0072328 4.0 41.712 -1.249 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20846 ESP Spain Pozohondo I WKS0063613 4.0 38.7167 -1.8857 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20897 ESP Spain Sariñena A WKS0066688 4.0 41.801 -0.083 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20927 ESP Spain Torrealvilla B WKS0070102 4.0 37.769 -1.698 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20951 ESP Spain Villafranca II WKS0063509 4.1 42.271 -1.692 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.437608657108813
20362 ESP Spain Fuentes de Valdepero WKS0072903 4.5 42.063 -4.498 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 12.553472916338944
20845 ESP Spain Pozal de Gallinas WKS0072904 4.5 41.3286 -4.8212 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 12.553472916338944
20341 ESP Spain El Escambron WKS0060263 4.7 37.2729 -7.3672 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.111405045954008
20345 ESP Spain Espartosa WKS0073058 4.7 38.2813 -1.51 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.111405045954008
20287 ESP Spain Campo Lugar WKS0060372 4.8 39.212 -5.7803 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.39037111076154
20434 ESP Spain La Herrera 160 WKS0060376 4.8 38.958 -2.1048 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.39037111076154
20450 ESP Spain Llerena I WKS0060373 4.8 38.2446 -5.9657 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.39037111076154
20491 ESP Spain Moraleja WKS0060371 4.8 40.062 -6.675 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.39037111076154
20843 ESP Spain Pitiegua WKS0060367 4.9 41.0536 -5.4377 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.669337175569071
20222 ESP Spain Bullas WKS0060345 5.0 38.052 -1.687 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20306 ESP Spain Daimiel WKS0060362 5.0 38.9932 -3.5714 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20378 ESP Spain Girasol WKS0060344 5.0 38.803 -6.83 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20392 ESP Spain Iniesta WKS0060356 5.0 39.438 -1.709 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20452 ESP Spain Logrosán WKS0060361 5.0 39.2946 -5.4885 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20860 ESP Spain Rota WKS0060360 5.0 36.695 -6.284 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20952 ESP Spain Villaldelmiro WKS0060359 5.0 42.2475 -3.973 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20956 ESP Spain Villaverde WKS0060358 5.0 39.6914 -3.9545 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20292 ESP Spain Casas Ibañez WKS0060336 5.1 39.2714 -1.4687 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.227269305184135
20847 ESP Spain Pozohondo II WKS0060337 5.1 38.7218 -1.881 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.227269305184135
20943 ESP Spain Valdecaballeros Tracker WKS0060338 5.1 39.2768 -5.22 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.227269305184135
20164 ESP Spain Abenójar WKS0060326 5.2 38.898 -4.366 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20168 ESP Spain Actiu Technological Park WKS0060333 5.2 38.6057 -0.6586 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20216 ESP Spain Bargas WKS0060325 5.2 39.919 -4.117 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20296 ESP Spain Castejon WKS0060321 5.2 42.1517 -1.6556 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20486 ESP Spain Mazarrón Conergy WKS0061095 5.2 37.626 -1.361 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20892 ESP Spain San Clemente WKS0060323 5.2 39.431 -2.416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20954 ESP Spain Villanueva de la Jara WKS0060322 5.2 39.4393 -1.9246 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20298 ESP Spain Castuera WKS0060318 5.4 38.7271 -5.5158 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.064167499606734
20363 ESP Spain Fustiñana III WKS0060319 5.4 42.0309 -1.4775 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.064167499606734
20385 ESP Spain Hinojar WKS0060314 5.5 37.685 -1.533 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.343133564414265
20947 ESP Spain Valverdon WKS0060316 5.5 41.0583 -5.782 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.343133564414265
20949 ESP Spain Villabrázaro WKS0060315 5.5 42.0471 -5.699 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.343133564414265
20180 ESP Spain Algarrobo WKS0060300 5.6 37.603 -5.104 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20187 ESP Spain Almonacid WKS0060307 5.6 41.418 -1.2969 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20288 ESP Spain Campollano WKS0060309 5.6 39.0105 -1.8949 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20396 ESP Spain Jerez de la Frontera WKS0060311 5.6 36.7076 -6.2309 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20188 ESP Spain Alvarado WKS0060293 5.7 38.8081 -6.8254 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20198 ESP Spain Atzeneta WKS0060297 5.7 40.214 -0.1853 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20221 ESP Spain Bonete WKS0060299 5.7 38.8816 -1.33 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20289 ESP Spain Cantillana WKS0060295 5.7 37.589 -5.816 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20441 ESP Spain La Rambla WKS0060294 5.7 37.6057 -4.7677 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20444 ESP Spain Las Cabezas de San Juan WKS0060298 5.7 37.07 -6.033 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20300 ESP Spain Cieza IGS WKS0073059 5.9 38.2584 -1.4568 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.458997823644395
20307 ESP Spain Darro AES WKS0060290 5.9 37.3341 -3.2508 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.458997823644395
20308 ESP Spain Darro Epuron WKS0060292 5.9 37.3488 -3.2707 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.458997823644395
20946 ESP Spain Valtierra II WKS0060241 5.9 42.1388 -1.6824 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.458997823644395
20167 ESP Spain Abona WKS0065991 6.0 28.163 -16.468 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20297 ESP Spain Castelnou WKS0060286 6.0 41.2199 -0.3017 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20438 ESP Spain La Olmeda WKS0060289 6.0 41.206 -4.837 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20484 ESP Spain Manzanares WKS0060285 6.0 39.0041 -3.4111 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20504 ESP Spain Olmedilla de Alarcón 6MW WKS0060288 6.0 39.6034 -2.0829 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20290 ESP Spain Carmona WKS0060274 6.1 37.5189 -5.6592 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.016929953259456
20357 ESP Spain Fuente Palmera WKS0060273 6.1 37.7539 -5.0429 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.016929953259456
20178 ESP Spain Aldea del Conde WKS0060265 6.2 38.817 -6.749 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.295896018066987
20181 ESP Spain Alhama WKS0060259 6.3 37.8483 -1.3416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.574862082874514
20479 ESP Spain Magec de Abona WKS0060264 6.3 28.1408 -16.4622 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.574862082874514
20485 ESP Spain Mazarrón WKS0060256 6.3 37.642 -1.348 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.574862082874514
20930 ESP Spain Trajano A WKS0067647 6.3 37.092 -5.875 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.574862082874514
20928 ESP Spain Torrealvilla I WKS0070100 6.4 37.756 -1.702 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.85382814768205
20194 ESP Spain Arico WKS0069759 6.6 28.158 -16.4644 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 18.41176027729712
20442 ESP Spain La Solana WKS0060249 6.6 38.924 -3.257 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 18.41176027729712
20453 ESP Spain Los Navalmorales WKS0060246 6.6 39.7199 -4.6529 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 18.41176027729712
20929 ESP Spain Torrealvilla II WKS0073056 6.8 37.756 -1.702 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 18.96969240691218
20220 ESP Spain Blanca WKS0060240 7.0 38.2216 -1.3163 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20293 ESP Spain Casas de Don Pedro WKS0060236 7.0 39.1159 -5.3349 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20344 ESP Spain Eruela WKS0060234 7.0 39.4194 -2.9897 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20397 ESP Spain L'Olleria and Garrofera WKS0060239 7.0 38.9287 -0.5115 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20489 ESP Spain Moclinejo WKS0060232 7.0 36.7848 -4.2672 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20896 ESP Spain Sanlúcar la Mayor A WKS0067646 7.0 37.452 -6.251 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20926 ESP Spain Torrealvilla A WKS0070101 7.0 37.766 -1.723 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20931 ESP Spain Trujillo A WKS0072744 7.0 39.46 -5.95 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20964 ESP Spain Zújar WKS0060237 7.0 38.942 -5.875 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20193 ESP Spain Arguedas III WKS0060227 7.1 42.1859 -1.6073 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
20291 ESP Spain Casas Coloradas WKS0063593 7.1 37.8094 -1.0631 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
20449 ESP Spain Lebrija 3+4 WKS0060226 7.1 36.964 -6.063 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
20487 ESP Spain Medina WKS0065692 7.1 41.3432 -4.92 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
20173 ESP Spain Alcaudete WKS0060224 7.2 37.571 -4.093 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.08555666614231
20177 ESP Spain Alconera II WKS0065277 7.2 38.3773 -6.4587 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.08555666614231
20433 ESP Spain La Flamenca WKS0060223 7.2 37.28 -7.259 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.08555666614231
20176 ESP Spain Alconera WKS0060221 7.3 38.365 -6.4549 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.36452273094984
20190 ESP Spain Archidona WKS0060222 7.3 37.09 -4.433 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.36452273094984
20455 ESP Spain Losa del Obispo WKS0060218 7.4 39.687 -0.852 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.64348879575737
20501 ESP Spain Olmeda de la Cuesta WKS0060216 7.6 40.319 -2.475 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 21.201420925372442
20959 ESP Spain Yecla WKS0060217 7.6 38.5924 -1.0558 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 21.201420925372442
20961 ESP Spain Zarza WKS0065683 7.6 39.871 -6.832 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 21.201420925372442
20950 ESP Spain Villafranca WKS0060101 7.8 42.268 -1.685 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 21.759353054987503
20199 ESP Spain Azonilla WKS0065994 8.0 38.7462 -5.5308 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20286 ESP Spain Camino del Cementerio A WKS0068018 8.0 38.822 -7.005 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20384 ESP Spain Hellin I+II WKS0060207 8.0 38.5891 -1.7906 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20481 ESP Spain Malagón WKS0060197 8.0 39.261 -4.087 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20858 ESP Spain Ramón Escriche WKS0060208 8.0 41.239 0.5336 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20182 ESP Spain Almansa WKS0060193 8.3 38.8443 -1.0498 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 23.154183379025163

Next page

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 158.642ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette