global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
28 rows where commissioning_year = "1925.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 22
- Erie Boulevard Hydropower LP 5
- Duke Energy Carolinas LLC 2
- Wisconsin Public Service Corp 2
- BP Piney & Deep Creek LLC 1
- Brookfield White Pine Hydro LLC 1
- Central Rivers Power NH LLC 1
- City of Colorado Springs - (CO) 1
- City of Seattle - (WA) 1
- Consumers Energy Co 1
- Entergy Arkansas LLC 1
- Georgia Power Co 1
- Kentucky Utilities Co 1
- Los Angeles Department of Water & Power 1
- Mahi Pono LLC 1
- Midwest Hydro LLC 1
- NorthWestern Energy 1
- Northbrook Carolina Hydro II LLC 1
- Northern Indiana Pub Serv Co 1
- PacifiCorp 1
- Pacific Gas & Electric Co. 1
- STS Hydropower LLC 1
- Turlock Irrigation District 1
primary_fuel 1
- Hydro · 28 ✖
country_long 1
- United States of America · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24915 | 24915 | USA | United States of America | Alexander | USA0004060 | 4.199999999999999 | 45.1875 | -89.7553 | Hydro | 1925.0 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37242 | 2019 | 20.622 | 26.378 | 23.609 | 28.669 | 30.22 | 24.375 | 29.103 | U.S. Energy Information Administration | 16.04 | 22.04 | 16.07 | 23.4 | 19.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25252 | 25252 | USA | United States of America | Ayers Island | USA0002355 | 8.399999999999999 | 43.5978 | -71.7177 | Hydro | 1925.0 | Central Rivers Power NH LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30816 | 2019 | 46.703 | 43.686 | 37.796 | 37.229 | 44.562 | 48.16 | 49.55 | U.S. Energy Information Administration | 27.92 | 29.48 | 21.01 | 29.56 | 25.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25549 | 25549 | USA | United States of America | Big Pine Creek | USA0000391 | 3.2 | 37.1428 | -118.3241 | Hydro | 1925.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25082 | 2019 | 3.241 | 9.526 | 9.553 | 1.484 | 12.959 | 12.883 | 0.16 | U.S. Energy Information Administration | 7.9 | 7.9 | 7.56 | 8.45 | 7.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26267 | 26267 | USA | United States of America | Cedar Falls (WA) | USA0006430 | 30.0 | 47.4193 | -121.7819 | Hydro | 1925.0 | City of Seattle - (WA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32343 | 2019 | 76.889 | 65.197 | 47.084 | 67.964 | 82.923 | 86.94 | 40.858 | U.S. Energy Information Administration | 87.66 | 101.32 | 72.91 | 90.64 | 87.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26662 | 26662 | USA | United States of America | Copco 2 | USA0000295 | 27.0 | 41.9757 | -122.3581 | Hydro | 1925.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 83.609 | 86.43900000000001 | 77.098 | 104.792 | 138.29 | 92.72 | 108.585 | U.S. Energy Information Administration | 96.14 | 95.8 | 66.19 | 102.94 | 83.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26980 | 26980 | USA | United States of America | Dayton Hydro | USA0010520 | 3.6 | 41.3878 | -88.7897 | Hydro | 1925.0 | Midwest Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 17.563 | 19.951 | 15.878 | 21.31 | 19.595 | 21.856 | 23.487 | U.S. Energy Information Administration | 14.03 | 13.87 | 12.5 | 15.02 | 12.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27003 | 27003 | USA | United States of America | Deep Creek | USA0001567 | 20.0 | 39.523 | -79.413 | Hydro | 1925.0 | BP Piney & Deep Creek LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29918 | 2019 | 27.622 | 20.876 | 25.702 | 23.184 | 30.037 | 42.478 | 26.186 | U.S. Energy Information Administration | 48.48 | 54.09 | 54.17 | 62.54 | 44.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27023 | 27023 | USA | United States of America | Deferiet | USA0002552 | 12.0 | 44.0381 | -75.6806 | Hydro | 1925.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27800 | 2019 | 60.001000000000005 | 58.870000000000005 | 44.038 | 45.236 | 68.224 | 50.799 | 70.22500000000001 | U.S. Energy Information Administration | 55.09 | 56.77 | 44.33 | 53.16 | 51.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27130 | 27130 | USA | United States of America | Dix Dam | USA0001354 | 28.200000000000003 | 37.7864 | -84.7028 | Hydro | 1925.0 | Kentucky Utilities Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23988 | 2019 | 106.623 | 72.287 | 97.943 | 78.642 | 59.235 | 152.672 | 106.045 | U.S. Energy Information Administration | 77.54 | 75.17 | 70.39 | 76.85 | 64.45 | 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 | |||
27821 | 27821 | USA | United States of America | Franklin (NC) | USA0002745 | 1.0 | 35.2194 | -83.3708 | Hydro | 1925.0 | Northbrook Carolina Hydro II LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27076 | 2019 | 5.284 | 4.127 | 1.873 | 1.746 | 3.044 | 3.726 | 2.795 | U.S. Energy Information Administration | 4.17 | 4.12 | 4.32 | 4.16 | 3.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28606 | 28606 | USA | United States of America | High Falls - Croghan NY | USA0002575 | 6.0 | 43.9247 | -75.3731 | Hydro | 1925.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27824 | 2019 | 30.246 | 35.077 | 25.565 | 27.824 | 35.027 | 31.952 | 37.802 | U.S. Energy Information Administration | 24.18 | 25.41 | 21.31 | 24.88 | 23.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28659 | 28659 | USA | United States of America | Hodenpyl | USA0001708 | 17.0 | 44.3629 | -85.82 | Hydro | 1925.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17523 | 2019 | 50.256 | 55.117 | 47.846 | 50.017 | 53.376 | 45.966 | 52.862 | U.S. Energy Information Administration | 68.46 | 70.68 | 56.84 | 66.06 | 62.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29176 | 29176 | USA | United States of America | Kaheka Hydro | USA0055864 | 4.5 | 20.8886 | -156.3569 | Hydro | 1925.0 | Mahi Pono LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 48726 | 2019 | 8.23779 | 17.82792 | 17.88831 | 2.737 | 3.249 | 3.599 | 0.8250000000000001 | U.S. Energy Information Administration | 16.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29419 | 29419 | USA | United States of America | La Grange | USA0000440 | 4.5 | 37.6697 | -120.4436 | Hydro | 1925.0 | Turlock Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35103 | 2019 | 9.501 | 7.657 | 7.918 | 9.54 | 5.5440000000000005 | 8.374 | 10.749 | U.S. Energy Information Administration | 14.3 | 14.59 | 14.35 | 15.98 | 17.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30530 | 30530 | USA | United States of America | Mystic | USA0002192 | 12.0 | 45.2257 | -109.7625 | Hydro | 1925.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26739 | 2019 | 54.124 | 57.106 | 57.481 | 51.416 | 61.891 | 61.328 | 57.802 | U.S. Energy Information Administration | 30.51 | 30.51 | 29.0 | 30.59 | 26.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30786 | 30786 | USA | United States of America | North Gorham | USA0001501 | 2.2 | 43.8025 | -70.4499 | Hydro | 1925.0 | Brookfield White Pine Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15907 | 2019 | 8.813 | 10.404 | 8.273 | 9.712 | 10.383 | 10.291 | 12.152 | U.S. Energy Information Administration | 8.61 | 8.16 | 7.07 | 8.18 | 7.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30918 | 30918 | USA | United States of America | Oakdale | USA0000999 | 11.8 | 40.6564 | -86.7528 | Hydro | 1925.0 | Northern Indiana Pub Serv Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27966 | 2019 | 3.452 | 12.655 | 18.521 | 16.266000000000002 | 32.444 | 23.693 | 24.784 | U.S. Energy Information Administration | 41.8 | 42.21 | 37.98 | 37.94 | 41.02 | 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 | |||
31466 | 31466 | USA | United States of America | Pit 3 | USA0000266 | 80.1 | 40.9974 | -121.7481 | Hydro | 1925.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29415 | 2019 | 258.625 | 214.655 | 237.705 | 299.634 | 241.413 | 257.821 | 362.321 | U.S. Energy Information Administration | 269.42 | 259.54 | 200.6 | 284.24 | 249.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31882 | 31882 | USA | United States of America | Remmel | USA0000174 | 9.0 | 34.4272 | -92.8941 | Hydro | 1925.0 | Entergy Arkansas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13530 | 2019 | 29.017 | 35.577 | 39.0 | 42.767 | 25.438 | 38.312 | 52.620000000000005 | U.S. Energy Information Administration | 34.87 | 37.16 | 36.78 | 37.79 | 29.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31898 | 31898 | USA | United States of America | Rhodhiss | USA0002730 | 25.5 | 35.7742 | -81.4378 | Hydro | 1925.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18739 | 2019 | 96.62 | 62.36 | 71.077 | 58.221 | 61.738 | 119.297 | 95.863 | U.S. Energy Information Administration | 92.97 | 88.66 | 67.93 | 81.17 | 66.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32132 | 32132 | USA | United States of America | Ruxton Park | USA0000495 | 1.0 | 38.8414 | -104.9738 | Hydro | 1925.0 | City of Colorado Springs - (CO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17064 | 2019 | 1.596 | 1.076 | 0.516 | 0.766 | 0.868 | 0.0 | 0.845 | U.S. Energy Information Administration | 2.95 | 2.97 | 3.23 | 2.98 | 2.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32330 | 32330 | USA | United States of America | Sandstone Rapids | USA0004074 | 3.8 | 45.2333 | -88.0678 | Hydro | 1925.0 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37259 | 2019 | 10.182 | 13.127 | 13.418 | 23.481 | 18.209 | 13.484 | 16.572 | U.S. Energy Information Administration | 10.01 | 12.14 | 13.88 | 15.58 | 12.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32463 | 32463 | USA | United States of America | Sewalls | USA0002608 | 2.0 | 43.9775 | -75.8942 | Hydro | 1925.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27856 | 2019 | 13.438 | 11.139 | 6.413 | 9.683 | 14.004 | 7.579 | 14.964 | U.S. Energy Information Administration | 9.12 | 9.4 | 7.83 | 8.86 | 8.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32668 | 32668 | USA | United States of America | Soft Maple | USA0002610 | 16.0 | 43.9206 | -75.2433 | Hydro | 1925.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27858 | 2019 | 38.551 | 45.733 | 31.738 | 33.67 | 51.188 | 39.2 | 52.217 | U.S. Energy Information Administration | 64.43 | 67.72 | 54.27 | 66.31 | 64.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33318 | 33318 | USA | United States of America | Terrora | USA0000724 | 16.0 | 34.7504 | -83.4063 | Hydro | 1925.0 | Georgia Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21002 | 2019 | 63.82 | 34.879 | 38.107 | 32.683 | 34.267 | 53.376 | 48.395 | U.S. Energy Information Administration | 54.33 | 53.74 | 45.29 | 54.25 | 47.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34473 | 34473 | USA | United States of America | Wylie | USA0003271 | 60.0 | 35.0218 | -81.0078 | Hydro | 1925.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18749 | 2019 | 208.806 | 143.153 | 143.06900000000002 | 124.836 | 98.272 | 175.81 | 77.824 | U.S. Energy Information Administration | 210.01 | 212.19 | 147.2 | 216.44 | 162.6 | 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");