Baselight
Sign In

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

Department of Energy

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__6b4a8ec9

About this Dataset

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

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: 2022-11-22T13:13:28.825078
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__6b4a8ec9.iou_rates_with_zip_codes
  • 239.5 KB
  • 52177 rows
  • 9 columns
Loading...
 

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__6b4a8ec9.non_iou_rates_with_zip_codes
  • 210.22 KB
  • 28057 rows
  • 9 columns
Loading...
 

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
);