Utility Mergers

EIA-861 mergers: utilities merged or acquired during the report year.

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

Mergers, one row per merged utility. 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, merge_company, duplicate_index) before aggregating.

Analysis rules

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

Schema14

Column
Type
event_timeDateTime64(6, 'UTC')
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
merge_dateLowCardinality(Nullable(String))
merge_companyLowCardinality(String)
new_parentLowCardinality(Nullable(String))
merge_addressLowCardinality(Nullable(String))
merge_cityLowCardinality(Nullable(String))
merge_stateLowCardinality(Nullable(String))
merge_zipLowCardinality(Nullable(String))
stateLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeutility_numberutility_namemerge_datemerge_companynew_parentmerge_addressmerge_citymerge_statemerge_zipstateduplicate_indexreleaseingested_at
2025-01-01 00:00:00.00000013664Norris Public Power District10/01/2024City of Hickman (NE)∅606 IrvingBeatriceNE68310∅0early_release2026-09-29 00:39:33.840421
2025-01-01 00:00:00.00000012647ALLETE, Inc.12/15/2025Alloy Parent LLCAlloy Parent LLC30 West Superior StreetDuluthMN55802∅0early_release2026-09-29 00:39:33.840421
2025-01-01 00:00:00.0000004716Dairyland Power Coop10/31/2025ROCKY ROAD ENERGY CENTERDairyland Power Cooperative1221 POWER DRIVEEAST DUNDEEIL60118∅0early_release2026-09-29 00:39:33.840421

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