global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
19 rows where capacity_mw = "1.3", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2016, generation_gwh_2017, generation_gwh_2019, 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_2017
owner 18
- Green Mountain Power Corp 2
- Blind Canyon Aqua Ranch Inc 1
- CHI Energy Inc 1
- City of Granite Falls - (MN) 1
- City of Martinsville - (VA) 1
- City of Mt Pleasant - (UT) 1
- Desert Water Agency 1
- Erie Boulevard Hydropower LP 1
- Fort Smith City of 1
- French Paper Co 1
- Grizzly Mountain Ranch 1
- Koyle Hydro Inc 1
- Mahi Pono LLC 1
- Metlakatla Power & Light 1
- North Gooding Main Hydro LLC 1
- Tarrant Regional Water District 1
- United Water Conservation Dist 1
- Wisconsin Public Service Corp 1
primary_fuel 1
- Hydro · 19 ✖
country_long 1
- United States of America · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25153 | 25153 | USA | United States of America | Arlington Outlet Hydroelectric Generator | USA0061355 | 1.3 | 32.6391 | -97.2429 | Hydro | 2015.0 | Tarrant Regional Water District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 63378 | 2019 | 0.0 | 1.588 | 1.168 | 1.49886 | U.S. Energy Information Administration | 2.91 | 2.92 | 2.89 | 2.93 | 2.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
25632 | 25632 | USA | United States of America | Blind Canyon Hydro | USA0054514 | 1.3 | 42.6998 | -114.8226 | Hydro | 1992.0 | Blind Canyon Aqua Ranch Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14642 | 2019 | 2.798 | 3.366 | 3.972 | 3.347 | 4.312 | 4.415 | 1.485 | U.S. Energy Information Administration | 3.71 | 4.17 | 3.16 | 4.2 | 3.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26388 | 26388 | USA | United States of America | Chester Lake | USA0007168 | 1.3 | 55.1169 | -131.5459 | Hydro | 1988.0 | Metlakatla Power & Light | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 45552 | 2019 | 4.368 | 5.966 | 5.429 | 4.585 | 3.839 | 5.384 | 5.809 | U.S. Energy Information Administration | 3.41 | 3.43 | 2.88 | 3.44 | 2.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27862 | 27862 | USA | United States of America | French Paper Hydro | USA0010656 | 1.3 | 41.8203 | -86.2592 | Hydro | 1925.846153846154 | French Paper Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 8.646 | 7.718 | 8.593 | 6.96 | 6.0760000000000005 | 5.266 | 4.772 | U.S. Energy Information Administration | 4.0 | 5.1 | 3.74 | 4.03 | 3.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27890 | 27890 | USA | United States of America | Fulton Hydro | USA0002566 | 1.3 | 43.3241 | -76.419 | Hydro | 1925.5384615384612 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.278 | 0.0 | 0.0 | 6.375 | 8.042 | U.S. Energy Information Administration | 3.85 | 4.16 | 4.07 | 4.16 | 3.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
28216 | 28216 | USA | United States of America | Granite Falls | USA0001977 | 1.3 | 44.8117 | -95.5345 | Hydro | 1967.0769230769235 | City of Granite Falls - (MN) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21299 | 2019 | 2.022 | 2.1750000000000003 | 2.779 | 2.434 | 4.123 | 3.851 | 2.93 | U.S. Energy Information Administration | 3.34 | 3.24 | 4.22 | 2.91 | 2.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29386 | 29386 | USA | United States of America | Koyle Ranch Hydroelectric Project | USA0010781 | 1.3 | 42.9457 | -114.7957 | Hydro | 1984.0 | Koyle Hydro Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 24272 | 2019 | 2.525 | 2.971 | 2.493 | 3.331 | 4.021 | 3.41 | 3.926 | U.S. Energy Information Administration | 5.15 | 4.31 | 4.9 | 3.81 | 3.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29585 | 29585 | USA | United States of America | Lee Creek Water Treatment Facility | USA0054283 | 1.3 | 35.4845 | -94.3929 | Hydro | 1992.0 | Fort Smith City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20443 | 2019 | -4.307 | 0.003 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 4.54 | 4.6 | 4.83 | 5.09 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30025 | 30025 | USA | United States of America | Martinsville | USA0003826 | 1.3 | 36.6641 | -79.8836 | Hydro | 1932.0 | City of Martinsville - (VA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25698 | 2019 | 2.308 | 2.004 | 2.491 | 3.217 | 1.294 | 0.647 | 0.31 | U.S. Energy Information Administration | 4.54 | 4.28 | 4.19 | 4.33 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30785 | 30785 | USA | United States of America | North Gooding Main Hydro | USA0061688 | 1.3 | 43.0451 | -114.5588 | Hydro | 2016.0 | North Gooding Main Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.315 | 4.759 | 4.793 | U.S. Energy Information Administration | 2.89 | 2.9 | 2.95 | 2.98 | 2.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
31190 | 31190 | USA | United States of America | Paia Hydroelectric Plant | USA0058277 | 1.3 | 20.8867 | -156.3378 | Hydro | 1912.0 | Mahi Pono LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.77685 | 0.7613099999999999 | 7.140000000000001 | 0.218 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 4.69 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
31575 | 31575 | USA | United States of America | Potato Rapids | USA0004071 | 1.3 | 45.1136 | -87.7586 | Hydro | 1922.923076923077 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37256 | 2019 | 4.513 | 4.852 | 5.284 | 5.0200000000000005 | 4.122 | 5.6610000000000005 | 7.009 | U.S. Energy Information Administration | 4.42 | 5.61 | 5.03 | 5.59 | 5.03 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32261 | 32261 | USA | United States of America | Salisbury | USA0003724 | 1.3 | 43.8954 | -73.1007 | Hydro | 1917.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15975 | 2019 | 3.1830000000000003 | 2.63 | 2.017 | 1.98 | 3.121 | 3.456 | 4.676 | U.S. Energy Information Administration | 4.87 | 4.91 | 4.69 | 4.9 | 4.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32345 | 32345 | USA | United States of America | Santa Felicia Dam | USA0050076 | 1.3 | 34.4617 | -118.7511 | Hydro | 1987.0 | United Water Conservation Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35395 | 2019 | 0.0 | 0.6950000000000001 | 0.082 | 0.914 | U.S. Energy Information Administration | 3.07 | 3.1 | 2.46 | 3.11 | 3.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
32733 | 32733 | USA | United States of America | Somersworth Lower Great Dam | USA0050704 | 1.3 | 43.2511 | -70.8408 | Hydro | 1985.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17442 | 2019 | 3.996 | 2.4210000000000003 | 2.509 | 2.625 | 1.821 | 3.444 | 3.397 | U.S. Energy Information Administration | 3.75 | 3.77 | 4.39 | 3.67 | 3.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33344 | 33344 | USA | United States of America | Theresa Plant | USA0010539 | 1.3 | 44.2174 | -75.7952 | Hydro | 1928.5384615384612 | CHI Energy Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27863 | 2019 | 7.623 | 7.491 | 6.273 | 6.086 | 8.779 | 5.835 | 5.945 | U.S. Energy Information Administration | 4.46 | 5.02 | 4.67 | 4.53 | 4.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33371 | 33371 | USA | United States of America | Three Forks Water Power Project | USA0054308 | 1.3 | 40.1998 | -123.5231 | Hydro | 1985.0 | Grizzly Mountain Ranch | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26898 | 2019 | 4.181 | 4.996 | 4.223 | 7.702 | 6.837 | 5.594 | 6.591 | U.S. Energy Information Administration | 2.91 | 2.92 | 2.89 | 2.93 | 2.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33650 | 33650 | USA | United States of America | Unit 4 | USA0007015 | 1.3 | 39.5441 | -111.4187 | Hydro | 1993.0 | City of Mt Pleasant - (UT) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.541 | 3.238 | 2.708 | 3.085 | 4.18 | 4.471 | 4.22 | U.S. Energy Information Administration | 3.33 | 3.35 | 3.33 | 3.36 | 2.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
34283 | 34283 | USA | United States of America | Whitewater Hydro Plant | USA0010162 | 1.3 | 33.9347 | -116.6405 | Hydro | 1986.0 | Desert Water Agency | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.631 | 0.0 | 0.0 | 1.9 | 7.176 | 2.827 | 4.005 | U.S. Energy Information Administration | 3.0 | 3.02 | 3.08 | 3.03 | 2.56 | 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");