About this Dataset

U.S. Electric Utility Companies And Rates: Look-up By Zipcode (2013)

This dataset, compiled by NREL using data from ABB, the Velocity Suite and the U.S. Energy Information Administration dataset 861, provides average residential, commercial and industrial electricity rates by zip code for both investor owned utilities (IOU) and non-investor owned utilities. Note: the file includes average rates for each utility, but not the detailed rate structure data found in the OpenEI U.S. Utility Rate Database.
Organization: Department of Energy
Last updated: 2021-06-24T00:05:54.608872
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zipcode

Tables

Noniouzipcodes2013

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__7b0b1342.noniouzipcodes2013

189.17 KB
18025 rows
9 columns


CREATE TABLE noniouzipcodes2013 (
  "zip" BIGINT,
  "eiaid" BIGINT,
  "utility_name" VARCHAR,
  "state" VARCHAR,
  "service_type" VARCHAR,
  "ownership" VARCHAR,
  "comm_rate" DOUBLE,
  "ind_rate" DOUBLE,
  "res_rate" DOUBLE
);