global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

6 rows where owner = "PacifiCorp" and primary_fuel = "Coal" sorted by other_fuel3

View and edit SQL

Suggested facets: other_fuel1

primary_fuel

  • Coal · 6

owner

  • PacifiCorp · 6

country_long

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 estimated_generation_gwh
22807 USA United States of America Dave Johnston USA0004158 922.2 42.8378 -105.7769 Coal Oil     1966.587508132726 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29503 2017 5295.073977000001 5183.4439710000015 5140.970018999999 5088.504023 4519.9779640000015  
24417 USA United States of America Hunter USA0006165 1577.2 39.1747 -111.0289 Coal Oil     1980.337053005326 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29515 2017 9546.313012999999 9098.917954 9630.418981 8161.218993 8582.142018999999  
24422 USA United States of America Huntington USA0008069 1037.3 39.3792 -111.0781 Coal Oil     1975.5655066036825 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29514 2017 6765.956963000001 6300.997967 5988.318014 5503.890032 5399.7769720000015  
24724 USA United States of America Jim Bridger USA0008066 2441.9 41.7378 -108.7875 Coal Oil     1976.249109300136 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29518 2017 14817.040609 14015.874978 13439.341169 11685.770985 11642.809507  
26080 USA United States of America Naughton USA0004162 832.0 41.7581 -110.5983 Coal Gas     1968.2307692307693 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29528 2017 5533.894961999999 4958.588961000001 4899.3209670000015 4871.838983 4740.719994  
29472 USA United States of America Wyodak USA0006101 402.3 44.2901 -105.3815 Coal Oil     1978.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29560 2017 2515.3960460000003 2622.574952 2563.5820190000004 2056.357982 2565.052998  

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,
  "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");
Powered by Datasette · Query took 98.287ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute