global-power-plants

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

243 rows where country_long = "Spain" and primary_fuel = "Solar" sorted by wepp_id

View and edit SQL

Suggested facets: commissioning_year, source, url, geolocation_source

primary_fuel

  • Solar · 243

country_long

  • Spain · 243
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
20164 ESP Spain Abenójar WKS0060326 5.2 38.898 -4.366 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20165 ESP Spain Abertura WKS0060038 23.0 39.2226 -5.7853 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 64.16219490573238
20166 ESP Spain Ablitas WKS0061102 8.8 42.006 -1.692 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 24.549013703062826
20167 ESP Spain Abona WKS0065991 6.0 28.163 -16.468 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
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
20169 ESP Spain Ager WKS0060113 11.3 38.328 -6.688 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 31.523165323251128
20170 ESP Spain Alange WKS0060188 8.5 38.8064 -6.2832 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 23.71211550864023
20171 ESP Spain Albacete Casa Grande WKS0060152 10.0 39.044 -1.976 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20172 ESP Spain Albacete Tinajeros WKS0060163 10.0 39.0465 -1.7941 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20173 ESP Spain Alcaudete WKS0060224 7.2 37.571 -4.093 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.08555666614231
20174 ESP Spain Alcolea I+II WKS0060254 9.3 37.92 -4.673 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 25.943844027100486
20175 ESP Spain Alconchel WKS0060160 10.0 38.523 -7.06 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20176 ESP Spain Alconera WKS0060221 7.3 38.365 -6.4549 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.36452273094984
20177 ESP Spain Alconera II WKS0065277 7.2 38.3773 -6.4587 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.08555666614231
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
20179 ESP Spain Alfarrasi WKS0061428 10.6 38.906 -0.509 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 29.570402869598396
20180 ESP Spain Algarrobo WKS0060300 5.6 37.603 -5.104 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20181 ESP Spain Alhama WKS0060259 6.3 37.8483 -1.3416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.574862082874514
20182 ESP Spain Almansa WKS0060193 8.3 38.8443 -1.0498 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 23.154183379025163
20183 ESP Spain Almaraz WKS0060040 22.1 39.83 -5.66 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 61.65150032246459
20184 ESP Spain Almodóvar del Campo WKS0060155 10.0 38.7288 -4.21 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20185 ESP Spain Almodóvar del Río E WKS0060157 9.6 37.838 -4.972 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 26.78074222152308
20186 ESP Spain Almodóvar del Río W WKS0060167 9.6 37.837 -4.98 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 26.78074222152308
20187 ESP Spain Almonacid WKS0060307 5.6 41.418 -1.2969 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
20189 ESP Spain Arbante WKS0060182 8.8 42.495 -2.31 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 24.549013703062826
20190 ESP Spain Archidona WKS0060222 7.3 37.09 -4.433 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 20.36452273094984
20191 ESP Spain Arcosol CSP WKS0071015 49.9 36.663 -5.828 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 139.20406633895848
20192 ESP Spain Arenales WKS0071016 50.0 37.122 -5.567 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 139.48303240376603
20193 ESP Spain Arguedas III WKS0060227 7.1 42.1859 -1.6073 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
20194 ESP Spain Arico WKS0069759 6.6 28.158 -16.4644 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 18.41176027729712
20195 ESP Spain Arnedo WKS0060022 30.0 42.277 -2.044 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 83.68981944225963
20196 ESP Spain Aste 1B WKS0070985 50.0 39.172 -3.277 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 139.48303240376603
20197 ESP Spain Ataquines A WKS0069237 4.0 41.198 -4.8322 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.158642592301282
20198 ESP Spain Atzeneta WKS0060297 5.7 40.214 -0.1853 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20199 ESP Spain Azonilla WKS0065994 8.0 38.7462 -5.5308 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 22.317285184602564
20215 ESP Spain Bardenas WKS0060135 10.1 42.271 -1.666 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 28.175572545560737
20216 ESP Spain Bargas WKS0060325 5.2 39.919 -4.117 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20217 ESP Spain Belmez WKS0060124 10.9 38.2812 -5.239 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 30.407301064020995
20218 ESP Spain Benahadux WKS0060127 10.6 36.9268 -2.4758 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 29.570402869598396
20219 ESP Spain Beneixama WKS0060055 20.0 38.72 -0.727 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 55.793212961506406
20220 ESP Spain Blanca WKS0060240 7.0 38.2216 -1.3163 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20221 ESP Spain Bonete WKS0060299 5.7 38.8816 -1.33 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20222 ESP Spain Bullas WKS0060345 5.0 38.052 -1.687 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20283 ESP Spain Calasparra WKS0060054 20.0 38.26 -1.682 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 55.793212961506406
20284 ESP Spain Calavéron WKS0060045 21.2 39.332 -2.525 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 59.140805739196786
20285 ESP Spain Calzada de Calatrava WKS0060158 10.0 38.7071 -3.72 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
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
20287 ESP Spain Campo Lugar WKS0060372 4.8 39.212 -5.7803 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.39037111076154
20288 ESP Spain Campollano WKS0060309 5.6 39.0105 -1.8949 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.622099629221795
20289 ESP Spain Cantillana WKS0060295 5.7 37.589 -5.816 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.901065694029331
20290 ESP Spain Carmona WKS0060274 6.1 37.5189 -5.6592 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.016929953259456
20291 ESP Spain Casas Coloradas WKS0063593 7.1 37.8094 -1.0631 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.806590601334776
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
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
20294 ESP Spain Casas de Los Pinos WKS0060099 28.0 39.275 -2.4095 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 78.11049814610898
20295 ESP Spain Casatejada WKS0060112 11.3 39.883 -5.667 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 31.523165323251128
20296 ESP Spain Castejon WKS0060321 5.2 42.1517 -1.6556 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.506235369991668
20297 ESP Spain Castelnou WKS0060286 6.0 41.2199 -0.3017 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.737963888451926
20298 ESP Spain Castuera WKS0060318 5.4 38.7271 -5.5158 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.064167499606734
20300 ESP Spain Cieza IGS WKS0073059 5.9 38.2584 -1.4568 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 16.458997823644395
20301 ESP Spain Corella WKS0060126 10.9 42.1194 -1.7154 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 30.407301064020995
20302 ESP Spain Cortijo Viejo WKS0060154 10.0 37.641 -4.584 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20303 ESP Spain Cáceres WKS0062360 10.7 39.4628 -6.3061 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 29.849368934405927
20306 ESP Spain Daimiel WKS0060362 5.0 38.9932 -3.5714 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
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
20309 ESP Spain Don Quijote WKS0060068 15.2 39.8942 -5.3246 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 42.402841850744885
20310 ESP Spain Don Rodrigo WKS0071538 175.0 37.228 -5.867 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 488.19061341318115
20311 ESP Spain Dulcinea WKS0060023 31.8 39.6564 -2.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 88.7112086087952
20334 ESP Spain El Bailadero WKS0065992 9.0 28.177 -16.445 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 25.106945832677887
20335 ESP Spain El Bonillo WKS0060056 20.0 38.916 -2.55 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 55.793212961506406
20336 ESP Spain El Carpio de Tajo WKS0071310 50.0 39.87 -4.475 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 139.48303240376603
20337 ESP Spain El Coronil WKS0060044 16.6 37.0939 -5.6265 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 46.308366758050326
20338 ESP Spain El Coronil I WKS0063916 10.1 37.0973 -5.6343 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 28.175572545560737
20339 ESP Spain El Coronil II WKS0063917 10.2 37.0983 -5.6223 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 28.45453861036827
20340 ESP Spain El Cuervo Chico WKS0063020 20.0 36.84 -6.058 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 55.793212961506406
20341 ESP Spain El Escambron WKS0060263 4.7 37.2729 -7.3672 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.111405045954008
20342 ESP Spain El Realengo WKS0060088 13.2 38.1995 -0.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 36.823520554594225
20343 ESP Spain Elduayen WKS0060110 11.5 38.8952 -6.26 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 32.08109745286619
20344 ESP Spain Eruela WKS0060234 7.0 39.4194 -2.9897 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 19.527624536527245
20345 ESP Spain Espartosa WKS0073058 4.7 38.2813 -1.51 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.111405045954008
20346 ESP Spain Extremasol WKS0060108 10.0 38.8459 -6.43 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20353 ESP Spain Finca Verde WKS0060178 9.0 28.1564 -16.4852 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 25.106945832677887
20354 ESP Spain Fontellas WKS0061103 8.8 41.99 -1.566 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 24.549013703062826
20355 ESP Spain Fontiveros WKS0060151 10.0 40.9178 -4.97 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.896606480753213
20356 ESP Spain Fuenmayor WKS0060162 9.9 42.4704 -2.6076 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 27.61764041594568
20357 ESP Spain Fuente Palmera WKS0060273 6.1 37.7539 -5.0429 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 17.016929953259456
20358 ESP Spain Fuente Álamo WKS0060028 27.9 37.685 -1.174 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 77.83153208130145
20359 ESP Spain Fuente Álamo I WKS0063590 14.8 37.685 -1.174 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 41.28697759151475
20360 ESP Spain Fuente Álamo II WKS0063588 8.9 37.684 -1.179 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 24.82797976787036
20361 ESP Spain Fuente Álamo III WKS0063589 10.4 37.69 -1.162 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 29.01247073998333
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
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
20376 ESP Spain Gemasol WKS0062476 19.9 37.562 -5.332 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 55.51424689669889
20377 ESP Spain General Motors WKS0060104 11.8 41.755 -1.175 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 32.91799564728879
20378 ESP Spain Girasol WKS0060344 5.0 38.803 -6.83 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.948303240376607
20379 ESP Spain Guadarranque WKS0060084 12.3 36.195 -5.416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 34.312825971326454
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
20385 ESP Spain Hinojar WKS0060314 5.5 37.685 -1.533 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.343133564414265

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