The controlling source is the DataLumos/ICPSR 217661, version V2 archive of the 2023 AHS National PUF. The two analyzed CSV files are pinned by SHA-256 in the companion. Their source rows contain 55,669 housing units and 44,689 projects; 28,192 homes meet the occupied-owner universe. ICPSR distributes these files as deposited, without its own processing or quality review. Repository V2 is not the Census release number.
We validated unique household keys, the many-to-one project join and source project counts. Repeated household/category pairs and identical project rows were retained rather than automatically deleted: removing them would change the source's project totals. No raw housing-unit identifiers or records are included in the public downloads.
183 selected control comparisons passed against the official Census 2023 PUF verification workbook, covering occupied/owner totals and all C-16 project-count, spending, positive-cost median/mean rows and available count margins. Comparison is at the workbook's displayed precision. The primary workbook was read as parsed document text; original binary XLSX bytes were not acquired. PUF controls are distinct from Table Creator's internal-use-file figures. The comparison receipt preserves those differences and the display conventions.
The actual archived edition is verified and its business fields are corroborated with Census's 2023 definitions, questionnaire and control specifications, alongside the pinned archived dictionary. We do not assert a direct Census download or a bitwise match to an original Census ZIP. The code validates the CSV contents separately from ZIP compression and timestamps.
All eight service categories are fixed in advance of weighted outcomes. Unweighted schema and code frequencies had already been inspected, so this is not claimed as full preregistration before any data inspection. Pre-2010 construction dates are grouped source codes, not exact individual years. Household participation retains every eligible no-project home; project statistics copy the housing unit's final and 160 supplied replicate weights onto its project rows.
The Census/HUD replicate-weight guide specifies Fay BRR variance: 4/160 times the sum of squared replicate deviations from the full estimate. Ratios recompute both numerator and denominator per replicate; share differences retain paired covariance. Weighted quantiles use an inverse empirical CDF. Study intervals use a pointwise 90% normal approximation, without multiplicity correction. They do not measure nonresponse, recall error or unmeasured confounding.
The publication policy requires at least 100 unweighted eligible homes and 30 qualifying homes per subgroup; it is Lonta's policy, not a Census standard. One septic 2000+ cell and its corresponding adjusted contrast are withheld everywhere, including exports. Census-control medians/means use positive costs; the research's category cost distributions intentionally retain known nonnegative amounts. These are separate, explicitly defined calculations.
This is historical improvement/replacement work, excluding many routine maintenance and emergency-call outcomes. It is not contractor revenue, profit, ad attribution or a 2026 demand forecast. It is original secondary analysis of one survey, not a pooled meta-analysis or a Lonta client study. Prepared with Codex; no independent or human-review claim is made.