Net Metering, Third-Party Owned

EIA-861 third-party-owned net metering: PV capacity and installations owned by third parties, by owner, state and customer class.

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

The TPO sheets of Net_Metering, 2014 on. 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.

Schema16

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

Sample data

event_timecustomer_classstateutility_numberutility_nameba_codephotovoltaic_capacity_mw_typephotovoltaic_capacity_mwphotovoltaic_installationsbattery_pv_paired_battery_capacity_mwbattery_pv_paired_installationsbattery_pv_paired_energy_capacity_mwhphotovoltaic_customersduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportationPA99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000totalPA99999State AdjustmentPJM∅-0.005∅0∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000residentialPA99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000industrialPA99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000commercialPA99999State AdjustmentPJM∅-0.005∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000transportationOR99999State AdjustmentPACW∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000totalOR99999State AdjustmentPACW∅-0.121∅0∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000residentialOR99999State AdjustmentPACW∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000industrialOR99999State AdjustmentPACW∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000commercialOR99999State AdjustmentPACW∅-0.121∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000transportationNJ99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000totalNJ99999State AdjustmentPJM∅-0.422∅0∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000residentialNJ99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000industrialNJ99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000commercialNJ99999State AdjustmentPJM∅-0.422∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000transportationDE99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000totalDE99999State AdjustmentPJM∅-0.004∅0∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000residentialDE99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000industrialDE99999State AdjustmentPJM∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000commercialDE99999State AdjustmentPJM∅-0.004∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000transportationCO99999State AdjustmentPSCO∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000totalCO99999State AdjustmentPSCO∅-0.391∅0∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000residentialCO99999State AdjustmentPSCO∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000industrialCO99999State AdjustmentPSCO∅∅∅∅∅∅∅0early_release2026-09-29 00:39:34.348841
2025-01-01 00:00:00.000000commercialCO99999State AdjustmentPSCO∅-0.391∅∅∅∅∅0early_release2026-09-29 00:39:34.348841

Coverage

0.3% complete4,007 gap days12 days with data
Show coverage history
Coverage: 0.3%Days with data: 12Gaps: 4,007
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
gaplessmore