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).
Les titres et les descriptions proviennent des sources de données, en anglais.
- Lignes
- 23 460
- Colonnes
- 24
- Cadence de la source
- Mensuelle
- Dernière actualisation
- 29 sept. 2026
- Thème
- energy
| Colonne | 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). |
10 premières lignes d’exemple — un aperçu, pas le jeu de données complet.
| 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 |
- Actuelle
20260929T234354Z-b761f91ddf0c · sha256 b761f91ddf0c…
23 460 lignes · premier instantané
Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (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)Point d’accès API : https://datazimuts.com/v1/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly
Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.
D’où viennent ces données et ce qui en a été fait. Le travail des autres apparaît sous forme de décomptes ; seuls les projets partagés sont nommés.
Citer cet instantané
Épinglé à l’instantané 20260929T234354Z-b761f91ddf0c et à son empreinte, pour que vos lecteurs obtiennent exactement les données utilisées.
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/fr/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/fr/datasets/eia_state_electricity_price_intel/us_state_electricity_price_monthly?snapshot=20260929T234354Z-b761f91ddf0c}},
note = {Snapshot 20260929T234354Z-b761f91ddf0c, sha256 b761f91ddf0c4e7339751cac67baa07aba6e07663e64ae9bd7795eea38e0dcbb; accessed 2026-09-30}
}Intégrer un tableau ou un graphique
Collez ce code dans n’importe quelle page. L’intégration est épinglée au même instantané, suit le thème clair ou sombre du lecteur et affiche toujours la source, la licence et un lien de retour.
<iframe src="https://datazimuts.com/embed/chart?dataset=eia_state_electricity_price_intel%2Fus_state_electricity_price_monthly&lang=fr&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>
Posez une question sur ce jeu de données. Les réponses viennent uniquement de sa fiche, de son profil mesuré et de son historique, et citent les faits utilisés.