2024 HUD Point in Time Count Data by State and CoC with Serious Mental Illness and Chronic Substance Use Counts

Note: Data are provided here in Excel form. They were originally created in Google Sheets. Formulas that cannot transfer from one to the other will need to be recreated. For example, many sheets used importrange() and indirect() functions to refer to the other sheets and files.Methodology:We conducted a cross-sectional analysis of 2024 HUD PIT data for each state and the District of Columbia. We extracted counts of total and unsheltered homelessness, SMI, and CSU. CoCs report counts using HUD-directed methods, including Homeless Management Information System data, staff observation, and client surveys. We calculated the proportion of PEH with SMI and/or CSU who were unsheltered, the rates of SMI and CSU in unsheltered PEH, and the relative risk (RR) of being unsheltered for each psychiatric subgroup versus all PEH.HUD PIT Count reports for states, Washington, DC, and the 384 CoCs were systematically downloaded from the HUD Exchange website using a Python script developed using Cursor software. Cursor uses large language models, especially Claude Sonnet 4 (Anthropic), to generate code. PDFs were converted to tables using the ExtractTable program (https://www.extracttable.com/) (for states) and using Adobe Acrobat Pro Action Wizard to bulk export PDFs to Excel (for CoCs). ExtractTable API credits were purchased at $15 of personal expense. Tables were compiled in Excel and imported to Google Sheets for processing. All data were rigorously checked against other HUD presentations of the same data, including the 2024 Annual Report, state-level reports, and a separate by-CoC data table provided by HUD (which does not include SMI/CSU information). The compiled data from PDFs were found to be without errors, with one discrepancy in Alabama noted below.Of note, HUD Exchange is missing PIT reports for the eighth CoC of Alabama (Dothan/Coffee, Dale, Geneva, Henry, Houston Counties), which represents 132 PEH (3% of PEH in Alabama). HUD was contacted regarding this issue, but had not responded by the time of manuscript submission. This error may result in a very slight undercounting of PEH with SMI and CSU in Alabama, but was not deemed to be critical to the overall data analysis. All other CoCs are represented.State and Washington, DC population estimates were taken from 2024 U.S. Census Bureau estimates (https://www.census.gov/data/tables/time-series/demo/popest/2020s-state-total.html).