global-power-plants

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

545 rows where country_long = "Russia" sorted by gppd_idnr

View and edit SQL

Suggested facets: other_fuel1, source, geolocation_source

primary_fuel

country_long

  • Russia · 545
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
19367 RUS Russia Isyangulovo WKS0065422 9.0 52.171 56.518 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.7128583323420956
19547 RUS Russia Pugachyovsky WKS0068463 15.0 52.125 48.74 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19442 RUS Russia Machatschkala WKS0069841 4.0 43.019 47.458 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.7612703699298204
19445 RUS Russia Maima WKS0070135 20.0 51.948 85.832 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 3.8063518496491016
19513 RUS Russia Onguday WKS0070136 5.0 50.769 86.115 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19519 RUS Russia Orlov-Gay WKS0070953 5.0 50.94 47.88 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19288 RUS Russia Elista East WKS0071398 15.0 46.36 44.315 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19290 RUS Russia Elista West WKS0071399 15.0 46.265 43.97 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19289 RUS Russia Elista North WKS0071400 15.0 46.51 44.2 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19454 RUS Russia Mikhailovskaya WKS0071403 15.0 50.215 43.1 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19276 RUS Russia Derzhavinskaya WKS0071405 5.0 53.2 52.33 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19253 RUS Russia Caspian WKS0071406 5.0 44.46 46.465 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19353 RUS Russia Hunzah 1 WKS0071407 5.0 42.55 46.775 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19556 RUS Russia Rudnik WKS0071408 15.0 50.74 37.435 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19554 RUS Russia Rubber WKS0071411 15.0 47.345 47.48 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19682 RUS Russia Volodarovka CI WKS0071412 15.0 46.42 48.405 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19202 RUS Russia Baymak WKS0071413 10.0 52.605 58.055 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19450 RUS Russia Matraevskaya WKS0071415 5.0 54.36 56.165 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19293 RUS Russia Enotaevka WKS0071416 15.0 47.26 47.026 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19683 RUS Russia Volodarovka MRTS WKS0071418 15.0 46.44 48.645 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19180 RUS Russia Akjar Hevel WKS0071420 5.0 51.945 58.195 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19704 RUS Russia Yuldybaevskaya WKS0071421 10.0 52.295 57.945 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19181 RUS Russia Aleksandrovskaya WKS0071425 10.0 44.78 43.055 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19517 RUS Russia Orenburg SES-5 WKS0071426 10.0 51.49 59.41 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19264 RUS Russia Chesmenskaya WKS0071434 15.0 53.485 60.435 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19200 RUS Russia Bashkir SES-5 WKS0071435 10.0 54.355 56.785 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19218 RUS Russia Borodinovskaya WKS0071436 15.0 53.48 60.765 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19518 RUS Russia Orenburg SES-6 WKS0071438 15.0 51.48 59.4 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19197 RUS Russia Balei WKS0071442 15.0 51.54 116.655 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19378 RUS Russia Kabanskaya WKS0071447 15.0 52.125 106.52 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19193 RUS Russia BVS WKS0071448 15.0 53.935 110.14 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19516 RUS Russia Orenburg 3T WKS0071455 60.0 51.13 55.49 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.419055548947306
19515 RUS Russia Orenburg 1T WKS0071460 45.0 51.14 55.49 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 8.564291661710481
19179 RUS Russia Akhtubinsky  WKS0073286 60.0 48.405 46.235 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.419055548947306
19507 RUS Russia Novouzenskaya WKS0073843 15.0 50.477 48.176 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.8547638872368264
19567 RUS Russia Samara SS WKS0073849 61.5 53.017 49.814 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 11.704531937670989
19201 RUS Russia Bashkir SES-6 WKS0073856 5.0 54.255 56.785 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9515879624122754
19291 RUS Russia Elshan WKS0073858 25.0 51.324 55.031 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 4.757939812061377
19356 RUS Russia Ininskaya WKS0073861 10.0 51.974 85.856 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 1.9031759248245508
19225 RUS Russia Buribay 3 WKS0073865 25.0 54.355 56.785 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 4.757939812061377
19182 RUS Russia Amurskaya CHPP WRI1003656 285.0 50.2274 136.8821 Gas Oil       JSC "FAR EASTERN GK" (JSC "DGK") EnergyBase (RUS) https://energybase.ru/power-plant/Amur_CHP-1 EnergyBase (RUS)                 1500.9689586562185
19183 RUS Russia Anadyr CHPP WRI1003657 50.0 64.7305 177.4995 Gas         JSC "Chukotenergo" EnergyBase (RUS) https://energybase.ru/power-plant/Anadyr_CHP CARMA 1022163               263.32788748354716
19185 RUS Russia Argayash CHP WRI1003659 195.0 55.6389 60.7786 Coal       1954.0 PJSC "Fortum" EnergyBase (RUS) https://energybase.ru/power-plant/Argayashskaya_CHP GEODB 1012146               679.3419993115338
19187 RUS Russia Arkhangelsk CHPP WRI1003660 450.0 64.5753 40.5731 Gas       1970.0 PJSC "TGC-2" EnergyBase (RUS) https://energybase.ru/power-plant/Arkhangelsk_CHP WRI 1055999               2369.950987351924
19188 RUS Russia Artyomovskaya CHPP WRI1003661 400.0 43.3714 132.305 Gas         JSC "FAR EASTERN GK" (JSC "DGK") EnergyBase (RUS) https://energybase.ru/power-plant/Artemovskaya_CHP EnergyBase (RUS)                 2106.6230998683773
19196 RUS Russia Balakovo TPP-4 WRI1003662 370.0 51.9756 47.7833 Gas       1962.0 Saratov Branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Balakovo_CHP-4 GEODB                 1948.626367378249
19203 RUS Russia Belgorod TPP (thermal power plant) WRI1003664 60.0 50.6 36.6186 Gas       1938.0 PJSC "Quadra - Power Generation" EnergyBase (RUS) https://energybase.ru/power-plant/Belgorod_CHP CARMA 1026538               315.9934649802565
19206 RUS Russia Beloyarsk WRI1003666 1480.0 56.8417 61.3225 Nuclear       1964.0 Rosatom IAEA http://www.rosenergoatom.ru/wps/wcm/connect/rosenergoatom_copy/site_en/NPP/ CARMA 1022694               9497.3146833286
19207 RUS Russia Berezniki CHPP-10 WRI1003667 27.0 53.5097 45.3184 Gas       1953.0 t+group t+group http://www.tplusgroup.ru/org/perm/organization/bereznikovskaja-chp10/ CARMA 1047119               142.19705924111543
19208 RUS Russia Berezniki CHPP-2 WRI1003668 127.2 59.4069 56.7358 Gas       1947.0 Perm Branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Bereznikovskaya_CHP-2 CARMA 1026555               669.9061457581438
19210 RUS Russia Berezovskaya GRES WRI1003669 2400.0 55.5794 89.0725 Coal       1979.0 PJSC "Unipro" EnergyBase (RUS) https://energybase.ru/power-plant/Berezovskaya_TPP-1 GEODB 1041600               8361.132299218878
19211 RUS Russia Bezymyanskaya CHP WRI1003670 169.7 53.1992 50.2944 Gas       1941.0 Samara branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Bezimyanskaya_CHP GEODB 1026542               893.734850119159
19213 RUS Russia Bilibino WRI1003671 48.0 68.0503 166.5389 Nuclear         JSC "Concern Rosenergoatom" EnergyBase (RUS) https://energybase.ru/power-plant/Bilibino_NPP GEODB 1022695               308.02101675660333
19216 RUS Russia Boguchanskaya HPP WRI1003673 2997.0 58.6944 99.1489 Hydro       2012.0 PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/Boguchanskaya_HPP GEODB 1011182               11644.545050562125
19219 RUS Russia Bratsk HPP WRI1003674 4500.0 56.2861 101.7842 Hydro         PJSC "IRKUTSKENERGO" EnergyBase (RUS) https://energybase.ru/power-plant/Bratsk_HPP WRI 1026549               17484.301877720907
19226 RUS Russia Byreyskaya HPP WRI1003675 2010.0 50.27 130.3136 Hydro         PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/Bureyskaya_HPP WRI 1033821               7809.65483871534
19259 RUS Russia Cheboksarskaya HPP WRI1003679 1370.0 56.1373 47.4661 Hydro       1968.0 PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/Cheboksary_HPP GEODB 1012464               5322.998571661698
19260 RUS Russia Cheboksary CHPP=2 WRI1003680 460.0 56.126 47.2996 Gas       1979.0 Branch of Mari El and Chuvashia PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Cheboksary_CHP-2 WRI 1012466               2422.616564848633
19261 RUS Russia Chelyabinsk CHP-1 WRI1003681 1129.1 55.23 61.4908 Gas       1942.0 PJSC "Fortum" EnergyBase (RUS) https://energybase.ru/power-plant/Chelyabinsk_CHP-1 GEODB 1012147|1012149               5946.47035515346
19262 RUS Russia Chelyabinsk GRES WRI1003682 742.0 55.2014 61.4031 Gas       1930.0 PJSC "Fortum" EnergyBase (RUS) https://energybase.ru/power-plant/Chelyabinsk_TPP GEODB 1066928               3907.7858502558393
19263 RUS Russia Cherepetskaya GRES WRI1003683 450.0 54.136 36.48 Coal       1953.0 Inter RAO Inter RAO http://irao-generation.com/en/stations/ GEODB                 1567.7123061035395
19231 RUS Russia CHP Volga Car WRI1003685 1172.0 53.575 49.2453 Gas       1967.0 Samara branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/CHP_VAZ GEODB                 6172.405682614344
19235 RUS Russia CHP-11 (MJ Ufaev) WRI1003686 330.0 55.7528 37.7303 Gas       1936.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-11 GEODB                 1737.9640573914112
19236 RUS Russia CHP-16 WRI1003687 780.0 55.7833 37.5022 Gas       1955.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-16 GEODB                 4107.915044743336
19237 RUS Russia CHP-17 WRI1003688 192.0 54.9028 38.055 Coal       1950.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-17 GEODB                 668.8905839375102
19238 RUS Russia CHP-20 WRI1003689 1150.0 55.7001 37.586 Gas Oil     1952.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-20 GEODB                 6056.5414121215845
19239 RUS Russia CHP-21 WRI1003690 1800.0 55.8947 37.5107 Gas       1963.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-21 GEODB                 9479.803949407697
19240 RUS Russia CHP-22 WRI1003691 1310.0 55.6341 37.8173 Coal       1960.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-22 GEODB                 4563.784713323637
19241 RUS Russia CHP-23 WRI1003692 5690.0 55.9162 37.6879 Gas Oil     1966.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-23 GEODB                 29966.713595627665
19244 RUS Russia CHP-8 WRI1003693 605.0 55.7242 37.6966 Gas       1930.0 PJSC "Mosenergo" EnergyBase (RUS) https://energybase.ru/power-plant/CHP-8 GEODB                 3186.2674385509204
19272 RUS Russia Dagestan Branch WRI1003695 1786.0 46.8712 46.8712 Hydro         RusHydro RusHydro http://www.eng.rushydro.ru/company_geography/ WRI                 6939.325145246565
19273 RUS Russia Dankov TPP WRI1003696 10.0 53.2561 39.1642 Gas       1961.0 PJSC "Quadra - Power Generation" EnergyBase (RUS) https://energybase.ru/power-plant/Dankovskaya_CHP EnergyBase (RUS)                 52.66557749670943
19282 RUS Russia Dzerzhinsk TPP WRI1003698 580.0 56.2336 43.5208 Gas       1961.0 Nizhny Novgorod branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Dzerzhinsk_CHP WRI 1024119               3054.603494809147
19283 RUS Russia Dzhubginskaya WRI1003699 198.0 44.4388 38.7636 Gas       2013.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Dzhubginskaya_TPP EnergyBase (RUS)                 1042.7784344348463
19284 RUS Russia Efremov TPP WRI1003700 160.0 53.1573 38.1179 Gas       1931.0 PJSC "Quadra - Power Generation" EnergyBase (RUS) https://energybase.ru/power-plant/Efremovskaya_CHP EnergyBase (RUS)                 842.6492399473508
19287 RUS Russia Egvenkinotskaya TPP WRI1003701 34.0 66.4013 -179.1338 Gas         JSC "Chukotenergo" EnergyBase (RUS) https://energybase.ru/power-plant/Egvekinotskaya_TPP EnergyBase (RUS)                 179.06296348881202
19292 RUS Russia Engels TPP-3 WRI1003703 182.0 51.4603 46.1537 Gas       1958.0 Saratov Branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Engels_CHP-3 GEODB                 958.5135104401116
19296 RUS Russia GES-1 (PG Smidovich) WRI1003704 86.0 55.7481 37.6302 Gas         Mosenergo (subsidiary of Gazprom) Mosenergo https://web.archive.org/web/20160314015543/http://www.mosenergo.ru/catalog/228.aspx GEODB 1064822|1028497               452.92396647170114
19315 RUS Russia GT-TPP (gas turbine TPP) "Luch" WRI1003705 60.0 50.5609 36.5806 Gas       2005.0 PJSC "Quadra - Power Generation" EnergyBase (RUS) https://energybase.ru/power-plant/GTU_CHP_BEAM CARMA 1059861               315.9934649802565
19343 RUS Russia Gubkin TPP WRI1003707 29.0 51.2809 37.5784 Gas       1954.0 PJSC "Quadra - Power Generation" EnergyBase (RUS) https://energybase.ru/power-plant/Gubkinskaya_CHP CARMA                 152.7301747404573
19346 RUS Russia Gusinoozyorskaya WRI1003708 1160.0 51.3008 106.4833 Coal Oil     1976.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Gusinoozerskaya_TPP WRI 1026578               4041.213944622458
19355 RUS Russia Ikustsk WRI1003710 662.4 52.2367 104.3217 Hydro       1958.0 PJSC "IRKUTSKENERGO" EnergyBase (RUS) https://energybase.ru/power-plant/Irkutsk_HPP WRI                 2573.689236400517
19360 RUS Russia Iriklinskaya WRI1003711 2444.0 51.754 58.8033 Gas Oil     1970.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Iriklinskaya_TPP WRI 1026587               12871.467140195784
19370 RUS Russia Ivanovskaya CHPP-3 WRI1003712 530.0 56.9907 41.0113 Gas       1974.0 t+group t+group http://www.tplusgroup.ru/org/ivanovo/key-figure/ GEODB                 2791.2756073256
19371 RUS Russia Ivanovskiye WRI1003713 325.0 57.0231 40.3848 Gas Oil     2008.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Ivanovo_CCPF EnergyBase (RUS)                 1711.6312686430567
19373 RUS Russia Izhevsk HPP-1 WRI1003714 681.0 56.8936 53.3404 Gas         t+group t+group http://www.tplusgroup.ru/org/udmurtia/organization/izhevskaja-chp2/ WRI 1026591               3586.525827525912
19381 RUS Russia Kaliningradskaya WRI1003716 900.0 54.6619 20.5908 Gas Oil     2018.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Kaliningrad_CHP-2 WRI 1047146               4739.901974703848
19382 RUS Russia Kalinn NPP WRI1003717 4000.0 57.905 35.0614 Nuclear         JSC "Concern Rosenergoatom" EnergyBase (RUS) https://energybase.ru/power-plant/Kalinin_NPP WRI 1022699               25668.418063050267
19387 RUS Russia Kamskaya HPP WRI1003720 543.0 58.1146 56.3289 Hydro       1949.0 PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/Kamskaya_HPP GEODB 1025389               2109.7724265783227
19374 RUS Russia KANSK CHP WRI1003721 24.0 56.2292 95.6961 Coal       1953.0 JSC "Yenisei TGC (TGC-13)" EnergyBase (RUS) https://energybase.ru/power-plant/Kan_CHP CARMA 1026600               83.61132299218878
19389 RUS Russia Kargalinskaya WRI1003723 320.0 51.8661 54.7741 Gas       1973.0 Orenburg Branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Kargalin_CHP GEODB                 1685.2984798947016
19390 RUS Russia Karmanovskaya TPP WRI1003724 1831.0 56.2486 54.5882 Gas       1968.0 LLC "Bashkir Generation Company" EnergyBase (RUS) https://energybase.ru/power-plant/Karmanovskaia_TPP WRI                  
19375 RUS Russia KEMEROVO GRES WRI1003725 485.0 55.3674 86.0684 Coal       1934.0 LLC "Siberian Generating Company" EnergyBase (RUS) https://energybase.ru/power-plant/Kemerovo_TPP WRI 1026609               1689.645485467148
19395 RUS Russia Kemerovo thermal power station WRI1003726 80.0 55.3333 86.0833 Coal       1940.0 Kuzbassenergo Kuzbassenergo http://sibgenco.ru/about/activity/electric-power-generation/ CARMA                 278.7044099739626
19398 RUS Russia Kharanorskaya WRI1003728 655.0 50.8539 115.7 Coal Oil     1995.0 JSC INTER RAO-Electric Power Generation EnergyBase (RUS) https://energybase.ru/power-plant/Kharanorskaya_TPP GEODB 1012223               2281.8923566618187
19399 RUS Russia Kirishskaya GRES WRI1003729 2595.0 59.4892 32.0503 Gas Oil       PJSC "OGK-2" EnergyBase (RUS) https://energybase.ru/power-plant/Kirishskaya_TPP GEODB                  
19400 RUS Russia Kirov CHPP-3 WRI1003730 385.0 58.621 49.5944 Coal       1942.0 t+group t+group http://www.tplusgroup.ru/org/kirov/organization/kirovskaja-chp4/ GEODB 1047091               1341.264972999695
19403 RUS Russia Kirov TPP-5 WRI1003731 450.0 58.5495 49.5833 Coal       1980.0 Kirov branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Kirov_CHP-5 GEODB 1047093               1567.7123061035395
19408 RUS Russia Kola NPP WRI1003733 1760.0 67.4667 32.4667 Nuclear         JSC "Concern Rosenergoatom" EnergyBase (RUS) https://energybase.ru/power-plant/Kola_NPP GEODB 1022700               11294.10394774212
19409 RUS Russia Kolymskaya HPP WRI1003734 900.0 62.0583 150.4167 Hydro         PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/Kolyma_HPP WRI                 3496.8603755441823

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