global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
17 rows where commissioning_year = "1986.0", country_long = "United States of America" and primary_fuel = "Gas"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019
owner 15
- Chevron USA Inc 2
- Northern California Power Agny 2
- City of Roseville - (CA) 1
- Eagle 2 US LLC 1
- Energy Center Paxton LLC 1
- Frito-Lay Inc 1
- JHP Pharmaceuticals LLC 1
- Kinder Morgan Yates Operation 1
- Moose International 1
- NRG Energy Center San Diego LLC 1
- New-Indy Oxnard LLC 1
- Sacramento Municipal Util Dist 1
- South Houston Green Power LLC 1
- Turlock Irrigation District 1
- U S Gypsum Co 1
primary_fuel 1
- Gas · 17 ✖
country_long 1
- United States of America · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24893 | 24893 | USA | United States of America | Alameda | USA0007450 | 54.8 | 37.7886 | -122.2889 | Gas | Oil | 1986.0 | Northern California Power Agny | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27937 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 7.208 | U.S. Energy Information Administration | 193.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
26872 | 26872 | USA | United States of America | Cymric 6Z Cogen | USA0052082 | 6.8 | 35.3461 | -119.6434 | Gas | 1986.0 | Chevron USA Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 46358 | 2019 | 44.496 | 44.116 | 45.332 | 45.643 | 43.267 | 45.207 | 43.041 | U.S. Energy Information Administration | 23.98 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27874 | 27874 | USA | United States of America | Frito-Lay Cogen Plant | USA0010110 | 6.0 | 35.3951 | -119.3216 | Gas | 1986.0 | Frito-Lay Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 26.611 | 24.5 | 27.851 | 27.041 | 28.175 | 26.593 | 24.03 | U.S. Energy Information Administration | 21.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
29710 | 29710 | USA | United States of America | Lodi | USA0007451 | 27.4 | 38.1466 | -121.3005 | Gas | Oil | 1986.0 | Northern California Power Agny | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27939 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.497 | U.S. Energy Information Administration | 96.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
30054 | 30054 | USA | United States of America | McClellan (CA) | USA0000535 | 77.0 | 38.6527 | -121.3933 | Gas | 1986.0 | Sacramento Municipal Util Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31873 | 2019 | 3.251 | 3.722 | 10.84 | 5.26 | 8.862 | 7.088 | 2.195 | U.S. Energy Information Administration | 271.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30401 | 30401 | USA | United States of America | Mooseheart Power House | USA0050337 | 1.8 | 41.8244 | -88.3331 | Gas | 1986.0 | Moose International | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25191 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 6.34 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30557 | 30557 | USA | United States of America | NRG Energy San Diego | USA0054337 | 1.6 | 32.7149 | -117.1689 | Gas | 1986.0 | NRG Energy Center San Diego LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68522 | 2019 | 1.695 | 1.056 | 1.95 | 1.294 | 1.764 | 1.907 | U.S. Energy Information Administration | 5.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
30795 | 30795 | USA | United States of America | North Midway Cogen | USA0052078 | 10.5 | 35.2761 | -119.5986 | Gas | 1986.0 | Chevron USA Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34427 | 2019 | 37.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
31115 | 31115 | USA | United States of America | Oxnard Paper Mill | USA0057585 | 29.0 | 34.1414 | -119.1831 | Gas | 1986.0 | New-Indy Oxnard LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 204.427 | 203.015 | 192.002 | 196.482 | 196.979 | 189.038 | 183.955 | U.S. Energy Information Administration | 102.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
31152 | 31152 | USA | United States of America | PPG Plant C Caustic | USA0050490 | 3.4 | 30.2264 | -93.2938 | Gas | 1986.0 | Eagle 2 US LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.908 | 11.97 | 8.965 | 12.498 | 14.322 | 14.046 | 12.894 | U.S. Energy Information Administration | 11.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
31246 | 31246 | USA | United States of America | Par Sterile Products | USA0050318 | 2.8 | 42.6837 | -83.1143 | Gas | 1986.0 | JHP Pharmaceuticals LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 9.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
31297 | 31297 | USA | United States of America | Paxton Creek Cogeneration | USA0050373 | 12.6 | 40.2653 | -76.8771 | Gas | Oil | 1986.0 | Energy Center Paxton LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.354 | 1.081 | 3.29 | 3.38 | 0.8810000000000001 | 1.263 | 0.388 | U.S. Energy Information Administration | 44.43 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31587 | 31587 | USA | United States of America | Power Station 4 | USA0052132 | 191.1 | 29.3782 | -94.9219 | Gas | 1986.0 | South Houston Green Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 626.717 | U.S. Energy Information Administration | 673.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
32087 | 32087 | USA | United States of America | Roseville Power Plant #2 | USA0007452 | 66.0 | 38.8107 | -121.3238 | Gas | 1986.0 | City of Roseville - (CA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27944 | 2019 | 0.0 | 0.589 | 2.502 | 1.003 | 1.284 | 2.955 | 1.411 | U.S. Energy Information Administration | 232.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
33595 | 33595 | USA | United States of America | US Gypsum Oakfield | USA0050203 | 5.8 | 43.0647 | -78.2972 | Gas | 1986.0 | U S Gypsum Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35716 | 2019 | 16.89128 | 16.18862 | 21.9667 | 24.049200000000003 | 28.13188 | 23.21914 | 16.837380000000003 | U.S. Energy Information Administration | 20.45 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
33941 | 33941 | USA | United States of America | Walnut | USA0004256 | 49.8 | 37.4903 | -120.9044 | Gas | Oil | 1986.0 | Turlock Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 57754 | 2019 | 0.0 | 0.0 | 0.0 | -0.162 | 0.307 | 0.01 | -0.255 | U.S. Energy Information Administration | 175.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
34502 | 34502 | USA | United States of America | Yates Gas Plant | USA0055025 | 5.6 | 30.8847 | -101.9208 | Gas | 1986.0 | Kinder Morgan Yates Operation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 24.26284 | 24.12368 | 24.15896 | 21.6531 | 24.02078 | 24.28146 | 10.35174 | U.S. Energy Information Administration | 19.74 | 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");