Net Metering by State

EIA-861 net metering state totals, by technology and customer class, 2023 on.

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

The State Level sheet of Net_Metering, as EIA totals it. 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, state, customer_class, duplicate_index) before aggregating.

Analysis rules

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

Schema28

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
stateLowCardinality(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)
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classstatephotovoltaic_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_mwhduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportationWY00∅∅∅∅∅∅∅∅∅∅∅00∅∅∅∅0000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000totalWY7.85916000000.4433700000.1615000.258208.26996800early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000residentialWY6.481849∅∅∅∅∅0.44337∅∅∅∅0.09540∅0.0181∅6.59489000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000industrialWY0.38619∅∅∅∅∅∅∅∅∅∅∅0.0062∅∅∅∅0.3922100early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000commercialWY0.98348∅∅∅∅∅∅∅∅∅∅∅0.068∅0.241∅1.2835700early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000transportationWV00000000000000000000000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000totalWV39.823358416258.84003.8251744.3675124.3870000.093243.05500043.741378216261.8950early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000residentialWV30.435336913173.39001.196994.265014.3440000.078213.05500031.709348913176.4450early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000industrialWV1.5839303.651000.25120000000000001.83411303.6510early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000commercialWV7.8052062781.799002.378730.107110.0430000.0153000010.1982822781.7990early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000transportationWI0000000∅∅∅∅∅∅0000000000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000totalWI259.51231425588.41131480.428512.5938210.2890.0210.022.75516922.72964.875570330.54238015611.140early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000residentialWI152.684208383102.5560.305990.428510.6148000.289∅∅∅1.4412322.7290.06540154.894213493125.2850early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000industrialWI11.611992100.60300000.0131∅∅∅∅0.21041.0111052.8211112100.6030early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000commercialWI95.2142205385.2522.69549001.96620∅0.0210.021.11545023.8420122.8242341385.2520early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000transportationWA00000000000000000000000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000totalWA427.5865339333570.709001.944239034.867340060.9270.350.4830.212599.1210.5563343.775430.2985587533623.6050early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000residentialWA373.4835101530773.774001.682224633.514331758.740.0540.1110.177459.1210.2462222.2375.5885332830805.0950early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000industrialWA0.73113000000000000000.014100.7451400early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000commercialWA53.37123652796.935000.2621441.353832.1870.2510.3720.0351400.2961021.57553.96425332818.510early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000transportationVT00∅∅∅00∅∅∅∅∅∅00∅00∅0000early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000totalVT182.543100535496.7860015.4243150000000.4374901.427600199.831104775496.7860early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000residentialVT114.26293991266.975∅∅2.334178∅∅∅∅∅∅0.35643∅0.92556∅117.87796761266.9750early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000industrialVT1.3875∅∅∅00∅∅∅∅∅∅00∅00∅1.387500early_release2026-09-29 00:39:34.182168
2025-01-01 00:00:00.000000commercialVT66.8946494229.811∅∅13.09137∅∅∅∅∅∅0.0816∅0.5024∅80.5677964229.8110early_release2026-09-29 00:39:34.182168

Coverage

0.3% complete730 gap days2 days with data
Show coverage history
Coverage: 0.3%Days with data: 2Gaps: 730
2025
2024
2023
gaplessmore