Which buildings on this run are on a vacancy register
99 rows stand on 57 named runs that hold 4,338 addresses between them, so the register is naming a small fraction of any street by construction — the pair of columns is there so that fraction is on the row rather than in a caveat.
The file
Minneapolis and Saint Paul — 246 registered vacant or condemned buildings placed on a parcel, of 1,047 filings the two cities publish. 99 of them stand on one of the 57 named runs the corridor file walks. A REGISTER IS A FLOOR: these are the buildings somebody filed on, so an address with no row here is an address nobody filed on.
246 rowsCounties in this file: Hennepin, Ramsey · 17 columns available · free, no account, no rate limit.
Joins to an address on parcel_id, 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.
| address | run | use | vacant since | which register | filings on this run | addresses on this run |
|---|---|---|---|---|---|---|
| 1911 14TH AVE S | 14th Avenue South | TRIPLEX | — | Minneapolis vacant building registration | 1 | 85 |
| 990 ARCADE ST | Arcade Street | 3A COMMERCIAL LAND AND BUILDING | 2023-08-14 | Saint Paul vacant building register | 5 | 16 |
| 1401 MARYLAND AVE E | Maryland Avenue East | 3A COMMERCIAL LAND AND BUILDING | 2024-01-17 | Saint Paul vacant building register | 3 | 57 |
| 861 SELBY AVE | Selby Avenue | 4A APARTMENT 4 OR MORE UNITS | 2024-06-28 | Saint Paul vacant building register | 2 | 156 |
| 1164 7TH ST W FL 2 | — | 1A/1B/4B1 RESIDENTIAL 1-3 UNITS | 2024-08-30 | Saint Paul vacant building register | — | — |
| 1907 UPTON AVE N | — | RESIDENTIAL | — | Minneapolis vacant building registration | — | — |
| 2732 4TH ST N | — | RESIDENTIAL-TWO UNIT | 2007-07-09 | Minneapolis condemned by boarding | — | — |
| 3623 PENN AVE N | — | RESIDENTIAL | — | Minneapolis vacant building registration | — | — |
| 615 30TH AVE N | — | RESIDENTIAL | 2012-06-14 | Minneapolis condemned by boarding | — | — |
| 973 FRONT AVE | — | 1A/1B/4BB RESIDENTIAL SINGLE UNIT | 2025-01-13 | Saint Paul vacant building register | — | — |
An em dash means the record is blank, and that is the source's gap rather than ours. Across the whole file: run is blank on 59.8% of rows, filings on this run is blank on 59.8% of rows, addresses on this run is blank on 59.8% of rows, vacant since is blank on 37.0% 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 |
|---|---|---|
address |
address | default |
corridor |
run | default |
use |
use | default |
vacant_since |
vacant since | default |
filed_by |
which register | default |
filings_on_this_run |
filings on this run | default |
buildings_on_this_run |
addresses on this run | default |
owner |
owner | optional |
assessed |
assessed | optional |
year_built |
year built | optional |
building_type |
building type | optional |
category |
register category | optional |
condemned_on |
condemned on | optional |
commercial_site |
a commercial parcel | optional |
on_a_named_run |
on a named run | optional |
parcel_id |
parcel id | optional |
county |
county | optional |
Where it comes from
Saint Paul vacant building register, Minneapolis vacant building registration and condemned-by-boarding lists
This source does not stamp the day it was published, so we cannot honestly date our copy of it and will not guess. The period the records themselves cover is on the system card.
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 City of Minneapolis, City of Saint Paul, county GIS offices, county assessors. Government data held by a Minnesota state agency or political subdivision, presumed public under the Minnesota Government Data Practices Act (Minn. Stat. ch. 13) and published by the agency itself.
Read the full licence · how we license every dataset, and the two we do not
Without the page
/api/export?dataset=vacancies&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=vacancies&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.