global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where estimated_generation_note_2013 = "HYDRO-V1", owner = "Consumers Energy Co" and year_of_capacity_data = 2019
This data as json, CSV (advanced)
Suggested facets: capacity_mw, commissioning_year, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24910 | 24910 | USA | United States of America | Alcona | USA0001693 | 8.0 | 44.562 | -83.8045 | Hydro | 1924.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17506 | 2019 | 27.658 | 30.711 | 28.055 | 29.953 | 33.507 | 30.764 | 33.312 | U.S. Energy Information Administration | 31.77 | 33.48 | 25.04 | 32.43 | 30.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
24926 | 24926 | USA | United States of America | Allegan Dam | USA0001694 | 2.6 | 42.5638 | -85.954 | Hydro | 1939.615384615385 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17507 | 2019 | 14.281 | 13.444 | 13.521 | 14.91 | 14.073 | 14.093 | 13.951 | U.S. Energy Information Administration | 10.18 | 9.4 | 8.34 | 10.22 | 9.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25957 | 25957 | USA | United States of America | C W Tippy | USA0001698 | 20.1 | 44.2591 | -85.9396 | Hydro | 1918.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17514 | 2019 | 64.246 | 68.32900000000001 | 60.057 | 63.254 | 66.737 | 61.368 | 66.726 | U.S. Energy Information Administration | 77.25 | 76.38 | 60.71 | 75.43 | 64.42 | 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 | |||
26829 | 26829 | USA | United States of America | Croton | USA0001701 | 8.9 | 43.4373 | -85.6645 | Hydro | 1909.1011235955052 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17515 | 2019 | 26.23 | 25.964 | 37.502 | 37.937 | 33.957 | 35.266 | 39.846 | U.S. Energy Information Administration | 38.35 | 38.49 | 27.96 | 37.35 | 34.85 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27669 | 27669 | USA | United States of America | Five Channels | USA0001704 | 6.0 | 44.4555 | -83.6763 | Hydro | 1912.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17520 | 2019 | 23.452 | 24.376 | 24.146 | 27.063 | 28.216 | 26.448 | 28.75 | U.S. Energy Information Administration | 24.19 | 25.47 | 18.78 | 24.69 | 23.04 | 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 | |||
28455 | 28455 | USA | United States of America | Hardy | USA0001707 | 31.5 | 43.4866 | -85.6299 | Hydro | 1931.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17522 | 2019 | 112.75 | 108.301 | 94.948 | 103.775 | 118.092 | 104.263 | 135.80100000000002 | U.S. Energy Information Administration | 108.88 | 108.88 | 73.79 | 104.8 | 94.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28659 | 28659 | USA | United States of America | Hodenpyl | USA0001708 | 17.0 | 44.3629 | -85.82 | Hydro | 1925.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17523 | 2019 | 50.256 | 55.117 | 47.846 | 50.017 | 53.376 | 45.966 | 52.862 | U.S. Energy Information Administration | 68.46 | 70.68 | 56.84 | 66.06 | 62.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29770 | 29770 | USA | United States of America | Loud | USA0001712 | 4.0 | 44.4631 | -83.7208 | Hydro | 1913.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17532 | 2019 | 17.623 | 17.766000000000002 | 17.807 | 19.867 | 20.585 | 19.33 | 21.144 | U.S. Energy Information Administration | 16.19 | 17.02 | 13.44 | 16.49 | 15.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29799 | 29799 | USA | United States of America | Ludington | USA0001713 | 1978.8 | 43.8942 | -86.4447 | Hydro | 1973.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17531 | 2019 | -870.822 | -700.889 | -480.821 | -751.65 | -674.759 | -698.455 | -696.488 | U.S. Energy Information Administration | 5474.06 | 5474.06 | 5210.49 | 5489.06 | 4633.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30301 | 30301 | USA | United States of America | Mio | USA0001714 | 5.0 | 44.6611 | -84.1317 | Hydro | 1916.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17533 | 2019 | 14.814 | 16.325 | 15.618 | 16.398 | 16.667 | 15.587 | 18.469 | U.S. Energy Information Administration | 18.87 | 19.88 | 15.52 | 19.89 | 18.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32057 | 32057 | USA | United States of America | Rogers | USA0001716 | 6.8 | 43.613 | -85.4795 | Hydro | 1922.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17537 | 2019 | 26.781 | 25.367 | 20.82 | 17.68 | 17.667 | 22.815 | 17.245 | U.S. Energy Information Administration | 27.06 | 27.56 | 20.5 | 26.55 | 25.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34079 | 34079 | USA | United States of America | Webber | USA0001722 | 4.3 | 42.9528 | -84.9025 | Hydro | 1916.767441860465 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17541 | 2019 | 8.014 | 11.249 | 10.362 | 11.216 | 12.686 | 8.836 | 14.408 | U.S. Energy Information Administration | 15.46 | 16.71 | 14.81 | 17.99 | 15.37 | 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");