global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
34 rows where capacity_mw = "3.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, generation_gwh_2013, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2016, estimated_generation_gwh_2017
owner 23
- Erie Boulevard Hydropower LP 7
- Green Mountain Power Corp 4
- Southern California Edison Co 3
- Alaska Power and Telephone Co 1
- Ampersand Mount Ida Hydro LLC 1
- Boralex Hydro Operations Inc 1
- Boulder City of 1
- Burrows Paper Corp 1
- City of Idaho Falls - (ID) 1
- City of Nashua NH 1
- City of Pasadena - (CA) 1
- Duke Energy Carolinas LLC 1
- EBD Hydro LLC 1
- Enel Green Power NA Inc. 1
- Errol Hydroelectric Co LLC 1
- Modesto Irrigation District 1
- PowerSouth Energy Cooperative 1
- Rochester Gas & Electric Corp 1
- STS Hydropower LLC 1
- Salt River Project 1
- Sho-Me Power Electric Coop 1
- Snow Mountain Hydro LLC 1
- U S Bureau of Reclamation 1
primary_fuel 1
- Hydro · 34 ✖
country_long 1
- United States of America · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24738 | 24738 | USA | United States of America | 45 Mile Hydroelectric Project | USA0058455 | 3.0 | 44.5281 | -121.1528 | Hydro | 2015.0 | EBD Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 64894 | 2019 | 5.561 | 7.332 | 6.349 | 7.921 | 5.324 | U.S. Energy Information Administration | 6.48 | 6.48 | 6.61 | 6.5 | 5.49 | 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 | |||
25734 | 25734 | USA | United States of America | Boulder City Betasso Hydro Plant | USA0054680 | 3.0 | 40.0111 | -105.3347 | Hydro | 1988.0 | Boulder City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14798 | 2019 | 8.299 | 8.31 | 7.757000000000001 | 7.05 | 7.704 | 6.574 | 7.635 | U.S. Energy Information Administration | 6.57 | 6.57 | 6.93 | 6.59 | 5.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25927 | 25927 | USA | United States of America | Burney Creek | USA0010706 | 3.0 | 40.8579 | -121.7225 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 38125 | 2019 | 2.03 | 1.873 | 0.394 | 7.147 | 10.717 | 3.366 | 8.869 | U.S. Energy Information Administration | 6.24 | 6.24 | 6.15 | 6.25 | 5.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26354 | 26354 | USA | United States of America | Chasm | USA0002550 | 3.0 | 44.7533 | -74.2169 | Hydro | 1917.3333333333333 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27794 | 2019 | 9.19 | 8.019 | 13.017 | 18.979 | 21.079 | 21.943 | 23.75 | U.S. Energy Information Administration | 10.24 | 9.52 | 7.81 | 10.45 | 8.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26487 | 26487 | USA | United States of America | Clark Falls | USA0003711 | 3.0 | 44.6356 | -73.12 | Hydro | 1937.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15961 | 2019 | 18.081 | 16.153 | 13.814 | 13.33 | 17.762 | 15.316 | 16.192 | U.S. Energy Information Administration | 10.25 | 11.2 | 9.18 | 10.3 | 9.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26823 | 26823 | USA | United States of America | Crosscut | USA0000143 | 3.0 | 33.4394 | -111.9461 | Hydro | 1939.0 | Salt River Project | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31943 | 2019 | 0.221 | U.S. Energy Information Administration | 6.7 | 6.88 | 7.6 | 5.82 | 6.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
27088 | 27088 | USA | United States of America | Deweys Mill | USA0010137 | 3.0 | 43.6411 | -72.4061 | Hydro | 1989.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17383 | 2019 | 6.9110000000000005 | 4.89 | 4.521 | 3.888 | 0.361 | 2.226 | 2.156 | U.S. Energy Information Administration | 9.71 | 9.58 | 9.38 | 9.61 | 8.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27133 | 27133 | USA | United States of America | Dixon Hydroelectric Dam | USA0054969 | 3.0 | 41.8453 | -89.4813 | Hydro | 1925.0 | STS Hydropower LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 47465 | 2019 | 13.325 | 13.634 | 15.991 | 16.887 | 12.046 | 15.89 | 12.516 | U.S. Energy Information Administration | 12.25 | 13.09 | 10.48 | 12.57 | 10.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27358 | 27358 | USA | United States of America | Effley | USA0002557 | 3.0 | 43.9228 | -75.2779 | Hydro | 1915.466666666667 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27804 | 2019 | 15.718 | 18.284 | 12.954 | 14.022 | 19.217 | 16.672 | 19.684 | U.S. Energy Information Administration | 11.62 | 12.24 | 10.7 | 11.97 | 11.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27483 | 27483 | USA | United States of America | Errol Hydroelectric Project | USA0010570 | 3.0 | 44.7866 | -71.1243 | Hydro | 1986.0 | Errol Hydroelectric Co LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 16.025 | 16.47 | 16.195 | 15.345 | 17.323 | 14.51 | 12.511 | U.S. Energy Information Administration | 12.78 | 12.74 | 10.94 | 12.04 | 11.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27717 | 27717 | USA | United States of America | Fontana | USA0000332 | 3.0 | 34.1552 | -117.3971 | Hydro | 1918.0 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33129 | 2019 | 2.845 | 1.916 | 1.627 | 1.294 | 3.493 | 2.545 | 4.78 | U.S. Energy Information Administration | 6.86 | 6.88 | 6.81 | 6.87 | 6.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27958 | 27958 | USA | United States of America | Gantt | USA0000053 | 3.0 | 31.4033 | -86.4795 | Hydro | 1961.4 | PowerSouth Energy Cooperative | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12563 | 2019 | 7.612 | 6.932 | 3.658 | 5.718 | 2.484 | 0.904 | 3.003 | U.S. Energy Information Administration | 7.84 | 7.84 | 5.93 | 8.23 | 7.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28166 | 28166 | USA | United States of America | Gorge 18 | USA0006475 | 3.0 | 44.49 | -73.1693 | Hydro | 1928.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21409 | 2019 | 9.374 | 11.189 | 15.073 | 14.321 | 12.633 | 9.791 | 12.701 | U.S. Energy Information Administration | 10.86 | 11.59 | 9.81 | 11.39 | 10.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28586 | 28586 | USA | United States of America | Hewittville Hydroelectric | USA0050268 | 3.0 | 44.7052 | -75.0079 | Hydro | 1984.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12371 | 2019 | 17.596 | 14.622 | 14.397 | 14.091 | 16.128 | 13.397 | 15.573 | U.S. Energy Information Administration | 12.87 | 13.01 | 11.56 | 12.18 | 11.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28783 | 28783 | USA | United States of America | Hydraulic Race | USA0002578 | 3.0 | 43.1709 | -78.6916 | Hydro | 1942.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27825 | 2019 | 10.265 | 9.328 | 9.716 | 10.685 | 9.313 | 9.217 | 7.699 | U.S. Energy Information Administration | 6.24 | 6.24 | 6.15 | 6.25 | 5.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29209 | 29209 | USA | United States of America | Kasidaya Creek Hydro | USA0056542 | 3.0 | 59.4072 | -135.3408 | Hydro | 2008.0 | Alaska Power and Telephone Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 61936 | 2019 | 7.405 | 8.64 | 8.638 | 7.123 | 9.87 | 10.606 | 10.741 | U.S. Energy Information Administration | 7.43 | 7.43 | 6.15 | 7.45 | 6.44 | 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 | ||||
29806 | 29806 | USA | United States of America | Lundy | USA0000342 | 3.0 | 38.0427 | -119.172 | Hydro | 1912.0 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33141 | 2019 | 4.838 | 4.324 | 4.285 | 7.722 | 16.799 | 9.035 | 13.212 | U.S. Energy Information Administration | 7.28 | 7.19 | 7.19 | 7.5 | 6.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29816 | 29816 | USA | United States of America | Lyonsdale Associates | USA0050652 | 3.0 | 43.6189 | -75.3055 | Hydro | 1984.0 | Burrows Paper Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15179 | 2019 | 11.611 | 11.147 | 11.11 | 10.802 | 13.312 | 8.608 | 10.649 | U.S. Energy Information Administration | 10.6 | 11.64 | 8.89 | 10.1 | 9.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30249 | 30249 | USA | United States of America | Mill Creek 3 | USA0007147 | 3.0 | 34.088 | -117.0395 | Hydro | 1903.6666666666667 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33148 | 2019 | 5.8100000000000005 | 4.905 | 4.966 | 5.23 | 14.508 | 7.573 | 10.603 | U.S. Energy Information Administration | 6.21 | 6.86 | 6.17 | 6.87 | 5.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30284 | 30284 | USA | United States of America | Mine Falls Generating Station | USA0010183 | 3.0 | 42.7503 | -71.5053 | Hydro | 1986.0 | City of Nashua NH | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19469 | 2019 | 9.346 | 10.476 | 8.288 | 6.379 | 3.478 | 16.041 | 9.727 | U.S. Energy Information Administration | 8.2 | 9.8 | 8.06 | 8.22 | 8.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30480 | 30480 | USA | United States of America | Mt Ida Hydroelectric | USA0050031 | 3.0 | 42.7213 | -73.6806 | Hydro | 1992.0 | Ampersand Mount Ida Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.0 | 7.407 | 7.243 | 8.743 | 8.540000000000001 | 9.274 | U.S. Energy Information Administration | 6.24 | 6.24 | 6.15 | 6.25 | 5.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||
30664 | 30664 | USA | United States of America | New Hogan Power Plant | USA0050755 | 3.0 | 38.1496 | -120.8149 | Hydro | 1989.0 | Modesto Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25316 | 2019 | 5.355 | 3.149 | 0.46 | 4.816 | 11.883 | 6.849 | 10.385 | U.S. Energy Information Administration | 6.4 | 6.69 | 6.8 | 7.11 | 8.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30716 | 30716 | USA | United States of America | Niangua | USA0002099 | 3.0 | 37.9385 | -92.8477 | Hydro | 1930.0 | Sho-Me Power Electric Coop | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32593 | 2019 | 0.01 | 0.686 | 1.028 | 0.776 | 0.166 | 0.657 | 0.798 | U.S. Energy Information Administration | 8.97 | 7.32 | 9.87 | 9.92 | 8.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31078 | 31078 | USA | United States of America | Oswego Falls West | USA0002596 | 3.0 | 43.3156 | -76.4172 | Hydro | 1945.3333333333333 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27846 | 2019 | 11.17 | 10.935 | 8.565 | 6.995 | 12.219 | 8.028 | 9.927 | U.S. Energy Information Administration | 11.26 | 11.98 | 11.24 | 11.98 | 11.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31257 | 31257 | USA | United States of America | Parishville | USA0002597 | 3.0 | 44.63 | -74.8258 | Hydro | 1925.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27843 | 2019 | 15.175 | 14.052 | 12.186 | 12.717 | 17.643 | 19.836 | 20.317 | U.S. Energy Information Administration | 6.24 | 6.24 | 6.15 | 6.25 | 5.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32008 | 32008 | USA | United States of America | Rochester 26 | USA0002638 | 3.0 | 43.1522 | -77.6098 | Hydro | 1952.0 | Rochester Gas & Electric Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31592 | 2019 | 0.0 | 0.8230000000000001 | 6.244 | 5.748 | 5.9590000000000005 | 11.436 | 7.961 | U.S. Energy Information Administration | 10.64 | 11.41 | 10.47 | 11.14 | 9.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32015 | 32015 | USA | United States of America | Rock Creek LP | USA0050892 | 3.0 | 38.7834 | -120.7785 | Hydro | 1986.0 | Enel Green Power NA Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32765 | 2019 | 0.211 | 0.613 | 0.11 | 1.286 | 2.392 | 1.469 | 1.704 | U.S. Energy Information Administration | 10.59 | 10.26 | 8.43 | 12.13 | 11.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32551 | 32551 | 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 | 2019 | 19.133 | 19.748 | 18.051 | 17.579 | 19.202 | 19.356 | 20.025 | U.S. Energy Information Administration | 9.98 | 9.86 | 9.26 | 9.8 | 8.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32610 | 32610 | USA | United States of America | Sissonville Hydro | USA0010220 | 3.0 | 44.6856 | -75.0029 | Hydro | 1990.0 | Boralex Hydro Operations Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12381 | 2019 | 15.235 | 14.536 | 12.876 | 11.278 | 18.166 | 13.778 | 17.022000000000002 | U.S. Energy Information Administration | 12.87 | 13.01 | 11.56 | 12.18 | 11.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33506 | 33506 | USA | United States of America | Tuckasegee | USA0002751 | 3.0 | 35.247 | -83.1281 | Hydro | 1950.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27082 | 2019 | 7.01 | 5.675 | 4.62 | 2.442 | 4.188 | 7.077 | 8.306000000000001 | U.S. Energy Information Administration | 11.09 | 10.51 | 11.66 | 10.57 | 8.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33648 | 33648 | USA | United States of America | Unionville Hydro Project 2499 NY | USA0050269 | 3.0 | 44.7145 | -74.9966 | Hydro | 1984.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12386 | 2019 | 16.831 | 14.579 | 13.271 | 12.41 | 16.046 | 12.708 | 14.741 | U.S. Energy Information Administration | 12.87 | 13.01 | 11.56 | 12.18 | 11.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34218 | 34218 | USA | United States of America | Weybridge | USA0003728 | 3.0 | 44.0661 | -73.2158 | Hydro | 1951.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15981 | 2019 | 16.815 | 13.083 | 10.911 | 10.754 | 13.429 | 13.118 | 17.047 | U.S. Energy Information Administration | 9.64 | 9.68 | 9.18 | 9.68 | 8.26 | 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");