Net Metering
EIA-861 net metering: net-metered capacity, installations and energy sold back by technology, utility and customer class.
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
Analysis rules
Schema46
event_timeDateTime64(6, 'UTC')customer_classLowCardinality(String)stateLowCardinality(String)utility_numberInt64utility_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_indexInt64releaseLowCardinality(Nullable(String))ingested_atDateTime64(6, 'UTC')Sample data
| event_time | customer_class | state | utility_number | utility_name | ba_code | photovoltaic_capacity_mw_type | photovoltaic_capacity_mw | photovoltaic_installations | photovoltaic_energy_sold_back_mwh | photovoltaic_virtual_capacity_1_mw_and_over_mw | photovoltaic_virtual_customers_1_mw_and_over | photovoltaic_virtual_capacity_under_1_mw_mw | photovoltaic_virtual_customers_under_1_mw | battery_pv_paired_battery_capacity_mw | battery_pv_paired_installations | battery_pv_paired_energy_capacity_mwh | battery_not_pv_paired_battery_capacity_mw | battery_not_pv_paired_installations | battery_not_pv_paired_energy_capacity_mwh | wind_capacity_mw | wind_installations | wind_energy_sold_back_mwh | other_capacity_mw | other_installations | other_energy_sold_back_mwh | all_technologies_capacity_mw | all_technologies_installations | all_technologies_energy_sold_back_mwh | photovoltaic_storage_capacity_mw | photovoltaic_storage_installations | photovoltaic_virtual_capacity_mw | photovoltaic_virtual_customers | photovoltaic_customers | photovoltaic_storage_customers | wind_customers | other_customers | all_technologies_customers | short_form | photovoltaic_number_of_meters | wind_number_of_meters | other_number_of_meters | total_number_of_meters | duplicate_index | release | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-01-01 00:00:00.000000 | transportation | WY | 99999 | State Adjustment | WACM | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | total | WY | 99999 | State Adjustment | WACM | ∅ | 0.488 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.488 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | residential | WY | 99999 | State Adjustment | WACM | ∅ | 0.284 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.284 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | industrial | WY | 99999 | State Adjustment | WACM | ∅ | 0.042 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.042 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | commercial | WY | 99999 | State Adjustment | WACM | ∅ | 0.162 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.162 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | transportation | WY | 99999 | State Adjustment | NWMT | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | total | WY | 99999 | State Adjustment | NWMT | ∅ | 0.289 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.289 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | residential | WY | 99999 | State Adjustment | NWMT | ∅ | 0.289 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.289 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | industrial | WY | 99999 | State Adjustment | NWMT | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | commercial | WY | 99999 | State Adjustment | NWMT | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | transportation | WV | 99999 | State Adjustment | PJM | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | total | WV | 99999 | State Adjustment | PJM | ∅ | 0.063 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.063 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | residential | WV | 99999 | State Adjustment | PJM | ∅ | 0.063 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0.063 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | industrial | WV | 99999 | State Adjustment | PJM | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | commercial | WV | 99999 | State Adjustment | PJM | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | transportation | WI | 99999 | State Adjustment | MISO | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | total | WI | 99999 | State Adjustment | MISO | ∅ | 1.719 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 1.719 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | residential | WI | 99999 | State Adjustment | MISO | ∅ | 2.864 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 2.864 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | industrial | WI | 99999 | State Adjustment | MISO | ∅ | -0.207 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | -0.207 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | commercial | WI | 99999 | State Adjustment | MISO | ∅ | -0.939 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | -0.939 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | transportation | WA | 99999 | State Adjustment | SCL | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | total | WA | 99999 | State Adjustment | SCL | ∅ | -13.027 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | -13.027 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | residential | WA | 99999 | State Adjustment | SCL | ∅ | -11.207 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | -11.207 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | industrial | WA | 99999 | State Adjustment | SCL | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |
| 2025-01-01 00:00:00.000000 | commercial | WA | 99999 | State Adjustment | SCL | ∅ | -1.82 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | -1.82 | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | ∅ | 0 | early_release | 2026-09-29 00:39:34.002727 |