Data Electric markets

Electric market

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

The zip codes that each electric utility serves.

We import this data from OpenEI.org.

Citing this data

To cite this data, reference Brighter Planet, "Electric markets," <http://data.brighterplanet.com/electric_markets>, retrieved 2013-05-23 02:17:50 UTC.

Download

Total: 64,864 records.

Random data sample

Sample: 5 records.

id electric utility eia zip code name
1000-72006 1000 72006
10000-63534 10000 63534
10000-63558 10000 63558
10000-64001 10000 64001
10000-64012 10000 64012

Import steps

Click a step for more detail.

  1. Don't re-import too often

    unless DataMiner::Run.allowed?(resource_model.name) then
  raise(DataMiner::Run::Skip)
end

  2. Import IOU markets

    1. Fetch data from en.openei.org.
    2. Apply errata.
    3. Store
      • id
      • zip_code_name
      • electric_utility_eia_id
      .

  3. Import Non-IOU markets

    1. Fetch data from en.openei.org.
    2. Apply errata.
    3. Store
      • id
      • zip_code_name
      • electric_utility_eia_id
      .

Table structure

CREATE TABLE electric_markets
  (
     id                      CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     electric_utility_eia_id INTEGER,
     zip_code_name           CHARACTER VARYING(255)
  );