global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
15 rows where country_long = "United States of America", estimated_generation_gwh_2017 = "17.63" and primary_fuel = "Gas"
This data as json, CSV (advanced)
Suggested facets: other_fuel1, commissioning_year, generation_gwh_2017
owner 15
- 2016 ESA Project Company LLC 1
- Broadridge Customer Communications 1
- COE Bridgewater LLC c/o Thor Equities LLC 1
- E.B. Eddy Paper Inc 1
- Foss Manufacturing Company LLC 1
- Middle Tennessee State University 1
- POET Biorefining - Gowrie 1
- POET Biorefining - Jewell 1
- POET Biorefining LLC - Corning 1
- Sentinel Peak Resources California LLC 1
- The Methodist Hospital 1
- United Illuminating Co 1
- University of Tennessee 1
- Utah State University 1
- Veolia Energy Kansas City 1
primary_fuel 1
- Gas · 15 ✖
country_long 1
- United States of America · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25817 | 25817 | USA | United States of America | Broadridge Cogen | USA0057580 | 5.0 | 38.6183 | -121.0564 | Gas | Solar | 2008.64 | Broadridge Customer Communications | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 14.99204 | 15.44676 | 14.49126 | 12.618 | 12.606 | 11.302 | 15.836 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26015 | 26015 | USA | United States of America | CIP II/AR Bridgewater Holdings - NJCOE | USA0010122 | 5.0 | 40.624 | -74.634 | Gas | Oil | 2002.0 | COE Bridgewater LLC c/o Thor Equities LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 16.94812 | 26.83632 | 25.74362 | 24.90474 | 26.57564 | 22.72522 | 22.663480000000003 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26301 | 26301 | USA | United States of America | Central Energy Plant USU | USA0058139 | 5.0 | 41.7486 | -111.8117 | Gas | Oil | 2004.0 | Utah State University | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 60728 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 27.825 | 0.0 | 33.513 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
27251 | 27251 | USA | United States of America | E.B. Eddy Paper Inc | USA0058222 | 5.0 | 42.9896 | -82.4379 | Gas | 1969.0 | E.B. Eddy Paper Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 32.53574 | 30.52202 | 30.08164 | 0.0 | 0.0 | 0.0 | 29.77 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
28189 | 28189 | USA | United States of America | Grand Ave Plant | USA0058205 | 5.0 | 39.1119 | -94.5811 | Gas | 1991.0 | Veolia Energy Kansas City | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 33.966 | 35.04 | 29.108 | 37.813 | 35.32 | 0.0 | 41.876 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
28418 | 28418 | USA | United States of America | Hampton Facility | USA0010108 | 5.0 | 42.9383 | -70.8406 | Gas | 2000.0 | Foss Manufacturing Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26324 | 2019 | 30.019 | 30.927 | 31.529 | 32.726000000000006 | 0.0 | 0.0 | 29.838 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29868 | 29868 | USA | United States of America | MTSU Power Co-Gen Plant | USA0058179 | 5.0 | 35.8514 | -86.365 | Gas | 1997.0 | Middle Tennessee State University | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 43.28170000000001 | 34.278 | 33.611000000000004 | 0.0 | 30.24748 | 36.335 | 33.154 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
30308 | 30308 | USA | United States of America | Mission College Blvd. Fuel Cell | USA0062697 | 5.0 | 37.3863 | -121.9624 | Gas | 2018.0 | 2016 ESA Project Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 25.932 | 39.336 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
31138 | 31138 | USA | United States of America | POET Biorefining - Gowrie | USA0063923 | 5.0 | 42.3198 | -94.2874 | Gas | 2018.0 | POET Biorefining - Gowrie | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
31140 | 31140 | USA | United States of America | POET Biorefining - Jewell | USA0063826 | 5.0 | 42.3284 | -93.6623 | Gas | 2019.0 | POET Biorefining - Jewell | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 19.608 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
31146 | 31146 | USA | United States of America | POET Biorefining LLC - Corning | USA0063919 | 5.0 | 40.9662 | -94.7958 | Gas | 2018.0 | POET Biorefining LLC - Corning | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
33341 | 33341 | USA | United States of America | The Methodist Hospital Gas Turbine | USA0059381 | 5.0 | 29.7094 | -95.4003 | Gas | 2010.0 | The Methodist Hospital | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 28.00448 | 26.458 | 29.246 | 30.12 | 31.024 | 28.434 | 28.50428 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
33579 | 33579 | USA | United States of America | UI RCP Bridgeport Seaside | USA0060054 | 5.0 | 41.1576 | -73.2081 | Gas | Solar | 2015.44 | United Illuminating Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.142 | 24.609 | 24.092 | 22.355 | 18.578 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
33677 | 33677 | USA | United States of America | University of Tennessee Steam Plant | USA0055036 | 5.0 | 35.9492 | -83.9261 | Gas | 1996.0 | University of Tennessee | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 35.041000000000004 | 32.413000000000004 | 25.804 | 33.362 | 34.756 | 34.835 | 31.62 | U.S. Energy Information Administration | 17.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
34100 | 34100 | USA | United States of America | Welport Lease Project | USA0054447 | 5.0 | 35.3544 | -119.6617 | Gas | 1990.0 | Sentinel Peak Resources California LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35476 | 2019 | 36.267 | 36.477 | 34.495 | 31.916 | 30.537 | 26.303 | 36.284 | U.S. Energy Information Administration | 17.63 | 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");