global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
34 rows where generation_gwh_2014 = "0.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2013, generation_gwh_2015
owner 27
- Metropolitan Water District of S CA 5
- Los Angeles Department of Water & Power 2
- Aclara Meters LLC 1
- California Dept. of Water Resources 1
- Capitol Broadcasting Company Inc 1
- Central Hudson Gas & Elec Corp 1
- Central Rivers Power MA LLC 1
- City & County of San Francisco 1
- City of Garland - (TX) 1
- City of Idaho Falls - (ID) 1
- City of Pasadena - (CA) 1
- Desert Water Agency 1
- Eagle Creek RE LLC 1
- Guadalupe Blanco River Authority 1
- Heber Light & Power Company 1
- Los Alamos County 1
- New York State Elec & Gas Corp 1
- Owyhee Irrigation District 1
- PacifiCorp 1
- Pacific Gas & Electric Co. 1
- Passaic Valley Water Comm 1
- Renewable World Energies LLC 1
- Salt River Project 1
- San Gabriel Valley Mun Wtr Dt 1
- Sugar River Power LLC 1
- Truckee-Carson Irrigation District 1
- Yolo County Flood Control WCD 1
country_long 2
primary_fuel 1
- Hydro · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14164 | 14164 | IND | India | BHAWANI KATTALAI -III | IND0000053 | 30.0 | 11.2428 | 77.8659 | Hydro | 2012.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1060506 | 2019 | 0.0 | 5.651599999999999 | 17.382649999999998 | 0.0 | 33.889700000000005 | Central Electricity Authority | 114.01 | 105.18 | 114.01 | 87.48 | 94.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14741 | 14741 | IND | India | KUTTIYADI Add ext | IND0000226 | 100.0 | 11.5484 | 75.8988 | Hydro | 2010.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1020768 | 2019 | 0.0 | 18.71595 | 150.7226 | 170.0853 | 268.91865 | Central Electricity Authority | 366.56 | 307.31 | 366.56 | 228.31 | 277.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
25257 | 25257 | USA | United States of America | Azusa | USA0006449 | 3.0 | 34.1548 | -117.9093 | Hydro | 1949.0 | City of Pasadena - (CA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29733 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 6.22 | 6.22 | 4.94 | 6.23 | 5.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26155 | 26155 | USA | United States of America | Canyon | USA0000791 | 6.0 | 29.8706 | -98.1947 | Hydro | 1989.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 63196 | 2019 | 0.0 | 0.0 | 12.21 | 19.26 | 13.489 | 4.479 | 12.6 | U.S. Energy Information Administration | 16.76 | 15.99 | 12.8 | 17.49 | 14.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26237 | 26237 | USA | United States of America | Castaic | USA0000392 | 1682.0 | 34.5872 | -118.6566 | Hydro | 1975.8668252080856 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25083 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 193.141 | U.S. Energy Information Administration | 4695.86 | 4540.07 | 4471.82 | 4552.51 | 2724.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26247 | 26247 | USA | United States of America | Cataract (MI) | USA0007118 | 2.0 | 46.3156 | -87.5128 | Hydro | 1988.0 | Renewable World Energies LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35494 | 2019 | 0.0 | 0.0 | 0.216 | 5.808 | 7.923 | 6.254 | 7.08 | U.S. Energy Information Administration | 6.79 | 8.17 | 8.18 | 7.89 | 6.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26302 | 26302 | USA | United States of America | Central Hudson High Falls | USA0000579 | 3.2 | 41.8288 | -74.1319 | Hydro | 1987.0 | Central Hudson Gas & Elec Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.524 | 0.0 | 0.0 | 0.147 | 2.863 | 7.62 | 8.002 | U.S. Energy Information Administration | 7.8 | 10.74 | 9.48 | 8.79 | 7.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27236 | 27236 | USA | United States of America | Dwight | USA0006378 | 1.2000000000000002 | 42.1495 | -72.6109 | Hydro | 1920.0 | Central Rivers Power MA LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36692 | 2019 | 3.283 | 0.0 | 0.0 | 1.557 | 3.828 | 6.37 | 5.198 | U.S. Energy Information Administration | 3.46 | 3.94 | 3.83 | 3.49 | 4.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27310 | 27310 | USA | United States of America | East Side | USA0003025 | 3.2 | 42.2248 | -121.7955 | Hydro | 1924.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29504 | 2019 | 0.0 | 0.0 | 0.002 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 11.86 | 12.23 | 9.63 | 13.23 | 10.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27376 | 27376 | USA | United States of America | El Vado Dam | USA0007593 | 8.0 | 36.5928 | -106.7321 | Hydro | 1988.0 | Los Alamos County | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25064 | 2019 | 14.429 | 0.0 | 0.0 | 0.0 | 18.194 | 1.598 | 33.062 | U.S. Energy Information Administration | 20.21 | 20.27 | 18.55 | 20.32 | 18.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27505 | 27505 | USA | United States of America | Etiwanda | USA0000745 | 23.9 | 34.1035 | -117.5257 | Hydro | 1995.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26172 | 2019 | 27.598 | 0.0 | 0.028 | 0.0 | 82.42 | 56.038 | 66.132 | U.S. Energy Information Administration | 69.16 | 69.16 | 60.82 | 69.35 | 59.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28026 | 28026 | USA | United States of America | General Electric Great Falls Upper Hydro | USA0010059 | 2.1 | 43.2597 | -70.8597 | Hydro | 1985.7142857142856 | Aclara Meters LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20854 | 2019 | 0.0 | 0.0 | U.S. Energy Information Administration | 6.02 | 6.06 | 7.06 | 5.9 | 5.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
28315 | 28315 | USA | United States of America | Greg Avenue | USA0006643 | 1.0 | 34.2079 | -118.3516 | Hydro | 1980.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26173 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 2.16 | 0.0 | 0.0 | U.S. Energy Information Administration | 2.14 | 2.36 | 1.87 | 2.37 | 2.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28891 | 28891 | USA | United States of America | Indian Valley Dam Hydro Project | USA0050129 | 2.9 | 39.0788 | -122.5356 | Hydro | 1983.0 | Yolo County Flood Control WCD | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23001 | 2019 | 5.463 | 0.0 | 1.555 | 1.91 | 3.6 | 3.477 | 8.285 | U.S. Energy Information Administration | 8.31 | 9.27 | 8.35 | 10.24 | 9.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29278 | 29278 | USA | United States of America | Kerckhoff | USA0000250 | 22.6 | 37.0925 | -119.5528 | Hydro | 1920.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29398 | 2019 | 15.989 | 0.0 | 5.495 | 44.863 | 73.232 | 0.0 | U.S. Energy Information Administration | 76.27 | 61.17 | 52.75 | 75.34 | 73.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29447 | 29447 | USA | United States of America | Lahontan | USA0006521 | 1.7999999999999998 | 39.4625 | -119.0667 | Hydro | 1911.0 | Truckee-Carson Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34072 | 2019 | 3.6 | 0.0 | 0.107 | 2.183 | 8.790000000000001 | 4.4190000000000005 | 8.278 | U.S. Energy Information Administration | 5.29 | 5.4 | 5.35 | 5.62 | 4.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29617 | 29617 | USA | United States of America | Lewisville | USA0000794 | 2.8 | 33.0685 | -96.9638 | Hydro | 1992.0 | City of Garland - (TX) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18286 | 2019 | 0.0 | 0.0 | 0.746 | 3.403 | 8.186 | 4.812 | 7.797000000000001 | U.S. Energy Information Administration | 8.62 | 8.58 | 8.52 | 10.04 | 7.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29790 | 29790 | USA | United States of America | Lower No 2 | USA0000843 | 3.0 | 43.4684 | -112.0626 | Hydro | 1940.0 | City of Idaho Falls - (ID) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.453 | 11.644 | 12.035 | 8.602 | U.S. Energy Information Administration | 11.17 | 11.42 | 9.55 | 11.52 | 11.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29795 | 29795 | USA | United States of America | Lower Village Water Power Project | USA0050285 | 1.2 | 43.3743 | -72.3476 | Hydro | 1995.0 | Sugar River Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 50281 | 2019 | 0.0 | 0.0 | 0.0 | 2.007 | 6.186 | 5.695 | U.S. Energy Information Administration | 2.64 | 3.46 | 3.35 | 3.41 | 2.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30319 | 30319 | USA | United States of America | Moccasin Low Head Hydro Project | USA0000751 | 2.9 | 37.8164 | -120.312 | Hydro | 1987.0 | City & County of San Francisco | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22075 | 2019 | 2.707 | 0.0 | 0.0 | 1.359 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 10.36 | 11.27 | 10.39 | 10.59 | 11.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30788 | 30788 | USA | United States of America | North Hollywood | USA0057854 | 9.0 | 34.1944 | -118.3903 | Hydro | 1993.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.92 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 23.71 | 22.2 | 18.42 | 22.28 | 21.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31275 | 31275 | USA | United States of America | Passaic Valley Water Commission | USA0050311 | 2.4 | 40.8833 | -74.23 | Hydro | 1935.0 | Passaic Valley Water Comm | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 7.75 | 8.76 | 7.33 | 7.62 | 6.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
31363 | 31363 | USA | United States of America | Perris | USA0000481 | 7.9 | 33.8361 | -117.1831 | Hydro | 1983.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26175 | 2019 | 0.001 | 0.0 | 0.032 | 4.497 | 31.91 | 14.812 | 10.52469 | U.S. Energy Information Administration | 20.67 | 20.67 | 19.15 | 20.72 | 18.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31786 | 31786 | USA | United States of America | Rainbow Falls Auscble | USA0006526 | 2.6 | 44.5236 | -73.4617 | Hydro | 1926.5 | New York State Elec & Gas Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27601 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.113 | U.S. Energy Information Administration | 8.88 | 10.02 | 9.34 | 9.86 | 8.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31892 | 31892 | USA | United States of America | Reusens | USA0003779 | 12.5 | 37.4639 | -79.1856 | Hydro | 1903.0 | Eagle Creek RE LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13363 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 2.598 | 29.174 | 15.756 | U.S. Energy Information Administration | 44.81 | 51.91 | 38.91 | 52.05 | 45.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32045 | 32045 | USA | United States of America | Rocky Mount Mill | USA0050468 | 1.6 | 35.9601 | -77.8024 | Hydro | 1946.5 | Capitol Broadcasting Company Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 66542 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 5.07 | 5.48 | 4.93 | 5.95 | 4.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
32293 | 32293 | USA | United States of America | San Dimas Wash Generating Station | USA0050233 | 1.0 | 34.1242 | -117.8051 | Hydro | 1986.0 | San Gabriel Valley Mun Wtr Dt | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26178 | 2019 | 0.0 | 0.0 | 0.0 | 1.495 | 0.377 | 1.192 | 3.021 | U.S. Energy Information Administration | 2.22 | 2.44 | 2.34 | 2.23 | 2.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32455 | 32455 | USA | United States of America | Sepulveda Canyon | USA0000316 | 8.5 | 34.0969 | -118.4795 | Hydro | 1982.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26179 | 2019 | 0.0 | 0.0 | 0.0 | 4.312 | 21.77 | 0.0 | 12.665 | U.S. Energy Information Administration | 22.18 | 22.18 | 17.18 | 22.24 | 19.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32649 | 32649 | USA | United States of America | Snake Creek | USA0003658 | 1.2 | 40.5449 | -111.5029 | Hydro | 1910.0 | Heber Light & Power Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21973 | 2019 | 0.0 | 0.0 | 2.192 | 2.401 | 4.01 | 4.978 | 5.011 | U.S. Energy Information Administration | 2.92 | 3.2 | 2.85 | 3.21 | 2.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32757 | 32757 | USA | United States of America | South Consolidated | USA0000100 | 1.4 | 33.4665 | -111.7811 | Hydro | 1981.0 | Salt River Project | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31952 | 2019 | -0.095 | 0.0 | 0.5700000000000001 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 1.88 | 1.98 | 2.47 | 2.17 | 2.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33346 | 33346 | USA | United States of America | Thermalito | USA0000438 | 115.1 | 39.5149 | -121.6301 | Hydro | 1968.0 | California Dept. of Water Resources | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15335 | 2019 | 0.0 | 0.0 | U.S. Energy Information Administration | 406.21 | 409.42 | 353.33 | 446.05 | 396.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
33521 | 33521 | USA | United States of America | Tunnel 1 Power Project | USA0050362 | 7.0 | 43.642 | -117.2327 | Hydro | 1993.0 | Owyhee Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.018 | 0.0 | 0.0 | 10.561 | 22.861 | 16.369 | 22.316 | U.S. Energy Information Administration | 20.32 | 20.47 | 20.46 | 24.59 | 20.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33778 | 33778 | USA | United States of America | Venice Hydro | USA0000072 | 10.1 | 34.0114 | -118.4168 | Hydro | 1982.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26182 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 2.225 | 0.0 | 0.0 | U.S. Energy Information Administration | 26.35 | 26.35 | 19.6 | 26.42 | 23.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34283 | 34283 | USA | United States of America | Whitewater Hydro Plant | USA0010162 | 1.3 | 33.9347 | -116.6405 | Hydro | 1986.0 | Desert Water Agency | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.631 | 0.0 | 0.0 | 1.9 | 7.176 | 2.827 | 4.005 | U.S. Energy Information Administration | 3.0 | 3.02 | 3.08 | 3.03 | 2.56 | 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");