global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
20 rows where commissioning_year = "1993.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, generation_gwh_2014, generation_gwh_2015, generation_gwh_2019, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2017
owner 18
- Hazelton/Wilson Joint Venture 2
- U S Bureau of Reclamation 2
- Appomattox River Associates LP 1
- Arkansas Electric Coop Corp 1
- Avista Corp 1
- Central Arizona Water Conservation Dist 1
- City of Burlington Electric - (VT) 1
- City of Mt Pleasant - (UT) 1
- City of Santa Clara - (CA) 1
- Colorado River Indian Irr Proj 1
- Denver City & County of 1
- GR Catalyst One LLC 1
- Los Angeles Department of Water & Power 1
- Marsh Valley Development Inc 1
- Marysville Hydro Partners 1
- Owyhee Irrigation District 1
- Rio Blanco Water Conserv Dist 1
- Wailuku Holding Company LLC 1
primary_fuel 1
- Hydro · 20 ✖
country_long 1
- United States of America · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25778 | 25778 | USA | United States of America | Brasfield | USA0010155 | 2.9 | 37.2208 | -77.5245 | Hydro | 1993.0 | Appomattox River Associates LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33814 | 2019 | 11.40678 | 9.94455 | 10.563 | 10.565 | 6.037 | 11.072 | 10.768 | U.S. Energy Information Administration | 10.19 | 11.27 | 8.95 | 11.36 | 8.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26318 | 26318 | USA | United States of America | Chace Mill Winooski One | USA0054355 | 7.5 | 44.49 | -73.1875 | Hydro | 1993.0 | City of Burlington Electric - (VT) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37150 | 2019 | 32.233000000000004 | 6.208 | 26.825 | 25.359 | 31.875 | 24.899 | 33.246 | U.S. Energy Information Administration | 28.94 | 30.77 | 25.03 | 29.7 | 26.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27598 | 27598 | USA | United States of America | Falls River Hydro | USA0054668 | 9.0 | 44.0597 | -111.3535 | Hydro | 1993.0 | Marysville Hydro Partners | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22740 | 2019 | 44.78265 | 54.155 | 40.347 | 37.751 | 64.81 | 58.588 | 47.835 | U.S. Energy Information Administration | 30.65 | 30.79 | 27.63 | 30.88 | 26.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28326 | 28326 | USA | United States of America | Grizzly | USA0007338 | 22.0 | 39.8893 | -121.2792 | Hydro | 1993.0 | City of Santa Clara - (CA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32084 | 2019 | 108.94752 | 5.854 | 12.037 | 40.738 | 91.213 | 19.337 | 0.0 | U.S. Energy Information Administration | 81.3 | 78.05 | 66.94 | 94.28 | 76.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28531 | 28531 | USA | United States of America | Hazelton B Hydro | USA0054558 | 7.6 | 42.6051 | -114.093 | Hydro | 1993.0 | Hazelton/Wilson Joint Venture | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32752 | 2019 | 22.808 | 23.139 | 23.564 | 22.271 | 21.795 | 23.147 | 22.635 | U.S. Energy Information Administration | 20.18 | 18.82 | 18.9 | 19.15 | 16.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28536 | 28536 | USA | United States of America | Headgate Rock | USA0007179 | 19.5 | 34.1683 | -114.2774 | Hydro | 1993.0 | Colorado River Indian Irr Proj | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 45554 | 2019 | 78.877 | 79.916 | 73.405 | 75.735 | 72.811 | 67.925 | 72.438 | U.S. Energy Information Administration | 79.16 | 89.34 | 71.53 | 80.57 | 70.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28637 | 28637 | USA | United States of America | Hillcrest Pump Station | USA0054142 | 2.0 | 39.6419 | -104.9138 | Hydro | 1993.0 | Denver City & County of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18299 | 2019 | 0.0 | 3.422 | 0.61 | 7.518 | 5.28 | 4.747 | 4.4030000000000005 | U.S. Energy Information Administration | 5.73 | 5.9 | 5.76 | 5.92 | 5.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29990 | 29990 | USA | United States of America | Marsh Valley Development | USA0050972 | 1.6 | 42.626 | -112.1493 | Hydro | 1993.0 | Marsh Valley Development Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32960 | 2019 | 3.353 | 3.661 | 3.143 | 4.729 | 7.588 | 6.867 | 7.669 | U.S. Energy Information Administration | 5.1 | 5.25 | 5.07 | 4.41 | 5.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30092 | 30092 | 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 | 2019 | 0.35 | 3.56 | 4.855 | 5.055 | 5.47 | 2.6830000000000003 | 4.303 | U.S. Energy Information Administration | 2.81 | 2.82 | 2.78 | 2.87 | 2.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30353 | 30353 | USA | United States of America | Monroe Street | USA0009095 | 14.8 | 47.6536 | -117.4206 | Hydro | 1993.0 | Avista Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36357 | 2019 | 104.654 | 102.775 | 84.084 | 96.851 | 95.459 | 81.033 | 98.076 | U.S. Energy Information Administration | 70.71 | 71.86 | 68.78 | 72.27 | 69.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30788 | 30788 | USA | United States of America | North Hollywood | USA0057854 | 9.0 | 34.1944 | -118.3903 | Hydro | 1993.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.92 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 23.71 | 22.2 | 18.42 | 22.28 | 21.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33008 | 33008 | USA | United States of America | Stillwater Hydro Electric Project | USA0054395 | 3.4 | 42.9375 | -73.6544 | Hydro | 1993.0 | GR Catalyst One LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 15.6 | 14.372 | 11.447 | 13.255 | 15.287 | 13.931 | 13.926 | U.S. Energy Information Administration | 13.94 | 15.03 | 11.03 | 13.94 | 11.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33274 | 33274 | USA | United States of America | Taylor Draw Hydroelectric Facility | USA0054729 | 2.3 | 40.1063 | -108.7112 | Hydro | 1993.0 | Rio Blanco Water Conserv Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31437 | 2019 | 8.782 | 12.258 | 10.732 | 10.837 | 10.78 | 8.549 | 11.316 | U.S. Energy Information Administration | 7.25 | 7.59 | 8.56 | 7.81 | 6.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33440 | 33440 | 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 | 2019 | 8.786 | 18.008 | 17.45 | 17.862000000000002 | 17.877 | 11.192 | 17.082 | U.S. Energy Information Administration | 28.23 | 29.33 | 25.28 | 28.31 | 24.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33521 | 33521 | USA | United States of America | Tunnel 1 Power Project | USA0050362 | 7.0 | 43.642 | -117.2327 | Hydro | 1993.0 | Owyhee Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.018 | 0.0 | 0.0 | 10.561 | 22.861 | 16.369 | 22.316 | U.S. Energy Information Administration | 20.32 | 20.47 | 20.46 | 24.59 | 20.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33650 | 33650 | USA | United States of America | Unit 4 | USA0007015 | 1.3 | 39.5441 | -111.4187 | Hydro | 1993.0 | City of Mt Pleasant - (UT) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.541 | 3.238 | 2.708 | 3.085 | 4.18 | 4.471 | 4.22 | U.S. Energy Information Administration | 3.33 | 3.35 | 3.33 | 3.36 | 2.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33906 | 33906 | USA | United States of America | Waddell | USA0007164 | 40.0 | 33.8447 | -112.2714 | Hydro | 1993.0 | Central Arizona Water Conservation Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15826 | 2019 | 38.503 | 31.047 | 43.432 | 42.832 | -40.193 | -29.888 | -59.229 | U.S. Energy Information Administration | 110.13 | 107.4 | 95.62 | 115.05 | 89.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33922 | 33922 | USA | United States of America | Wailuku River Hydroelectric | USA0054827 | 10.4 | 19.713 | -155.1486 | Hydro | 1993.0 | Wailuku Holding Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34080 | 2019 | 15.129 | 18.185 | 40.881 | 36.288 | 19.466 | 42.43 | 23.951 | U.S. Energy Information Administration | 37.59 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34241 | 34241 | USA | United States of America | Whillock | USA0007135 | 32.400000000000006 | 35.1276 | -92.7903 | Hydro | 1993.0 | Arkansas Electric Coop Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13511 | 2019 | 144.88 | 153.723 | 102.453 | 169.672 | 121.74 | 162.79500000000002 | 122.04 | U.S. Energy Information Administration | 135.69 | 142.83 | 112.99 | 126.02 | 108.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34352 | 34352 | USA | United States of America | Wilson Lake Hydroelectric Project | USA0054306 | 8.4 | 42.6289 | -114.1747 | Hydro | 1993.0 | Hazelton/Wilson Joint Venture | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22743 | 2019 | 26.493 | 26.868 | 27.395 | 25.933 | 25.144 | 26.672 | 25.457 | U.S. Energy Information Administration | 22.3 | 20.8 | 20.89 | 21.17 | 18.33 | 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");