Data Electric utilities

Electric utility

Last imported 05:14AM UTC on Tuesday, March 26, 2013. See log

U.S. electric utilities (e.g. Pacific Gas & Electric Co).

We import this data from the U.S. EIA Form 861.

Citing this data

To cite this data, reference Brighter Planet, "Electric utilities," <http://data.brighterplanet.com/electric_utilities>, retrieved 2013-05-20 08:51:39 UTC.

Download

Total: 3,265 records.

Random data sample

Sample: 5 records.

eia name nickname state postal abbreviation nerc region abbreviation second nerc region abbreviation
34 Abbeville City of SC SERC
55 Aberdeen City of MS SERC
59 City of Abbeville LA SPP
84 A & N Electric Coop VA RFC
87 City of Ada MN MRO

Import steps

Click a step for more detail.

  1. Import EIA Form 861 records from 2010 (revised)

    1. Fetch data from www.eia.gov.
    2. Apply errata.
    3. Store
      • eia_id
      • name
      • state_postal_abbreviation
      • nerc_region_abbreviation
      • second_nerc_region_abbreviation
      .

  2. Import aliases

    1. Fetch data from docs.google.com.
    2. Store
      • eia_id
      • nickname
      .

Table structure

CREATE TABLE electric_utilities
  (
     eia_id                          INTEGER NOT NULL PRIMARY KEY,
     name                            CHARACTER VARYING(255),
     nickname                        CHARACTER VARYING(255),
     state_postal_abbreviation       CHARACTER VARYING(255),
     nerc_region_abbreviation        CHARACTER VARYING(255),
     second_nerc_region_abbreviation CHARACTER VARYING(255)
  );