global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
23 rows where capacity_mw = "5.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, source, url, geolocation_source, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2017
owner 21
- Erie Boulevard Hydropower LP 3
- Big Creek Water Works Ltd 1
- Boulder City of 1
- Central Oregon Irrigation Dist 1
- City of Aspen- (CO) 1
- City of Santa Clara - (CA) 1
- Consumers Energy Co 1
- Dodge Falls Associates LP 1
- Duke Energy Progress - (NC) 1
- EONY Generation Limited 1
- Fort Miller Associates 1
- Green Mountain Power Corp 1
- Los Angeles County-San Gabriel 1
- Northbrook Tuxedo LLC 1
- Olsen Power Partners 1
- PREPA 1
- PacifiCorp 1
- Siskiyou Power Authority 1
- Snow Mountain Hydro LLC 1
- Town of Bedford - (VA) 1
- U S Bureau of Reclamation 1
primary_fuel 1
- Hydro · 23 ✖
country_long 1
- United States of America · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25363 | 25363 | USA | United States of America | Basalt | USA0007458 | 5.0 | 39.3631 | -106.8219 | Hydro | 1985.0 | City of Aspen- (CO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 62500 | 2019 | 1.114 | 20.24 | 20.476 | 22.69 | 16.797 | 15.869 | 15.951 | U.S. Energy Information Administration | 15.49 | 17.08 | 16.06 | 15.53 | 13.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25540 | 25540 | USA | United States of America | Big Creek Water Works | USA0010282 | 5.0 | 40.6467 | -123.498 | Hydro | 1987.0 | Big Creek Water Works Ltd | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.601 | 2.631 | 3.365 | 10.436 | 10.438 | 6.3274300000000006 | 8.042 | U.S. Energy Information Administration | 16.17 | 16.32 | 16.82 | 19.69 | 17.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
25733 | 25733 | USA | United States of America | Boulder Canyon Hydro | USA0000466 | 5.0 | 40.0047 | -105.3325 | Hydro | 2013.0 | Boulder City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30843 | 2019 | 11.97 | 19.615 | 6.272 | 12.119 | 12.58 | 12.281 | 9.38 | U.S. Energy Information Administration | 10.46 | 10.46 | 10.74 | 10.49 | 8.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25757 | 25757 | USA | United States of America | Box Canyon Dam | USA0050179 | 5.0 | 41.2792 | -122.3292 | Hydro | 1986.0 | Siskiyou Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 10.838 | 8.188 | 9.815 | 23.912 | 25.294 | 8.754 | 20.928 | U.S. Energy Information Administration | 12.29 | 15.49 | 13.78 | 17.28 | 14.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26764 | 26764 | USA | United States of America | Cove Hydroelectric | USA0010707 | 5.0 | 40.8713 | -121.9487 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29498 | 2019 | 9.489 | 7.047 | 3.117 | 16.568 | 18.241 | 9.957 | 18.022 | U.S. Energy Information Administration | 17.55 | 18.27 | 14.24 | 21.31 | 17.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27135 | 27135 | USA | United States of America | Dodge Falls Associates | USA0010526 | 5.0 | 44.2081 | -72.0581 | Hydro | 1991.0 | Dodge Falls Associates LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 16793 | 2019 | 28.438 | 25.635 | 24.895 | 26.243 | 26.841 | 26.301 | 28.029 | U.S. Energy Information Administration | 21.96 | 22.77 | 18.1 | 22.55 | 19.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27142 | 27142 | USA | United States of America | Dolgeville Hydro | USA0010238 | 5.0 | 43.0906 | -74.767 | Hydro | 1985.0 | EONY Generation Limited | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12365 | 2019 | 17.015 | 15.73 | 7.366 | 2.397 | 0.062 | 1.217 | 0.478 | U.S. Energy Information Administration | 15.84 | 15.32 | 15.22 | 16.3 | 15.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27628 | 27628 | USA | United States of America | Feeder Dam Hydro Plant | USA0010530 | 5.0 | 43.2899 | -73.6658 | Hydro | 1924.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27811 | 2019 | 27.959 | 26.424 | 22.504 | 22.498 | 29.716 | 26.646 | 24.792 | U.S. Energy Information Administration | 20.91 | 22.49 | 15.98 | 20.68 | 19.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27687 | 27687 | USA | United States of America | Flat Rock | USA0002563 | 5.0 | 44.2217 | -75.0742 | Hydro | 1924.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27807 | 2019 | 19.805 | 18.754 | 13.184 | 14.788 | 24.217 | 19.432 | 22.133 | U.S. Energy Information Administration | 16.72 | 19.46 | 15.86 | 16.98 | 17.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27765 | 27765 | USA | United States of America | Fort Miller Hydroelectric Facility | USA0050514 | 5.0 | 43.1609 | -73.5841 | Hydro | 1985.0 | Fort Miller Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26029 | 2019 | 23.947 | 24.268 | 20.09 | 19.337 | 27.35 | 22.661 | 16.912 | U.S. Energy Information Administration | 20.91 | 22.75 | 15.72 | 20.45 | 19.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28539 | 28539 | 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 | 2019 | 17.292 | 18.14 | 17.239 | 17.72 | 23.242 | 22.252 | 22.202 | U.S. Energy Information Administration | 16.95 | 17.45 | 16.03 | 16.75 | 15.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29155 | 29155 | USA | United States of America | Juniper Ridge Hydroelectric Project | USA0057437 | 5.0 | 44.1427 | -121.2697 | Hydro | 2010.0 | Central Oregon Irrigation Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 58836 | 2019 | 13.118 | 13.957 | 13.017 | 13.125 | 12.951 | 13.03 | 11.901 | U.S. Energy Information Administration | 10.85 | 10.85 | 10.76 | 10.88 | 9.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29997 | 29997 | USA | United States of America | Marshall Dam | USA0002710 | 5.0 | 35.7025 | -82.7106 | Hydro | 1985.0 | Duke Energy Progress - (NC) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 21.568 | 24.255 | 15.46 | 8.677 | 4.057 | 0.812 | -0.284 | U.S. Energy Information Administration | 10.46 | 10.46 | 10.74 | 10.49 | 8.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30011 | 30011 | USA | United States of America | Marshfield 6 | USA0003739 | 5.0 | 44.3606 | -72.3356 | Hydro | 1927.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21410 | 2019 | 10.789 | 5.4270000000000005 | 4.876 | 7.37 | 11.248 | 8.879 | 11.334 | U.S. Energy Information Administration | 16.34 | 17.38 | 12.9 | 13.94 | 13.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30301 | 30301 | USA | United States of America | Mio | USA0001714 | 5.0 | 44.6611 | -84.1317 | Hydro | 1916.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17533 | 2019 | 14.814 | 16.325 | 15.618 | 16.398 | 16.667 | 15.587 | 18.469 | U.S. Energy Information Administration | 18.87 | 19.88 | 15.52 | 19.89 | 18.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30758 | 30758 | USA | United States of America | Norfolk | USA0002590 | 5.0 | 44.8053 | -74.9975 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 28.591 | 28.155 | 24.632 | 17.831 | 31.355 | 22.39 | 26.95 | U.S. Energy Information Administration | 21.61 | 21.85 | 19.11 | 20.79 | 19.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30978 | 30978 | USA | United States of America | Olsen | USA0050180 | 5.0 | 40.6705 | -121.8906 | Hydro | 1990.0 | Olsen Power Partners | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34075 | 2019 | 4.961 | 3.881 | 1.314 | 12.003 | 2.541 | 6.106 | 14.168 | U.S. Energy Information Administration | 11.42 | 12.33 | 11.31 | 13.99 | 13.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31454 | 31454 | USA | United States of America | Pioneer | USA0003656 | 5.0 | 41.2436 | -111.9465 | Hydro | 1910.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29537 | 2019 | 7.718 | 9.008 | 9.846 | 11.369 | 27.134 | 9.235 | 21.353 | U.S. Energy Information Administration | 12.19 | 12.47 | 11.66 | 13.23 | 12.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32136 | 32136 | USA | United States of America | Río Blanco | WRI1026831 | 5.0 | 18.2436 | -65.7852 | Hydro | PREPA | PREPA | http://energia.pr.gov/datos/plantas/ | WRI | 30945 | 12.48 | 12.48 | 10.04 | 12.51 | 10.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
32299 | 32299 | USA | United States of America | San Gabriel Hydro Project | USA0054017 | 5.0 | 34.2043 | -117.8557 | Hydro | 1988.0 | Los Angeles County-San Gabriel | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22577 | 2019 | 0.458 | 0.61 | 0.236 | 0.855 | 10.011 | 0.0 | 9.147 | U.S. Energy Information Administration | 10.45 | 10.45 | 8.02 | 10.48 | 8.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32658 | 32658 | USA | United States of America | Snowden | USA0003821 | 5.0 | 37.5736 | -79.3715 | Hydro | 1987.0 | Town of Bedford - (VA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14258 | 2019 | 9.214 | 19.492 | 19.492 | 14.567 | 9.205 | 12.411 | 14.53 | U.S. Energy Information Administration | 17.41 | 19.93 | 15.64 | 19.98 | 17.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33029 | 33029 | USA | United States of America | Stony Gorge | USA0007151 | 5.0 | 39.5869 | -122.5332 | Hydro | 1986.0 | City of Santa Clara - (CA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32087 | 2019 | 7.76457 | 5.2836300000000005 | 5.99 | 8.729000000000001 | 13.331 | 4.343 | 14.337 | U.S. Energy Information Administration | 11.84 | 13.4 | 11.79 | 15.18 | 13.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33541 | 33541 | USA | United States of America | Tuxedo | USA0002736 | 5.0 | 35.245 | -82.3894 | Hydro | 1920.0 | Northbrook Tuxedo LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 32.738 | 17.125 | 19.661 | 18.557 | 14.694 | 33.861000000000004 | 21.884 | U.S. Energy Information Administration | 10.49 | 10.49 | 10.04 | 10.52 | 8.83 | 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");