Ask the Grid
Open live grid

Delivery-Only Company Sales

EIA-861 delivery companies: revenue, MWh and customers reported by delivery-only companies, by customer class.

EIALoad data
Download data
Native record
event_time x utility_number x state x part x ba_code x customer_class x duplicate_index
annual (report year) publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Delivery_Companies, 2020 on, laid out like sales. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.

Query contract

Preserve one canonical row per (event_time, utility_number, state, part, ba_code, customer_class, duplicate_index) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, utility_number, state, part, ba_code, customer_class, duplicate_index.

Schema16

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
partLowCardinality(String)
service_typeLowCardinality(Nullable(String))
data_typeLowCardinality(Nullable(String))
stateLowCardinality(String)
ownershipLowCardinality(Nullable(String))
ba_codeLowCardinality(String)
revenues_thousand_dollarsNullable(Float64)
sales_mwhNullable(Float64)
customers_countNullable(Float64)
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classutility_numberutility_namepartservice_typedata_typestateownershipba_coderevenues_thousand_dollarssales_mwhcustomers_countduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportation59848ResCom Energy, LLCCDeliveryOTXRetail Power MarketerERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000total59848ResCom Energy, LLCCDeliveryOTXRetail Power MarketerERCO114780468950early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000residential59848ResCom Energy, LLCCDeliveryOTXRetail Power MarketerERCO114780468950early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000industrial59848ResCom Energy, LLCCDeliveryOTXRetail Power MarketerERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000commercial59848ResCom Energy, LLCCDeliveryOTXRetail Power MarketerERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000transportation44372Oncor Electric Delivery Company LLCCDeliveryOTXInvestor OwnedERCO5332.715534210early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000total44372Oncor Electric Delivery Company LLCCDeliveryOTXInvestor OwnedERCO531915317112704440847960early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000residential44372Oncor Electric Delivery Company LLCCDeliveryOTXInvestor OwnedERCO26528274704970335458140early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000industrial44372Oncor Electric Delivery Company LLCCDeliveryOTXInvestor OwnedERCO716457.574067446106130early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000commercial44372Oncor Electric Delivery Company LLCCDeliveryOTXInvestor OwnedERCO1944535.8498545535283680early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000transportation40051Texas-New Mexico Power CoCDeliveryOTXInvestor OwnedERCO∅∅∅0early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000total40051Texas-New Mexico Power CoCDeliveryOTXInvestor OwnedERCO486626191602602819820early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000residential40051Texas-New Mexico Power CoCDeliveryOTXInvestor OwnedERCO23310132866872379300early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000industrial40051Texas-New Mexico Power CoCDeliveryOTXInvestor OwnedERCO393306030528820early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000commercial40051Texas-New Mexico Power CoCDeliveryOTXInvestor OwnedERCO2141959843045439700early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000transportation20404AEP Texas North CompanyCDeliveryOTXInvestor OwnedERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000total20404AEP Texas North CompanyCDeliveryOTXInvestor OwnedERCO261407.8134860912014220early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000residential20404AEP Texas North CompanyCDeliveryOTXInvestor OwnedERCO109302.818664801584880early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000industrial20404AEP Texas North CompanyCDeliveryOTXInvestor OwnedERCO50551.6315330750840early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000commercial20404AEP Texas North CompanyCDeliveryOTXInvestor OwnedERCO101553.48466304378500early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000transportation13830Nueces Electric CooperativeCDeliveryOTXCooperativeERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000total13830Nueces Electric CooperativeCDeliveryOTXCooperativeERCO5970.333281112840early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000residential13830Nueces Electric CooperativeCDeliveryOTXCooperativeERCO0000early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000industrial13830Nueces Electric CooperativeCDeliveryOTXCooperativeERCO2205.8259466160early_release2026-09-29 00:39:36.848873
2025-01-01 00:00:00.000000commercial13830Nueces Electric CooperativeCDeliveryOTXCooperativeERCO3764.57334512680early_release2026-09-29 00:39:36.848873

Coverage

0.3% complete1,822 gap days6 days with data
Show coverage history
Coverage: 0.3%Days with data: 6Gaps: 1,822
2025
2024
2023
2022
2021
2020
gaplessmore