global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
6 rows where country_long = "United States of America", estimated_generation_note_2017 = "CAPACITY-FACTOR-V1" and owner = "Omaha Public Power District"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26232 | 26232 | USA | United States of America | Cass County | USA0055972 | 345.0 | 40.9479 | -95.964 | Gas | 2003.0 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28897 | 2019 | 82.621 | 21.018 | 16.286 | 28.252 | 17.098 | 116.903 | 195.085 | U.S. Energy Information Administration | 1216.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27393 | 27393 | USA | United States of America | Elk City Station | USA0007955 | 6.4 | 41.3839 | -96.2544 | Waste | 2004.375 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 47102 | 2019 | 49.124 | 47.08 | 49.026 | 49.199 | 48.218 | 45.062 | 45.681 | U.S. Energy Information Administration | 1.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29137 | 29137 | USA | United States of America | Jones Street | USA0002290 | 130.0 | 41.2515 | -95.9227 | Oil | 1973.0 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28894 | 2019 | -0.408 | 0.294 | -0.395 | -0.125 | 0.08 | 1.337 | 3.0660000000000003 | U.S. Energy Information Administration | 76.19 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30626 | 30626 | USA | United States of America | Nebraska City | USA0006096 | 1389.6 | 40.6214 | -95.7764 | Coal | 1994.9326424870471 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28895 | 2019 | 9654.692999 | 8828.982049 | 8681.174977 | 9086.200983 | 8702.872046000002 | 9102.065988 | 6812.456989 | U.S. Energy Information Administration | 6418.8 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30798 | 30798 | USA | United States of America | North Omaha | USA0002291 | 644.7 | 41.3291 | -95.9447 | Coal | Gas | 1961.973941368078 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28896 | 2019 | 3299.848997 | 3060.377049 | 3095.081954 | 2049.391983 | 1912.218968 | 1757.5390140000002 | 1873.295993 | U.S. Energy Information Administration | 2977.98 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
32368 | 32368 | USA | United States of America | Sarpy County | USA0002292 | 338.4 | 41.1706 | -95.9706 | Gas | Oil | 1989.534278959811 | Omaha Public Power District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28898 | 2019 | 65.70100000000001 | 34.804 | 32.806999999999995 | 52.768 | 79.65899999999999 | 93.77700000000002 | 92.785 | U.S. Energy Information Administration | 1193.36 | 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");