global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
15 rows where capacity_mw = "1.1", geolocation_source = "U.S. Energy Information Administration" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
owner 13
- PacifiCorp 2
- Snow Mountain Hydro LLC 2
- Boltonville Hydro Associates 1
- C-Drop 1
- Central Rivers Power NH LLC 1
- Erie Boulevard Hydropower LP 1
- Hollingworth & Vose Co Center Falls 1
- KEI (Maine) Power Management (II) LLC 1
- Lockhart Power Co 1
- Midwest Hydro LLC 1
- N E W Hydro LLC 1
- Riverside Investments LLC 1
- STS Hydropower LLC 1
primary_fuel 1
- Hydro · 15 ✖
country_long 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25476 | 25476 | USA | United States of America | Bend | USA0006484 | 1.1 | 44.0623 | -121.3133 | Hydro | 1916.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29487 | 2019 | 1.925 | 2.498 | 2.396 | 1.958 | 2.295 | 1.448 | 1.559 | U.S. Energy Information Administration | 4.45 | 4.04 | 4.34 | 4.1 | 3.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25706 | 25706 | USA | United States of America | Boltonville Hydro Associates | USA0050539 | 1.1 | 44.1706 | -72.0994 | Hydro | 1985.6363636363635 | Boltonville Hydro Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36551 | 2019 | 4.648 | 3.978 | 4.354 | 3.981 | 4.729 | 3.672 | 4.172 | U.S. Energy Information Administration | 2.46 | 2.47 | 2.6 | 2.48 | 2.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25959 | 25959 | USA | United States of America | C-Drop Hydro | USA0058470 | 1.1 | 42.1658 | -121.685 | Hydro | 2012.0 | C-Drop | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 64336 | 2019 | 1.904 | 2.152 | 2.246 | 2.539 | 2.331 | 1.776 | 2.207 | U.S. Energy Information Administration | 3.18 | 3.28 | 3.29 | 3.66 | 3.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26136 | 26136 | USA | United States of America | Canaan | USA0003750 | 1.1 | 44.9993 | -71.5302 | Hydro | 1927.0 | Central Rivers Power NH LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30817 | 2019 | 6.0 | 7.081 | 7.179 | 5.365 | 7.465 | 3.722 | 6.106 | U.S. Energy Information Administration | 4.29 | 4.71 | 3.84 | 4.6 | 4.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26289 | 26289 | USA | United States of America | Center Falls | USA0010853 | 1.1 | 43.0967 | -73.4602 | Hydro | 1984.0 | Hollingworth & Vose Co Center Falls | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22252 | 2019 | 0.002 | 2.097 | 2.664 | 2.431 | 3.1910000000000003 | 3.051 | 1.698 | U.S. Energy Information Administration | 3.94 | 3.61 | 4.06 | 3.62 | 3.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27603 | 27603 | USA | United States of America | Fargo Drop | USA0058384 | 1.1 | 43.625 | -116.8997 | Hydro | 2013.0 | Riverside Investments LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 64914 | 2019 | 3.487 | 3.487 | 3.498 | 4.847 | 3.979 | 3.933 | 3.757 | U.S. Energy Information Administration | 3.62 | 5.45 | 3.37 | 3.63 | 3.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29196 | 29196 | USA | United States of America | Kanaka | USA0054653 | 1.1 | 39.5589 | -121.2961 | Hydro | 1989.0 | STS Hydropower LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33819 | 2019 | 0.304 | 0.543 | 0.138 | 1.277 | 0.8140000000000001 | 0.0 | 0.0 | U.S. Energy Information Administration | 3.22 | 4.29 | 3.94 | 4.57 | 4.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29763 | 29763 | USA | United States of America | Lost Creek I | USA0010708 | 1.1 | 40.7576 | -121.4145 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.893 | 4.772 | 4.284 | 4.032 | 5.393 | 5.551 | 6.497 | U.S. Energy Information Administration | 3.63 | 3.51 | 3.42 | 4.36 | 3.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30937 | 30937 | USA | United States of America | Oconto Falls Upper | USA0004044 | 1.1 | 44.8764 | -88.1475 | Hydro | 1921.2727272727277 | N E W Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37194 | 2019 | 6.293 | 7.742 | 7.691 | 8.129 | 9.091 | 7.504 | 9.523 | U.S. Energy Information Administration | 3.74 | 3.89 | 4.33 | 3.89 | 3.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31474 | 31474 | USA | United States of America | Pittsfield Hydro | USA0054124 | 1.1 | 44.7214 | -69.412 | Hydro | 1986.0 | KEI (Maine) Power Management (II) LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.41936 | 5.26086 | 4.204 | 2.858 | 3.777 | 3.306 | 4.228 | U.S. Energy Information Administration | 4.23 | 4.39 | 3.92 | 4.15 | 3.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31529 | 31529 | USA | United States of America | Ponderosa Bailey Creek | USA0010709 | 1.1 | 40.4579 | -121.8427 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22119 | 2019 | 0.799 | 0.632 | 0.318 | 3.515 | 5.273 | 1.771 | 3.808 | U.S. Energy Information Administration | 2.45 | 2.46 | 2.61 | 2.47 | 2.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32037 | 32037 | USA | United States of America | Rockton | USA0000903 | 1.1 | 42.4511 | -89.0756 | Hydro | 1928.9999999999995 | Midwest Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32879 | 2019 | 5.902 | 6.21 | 5.1770000000000005 | 5.718 | 5.8500000000000005 | 4.525 | 3.793 | U.S. Energy Information Administration | 4.48 | 4.53 | 4.11 | 5.02 | 3.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33237 | 33237 | USA | United States of America | Talcville | USA0007583 | 1.1 | 44.3083 | -75.3083 | Hydro | 1986.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27868 | 2019 | 0.617 | 3.389 | 2.618 | 2.682 | 5.9350000000000005 | 3.936 | 4.908 | U.S. Energy Information Administration | 4.17 | 4.67 | 4.23 | 4.25 | 4.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33696 | 33696 | USA | United States of America | Upper Pacolet Hydro | USA0058257 | 1.1 | 34.9214 | -81.7456 | Hydro | 2013.0 | Lockhart Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26457 | 2019 | 6.069 | 5.386 | 5.279 | 4.704 | 4.17 | 4.882 | 5.3740000000000006 | U.S. Energy Information Administration | 3.46 | 2.7 | 3.94 | 4.2 | 2.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33939 | 33939 | USA | United States of America | Wallowa Falls | USA0003041 | 1.1 | 45.2667 | -117.2127 | Hydro | 1921.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29551 | 2019 | 5.34 | 2.354 | 3.49 | 4.34 | 4.642 | 4.664 | 2.745 | U.S. Energy Information Administration | 2.45 | 2.46 | 2.61 | 2.47 | 2.07 | 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");