global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
10 rows where country_long = "United States of America", estimated_generation_note_2013 = "HYDRO-V1", owner = "NorthWestern Energy" and year_of_capacity_data = 2019
This data as json, CSV (advanced)
primary_fuel 1
- Hydro 10
owner 1
- NorthWestern Energy · 10 ✖
country_long 1
- United States of America · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25604 | 25604 | USA | United States of America | Black Eagle | USA0002181 | 24.0 | 47.5213 | -111.2614 | Hydro | 1927.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26726 | 2019 | 109.985 | 120.985 | 127.279 | 118.288 | 126.346 | 138.717 | 142.208 | U.S. Energy Information Administration | 102.45 | 95.45 | 70.17 | 127.56 | 88.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26544 | 26544 | USA | United States of America | Cochrane | USA0002182 | 60.4 | 47.5375 | -111.195 | Hydro | 1958.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26730 | 2019 | 229.223 | 244.51 | 260.568 | 234.165 | 288.168 | 326.28000000000003 | 326.084 | U.S. Energy Information Administration | 235.89 | 214.43 | 149.15 | 263.39 | 201.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28504 | 28504 | USA | United States of America | Hauser | USA0002185 | 17.7 | 46.7659 | -111.8873 | Hydro | 1933.033898305085 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26733 | 2019 | 115.817 | 111.83 | 122.257 | 120.437 | 130.317 | 118.094 | 126.084 | U.S. Energy Information Administration | 60.69 | 68.27 | 49.87 | 70.56 | 69.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28687 | 28687 | USA | United States of America | Holter | USA0002186 | 38.4 | 46.9915 | -112.0047 | Hydro | 1918.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26735 | 2019 | 226.345 | 249.642 | 258.627 | 254.064 | 299.866 | 341.81100000000004 | 344.89300000000003 | U.S. Energy Information Administration | 140.43 | 151.47 | 98.67 | 149.52 | 157.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29891 | 29891 | USA | United States of America | Madison Dam | USA0006422 | 8.8 | 45.4879 | -111.6338 | Hydro | 1906.5000000000005 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26738 | 2019 | 56.473 | 53.649 | 59.401 | 57.101 | 62.279 | 62.61 | 51.327 | U.S. Energy Information Administration | 30.79 | 32.89 | 28.08 | 32.79 | 31.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30428 | 30428 | USA | United States of America | Morony | USA0002191 | 63.0 | 47.5817 | -111.0609 | Hydro | 1930.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26741 | 2019 | 225.296 | 254.979 | 247.097 | 258.995 | 289.766 | 323.972 | 318.712 | U.S. Energy Information Administration | 210.89 | 191.71 | 133.34 | 251.35 | 180.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30530 | 30530 | USA | United States of America | Mystic | USA0002192 | 12.0 | 45.2257 | -109.7625 | Hydro | 1925.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26739 | 2019 | 54.124 | 57.106 | 57.481 | 51.416 | 61.891 | 61.328 | 57.802 | U.S. Energy Information Administration | 30.51 | 30.51 | 29.0 | 30.59 | 26.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31785 | 31785 | USA | United States of America | Rainbow (MT) | USA0002193 | 59.0 | 47.5344 | -111.2045 | Hydro | 2013.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 62549 | 2019 | 289.20300000000003 | 367.241 | 347.742 | 343.233 | 376.048 | 398.801 | 453.37 | U.S. Energy Information Administration | 230.42 | 209.46 | 145.69 | 274.62 | 197.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32133 | 32133 | USA | United States of America | Ryan | USA0002194 | 52.8 | 47.5699 | -111.1225 | Hydro | 1915.3257575757575 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26745 | 2019 | 395.44 | 468.992 | 447.914 | 413.979 | 423.168 | 470.678 | 484.121 | U.S. Energy Information Administration | 196.83 | 178.92 | 124.45 | 246.29 | 168.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33357 | 33357 | USA | United States of America | Thompson Falls | USA0002195 | 98.1 | 47.5932 | -115.3582 | Hydro | 1915.4179408766563 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26747 | 2019 | 482.932 | 529.751 | 522.509 | 510.256 | 498.356 | 460.628 | 449.078 | U.S. Energy Information Administration | 384.59 | 394.91 | 360.75 | 395.99 | 348.26 | 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");