Dispersed Generation

EIA-861 dispersed 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

Dispersed sheets of the discontinued distributed_generation file. 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.00000058124City of Winter Park - (FL)FL317.97.92.7E7.9∅∅∅∅∅∅∅7.9E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000058123Aha Macav Power ServiceNV54∅∅E4∅∅∅∅∅∅∅4∅0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000058123Aha Macav Power ServiceCA21.6∅∅E1.6∅∅∅∅∅∅∅1.6∅0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000058123Aha Macav Power ServiceAZ122.1∅∅E2.1∅∅∅∅∅∅∅2.1E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000057105Commonwealth Utility CorporationMP4721.81618.5593.257E21.816∅∅∅∅∅∅∅21.816E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000049826Mohegan Tribal Utility AuthorityCT73.83.8∅A3.8∅∅∅∅∅∅∅3.8A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000027599Carroll-White REMCIN13332E3∅∅∅∅∅∅∅3E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000027422Todd-Wadena Electric CoopMN82.400E2.4∅∅∅∅∅∅∅2.4E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000027316Town of Stowe- (VT)VT205∅∅E5∅∅∅∅∅∅∅5E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000024949Cass County Elec Coop IncND13144.644.6∅A44.6∅∅∅∅∅∅∅44.6A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000024558City of EscanabaMI17330.1A3∅∅∅∅∅∅∅3A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000024211Tucson Electric Power CoAZ11024.924.9∅E2.722.2∅∅∅∅∅∅24.9E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000023826Bluestem Electric Coop IncKS21.0750.1751.075A1.075∅∅∅∅∅∅∅1.075A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000021101Village of Yellow Springs - (OH)OH121∅∅A1∅∅∅∅∅∅∅1A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020996Wright-Hennepin Coop Elec AssnMN176.26.20A6.2∅∅∅∅∅∅∅6.2A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020858WPPI EnergyWI30.70.7∅A0.700000000.7A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020806City of WindomMN112.62.6∅A2.6∅∅∅∅∅∅∅2.6A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020477City of Westerville - (OH)OH6817.49517.4952.56A17.495∅∅∅∅∅∅∅17.495A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020387West Penn Power CompanyPA12541.141.1∅E41.1∅∅∅∅∅∅∅41.1E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020259City of Webster City - (IA)IA411∅E1∅∅∅∅∅∅∅1E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020134City of WarroadMN86.76.7∅∅6.7∅∅∅∅∅∅∅6.7E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000020065Walton Electric Member CorpGA63.63.63.6A3.6∅∅∅∅∅∅∅3.6A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000019981Wake Electric Membership CorpNC63∅∅E3∅∅∅∅∅∅∅3E0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000019947City of Wadena - (MN)MN10.150.150.15A0.15∅∅∅∅∅∅∅0.15A0final2026-09-29 00:38:37.073754
2015-01-01 00:00:00.00000019882Virginia Tech Electric ServiceVA8215.56415.5640.2E15.564∅∅∅∅∅∅∅15.564E0final2026-09-29 00:38:37.073754

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