Baselight

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

Department of Energy

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__eefaae2e

About this Dataset

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

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: 2024-04-06T04:39:13.362471
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zip-code, zipcode

Tables

IOU Rates With Zip Codes 2022

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__eefaae2e.iou_rates_with_zip_codes_2022
  • 238.89 KB
  • 52074 rows
  • 9 columns
Loading...

CREATE TABLE iou_rates_with_zip_codes_2022 (
  "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 2022

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__eefaae2e.non_iou_rates_with_zip_codes_2022
  • 210.17 KB
  • 28029 rows
  • 9 columns
Loading...

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