US state monthly retail electricity price intelligence
US state monthly retail electricity price intelligence from the keyless U.S. Energy Information Administration Form EIA-861M monthly workbooks: one row per month per state per sector (residential, commercial, industrial, transportation), 2017-01 to present, 50 states + DC. Each row carries the average retail price (cents/kWh, computed as 100 * summed revenue / summed sales across utilities), the customer count, the same-month US average price, the state's premium or discount vs the US in cents and percent, gap-aware month-over-month and year-over-year changes in cents and percent (null when a comparison month is missing or not exactly 1/12 months earlier — never annualized or filled), the per-month cross-state price and premium ranks, a price quintile tier, a documented 0-100 power-bill pressure score (50% winsorized YoY momentum + 50% trailing-12-month range position), and sharp-move (>=5% MoM) / 12-month-record-high flags, plus a final/preliminary data-status marker. Method: aggregate EIA's utility-level filings to the state x sector grain; momentum requires exact month spacing. Caveats: prices are billed-revenue averages (not quoted tariffs); the transportation sector is genuinely sparse (EV charging footprint); recent months arrive Preliminary and are revised by EIA; the score is a relative history gauge of bill pressure, not a price forecast. U.S. federal public domain (commercial reuse allowed with attribution to the U.S. Energy Information Administration).
- Rows
- 23,460
- Columns
- 24
- Source cadence
- Monthly
- Last refreshed
- Sep 29, 2026
- Theme
- energy
| Column | Type | Description |
|---|---|---|
| month_start | date | First day of the EIA-861M reporting month (the filings cover that calendar month). Join key with state_code and sector. (unit: date) |
| state_code | string | USPS 2-letter state code (50 states + DC). Join key with month_start and sector. |
| state_name | string | Full state name. |
| country | string | Country name (shared normalization layer). |
| country_code | string | ISO 3166-1 alpha-3 country code (USA). |
| sector | string | EIA end-use sector: residential, commercial, industrial, transportation. |
| price_cents_kwh | float | Average retail price, computed as 100 * (summed revenue in thousand USD) / (summed sales in MWh) across the utilities reporting in that state and month (including EIA's adjustment rows). Null when no sales were reported or the computed price is non-positive (adjustment-row arithmetic, not a tariff). (unit: US cents/kWh) |
| customers | float | Summed customer count across reporting utilities in that state, month and sector. (unit: count) |
| us_price_cents_kwh | float | National average retail price for the same month and sector, from EIA's 'US Total EPM' aggregate row (reference for the premium arithmetic; not a panel row). (unit: US cents/kWh) |
| premium_vs_us_cents | float | State price minus the same-month, same-sector US average price. Positive = the state pays a premium; negative = a discount. Null when the US reference is missing. (unit: US cents/kWh) |
| premium_vs_us_pct | float | premium_vs_us_cents expressed as a percent of the US average price. (unit: percent) |
| mom_change_cents | float | Month-over-month price change vs the month exactly 1 month earlier. Null when that month is missing (revision skips are never filled). (unit: US cents/kWh) |
| mom_change_pct | float | Month-over-month percent change (same gap-aware rule as mom_change_cents). (unit: percent) |
| yoy_change_cents | float | Year-over-year price change vs the month exactly 12 months earlier (gap-aware, null on breaks). (unit: US cents/kWh) |
| yoy_change_pct | float | Year-over-year percent change (same gap-aware rule). (unit: percent) |
| price_rank_month | integer | Cross-state price rank within the month and sector (1 = cheapest of the 51). Null when the price is null. (unit: rank) |
| premium_rank_month | integer | Cross-state rank of premium_vs_us_cents within the month and sector (1 = deepest discount vs the US average). (unit: rank) |
| price_tier_month | string | Quintile tier of the month's cross-state price distribution: cheapest_fifth / low_fifth / middle_fifth / high_fifth / priciest_fifth. |
| power_bill_pressure_score | float | Documented 0-100 power-bill pressure gauge: 100 * (0.5 * winsorized-YoY-component + 0.5 * trailing-12-month range position), where the YoY percent change is winsorized to [-30, +30] and scaled to 0-100. Null until 12 priced months exist. A relative history gauge, not a price forecast. (unit: 0-100 score) |
| sharp_move_flag | boolean | True when |mom_change_pct| >= 5.0. Null when mom_change_pct is null. |
| record_high_12m_flag | boolean | True when the month's price is >= its trailing-12-month maximum (ties count). |
| data_status | string | 'final' when every reporting utility in that state and month is Final, else 'preliminary' (EIA revises preliminary months). |
| source_url | string | Exact EIA-861M workbook URL this month's rows were parsed from. |
| row_hash | string | Deterministic 16-hex sha256 of month_start + state_code + sector (idempotency key). |
First 10 sample rows — a preview, not the complete dataset.
| month_start | state_code | state_name | country | country_code | sector | price_cents_kwh | customers | us_price_cents_kwh | premium_vs_us_cents | premium_vs_us_pct | mom_change_cents | mom_change_pct | yoy_change_cents | yoy_change_pct | price_rank_month | premium_rank_month | price_tier_month | power_bill_pressure_score | sharp_move_flag | record_high_12m_flag | data_status | source_url | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017-01-01 | AK | Alaska | United States | USA | commercial | 17.796 | 106,370 | 10.213 | 7.582 | 74.237 | — | — | — | — | 50 | 50 | priciest_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | fb537330f0a0b5f9 |
| 2017-01-01 | AK | Alaska | United States | USA | industrial | 16.725 | 2,690 | 6.585 | 10.139 | 153.964 | — | — | — | — | 50 | 50 | priciest_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | e3e540c1846fe3c4 |
| 2017-01-01 | AK | Alaska | United States | USA | residential | 20.287 | 567,504 | 12.213 | 8.074 | 66.108 | — | — | — | — | 50 | 50 | priciest_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 8239ad0cd1b2fa04 |
| 2017-01-01 | AK | Alaska | United States | USA | transportation | — | — | 9.388 | — | — | — | — | — | — | — | — | — | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | f0bb02738d75858a |
| 2017-01-01 | AL | Alabama | United States | USA | commercial | 11.451 | 738,518 | 10.213 | 1.237 | 12.115 | — | — | — | — | 40 | 40 | high_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 8cbf629c4e45344f |
| 2017-01-01 | AL | Alabama | United States | USA | industrial | 5.776 | 15,988 | 6.585 | -0.81 | -12.296 | — | — | — | — | 11 | 11 | cheapest_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 286aa1fc8a8f9354 |
| 2017-01-01 | AL | Alabama | United States | USA | residential | 12.037 | 4,410,614 | 12.213 | -0.176 | -1.445 | — | — | — | — | 33 | 33 | high_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 0780b1574d06515d |
| 2017-01-01 | AL | Alabama | United States | USA | transportation | — | — | 9.388 | — | — | — | — | — | — | — | — | — | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 56bb51cda4918373 |
| 2017-01-01 | AR | Arkansas | United States | USA | commercial | 8.069 | 381,702 | 10.213 | -2.144 | -20.995 | — | — | — | — | 7 | 7 | cheapest_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | 61036fb9939640e2 |
| 2017-01-01 | AR | Arkansas | United States | USA | industrial | 5.809 | 70,104 | 6.585 | -0.777 | -11.797 | — | — | — | — | 13 | 13 | low_fifth | — | — | false | final | https://www.eia.gov/electricity/data/eia861m/archive/xls/retail_sales_2017.xlsx | d66a0cc880201c7c |
- Current
20260929T234354Z-b761f91ddf0c · sha256 b761f91ddf0c…
23,460 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20260929T234354Z-b761f91ddf0c and its content hash, so readers get exactly the data you used.
U.S. Energy Information Administration. (2026). US state monthly retail electricity price intelligence [Data set, snapshot 20260929T234354Z-b761f91ddf0c, sha256 b761f91ddf0c]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly?snapshot=20260929T234354Z-b761f91ddf0c
@misc{dz_eia_state_electricity_price_intel_us_sta_b761f91d,
title = {{US state monthly retail electricity price intelligence}},
author = {{U.S. Energy Information Administration}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly?snapshot=20260929T234354Z-b761f91ddf0c}},
note = {Snapshot 20260929T234354Z-b761f91ddf0c, sha256 b761f91ddf0c4e7339751cac67baa07aba6e07663e64ae9bd7795eea38e0dcbb; accessed 2026-09-30}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
<iframe src="https://datazimuts.com/embed/chart?dataset=eia_state_electricity_price_intel%2Fus_state_electricity_price_monthly&lang=en&theme=auto&snapshot=20260929T234354Z-b761f91ddf0c&x=month_start&y=price_cents_kwh&agg=avg" title="US state monthly retail electricity price intelligence" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.