global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where capacity_mw = "9.0", country_long = "United States of America", primary_fuel = "Hydro" and source = "U.S. Energy Information Administration"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2015, generation_gwh_2017, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2016
owner 13
- Consumers Energy Co 2
- Duke Energy Carolinas LLC 1
- Eagle Creek RE LLC 1
- Entergy Arkansas LLC 1
- Erie Boulevard Hydropower LP 1
- FirstLight Power Resources Services LLC 1
- Los Angeles Department of Water & Power 1
- Marysville Hydro Partners 1
- Merced Irrigation District 1
- Metropolitan Water District of S CA 1
- New York Power Authority 1
- Wisconsin Electric Power Co 1
- Wood Hydro LLC 1
primary_fuel 1
- Hydro · 14 ✖
country_long 1
- United States of America · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25405 | 25405 | USA | United States of America | Bear Creek Dam | USA0002741 | 9.0 | 35.2427 | -83.072 | Hydro | 1954.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27072 | 2019 | 37.843 | 21.207 | 27.553 | 18.298 | 1.229 | 37.232 | 21.408 | U.S. Energy Information Administration | 23.58 | 23.58 | 22.51 | 23.64 | 20.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25447 | 25447 | USA | United States of America | Beebee Island Hydro Plant | USA0010531 | 9.0 | 43.9767 | -75.9072 | Hydro | 1931.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27786 | 2019 | 47.713 | 43.841 | 42.199 | 41.902 | 52.082 | 39.261 | 50.626 | U.S. Energy Information Administration | 41.0 | 42.26 | 33.66 | 39.55 | 38.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26650 | 26650 | USA | United States of America | Cooke | USA0001700 | 9.0 | 44.4726 | -83.5719 | Hydro | 1911.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17512 | 2019 | 26.621 | 29.612 | 26.976 | 28.984 | 30.436 | 28.36 | 32.385 | U.S. Energy Information Administration | 35.74 | 37.67 | 28.17 | 36.48 | 34.42 | 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 | |||
27599 | 27599 | USA | United States of America | Falls Village | USA0000560 | 9.0 | 41.9573 | -73.3693 | Hydro | 1914.0 | FirstLight Power Resources Services LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17272 | 2019 | 38.863 | 45.744 | 30.932 | 25.188 | 33.205 | 45.223 | 42.152 | U.S. Energy Information Administration | 27.5 | 30.65 | 21.36 | 23.7 | 23.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27721 | 27721 | USA | United States of America | Foote | USA0001705 | 9.0 | 44.4354 | -83.4407 | Hydro | 1918.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17518 | 2019 | 30.114 | 30.345 | 29.492 | 30.66 | 33.106 | 32.152 | 36.618 | U.S. Energy Information Administration | 35.74 | 37.67 | 28.17 | 36.48 | 34.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27727 | 27727 | USA | United States of America | Foothill Feeder | USA0006645 | 9.0 | 34.5148 | -118.6092 | Hydro | 1981.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26171 | 2019 | 59.567 | 24.918 | 0.0 | 27.372 | 52.669 | 48.539 | 44.336 | U.S. Energy Information Administration | 23.15 | 22.29 | 21.55 | 22.35 | 19.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29063 | 29063 | USA | United States of America | Jarvis (Hinckley) | USA0000808 | 9.0 | 43.3121 | -75.109 | Hydro | 1991.0 | New York Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27569 | 2019 | 23.889 | 26.453 | 21.0 | 29.119 | 37.241 | 25.687 | 40.652 | U.S. Energy Information Administration | 33.84 | 35.73 | 26.37 | 32.07 | 30.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29683 | 29683 | USA | United States of America | Little Quinnesec Falls Hydro Project | USA0057190 | 9.0 | 45.7736 | -87.9894 | Hydro | 1909.488888888889 | Eagle Creek RE LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 24085 | 2019 | 52.998 | 47.183 | 56.914 | 67.174 | 70.935 | 67.174 | 69.632 | U.S. Energy Information Administration | 35.2 | 39.79 | 33.93 | 39.06 | 43.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29894 | 29894 | USA | United States of America | Magic Dam Hydroelectric Project | USA0010740 | 9.0 | 43.2547 | -114.3569 | Hydro | 1989.0 | Wood Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25391 | 2019 | 0.5670000000000001 | 5.806 | 5.57 | 16.892 | 0.0 | 19.969 | 27.739 | U.S. Energy Information Administration | 31.83 | 30.64 | 28.79 | 34.29 | 30.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30095 | 30095 | USA | United States of America | McSwain | USA0000410 | 9.0 | 37.5221 | -120.3101 | Hydro | 1967.0 | Merced Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26021 | 2019 | 20.229 | 11.144 | 0.925 | 20.145 | 55.762 | 29.383 | 46.925 | U.S. Energy Information Administration | 30.66 | 26.32 | 23.57 | 31.78 | 32.15 | 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 | ||||
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 | |||
34263 | 34263 | USA | United States of America | White Rapids | USA0001786 | 9.0 | 45.4821 | -87.8022 | Hydro | 1927.0 | Wisconsin Electric Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37213 | 2019 | 31.325 | 36.848 | 37.77 | 40.46 | 48.395 | 39.099 | 38.412 | U.S. Energy Information Administration | 34.91 | 38.7 | 35.27 | 38.88 | 43.5 | 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");