Distribution Systems

EIA-861 distribution systems: distribution circuit counts and circuits with voltage optimization, by utility.

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

Distribution_Systems, 2013 on. 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.

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
stateLowCardinality(String)
distribution_circuitsNullable(Float64)
circuits_with_voltage_optimizationNullable(Float64)
short_formLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeutility_numberutility_namestatedistribution_circuitscircuits_with_voltage_optimizationshort_formduplicate_indexreleaseingested_at
2025-01-01 00:00:00.00000066866University of Massachusetts AmherstMA244∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000066073MPD Electric CooperativeSC154109∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000065261Gila River Indian Utility Authority (GRICUA)AZ320∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000060839Southern Pioneer Electric CompanyKS600∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000060631Upper Michigan Energy Resources Corp.MI650∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000060482CKenergy Electric CooperativeOK980∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000059505Heartland REMCIN72∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000058124City of Winter Park - (FL)FL170∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000056146Black Hills Colorado Electric, LLCCO1470∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000055982Heart of Texas Electric CoopTX66∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000055959Roughrider Electric CooperativND148∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000055937Entergy Texas Inc.TX499∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000049998City of Berea Municipal UtilityKY90∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000044372Oncor Electric Delivery Company LLCTX38743487∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040606City of Grand Island - (NE)NE560∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040456PUD No 1 of Whatcom CountyWA11∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040437Emerald People's Utility DistOR21∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040429American Samoa Power AuthorityAS12∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040364City of CourtlandAL20∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040304Minnesota Valley Coop L&P AssnMN640∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040303Monroe County Elec Power AssnMS240∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040302North East Mississippi EPAMS490∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040293Northwestern Rural E C A, Inc - (PA)PA4040∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040292REA Energy Coop IncPA70∅∅0early_release2026-09-29 00:39:37.186782
2025-01-01 00:00:00.00000040290Tri-County Rural Elec Coop Inc (PA)PA4742∅0early_release2026-09-29 00:39:37.186782

Coverage

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