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
Evidence
Observed market data
Time basis
Point-in-time records
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
Analysis rules
Schema14
Column
Type
event_timeDateTime64(6, 'UTC')utility_numberInt64utility_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_indexInt64releaseLowCardinality(Nullable(String))ingested_atDateTime64(6, 'UTC')Sample data
| event_time | utility_number | utility_name | merge_date | merge_company | new_parent | merge_address | merge_city | merge_state | merge_zip | state | duplicate_index | release | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-01-01 00:00:00.000000 | 13664 | Norris Public Power District | 10/01/2024 | City of Hickman (NE) | ∅ | 606 Irving | Beatrice | NE | 68310 | ∅ | 0 | early_release | 2026-09-29 00:39:33.840421 |
| 2025-01-01 00:00:00.000000 | 12647 | ALLETE, Inc. | 12/15/2025 | Alloy Parent LLC | Alloy Parent LLC | 30 West Superior Street | Duluth | MN | 55802 | ∅ | 0 | early_release | 2026-09-29 00:39:33.840421 |
| 2025-01-01 00:00:00.000000 | 4716 | Dairyland Power Coop | 10/31/2025 | ROCKY ROAD ENERGY CENTER | Dairyland Power Cooperative | 1221 POWER DRIVE | EAST DUNDEE | IL | 60118 | ∅ | 0 | early_release | 2026-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