global-power-plants

Table actions

7 rows where owner = "Public Service Co of Oklahoma"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016

primary_fuel 2

owner 1

  • Public Service Co of Oklahoma · 7 ✖

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
26225 26225 USA United States of America Comanche (OK) USA0008059 294.0 34.5431 -98.3244 Gas Oil     1973.547619047619 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30903 2017 742.569 0.0 363.32599999999996 95.04899999999999   U.S. Energy Information Administration  
29982 29982 USA United States of America Northeastern USA0002963 1477.5 36.4317 -95.7008 Gas Coal Oil   1979.6896785109986 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50598 2017 9353.65905 0.0 8097.405970000001 4774.12898 3951.36998 U.S. Energy Information Administration  
30091 30091 USA United States of America Oklaunion USA0000127 720.0 34.0825 -99.1753 Coal       1987.0 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36628 2017 3967.166969 3216.641024 2081.936951 2491.265037 1669.203043 U.S. Energy Information Administration  
30984 30984 USA United States of America Riverside (OK) USA0004940 1121.7 35.9978 -95.9567 Gas Oil     1980.0920032094143 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30911 2017 1029.5870220000002 290.414 70.878 325.4890000000001 294.638 U.S. Energy Information Administration  
31754 31754 USA United States of America Southwestern USA0002964 658.0 35.1009 -98.3524 Gas Oil     1974.2021276595747 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30913 2017 470.023 352.4170000000001 0.0 0.0 279.15 U.S. Energy Information Administration  
32358 32358 USA United States of America Tulsa USA0002965 348.2 36.1165 -95.991 Gas Oil     1957.235496840896 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30917 2017 0.0 0.0 0.0 0.0 248.112 U.S. Energy Information Administration  
32847 32847 USA United States of America Weleetka USA0002966 163.0 35.3233 -96.1352 Gas Oil     1975.3558282208592 Public Service Co of Oklahoma U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30918 2017 0.0 0.0 0.0 0.0 23.464 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");