What a bank actually lent, loan by loan
One row per loan SBA approved, newest first. The two programmes are different products and carry different columns — 7(a) is a bank-issued, SBA-guaranteed loan and only it publishes an interest rate and a guaranteed amount; 504 is a fixed-asset loan through a certified development company and only it names a third-party lender. A blank in either is the programme not publishing that field, never a zero. The loan status column carries SBA's own code and, beside it, the meaning SBA's data dictionary gives that code. Two pairs of those codes each mean one single thing written two ways, so count the meaning and not the code — and note that an approval is not a disbursement, which is what the cut for money that moved is for.
The file
8,822 SBA loans · FY2010–FY2026 · $4.69bn approved, $4.03bn of it disbursed
8,822 rowsCounties in this file: Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, Washington · 32 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.
| business | borrower address | city | county | programme | approved $ | approved on | trade | lender | loan status | jobs supported |
|---|---|---|---|---|---|---|---|---|---|---|
| Nutter Custom Construction LLC | 22 Doral Road | Dellwood | Ramsey County, Minnesota | 7(a) | 1,500,000.0 | 2026-06-30 | New Single-Family Housing Construction (except For-Sale Builders) | 1st Financial Bank USA | undisbursed | 6 |
| Huffman Capital INC | 16345 Lithium St NW | ANOKA | Anoka County, Minnesota | 7(a) | 345,700.0 | 2025-05-19 | Pet Care (except Veterinary) Services | The Huntington National Bank | cancelled | 15 |
| A Team Enterprise LLC | 7030 VALLEY CREEK PLZ STE 102 | Woodbury | Washington County, Minnesota | 7(a) | 60,000.0 | 2024-08-26 | Other Personal Care Services | The Huntington National Bank | disbursed, still open | 8 |
| Elliot James Properties, LLC | 541 Selby Avenue | Saint Paul | Ramsey County, Minnesota | 504 | 287,000.0 | 2023-11-16 | Offices of Mental Health Practitioners (except Physicians) | WBD, Inc. | disbursed, still open | 0 |
| BLASING COMPANIES LLC | 42 SOUTHWOOD DR | VADNAIS HEIGHTS | Ramsey County, Minnesota | 7(a) | 20,000.0 | 2023-01-20 | Furniture Merchant Wholesalers | Wells Fargo Bank National Association | paid in full | 1 |
| Freedom Real Estate Solutions LLC | 413 WACOUTA ST | SAINT PAUL | Ramsey County, Minnesota | 7(a) | 100,000.0 | 2022-03-09 | Residential Property Managers | United Midwest Savings Bank National Association | cancelled | 3 |
| SKJ Brands, LLC | 897 Nordic Court N. | STILLWATER | Washington County, Minnesota | 7(a) | 350,000.0 | 2021-06-07 | Other Direct Selling Establishments | Security Bank & Trust Company | disbursed, still open | 6 |
| Glam Comb LLC | 3300 COUNTY ROAD 10 P320 | BROOKLYN CENTER | Hennepin County, Minnesota | 7(a) | 25,000.0 | 2020-07-02 | Service Establishment Equipment and Supplies Merchant Wholesalers | Granite Bank | paid in full | 4 |
| Denny's | 5605 Guthrie Place | DAVIS | Ramsey County, Minnesota | 504 | 1,147,000.0 | 2016-12-12 | Full-Service Restaurants | Amplio Economic Development Corporation | paid in full | 15 |
| Sentient Consultants Inc | 586 Hayward Avenue North. | Oakdale | Washington County, Minnesota | 504 | 102,000.0 | 2009-10-09 | Other Management Consulting Services | Twin Cities-Metro Certified Development Company | paid in full | 5 |
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 |
|---|---|---|
business |
business | default |
address |
borrower address | default |
city |
city | default |
county |
county | default |
program |
programme | default |
approved |
approved $ | default |
approval_date |
approved on | default |
trade |
trade | default |
lender |
lender | default |
status_label |
loan status | default |
jobs_supported |
jobs supported | default |
status |
SBA status code | optional |
disbursed |
money was disbursed | optional |
approval_fy |
approval FY | optional |
sba_guaranteed |
SBA guaranteed $ (7(a) only) | optional |
term_months |
term (months) | optional |
interest_rate |
interest rate % (7(a) only) | optional |
rate_type |
fixed or variable | optional |
third_party_lender |
third-party lender (504 only) | optional |
third_party_dollars |
third-party $ (504 only) | optional |
lender_kind |
lender kind | optional |
naics |
NAICS | optional |
franchise |
franchise | optional |
business_type |
entity type | optional |
business_age |
business age at approval | optional |
paid_in_full |
paid in full on | optional |
charged_off |
charged off on | optional |
charged_off_amount |
charged off $ | optional |
written_off |
was charged off | optional |
big |
$1m or more | optional |
zip |
zip | optional |
parcel_id |
parcel id | optional |
Where it comes from
U.S. Small Business Administration, 7(a) & 504 FOIA release
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. Small Business Administration. 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=sba-loans&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=sba-loans&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.