Outlets /
Saint Andrew's Hall
Detroit, MI 48226 · O1602c96e1966 · first seen 2026-11-03
5 sourceson premise · predictedalcohol: licensed1 licence
Golden record
One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Saint Andrew's Hall 4 other | a source's own spelling of the licence name (record_title.py) | SAINT ANDREWS HALL ab-inbevmi-lccvtinfo ×3 MICHIGAN HOLDINGS, LLC (A DELAWARE LIMITED LIABILITY COMPANY) mi-lcc (legal name) Saint Andrew’s Hall overture ST ANDREWS HALL inspections |
| Street | 431 E Congress St | mi-lcc | no other value |
| City | Detroit | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48226 | mi-lcc | no other value |
| Pin | 42.33220, -83.04144 map | overture | no other value |
| Phone | 3139616358 2 other | vtinfo | 3139618961 overture 7349618961 mi-lcc |
| Licences | mi-lcc L-000125681 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ob7bf082dce4a; O5b8267489b4d; Oda1a83c44a58; O92a06eff3065
Carries
Products seen on this outlet’s shelf in store-level catalogs.
No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.
Sources
Every source record folded into this outlet, as the source states it.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SAINT ANDREWS HALL 2516944 | 431 E CONGRESS ST, DETROIT, MI, 48226 | 42.33236, -83.04093 | 2026-11-11 | 2026-11-11 | |
| inspections | ST ANDREWS HALL inspections|mi|SFE-4982-043323 | 431 E CONGRESS ST, Detroit, MI, 48226 | 42.33231, -83.04116 | 2026-11-20 | 2026-11-20 | |
| mi-lcc | SAINT ANDREWS HALL legal name: MICHIGAN HOLDINGS, LLC (A DELAWARE LIMITED LIABILITY COMPANY) L-000125681 | 431 E Congress St, Detroit, MI, 48226 | 7349618961 | 42.33206, -83.04165 | 2026-11-03 | 2026-11-11 |
| overture | Saint Andrew’s Hall 60207930-8651-4f13-afcf-a396ef5a34c0 | 431 E Congress St, Detroit, MI, 48226 | 3139618961 | 42.33220, -83.04144 | 2026-11-06 | 2026-11-11 |
| vtinfo | SAINT ANDREWS HALL de95de5d2286354a | 431 E CONGRESS ST, DETROIT, MI, 48226 | 3139616358 | 42.33239, -83.04148 | 2026-11-11 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SAINT ANDREWS HALL | mi-lcc SAINT ANDREWS HALL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 68 m apart · name similarity 1.00 |
| ab-inbev SAINT ANDREWS HALL | overture Saint Andrew’s Hall | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00 |
| ab-inbev SAINT ANDREWS HALL | vtinfo SAINT ANDREWS HALL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00 |
| mi-lcc SAINT ANDREWS HALL | overture Saint Andrew’s Hall | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00 · phone: differs |
| mi-lcc SAINT ANDREWS HALL | vtinfo SAINT ANDREWS HALL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00 · phone: differs |
| overture Saint Andrew’s Hall | vtinfo SAINT ANDREWS HALL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00 · phone: differs |
| ab-inbev SAINT ANDREWS HALL | inspections ST ANDREWS HALL | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 20 m apart · name similarity 0.70 |
| inspections ST ANDREWS HALL | mi-lcc SAINT ANDREWS HALL | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 49 m apart · name similarity 0.70 |
| inspections ST ANDREWS HALL | overture Saint Andrew’s Hall | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 27 m apart · name similarity 0.70 |
| inspections ST ANDREWS HALL | vtinfo SAINT ANDREWS HALL | 0.70 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 27 m apart · name similarity 0.70 |
Attributes
- Channel
- unknown
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- MICHIGAN HOLDINGS, LLC (A DELAWARE LIMITED LIABILITY COMPANY) — 2 outlets in the master under this operator
- Licence privileges
- beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
"votes": []
}Trade area
- Other outlets
- 379 within 1 mi · 896 within 3 mi
- Off / on premise
- 24 / 184 within 1 mi · 117 / 442 within 3 mi
- Selling alcohol
- 292 within 1 mi · 617 within 3 mi
- Nearest
- same channel none within 3 mi · licensed 0.01 mi
- Setting
- suburban (2,320 people per sq mi)
- People within 3 mi
- 65,589 (53,108 adults 21+, 34,623 households) from 35 tract(s), tracts within 3 mi
- Income
- per capita $40,572 · median household ~$46,863 (weighted mean of tract medians)
- Age and education
- median age ~38.1 · bachelor's or higher 39%
- Ethnicity
- Hispanic 6% · White 27% · Black 59% · Asian 5%
- Adults per alcohol outlet
- 86
- Alcohol spend within 3 mi
- $17,193,798 a year ($8,221,270 at home, $8,960,373 away) · $27,822 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.
History
Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4982-043323 ↔ overture 60207930-8651-4f13-afcf-a396ef5a34c0 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4982-043323 ↔ mi-lcc L-000125681 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ab-inbev 2516944 ↔ inspections inspections|mi|SFE-4982-043323 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4982-043323 ↔ vtinfo de95de5d2286354a | same address and name | merged | 17 |
| 2026-11-11 12:56 | insert | overture 60207930-8651-4f13-afcf-a396ef5a34c0 ↔ vtinfo de95de5d2286354a | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2516944 ↔ vtinfo de95de5d2286354a | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | mi-lcc L-000125681 ↔ vtinfo de95de5d2286354a | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2516944 ↔ overture 60207930-8651-4f13-afcf-a396ef5a34c0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2516944 ↔ mi-lcc L-000125681 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | mi-lcc L-000125681 ↔ overture 60207930-8651-4f13-afcf-a396ef5a34c0 | same address and name | merged | 11 |