🔔 EIA-861M Utility Sales & Revenue to Ultimate Customers

Structured monthly sales-and-revenue-to-ultimate-customers records from the U.S. EIA Form EIA-861M, read directly from the official current-year sales_ult_cust_<year>.xlsx workbook on www.eia.gov. One record per row of the -States and -Territory sheets, carried source-native and verbatim.

Output is one utility_sales_record row per result; billing is pay-per-event, the value event being one utility sales & revenue record (a $0.02 start fee per run, then $0.02 per utility sales & revenue record). Source: www.eia.gov.

No login, no API key and no CAPTCHA solving are involved: the source is read logged-out with an identified contact User-Agent.

📊 Sample Output

Real rows from run cTMyabgGgcnW3ueRW on build 0.1.5 (2026-09-19), the same input as the Quick start below — every value is as the source published it (emails masked, long text shortened):

sheet	utility_name	ownership	data_status	residential_sales	commercial_sales
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	11460.783	10468.391
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	14265.222	10601.126
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	18565.284	11313.801
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	21041.86	11766.499
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	19673.991	11411.366
Sales Ultimate Cust. -States	Alaska Electric Light & Power Co.	Investor Owned	Preliminary	24845.489	12837.432

The run finished with the status message: NORMAL: 6 unique rows (0 duplicates collapsed) from sales_ult_cust_2026. billable=6

✅ What you get

Each row is flat JSON with these fields (from the dataset schema and the sample run; a field the source does not publish for a given row is null):

