Metro Shoppers Market

Detroit, MI 48212 · O0baf4c0ac71e · first seen 2026-11-03
3 sourcesoff premise · predictedalcohol: licensed2 licences

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.

FieldMaster valueTaken fromWhat other sources say
Name
Metro Shoppers Market 2 other
a licence name in capitals, cleaned (derived; record_title.py)
METRO SHOPPERS MKT ab-inbevvtinfo ×2
SW BAHO, INC. mi-lcc (legal name) ×2
Street
17924-17932 Conant St 1 other
mi-lcc
17932 CONANT ab-inbevvtinfo ×2
City
Detroit 1 other
mi-lcc
HAMTRAMCK ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48212 1 other
mi-lcc
48234 vtinfo
Pin
42.42529, -83.06814 map
mi-lccno other value
Phone
3138914888
vtinfono other value
Licences
mi-lcc L-000437574 · mi-lcc L-000437575
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od54b0a1451a7; Obdf04316d5c3; O52bcbe841170

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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevMETRO SHOPPERS MKT
2549332
17932 CONANT, HAMTRAMCK, MI, 4821242.42568, -83.068402026-11-112026-11-11
mi-lccMETRO SHOPPERS MARKET
legal name: SW BAHO, INC.
L-000437574
17924-17932 Conant St, Detroit, MI, 48212313891488842.42529, -83.068142026-11-032026-11-12
mi-lccMETRO SHOPPERS MARKET
legal name: SW BAHO, INC.
L-000437575
17924-17932 Conant St, Detroit, MI, 48212313891488842.42529, -83.068142026-11-032026-11-12
vtinfoMETRO SHOPPERS MKT
6dafbf47154690f6
17932 CONANT, HAMTRAMCK, MI, 48234
ZIP lookup: Detroit, MI
313891488842.42536, -83.067942026-11-112026-11-14

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev METRO SHOPPERS MKTvtinfo METRO SHOPPERS MKT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
mi-lcc METRO SHOPPERS MARKETmi-lcc METRO SHOPPERS MARKET1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev METRO SHOPPERS MKTmi-lcc METRO SHOPPERS MARKET0.61Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Same market name, address range includes 17932 Conant
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name METRO SHOPPERS MARKET (ab-inbev 'METRO SHOPPERS MKT') at the same Conant Street address in ZIP 48212, with coordinates about 48 m apart; the city difference (Hamtramck vs Detroit) is a common postal-address mismatch for this location and only one business is held at the address.
pair 480f5fef169510196ea3

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SW BAHO, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
43 within 1 mi · 501 within 3 mi
Off / on premise
14 / 20 within 1 mi · 153 / 217 within 3 mi
Selling alcohol
24 within 1 mi · 255 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.47 mi
Setting
urban (4,505 people per sq mi)
People within 3 mi
127,384 (86,138 adults 21+, 44,500 households) from 48 tract(s), tracts within 3 mi
Income
per capita $20,949 · median household ~$42,120 (weighted mean of tract medians)
Age and education
median age ~33.4 · bachelor's or higher 16%
Ethnicity
Hispanic 2% · White 29% · Black 53% · Asian 11%
Adults per alcohol outlet
336
Alcohol spend within 3 mi
$18,910,284 a year ($9,466,776 at home, $9,431,864 away) · $73,868 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”).
WhenEventPairRuleDecisionRule version
2026-11-12 17:29insertab-inbev 2549332 ↔ mi-lcc L-000437574Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2549332 ↔ vtinfo 6dafbf47154690f6same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000437574 ↔ mi-lcc L-000437575one store listed twicemerged