Data Mecs energies

Mecs energy

Last imported 10:35AM UTC on Tuesday, March 26, 2013. See log

Census region-specific average energy consumption for NAICS manufacturing sectors.

Derived from the U.S. EIA Manufacturing Energy Consumption Survey.

Citing this data

To cite this data, reference Brighter Planet, "Mecs energies," <http://data.brighterplanet.com/mecs_energies>, retrieved 2013-05-18 09:27:40 UTC.

Download

Total: 395 records.

Random data sample

Sample: 5 records.

name census region number naics code energy energy units electricity electricity units residual fuel oil residual fuel oil units distillate fuel oil distillate fuel oil units natural gas natural gas units lpg and ngl lpg and ngl units coal coal units coke and breeze coke and breeze units other fuel other fuel units
311- 311 1251300000000.0 megajoules 264819000000.0 megajoules 27431500000.0 megajoules 16880900000.0 megajoules 669960000000.0 megajoules 3165170000.0 megajoules 155093000000.0 megajoules 1055060000.0 megajoules 112891000000.0 megajoules
311-1 1 311 62248300000.0 megajoules 20046100000.0 megajoules 3165170000.0 megajoules 3165170000.0 megajoules 34816800000.0 megajoules 0.0 megajoules 0.0 megajoules 0.0 megajoules
311-2 2 311 598217000000.0 megajoules 110781000000.0 megajoules 11605600000.0 megajoules 2110110000.0 megajoules 313352000000.0 megajoules 1055060000.0 megajoules 125552000000.0 megajoules 0.0 megajoules 31651700000.0 megajoules
311-3 3 311 369270000000.0 megajoules 86514600000.0 megajoules 11605600000.0 megajoules 4220220000.0 megajoules 179359000000.0 megajoules 1055060000.0 megajoules 12660700000.0 megajoules 0.0 megajoules
311-4 4 311 221562000000.0 megajoules 47477500000.0 megajoules 1055060000.0 megajoules 7385390000.0 megajoules 142433000000.0 megajoules 1055060000.0 megajoules 15825800000.0 megajoules 0.0 megajoules 6330340000.0 megajoules

Import steps

Click a step for more detail.

  1. Import MECS table 3.2 Total US

    1. Fetch data from www.eia.gov.
    2. Store
      • name
      • census_region_number
      • naics_code
      • energy
      • electricity
      • residual_fuel_oil
      • distillate_fuel_oil
      • natural_gas
      • lpg_and_ngl
      • coal
      • coke_and_breeze
      • other_fuel
      .

  2. Import MECS table 3.2 Northeast

    1. Fetch data from www.eia.gov.
    2. Store
      • name
      • census_region_number
      • naics_code
      • energy
      • electricity
      • residual_fuel_oil
      • distillate_fuel_oil
      • natural_gas
      • lpg_and_ngl
      • coal
      • coke_and_breeze
      • other_fuel
      .

  3. Import MECS table 3.2 Midwest

    1. Fetch data from www.eia.gov.
    2. Store
      • name
      • census_region_number
      • naics_code
      • energy
      • electricity
      • residual_fuel_oil
      • distillate_fuel_oil
      • natural_gas
      • lpg_and_ngl
      • coal
      • coke_and_breeze
      • other_fuel
      .

  4. Import MECS table 3.2 South

    1. Fetch data from www.eia.gov.
    2. Store
      • name
      • census_region_number
      • naics_code
      • energy
      • electricity
      • residual_fuel_oil
      • distillate_fuel_oil
      • natural_gas
      • lpg_and_ngl
      • coal
      • coke_and_breeze
      • other_fuel
      .

  5. Import MECS table 3.2 West

    1. Fetch data from www.eia.gov.
    2. Store
      • name
      • census_region_number
      • naics_code
      • energy
      • electricity
      • residual_fuel_oil
      • distillate_fuel_oil
      • natural_gas
      • lpg_and_ngl
      • coal
      • coke_and_breeze
      • other_fuel
      .

Table structure

CREATE TABLE mecs_energies
  (
     name                      CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     census_region_number      INTEGER,
     naics_code                CHARACTER VARYING(255),
     energy                    FLOAT,
     energy_units              CHARACTER VARYING(255),
     electricity               FLOAT,
     electricity_units         CHARACTER VARYING(255),
     residual_fuel_oil         FLOAT,
     residual_fuel_oil_units   CHARACTER VARYING(255),
     distillate_fuel_oil       FLOAT,
     distillate_fuel_oil_units CHARACTER VARYING(255),
     natural_gas               FLOAT,
     natural_gas_units         CHARACTER VARYING(255),
     lpg_and_ngl               FLOAT,
     lpg_and_ngl_units         CHARACTER VARYING(255),
     coal                      FLOAT,
     coal_units                CHARACTER VARYING(255),
     coke_and_breeze           FLOAT,
     coke_and_breeze_units     CHARACTER VARYING(255),
     other_fuel                FLOAT,
     other_fuel_units          CHARACTER VARYING(255)
  );