Non-Net-Metered Distributed Generation

EIA-861 distributed generation not net metered: generator counts and capacity by technology, utility and customer class, 2016 on.

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

Non_Net_Metering_Distributed, the utility-level sheets. Capacity in MW; battery energy in MWh from 2023, when storage became battery. 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.

Schema26

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

Sample data

event_timecustomer_classstateutility_numberutility_nameba_codenumber_and_capacity_mw_number_of_generatorsnumber_and_capacity_mw_total_capacitynumber_and_capacity_mw_capacity_back_up_onlynumber_and_capacity_mw_capacity_utility_ownedphotovoltaic_mw_typephotovoltaic_mwbattery_mwbattery_energy_mwhwind_mwhydroelectric_mwfuel_cells_mwinternal_combustion_mwcombustion_turbine_mwsteam_mwother_mwtotal_mwstorage_mwduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportationWI99999State AdjustmentMISO∅0.747∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000totalWI99999State AdjustmentMISO∅0.747∅∅∅0.747∅∅∅∅∅∅∅∅∅0.747∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000residentialWI99999State AdjustmentMISO∅0.747∅∅∅0.747∅∅∅∅∅∅∅∅∅0.747∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000industrialWI99999State AdjustmentMISO∅0.747∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000direct_connectedWI99999State AdjustmentMISO∅0.747∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000commercialWI99999State AdjustmentMISO∅0.747∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000transportationWA99999State AdjustmentCHPD∅-0.023∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000totalWA99999State AdjustmentCHPD∅-0.023∅∅∅-0.023∅∅∅∅∅∅∅∅∅-0.023∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000residentialWA99999State AdjustmentCHPD∅-0.023∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000industrialWA99999State AdjustmentCHPD∅-0.023∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000direct_connectedWA99999State AdjustmentCHPD∅-0.023∅∅∅-0.023∅∅∅∅∅∅∅∅∅-0.023∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000commercialWA99999State AdjustmentCHPD∅-0.023∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000transportationWA99999State AdjustmentBPAT∅0.509∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000totalWA99999State AdjustmentBPAT∅0.509∅∅∅0.509∅∅∅∅∅∅∅∅∅0.509∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000residentialWA99999State AdjustmentBPAT∅0.509∅∅∅0.534∅∅∅∅∅∅∅∅∅0.534∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000industrialWA99999State AdjustmentBPAT∅0.509∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000direct_connectedWA99999State AdjustmentBPAT∅0.509∅∅∅-0.053∅∅∅∅∅∅∅∅∅-0.053∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000commercialWA99999State AdjustmentBPAT∅0.509∅∅∅0.028∅∅∅∅∅∅∅∅∅0.028∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000transportationUT99999State AdjustmentPACE∅-0.079∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000totalUT99999State AdjustmentPACE∅-0.079∅∅∅-0.079∅∅∅∅∅∅∅∅∅-0.079∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000residentialUT99999State AdjustmentPACE∅-0.079∅∅∅-0.05∅∅∅∅∅∅∅∅∅-0.05∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000industrialUT99999State AdjustmentPACE∅-0.079∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000direct_connectedUT99999State AdjustmentPACE∅-0.079∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000commercialUT99999State AdjustmentPACE∅-0.079∅∅∅-0.03∅∅∅∅∅∅∅∅∅-0.03∅0early_release2026-09-29 00:39:34.676718
2025-01-01 00:00:00.000000transportationTX99999State AdjustmentMISO∅-0.187∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.676718

Coverage

0.3% complete3,279 gap days10 days with data
Show coverage history
Coverage: 0.3%Days with data: 10Gaps: 3,279
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
gaplessmore