Distributed Generation

EIA-861 distributed generation capacity by technology and utility, 2012 to 2015.

Native record
event_time x utility_number x state 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

Distributed sheets of the discontinued distributed_generation file, succeeded by net_metering and non_net_metering_distributed. 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, duplicate_index) before aggregating.

Analysis rules

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

Schema22

Column
Type
event_timeDateTime64(6, 'UTC')
utility_numberInt64
utility_nameLowCardinality(Nullable(String))
stateLowCardinality(String)
number_and_capacity_number_of_generatorsNullable(Float64)
number_and_capacity_total_capacity_in_mwsNullable(Float64)
number_and_capacity_capacity_back_up_onlyNullable(Float64)
number_and_capacity_capacity_utility_ownedNullable(Float64)
number_and_capacity_estimated_or_actual_dataLowCardinality(Nullable(String))
capacity_by_technology_type_mw_internal_combustion_engineNullable(Float64)
capacity_by_technology_type_mw_combusiton_turbineNullable(Float64)
capacity_by_technology_type_mw_steam_turbineNullable(Float64)
capacity_by_technology_type_mw_hydroelectricNullable(Float64)
capacity_by_technology_type_mw_windNullable(Float64)
capacity_by_technology_type_mw_photovoltaicNullable(Float64)
capacity_by_technology_type_mw_storageNullable(Float64)
capacity_by_technology_type_mw_otherNullable(Float64)
capacity_by_technology_type_mw_totalNullable(Float64)
capacity_by_technology_type_mw_estimated_or_actual_dataLowCardinality(Nullable(String))
duplicate_indexInt64
releaseLowCardinality(Nullable(String))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeutility_numberutility_namestatenumber_and_capacity_number_of_generatorsnumber_and_capacity_total_capacity_in_mwsnumber_and_capacity_capacity_back_up_onlynumber_and_capacity_capacity_utility_ownednumber_and_capacity_estimated_or_actual_datacapacity_by_technology_type_mw_internal_combustion_enginecapacity_by_technology_type_mw_combusiton_turbinecapacity_by_technology_type_mw_steam_turbinecapacity_by_technology_type_mw_hydroelectriccapacity_by_technology_type_mw_windcapacity_by_technology_type_mw_photovoltaiccapacity_by_technology_type_mw_storagecapacity_by_technology_type_mw_othercapacity_by_technology_type_mw_totalcapacity_by_technology_type_mw_estimated_or_actual_dataduplicate_indexreleaseingested_at
2015-01-01 00:00:00.00000059505Heartland REMCIN90.056∅∅E∅∅∅∅0.0060.05∅∅0.056E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000056697Ameren Illinois CompanyIL594.8∅∅E∅∅∅2.52.3∅∅∅4.8E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000054913NSTAR Electric CompanyMA13023.813∅∅A23.538∅0.0750.2∅∅∅∅23.813A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000049986Southwest Iowa Rural Elec CoopIA10.007∅∅A∅∅∅∅∅0.007∅∅0.007A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000044372Oncor Electric Delivery Company LLCTX2010.910.90A10.80.100000010.9A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040441Town of Murphy - (NC)NC40.0400A000000.04000.04A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040437Emerald People's Utility DistOR40.4∅∅A∅∅∅∅∅0.1∅0.30.4A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040429American Samoa Power AuthorityAS21.972∅1.972A∅∅∅∅∅1.972∅∅1.972A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040305Hickman-Fulton Counties RECCTN10.0100A000000.01000.01A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040305Hickman-Fulton Counties RECCKY150.13400A000000.134000.134A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040303Monroe County Elec Power AssnMS20.02200A000000.022000.022A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040302North East Mississippi EPAMS40.01800A000000.018000.018A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040236Forked Deer Electric Coop, IncTN30.00500A00000.0010.004000.005A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040228Rappahannock Electric CoopVA32.40.80E0.8∅∅1.6∅∅∅∅2.4E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000040166Chickasaw Electric Coop, IncTN80.07400A000000.074000.074A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000027599Carroll-White REMCIN10.80.8∅A0.8∅∅∅∅∅∅∅0.8∅0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000027316Town of Stowe- (VT)VT21∅∅A1∅∅∅∅∅∅∅1A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000026765Pella Cooperative Elec AssnIA100.192∅∅A∅∅∅∅∅0.192∅∅0.192A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000024949Cass County Elec Coop IncND10.9∅∅A0.9∅∅∅∅∅∅∅0.9A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000024889Brunswick Electric Member CorpNC1101.2∅0.03E∅∅∅∅∅1.015∅0.1851.2E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000024590Unitil Energy SystemsNH3283.2∅∅A0.10.6∅∅0.32.2∅∅3.2A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000024558City of EscanabaMI30.200∅∅∅∅∅0.10.1∅∅0.2E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000024211Tucson Electric Power CoAZ81.81.80E0.21.6∅∅∅∅∅∅1.8E0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000023826Bluestem Electric Coop IncKS40.3∅∅A∅∅∅∅0.3∅∅∅0.3A0final2026-09-29 00:38:36.895102
2015-01-01 00:00:00.00000022500Westar Energy IncKS331.01200E00000.050.962001.012E0final2026-09-29 00:38:36.895102

Coverage

0.4% complete1,093 gap days4 days with data
Show coverage history
Coverage: 0.4%Days with data: 4Gaps: 1,093
2015
2014
2013
2012
gaplessmore