• sheet (string/null) — e.g. Sales Ultimate Cust. -States
• year (string/null) — e.g. 2026
• month (string/null) — e.g. 6
• utility_number (string/null) — e.g. 213
• utility_name (string/null) — e.g. Alaska Electric Light & Power Co.
• state (string/null) — e.g. AK
• ownership (string/null) — e.g. Investor Owned
• data_status (string/null) — e.g. Preliminary
• residential_revenue (string/null) — e.g. 1219.655
• residential_sales (string/null) — e.g. 11460.783
• residential_customers (string/null) — e.g. 15688
• commercial_revenue (string/null) — e.g. 972.086
• commercial_sales (string/null) — e.g. 10468.391
• commercial_customers (string/null) — e.g. 2535
• industrial_revenue (string/null) — e.g. 1137.431
• industrial_sales (string/null) — e.g. 10840.764
• industrial_customers (string/null) — e.g. 150
• transportation_revenue (string/null) — e.g. 0
• transportation_sales (string/null) — e.g. 0
• transportation_customers (string/null) — e.g. 0
• total_revenue (string/null) — e.g. 3329.172
• total_sales (string/null) — e.g. 32769.938
• total_customers (string/null) — e.g. 18373
• row_type (string/null) — e.g. utility
• record_type (string/null) — e.g. utility_sales_record
• reporting_period (string/null) — e.g. 2026-6
• units (string/null) — e.g. revenue in thousand USD; sales in megawatthours (MWh); customers as a count
• revision_note (string/null) — e.g. EIA-861M monthly; the most recent months are PRELIMINARY and revised over a roll
• record_key (string/null) — e.g. eia861m-sales:2026:6:AK:213:utility:00ad1d31d72e704e
• source_url (string/null) — e.g. https://www.eia.gov/electricity/data/eia861m/xls/sales_ult_cust_2026.xlsx
• source (string/null) — e.g. eia861m-utility-sales-revenue
• release_date (string/null) — e.g. sales_ult_cust_2026
• observed_at (string/null) — e.g. 2026-09-19T02:19:57Z
• release_checksum (string/null) — e.g. 2026
• license (string/null) — e.g. U.S. Energy Information Administration (EIA), Form EIA-861M (monthly electric po
• attribution (string/null) — e.g. U.S. Energy Information Administration — Form EIA-861M (https://www.eia.gov/elec
• terminal (string/null) — null in every sample row
• scope (string/null) — null in every sample row
• note (string/null) — null in every sample row
• reported_total (string/integer/null) — null in every sample row
• raw_seen (string/integer/null) — null in every sample row
• duplicates (string/integer/null) — null in every sample row
• unique_found (string/integer/null) — null in every sample row
• delivered (string/integer/null) — null in every sample row

✅ What you get

• sheet (string/null) — e.g. Sales Ultimate Cust. -States
• year (string/null) — e.g. 2026
• month (string/null) — e.g. 6
• utility_number (string/null) — e.g. 213
• utility_name (string/null) — e.g. Alaska Electric Light & Power Co.
• state (string/null) — e.g. AK
• ownership (string/null) — e.g. Investor Owned
• data_status (string/null) — e.g. Preliminary
• residential_revenue (string/null) — e.g. 1219.655
• residential_sales (string/null) — e.g. 11460.783
• residential_customers (string/null) — e.g. 15688
• commercial_revenue (string/null) — e.g. 972.086
• commercial_sales (string/null) — e.g. 10468.391
• commercial_customers (string/null) — e.g. 2535
• industrial_revenue (string/null) — e.g. 1137.431
• industrial_sales (string/null) — e.g. 10840.764
• industrial_customers (string/null) — e.g. 150
• transportation_revenue (string/null) — e.g. 0
• transportation_sales (string/null) — e.g. 0
• transportation_customers (string/null) — e.g. 0
• total_revenue (string/null) — e.g. 3329.172
• total_sales (string/null) — e.g. 32769.938
• total_customers (string/null) — e.g. 18373
• row_type (string/null) — e.g. utility
• record_type (string/null) — e.g. utility_sales_record
• reporting_period (string/null) — e.g. 2026-6
• units (string/null) — e.g. revenue in thousand USD; sales in megawatthours (MWh); customers as a count
• revision_note (string/null) — e.g. EIA-861M monthly; the most recent months are PRELIMINARY and revised over a roll
• record_key (string/null) — e.g. eia861m-sales:2026:6:AK:213:utility:00ad1d31d72e704e
• source_url (string/null) — e.g. https://www.eia.gov/electricity/data/eia861m/xls/sales_ult_cust_2026.xlsx
• source (string/null) — e.g. eia861m-utility-sales-revenue
• release_date (string/null) — e.g. sales_ult_cust_2026
• observed_at (string/null) — e.g. 2026-09-19T01:42:04Z
• release_checksum (string/null) — e.g. 2026
• license (string/null) — e.g. U.S. Energy Information Administration (EIA), Form EIA-861M (monthly electric po
• attribution (string/null) — e.g. U.S. Energy Information Administration — Form EIA-861M (https://www.eia.gov/elec
• terminal (string/null) — null in every sample row
• scope (string/null) — null in every sample row
• note (string/null) — null in every sample row
• reported_total (string/integer/null) — null in every sample row
• raw_seen (string/integer/null) — null in every sample row
• duplicates (string/integer/null) — null in every sample row
• unique_found (string/integer/null) — null in every sample row
• delivered (string/integer/null) — null in every sample row

What you get

One utility_sales_record per source row: reporting period (year, month, reporting_period), respondent identity (utility_number, utility_name, state, ownership), source data_status, row_type, and the sector breakdown — residential / commercial / industrial / transportation / total — of revenue, sales and customers, plus units, source_url, license.

⚙️ Sample inputs

1. Quick start — the Store example (this is what the sample above came from)

{
  "utilityNumbers": [
    "213"
  ],
  "maxRecords": 10
}

The sample run charged exactly: 2 × $0.02 apify-actor-start + 6 × $0.02 utility_sales_record = $0.16 on the Free tier — every delivered row was billed.

2. A smaller, narrowed run

{
  "utilityNumbers": [
    "213"
  ],
  "maxRecords": 5
}

Caps the run at 5 rows — about $0.12 on the Free tier ($0.02 start + 5 × $0.02).

3. A full-size run

{
  "utilityNumbers": [
    "213"
  ],
  "maxRecords": 2500
}

Up to 2500 rows (the schema default for maxRecords) — about $50.02 on the Free tier ($0.02 start + 2500 × $0.02) if the source has that many.

4. A filtered run

{
  "utilityNumbers": [
    "213"
  ],
  "maxRecords": 10,
  "fieldMatch": {
    "utility_name": "Alaska Electric Light & Power Co."
  }
}

Keeps only rows whose utility_name contains Alaska Electric Light & Power Co. (a value from the sample run above), matched case-insensitively after the source is read and before the maxRecords cap, so the cap counts matches and only delivered matches are billed. searchText does the same across every column. Zero matches end the run as EMPTY_SELECTION with no row charged — if the source has moved on since that sample run, pick a value you see in your own first run. The source is still read in full — this narrows what you receive and pay for, not what the source serves.

🧾 JSON sample record

One real record from run cTMyabgGgcnW3ueRW, exactly as it lands in the dataset (emails masked, long text shortened):

{
  "sheet": "Sales Ultimate Cust. -States",
  "year": "2026",
  "month": "6",
  "utility_number": "213",
  "utility_name": "Alaska Electric Light & Power Co.",
  "state": "AK",
  "ownership": "Investor Owned",
  "data_status": "Preliminary",
  "residential_revenue": "1219.655",
  "residential_sales": "11460.783",
  "residential_customers": "15688",
  "commercial_revenue": "972.086",
  "commercial_sales": "10468.391",
  "commercial_customers": "2535",
  "industrial_revenue": "1137.431",
  "industrial_sales": "10840.764",
  "industrial_customers": "150",
  "transportation_revenue": "0",
  "transportation_sales": "0",
  "transportation_customers": "0",
  "total_revenue": "3329.172",
  "total_sales": "32769.938",
  "total_customers": "18373",
  "row_type": "utility",
  "record_type": "utility_sales_record",
  "reporting_period": "2026-6",
  "units": "revenue in thousand USD; sales in megawatthours (MWh); customers as a count",
  "revision_note": "EIA-861M monthly; the most recent months are PRELIMINARY and revised over a rolling ~6-month window — the source data_status is carried verbatim per record",
  "record_key": "eia861m-sales:2026:6:AK:213:utility:00ad1d31d72e704e",
  "source_url": "https://www.eia.gov/electricity/data/eia861m/xls/sales_ult_cust_2026.xlsx",
  "source": "eia861m-utility-sales-revenue",
  "release_date": "sales_ult_cust_2026",
  "observed_at": "2026-09-19T02:19:57Z",
  "release_checksum": "2026",
  "license": "U.S. Energy Information Administration (EIA), Form EIA-861M (monthly electric power industry report) — U.S. Government work, public domain. The most recent months are preliminary and subject to revision. Acknowledgement: data from the U.S. ",
  "attribution": "U.S. Energy Information Administration — Form EIA-861M (https://www.eia.gov/electricity/data/eia861m/)"
}

🔧 How it works

Source. The actor reads www.eia.gov — endpoints: https://www.eia.gov, https://www.eia.gov/electricity/data/eia861m/, https://www.eia.gov/electricity/data/eia861m/xls/sales_ult_cust_. Public pages and feeds only; nothing behind a login.

Transport. Plain HTTPS from the Apify platform, no proxy. robots.txt is read first and a disallowed path is never fetched. Every request carries an identified contact User-Agent. Pacing: CRAWL_DELAY=0.0.

Terminal states. A run ends NORMAL, CAPPED (your cap was reached), PARTIAL (something was withheld and the message says what), GENUINE_EMPTY (the source was read and truly had nothing in scope) or BLOCKED (the source refused or changed shape — the run FAILS loud and bills nothing). A zero-row run is never reported as a silent success.

Charging. Each utility sales & revenue record is charged at the moment it is pushed (utility_sales_record); a row that fails to charge is not delivered, so the dataset count always equals the charged count.

🔧 How it works

Aggregate vs utility — never mixed silently

Every record carries an explicit row_type so an aggregate is never mistaken for a single utility:

• utility — a single reporting utility
• state_total — the EIA "State Total" aggregate (utility number 88888)
• us_total — the EIA "US Total" aggregate (utility number 88888)
• state_adjustment — the EIA "State Adjustment" reconciliation row (utility number 0)

Filter to exactly the row type you want with rowTypes.

Preliminary data & the revision window

EIA-861M is a monthly series. The most recent months are preliminary and are revised over a rolling ~6-month window. The source data_status (Preliminary / Final) is carried verbatim on every record so you always know a value's edit state; a revision_note restates the window.

Units — preserved exactly

Values are carried exactly as reported. A units field states the units on every record: revenue in thousand USD, sales in megawatthours (MWh), customers as a count. Nothing is converted or rescaled.

Filters

Supply at least one of utilityNumbers, states, ownerships, rowTypes, or months — the sheets are never emitted in full. maxRecords caps delivery (one charge per delivered record, hard cap 5000).

Integrity, robots & door

A per-sheet schema canary fails loud on header drift. Only the current sales_ult_cust_<year>.xlsx is read — www.eia.gov/robots.txt disallows /archive/, which is never fetched. No third-party content or logos.

Source & licence

U.S. Energy Information Administration, Form EIA-861M — U.S. Government work, public domain (recent months preliminary, subject to revision). Acknowledgement: data from the U.S. Energy Information Administration (https://www.eia.gov/electricity/data/eia861m/).

What is not done. No login, no cookie or CAPTCHA bypass, no private or personal-account data, no browser automation.

💰 Pricing example

Event	Free	Bronze	Silver	Gold
Actor Start (apify-actor-start)	$0.02	$0.02	$0.02	$0.02
Utility sales & revenue record (utility_sales_record)	$0.02	$0.018	$0.016	$0.0134

Worked at the live Free-tier price:

• 6 utility sales & revenue records: $0.02 start + 6 × $0.02 = $0.14
• 25 utility sales & revenue records: $0.02 start + 25 × $0.02 = $0.52
• 2500 utility sales & revenue records: $0.02 start + 2500 × $0.02 = $50.02

A run that delivers zero rows charges the $0.02 start fee only. A BLOCKED run (source refused) fails loud and charges no value event. The start fee is charged once per GB of run memory; the default run memory is 4096 MB.

Yield on the sample run: NORMAL: 6 unique rows (0 duplicates collapsed) from sales_ult_cust_2026. billable=6. maxRecords is a hard ceiling on what is delivered and billed, never a target.

⚖️ Legal & ToS

This actor reads public, logged-out pages and feeds published by www.eia.gov. It collects only what the source publishes to any visitor, keeps to the source's robots rules (checked on every run), identifies itself with a contact User-Agent, and does not access accounts, private data or anything behind authentication. Use the output in line with the source's terms and your local law; the intended use is B2B research and monitoring.

❓ FAQ

Q: Do I need an API key or a login?
A: No. The source (www.eia.gov) is read logged-out; the input schema has no key field and the actor carries no secrets.

Q: Why did my run return 0 rows?
A: Read the run's status message. GENUINE_EMPTY means the source was read and had nothing in scope for your input; BLOCKED means the source refused and the run failed without billing a value event — retry later or narrow the input. A zero-row run bills the start fee only.

Q: How many rows can one run return?
A: Up to maxRecords (default 2500). Raise the cap for a bigger run; you pay per delivered row.

Q: How fresh is the data?
A: Every run reads the source live at run time; nothing is cached between runs. Put it on a schedule for a continuous feed.

Q: What formats can I export?
A: The dataset downloads as JSON, CSV, Excel, XML or RSS from the run's Dataset tab or the Apify API, and any run can push to a webhook or integration.

Q: How is this different from the other NexGen Watch actors actors?
A: Same output shape and billing model; this one covers www.eia.gov. The siblings under Related Actors cover the other sources or slices — run several on one schedule for a combined feed.

Q: Are there rate limits?
A: The actor paces itself against the source (CRAWL_DELAY=0.0) and honours its robots rules; there is no per-buyer limit beyond your Apify plan's concurrency.

🆘 Troubleshooting

• Run FAILED with BLOCKED → the source refused the request or changed its page shape → nothing was billed beyond the start fee; retry after a while, and if it persists open an Issue with the run id.
• Status says CAPPED → your cap (maxRecords) was reached → raise it for a bigger run.
• Input validation error on start → a field is outside the schema's allowed values → start from the Quick start block and change one field at a time.
• Run TIMED-OUT → a very wide request on a slow day → raise the run timeout in Run options or narrow the input; what was delivered before the timeout is still in the dataset.

🔗 Related Actors

• EIA-861 Filing Frame (schedule presence per utility) — Structured filing-frame records from the U.S. EIA Form EIA-861 Annual Electric Power Industry Report, read directly from the official current-year ZI…
• EIA-861 Utility Service Territory (Counties) — Structured utility service-territory records from the U.S. EIA Form EIA-861 Annual Electric Power Industry Report, read directly from the official cu…
• EIA-861M Net Metering & Distributed Generation Matrix — Structured net-metering and distributed-generation records from the U.S. EIA Form EIA-861M, read directly from the official current-year net_metering…
• EIA-923 Air Emissions Control Operations (Annual Release) — Structured air-emissions-control operating records from the U.S. EIA Form EIA-923 Schedule 8C — Air Emissions Control Information sheet, read directl…
• EIA-923 Boiler Fuel Data (Monthly, Preliminary) — Structured boiler-level fuel consumption records from the U.S. EIA Form EIA-923 Page 3 Boiler Fuel Data, read directly from the official current-year…
• EIA-923 Byproduct Disposition (Annual Release) — Structured combustion-byproduct disposition records from the U.S. EIA Form EIA-923 Schedule 8A — Annual Byproduct Disposition sheet, read directly fr…
• 🏢 About NexGenData — NexGen Watch is NexGenData's fleet of more than 300 public data actors built on official sources, pay-per-result. Browse the catalog at apify.com/nexgenwatch.

⭐ Found this useful?

If this actor saved you a manual check, a quick review on the Apify Store helps other teams find it. Feature request or a source that changed? Open it from the Issues tab — every one is read.