global-power-plants

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

829 rows where country_long = "Spain" sorted by gppd_idnr

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 estimated_generation_gwh
20502 ESP Spain Olmedilla WKS0060007 60.0 39.619 -2.086 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               167.37963888451927
20849 ESP Spain Puertollano WKS0060011 47.6 38.62 -3.974 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               132.78784684838527
20195 ESP Spain Arnedo WKS0060022 30.0 42.277 -2.044 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               83.68981944225963
20311 ESP Spain Dulcinea WKS0060023 31.8 39.6564 -2.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               88.7112086087952
20888 ESP Spain SPEX WKS0060026 30.0 38.89 -6.285 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               83.68981944225963
20358 ESP Spain Fuente Álamo WKS0060028 27.9 37.685 -1.174 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               77.83153208130145
20456 ESP Spain Lucainena de las Torres WKS0060037 15.2 37.015 -2.176 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               42.402841850744885
20165 ESP Spain Abertura WKS0060038 23.0 39.2226 -5.7853 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               64.16219490573238
20388 ESP Spain Hoya de Los Vicentes WKS0060039 20.0 38.364 -1.277 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               55.793212961506406
20183 ESP Spain Almaraz WKS0060040 22.1 39.83 -5.66 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               61.65150032246459
20337 ESP Spain El Coronil WKS0060044 16.6 37.0939 -5.6265 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               46.308366758050326
20284 ESP Spain Calavéron WKS0060045 21.2 39.332 -2.525 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               59.140805739196786
20901 ESP Spain Solten WKS0060053 19.7 28.0684 -16.525 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               54.956314767083825
20283 ESP Spain Calasparra WKS0060054 20.0 38.26 -1.682 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               55.793212961506406
20219 ESP Spain Beneixama WKS0060055 20.0 38.72 -0.727 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               55.793212961506406
20335 ESP Spain El Bonillo WKS0060056 20.0 38.916 -2.55 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               55.793212961506406
20500 ESP Spain Olivenza WKS0060061 18.0 38.7217 -7.1375 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               50.213891665355774
20446 ESP Spain Las Gabias S WKS0060062 18.0 37.129 -3.712 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               50.213891665355774
20309 ESP Spain Don Quijote WKS0060068 15.2 39.8942 -5.3246 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               42.402841850744885
20480 ESP Spain Mahora WKS0060073 15.0 39.2101 -1.75 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               41.84490972112982
20891 ESP Spain Salamanca WKS0060081 13.8 41.0277 -5.85 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               38.49731694343943
20379 ESP Spain Guadarranque WKS0060084 12.3 36.195 -5.416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               34.312825971326454
20342 ESP Spain El Realengo WKS0060088 13.2 38.1995 -0.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               36.823520554594225
20451 ESP Spain Lobosillo WKS0060090 12.7 37.7336 -1.0596 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               35.428690230556576
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
20387 ESP Spain Hinojosa del Valle WKS0060100 12.0 38.474 -6.232 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               33.47592777690385
20950 ESP Spain Villafranca WKS0060101 7.8 42.268 -1.685 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               21.759353054987503
20377 ESP Spain General Motors WKS0060104 11.8 41.755 -1.175 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               32.91799564728879
20848 ESP Spain Puebla de Almoradiel WKS0060105 11.8 39.632 -3.09 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               32.91799564728879
20925 ESP Spain Tordesillas WKS0060106 10.0 41.5062 -5.0275 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20503 ESP Spain Olmedilla de Alarcón WKS0060107 10.0 39.6393 -2.0965 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20346 ESP Spain Extremasol WKS0060108 10.0 38.8459 -6.43 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20343 ESP Spain Elduayen WKS0060110 11.5 38.8952 -6.26 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               32.08109745286619
20942 ESP Spain Valdecaballeros WKS0060111 10.0 39.2919 -5.2111 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20295 ESP Spain Casatejada WKS0060112 11.3 39.883 -5.667 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               31.523165323251128
20169 ESP Spain Ager WKS0060113 11.3 38.328 -6.688 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               31.523165323251128
20890 ESP Spain Saelices WKS0060114 11.3 39.918 -2.822 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               31.523165323251128
20439 ESP Spain La Puente de Piedra WKS0060116 11.2 41.4369 -2.5 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               31.244199258443594
20492 ESP Spain Moratalla WKS0060119 10.0 38.301 -1.763 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20478 ESP Spain Magacela WKS0060123 10.9 38.913 -5.7048 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               30.407301064020995
20217 ESP Spain Belmez WKS0060124 10.9 38.2812 -5.239 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               30.407301064020995
20953 ESP Spain Villanueva de Serena WKS0060125 10.9 38.964 -5.771 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               30.407301064020995
20301 ESP Spain Corella WKS0060126 10.9 42.1194 -1.7154 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
20215 ESP Spain Bardenas WKS0060135 10.1 42.271 -1.666 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               28.175572545560737
20948 ESP Spain Vejer de la Frontera WKS0060150 10.0 36.2447 -6.008 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20355 ESP Spain Fontiveros WKS0060151 10.0 40.9178 -4.97 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
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
20899 ESP Spain Sierresita WKS0060153 10.0 37.644 -4.59 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20302 ESP Spain Cortijo Viejo WKS0060154 10.0 37.641 -4.584 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
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
20924 ESP Spain Talayuela 1 WKS0060156 10.0 40.0208 -5.579 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
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
20445 ESP Spain Las Gabias N WKS0060159 10.0 37.142 -3.715 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20175 ESP Spain Alconchel WKS0060160 10.0 38.523 -7.06 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20963 ESP Spain Zuera II WKS0060161 9.9 41.944 -0.818 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.61764041594568
20356 ESP Spain Fuenmayor WKS0060162 9.9 42.4704 -2.6076 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.61764041594568
20172 ESP Spain Albacete Tinajeros WKS0060163 10.0 39.0465 -1.7941 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.896606480753213
20440 ESP Spain La Quintana WKS0060164 9.8 37.718 -4.89 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.338674351138142
20955 ESP Spain Villar de Cañas WKS0060165 9.8 39.8331 -2.5712 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               27.338674351138142
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
20851 ESP Spain Quintanilla WKS0060168 9.5 37.962 -4.481 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               26.50177615671555
20490 ESP Spain Monte Alto WKS0060169 9.5 42.26 -1.775 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               26.50177615671555
20386 ESP Spain Hinojos WKS0060170 9.5 37.268 -6.417 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               26.50177615671555
20443 ESP Spain La Veguilla WKS0060171 9.4 38.0016 -4.3197 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               26.222810091908016
20454 ESP Spain Los Olivares WKS0060173 9.1 37.7976 -3.7977 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               25.385911897485414
20447 ESP Spain Lasesa WKS0060177 9.0 41.856 -0.061 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               25.106945832677887
20353 ESP Spain Finca Verde WKS0060178 9.0 28.1564 -16.4852 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               25.106945832677887
20960 ESP Spain Zaratán WKS0060179 9.0 41.6428 -4.8151 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               25.106945832677887
20477 ESP Spain Madridejos WKS0060181 8.8 39.492 -3.535 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               24.549013703062826
20189 ESP Spain Arbante WKS0060182 8.8 42.495 -2.31 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               24.549013703062826
20493 ESP Spain Morita WKS0060183 8.7 37.4542 -4.6968 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               24.270047638255292
20957 ESP Spain Vinaceite WKS0060185 8.7 41.307 -0.605 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               24.270047638255292
20170 ESP Spain Alange WKS0060188 8.5 38.8064 -6.2832 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               23.71211550864023
20393 ESP Spain Isla Mayor WKS0060191 8.4 37.1488 -6.1452 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               23.433149443832693
20182 ESP Spain Almansa WKS0060193 8.3 38.8443 -1.0498 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               23.154183379025163
20481 ESP Spain Malagón WKS0060197 8.0 39.261 -4.087 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
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
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
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
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
20433 ESP Spain La Flamenca WKS0060223 7.2 37.28 -7.259 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               20.08555666614231
20173 ESP Spain Alcaudete WKS0060224 7.2 37.571 -4.093 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               20.08555666614231
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
20193 ESP Spain Arguedas III WKS0060227 7.1 42.1859 -1.6073 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               19.806590601334776
20489 ESP Spain Moclinejo WKS0060232 7.0 36.7848 -4.2672 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               19.527624536527245
20903 ESP Spain Solten II WKS0060233 11.0 28.0724 -16.5252 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               30.68626712882853
20344 ESP Spain Eruela WKS0060234 7.0 39.4194 -2.9897 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
20964 ESP Spain Zújar WKS0060237 7.0 38.942 -5.875 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
20220 ESP Spain Blanca WKS0060240 7.0 38.2216 -1.3163 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               19.527624536527245
20946 ESP Spain Valtierra II WKS0060241 5.9 42.1388 -1.6824 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar               16.458997823644395
20453 ESP Spain Los Navalmorales WKS0060246 6.6 39.7199 -4.6529 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
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

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