global-power-plants

Table actions

18 rows where owner = "Public Service Co of Colorado"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, commissioning_year

primary_fuel 4

owner 1

  • Public Service Co of Colorado · 18 ✖

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
24702 24702 USA United States of America Alamosa USA0000464 53.2 37.4594 -105.8947 Gas Oil     1975.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30838 2017 9.964 1.8659999999999999 3.5930000000000004 4.072 0.406 U.S. Energy Information Administration  
24826 24826 USA United States of America Ames Hydro USA0006207 3.6 37.866 -107.8831 Hydro       1906.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.964 2.294 8.996 6.972 8.109 U.S. Energy Information Administration  
25372 25372 USA United States of America Blue Spruce Energy Center USA0055645 397.8 39.7479 -104.6814 Gas Oil     2003.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 47813 2017 296.973004 300.2130049999999 402.09 181.944996 334.6740010000001 U.S. Energy Information Administration  
25721 25721 USA United States of America Cabin Creek USA0000467 300.0 39.6551 -105.7088 Hydro       1967.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30842 2017 -146.82399999999998 -159.359 -159.085 -179.267 -205.9 U.S. Energy Information Administration  
26001 26001 USA United States of America Cherokee USA0000469 1006.4 39.8073 -104.9645 Gas Coal     1997.216216216216 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30846 2017 2873.768954 3075.3740270000008 3192.480004 4633.892997999999 4274.896992 U.S. Energy Information Administration  
26224 26224 USA United States of America Comanche (CO) USA0000470 1635.3 38.2081 -104.5747 Coal Gas     1992.870115575124 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30847 2017 8959.659029999999 8289.783029999999 8636.016029999999 9059.70998 9275.37898 U.S. Energy Information Administration  
27246 27246 USA United States of America Fort Lupton USA0008067 100.8 40.0922 -104.796 Gas Oil     1972.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30850 2017 6.098999999999998 2.798 3.2019999999999995 2.161 1.334 U.S. Energy Information Administration  
27253 27253 USA United States of America Fort St Vrain USA0006112 1148.5 40.2461 -104.8742 Gas       2000.992424902046 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30848 2017 3179.222 3876.5040000000004 3566.523 2838.269 2744.6040000000007 U.S. Energy Information Administration  
27352 27352 USA United States of America Fruita USA0000471 26.6 39.1364 -108.7347 Gas Oil     1973.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30852 2017 0.30200000000000005 0.129 0.135 0.258 0.17 U.S. Energy Information Administration  
27486 27486 USA United States of America Georgetown Hydro USA0000472 1.2 39.6919 -105.6978 Hydro       1907.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30849 2017 6.035 6.165 4.527 3.678 4.824 U.S. Energy Information Administration  
27915 27915 USA United States of America Hayden USA0000525 465.4 40.4856 -107.185 Coal Oil Gas   1971.509239363988 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30853 2017 3173.7390370000007 3156.7799579999996 2877.284018 2411.462993 2598.851043 U.S. Energy Information Administration  
30325 30325 USA United States of America Panasonic Carport Solar USA0061439 2.3 39.8087 -104.7815 Solar Storage     2017.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         1.349 U.S. Energy Information Administration 1.0223838409177732
30382 30382 USA United States of America Pawnee USA0006248 552.3 40.2217 -103.6803 Coal Gas     1981.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30855 2017 3093.5820320000003 2704.9979789999998 3427.165961000001 2705.324009 3521.113049 U.S. Energy Information Administration  
31054 31054 USA United States of America Rocky Mountain Energy Center USA0055835 685.0999999999998 40.0908 -104.5953 Gas       2004.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 47820 2017 1776.9579999999999 2452.794 1848.027 1860.525 1975.431 U.S. Energy Information Administration  
31242 31242 USA United States of America Salida USA0000474 1.4 38.5342 -106.182 Hydro       1920.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30856 2017 1.5919999999999999 2.1519999999999997 0.623 2.116 2.633 U.S. Energy Information Administration  
31501 31501 USA United States of America Shoshone (CO) USA0000476 14.4 39.5701 -107.2269 Hydro       1909.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30858 2017 86.132 66.015 80.256 83.045 95.238 U.S. Energy Information Administration  
32107 32107 USA United States of America Tacoma USA0006206 4.6 37.5237 -107.7828 Hydro       1905.5 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30859 2017 6.49 0.29100000000000004 1.136 4.005 13.397 U.S. Energy Information Administration  
32548 32548 USA United States of America Valmont USA0000477 59.3 40.0195 -105.202 Gas       1973.0 Public Service Co of Colorado U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 46204 2017 995.8599960000001 1048.991048 1058.475045 1010.565003 217.96799700000003 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");