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 = "1928.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, latitude
owner 12
- Erie Boulevard Hydropower LP 5
- Pacific Gas & Electric Co. 3
- Green Mountain Power Corp 2
- Northern States Power Co - Minnesota 2
- Alabama Power Co 1
- Brookfield Smoky Mountain Hydropower LP 1
- Brookfield White Pine Hydro LLC 1
- Central Rivers Power MA LLC 1
- Duke Energy Carolinas LLC 1
- Great River Hydro LLC 1
- Louisville Gas & Electric Co 1
- PacifiCorp 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25059 | 25059 | USA | United States of America | Androscoggin 3 | USA0001480 | 3.6 | 44.1353 | -70.2015 | Hydro | 1928.0 | Brookfield White Pine Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15881 | 2019 | 26.22 | 31.136 | 14.652 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 15.9 | 16.21 | 13.97 | 15.31 | 14.03 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25469 | 25469 | USA | United States of America | Bellows Falls | USA0003745 | 40.8 | 43.1375 | -72.4464 | Hydro | 1928.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27424 | 2019 | 248.673 | 236.573 | 215.228 | 183.361 | 238.173 | 246.119 | 255.044 | U.S. Energy Information Administration | 150.45 | 150.45 | 104.58 | 150.86 | 128.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25885 | 25885 | USA | United States of America | Bucks Creek | USA0000220 | 66.0 | 39.9106 | -121.3277 | Hydro | 1928.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29360 | 2019 | 137.772 | 70.387 | 79.157 | 260.39300000000003 | 265.473 | 131.028 | 160.302 | U.S. Energy Information Administration | 232.28 | 219.6 | 192.7 | 253.52 | 207.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26418 | 26418 | USA | United States of America | Chippewa Falls | USA0004000 | 21.6 | 44.9308 | -91.3889 | Hydro | 1928.0 | Northern States Power Co - Minnesota | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28309 | 2019 | 62.167 | 89.09100000000001 | 81.468 | 95.223 | 93.086 | 76.383 | 85.921 | U.S. Energy Information Administration | 104.94 | 107.76 | 91.11 | 100.88 | 94.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27304 | 27304 | USA | United States of America | East Norfolk | USA0002561 | 4.0 | 44.7989 | -74.9856 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27798 | 2019 | 27.029 | 24.853 | 22.222 | 20.699 | 10.801 | 21.909 | 22.531 | U.S. Energy Information Administration | 17.82 | 18.01 | 16.0 | 16.97 | 16.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27356 | 27356 | USA | United States of America | Eel Weir | USA0002556 | 2.5 | 44.6384 | -75.4905 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27810 | 2019 | 9.755 | 9.506 | 7.67 | 7.648000000000001 | 10.619 | 6.98 | 8.767 | U.S. Energy Information Administration | 10.56 | 10.79 | 9.86 | 10.37 | 10.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28166 | 28166 | USA | United States of America | Gorge 18 | USA0006475 | 3.0 | 44.49 | -73.1693 | Hydro | 1928.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21409 | 2019 | 9.374 | 11.189 | 15.073 | 14.321 | 12.633 | 9.791 | 12.701 | U.S. Energy Information Administration | 10.86 | 11.59 | 9.81 | 11.39 | 10.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28882 | 28882 | USA | United States of America | Indian Orchard | USA0006379 | 3.7 | 42.161 | -72.5076 | Hydro | 1928.0 | Central Rivers Power MA LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36695 | 2019 | 7.274 | 4.57 | 3.803 | 3.601 | 6.454 | 6.687 | 9.942 | U.S. Energy Information Administration | 9.25 | 10.67 | 10.33 | 9.27 | 10.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30211 | 30211 | USA | United States of America | Middlesex 2 | USA0003740 | 3.2 | 44.2924 | -72.6824 | Hydro | 1928.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21411 | 2019 | 11.865 | 9.432 | 10.303 | 6.938 | 14.158 | 9.57 | 12.049 | U.S. Energy Information Administration | 11.52 | 12.1 | 10.35 | 12.38 | 10.42 | 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 | ||||
30844 | 30844 | USA | United States of America | Norwood | USA0002591 | 2.0 | 44.7439 | -75.0042 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27839 | 2019 | 15.345 | 13.555 | 13.001 | 12.056 | 14.335 | 10.051 | 10.393 | U.S. Energy Information Administration | 9.26 | 9.36 | 8.39 | 8.81 | 8.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30949 | 30949 | USA | United States of America | Ohio Falls | USA0001365 | 109.6 | 38.2832 | -85.7792 | Hydro | 1928.0 | Louisville Gas & Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25148 | 2019 | 193.332 | 271.88800000000003 | 273.77500000000003 | 316.437 | 277.577 | 190.876 | 250.858 | U.S. Energy Information Administration | 480.47 | 529.86 | 520.41 | 455.36 | 384.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31113 | 31113 | USA | United States of America | Oxford Dam | USA0002729 | 36.0 | 35.8214 | -81.1922 | Hydro | 1928.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18734 | 2019 | 141.055 | 107.244 | 94.443 | 75.181 | 59.387 | 107.478 | 131.197 | U.S. Energy Information Administration | 129.1 | 121.58 | 94.65 | 124.13 | 98.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31647 | 31647 | USA | United States of America | Prospect 2 | USA0003033 | 32.0 | 42.7312 | -122.514 | Hydro | 1928.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29532 | 2019 | 215.139 | 206.474 | 166.763 | 239.892 | 256.205 | 199.202 | 190.315 | U.S. Energy Information Administration | 87.97 | 99.48 | 63.1 | 96.24 | 76.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31826 | 31826 | USA | United States of America | Raymondville | USA0002601 | 2.0 | 44.835 | -74.9803 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27852 | 2019 | 13.712 | 13.089 | 11.075 | 9.922 | 13.044 | 10.611 | 8.876 | U.S. Energy Information Administration | 8.74 | 9.4 | 8.39 | 8.7 | 8.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32356 | 32356 | USA | United States of America | Santeetlah | USA0054898 | 45.0 | 35.4475 | -83.8639 | Hydro | 1928.0 | Brookfield Smoky Mountain Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34175 | 2019 | 204.816 | 126.602 | 155.079 | 83.767 | 100.567 | 142.814 | 176.036 | U.S. Energy Information Administration | 180.93 | 167.49 | 141.0 | 164.54 | 140.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32825 | 32825 | USA | United States of America | Spaulding 1 | USA0000281 | 7.0 | 39.3246 | -120.6448 | Hydro | 1928.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29431 | 2019 | 23.859 | 25.046 | 21.925 | 16.756 | 48.076 | 4.496 | 6.648000000000001 | U.S. Energy Information Administration | 23.65 | 22.52 | 21.89 | 29.61 | 25.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32826 | 32826 | USA | United States of America | Spaulding 2 | USA0000282 | 3.7 | 39.3246 | -120.6454 | Hydro | 1928.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29430 | 2019 | 4.736 | 1.861 | 6.45 | 0.948 | 5.053 | 8.907 | 8.166 | U.S. Energy Information Administration | 12.8 | 12.38 | 12.53 | 15.43 | 13.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33362 | 33362 | USA | United States of America | Thornapple | USA0003988 | 1.4 | 45.4111 | -91.2183 | Hydro | 1928.0 | Northern States Power Co - Minnesota | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28298 | 2019 | 8.492 | 9.768 | 9.835 | 11.683 | 11.069 | 9.607 | 9.784 | U.S. Energy Information Administration | 5.12 | 6.07 | 5.54 | 6.01 | 5.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34501 | 34501 | USA | United States of America | Yates Dam | USA0000021 | 50.5 | 32.5743 | -85.8901 | Hydro | 1928.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12600 | 2019 | 158.284 | 138.401 | 117.278 | 116.654 | 125.786 | 142.992 | 155.736 | U.S. Energy Information Administration | 180.04 | 181.06 | 147.31 | 184.62 | 149.36 | 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");