Utility Balancing Authorities

EIA-861 balancing authorities: code, id, name and the states each operates in.

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

Balancing_Authority. The 2012 file maps utilities to balancing authorities instead, and carries utility_number where later years do not. 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, ba_code, state, utility_number, duplicate_index) before aggregating.

Analysis rules

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

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
ba_idNullable(Int64)
ba_codeLowCardinality(String)
stateLowCardinality(String)
balancing_authority_nameLowCardinality(Nullable(String))
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeba_idba_codestatebalancing_authority_nameutility_numberutility_nameduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000317YADNCAlcoa Power Generating, Inc. - Yadkin Division0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000019610WAUWWYWestern Area Power Administration UGP West0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000019610WAUWUTWestern Area Power Administration UGP West0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000019610WAUWMTWestern Area Power Administration UGP West0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000025471WALCUTWestern Area Power Administration - Desert Southwest Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000025471WALCNVWestern Area Power Administration - Desert Southwest Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000025471WALCNMWestern Area Power Administration - Desert Southwest Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000025471WALCCAWestern Area Power Administration - Desert Southwest Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000025471WALCAZWestern Area Power Administration - Desert Southwest Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMWYWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMUTWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMSDWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMNMWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMNEWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMNDWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMMTWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMKSWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000028503WACMCOWestern Area Power Administration - Rocky Mountain Region0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVAVATennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVATNTennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVANCTennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVAMSTennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVAKYTennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVAGATennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517
2025-01-01 00:00:00.00000018642TVAALTennessee Valley Authority0∅0early_release2026-09-29 00:39:36.688517

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