U.S. Electric Utility Companies And Rates: Look-up By Zipcode (2019) by US Government | Demographics and Population Studies

About this Dataset

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

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 with likely zip codes for both investor owned utilities (IOU) and non-investor owned utilities. Note: the files include average rates for each utility (not average rates per zip code), 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:20:44.093715
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zip-code, zipcode

Tables

IOU Rates With Zip Codes

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__f3a2808c.iou_rates_with_zip_codes

240.89 KB
52246 rows
9 columns


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

Non-IOU Rates With Zip Codes

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__f3a2808c.non_iou_rates_with_zip_codes

327.97 KB
36494 rows
9 columns


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