Advanced Meters

EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class.

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

Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. 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, ba_code, customer_class, duplicate_index) before aggregating.

Analysis rules

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

Schema19

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
ownershipLowCardinality(Nullable(String))
short_formLowCardinality(Nullable(String))
stateLowCardinality(String)
ba_codeLowCardinality(String)
number_amr_automated_meter_readingNullable(Float64)
number_ami_advanced_metering_infrastructureNullable(Float64)
number_home_area_networkNullable(Float64)
number_standard_non_amr_ami_metersNullable(Float64)
total_numbers_of_metersNullable(Float64)
energy_served_ami_mwhNullable(Float64)
customers_with_daily_digital_accessNullable(Float64)
customers_with_direct_load_controlNullable(Float64)
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classutility_numberutility_nameownershipshort_formstateba_codenumber_amr_automated_meter_readingnumber_ami_advanced_metering_infrastructurenumber_home_area_networknumber_standard_non_amr_ami_meterstotal_numbers_of_metersenergy_served_ami_mwhcustomers_with_daily_digital_accesscustomers_with_direct_load_controlduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportation66073MPD Electric CooperativeCooperative∅SCSC∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000total66073MPD Electric CooperativeCooperative∅SCSC∅38896∅938905968853∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000residential66073MPD Electric CooperativeCooperative∅SCSC∅32130∅∅32130505875∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000industrial66073MPD Electric CooperativeCooperative∅SCSC∅16∅723325670∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000commercial66073MPD Electric CooperativeCooperative∅SCSC∅6750∅26752137308∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000transportation66052Kirkwood Meadows PUDPolitical SubdivisionYCACISO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000total66052Kirkwood Meadows PUDPolitical SubdivisionYCACISO740∅∅∅740∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000residential66052Kirkwood Meadows PUDPolitical SubdivisionYCACISO625∅∅∅625∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000industrial66052Kirkwood Meadows PUDPolitical SubdivisionYCACISO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000commercial66052Kirkwood Meadows PUDPolitical SubdivisionYCACISO115∅∅∅115∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000transportation65353Arrow Energy TX LLCRetail Power Marketer∅TXERCO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000total65353Arrow Energy TX LLCRetail Power Marketer∅TXERCO000000000early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000residential65353Arrow Energy TX LLCRetail Power Marketer∅TXERCO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000industrial65353Arrow Energy TX LLCRetail Power Marketer∅TXERCO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000commercial65353Arrow Energy TX LLCRetail Power Marketer∅TXERCO∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000transportation65261Gila River Indian Utility Authority (GRICUA)Cooperative∅AZWALC000000000early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000total65261Gila River Indian Utility Authority (GRICUA)Cooperative∅AZWALC03466003466279168346600early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000residential65261Gila River Indian Utility Authority (GRICUA)Cooperative∅AZWALC0270700270745850270700early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000industrial65261Gila River Indian Utility Authority (GRICUA)Cooperative∅AZWALC000000000early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000commercial65261Gila River Indian Utility Authority (GRICUA)Cooperative∅AZWALC07590075923331875900early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000transportation632864 Rivers Electric Cooperative, Inc.CooperativeYKSSWPP∅∅∅∅0∅∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000total632864 Rivers Electric Cooperative, Inc.CooperativeYKSSWPP∅12295∅∅12295156277∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000residential632864 Rivers Electric Cooperative, Inc.CooperativeYKSSWPP∅8709∅∅8709104078∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000industrial632864 Rivers Electric Cooperative, Inc.CooperativeYKSSWPP∅4∅∅42985∅∅0early_release2026-09-29 00:39:36.509148
2025-01-01 00:00:00.000000commercial632864 Rivers Electric Cooperative, Inc.CooperativeYKSSWPP∅3582∅∅358249214∅∅0early_release2026-09-29 00:39:36.509148

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