Download HUD 232 process data
The queue, closing-rate and timing figures on this site are free CSV and JSON files. The queue file changes every week, and we keep each week's copy so you can see the line grow or shrink.
Files
| Dataset | Rows | As of | Download |
|---|---|---|---|
| This week's HUD queueOne row per queue and per assignment list | 7 | HUD report of October 14, 2026 | CSV (1 KB) · JSON (2 KB) |
| Queue historyEvery weekly snapshot kept since October 14, 2026 (1 so far) | 7 | Through October 14, 2026 | CSV (1 KB) · JSON (2 KB) |
| Note rates at closing by month223(f), 223(a)(7) and all programs: count, 25th percentile, median, 75th | 25 | Fiscal 2025 | CSV (1 KB) · JSON (3 KB) |
| Processing timesEach step in the closings file, plus firm commitment to closing by fiscal year since 2011 | 78 | Fiscal 2025; endorsements to July 8, 2026 | CSV (7 KB) · JSON (14 KB) |
manifest.json names the current files with their row counts, sources and column dictionaries. The weekly queue file's name carries its report date, so read the manifest rather than hard-coding a file name.
Where it comes from
The queue comes from HUD's ORCF Underwriting Queues and Assignments page, which shows only the current week. A script reads it each week, counts the applications on each line and measures waits from HUD's own dates. Project numbers and HUD staff names stay out of the files. History starts October 14, 2026, the first week this site saved; earlier weeks are gone from HUD's page.
Closing rates and step times come from HUD's fiscal 2025 Lean closings file, which dates each loan's application, assignment, firm commitment and closing and gives its note rate. Firm-to-closing times by year come from HUD's healthcare endorsement database (data run July 8, 2026). The methodology says how each date difference is measured. These are history, not a quote or a promise of timing.
Queue and queue history columns
| Column | What it holds |
|---|---|
as_of | Date of HUD's queue report (YYYY-MM-DD). |
line | Queue or assignment list name as HUD's page writes it. |
kind | queue (waiting now) or assignment (moved this week). |
description | What the line counts, in plain words. |
count | Applications or closings on the line. |
express_lane | Of those, flagged Express Lane (223(f) queues only). |
median_days | Queues: median days since entering the queue. Assignments: median days waited before assignment. |
oldest_days | Queues: longest wait so far. Assignments: longest wait among this week's assignments. |
waits_days | Assignments only: each assignment's wait in days, semicolon-separated. |
Closing rate columns
| Column | What it holds |
|---|---|
fiscal_year | HUD fiscal year of the closings file. |
month | Closing month (YYYY-MM). |
program | 223(f), 223(a)(7) or all programs. |
closings | Closings with a note rate that month. |
rate_p25 | 25th percentile note rate, percent. |
rate_median | Median note rate, percent. |
rate_p75 | 75th percentile note rate, percent. |
Processing time columns
| Column | What it holds |
|---|---|
source | closings-file (one fiscal year, every step) or endorsement-database (firm to closing, by year). |
fiscal_year | HUD fiscal year. |
program | HUD program group. |
step | Which two dates the days run between. |
loans | Loans with both dates. |
days_p25 | 25th percentile, days. |
days_median | Median, days. |
days_p75 | 75th percentile, days. |
JSON endpoint and rate ticker
/api/live?ids=UST10,UST7,SOFR returns the latest Treasury par yields and SOFR with their dates, a week-ago and month-ago reading, a freshness flag and the publisher's citation, open to requests from any origin. Add &history=60 for the last 60 readings. The same figures come as a small ticker you can paste into your own page:
<iframe src="https://fhaassistedliving.loan/embed/rates?ids=UST10,UST7,SOFR" width="100%" height="150" style="border:0" title="Rates from Route 232" loading="lazy"></iframe>Change ids for other series (UST1M to UST30, SOFR30, SOFR90, EFFR, PRIME, PMMS30) or add &theme=dark.
License
HUD's data is public domain. Our compilation (the counts, waits and percentiles) is yours to use under Creative Commons Attribution 4.0: credit it as "Data: Route 232 (fhaassistedliving.loan)" with a link to this page. SOFR in the ticker comes from the Federal Reserve Bank of New York under its terms of use. No warranty: HUD changes its page and files without notice, and a week can be missed. For a bulk feed or licensing on other terms, write to desk@janover.co.
Route 232 is not affiliated with or endorsed by HUD or FHA.