global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where commissioning_year = "1994.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2017
owner 14
- Black Creek Hydro Inc 1
- Boralex Hydro Operations Inc 1
- Calleguas Mun Water District 1
- City of Hamilton - (OH) 1
- City of Tacoma - (WA) 1
- Eugene Water & Electric Board 1
- Fall River Rural Elec Coop Inc 1
- Hydro Sierra Energy LLC 1
- Idaho Power Co 1
- Mill Shoals Hydro Co Inc 1
- PUD No 1 of Lewis County 1
- Pelican Utility 1
- U S Bureau of Reclamation 1
- Wood Hydro LLC 1
primary_fuel 1
- Hydro · 14 ✖
country_long 1
- United States of America · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25602 | 25602 | USA | United States of America | Black Creek | USA0054860 | 3.7 | 47.5497 | -121.7105 | Hydro | 1994.0 | Black Creek Hydro Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14593 | 2019 | 12.844 | 14.09364 | 6.389 | 12.276 | 11.417 | 11.824 | 8.03 | U.S. Energy Information Administration | 12.94 | 13.64 | 12.87 | 13.07 | 11.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26775 | 26775 | USA | United States of America | Cowlitz Falls | USA0007427 | 70.0 | 46.4661 | -122.1097 | Hydro | 1994.0 | PUD No 1 of Lewis County | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 24780 | 2019 | 252.687 | 290.216 | 188.677 | 250.842 | 283.0 | 226.872 | 165.25 | U.S. Energy Information Administration | 247.03 | 266.69 | 208.49 | 266.38 | 227.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26989 | 26989 | USA | United States of America | Deadwood Creek | USA0007507 | 2.0 | 39.53 | -121.0958 | Hydro | 1994.0 | Hydro Sierra Energy LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37575 | 2019 | 0.756 | 5.6850000000000005 | 0.39 | 3.33 | 2.936 | 1.967 | 4.892 | U.S. Energy Information Administration | 7.56 | 7.79 | 7.33 | 8.45 | 7.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28405 | 28405 | USA | United States of America | Hamilton Hydro | USA0007807 | 2.2 | 39.4128 | -84.5558 | Hydro | 1994.0 | City of Hamilton - (OH) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.175 | 4.866 | 4.151 | 4.095 | 5.093 | 4.7780000000000005 | 4.313 | U.S. Energy Information Administration | 7.62 | 8.7 | 7.52 | 9.35 | 6.99 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
28995 | 28995 | USA | United States of America | Island Park | USA0004204 | 4.8 | 44.4183 | -111.396 | Hydro | 1994.0 | Fall River Rural Elec Coop Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19949 | 2019 | 18.26 | 15.667 | 14.249 | 4.848 | 18.409 | 17.366 | 13.513 | U.S. Energy Information Administration | 13.66 | 14.38 | 11.58 | 16.27 | 14.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30232 | 30232 | USA | United States of America | Mile 28 Water Power Project | USA0054812 | 1.4 | 42.7401 | -114.1612 | Hydro | 1994.0 | Wood Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26421 | 2019 | 4.0440000000000005 | 4.755 | 4.766 | 4.625 | 6.043 | 4.098 | 0.898 | U.S. Energy Information Administration | 2.92 | 2.94 | 2.92 | 2.95 | 2.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30275 | 30275 | USA | United States of America | Milstead | USA0054872 | 1.0 | 33.6894 | -83.9903 | Hydro | 1994.0 | Mill Shoals Hydro Co Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17415 | 2019 | 2.443 | 2.344 | 2.93 | 1.752 | 2.195 | 2.495 | 1.93098 | U.S. Energy Information Administration | 2.37 | 2.3 | 2.68 | 3.28 | 2.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31326 | 31326 | USA | United States of America | Pelican | USA0006702 | 2.4 | 57.9572 | -136.2201 | Hydro | Oil | 1994.0 | Pelican Utility | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29864 | 2019 | 0.49 | 1.1 | 1.129 | 0.964 | 1.902 | 1.309 | 1.055 | U.S. Energy Information Administration | 8.67 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
32770 | 32770 | USA | United States of America | South Glens Falls Hydroelectric | USA0054772 | 13.8 | 43.3044 | -73.6399 | Hydro | 1994.0 | Boralex Hydro Operations Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12382 | 2019 | 73.232 | 73.185 | 63.687000000000005 | 59.404 | 83.611 | 77.046 | 97.676 | U.S. Energy Information Administration | 61.0 | 65.5 | 45.24 | 60.37 | 57.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32846 | 32846 | 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 | 2019 | 16.92 | 16.315 | 18.386 | 16.839 | 15.018 | 15.539 | 17.052 | U.S. Energy Information Administration | 15.26 | 15.59 | 14.6 | 15.02 | 13.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32879 | 32879 | USA | United States of America | Springville Hydroelectric | USA0056125 | 1.0 | 34.2253 | -119.0858 | Hydro | 1994.0 | Calleguas Mun Water District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15370 | 2019 | 2.932 | 2.157 | 2.111 | 1.167 | 1.487 | 1.291 | 0.8160000000000001 | U.S. Energy Information Administration | 2.14 | 2.16 | 1.88 | 2.17 | 1.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33019 | 33019 | USA | United States of America | Stone Creek | USA0007508 | 12.0 | 45.0811 | -121.8866 | Hydro | 1994.0 | Eugene Water & Electric Board | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19814 | 2019 | 62.008 | 63.734 | 49.017 | 50.46723 | 61.522 | 50.39 | 42.57 | U.S. Energy Information Administration | 41.19 | 39.94 | 36.4 | 40.6 | 32.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33154 | 33154 | USA | United States of America | Swan Falls | USA0000819 | 25.0 | 43.2435 | -116.3791 | Hydro | 1994.0 | Idaho Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22767 | 2019 | 108.062 | 110.848 | 110.847 | 112.684 | 130.191 | 123.727 | 134.329 | U.S. Energy Information Administration | 99.64 | 134.08 | 74.02 | 110.62 | 91.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34475 | 34475 | USA | United States of America | Wynoochee | USA0007127 | 12.8 | 47.3851 | -123.6052 | Hydro | 1994.0 | City of Tacoma - (WA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34127 | 2019 | 24.404 | 14.272 | 12.68 | 37.209 | 34.103 | 26.071 | 13.734 | U.S. Energy Information Administration | 47.94 | 51.03 | 42.1 | 52.63 | 44.25 | 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");