global-power-plants

Table actions

7 rows where owner = "Black Hills Power Inc. d/b/a"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, other_fuel1, wepp_id

primary_fuel 2

owner 1

  • Black Hills Power Inc. d/b/a · 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
25201 25201 USA United States of America Ben French USA0003325 110.0 44.0872 -103.261 Gas Oil     1976.590909090909 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14601 2017 1.8860000000000003 8.087 1.635 6.314 3.3079600000000005 U.S. Energy Information Administration  
28805 28805 USA United States of America Lange Gas Turbines USA0055478 40.0 44.1203 -103.26 Gas       2002.0 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 53235 2017 8.391 2.9170000000000003 10.863 11.657 8.889 U.S. Energy Information Administration  
29814 29814 USA United States of America Neil Simpson Gas Turbine #2 USA0055477 40.0 44.285 -105.3786 Gas       2001.0 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14604 2017 16.577 4.478 7.027 5.309 7.678 U.S. Energy Information Administration  
29815 29815 USA United States of America Neil Simpson II USA0007504 130.0 44.2856 -105.3833 Coal Gas     1996.5384615384612 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14604 2017 678.0890049999999 578.9300010000002 611.222005 609.0269979999998 557.412998 U.S. Energy Information Administration  
33181 33181 USA United States of America Wygen 1 USA0055479 90.0 44.2858 -105.3833 Coal Gas     2003.0 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 37425 2017 705.252002 705.405997 734.553002 710.523999 721.780005 U.S. Energy Information Administration  
33182 33182 USA United States of America Wygen 2 USA0056319 95.0 44.2919 -105.3811 Coal Gas     2008.0 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 688.317999 697.290002 690.6129970000002 734.354003 745.363003 U.S. Energy Information Administration  
33183 33183 USA United States of America Wygen III USA0056596 116.0 44.2919 -105.3806 Coal Gas     2010.0 Black Hills Power Inc. d/b/a U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 58328 2017 837.892996 838.9770000000002 773.8019959999998 821.6990040000002 772.444005 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");