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

202.46 kB
16,029 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

213.03 kB
16,801 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

219.62 kB
17,366 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

224.76 kB
17,728 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

223.04 kB
17,999 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

233.62 kB
18,354 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

235.85 kB
19,060 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

240.81 kB
19,558 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

224.38 kB
17,876 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

228.18 kB
18,150 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

236.97 kB
18,530 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

239.65 kB
19,023 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

251.06 kB
19,243 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

255.92 kB
19,745 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

263.64 kB
20,066 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

291.19 kB
20,724 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

304.45 kB
21,437 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

322.04 kB
22,118 rows
6 columns

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