About this Dataset

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

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:05:57.706069
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zip-code, zipcode

Tables

Non-IOU Rates With Zip Codes

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__e98fe25e.non_iou_rates_with_zip_codes

275.95 kB
34,090 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
);