Energy Reference tableQC clean AI-training-safe

US Retail Electricity Prices & Sales by State (EIA)

What US electricity actually costs end-users, by state and customer sector, every month back to 2001 - the price-and-demand layer that completes our US power story (generation, capacity, emissions). From EIA's Electric Power Monthly retail-sales data: one clean row per (state × sector × month) with the average retail price (cents/kWh), sales (MWh), revenue and customer count. Residential / commercial / industrial / transportation / all sectors. Public domain.

113K
rows
9
columns
3.9 MB
download
Source
EIA_RETAIL
Licence
Redistributable open data
Quality
QC clean · 0 failures
Format
Apache Parquet + dictionary

Safe to train on

Built only from a named, redistributable official source under a documented open licence - not scraped web data. No copyright grey zone, no personal data. Ships machine-readable Croissant metadata (ML Commons - loads in Hugging Face / Kaggle / Google), an AI training-licence manifest documenting source, licence and provenance for your model's data governance, and a machine-readable data dictionary (drop it into an agent / RAG prompt so the model knows every column) - all inspectable before you buy.

What's included

  • Average retail electricity price (cents/kWh) by state × sector × month, 2001→present
  • Plus sales (MWh), revenue (M USD) and customer counts per cell
  • Sectors: residential, commercial, industrial, transportation, all
  • The price/demand layer beside our US generation, capacity & emissions products
  • Audiences: energy analysts, utilities, ESG, demand-response, policy, consumer research
  • Public domain (U.S. EIA, Electric Power Monthly) - free commercial reuse & resale
  • Source: U.S. Energy Information Administration - retail sales of electricity

Schema

ColumnTypeDescriptionFilledDistinct
state str US state / region code (with sector_id + month, the primary key) 100.0% 62
state_name str State / region name 100.0% 62
sector_id str Sector code (RES, COM, IND, TRA, ALL) 100.0% 6
sector str Customer sector name 100.0% 6
month str Month (YYYY-MM) 100.0% 304
price_cents_kwh float Average retail price (cents per kWh) 83.3% 3,175
sales_mwh float Retail sales (MWh) 83.3% 87,000
revenue_musd float Retail revenue (million USD) 83.3% 86,359
customers float Number of customers 60.3% 51,049

Sample & preview

Every purchase ships as Apache Parquet with a data dictionary and the full QC report. A free sample (first rows + schema) is downloadable here - confirm fit before you buy. Source: EIA_RETAIL (redistributable open data; attribution passes through - see our Licence).

Don't trust screenshots - drop the sample into your notebook right now.

import pandas as pd
df = pd.read_parquet("us-electricity-retail-prices_sample.parquet")
df.info()   # typed columns, gap-aware, ready to join
⬇ Download free Parquet sample or CSV for Excel