global-power-plants

Table actions

10 rows where owner = "Tri-State G & T Assn Inc"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, other_fuel1, commissioning_year, generation_gwh_2014

primary_fuel 3

owner 1

  • Tri-State G & T Assn Inc · 10 ✖

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_data_source estimated_generation_gwh
25599 25599 USA United States of America Burlington (CO) USA0006619 129.4 39.3561 -102.2431 Oil       1977.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34958 2017 3.1239999999999997 2.556 1.685 1.533 2.571 U.S. Energy Information Administration  
26379 26379 USA United States of America Craig (CO) USA0006021 1427.6 40.4627 -107.5912 Coal       1981.1857663210985 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34959 2017 8197.480031000001 9281.410042 8020.477004 8325.432955 7953.454035 U.S. Energy Information Administration  
26995 26995 USA United States of America Escalante USA0000087 257.0 35.4159 -108.082 Coal Gas     1985.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30272 2017 1513.065041 1389.6869809999996 1368.601974 1301.5899700000002 1106.7589940000003 U.S. Energy Information Administration  
27292 27292 USA United States of America Frank Knutson USA0055505 154.2 39.9411 -104.682 Gas Oil     2002.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48094 2017 63.871 0.0 7.102 15.621 11.742 U.S. Energy Information Administration  
28375 28375 USA United States of America JM Shafer Generating Station USA0050707 396.9 40.0986 -104.7736 Gas       1994.0000000000007 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33714 2017 608.466 584.0169999999999 702.577 547.556 433.971 U.S. Energy Information Administration  
28912 28912 USA United States of America Limon Generating Station USA0055504 154.2 39.2038 -103.7005 Gas Oil     2002.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48093 2017 46.519 27.719 28.952 51.2 37.001 U.S. Energy Information Administration  
30014 30014 USA United States of America Nucla USA0000527 113.8 38.2383 -108.5069 Coal Oil     1981.298769771529 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34960 2017 369.60500299999995 417.583997 416.14999900000004 222.726003 90.10799999999999 U.S. Energy Information Administration  
30725 30725 USA United States of America Pyramid USA0007975 186.0 32.2363 -108.5494 Gas Oil     2003.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 47305 2017 57.498999999999995 57.106 46.906000000000006 25.242000000000004 34.196999999999996 U.S. Energy Information Administration  
30942 30942 USA United States of America Rifle Generating Station USA0010755 84.0 39.5173 -107.7299 Gas       1987.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17046 2017 22.078000000000003 8.416 0.0 1.804 1.5319999999999998 U.S. Energy Information Administration  
32100 32100 USA United States of America TSGT Mobile Generator #15 USA0057476 2.0 36.934 -106.9865 Oil       2010.0 Tri-State G & T Assn Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.028999999999999998 0.0       U.S. Energy Information Administration  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");