global-power-plants

Table actions

44 rows where country_long = "Spain", owner = "ENDESA GENERACION S.A." and primary_fuel = "Hydro"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year, geolocation_source

primary_fuel 1

  • Hydro · 44 ✖

owner 1

  • ENDESA GENERACION S.A. · 44 ✖

country_long 1

  • Spain · 44 ✖
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
20158 20158 ESP Spain ARTIES 1 WRI1006212 67.52 41.798 1.9543 Hydro       1955.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 CARMA 1029321               185.28061829209477
20202 20202 ESP Spain BARCENA GR 1 WRI1006228 61.15 43.1258 -4.0566 Hydro       1959.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 CARMA                 167.80079692774868
20203 20203 ESP Spain BARRADOS WRI1006229 15.88 42.7333 0.7167 Hydro       1956.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 CARMA 1029322               43.57606958647015
20206 20206 ESP Spain BEMBEZAR WRI1006247 14.86 37.8333 -5.2333 Hydro       1962.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 CARMA 1012771               40.77710290018554
20228 20228 ESP Spain CALDES 2 WRI1006288 32.48 42.5046 0.8006 Hydro       1959.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 CARMA 1015785               89.12788036325883
20229 20229 ESP Spain CAMARASA II 1 WRI1006289 58.65000000000001 41.8749 0.8781 Hydro       1989.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 CARMA 1017205               160.9405844613649
20234 20234 ESP Spain CANELLES 1 WRI1006306 107.4 41.9763 0.6116 Hydro       1959.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 WRI 1015787               294.71472755584966
20254 20254 ESP Spain CIJARA M. DCHA. 1 WRI1006357 50.4 39.3711 -5.0166 Hydro       1980.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 WRI                 138.3018833222982
20255 20255 ESP Spain CIJARA M. IZDA. 3 WRI1023631 51.7 39.3711 -5.0166 Hydro       1969.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 WRI                 141.86919380481785
20268 20268 ESP Spain CORNATEL GR 1 WRI1006401 130.66 42.4496 -6.9476 Hydro       1963.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 CARMA 1015709               358.542144343085
20305 20305 ESP Spain DUQUE WRI1006425 12.56 36.9402 -3.361 Hydro       1982.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 CARMA 1012790               34.465707431112406
20328 20328 ESP Spain ESCALES 1 WRI1006464 35.85 42.3161 0.7463 Hydro       1955.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 CARMA 1015789               98.37544676794428
20332 20332 ESP Spain EUME GR 1 WRI1006471 54.4 43.427 -8.0671 Hydro       1960.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 CARMA 1015713               149.2782232685123
20349 20349 ESP Spain FLIX 1 WRI1006481 52.52 41.2331 0.5472 Hydro       1948.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 WRI                 144.1193434937917
20371 20371 ESP Spain GUADALMENA WRI1006522 15.2 38.3119 -3.0422 Hydro       1970.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 CARMA 1012799               41.71009179561374
20375 20375 ESP Spain GUILLENA 1 WRI1006526 207.99 37.641 -6.0724 Hydro       1973.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 WRI 1012801               570.7422363532701
20390 20390 ESP Spain IZNAJAR 1 WRI1006562 76.71000000000002 37.2667 -4.4143 Hydro       1969.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 CARMA 1012803               210.49875931852176
20409 20409 ESP Spain LA SERENA WRI1006595 22.0 38.732 -5.5439 Hydro       1992.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 CARMA 1027884               60.36986970417778
20412 20412 ESP Spain LAFORTUNADA CINQUETA 1 WRI1006600 40.8 42.5741 0.1824 Hydro       1932.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 CARMA 1019176|1019175               111.95866745138426
20416 20416 ESP Spain LAS ONDINAS GR 1 WRI1006607 82.46000000000002 42.8206 -6.4875 Hydro       1966.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 CARMA 1015716               226.27724799120458
20422 20422 ESP Spain LERIDA WRI1006620 11.93 41.6167 0.6167 Hydro       1964.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 CARMA                 32.736933889583675
20426 20426 ESP Spain LLAVORSI CARDOS 1 WRI1006626 52.4 42.4951 1.211 Hydro       1966.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 CARMA 1017211               143.79005329540527
20467 20467 ESP Spain MEQUINENZA 1 WRI1006676 322.36 41.3687 0.2765 Hydro       1964.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 WRI 1015792               884.583236265398
20470 20470 ESP Spain MONTAMARA 1 WRI1006685 92.42 42.5758 1.1423 Hydro       1974.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 WRI 1017214               253.60833445727775
20474 20474 ESP Spain MORALETS 1 WRI1006693 219.14 42.5787 0.7587 Hydro       1985.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 WRI 1015793               601.3387839533419
20499 20499 ESP Spain OLIANA 3 WRI1006711 37.62 41.9397 1.1954 Hydro       1965.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 WRI 1017247               103.232477194144
20715 20715 ESP Spain PAMPANEIRA WRI1007285 12.8 36.9402 -3.361 Hydro       1956.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 CARMA 1012822               35.12428782788526
20821 20821 ESP Spain PONT DE REI 1 WRI1007796 46.14 42.8384 0.739 Hydro       1960.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 CARMA 1029328               126.61208127958014
20823 20823 ESP Spain PORTO GR 1 WRI1007801 17.6 42.3094 -8.2049 Hydro       1963.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 CARMA                 48.29589576334224
20835 20835 ESP Spain PUERTO PENA 1 WRI1007824 55.2 39.037 -5.2342 Hydro       1964.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 CARMA 1027887               151.47349125775517
20850 20850 ESP Spain QUERENO GR 1 WRI1007838 36.46 42.4496 -6.9476 Hydro       1961.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 CARMA 1015721               100.04933860974192
20855 20855 ESP Spain RIBA ROJA 1 WRI1007848 261.28 41.2422 0.4309 Hydro       1969.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 WRI 1015796               716.9745252867077
20856 20856 ESP Spain RIBADELAGO GR 3 WRI1007849 34.56 41.9781 -6.1404 Hydro       1955.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 CARMA 1015722               94.83557713529021
20864 20864 ESP Spain SAN AGUSTIN GR 1 WRI1007866 62.88 42.1795 -7.1122 Hydro       1961.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 CARMA 1015725               172.5480639544863
20868 20868 ESP Spain SANTA MARINA GR 3 WRI1023649 34.68 42.5103 -5.873 Hydro       1992.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 WRI 1015727               95.16486733367664
20871 20871 ESP Spain SAU 2 WRI1007890 55.56 41.947 2.3844 Hydro       1964.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 CARMA 1018379               152.46136185291442
20874 20874 ESP Spain SEROS II 1 WRI1023650 44.24 41.4744 0.4534 Hydro       1989.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 WRI 1017220               121.39831980512844
20889 20889 ESP Spain SUSQUEDA 3 WRI1007949 88.55000000000003 41.9791 2.5274 Hydro       1981.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 WRI 1018381               242.98872555931564
20904 20904 ESP Spain TAJO DE LA ENCANTADA 1 WRI1007951 376.88 36.9083 -4.7631 Hydro       1977.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 WRI 1012844               1034.1907497322966
20908 20908 ESP Spain TAVASCAN INFERIOR WRI1007958 150.88 42.637 1.2512 Hydro       1971.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 CARMA                 414.02754277119743
20909 20909 ESP Spain TERMENS WRI1007960 11.92 41.7167 0.7667 Hydro       1964.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 CARMA 1017224               32.70949303971815
20913 20913 ESP Spain TERRADETS 1 WRI1007963 32.32 42.0748 0.9162 Hydro       1935.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 CARMA 1017225               88.68882676541028
20916 20916 ESP Spain TORAN WRI1007972 13.12 42.2312 -7.8303 Hydro       1963.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 CARMA 1029330               36.002395023582395
20938 20938 ESP Spain VIELHA 1 WRI1008028 21.86 42.702 0.7956 Hydro       1947.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 CARMA 1029331               59.98569780606029

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