Utility Service Territories

EIA-861 service territory: every county each utility serves, by year.

Native record
event_time x utility_number x state x county 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

Service_Territory, one row per utility, state and county. Community choice aggregators mostly report no counties (one of 26 did for 2024), so a CCA's footprint has to come from its member jurisdictions or the wires utility's territory. 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, county, duplicate_index) before aggregating.

Analysis rules

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

Schema9

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

Sample data

event_timeutility_numberutility_nameshort_formstatecountyduplicate_indexreleaseingested_at
2025-01-01 00:00:00.00000066866University of Massachusetts Amherst∅MAHampshire0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCMarlboro0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCMarion0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCLee0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCFlorence0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCDillon0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCDarlington0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066073MPD Electric Cooperative∅SCChesterfield0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066062Shelter Cove Resort Improvement Dist No. 1YCAHumboldt0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066058Ticaboo Electric Improvement DistrictYUTGarfield0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066052Kirkwood Meadows PUDYCAAmador0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000066052Kirkwood Meadows PUDYCAAlpine0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000065352Umpqua Indian Utility CooperativeYORDouglas0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000065261Gila River Indian Utility Authority (GRICUA)∅AZPinal0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000065261Gila River Indian Utility Authority (GRICUA)∅AZMaricopa0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000062779Lathrop Irrigation DistrictYCASan Joaquin0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSSeward0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSReno0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSPratt0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSMeade0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSKiowa0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSKingman0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSHaskell0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSHarper0early_release2026-09-29 00:39:36.020212
2025-01-01 00:00:00.00000060839Southern Pioneer Electric Company∅KSComanche0early_release2026-09-29 00:39:36.020212

Coverage

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