Buildings coming down, and the big electrical jobs, before the gear is scrapped
Commercial buildings with a wrecking or demolition permit, and standing commercial buildings where an electrician has declared a large job — newest first, with the firm doing the work and the address its permit office has for it. It answers 'where is working electrical equipment about to become surplus' out of the two cities' own permit desks, for anyone who buys transformers, switchgear or panels before the scrap yard does.
The file
Minneapolis and Saint Paul · 562 permits (209 teardowns, 353 electrical) · 2020-01-08 to 2026-09-22
562 rowsCounties in this file: Hennepin, Ramsey · 22 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 | city | teardown or electrical | issued | firm as filed | firm's mailing address | work, office's own word | declared value (St Paul only) | status |
|---|---|---|---|---|---|---|---|---|
| — | Minneapolis | teardown | 2026-09-22 | Veit and Co Inc | 1400 Veit Place Rogers | Private | — | Issued |
| 1745 GRAND AVE | Saint Paul | electrical | 2025-01-30 | CAL-TEX ELECTRIC INC | 17001 FISH POINT ROAD PRIOR LAKE MN 55372 | Commercial Repair/Alter | 240,750 | Inspected |
| 1829 5th Ave S, Minneapolis | Minneapolis | teardown | 2024-05-20 | Rachel Contracting LLC | 4180 Napier CT NE St Michael | Private | — | Closed |
| 1116 ASHLAND AVE | Saint Paul | electrical | 2023-08-14 | NICK BYRAM TRUNORTH SOLAR | 3735 DUNLAP ST N - ARDEN HILLS MN 55112 UNITED STATES | Commercial Repair/Alter | 49,450 | Finaled |
| 2270 FORD PKWY | Saint Paul | electrical | 2022-11-04 | Mr. Anthony Pallarico NEI ELECTRIC | 4815 White Bear Parkway White Bear Lake, MN 55110 | Commercial Repair/Alter | 175,000 | Finaled |
| 435 PHALEN BLVD | Saint Paul | electrical | 2022-03-08 | SETH HOLM HUNT ELECTRIC CORPORATION | 7900 CHICAGO AVE S BLOOMINGTON MN 55420 | Commercial Repair/Alter | 50,000 | Finaled |
| 471 MARION ST | Saint Paul | electrical | 2021-07-07 | Adam Werner REGENCY ELECTRIC LLC | 16159 MARBLE ST NW ANOKA MN 55303 | Commercial Repair/Alter | 130,000 | Finaled |
| 2600 27th Ave S, Minneapolis | Minneapolis | teardown | 2020-12-21 | BD Construction LLC | 3844 Florida Ave N Crystal | Private | — | Closed |
| 1499 UNIVERSITY AVE W | Saint Paul | teardown | 2020-07-31 | JAMES SEMPLE SEMPLE EXCAVATING & TRUCKING | 91 RIDDER CIRCL ST PAUL MN 55107 | Commercial Demo | 100,000 | Finaled |
| 875 MONTREAL WAY | Saint Paul | electrical | 2020-01-08 | CEDAR LAKE ELECTRIC INC | 20700 Bagley Avenue Faribault MN 55021 | Commercial Repair/Alter | 245,000 | Finaled |
An em dash means the record is blank, and that is the source's gap rather than ours. Across the whole file: declared value (St Paul only) is blank on 27.9% of rows, address is blank on 0.4% 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 |
city |
city | default |
signal |
teardown or electrical | default |
issued |
issued | default |
firm |
firm as filed | default |
firm_address |
firm's mailing address | default |
work |
work, office's own word | default |
value_usd |
declared value (St Paul only) | default |
status |
status | default |
kind |
permit kind, office's own word | optional |
occupancy |
occupancy (Minneapolis only) | optional |
fees_usd |
fee charged (Minneapolis only) | optional |
completed |
completion recorded | optional |
open |
no completion recorded | optional |
use |
parcel use class | optional |
assessed |
assessed value | optional |
year_built |
year built | optional |
permit_no |
permit number | optional |
register |
register's own word | optional |
parcel_id |
parcel id | optional |
county |
county | optional |
source |
source | optional |
Where it comes from
Minneapolis CCS_Permits — Community Planning and Economic Development; Saint Paul Approved_Building_Permits — Department of Safety and Inspections
Records retrieved 2026-09-25 — 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 City of Minneapolis, City of Saint Paul. 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=teardowns&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=teardowns&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.