global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
20 rows where capacity_mw = "3.6", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: source, url, generation_gwh_2017, estimated_generation_gwh_2013, 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
owner 19
- Appalachian Power Co 1
- Boyce Hydro Power LLC 1
- Brassua Hydroelectric LP 1
- Brookfield White Pine Hydro LLC 1
- Central Rivers Power MA LLC 1
- City of Bryan - (OH) 1
- Dry Creek LLC 1
- EONY Generation Limited 1
- Fall River Rural Elec Coop Inc 1
- Green Mountain Power Corp 1
- Guadalupe Blanco River Authority 1
- Lake Lure Town of 1
- McBryde Sugar Co Ltd 1
- Midwest Hydro LLC 1
- Nevada Irrigation District 1
- Public Service Co of Colorado 1
- Strawberry Water Users Assn 1
- U S Bureau of Reclamation 1
- Utica Water & Power Authority 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25033 | 25033 | USA | United States of America | Ames Hydro | USA0006207 | 3.6 | 37.866 | -107.8831 | Hydro | 1906.0 | Public Service Co of Colorado | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.964 | 2.294 | 8.996 | 6.972 | 8.109 | 2.295 | 3.398 | U.S. Energy Information Administration | 11.45 | 11.54 | 11.44 | 11.88 | 11.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
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 | |||
25221 | 25221 | USA | United States of America | Auglaize Hydro | USA0007657 | 3.6 | 41.2372 | -84.3998 | Hydro | 1996.111111111111 | City of Bryan - (OH) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30522 | 2019 | 0.011 | 10.76922 | 8.861 | 8.743 | 11.105 | 11.728 | 12.116 | U.S. Energy Information Administration | 13.08 | 12.36 | 12.64 | 13.85 | 11.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25755 | 25755 | USA | United States of America | Bowman | USA0050546 | 3.6 | 39.4484 | -120.6534 | Hydro | 1986.0 | Nevada Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55103 | 2019 | 6.28 | 5.083 | 3.953 | 14.7 | 20.462 | 13.92 | 14.275 | U.S. Energy Information Administration | 8.02 | 8.02 | 8.44 | 8.04 | 6.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25780 | 25780 | USA | United States of America | Brassua Hydroelectric Project | USA0010555 | 3.6 | 45.6603 | -69.8122 | Hydro | 1989.0 | Brassua Hydroelectric LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34037 | 2019 | 16.740000000000002 | 15.548 | 15.582 | 17.404 | 19.295 | 16.339 | 15.207 | U.S. Energy Information Administration | 14.49 | 14.76 | 12.09 | 14.65 | 12.85 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26161 | 26161 | USA | United States of America | Caonillas 2 | WRI1028016 | 3.6 | 18.2397 | -66.6691 | Hydro | CEPR | http://energia.pr.gov/datos/plantas/ | WRI | 30932 | 8.0 | 8.0 | 7.9 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
26386 | 26386 | USA | United States of America | Chester Diversion Hydroelectric Project | USA0056893 | 3.6 | 44.0183 | -111.5836 | Hydro | 2014.0 | Fall River Rural Elec Coop Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55102 | 2019 | 4.121 | 3.712 | 6.663 | 7.884 | 5.265 | 7.551 | U.S. Energy Information Administration | 13.28 | 13.19 | 12.05 | 13.3 | 12.62 | 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 | ||||
27200 | 27200 | USA | United States of America | Dry Creek Project | USA0054394 | 3.6 | 44.0274 | -112.7194 | Hydro | 1988.0 | Dry Creek LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 48767 | 2019 | 5.158 | 7.719 | 8.465 | 11.163 | 13.16 | 12.788 | 10.341 | U.S. Energy Information Administration | 8.02 | 8.02 | 8.44 | 8.04 | 6.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27221 | 27221 | USA | United States of America | Dunlap TP 1 | USA0003582 | 3.6 | 29.6402 | -98.0459 | Hydro | 1927.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21549 | 2019 | 5.674 | 3.145 | 15.303 | 17.322 | 16.179000000000002 | 12.304 | 5.974 | U.S. Energy Information Administration | 10.12 | 9.65 | 7.89 | 10.11 | 8.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29465 | 29465 | USA | United States of America | Lake Lure | USA0002773 | 3.6 | 35.4259 | -82.184 | Hydro | 1927.0000000000005 | Lake Lure Town of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 24464 | 2019 | 11.62656 | 7.99524 | 6.272 | 7.99 | 5.492 | 10.526 | 10.171 | U.S. Energy Information Administration | 8.0 | 8.0 | 7.95 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30510 | 30510 | USA | United States of America | Murphys | USA0000261 | 3.6 | 38.1471 | -120.4464 | Hydro | 1954.0 | Utica Water & Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29404 | 2019 | 12.227 | 11.545 | 6.187 | 13.756 | 18.573 | 14.187 | 14.963 | U.S. Energy Information Administration | 8.3 | 8.3 | 8.46 | 8.32 | 7.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30714 | 30714 | USA | United States of America | Niagara | USA0003778 | 3.6 | 37.2544 | -79.8756 | Hydro | 1954.0 | Appalachian Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13362 | 2019 | 10.449 | 8.006 | 0.0 | 0.0 | 0.0 | 7.858 | 10.524 | U.S. Energy Information Administration | 7.67 | 8.96 | 7.46 | 8.98 | 8.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31387 | 31387 | USA | United States of America | Philadlephia | USA0010197 | 3.6 | 44.1586 | -75.7088 | Hydro | 1986.0 | EONY Generation Limited | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.83 | 8.325 | 0.926 | 6.121 | 12.72 | 10.197 | 14.769 | U.S. Energy Information Administration | 11.25 | 12.92 | 11.5 | 11.33 | 12.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31475 | 31475 | USA | United States of America | Pittsford | USA0003722 | 3.6 | 43.694 | -72.955 | Hydro | 1914.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.848 | 8.439 | 8.359 | 7.725 | 9.608 | 10.15 | 11.389 | U.S. Energy Information Administration | 8.3 | 8.3 | 8.46 | 8.32 | 7.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31858 | 31858 | USA | United States of America | Redbridge | USA0001638 | 3.6 | 42.176 | -72.4095 | Hydro | 1930.0 | Central Rivers Power MA LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36698 | 2019 | 11.68 | 8.595 | 6.6240000000000006 | 6.694 | 10.719 | 22.792 | 17.848 | U.S. Energy Information Administration | 9.0 | 10.38 | 10.05 | 9.02 | 10.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32337 | 32337 | USA | United States of America | Sanford Dam | USA0050157 | 3.6 | 43.6773 | -84.3802 | Hydro | 1923.0 | Boyce Hydro Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37308 | 2019 | 9.045 | 8.364 | 5.11 | 9.749 | 11.534 | 11.592 | 13.452 | U.S. Energy Information Administration | 13.87 | 14.41 | 11.5 | 12.98 | 12.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32819 | 32819 | USA | United States of America | Spanish Fork | USA0003691 | 3.6 | 40.08 | -111.6048 | Hydro | 1980.4444444444443 | Strawberry Water Users Assn | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33803 | 2019 | 8.514 | 7.848 | 4.974 | 4.915 | 12.86 | 7.1930000000000005 | 13.871 | U.S. Energy Information Administration | 9.52 | 10.38 | 9.4 | 11.23 | 8.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32937 | 32937 | USA | United States of America | Stampede | USA0007066 | 3.6 | 39.4704 | -120.1046 | Hydro | 1988.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35671 | 2019 | 13.2 | 9.542 | 3.496 | 4.982 | 13.538 | 9.61 | 12.236 | U.S. Energy Information Administration | 8.0 | 8.0 | 7.9 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33924 | 33924 | USA | United States of America | Wainiha Hydro | USA0010413 | 3.6 | 22.1963 | -159.5561 | Hydro | 1908.0 | McBryde Sugar Co Ltd | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 23.136 | 25.253 | 25.222 | 24.533 | 21.475 | 20.814 | 20.536 | U.S. Energy Information Administration | 13.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");