Energy Efficiency Programs

EIA-861 energy efficiency: incremental and life-cycle savings and costs of utility efficiency programs, by 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

Energy_Efficiency, 2013 on. Savings in MWh and MW, costs in thousand dollars. 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.

Schema20

Column
Type
event_timeDateTime64(6, 'UTC')
customer_classLowCardinality(String)
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
stateLowCardinality(String)
ba_codeLowCardinality(String)
reporting_year_incremental_annual_savings_energy_savings_mwhNullable(Float64)
reporting_year_incremental_annual_savings_peak_demand_savings_mwNullable(Float64)
incremental_life_cycle_savings_energy_savings_mwhNullable(Float64)
incremental_life_cycle_savings_peak_demand_savings_mwNullable(Float64)
reporting_year_incremental_cost_customer_incentives_thousand_dollarsNullable(Float64)
reporting_year_incremental_cost_all_other_costs_thousand_dollarsNullable(Float64)
incremental_life_cycle_costs_customer_incentives_thousand_dollarsNullable(Float64)
incremental_life_cycle_costs_all_other_costs_thousand_dollarsNullable(Float64)
weighted_average_life_yearsNullable(Float64)
websiteLowCardinality(Nullable(String))
short_formLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecustomer_classutility_numberutility_namestateba_codereporting_year_incremental_annual_savings_energy_savings_mwhreporting_year_incremental_annual_savings_peak_demand_savings_mwincremental_life_cycle_savings_energy_savings_mwhincremental_life_cycle_savings_peak_demand_savings_mwreporting_year_incremental_cost_customer_incentives_thousand_dollarsreporting_year_incremental_cost_all_other_costs_thousand_dollarsincremental_life_cycle_costs_customer_incentives_thousand_dollarsincremental_life_cycle_costs_all_other_costs_thousand_dollarsweighted_average_life_yearswebsiteshort_formduplicate_indexreleaseingested_at
2025-01-01 00:00:00.000000transportation66867David Energy Supply LLCTXERCO∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000total66867David Energy Supply LLCTXERCO380.840.13380.840.1305.75705.757∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000residential66867David Energy Supply LLCTXERCO90.540.0190.540.0103.36303.3631∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000industrial66867David Energy Supply LLCTXERCO∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000commercial66867David Energy Supply LLCTXERCO290.30.12290.30.1202.39402.3941∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000transportation66867David Energy Supply LLCNYNYIS∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000total66867David Energy Supply LLCNYNYIS2682.830.412682.830.41058.254058.254∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000residential66867David Energy Supply LLCNYNYIS∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000industrial66867David Energy Supply LLCNYNYIS∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000commercial66867David Energy Supply LLCNYNYIS2682.830.412682.830.41058.254058.2541∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000transportation66867David Energy Supply LLCNJPJM∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000total66867David Energy Supply LLCNJPJM260.10.1260.10.108.32208.322∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000residential66867David Energy Supply LLCNJPJM∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000industrial66867David Energy Supply LLCNJPJM∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000commercial66867David Energy Supply LLCNJPJM260.10.1260.10.108.32208.3221∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000transportation66867David Energy Supply LLCMAISNE∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000total66867David Energy Supply LLCMAISNE160.10.1160.10.102.39402.394∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000residential66867David Energy Supply LLCMAISNE∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000industrial66867David Energy Supply LLCMAISNE∅∅∅∅∅∅∅∅∅∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000commercial66867David Energy Supply LLCMAISNE160.10.1160.10.102.39402.3941∅∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000transportation60868Redwood Coast Energy AuthorityCACISO000000000https://redwoodenergy.org/programs-rebates/∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000total60868Redwood Coast Energy AuthorityCACISO33.2140.002428.130.00265.32296.4865.32296.48∅https://redwoodenergy.org/programs-rebates/∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000residential60868Redwood Coast Energy AuthorityCACISO33.2140.002428.130.00265.32296.4865.32296.4812.89https://redwoodenergy.org/programs-rebates/∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000industrial60868Redwood Coast Energy AuthorityCACISO000000000https://redwoodenergy.org/programs-rebates/∅0early_release2026-09-29 00:39:33.494544
2025-01-01 00:00:00.000000commercial60868Redwood Coast Energy AuthorityCACISO000000000https://redwoodenergy.org/programs-rebates/∅0early_release2026-09-29 00:39:33.494544

Coverage

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