About this Dataset

U.S. Electric Utility Companies And Rates: Look-up By Zip Code (2024)

This dataset, compiled by NREL using data from ABB, the Velocity Suite (http://energymarketintel.com/) and the U.S. Energy Information Administration dataset 861 (http://www.eia.gov/electricity/data/eia861/), 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 (https://openei.org/apps/USURDB/).
Organization: Department of Energy
Last updated: 2025-11-11T15:17:12.744942
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zip-code, zipcode

Tables

Iou Zipcodes 2024

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__2c1b1c08.iou_zipcodes_2024

234.04 kB
49,004 rows
9 columns

CREATE TABLE iou_zipcodes_2024 (
  "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 Zipcodes 2024

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__2c1b1c08.non_iou_zipcodes_2024

215.4 kB
28,009 rows
9 columns

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