Subsidised homes, and when the subsidy runs out
One row per subsidised property, ordered by the soonest subsidy expiry so the file opens on the nearest deadline; rows whose programme has no expiry sort last. Each row says which of HUD's three programmes it belongs to, how many of its units are subsidised, and whether the pin is a building or a project area. Three rows are HUD's own administrative records rather than buildings — a state agency named where a property name goes, with no units — and they are left in because they are what HUD publishes.
The file
1,500 subsidised properties · 293 carry a contract expiry
1,500 rowsCounties in this file: Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, Washington · 23 columns available · free, no account, no rate limit.
Joins to an address on lat, lon, so it can be pointed at one property rather than read whole.
What the rows look like
10 real rows from this file, spread evenly across it rather than taken off the top — every file here is written in some order, so its first rows are never a fair sample of it. These are the default columns, which is what the download button hands over.
| property | address | city | programme | units | subsidised units | subsidy ends | county | pin is a |
|---|---|---|---|---|---|---|---|---|
| KELLY APARTMENTS | 3384 Library Ln | Saint Louis Park | Rental-assistance contract (project-based) | 6 | 6 | 2026-06-30 | Hennepin County, Minnesota | building |
| BLOOMINGTON BARRIER FREE HSNG | 10100 Lyndale Ave S | Bloomington | Rental-assistance contract (project-based) | 24 | 24 | 2036-09-30 | Hennepin County, Minnesota | building |
| PINE TREE PARK APARTMENTS | Multiple Building Addresses | Saint Paul | Tax-credit restricted (LIHTC) | 199 | 180 | — | Ramsey County, Minnesota | project area |
| RAINBOW PLAZA | 820 W Main St | Anoka | Tax-credit restricted (LIHTC) | 105 | 63 | — | Anoka County, Minnesota | project area |
| MAPLE TERRACE | 1560 Howard Ave | Maple Plain | Tax-credit restricted (LIHTC) | 38 | 38 | — | Hennepin County, Minnesota | project area |
| HUD HOMES TAX CREDIT | Multiple Buildingaddresses | Coon Rapids | Tax-credit restricted (LIHTC) | 15 | 15 | — | Anoka County, Minnesota | project area |
| MHOP | 861 Walnut Pl | Chaska | Public housing | 6 | 2 | — | Carver County, Minnesota | building |
| SCATTERED | 771 Dayton Ave | Saint Paul | Public housing | 1 | 1 | — | Ramsey County, Minnesota | building |
| SCATTERED | 875 York Ave | Saint Paul | Public housing | 1 | 1 | — | Ramsey County, Minnesota | building |
| THE BARRINGTON | 911 Park Ave | Minneapolis | Tax-credit restricted (LIHTC) | 19 | — | — | Hennepin County, Minnesota | project area |
An em dash means the record is blank, and that is the source's gap rather than ours. Across the whole file: subsidy ends is blank on 80.5% of rows.
The cuts of this file
Every cut is the same columns, filtered. Pick one and the row count changes; the file does not.
Every column in this file
Columns marked default come down unless you pick your own with
&columns=.
| Column | What it is | In the default file |
|---|---|---|
property |
property | default |
address |
address | default |
city |
city | default |
program_family |
programme | default |
units_total |
units | default |
units_subsidised |
subsidised units | default |
subsidy_expires |
subsidy ends | default |
county |
county | default |
location_grain |
pin is a | default |
programme |
HUD programme code | optional |
year_in_service |
in service since | optional |
also_in |
also in another HUD layer | optional |
expiring_soon |
ends before 2031 | optional |
occupied_pct |
occupied % | optional |
households_reported_pct |
households reported % | optional |
median_household_income_usd |
median household income | optional |
pct_aged_62_plus |
aged 62+ % | optional |
pct_with_a_disability |
with a disability % | optional |
also_tax_credit |
also tax-credit financed | optional |
tract |
census tract | optional |
zip |
zip | optional |
hud_layer |
HUD layer | optional |
hud_key |
HUD id | optional |
Where it comes from
U.S. Department of Housing and Urban Development — LIHTC property database, Multifamily Assisted properties, and Public Housing buildings
Records retrieved 2026-08-20 — the oldest capture date among the layers behind this file, because data is no fresher than its stalest input.
What this layer cannot answer is stated in full on the system card — read it before quoting a figure.
What you may do with it
Creative Commons Attribution 4.0 International (CC BY 4.0). Share it, change it, build a product on it, sell that product — all fine. The one condition is credit: say it came from Brick & Mortar and link back.
Records published by U.S. Department of Housing and Urban Development, U.S. Census Bureau. A work of the United States government, which is not subject to copyright protection in the U.S. (17 U.S.C. § 105).
Read the full licence · how we license every dataset, and the two we do not
Without the page
/api/export?dataset=subsidised-housing&format=csv returns the
same file. Call /api/export
with no arguments for the whole catalogue.
Point an AI at it
Every file carries its own source, its capture date and the layer's own warnings in the header, so a model reading one gets the caveats with the numbers rather than the numbers alone. Paste this at an assistant that can fetch a URL:
Read https://brickandmortar.dev/api/export?dataset=subsidised-housing&format=csv
Everything above the header row is provenance and limits. Read it first,
then answer using only what the rows support.llms.txt describes the whole warehouse the same way — what each dataset holds, which counties it really covers, and what it cannot answer.