Net Metering, Third-Party Owned Totals

EIA-861 third-party-owned net metering national totals per owner, 2023 on.

Native record
event_time x utility_number 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 TPO Total sheet of Net_Metering. 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, customer_class, duplicate_index) before aggregating.

Analysis rules

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

Schema13

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
photovoltaic_capacity_mwNullable(Float64)
photovoltaic_installationsNullable(Float64)
battery_pv_paired_battery_capacity_mwNullable(Float64)
battery_pv_paired_installationsNullable(Float64)
battery_pv_paired_energy_capacity_mwhNullable(Float64)
photovoltaic_capacity_mw_typeLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classutility_numberutility_namephotovoltaic_capacity_mwphotovoltaic_installationsbattery_pv_paired_battery_capacity_mwbattery_pv_paired_installationsbattery_pv_paired_energy_capacity_mwhphotovoltaic_capacity_mw_typeduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportation65242Scale Sustainable I, LLC∅∅∅∅∅∅0early_release2026-09-29 00:39:34.517182
2025-01-01 00:00:00.000000total65242Scale Sustainable I, LLC5.52216000∅0early_release2026-09-29 00:39:34.517182
2025-01-01 00:00:00.000000residential65242Scale Sustainable I, LLC∅∅∅∅∅∅0early_release2026-09-29 00:39:34.517182
2025-01-01 00:00:00.000000industrial65242Scale Sustainable I, LLC∅∅∅∅∅∅0early_release2026-09-29 00:39:34.517182
2025-01-01 00:00:00.000000commercial65242Scale Sustainable I, LLC5.52216∅∅∅∅0early_release2026-09-29 00:39:34.517182

Coverage

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