global-power-plants

Table actions

58 rows where country_long = "Spain" and primary_fuel = "Gas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year, geolocation_source, generation_gwh_2016

primary_fuel 1

  • Gas · 58 ✖

country_long 1

  • Spain · 58 ✖
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
20137 20137 ESP Spain ACECA GRUPO 4 WRI1006159 758.74 39.9427 -3.8548 Gas       2006.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 1031228       1294.233 1272.51 1678.557 JRC-PPDB-OPEN 1371.1425733196775
20148 20148 ESP Spain AMOREBIETA WRI1006189 786.42 43.2347 -2.7497 Gas       2005.0 BIZKAIA ENERGIA 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 1051022       771.686 662.1030000000001 928.35 JRC-PPDB-OPEN 1421.1639593405655
20155 20155 ESP Spain ARCOS DE LA FRONTERA GRUPO 1 WRI1006203 1585.39 36.6721 -5.8164 Gas       2005.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 GEODB         198.232 909.4069999999999 888.096 JRC-PPDB-OPEN 2865.00741270433
20157 20157 ESP Spain ARRUBAL GRUPO 1 WRI1006210 784.7 42.4194 -2.2511 Gas       2005.0 CONTOUR GLOBAL LA RIOJA 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 1054391       586.258 1010.712 1688.797 JRC-PPDB-OPEN 1418.0556940242388
20162 20162 ESP Spain AZULIBER WRI1006221 17.762999999999998 40.0667 -0.2 Gas         AZULIBER 1 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 1010596               32.100067915066326
20200 20200 ESP Spain BAHIA DE ALGECIRAS I WRI1006223 731.0 36.1829 -5.3905 Gas       1970.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 1012767       2103.4970000000003 2415.509 3373.7129999999997 JRC-PPDB-OPEN 1321.0127594389173
20208 20208 ESP Spain BESOS GRUPO 5 WRI1006249 1670.81 41.4196 2.2294 Gas       2010.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 1031231       744.13 666.045 1360.293 JRC-PPDB-OPEN 3019.372542541912
20230 20230 ESP Spain CAMPO DE GIBRALTAR GRUPO 20 WRI1006292 780.6600000000002 36.1834 -5.3933 Gas       2004.0 PUENTE MAYORGA 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 1045094               1410.7548847928665
20235 20235 ESP Spain CARTAGENA GRUPO 1 WRI1006308 1248.82 37.5732 -0.9392 Gas       2006.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 1044241               2256.7813327530907
20236 20236 ESP Spain CAS TRESORER TG3 CC2 WRI1006309 429.0 39.5672 2.6895 Gas       2009.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 1062467               775.2591980838516
20238 20238 ESP Spain CASTEJON GRUPO 2 WRI1006317 797.41 42.1718 -1.6773 Gas       2007.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 1041578       341.909 632.861 537.364 JRC-PPDB-OPEN 1441.024329007096
20239 20239 ESP Spain CASTELLON WRI1006318 782.0 39.9592 -0.001 Gas       2002.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 GEODB 1049538       1343.546 1798.9029999999998 1591.8239999999998 JRC-PPDB-OPEN 1413.1764403300049
20243 20243 ESP Spain CCC BAHIA DE ALGECIRAS WRI1006322 820.5360000000001 36.1829 -5.3905 Gas       2009.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 1012767               1482.8160404637094
20244 20244 ESP Spain CCC SAGUNTO GRUPO 2 WRI1006323 1232.19 39.6426 -0.2344 Gas       2007.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 1051731       3628.278 3092.415 2771.594 JRC-PPDB-OPEN 2226.7287442586044
20253 20253 ESP Spain CICLO COMBINADO DE CASTELNOU WRI1006355 790.68 41.2167 -0.2928 Gas       2006.0 CASTELNOU ENERGIA 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 1049538               1428.862337391468
20259 20259 ESP Spain COGENERACION MOTRIL WRI1006377 48.8 36.7334 -3.5413 Gas       2001.0 COGENERACION MOTRIL 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 1049221               88.18799269578544
20260 20260 ESP Spain COGENERACION NAVIA WRI1006378 24.0 43.5354 -6.7193 Gas         INDUSTRIAS LACTEAS ASTURIANAS 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 1009611               43.371143948746955
20262 20262 ESP Spain COLORTEX WRI1006390 12.68 38.8167 -0.6167 Gas         COLORTEX 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 1054595               22.914421052921305
20269 20269 ESP Spain COTASA WRI1006403 14.071 40.0667 -0.2 Gas         TIERRA ATOMIZADA 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 1031355               25.428140270950767
20270 20270 ESP Spain CRISTOBAL COLON WRI1006404 390.94 37.2156 -6.943 Gas       2006.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 1012783       289.949 0.0 195.981 JRC-PPDB-OPEN 706.4797923051303
20275 20275 ESP Spain CTCC AS PONTES GRUPO 5 WRI1006410 855.67 43.4451 -7.8621 Gas       2008.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         178.93200000000002 484.793 1472.945 JRC-PPDB-OPEN 1546.307780942679
20276 20276 ESP Spain CTCC CASTEJON GRUPO 1 WRI1006412 424.91 42.1718 -1.6773 Gas       2002.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         390.789 656.442 875.788 JRC-PPDB-OPEN 767.868032302586
20277 20277 ESP Spain CTCC CASTELLON GRUPO 4 WRI1006413 839.35 39.9592 -0.001 Gas       2008.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 GEODB 1019106               1516.815403057531
20278 20278 ESP Spain CTCC ESCATRON WRI1006414 274.635 41.2977 -0.3376 Gas       2007.0 GLOBAL 3 COMBI 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 1061816               496.3014215985049
20279 20279 ESP Spain CTCC ESCOMBRERAS WRI1006415 815.64 37.5732 -0.9392 Gas       2006.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 GEODB 1019142       369.81800000000004 644.342 1083.558 JRC-PPDB-OPEN 1473.968327098165
20280 20280 ESP Spain CTCC PLANA DEL VENT 2 WRI1006416 819.03 40.9596 0.8692 Gas       2007.0 ALPIQ ENERGIA ESPANA 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 GEODB 1054392       348.084 606.193 876.424 JRC-PPDB-OPEN 1480.0945011809256
20281 20281 ESP Spain CTCC SABON GRUPO 3 WRI1006417 391.31 43.329 -8.503 Gas       2008.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 1032483       160.119 188.94099999999997 297.541 JRC-PPDB-OPEN 707.1484307743402
20282 20282 ESP Spain CTCC SOTO DE RIBERA GRUPO 5 WRI1006418 854.1700000000002 43.3161 -5.8777 Gas       2011.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 1031230       77.778 112.48200000000001 112.96600000000001 JRC-PPDB-OPEN 1543.5970844458825
20312 20312 ESP Spain ECOCARBURANTES WRI1006426 21.666 37.6051 -0.9862 Gas       2012.0 ECOCARBURANTES ESPANOLES 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 1055607               39.15330019973131
20322 20322 ESP Spain ENCE - PONTEVEDRA $$ WRI1006454 26.62 42.4167 -8.6667 Gas       2008.0 GRUPO EMPRESARIAL ENCE 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 1073837               48.105827163151815
20323 20323 ESP Spain ENCE ENERGIA HUELVA S.L.U. $$ WRI1006455 50.0 37.2583 -6.9508 Gas       2012.0 ENCE ENERGIA HUELVA 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 CARMA 1073838               90.35654989322279
20329 20329 ESP Spain ESCATRON WRI1006465 804.36 41.2977 -0.3376 Gas       2008.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 1015712       68.238 0.0 926.488 JRC-PPDB-OPEN 1453.583889442254
20331 20331 ESP Spain ESCOMBRERAS GRUPO 1 WRI1006467 1199.25 7.5732 -0.9392 Gas       2006.0 GDF SUEZ CARTAGENA ENERGIA 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 WRI 1019142|1044241       1683.195 479.222 2367.604 JRC-PPDB-OPEN 2167.201849188949
20347 20347 ESP Spain FERTIMOLINA WRI1006477 10.0 40.8436 -1.8876 Gas       2000.0 FERTIMOLINA 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 1056498               18.07130997864456
20348 20348 ESP Spain FINSA-SANTIAGO WRI1006480 23.96 42.8805 -8.5457 Gas       2002.0 COGENERACION DEL NOROESTE 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 1017189               43.29885870883237
20365 20365 ESP Spain GARONA VERDA WRI1006494 14.95 0.7046 42.8025 Gas       1999.0 NEO SC ARAN SLU 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                 27.016608418073613
20366 20366 ESP Spain GENSABON WRI1006500 12.0 43.3048 -8.5075 Gas       1999.0 GENSABON 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 1054440               21.685571974373477
20372 20372 ESP Spain GUASCOR WRI1006523 13.5 42.2793 -1.7463 Gas         GUASCOR INVESTIGACION Y DESARROLLO 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                 24.39626847117016
20458 20458 ESP Spain MAHON TG4 WRI1006662 50.0 39.8964 4.2597 Gas       2008.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                 90.35654989322279
20460 20460 ESP Spain MALA1 (CTCC MALAGA) WRI1006664 415.509 36.7495 -4.5631 Gas       2009.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 1064787       1845.6470000000002 1787.158 1821.3039999999999 JRC-PPDB-OPEN 750.8791937916625
20468 20468 ESP Spain MICHELIN ARANDA WRI1006677 31.866 41.6704 -3.6892 Gas       2003.0 ENERGYWORKS ARANDA 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 1053157               57.58603637794876
20469 20469 ESP Spain MICHELIN VALLADOLID $$ WRI1006678 46.0 41.6552 -4.7237 Gas         ENERGYWORKS VIT-VALL 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 1049219               83.12802590176497
20496 20496 ESP Spain NEUMATICOS MICHELIN-VITORIA WRI1006705 47.0 42.85 -2.6667 Gas         ENERGYWORKS VIT-VALL 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 1022576               84.93515689962943
20497 20497 ESP Spain NUFRI WRI1006706 10.0 41.6333 0.9 Gas       2005.0 SAT NUM.1596 NUFRI 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 1053783               18.07130997864456
20714 20714 ESP Spain PALOS DE LA FRONTERA GRUPO 1 WRI1007283 1167.0 37.1843 -6.8857 Gas       2004.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 1051730       178.209 66.65100000000001 392.689 JRC-PPDB-OPEN 2108.9218745078197
20716 20716 ESP Spain PAPELERA GUIPUZCOANA WRI1007287 79.918 43.2596 -1.9688 Gas         PAPELERA GUIPUZCOANA DE ZICUNAGA SA 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                 144.4222950873316
20815 20815 ESP Spain PLANTA SECADO TERMICO DE LODOS E.R.A.R. DE BUTARQUE WRI1007779 18.0 37.5624 -5.1254 Gas         SUFI SA (70%) Y CADAGUA SA (30%) 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                 32.52835796156021
20833 20833 ESP Spain PUERTO DE BARCELONA GRUPO 2 WRI1007821 866.3 41.3366 2.1594 Gas       2010.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 1057106       2309.512 1982.6889999999999 1720.2479999999998 JRC-PPDB-OPEN 1565.5175834499782
20854 20854 ESP Spain REPSOL PUERTOLLANO WRI1007845 80.5 38.6478 -4.1214 Gas       1994.0 REPSOL PETROLEO 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 1027345               145.47404532808872
20863 20863 ESP Spain SALINAS BRAS DEL PORT S.A. WRI1007864 10.0 42.5741 0.1824 Gas         BRAS DEL PORT 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                 18.07130997864456
20867 20867 ESP Spain SAN ROQUE GRUPO 2 WRI1007879 791.6800000000002 36.1955 -5.4131 Gas       2002.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         2693.8340000000003 2313.036 1762.875 JRC-PPDB-OPEN 1430.669468389333
20870 20870 ESP Spain SANTURCE GRUPO 4 WRI1007889 396.4 43.34 -3.0539 Gas       2005.0 HIDROELECTRICA IBERICA 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 1019245       0.0 0.0 138.55700000000002 JRC-PPDB-OPEN 716.3467275534703
20880 20880 ESP Spain SNIACE WRI1007923 93.0 42.5273 -8.0086 Gas         SNIACE 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                 168.06318280139442
20907 20907 ESP Spain TARRAGONA WRI1007956 802.84 41.1081 1.1912 Gas       2004.0 TARRAGONA POWER 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         442.939 420.517 544.075 JRC-PPDB-OPEN 1450.8370503254998
20915 20915 ESP Spain TIOXIDE EUROPE S.L. WRI1007968 10.0 37.2583 -6.9508 Gas       2009.0 TIOXIDE EUROPE 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                 18.07130997864456
20917 20917 ESP Spain TORRASPAPEL-MONTANANESA WRI1007973 22.0 41.6561 -0.8773 Gas         TORRASPAPEL 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                 39.75688195301804
20919 20919 ESP Spain TORTOSA ENERGIA WRI1007975 39.58 40.8125 0.5216 Gas       2011.0 TORTOSA ENERGIA SA 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 1031863               71.52624489547517
20923 20923 ESP Spain TRUCHAS DEL CINCA WRI1007994 23.92 42.1519 0.2225 Gas       1999.0 NEO SC EL GRADO SLU 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                 43.22657346891779

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");