Advanced Meters
EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class.
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
Analysis rules
Schema19
event_timeDateTime64(6, 'UTC')customer_classLowCardinality(String)utility_numberInt64utility_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_indexInt64releaseLowCardinality(Nullable(String))ingested_atDateTime64(6, 'UTC')Sample data
| event_time | customer_class | utility_number | utility_name | ownership | short_form | state | ba_code | number_amr_automated_meter_reading | number_ami_advanced_metering_infrastructure | number_home_area_network | number_standard_non_amr_ami_meters | total_numbers_of_meters | energy_served_ami_mwh | customers_with_daily_digital_access | customers_with_direct_load_control | duplicate_index | release | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-01-01 00:00:00.000000 | transportation | 66073 | MPD Electric Cooperative | Cooperative | ∅ | SC | SC | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | total | 66073 | MPD Electric Cooperative | Cooperative | ∅ | SC | SC | ∅ | 38896 | ∅ | 9 | 38905 | 968853 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | residential | 66073 | MPD Electric Cooperative | Cooperative | ∅ | SC | SC | ∅ | 32130 | ∅ | ∅ | 32130 | 505875 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | industrial | 66073 | MPD Electric Cooperative | Cooperative | ∅ | SC | SC | ∅ | 16 | ∅ | 7 | 23 | 325670 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | commercial | 66073 | MPD Electric Cooperative | Cooperative | ∅ | SC | SC | ∅ | 6750 | ∅ | 2 | 6752 | 137308 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | transportation | 66052 | Kirkwood Meadows PUD | Political Subdivision | Y | CA | CISO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | total | 66052 | Kirkwood Meadows PUD | Political Subdivision | Y | CA | CISO | 740 | ∅ | ∅ | ∅ | 740 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | residential | 66052 | Kirkwood Meadows PUD | Political Subdivision | Y | CA | CISO | 625 | ∅ | ∅ | ∅ | 625 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | industrial | 66052 | Kirkwood Meadows PUD | Political Subdivision | Y | CA | CISO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | commercial | 66052 | Kirkwood Meadows PUD | Political Subdivision | Y | CA | CISO | 115 | ∅ | ∅ | ∅ | 115 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | transportation | 65353 | Arrow Energy TX LLC | Retail Power Marketer | ∅ | TX | ERCO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | total | 65353 | Arrow Energy TX LLC | Retail Power Marketer | ∅ | TX | ERCO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | residential | 65353 | Arrow Energy TX LLC | Retail Power Marketer | ∅ | TX | ERCO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | industrial | 65353 | Arrow Energy TX LLC | Retail Power Marketer | ∅ | TX | ERCO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | commercial | 65353 | Arrow Energy TX LLC | Retail Power Marketer | ∅ | TX | ERCO | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | transportation | 65261 | Gila River Indian Utility Authority (GRICUA) | Cooperative | ∅ | AZ | WALC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | total | 65261 | Gila River Indian Utility Authority (GRICUA) | Cooperative | ∅ | AZ | WALC | 0 | 3466 | 0 | 0 | 3466 | 279168 | 3466 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | residential | 65261 | Gila River Indian Utility Authority (GRICUA) | Cooperative | ∅ | AZ | WALC | 0 | 2707 | 0 | 0 | 2707 | 45850 | 2707 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | industrial | 65261 | Gila River Indian Utility Authority (GRICUA) | Cooperative | ∅ | AZ | WALC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | commercial | 65261 | Gila River Indian Utility Authority (GRICUA) | Cooperative | ∅ | AZ | WALC | 0 | 759 | 0 | 0 | 759 | 233318 | 759 | 0 | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | transportation | 63286 | 4 Rivers Electric Cooperative, Inc. | Cooperative | Y | KS | SWPP | ∅ | ∅ | ∅ | ∅ | 0 | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | total | 63286 | 4 Rivers Electric Cooperative, Inc. | Cooperative | Y | KS | SWPP | ∅ | 12295 | ∅ | ∅ | 12295 | 156277 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | residential | 63286 | 4 Rivers Electric Cooperative, Inc. | Cooperative | Y | KS | SWPP | ∅ | 8709 | ∅ | ∅ | 8709 | 104078 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | industrial | 63286 | 4 Rivers Electric Cooperative, Inc. | Cooperative | Y | KS | SWPP | ∅ | 4 | ∅ | ∅ | 4 | 2985 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |
| 2025-01-01 00:00:00.000000 | commercial | 63286 | 4 Rivers Electric Cooperative, Inc. | Cooperative | Y | KS | SWPP | ∅ | 3582 | ∅ | ∅ | 3582 | 49214 | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:36.509148 |