Net Metering

EIA-861 net metering: net-metered capacity, installations and energy sold back by technology, 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

Net_Metering, the utility-level sheets. Columns follow EIA's own labels across its renames: customers counts run to 2020 and installations from 2021, storage paired with PV is photovoltaic_storage_* to 2022 and battery_* from 2023, and 2012 counted meters. Capacity in MW, energy in MWh. 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.

Schema46

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
stateLowCardinality(String)
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
ba_codeLowCardinality(String)
photovoltaic_capacity_mw_typeLowCardinality(Nullable(String))
photovoltaic_capacity_mwNullable(Float64)
photovoltaic_installationsNullable(Float64)
photovoltaic_energy_sold_back_mwhNullable(Float64)
photovoltaic_virtual_capacity_1_mw_and_over_mwNullable(Float64)
photovoltaic_virtual_customers_1_mw_and_overNullable(Float64)
photovoltaic_virtual_capacity_under_1_mw_mwNullable(Float64)
photovoltaic_virtual_customers_under_1_mwNullable(Float64)
battery_pv_paired_battery_capacity_mwNullable(Float64)
battery_pv_paired_installationsNullable(Float64)
battery_pv_paired_energy_capacity_mwhNullable(Float64)
battery_not_pv_paired_battery_capacity_mwNullable(Float64)
battery_not_pv_paired_installationsNullable(Float64)
battery_not_pv_paired_energy_capacity_mwhNullable(Float64)
wind_capacity_mwNullable(Float64)
wind_installationsNullable(Float64)
wind_energy_sold_back_mwhNullable(Float64)
other_capacity_mwNullable(Float64)
other_installationsNullable(Float64)
other_energy_sold_back_mwhNullable(Float64)
all_technologies_capacity_mwNullable(Float64)
all_technologies_installationsNullable(Float64)
all_technologies_energy_sold_back_mwhNullable(Float64)
photovoltaic_storage_capacity_mwNullable(Float64)
photovoltaic_storage_installationsNullable(Float64)
photovoltaic_virtual_capacity_mwNullable(Float64)
photovoltaic_virtual_customersNullable(Float64)
photovoltaic_customersNullable(Float64)
photovoltaic_storage_customersNullable(Float64)
wind_customersNullable(Float64)
other_customersNullable(Float64)
all_technologies_customersNullable(Float64)
short_formLowCardinality(Nullable(String))
photovoltaic_number_of_metersNullable(Float64)
wind_number_of_metersNullable(Float64)
other_number_of_metersNullable(Float64)
total_number_of_metersNullable(Float64)
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classstateutility_numberutility_nameba_codephotovoltaic_capacity_mw_typephotovoltaic_capacity_mwphotovoltaic_installationsphotovoltaic_energy_sold_back_mwhphotovoltaic_virtual_capacity_1_mw_and_over_mwphotovoltaic_virtual_customers_1_mw_and_overphotovoltaic_virtual_capacity_under_1_mw_mwphotovoltaic_virtual_customers_under_1_mwbattery_pv_paired_battery_capacity_mwbattery_pv_paired_installationsbattery_pv_paired_energy_capacity_mwhbattery_not_pv_paired_battery_capacity_mwbattery_not_pv_paired_installationsbattery_not_pv_paired_energy_capacity_mwhwind_capacity_mwwind_installationswind_energy_sold_back_mwhother_capacity_mwother_installationsother_energy_sold_back_mwhall_technologies_capacity_mwall_technologies_installationsall_technologies_energy_sold_back_mwhphotovoltaic_storage_capacity_mwphotovoltaic_storage_installationsphotovoltaic_virtual_capacity_mwphotovoltaic_virtual_customersphotovoltaic_customersphotovoltaic_storage_customerswind_customersother_customersall_technologies_customersshort_formphotovoltaic_number_of_meterswind_number_of_metersother_number_of_meterstotal_number_of_metersduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportationWY99999State AdjustmentWACM∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000totalWY99999State AdjustmentWACM∅0.488∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.488∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000residentialWY99999State AdjustmentWACM∅0.284∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.284∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000industrialWY99999State AdjustmentWACM∅0.042∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.042∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000commercialWY99999State AdjustmentWACM∅0.162∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.162∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000transportationWY99999State AdjustmentNWMT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000totalWY99999State AdjustmentNWMT∅0.289∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.289∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000residentialWY99999State AdjustmentNWMT∅0.289∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.289∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000industrialWY99999State AdjustmentNWMT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000commercialWY99999State AdjustmentNWMT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000transportationWV99999State AdjustmentPJM∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000totalWV99999State AdjustmentPJM∅0.063∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.063∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000residentialWV99999State AdjustmentPJM∅0.063∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0.063∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000industrialWV99999State AdjustmentPJM∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000commercialWV99999State AdjustmentPJM∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000transportationWI99999State AdjustmentMISO∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000totalWI99999State AdjustmentMISO∅1.719∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅1.719∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000residentialWI99999State AdjustmentMISO∅2.864∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅2.864∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000industrialWI99999State AdjustmentMISO∅-0.207∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅-0.207∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000commercialWI99999State AdjustmentMISO∅-0.939∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅-0.939∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000transportationWA99999State AdjustmentSCL∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000totalWA99999State AdjustmentSCL∅-13.027∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅-13.027∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000residentialWA99999State AdjustmentSCL∅-11.207∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅-11.207∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000industrialWA99999State AdjustmentSCL∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727
2025-01-01 00:00:00.000000commercialWA99999State AdjustmentSCL∅-1.82∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅-1.82∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.002727

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