Data license: CC Attribution 4.0 License · Data source: World Resources Institute
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 | estimated_generation_gwh |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21002 | 21002 | USA | United States of America | Alcova | USA0006409 | 41.4 | 42.5484 | -106.7175 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35616 | 2017 | 91.92200000000001 | 73.132 | 78.306 | 108.678 | 133.364 | ||||
| 21132 | 21132 | USA | United States of America | Anderson Ranch | USA0006395 | 40.0 | 43.3571 | -115.4515 | Hydro | 1951.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35617 | 2017 | 112.885 | 86.29899999999999 | 122.346 | 145.394 | 162.52100000000004 | ||||
| 21567 | 21567 | USA | United States of America | Big Thompson | USA0000515 | 4.5 | 40.421 | -105.2238 | Hydro | 1959.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35618 | 2017 | 7.223 | 2.006 | 4.123 | 5.722 | 7.627000000000001 | ||||
| 21604 | 21604 | USA | United States of America | Black Canyon | USA0006396 | 10.2 | 43.9305 | -116.4372 | Hydro | 1926.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35619 | 2017 | 55.598 | 63.647 | 61.394 | 62.55900000000001 | 65.214 | ||||
| 21652 | 21652 | USA | United States of America | Blue Mesa | USA0000512 | 86.4 | 38.4532 | -107.3375 | Hydro | 1967.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35620 | 2017 | 134.60399999999998 | 221.259 | 258.762 | 252.915 | 311.473 | ||||
| 21683 | 21683 | USA | United States of America | Boise R Diversion | USA0006397 | 3.3000000000000003 | 43.5377 | -116.0938 | Hydro | 2004.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2017 | 7.997999999999999 | 7.037999999999999 | 8.252 | 8.849 | 11.825 | |||||
| 21735 | 21735 | USA | United States of America | Boysen | USA0000505 | 15.0 | 43.4179 | -108.1775 | Hydro | 1952.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35623 | 2017 | 30.586 | 69.50399999999999 | 65.509 | 67.47399999999999 | 88.947 | ||||
| 21857 | 21857 | USA | United States of America | Buffalo Bill | USA0007317 | 18.0 | 44.5082 | -109.1707 | Hydro | 1992.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35622 | 2017 | 58.247 | 97.067 | 58.193999999999996 | 53.641000000000005 | 119.56 | ||||
| 22092 | 22092 | USA | United States of America | Canyon Ferry | USA0006400 | 49.8 | 46.649 | -111.7279 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35625 | 2017 | 264.915 | 363.024 | 303.399 | 310.096 | 347.272 | ||||
| 22250 | 22250 | USA | United States of America | Chandler | USA0006406 | 12.0 | 46.2668 | -119.5898 | Hydro | 1956.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35624 | 2017 | 41.2 | 44.288999999999994 | 29.108 | 53.86 | 55.456 | ||||
| 22706 | 22706 | USA | United States of America | Crystal | USA0006159 | 28.0 | 38.5106 | -107.6253 | Hydro | 1978.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35626 | 2017 | 105.40700000000001 | 139.47 | 133.844 | 175.78 | 155.734 | ||||
| 22812 | 22812 | USA | United States of America | Davis Dam | USA0000152 | 254.8 | 35.197 | -114.5707 | Hydro | 1951.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35627 | 2017 | 1124.512 | 1162.92 | 1139.658 | 1118.857 | 1071.015 | ||||
| 22844 | 22844 | USA | United States of America | Deer Creek (UT) | USA0006404 | 4.8 | 40.4044 | -111.5284 | Hydro | 1958.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35628 | 2017 | 20.401 | 18.559 | 21.205 | 20.055999999999997 | 26.046 | ||||
| 23192 | 23192 | USA | United States of America | Elephant Butte | USA0006402 | 27.9 | 33.1534 | -107.192 | Hydro | 1940.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35633 | 2017 | 9.308 | 12.799000000000001 | 37.645 | 43.49100000000001 | 44.865 | ||||
| 23294 | 23294 | USA | United States of America | Estes | USA0000513 | 45.0 | 40.3768 | -105.5097 | Hydro | 1950.666666666667 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35632 | 2017 | 84.165 | 95.294 | 57.328 | 114.737 | 100.277 | ||||
| 23459 | 23459 | USA | United States of America | Flaming Gorge | USA0006405 | 151.8 | 40.9146 | -109.4217 | Hydro | 1963.666666666667 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35631 | 2017 | 303.057 | 416.74300000000005 | 548.65 | 495.226 | 838.404 | ||||
| 23467 | 23467 | USA | United States of America | Flatiron | USA0000518 | 94.5 | 40.365 | -105.236 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35634 | 2017 | 179.93099999999998 | 222.61599999999999 | 143.563 | 208.112 | 156.385 | ||||
| 23490 | 23490 | USA | United States of America | Folsom | USA0000441 | 198.6 | 38.7067 | -121.1584 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35629 | 2017 | 341.902 | 185.14700000000002 | 203.50099999999998 | 593.96 | 861.6160000000001 | ||||
| 23495 | 23495 | USA | United States of America | Fontenelle | USA0004185 | 10.0 | 42.027 | -110.064 | Hydro | 1968.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35630 | 2017 | 37.453 | 68.718 | 67.928 | 44.169 | 48.358 | ||||
| 23614 | 23614 | USA | United States of America | Fremont Canyon | USA0004176 | 66.8 | 42.4766 | -106.7959 | Hydro | 1961.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35639 | 2017 | 147.69 | 133.507 | 189.039 | 229.509 | 289.3280000000001 | ||||
| 23830 | 23830 | USA | United States of America | Glen Canyon Dam | USA0000153 | 1312.0 | 36.9366 | -111.4839 | Hydro | 1964.9939024390244 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35638 | 2017 | 3332.256 | 3344.619 | 3839.205 | 4016.225 | 3949.678 | ||||
| 23839 | 23839 | USA | United States of America | Glendo | USA0004177 | 38.0 | 42.4673 | -104.9555 | Hydro | 1959.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35637 | 2017 | 53.979 | 80.112 | 69.95 | 99.274 | 107.756 | ||||
| 23910 | 23910 | USA | United States of America | Grand Coulee | USA0006163 | 6809.0 | 47.9575 | -118.9773 | Hydro | 1967.470333382288 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35636 | 2017 | 21073.181 | 20261.569 | 18878.623 | 19011.492 | 20983.99 | ||||
| 23992 | 23992 | USA | United States of America | Green Mountain | USA0000516 | 26.0 | 39.8788 | -106.3327 | Hydro | 1943.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35643 | 2017 | 33.149 | 93.802 | 76.642 | 59.568000000000005 | 56.94 | ||||
| 23999 | 23999 | USA | United States of America | Green Springs | USA0006403 | 17.2 | 42.1212 | -122.5479 | Hydro | 1960.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35641 | 2017 | 56.96 | 64.423 | 54.481 | 52.255 | 43.685 | ||||
| 24041 | 24041 | USA | United States of America | Guernsey | USA0004178 | 6.4 | 42.2899 | -104.7606 | Hydro | 1927.5 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35640 | 2017 | 8.711 | 15.838 | 18.089000000000002 | 17.942 | 12.004000000000001 | ||||
| 24217 | 24217 | USA | United States of America | Heart Mountain | USA0006408 | 5.0 | 44.5138 | -109.1296 | Hydro | 1949.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35642 | 2017 | 17.292 | 18.14 | 17.239 | 17.72 | 23.241999999999997 | ||||
| 24372 | 24372 | USA | United States of America | Hoover Dam (AZ) | USA0008902 | 1039.4 | 36.0155 | -114.738 | Hydro | 1944.097460073119 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35645 | 2017 | 1245.441 | 1436.779 | 1401.8470000000002 | 1818.612 | 1653.271 | ||||
| 24373 | 24373 | USA | United States of America | Hoover Dam (NV) | USA0000154 | 1039.4 | 36.0155 | -114.738 | Hydro | 1940.9797960361745 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35644 | 2017 | 2624.6330000000007 | 2352.308 | 2248.649 | 1748.122 | 1738.8829999999998 | ||||
| 24412 | 24412 | USA | United States of America | Hungry Horse | USA0002203 | 428.0 | 48.3415 | -114.0144 | Hydro | 1952.75 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35647 | 2017 | 1023.385 | 1004.8710000000001 | 1000.298 | 835.1619999999999 | 1034.475 | ||||
| 24769 | 24769 | USA | United States of America | Judge F Carr | USA0000442 | 154.4 | 40.6469 | -122.627 | Hydro | 1963.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35648 | 2017 | 423.712 | 338.338 | 248.667 | 133.554 | 359.6860000000001 | ||||
| 24885 | 24885 | USA | United States of America | Keswick | USA0000443 | 117.0 | 40.6119 | -122.4464 | Hydro | 1949.666666666667 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35650 | 2017 | 383.661 | 284.27299999999997 | 277.776 | 333.401 | 437.401 | ||||
| 24966 | 24966 | USA | United States of America | Kortes | USA0004180 | 36.0 | 42.1743 | -106.8805 | Hydro | 1950.333333333333 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35649 | 2017 | 113.335 | 130.209 | 115.25200000000001 | 135.22899999999998 | 111.056 | ||||
| 25330 | 25330 | USA | United States of America | Lower Molina | USA0000520 | 5.6 | 39.1937 | -108.0441 | Hydro | 1963.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35651 | 2017 | 6.596 | 15.693 | 14.062999999999999 | 15.148 | 12.732 | ||||
| 25548 | 25548 | USA | United States of America | Marys Lake | USA0000517 | 8.1 | 40.3441 | -105.5343 | Hydro | 1951.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35653 | 2017 | 27.759 | 35.205 | 18.996 | 36.793 | 31.145 | ||||
| 25606 | 25606 | USA | United States of America | McPhee | USA0007372 | 1.2 | 37.5752 | -108.574 | Hydro | 1993.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35654 | 2017 | 0.35000000000000003 | 3.56 | 4.855 | 5.055 | 5.47 | ||||
| 25777 | 25777 | USA | United States of America | Minidoka | USA0006398 | 27.7 | 42.6699 | -113.4832 | Hydro | 1980.2490974729244 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35655 | 2017 | 85.25200000000001 | 96.317 | 110.976 | 75.153 | 50.897 | ||||
| 25908 | 25908 | USA | United States of America | Morrow Point | USA0000514 | 173.2 | 38.4518 | -107.5393 | Hydro | 1971.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35657 | 2017 | 183.43099999999998 | 295.791 | 341.545 | 326.7750000000001 | 338.514 | ||||
| 25925 | 25925 | USA | United States of America | Mount Elbert | USA0006208 | 200.0 | 39.0942 | -106.3523 | Hydro | 1982.5 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35656 | 2017 | -134.35 | -52.967 | -101.211 | -80.734 | -87.77799999999999 | ||||
| 26133 | 26133 | USA | United States of America | New Melones | USA0006158 | 300.0 | 37.9469 | -120.5282 | Hydro | 1979.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35658 | 2017 | 410.549 | 275.57 | 130.222 | 212.09400000000002 | 713.048 | ||||
| 26182 | 26182 | USA | United States of America | Nimbus | USA0000444 | 13.4 | 38.6373 | -121.2202 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35659 | 2017 | 45.661 | 26.149 | 27.656999999999996 | 53.958999999999996 | 64.65 | ||||
| 26318 | 26318 | USA | United States of America | ONeill | USA0000446 | 25.2 | 37.0987 | -121.0477 | Hydro | 1967.6666666666665 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35661 | 2017 | -29.413 | -5.735 | -12.192 | -50.858999999999995 | -105.76799999999999 | ||||
| 26595 | 26595 | USA | United States of America | Palisades Dam | USA0000850 | 176.4 | 43.3348 | -111.2058 | Hydro | 1957.25 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35660 | 2017 | 356.031 | 513.643 | 626.3480000000001 | 581.315 | 688.052 | ||||
| 26638 | 26638 | USA | United States of America | Parker Dam | USA0000447 | 120.0 | 34.2953 | -114.1402 | Hydro | 1943.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35662 | 2017 | 433.745 | 448.589 | 439.9 | 440.87199999999996 | 435.51599999999996 | ||||
| 26772 | 26772 | USA | United States of America | Pilot Butte | USA0000674 | 1.6 | 43.219 | -108.7877 | Hydro | 1927.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35664 | 2017 | 73.1090892626952 | ||||||||
| 26869 | 26869 | USA | United States of America | Pole Hill | USA0000519 | 38.2 | 40.3651 | -105.3251 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35663 | 2017 | 150.626 | 191.968 | 120.246 | 190.64700000000002 | 146.464 | ||||
| 27400 | 27400 | USA | United States of America | Roza | USA0006407 | 12.9 | 46.6184 | -120.4778 | Hydro | 1958.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35665 | 2017 | 70.205 | 67.48100000000001 | 62.193000000000005 | 67.63 | 63.24800000000001 | ||||
| 27689 | 27689 | USA | United States of America | Seminoe | USA0004182 | 51.6 | 42.1561 | -106.9085 | Hydro | 1939.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35666 | 2017 | 90.352 | 119.627 | 125.244 | 138.3 | 128.499 | ||||
| 27731 | 27731 | USA | United States of America | Shasta | USA0000445 | 714.0 | 40.7175 | -122.4223 | Hydro | 1946.5854341736692 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35670 | 2017 | 1794.5539999999999 | 1012.933 | 1096.894 | 1748.0410000000002 | 2908.434 | ||||
| 27787 | 27787 | USA | United States of America | Shoshone (WY) | USA0004183 | 3.0 | 44.5029 | -109.1812 | Hydro | 1922.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35667 | 2017 | 19.133 | 19.748 | 18.051 | 17.579 | 19.202 | ||||
| 28072 | 28072 | USA | United States of America | Spirit Mountain | USA0007541 | 4.5 | 44.5127 | -109.1299 | Hydro | 1994.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35668 | 2017 | 16.92 | 16.315 | 18.386 | 16.839000000000002 | 15.017999999999999 | ||||
| 28079 | 28079 | USA | United States of America | Spring Creek | USA0000450 | 180.0 | 40.6281 | -122.4675 | Hydro | 1964.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35669 | 2017 | 352.401 | 283.44599999999997 | 200.467 | 193.724 | 417.597 | ||||
| 28143 | 28143 | USA | United States of America | Stampede | USA0007066 | 3.6 | 39.4704 | -120.1046 | Hydro | 1988.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35671 | 2017 | 13.2 | 9.542 | 3.4960000000000004 | 4.982 | 13.538 | ||||
| 28577 | 28577 | USA | United States of America | Towaoc | USA0007373 | 11.4 | 37.4295 | -108.5749 | Hydro | 1993.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35673 | 2017 | 8.786 | 18.008 | 17.45 | 17.862000000000005 | 17.877 | ||||
| 28621 | 28621 | USA | United States of America | Trinity | USA0000451 | 140.0 | 40.7973 | -122.7626 | Hydro | 1964.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35672 | 2017 | 449.91 | 279.059 | 195.16099999999997 | 277.80400000000003 | 411.16900000000004 | ||||
| 28780 | 28780 | USA | United States of America | Upper Molina | USA0000521 | 9.9 | 39.1438 | -108.0048 | Hydro | 1963.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35674 | 2017 | 17.221 | 24.43 | 25.206 | 25.913 | 22.859 | ||||
| 29502 | 29502 | USA | United States of America | Yellowtail | USA0002204 | 259.4 | 45.3074 | -107.9575 | Hydro | 1966.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35676 | 2017 | 471.034 | 1095.85 | 744.118 | 690.297 | 1124.349 |
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,
"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");