Name: U.S. Electric Power Generators
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

U.S. Electric Power Generators

Context

The soft path revisited: Quantifying the spatial dispersion of electric power generators in the contiguous U.S.

These are cleaned, compiled, and geocoded datasets of publicly available EIA-860 data for 2001-2018. Original data is found here: https://www.eia.gov/electricity/data/eia860/

Acknowledgements

Kahsar, Rudy (2021), “Data for: The soft path revisited: Quantifying the spatial dispersion of electric power generators in the contiguous U.S.”, Mendeley Data, V1, doi: 10.17632/37hn87t2rb.1

Tables

Y2001

@kaggle.saurabhshahane_us_electric_power_generators.y2001

197.72 KB
16029 rows
6 columns


CREATE TABLE y2001 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2002

@kaggle.saurabhshahane_us_electric_power_generators.y2002

208.04 KB
16801 rows
6 columns


CREATE TABLE y2002 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2003

@kaggle.saurabhshahane_us_electric_power_generators.y2003

214.47 KB
17366 rows
6 columns


CREATE TABLE y2003 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2004

@kaggle.saurabhshahane_us_electric_power_generators.y2004

219.49 KB
17728 rows
6 columns


CREATE TABLE y2004 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2005

@kaggle.saurabhshahane_us_electric_power_generators.y2005

217.81 KB
17999 rows
6 columns


CREATE TABLE y2005 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2006

@kaggle.saurabhshahane_us_electric_power_generators.y2006

228.15 KB
18354 rows
6 columns


CREATE TABLE y2006 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2007

@kaggle.saurabhshahane_us_electric_power_generators.y2007

230.32 KB
19060 rows
6 columns


CREATE TABLE y2007 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2008

@kaggle.saurabhshahane_us_electric_power_generators.y2008

235.17 KB
19558 rows
6 columns


CREATE TABLE y2008 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plntcode" BIGINT,
  "state" VARCHAR
);

Y2009

@kaggle.saurabhshahane_us_electric_power_generators.y2009

219.12 KB
17876 rows
6 columns


CREATE TABLE y2009 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_code" BIGINT,
  "state" VARCHAR
);

Y2010

@kaggle.saurabhshahane_us_electric_power_generators.y2010

222.83 KB
18150 rows
6 columns


CREATE TABLE y2010 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_code" BIGINT,
  "state" VARCHAR
);

Y2011

@kaggle.saurabhshahane_us_electric_power_generators.y2011

231.41 KB
18530 rows
6 columns


CREATE TABLE y2011 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_code" BIGINT,
  "state" VARCHAR
);

Y2012

@kaggle.saurabhshahane_us_electric_power_generators.y2012

234.03 KB
19023 rows
6 columns


CREATE TABLE y2012 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2013

@kaggle.saurabhshahane_us_electric_power_generators.y2013

245.18 KB
19243 rows
6 columns


CREATE TABLE y2013 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2014

@kaggle.saurabhshahane_us_electric_power_generators.y2014

249.92 KB
19745 rows
6 columns


CREATE TABLE y2014 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2015

@kaggle.saurabhshahane_us_electric_power_generators.y2015

257.46 KB
20066 rows
6 columns


CREATE TABLE y2015 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2016

@kaggle.saurabhshahane_us_electric_power_generators.y2016

284.36 KB
20724 rows
6 columns


CREATE TABLE y2016 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2017

@kaggle.saurabhshahane_us_electric_power_generators.y2017

297.31 KB
21437 rows
6 columns


CREATE TABLE y2017 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "plant_id" BIGINT,
  "state" VARCHAR
);

Y2018

@kaggle.saurabhshahane_us_electric_power_generators.y2018

314.49 KB
22118 rows
6 columns


CREATE TABLE y2018 (
  "nameplate" DOUBLE,
  "technology" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "state" VARCHAR,
  "plant_id" BIGINT
);