Non-Net-Metered Distributed Generation by State

EIA-861 distributed generation not net metered, 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 Non_Net_Metering_Distributed. 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.

Schema22

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
stateLowCardinality(String)
number_and_capacity_mw_number_of_generatorsNullable(Float64)
number_and_capacity_mw_total_capacityNullable(Float64)
number_and_capacity_mw_capacity_back_up_onlyNullable(Float64)
number_and_capacity_mw_capacity_utility_ownedNullable(Float64)
data_typeLowCardinality(Nullable(String))
photovoltaic_mwNullable(Float64)
battery_mwNullable(Float64)
battery_energy_mwhNullable(Float64)
wind_mwNullable(Float64)
hydroelectric_mwNullable(Float64)
fuel_cells_mwNullable(Float64)
internal_combustion_mwNullable(Float64)
combustion_turbine_mwNullable(Float64)
steam_mwNullable(Float64)
other_mwNullable(Float64)
total_mwNullable(Float64)
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classstatenumber_and_capacity_mw_number_of_generatorsnumber_and_capacity_mw_total_capacitynumber_and_capacity_mw_capacity_back_up_onlynumber_and_capacity_mw_capacity_utility_owneddata_typephotovoltaic_mwbattery_mwbattery_energy_mwhwind_mwhydroelectric_mwfuel_cells_mwinternal_combustion_mwcombustion_turbine_mwsteam_mwother_mwtotal_mwduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportationWV10.315∅0A∅∅∅∅∅∅∅∅∅000early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000totalWV10.315∅0A0000000000.3150.3150early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000residentialWV10.315∅0A∅∅∅∅∅∅∅∅∅000early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000industrialWV10.315∅0A∅∅∅∅∅∅∅∅∅0.3150.3150early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000direct_connectedWV10.315∅0A∅∅∅∅∅∅∅∅∅000early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000commercialWV10.315∅0A∅∅∅∅∅∅∅∅∅000early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000transportationWI61581.147036.919A∅∅∅∅∅∅∅∅∅∅00early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000totalWI61581.147036.919A32.031.8930.020.40339.8630.4251.4720.0040.4554.60281.1470early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000residentialWI61581.147036.919A1.6810.272∅0.01∅∅∅∅∅∅1.9630early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000industrialWI61581.147036.919A11.7910.336∅0.2950.65∅0.522∅0.4553.45317.5020early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000direct_connectedWI61581.147036.919A0.571∅∅0.0135.687∅∅∅∅∅36.2680early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000commercialWI61581.147036.919A17.9871.2850.020.0883.5260.4250.950.004∅1.14925.4140early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000transportationWA604144.325127.2093.233A∅∅∅∅∅∅∅∅∅∅00early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000totalWA604144.325127.2093.233A11.552.2043.3350.2280.5680129.775000144.3250early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000residentialWA604144.325127.2093.233A0.5541.5582.524∅∅∅∅∅∅∅2.1120early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000industrialWA604144.325127.2093.233A∅∅∅∅∅∅59.5∅∅∅59.50early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000direct_connectedWA604144.325127.2093.233A0.36∅∅∅∅∅∅∅∅∅0.360early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000commercialWA604144.325127.2093.233A10.6360.6460.8110.2280.568∅70.275∅∅∅82.3530early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000transportationVT950463.26749.4587.297A∅∅∅∅∅∅∅∅∅∅00early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000totalVT950463.26749.4587.297A3.61349.5190.1570.0484.75705.3300063.2670early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000residentialVT950463.26749.4587.297A∅49.4890.081∅∅∅∅∅∅∅49.4890early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000industrialVT950463.26749.4587.297A∅∅∅∅∅∅∅∅∅∅00early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000direct_connectedVT950463.26749.4587.297A2.64∅∅0.0484.757∅5.33∅∅∅12.7750early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000commercialVT950463.26749.4587.297A0.9730.030.076∅∅∅∅∅∅∅1.0030early_release2026-09-29 00:39:34.836536
2025-01-01 00:00:00.000000transportationVA9016.691.8557.578A0∅∅000000000early_release2026-09-29 00:39:34.836536

Coverage

0.4% complete729 gap days3 days with data
Show coverage history
Coverage: 0.4%Days with data: 3Gaps: 729
2025
2024
2023
gaplessmore