global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
19 rows where owner = "Union Electric Co - (MO)" and source = "U.S. Energy Information Administration"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017
owner 1
- Union Electric Co - (MO) · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25219 | 25219 | USA | United States of America | Audrain Generating Station | USA0055234 | 814.3999999999999 | 39.3092 | -91.5369 | Gas | 2001.0000000000005 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 46856 | 2019 | 23.054 | 2.422 | 1.897 | 20.022 | 33.017 | 50.473 | 18.748 | U.S. Energy Information Administration | 2871.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26099 | 26099 | USA | United States of America | Callaway | USA0006153 | 1235.8 | 38.7589 | -91.7788 | Nuclear | 1985.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35247 | 2019 | 8367.103000000001 | 9276.356 | 10440.082 | 9430.179 | 8304.127 | 10655.279 | 9189.863 | U.S. Energy Information Administration | 9803.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27579 | 27579 | USA | United States of America | Fairgrounds | USA0002082 | 68.3 | 38.5935 | -92.2206 | Oil | 1974.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35253 | 2019 | 0.014 | 0.113 | -0.28 | -0.21 | -0.288 | 0.459 | -0.202 | U.S. Energy Information Administration | 40.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
28155 | 28155 | USA | United States of America | Goose Creek Energy Center | USA0055496 | 684.0 | 40.1069 | -88.5999 | Gas | 2003.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49060 | 2019 | 13.129 | -0.929 | 13.028 | 27.657 | 21.154 | 31.465 | 4.921 | U.S. Energy Information Administration | 2412.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29276 | 29276 | USA | United States of America | Keokuk | USA0001109 | 124.79999999999995 | 40.3965 | -91.3719 | Hydro | 1913.0000000000005 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35258 | 2019 | 738.922 | 869.78 | 946.037 | 899.879 | 1017.208 | 910.693 | 782.218 | U.S. Energy Information Administration | 585.39 | 567.6 | 459.75 | 629.23 | 536.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29348 | 29348 | USA | United States of America | Kinmundy | USA0055204 | 270.0 | 38.7619 | -89.0128 | Gas | Oil | 2001.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 45691 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.15 | U.S. Energy Information Administration | 952.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29431 | 29431 | USA | United States of America | Labadie | USA0002103 | 2389.4 | 38.5622 | -90.8377 | Coal | Oil | 1971.5395915292545 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35255 | 2019 | 17294.713334000004 | 15183.698224000002 | 16042.082296 | 14792.689603 | 16146.394611000002 | 15765.698617 | 14121.001902000002 | U.S. Energy Information Administration | 11037.05 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
30134 | 30134 | USA | United States of America | Meramec | USA0002104 | 1041.0 | 38.4017 | -90.3358 | Coal | Oil | Gas | 1961.335734870317 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35259 | 2019 | 2480.9279730000003 | 0.0 | 0.0 | 1663.303969 | 0.0 | 0.0 | 496.946004 | U.S. Energy Information Administration | 4808.56 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
30182 | 30182 | USA | United States of America | Mexico | USA0006650 | 60.7 | 39.1481 | -91.8306 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35261 | 2019 | -0.244 | 1.48 | -0.128 | -0.01 | -0.214 | 0.312 | 0.22 | U.S. Energy Information Administration | 35.57 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30316 | 30316 | USA | United States of America | Moberly | USA0006651 | 60.6 | 39.4244 | -92.4837 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35267 | 2019 | 0.022 | 0.547 | -0.198 | -0.195 | -0.299 | 0.279 | 2.125 | U.S. Energy Information Administration | 35.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30406 | 30406 | USA | United States of America | Moreau | USA0006652 | 60.8 | 38.5557 | -92.1023 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35263 | 2019 | -0.176 | -0.043 | -0.443 | -0.14 | -0.162 | 0.279 | 1.711 | U.S. Energy Information Administration | 35.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31059 | 31059 | USA | United States of America | Osage Dam | USA0002106 | 208.0 | 38.2044 | -92.6239 | Hydro | 1935.548076923077 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 667.2570000000001 | 232.19 | 754.198 | 609.1850000000001 | 624.91 | 340.041 | 1215.96 | U.S. Energy Information Administration | 742.42 | 667.04 | 602.36 | 703.37 | 784.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31347 | 31347 | USA | United States of America | Peno Creek | USA0007964 | 240.0 | 39.3531 | -91.2295 | Gas | Oil | 2002.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49805 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 64.525 | U.S. Energy Information Administration | 846.35 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
31424 | 31424 | USA | United States of America | Pinckneyville | USA0055202 | 380.0 | 38.1114 | -89.3467 | Gas | 2000.5263157894735 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 46977 | 2019 | 30.84 | 15.814 | 55.182 | 95.213 | 99.461 | 146.519 | 77.35000000000001 | U.S. Energy Information Administration | 1340.06 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31767 | 31767 | USA | United States of America | Raccoon Creek Energy Center | USA0055417 | 456.0 | 38.6996 | -88.5392 | Gas | 2002.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49061 | 2019 | -2.242 | 1.522 | 0.81 | 7.22 | 5.952 | 8.876 | 2.369 | U.S. Energy Information Administration | 1608.08 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32120 | 32120 | USA | United States of America | Rush Island | USA0006155 | 1242.0 | 38.1312 | -90.2632 | Coal | Oil | 1976.5 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35270 | 2019 | 8475.303998000001 | 7869.454992 | 7465.221955 | 6406.193004000001 | 8814.93396 | 7766.228041000001 | 5545.391976 | U.S. Energy Information Administration | 5737.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
32607 | 32607 | USA | United States of America | Sioux | USA0002107 | 1099.4 | 38.9155 | -90.2902 | Coal | Oil | 1967.5 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35271 | 2019 | 5080.395006 | 4964.295008 | 4495.381012 | 0.0 | 0.0 | 0.0 | 3885.565964 | U.S. Energy Information Administration | 5078.32 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
33270 | 33270 | USA | United States of America | Taum Sauk | USA0002108 | 408.0 | 37.5208 | -90.8347 | Hydro | 1964.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35272 | 2019 | -102.571 | -135.904 | -71.811 | -152.879 | -147.606 | -121.335 | -19.611 | U.S. Energy Information Administration | 1005.36 | 1005.36 | 951.02 | 1008.11 | 831.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33777 | 33777 | USA | United States of America | Venice | USA0000913 | 586.0 | 38.6642 | -90.1764 | Gas | Oil | 2004.68771331058 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35274 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 27.6 | U.S. Energy Information Administration | 2066.52 | 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");