About this Dataset

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

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. A more recent version of this data is also available through the NREL Utility Rate API with more search options. This data was released by NREL/Ventyx in February 2011.
Organization: Department of Energy
Last updated: 2021-06-24T00:05:58.300793
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zipcode

Tables

Noniouzipcodes2011

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__8d27f509.noniouzipcodes2011

206.85 KB
18667 rows
9 columns


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