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

About this Dataset

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

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 by zip code for both investor owned utilities (IOU) and non-investor owned utilities. Note: the file includes average rates for each utility, 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.575382
Tags: electric-rates, rate-lookup, rates, us-utilities, utility-companies, utility-rates, zipcode

Tables

IOU Rates By Zipcode

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__f8947577.iou_rates_by_zipcode

241.09 KB
52493 rows
9 columns


CREATE TABLE iou_rates_by_zipcode (
  "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 By Zipcode

@usgov.doe_gov_u_s_electric_utility_companies_and_rates_look__f8947577.non_iou_rates_by_zipcode

269.79 KB
34099 rows
9 columns


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