global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
45 rows where country_long = "Russia", geolocation_source = "GEODB" and primary_fuel = "Gas" sorted by generation_gwh_2013
This data as json, CSV (advanced)
Suggested facets: other_fuel1, source
owner 20
- PJSC "Mosenergo" 6
- Samara branch of PJSC "T Plus" 5
- JSC INTER RAO-Electric Power Generation 4
- PJSC "Unipro" 4
- Orenburg Branch of PJSC "T Plus" 3
- PJSC "Fortum" 3
- Quandra 3
- Saratov Branch of PJSC "T Plus" 3
- PJSC "Enel Russia" 2
- PJSC "OGK-2" 2
- LLC "Bashkir Generation Company" 1
- Mosenergo (subsidiary of Gazprom) 1
- PJSC "TGC-2" 1
- Perm Branch of PJSC "T Plus" 1
- Sverdlovsk Branch of PJSC "T Plus" 1
- TOBOLSKAYA TPP 1
- Technoproexport 1
- Ulyanovsk branch of PJSC "T Plus" 1
- ZAO Nizhnevartovskaya GRES 1
- t+group 1
primary_fuel 1
- Gas · 45 ✖
country_long 1
- Russia · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19196 | 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 | 1623.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19211 | 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 | 744.42 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19231 | 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 | 5141.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19235 | 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 | 1447.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19236 | 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 | 3421.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19238 | 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 | 5044.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19239 | 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 | 7896.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19241 | 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 | 24960.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19244 | 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 | 2653.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19261 | 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 | 4953.06 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19262 | 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 | 3254.96 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19292 | 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 | 798.38 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19296 | 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 | 377.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19370 | 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 | 2324.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19389 | 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 | 1403.75 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19399 | 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 | 11383.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19412 | 19412 | RUS | Russia | Konakovskaya | WRI1003737 | 2520.0 | 56.741 | 36.7707 | Gas | Oil | 1965.0 | PJSC "Enel Russia" | EnergyBase (RUS) | https://energybase.ru/power-plant/Konakovskaya_TPP | GEODB | 1026620 | 11054.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
19471 | 19471 | RUS | Russia | Nevinnomysskya | WRI1003757 | 1530.2 | 44.6595 | 41.9294 | Gas | Oil | 1960.0 | PJSC "Enel Russia" | EnergyBase (RUS) | https://energybase.ru/power-plant/Nevinnomysskaya_TPP | GEODB | 6712.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19483 | 19483 | RUS | Russia | Nizhnevartovskaya | WRI1003761 | 2013.0 | 60.9758 | 76.9433 | Gas | 1993.0 | ZAO Nizhnevartovskaya GRES | EnergyBase (RUS) | https://energybase.ru/power-plant/Nizhnevartovsk_TPP | GEODB | 1026672 | 8830.5 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19491 | 19491 | RUS | Russia | Novo Sverdlovsk | WRI1003764 | 557.0 | 56.8397 | 60.841 | Gas | 1982.0 | Sverdlovsk Branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novo_Sverdlovsk_CHP | GEODB | 1026692|1030657 | 2443.41 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19497 | 19497 | RUS | Russia | Novokuibyshevsk HPP-1 | WRI1003772 | 482.0 | 53.1103 | 49.9204 | Gas | 1947.0 | Samara branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novokuibyshev_CHP-1 | GEODB | 2114.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19520 | 19520 | RUS | Russia | Orsk TPP-1 | WRI1003777 | 245.0 | 51.2408 | 58.4986 | Gas | Oil | 1938.0 | Orenburg Branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Orsk_CHP-1 | GEODB | 1074.75 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19528 | 19528 | RUS | Russia | Pechorskaya | WRI1003780 | 1060.0 | 65.1344 | 57.3156 | Gas | Oil | 1979.0 | JSC INTER RAO-Electric Power Generation | EnergyBase (RUS) | https://energybase.ru/power-plant/Pechorskaya_TPP | GEODB | 1028495 | 4649.94 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
19531 | 19531 | RUS | Russia | Perm HPP-13 | WRI1003782 | 543.7 | 57.9772 | 56.2561 | Gas | 1959.0 | Perm Branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Perm_CHP-13 | GEODB | 1047623|1047625 | 2385.06 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19532 | 19532 | RUS | Russia | Permskaya | WRI1003784 | 3363.0 | 58.4959 | 56.3471 | Gas | Oil | 1986.0 | JSC INTER RAO-Electric Power Generation | EnergyBase (RUS) | https://energybase.ru/power-plant/Permskaya_TPP | GEODB | 14752.6 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19546 | 19546 | RUS | Russia | Pskovskaya GRES | WRI1003788 | 440.0 | 57.5097 | 29.9694 | Gas | Oil | 1993.0 | PJSC "OGK-2" | EnergyBase (RUS) | https://energybase.ru/power-plant/Pskovskaya_TPP | GEODB | 1028497 | 1930.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
19564 | 19564 | RUS | Russia | Sakmarskaya TPP | WRI1003795 | 460.0 | 51.8433 | 55.0988 | Gas | 1969.0 | Orenburg Branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Sakmarskaya_TPP | GEODB | 1026727 | 2017.89 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19568 | 19568 | RUS | Russia | Samara TPP | WRI1003798 | 440.0 | 53.2514 | 50.2756 | Gas | 1971.0 | Samara branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Samara_CHP | GEODB | 1027921 | 1930.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19571 | 19571 | RUS | Russia | Saratov HPP-2 | WRI1003800 | 669.0 | 51.6239 | 46.0097 | Gas | 1955.0 | Saratov Branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Saratov_CHP-2 | GEODB | 1026732 | 2934.72 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19584 | 19584 | RUS | Russia | Shaturskaya GRES | WRI1003808 | 1493.0 | 55.5833 | 39.5611 | Gas | Biomass | 1923.0 | PJSC "Unipro" | EnergyBase (RUS) | https://energybase.ru/power-plant/Shaturskaya_TPP | GEODB | 6549.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19591 | 19591 | RUS | Russia | Smolensk TPP-2 | WRI1003813 | 275.0 | 47.2161 | 39.5794 | Gas | 1973.0 | Quandra | Quandra | http://www.quadra.ru/about/production_capacity/ | GEODB | 1026749 | 1206.35 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19593 | 19593 | RUS | Russia | Smolenskaya GRES | WRI1003814 | 630.0 | 55.6056 | 32.4139 | Gas | 1970.0 | PJSC "Unipro" | EnergyBase (RUS) | https://energybase.ru/power-plant/Smolenskaya_TPP | GEODB | 2763.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19604 | 19604 | RUS | Russia | Surgutskaya GRES-2 | WRI1003821 | 8865.0 | 61.2794 | 73.4889 | Gas | 1979.0 | PJSC "Unipro" | EnergyBase (RUS) | https://energybase.ru/power-plant/Surgutskaya_TPP-2 | GEODB | 38888.43 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19610 | 19610 | RUS | Russia | Syzran TPP | WRI1003823 | 372.4 | 53.0642 | 48.3994 | Gas | 1947.0 | Samara branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Syzranskaya_CHP | GEODB | 1026765 | 1633.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19616 | 19616 | RUS | Russia | TPP-1 | WRI1003834 | 313.0 | 54.8402 | 56.091 | Gas | 1955.0 | Quandra | Quandra | http://www.quadra.ru/about/production_capacity/ | GEODB | 1373.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19618 | 19618 | RUS | Russia | TPP-2 | WRI1003836 | 642.0 | 47.2161 | 39.5794 | Gas | 1957.0 | Quandra | Quandra | http://www.quadra.ru/about/production_capacity/ | GEODB | 2816.28 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19635 | 19635 | RUS | Russia | Tobolsk CHP | WRI1003829 | 878.3 | 58.2449 | 68.4453 | Gas | 1980.0 | TOBOLSKAYA TPP | EnergyBase (RUS) | https://energybase.ru/power-plant/Tobolsk_TEC | GEODB | 1026773 | 3852.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19650 | 19650 | RUS | Russia | Tyumen CHP-1 | WRI1003840 | 1417.0 | 57.0867 | 65.6269 | Gas | 1960.0 | PJSC "Fortum" | EnergyBase (RUS) | https://energybase.ru/power-plant/Tyumen_CHP-1 | GEODB | 1026782 | 6216.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19653 | 19653 | RUS | Russia | Ufimskaya TPP-2 | WRI1003842 | 929.0 | 54.9131 | 56.0719 | Gas | 1940.0 | LLC "Bashkir Generation Company" | EnergyBase (RUS) | https://energybase.ru/power-plant/Ufa_CHP-2 | GEODB | 4075.28 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19657 | 19657 | RUS | Russia | Ulyanovsk TPP-1 | WRI1003843 | 852.0 | 54.3472 | 48.625 | Gas | 1952.0 | Ulyanovsk branch of PJSC "T Plus" | EnergyBase (RUS) | https://energybase.ru/power-plant/Ulyanovsk_CHP-1 | GEODB | 3737.5 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19659 | 19659 | RUS | Russia | Urengoyskaya | WRI1003845 | 979.7 | 66.035 | 78.0838 | Gas | Oil | 2012.0 | Technoproexport | Technoproexport | Technoproexport (p.6-7) | GEODB | 4297.68 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19668 | 19668 | RUS | Russia | Verkhnetagilskaya | WRI1003849 | 1062.15 | 57.3556 | 59.9603 | Gas | 1955.0 | JSC INTER RAO-Electric Power Generation | EnergyBase (RUS) | https://energybase.ru/power-plant/Verhnetagilskaya_TPP | GEODB | 1030658 | 4659.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19684 | 19684 | RUS | Russia | Vologda CHP | WRI1003852 | 136.1 | 59.195 | 39.9389 | Gas | 2011.0 | PJSC "TGC-2" | EnergyBase (RUS) | https://energybase.ru/power-plant/Vologda_CHP | GEODB | 597.03 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19701 | 19701 | RUS | Russia | Yavinskaya GRES | WRI1003859 | 1025.0 | 59.3378 | 57.2461 | Gas | 1956.0 | PJSC "Unipro" | EnergyBase (RUS) | https://energybase.ru/power-plant/Yayvinskaya_TPP | GEODB | 1047629 | 4496.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19709 | 19709 | RUS | Russia | Yuzhnouralskaya 2 | WRI1003864 | 1591.5 | 54.4557 | 61.2325 | Gas | Oil | 2014.0 | JSC INTER RAO-Electric Power Generation | EnergyBase (RUS) | https://energybase.ru/power-plant/Yuzhnouralskaya_TPP-2 | GEODB | 6981.49 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");