global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where country_long = "United States of America", owner = "PacifiCorp", primary_fuel = "Hydro" and url = "http://www.eia.gov/electricity/data/browser/"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, commissioning_year
primary_fuel 1
- Hydro · 36 ✖
owner 1
- PacifiCorp · 36 ✖
country_long 1
- United States of America · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25190 | 25190 | USA | United States of America | Ashton | USA0000825 | 6.7 | 44.0786 | -111.4973 | Hydro | 1921.7761194029847 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29484 | 2019 | 34.536 | 32.826 | 29.969 | 28.779 | 36.863 | 38.064 | 39.649 | U.S. Energy Information Administration | 21.86 | 23.23 | 20.19 | 24.54 | 24.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25476 | 25476 | USA | United States of America | Bend | USA0006484 | 1.1 | 44.0623 | -121.3133 | Hydro | 1916.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29487 | 2019 | 1.925 | 2.498 | 2.396 | 1.958 | 2.295 | 1.448 | 1.559 | U.S. Energy Information Administration | 4.45 | 4.04 | 4.34 | 4.1 | 3.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25542 | 25542 | USA | United States of America | Big Fork | USA0006459 | 4.1 | 48.0592 | -114.0708 | Hydro | 1924.5121951219517 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29486 | 2019 | 30.165 | 31.24 | 26.515 | 29.483 | 21.447 | 26.132 | 27.204 | U.S. Energy Information Administration | 16.38 | 17.26 | 16.34 | 17.11 | 15.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26503 | 26503 | USA | United States of America | Clearwater 1 | USA0003020 | 15.0 | 43.2512 | -122.3379 | Hydro | 1953.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29491 | 2019 | 37.778 | 41.246 | 31.575 | 40.459 | 49.392 | 40.494 | 26.356 | U.S. Energy Information Administration | 37.93 | 37.93 | 34.04 | 38.03 | 32.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26504 | 26504 | USA | United States of America | Clearwater 2 | USA0003021 | 26.0 | 43.2669 | -122.4098 | Hydro | 1953.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29491 | 2019 | 39.381 | 44.892 | 32.142 | 45.439 | 67.71900000000001 | 36.927 | 35.821 | U.S. Energy Information Administration | 86.86 | 87.49 | 68.71 | 91.66 | 73.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26661 | 26661 | USA | United States of America | Copco 1 | USA0000294 | 20.0 | 41.9789 | -122.3353 | Hydro | 1918.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 67.577 | 65.39 | 60.539 | 80.964 | 107.722 | 73.916 | 85.84100000000001 | U.S. Energy Information Administration | 77.12 | 78.35 | 56.28 | 86.25 | 69.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26662 | 26662 | USA | United States of America | Copco 2 | USA0000295 | 27.0 | 41.9757 | -122.3581 | Hydro | 1925.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 83.609 | 86.43900000000001 | 77.098 | 104.792 | 138.29 | 92.72 | 108.585 | U.S. Energy Information Administration | 96.14 | 95.8 | 66.19 | 102.94 | 83.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26863 | 26863 | USA | United States of America | Cutler Hydro | USA0003646 | 30.0 | 41.8347 | -112.0521 | Hydro | 1927.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29499 | 2019 | 31.877 | 40.61 | 35.726 | 64.221 | 147.609 | 69.76 | 90.186 | U.S. Energy Information Administration | 95.38 | 93.14 | 69.88 | 102.39 | 89.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27280 | 27280 | USA | United States of America | Eagle Point | USA0003024 | 2.8 | 42.5146 | -122.7571 | Hydro | 1957.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29502 | 2019 | 16.334 | 16.187 | 16.857 | 18.526 | 18.371 | 16.411 | 16.812 | U.S. Energy Information Administration | 9.73 | 10.01 | 10.39 | 11.08 | 9.17 | 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 | |||
27591 | 27591 | USA | United States of America | Fall Creek | USA0000296 | 2.1 | 41.9856 | -122.3605 | Hydro | 1907.7619047619048 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29505 | 2019 | 9.864 | 7.396 | 9.699 | 10.146 | 7.872 | 3.931 | 6.046 | U.S. Energy Information Administration | 8.25 | 8.26 | 6.84 | 9.14 | 7.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27661 | 27661 | USA | United States of America | Fish Creek | USA0003026 | 11.0 | 43.2742 | -122.449 | Hydro | 1952.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29506 | 2019 | 15.766 | 24.132 | 7.941 | 34.839 | 42.304 | 14.758 | 20.911 | U.S. Energy Information Administration | 39.79 | 40.94 | 34.64 | 43.06 | 35.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28176 | 28176 | USA | United States of America | Grace | USA0000827 | 33.0 | 42.5367 | -111.794 | Hydro | 1923.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29508 | 2019 | 70.991 | 56.069 | 63.251000000000005 | 78.074 | 162.133 | 123.892 | 80.378 | U.S. Energy Information Administration | 106.44 | 104.92 | 75.53 | 102.46 | 101.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28214 | 28214 | USA | United States of America | Granite | USA0003651 | 2.0 | 40.6192 | -111.7821 | Hydro | 1896.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29510 | 2019 | 5.671 | 6.05 | 5.516 | 6.219 | 7.476 | 5.36 | 6.719 | U.S. Energy Information Administration | 5.91 | 6.41 | 5.98 | 6.43 | 5.85 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28986 | 28986 | USA | United States of America | Iron Gate | USA0000297 | 18.0 | 41.933 | -122.4368 | Hydro | 1962.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29516 | 2019 | 85.349 | 85.55 | 82.043 | 100.752 | 108.851 | 88.987 | 101.368 | U.S. Energy Information Administration | 46.75 | 46.75 | 41.85 | 46.88 | 40.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29102 | 29102 | USA | United States of America | John C Boyle | USA0003028 | 98.7 | 42.0936 | -122.0703 | Hydro | 1958.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29513 | 2019 | 166.834 | 172.588 | 160.121 | 214.776 | 318.732 | 194.05 | 228.036 | U.S. Energy Information Administration | 352.18 | 356.57 | 252.28 | 377.05 | 307.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29547 | 29547 | USA | United States of America | Last Chance | USA0000987 | 1.7 | 42.6033 | -111.7053 | Hydro | 1984.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29521 | 2019 | 3.257 | 3.094 | 1.929 | 1.162 | 3.725 | 4.553 | 4.695 | U.S. Energy Information Administration | 5.86 | 4.96 | 4.28 | 4.69 | 4.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29593 | 29593 | USA | United States of America | Lemolo 1 | USA0003029 | 32.0 | 43.3558 | -122.2494 | Hydro | 1955.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 123.888 | 140.861 | 123.55 | 134.067 | 174.923 | 124.864 | 114.477 | U.S. Energy Information Administration | 106.21 | 106.98 | 83.87 | 112.11 | 89.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29594 | 29594 | USA | United States of America | Lemolo 2 | USA0006421 | 38.5 | 43.2806 | -122.4025 | Hydro | 1956.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 150.001 | 173.729 | 136.64 | 146.665 | 200.914 | 133.034 | 143.451 | U.S. Energy Information Administration | 127.78 | 128.71 | 100.91 | 134.88 | 107.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30155 | 30155 | USA | United States of America | Merwin | USA0003847 | 136.0 | 45.9567 | -122.5544 | Hydro | 1946.5514705882356 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29525 | 2019 | 460.852 | 579.582 | 398.837 | 560.116 | 629.623 | 450.459 | 337.034 | U.S. Energy Information Administration | 420.88 | 468.42 | 371.14 | 435.71 | 393.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30987 | 30987 | USA | United States of America | Oneida | USA0000829 | 30.0 | 42.2678 | -111.7485 | Hydro | 1917.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29529 | 2019 | 28.182 | 21.691 | 28.864 | 39.854 | 94.117 | 61.899 | 51.274 | U.S. Energy Information Administration | 105.0 | 94.47 | 65.39 | 94.4 | 89.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31454 | 31454 | USA | United States of America | Pioneer | USA0003656 | 5.0 | 41.2436 | -111.9465 | Hydro | 1910.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29537 | 2019 | 7.718 | 9.008 | 9.846 | 11.369 | 27.134 | 9.235 | 21.353 | U.S. Energy Information Administration | 12.19 | 12.47 | 11.66 | 13.23 | 12.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31646 | 31646 | USA | United States of America | Prospect 1 | USA0003032 | 3.8 | 42.7307 | -122.5151 | Hydro | 1912.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29536 | 2019 | 20.789 | 23.728 | 6.378 | 0.0 | 21.106 | 12.114 | 8.511000000000001 | U.S. Energy Information Administration | 11.74 | 13.55 | 10.78 | 13.62 | 11.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31647 | 31647 | USA | United States of America | Prospect 2 | USA0003033 | 32.0 | 42.7312 | -122.514 | Hydro | 1928.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29532 | 2019 | 215.139 | 206.474 | 166.763 | 239.892 | 256.205 | 199.202 | 190.315 | U.S. Energy Information Administration | 87.97 | 99.48 | 63.1 | 96.24 | 76.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31648 | 31648 | USA | United States of America | Prospect 3 | USA0003034 | 7.2 | 42.7306 | -122.4185 | Hydro | 1932.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29533 | 2019 | 33.745 | 35.937 | 27.781 | 32.997 | 40.779 | 22.263 | 23.624 | U.S. Energy Information Administration | 18.74 | 18.74 | 17.89 | 18.79 | 16.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31649 | 31649 | USA | United States of America | Prospect 4 | USA0003035 | 1.0 | 42.7331 | -122.5151 | Hydro | 1944.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29535 | 2019 | 4.178 | 4.567 | 1.219 | 0.0 | 4.599 | 2.541 | 1.817 | U.S. Energy Information Administration | 3.48 | 3.93 | 3.46 | 3.98 | 3.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32630 | 32630 | USA | United States of America | Slide Creek | USA0003036 | 18.0 | 43.2939 | -122.4728 | Hydro | 1951.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29540 | 2019 | 53.119 | 70.42 | 44.735 | 75.625 | 79.047 | 56.868 | 46.271 | U.S. Energy Information Administration | 68.61 | 71.48 | 58.26 | 69.79 | 65.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32664 | 32664 | USA | United States of America | Soda | USA0000831 | 14.5 | 42.6446 | -111.6967 | Hydro | 1924.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29542 | 2019 | 15.674 | 14.51 | 14.474 | 17.769000000000002 | 33.872 | 29.789 | 20.509 | U.S. Energy Information Administration | 50.33 | 48.39 | 36.93 | 47.31 | 54.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32667 | 32667 | USA | United States of America | Soda Springs | USA0003037 | 11.0 | 43.3061 | -122.5014 | Hydro | 1952.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29543 | 2019 | 45.782 | 54.071 | 34.278 | 61.093 | 60.374 | 44.108 | 38.101 | U.S. Energy Information Administration | 42.13 | 42.9 | 35.81 | 41.86 | 38.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32936 | 32936 | USA | United States of America | Stairs | USA0003659 | 1.0 | 40.6236 | -111.7533 | Hydro | 1912.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29544 | 2019 | 3.909 | 4.648 | 3.897 | 4.5440000000000005 | 5.643 | 3.767 | 5.771 | U.S. Energy Information Administration | 2.39 | 2.64 | 2.62 | 2.65 | 2.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33167 | 33167 | USA | United States of America | Swift 1 | USA0003850 | 240.0 | 46.0608 | -122.2017 | Hydro | 1959.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29547 | 2019 | 574.062 | 812.195 | 583.525 | 761.592 | 866.791 | 545.383 | 369.084 | U.S. Energy Information Administration | 634.57 | 720.77 | 570.2 | 705.98 | 588.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33168 | 33168 | USA | United States of America | Swift 2 | USA0006265 | 72.0 | 46.0594 | -122.2594 | Hydro | 1959.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29545 | 2019 | 251.81 | 253.67 | 205.04 | 257.07 | 214.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
33417 | 33417 | USA | United States of America | Toketee Falls | USA0003040 | 42.6 | 43.2727 | -122.4475 | Hydro | 1950.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29548 | 2019 | 195.898 | 226.366 | 183.992 | 232.82 | 255.226 | 195.057 | 193.356 | U.S. Energy Information Administration | 141.7 | 142.73 | 111.97 | 149.56 | 119.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33939 | 33939 | USA | United States of America | Wallowa Falls | USA0003041 | 1.1 | 45.2667 | -117.2127 | Hydro | 1921.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29551 | 2019 | 5.34 | 2.354 | 3.49 | 4.34 | 4.642 | 4.664 | 2.745 | U.S. Energy Information Administration | 2.45 | 2.46 | 2.61 | 2.47 | 2.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34082 | 34082 | USA | United States of America | Weber | USA0003661 | 3.8 | 41.1376 | -111.8849 | Hydro | 1911.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29550 | 2019 | 8.908 | 5.031 | 9.926 | 13.611 | 0.0 | 11.273 | 14.064 | U.S. Energy Information Administration | 11.32 | 10.29 | 10.28 | 10.32 | 10.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34490 | 34490 | USA | United States of America | Yale | USA0003852 | 134.0 | 45.9628 | -122.3355 | Hydro | 1953.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29554 | 2019 | 506.285 | 671.693 | 482.067 | 645.247 | 726.025 | 519.6370000000001 | 370.023 | U.S. Energy Information Administration | 406.81 | 422.73 | 335.12 | 415.82 | 349.0 | 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");