SHAREABLE eia-112-utility-workbook MAKE A COPY TO EDIT.xlsx

	A	B	C
1	2024 EIA-112 Utility-Level Residential Disconnections — Consolidated Workbook
2	Energy Equity Project
3	in collaboration with Shelby Green and Jonathan Kim at Energy and Policy Institute
4	Generated: July 06, 2026
5
6	Single-workbook consolidation of all utility-level EIA Form 112 pipeline outputs. Each data sheet is a complete, analysis-ready dataset. The three source CSVs written to Cleaned_Data/eia/112/ remain the machine-readable source of truth and continue to be synced to S3. This workbook does not replace them.
7
8	SHEET INDEX
9
10	Sheet Name	Rows (approx.)	Description
11	Utility Annual	~2,148	Annual utility-level summary for 2024, enriched with ownership, disconnection-intensity rates, and percentile rankings. 19 columns.
12	Utility Monthly	~25,956	Monthly utility-level disconnection activity for 2024 (long format: one row per utility x fuel x month). Excludes State Adjustment rows. 9 columns.
13	State Adjustments	~1,224	Monthly State Adjustment rows isolated from the monthly output. EIA estimation values accounting for nonresponse and data-quality resolutions. Not real utilities. 9 columns.
14	Bad Data Flags	145	Rows EEP flagged as having bad or incomplete 2024 reporting. Retained in the annual output but excluded from percentile benchmarks. Same 19-column schema as Utility Annual.
15	Bad Data Monthly	~1,740	Monthly disconnection activity (long format) for the 145 bad-data-flagged utility-fuel combos only. Same 9-column schema as Utility Monthly; a filtered view for reviewing flagged utilities month by month.
16
17	DATA SOURCES & CITATIONS
18
19	1. EIA Form 112 — Residential Utility Disconnections Survey, 2024 (primary input)
20	First reporting year. OMB approval October 2024; data collection February–December 2025;
21	EIA processing completed February 2026. Two utility-level workbooks (electric + gas),
22	each with five metric sheets (Final notices, Disconnections, Reconnections, Number of
23	customers, About). Utility-level files carry no Q/R quality flags.
24	URL: https://www.eia.gov/analysis/requests/residential/utility/
25
26	2. EIA Form 861 — Annual Electric Power Industry Report (ownership lookup)
27	Source: Cleaned_Data/eia/861/DD-MM-YYYY-eia-861-sales.csv (2024 data, electric service only).
28	Provides ownership classification for the ownership / ownership_source columns.
29	Covers ~89% of electric utilities; ~7% of gas utilities (combined-service utilities only).
30
31	3. EEP manual ownership overrides (data/eia-112-manual-ownership-overrides.csv)
32	EEP-determined ownership classifications for ~988 utilities (134 electric + 854 gas)
33	that EIA-861 could not classify. Assigned by EEP team manual research, May 2026.
34	Recorded in the output as ownership_source = 'eep_determined'.
35
36	4. EEP bad-data flags (data/eia-112-manual-bad-data-flags.csv)
37	145 utility-year rows EEP identified as having bad or incomplete 2024 reporting.
38	Flagged rows are retained in the annual output but receive NA for all three
39	shutoff_rate_*_percentile columns so bad reporting does not distort benchmarks.
40
41	5. EIA 2024 Residential Utility Disconnections Report (April 2026)
42	National and state aggregate report. Cleaned separately in eep-pipeline-core;
43	not included in this workbook.
44
45	COLUMN DICTIONARIES
46
47	Utility Annual — DD-MM-YYYY-eia-112-utility-annual.csv (19 columns)
48
49	Column	Type	Description
50	state	character	2-character state abbreviation
51	utility_name	character	EIA-reported utility name (as-is from source)
52	energy_type	character	'electric' or 'gas'
53	year	integer	Reporting year (2024)
54	ownership	character	Ownership class (EIA-861 or EEP-determined); NA only if both sources lack a classification
55	ownership_source	character	'eia_861' where ownership came from EIA-861 join; 'eep_determined' where filled by EEP manual review; NA if unassigned
56	parent	character	EEP-identified parent company name (~136 utilities); NA otherwise
57	customer_count	numeric	12-month average residential customer count (rate denominator, not a cumulative sum)
58	shutoffs	numeric	Annual sum of residential disconnections
59	reconnections	numeric	Annual sum of residential reconnections
60	final_notices	numeric	Annual sum of final notices sent
61	shutoff_rate	numeric	shutoffs / customer_count; NA when customer_count <= 0
62	reconnection_rate	numeric	reconnections / shutoffs; NA when shutoffs <= 0 (not Inf)
63	final_notice_rate	numeric	final_notices / customer_count; NA when customer_count <= 0
64	shutoff_rate_national_percentile	numeric	percent_rank(shutoff_rate) within energy_type; 0-1 fraction; NA for bad_data_flag='Y', NA shutoff_rate, or n=1 peer group
65	shutoff_rate_state_percentile	numeric	percent_rank(shutoff_rate) within (energy_type, state); 0-1 fraction; NA for bad_data_flag='Y', NA shutoff_rate, or n=1 peer group
66	shutoff_rate_ownership_percentile	numeric	percent_rank(shutoff_rate) within (energy_type, ownership); 0-1 fraction; NA for bad_data_flag='Y', NA shutoff_rate, or n=1 peer group
67	bad_data_flag	character	'Y' for 145 EEP-flagged rows (bad/incomplete reporting); NA otherwise
68	data_quality_note	character	Algorithmically derived note: 'customer_count missing'; 'all activity metrics zero'; 'shutoff_rate exceeds 1 (shutoffs > customers)'; 'final notices but zero shutoffs'; NA where no rule applies
69
70	Utility Monthly — DD-MM-YYYY-eia-112-utility-shutoffs.csv filtered to utility_name != 'State Adjustment' (9 columns)
71
72	Column	Type	Description
73	state	character	2-character state abbreviation
74	utility_name	character	EIA-reported utility name (as-is from source)
75	energy_type	character	'electric' or 'gas'
76	year	integer	Reporting year (2024)
77	month	integer	Month number (1-12)
78	shutoffs	numeric	Residential disconnections (Disconnections sheet)
79	reconnections	numeric	Residential reconnections (Reconnections sheet)
80	final_notices	numeric	Final notices sent to residential customers (Final notices sheet)
81	customer_count	numeric	Total residential customers (Number of customers sheet)
82
83	State Adjustments — DD-MM-YYYY-eia-112-utility-shutoffs.csv filtered to utility_name == 'State Adjustment' (9 columns)
84
85	Column	Type	Description
86	state	character	2-character state abbreviation
87	utility_name	character	EIA-reported utility name (as-is from source)
88	energy_type	character	'electric' or 'gas'
89	year	integer	Reporting year (2024)
90	month	integer	Month number (1-12)
91	shutoffs	numeric	Residential disconnections (Disconnections sheet)
92	reconnections	numeric	Residential reconnections (Reconnections sheet)
93	final_notices	numeric	Final notices sent to residential customers (Final notices sheet)
94	customer_count	numeric	Total residential customers (Number of customers sheet)
95
96	Bad Data Flags — DD-MM-YYYY-eia-112-utility-bad-data.csv (19 columns, same schema as Utility Annual)
97
98	Contains only the 145 rows where bad_data_flag = 'Y'. All 19 columns are identical to the Utility Annual sheet.
99	These rows are also present in the Utility Annual sheet; this sheet isolates them for convenient review.
100