global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
132 rows where country_long = "Switzerland" and geolocation_source = "CARMA"
This data as json, CSV (advanced)
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_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21338 | 21338 | CHE | Switzerland | Schaffhausen | WRI1004498 | 28.9 | 47.6973 | 8.6349 | Hydro | 1964.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1021318 | 110.89 | 102.4 | 100.77 | 94.24 | 96.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21339 | 21339 | CHE | Switzerland | Schlappin | WRI1004504 | 6.1 | 46.95 | 9.75 | Hydro | 1928.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1075003 | 19.42 | 20.51 | 19.17 | 19.05 | 23.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21340 | 21340 | CHE | Switzerland | Sedrun 1 | WRI1004512 | 150.0 | 46.6816 | 8.7786 | Hydro | 1968.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1021359 | 293.31 | 367.45 | 367.45 | 357.63 | 432.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21341 | 21341 | CHE | Switzerland | Sella | WRI1004515 | 1.93 | 46.5285 | 8.6088 | Hydro | 1991.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1051650 | 4.99 | 5.53 | 5.53 | 5.4 | 6.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21343 | 21343 | CHE | Switzerland | Siebnen | WRI1004521 | 51.52 | 47.1745 | 8.8978 | Hydro | 1926.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1009816 | 129.79 | 176.96 | 156.82 | 145.19 | 173.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21344 | 21344 | CHE | Switzerland | Soazza | WRI1004531 | 83.0 | 46.3659 | 9.2216 | Hydro | 1961.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1024671 | 218.92 | 232.79 | 232.79 | 227.44 | 267.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21345 | 21345 | CHE | Switzerland | Spiez | WRI1004537 | 18.66 | 46.6847 | 7.6911 | Hydro | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1011146 | 60.88 | 74.15 | 66.15 | 62.99 | 76.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21348 | 21348 | CHE | Switzerland | Stalvedro (AET) | WRI1004547 | 14.0 | 46.5136 | 8.6783 | Hydro | 1968.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1010589 | 32.34 | 36.22 | 36.22 | 35.31 | 41.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21349 | 21349 | CHE | Switzerland | Stampa | WRI1004549 | 5.0 | 46.0156 | 8.9453 | Hydro | 1926.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1009657 | 16.05 | 17.83 | 16.57 | 16.99 | 17.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21350 | 21350 | CHE | Switzerland | Stechelberg | WRI1004551 | 4.3 | 46.5431 | 7.9015 | Hydro | 1905.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016825 | 10.04 | 11.0 | 11.0 | 10.72 | 12.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21351 | 21351 | CHE | Switzerland | Strick | WRI1004555 | 1.22 | 47.2605 | 9.5027 | Hydro | 1912.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1075139 | 3.44 | 4.16 | 3.93 | 3.86 | 4.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21352 | 21352 | CHE | Switzerland | Sublin 1 | WRI1004557 | 10.61 | 46.2521 | 7.0114 | Hydro | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1017085 | 39.08 | 52.57 | 42.34 | 40.29 | 42.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21353 | 21353 | CHE | Switzerland | Tenero-Centrale di dotazione | WRI1004570 | 4.25 | 46.1814 | 8.851 | Hydro | 1972.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1066728 | 9.32 | 10.44 | 10.44 | 10.16 | 12.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21354 | 21354 | CHE | Switzerland | Thusis | WRI1004575 | 4.6 | 46.6972 | 9.4394 | Hydro | 1968.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1064052 | 14.99 | 17.09 | 16.21 | 15.92 | 17.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21355 | 21355 | CHE | Switzerland | Ticinetto | WRI1004576 | 2.9 | 46.4226 | 8.8431 | Hydro | 1907.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1052060 | 10.56 | 11.14 | 11.49 | 11.18 | 11.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21356 | 21356 | CHE | Switzerland | Tinizong | WRI1004583 | 69.5 | 46.5824 | 9.6173 | Hydro | 1954.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016813 | 183.86 | 217.05 | 187.87 | 183.02 | 218.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21357 | 21357 | CHE | Switzerland | Trempel | WRI1004590 | 1.8 | 47.2476 | 9.1705 | Hydro | 1925.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1075138 | 4.7 | 5.2 | 5.2 | 5.08 | 5.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21358 | 21358 | CHE | Switzerland | Turgi | WRI1004595 | 1.0 | 47.492 | 8.2541 | Hydro | 1902.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1100250 | 4.26 | 4.34 | 4.06 | 4.47 | 4.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21359 | 21359 | CHE | Switzerland | Turtmann | WRI1004597 | 23.9 | 46.3015 | 7.702 | Hydro | 1925.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1019356 | 60.82 | 67.14 | 67.14 | 65.59 | 77.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21360 | 21360 | CHE | Switzerland | Unteraa (Lungerersee) | WRI1004599 | 54.0 | 46.8333 | 8.1806 | Hydro | 1921.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016832 | 172.91 | 164.18 | 172.37 | 153.93 | 190.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21361 | 21361 | CHE | Switzerland | Unteraa (Melchaa) | WRI1004600 | 12.0 | 46.8333 | 8.1806 | Hydro | 2012.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016832 | 41.73 | 41.18 | 43.01 | 38.82 | 46.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21362 | 21362 | CHE | Switzerland | Valeis | WRI1004610 | 1.2 | 47.0326 | 9.4341 | Hydro | 1982.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016847 | 3.38 | 4.09 | 3.87 | 3.8 | 4.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21363 | 21363 | CHE | Switzerland | Verbano 1 | WRI1004612 | 119.0 | 46.1201 | 8.7118 | Hydro | 1953.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 315.28 | 356.62 | 334.04 | 332.68 | 382.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21365 | 21365 | CHE | Switzerland | Vernayaz (CFF) | WRI1004615 | 92.0 | 46.1367 | 7.0391 | Hydro | 1927.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1028278 | 283.69 | 384.27 | 302.99 | 285.05 | 303.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21366 | 21366 | CHE | Switzerland | Vissoie | WRI1004620 | 50.0 | 46.2163 | 7.5854 | Hydro | 1958.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1017097 | 130.65 | 151.39 | 145.39 | 142.19 | 151.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21367 | 21367 | CHE | Switzerland | Wernisberg | WRI1004634 | 20.4 | 47.011 | 8.6454 | Hydro | 1966.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016817 | 55.25 | 59.82 | 59.82 | 58.52 | 68.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21368 | 21368 | CHE | Switzerland | Wettingen | WRI1004635 | 25.35 | 47.4705 | 8.3164 | Hydro | 1933.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016814 | 86.26 | 96.57 | 81.65 | 91.88 | 97.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21369 | 21369 | CHE | Switzerland | Wettingen-Dotierzentrale | WRI1004636 | 2.1 | 47.4705 | 8.3164 | Hydro | 2007.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016814 | 8.76 | 9.37 | 8.35 | 9.23 | 9.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21370 | 21370 | CHE | Switzerland | Windisch | WRI1004642 | 1.59 | 47.479 | 8.2184 | Hydro | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1009812 | 5.38 | 6.41 | 5.97 | 5.61 | 5.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21371 | 21371 | CHE | Switzerland | Wolfenschiessen | WRI1004644 | 6.6 | 46.9032 | 8.3942 | Hydro | 1945.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1016829 | 21.37 | 23.02 | 21.69 | 23.28 | 27.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21372 | 21372 | CHE | Switzerland | Wynau | WRI1004648 | 12.0 | 47.2557 | 7.8163 | Hydro | 1996.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1015496 | 50.2 | 59.2 | 48.76 | 54.17 | 50.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21374 | 21374 | CHE | Switzerland | Zervreila | WRI1004651 | 22.0 | 46.6128 | 9.1779 | Hydro | 1958.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1021364 | 57.27 | 63.37 | 63.37 | 61.96 | 72.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
Advanced export
JSON shape: default, array, newline-delimited
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_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");