Ask the Grid
Open live grid

Short-Form Utility Sales

EIA-861S short form: totals and program flags for the small utilities that file the short form instead of the full schedules.

EIALoad data
Download data
Native record
event_time x utility_number x state 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

Short_Form (861S). Revenue in thousand dollars, sales in MWh. 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, duplicate_index) before aggregating.

Analysis rules

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

Schema17

Column
Type
event_timeDateTime64(6, 'UTC')
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
ownershipLowCardinality(Nullable(String))
stateLowCardinality(String)
ba_codeLowCardinality(Nullable(String))
total_revenue_thousand_dollarsNullable(Float64)
total_sales_mwhNullable(Float64)
total_customersNullable(Float64)
water_heaterNullable(Float64)
net_meteringLowCardinality(Nullable(String))
demand_side_managementLowCardinality(Nullable(String))
time_based_programsLowCardinality(Nullable(String))
green_pricingLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeutility_numberutility_nameownershipstateba_codetotal_revenue_thousand_dollarstotal_sales_mwhtotal_customerswater_heaternet_meteringdemand_side_managementtime_based_programsgreen_pricingduplicate_indexreleaseingested_at
2025-01-01 00:00:00.00000066062Shelter Cove Resort Improvement Dist No. 1Political SubdivisionCACISO1366.93743648∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000066058Ticaboo Electric Improvement DistrictPolitical SubdivisionUTWALC306.357697∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000066052Kirkwood Meadows PUDPolitical SubdivisionCACISO53236749754∅YNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000065352Umpqua Indian Utility CooperativeCooperativeORBPAT20322227471∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.000000632864 Rivers Electric Cooperative, Inc.CooperativeKSSWPP2914115743812481∅YNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000062779Lathrop Irrigation DistrictPolitical SubdivisionCACISO8270.4377234104∅YNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000060715Port of OaklandMunicipalCACISO1883983311120∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000060080Pleasant Hill Community LineCooperativeIASWPP526.14498140∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058139Town of Pickstown - (SD)MunicipalSDSWPP281.62946182∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058126Pittsburg Power CompanyMunicipalCACISO699923292595∅YNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058123Aha Macav Power ServicePolitical SubdivisionNVWALC2208.818300285∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058123Aha Macav Power ServicePolitical SubdivisionCAWALC462.64440115∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058123Aha Macav Power ServicePolitical SubdivisionAZWALC2500.721860726∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000058113Texas A&M, Utilities & Energy ServicesStateTXERCO47225544440∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000057194City of Industry - (CA)MunicipalCACISO6409.144389142∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000056739Gold Country EnergyInvestor OwnedAKNA270347137∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000056536Riverside Electric CooperativeCooperativeIDIPCO184123822630∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000056535City of Williams - AZMunicipalAZAZPS5692432602345∅NYN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000056503TDX Manley Generating LLCInvestor OwnedAKNA521544116∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000056224Rancho Cucamonga Municipal UtilityMunicipalCACISO211371404753758∅YYY∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000055962City of Victorville - (CA)MunicipalCACISO2147910617692∅YNY∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000049986Southwest Iowa Rural Elec CoopCooperativeIAMISO13587.91003326094∅NYN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000049826Mohegan Tribal Utility AuthorityPolitical SubdivisionCTISNE14774.512091975∅NNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000040604Heartland Consumers Power DistPolitical SubdivisionSDSWPP1484.5175113∅YNN∅0early_release2026-09-29 00:39:36.193255
2025-01-01 00:00:00.00000040548Unalakleet Valley Elec CoopCooperativeAKNA24133635385∅YNN∅0early_release2026-09-29 00:39:36.193255

Coverage

0.3% complete4,737 gap days13 days with data
Show coverage history
Coverage: 0.3%Days with data: 13Gaps: 4,737
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
gaplessmore