global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where commissioning_year = "1982.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, generation_gwh_2013, generation_gwh_2018, estimated_generation_gwh_2015, estimated_generation_gwh_2016
owner 14
- City of Idaho Falls - (ID) 3
- Metropolitan Water District of S CA 2
- Portland City of 2
- CHI Energy Inc 1
- City & Borough of Sitka - (AK) 1
- Columbia Basin Hydropower 1
- Copper Valley Elec Assn Inc 1
- Cornell Hydro 1
- Hitchcock Hydro LLC 1
- Imperial Irrigation District 1
- Merced Irrigation District 1
- New York Power Authority 1
- Turlock Irrigation District 1
- Warm Springs Power Enterprises 1
primary_fuel 1
- Hydro · 18 ✖
country_long 1
- United States of America · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25185 | 25185 | USA | United States of America | Ashokan | USA0000088 | 4.6 | 41.949 | -74.2063 | Hydro | 1982.0 | New York Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27563 | 2019 | 10.811 | 7.924 | 11.879 | 10.876 | 13.251 | 12.662 | 10.437 | U.S. Energy Information Administration | 15.38 | 15.41 | 12.53 | 12.98 | 13.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25435 | 25435 | USA | United States of America | Beaver Valley Patterson Dam | USA0010546 | 1.2000000000000002 | 40.7441 | -80.3178 | Hydro | 1982.0 | CHI Energy Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17369 | 2019 | 3.978 | 3.398 | 3.3240000000000003 | 3.121 | 3.719 | 4.7940000000000005 | 4.695 | U.S. Energy Information Administration | 3.85 | 3.87 | 3.64 | 3.96 | 3.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26461 | 26461 | USA | United States of America | City Power Plant | USA0000841 | 8.0 | 43.4914 | -112.0454 | Hydro | 1982.0 | City of Idaho Falls - (ID) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 43.086 | 42.551 | 45.196 | 44.131 | 50.56 | 46.503 | 46.722 | U.S. Energy Information Administration | 33.94 | 34.57 | 27.36 | 34.89 | 33.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26694 | 26694 | USA | United States of America | Cornell Hydro | USA0010286 | 1.9 | 42.4519 | -76.4851 | Hydro | 1982.0 | Cornell Hydro | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 5.702 | 2.66 | 4.5360000000000005 | 4.292 | 6.075 | 6.149 | 6.476 | U.S. Energy Information Administration | 5.17 | 5.2 | 5.28 | 5.21 | 4.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27196 | 27196 | USA | United States of America | Drop 5 | USA0000314 | 4.0 | 32.6731 | -115.392 | Hydro | 1982.0 | Imperial Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22900 | 2019 | 15.81 | 11.793 | 12.987 | 13.508 | 12.011 | 11.264 | 10.382 | U.S. Energy Information Administration | 8.94 | 8.97 | 8.8 | 8.97 | 7.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28276 | 28276 | USA | United States of America | Green Lake | USA0000313 | 18.6 | 56.9863 | -135.1227 | Hydro | 1982.0 | City & Borough of Sitka - (AK) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32770 | 2019 | 60.781 | 70.792 | 49.511 | 35.983000000000004 | 54.587 | 52.27 | 51.134 | U.S. Energy Information Administration | 55.72 | 55.72 | 43.28 | 55.87 | 49.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29789 | 29789 | USA | United States of America | Lower No 1 | USA0007012 | 8.0 | 43.4687 | -112.0625 | Hydro | 1982.0 | City of Idaho Falls - (ID) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 43.628 | 42.029 | 45.938 | 41.583 | 42.038 | 42.339 | 42.778 | U.S. Energy Information Administration | 33.94 | 34.57 | 27.36 | 34.89 | 33.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31133 | 31133 | USA | United States of America | PHP 1 | USA0004213 | 23.7 | 45.4817 | -122.0832 | Hydro | 1982.0 | Portland City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 52.542 | 56.508 | 38.341 | 53.385 | 55.234 | 44.204 | 31.144 | U.S. Energy Information Administration | 68.58 | 68.58 | 60.31 | 68.77 | 58.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31134 | 31134 | USA | United States of America | PHP 2 | USA0004214 | 11.8 | 45.449 | -122.1513 | Hydro | 1982.0 | Portland City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 5.681 | 35.910000000000004 | 27.142 | 36.712 | 40.713 | 30.069 | 21.313 | U.S. Energy Information Administration | 30.06 | 30.06 | 27.0 | 30.14 | 26.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31261 | 31261 | USA | United States of America | Parker | USA0000428 | 2.7 | 37.4778 | -120.4445 | Hydro | 1982.0 | Merced Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26024 | 2019 | 5.597 | 3.047 | -0.019 | 4.958 | 3.717 | 5.2090000000000005 | 4.32 | U.S. Energy Information Administration | 10.43 | 8.91 | 8.63 | 9.73 | 9.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32124 | 32124 | USA | United States of America | Russell D Smith | USA0056694 | 6.1 | 46.7392 | -119.1122 | Hydro | 1982.0 | Columbia Basin Hydropower | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31841 | 2019 | 17.67 | 16.144000000000002 | 18.01 | 15.332 | 14.372 | 13.04 | 12.746 | U.S. Energy Information Administration | 14.18 | 14.18 | 13.45 | 14.21 | 12.16 | 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 | |||
32720 | 32720 | USA | United States of America | Solomon Gulch | USA0000390 | 12.0 | 61.0828 | -146.3033 | Hydro | 1982.0 | Copper Valley Elec Assn Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17653 | 2019 | 54.75 | 54.955 | 55.982 | 54.85 | 36.763 | 42.087 | 53.198 | U.S. Energy Information Administration | 36.17 | 36.17 | 28.15 | 36.27 | 32.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33331 | 33331 | USA | United States of America | Texon Hydroelectric Project | USA0061640 | 1.5 | 42.2214 | -72.8596 | Hydro | 1982.0 | Hitchcock Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.16 | 6.267 | 5.36 | U.S. Energy Information Administration | 4.96 | 5.68 | 4.76 | 4.93 | 4.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
33697 | 33697 | USA | United States of America | Upper Power Plant | USA0000844 | 8.0 | 43.5527 | -112.051 | Hydro | 1982.0 | City of Idaho Falls - (ID) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 45.978 | 45.755 | 49.989 | 42.607 | 53.911 | 52.418 | 50.598 | U.S. Energy Information Administration | 33.94 | 34.57 | 27.36 | 34.89 | 33.26 | 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 | |||
33977 | 33977 | USA | United States of America | Warm Springs Power Enterprises | USA0054721 | 19.6 | 44.7242 | -121.2477 | Hydro | 1982.0 | Warm Springs Power Enterprises | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 83.459 | 89.305 | 81.909 | 82.063 | 76.785 | 61.703 | 62.279 | U.S. Energy Information Administration | 82.08 | 90.08 | 73.47 | 89.21 | 78.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
34449 | 34449 | USA | United States of America | Woodward Power Plant | USA0050218 | 2.8 | 37.8607 | -120.8792 | Hydro | 1982.0 | Turlock Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33067 | 2019 | 4.9430000000000005 | 3.241 | 1.454 | 2.359 | 3.065 | 2.674 | 2.203 | U.S. Energy Information Administration | 7.3 | 7.98 | 7.28 | 8.0 | 7.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");