SPKR Box

DETROIT, MI 48226 · O0f76d5e07255 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: 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
SPKR Box 3 other
a licence name in capitals, cleaned (derived; record_title.py)
SPKRBOX ab-inbevinspectionsoverturevtinfo ×4
GLASS JAR, LLC mi-lcc (legal name) ×2
spkrbox detroit doordash
Street
200 Grand River 3 other
mi-lcc
200 E GRAND RIVER AVE ab-inbevvtinfo ×2
200 Grand River Ave overture
200 Grand River Avenue doordash
City
DETROIT
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48226
mi-lccno other value
Pin
42.33370, -83.04993 map 2 other
doordash
369 m away ab-inbev
192 m away vtinfo
Phone
3134691010 2 other
vtinfo
3137656513 mi-lcc ×2
3134961010 overture
Licences
mi-lcc L-000434916 · mi-lcc L-000434917
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocae572db87a2; O36f255d04400; O11ab75ddd3e2; O69ec1dc045df; O59475e480090; O2ef0e1635f2e

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-inbevSPKRBOX
4530805
200 E GRAND RIVER AVE, DETROIT, MI, 4822642.33587, -83.046542026-11-112026-11-16
doordashspkrbox detroit
24755980
200 Grand River Avenue, Detroit, MI, 4822642.33370, -83.049932026-10-082026-11-17
inspectionsSpkrBox
inspections|detroit|51623592
200 GRAND RIVER, Detroit, MI, 4822642.33398, -83.050042026-11-202026-11-20
mi-lccSPKR BOX
legal name: GLASS JAR, LLC
L-000434916
200 Grand River, DETROIT, MI, 48226313765651342.33375, -83.049682026-11-032026-11-19
mi-lccSPKR BOX
legal name: GLASS JAR, LLC
L-000434917
200 Grand River, DETROIT, MI, 48226313765651342.33375, -83.049682026-11-032026-11-19
overtureSpkrbox
fd8b092b-1574-4b4b-b52a-882258912e0a
200 Grand River Ave, Detroit, MI, 48226313496101042.33375, -83.049902026-11-182026-11-18
vtinfoSPKRBOX
a54081cf2c4dccb8
200 E GRAND RIVER AVE, DETROIT, MI, 48226313469101042.33434, -83.047752026-11-112026-11-16

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 SPKRBOXdoordash spkrbox detroit1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 369 m apart · name similarity 1.00 · street similarity 0.94
ab-inbev SPKRBOXinspections SpkrBox1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 356 m apart · name similarity 1.00 · street similarity 0.79
ab-inbev SPKRBOXoverture Spkrbox1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 363 m apart · name similarity 1.00 · street similarity 0.94
ab-inbev SPKRBOXvtinfo SPKRBOX1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 197 m apart · name similarity 1.00
doordash spkrbox detroitinspections SpkrBox1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 33 m apart · name similarity 1.00 · street similarity 0.85
doordash spkrbox detroitoverture Spkrbox1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
doordash spkrbox detroitvtinfo SPKRBOX1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 192 m apart · name similarity 1.00 · street similarity 0.94
inspections SpkrBoxoverture Spkrbox1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 28 m apart · name similarity 1.00 · street similarity 0.85
inspections SpkrBoxvtinfo SPKRBOX1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 192 m apart · name similarity 1.00 · street similarity 0.79
mi-lcc SPKR BOXmi-lcc SPKR BOX1.00one store listed twicemergedsame street + ZIP · name: identical
overture Spkrboxvtinfo SPKRBOX1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 188 m apart · name similarity 1.00 · street similarity 0.94
doordash spkrbox detroitmi-lcc SPKR BOX0.27Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “same-address” pair)
Same name SPKR BOX at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — The DoorDash listing 'spkrbox detroit' matches the Michigan licence trade name 'SPKR BOX' at the same street address, ZIP, and city, with coordinates about 22 m apart and only one business at the address, so it is the same outlet.
pair ce04a70c2c4e4280a3b4
doordash spkrbox detroitmi-lcc SPKR BOX0.27Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Spkr Box at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — The DoorDash listing 'spkrbox detroit' and the Michigan licence trade name 'SPKR BOX' match at the same street address and ZIP in Detroit, with coordinates about 22 m apart and no other business at the address.
pair 8b414c6e95901da0e342
inspections SpkrBoxmi-lcc SPKR BOX0.27same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.42 · same street + ZIP · pins 40 m apart · name similarity 0.27
inspections SpkrBoxmi-lcc SPKR BOX0.27same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.42 · same street + ZIP · pins 40 m apart · name similarity 0.27

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GLASS JAR, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
455 within 1 mi · 940 within 3 mi
Off / on premise
27 / 228 within 1 mi · 124 / 464 within 3 mi
Selling alcohol
332 within 1 mi · 643 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.01 mi
Setting
suburban (2,644 people per sq mi)
People within 3 mi
74,766 (60,373 adults 21+, 39,457 households) from 40 tract(s), tracts within 3 mi
Income
per capita $39,561 · median household ~$46,941 (weighted mean of tract medians)
Age and education
median age ~38.1 · bachelor's or higher 38%
Ethnicity
Hispanic 10% · White 26% · Black 57% · Asian 5%
Adults per alcohol outlet
94
Alcohol spend within 3 mi
$19,301,482 a year ($9,252,215 at home, $10,035,836 away) · $29,971 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-20 22:08insertinspections inspections|detroit|51623592 ↔ mi-lcc L-000434917same address and namemerged17
2026-11-20 22:08insertinspections inspections|detroit|51623592 ↔ mi-lcc L-000434916same address and namemerged17
2026-11-20 22:08insertab-inbev 4530805 ↔ inspections inspections|detroit|51623592street written two waysmerged17
2026-11-20 22:08insertinspections inspections|detroit|51623592 ↔ vtinfo a54081cf2c4dccb8street written two waysmerged17
2026-11-20 22:08insertdoordash 24755980 ↔ inspections inspections|detroit|51623592street written two waysmerged17
2026-11-20 22:08insertinspections inspections|detroit|51623592 ↔ overture fd8b092b-1574-4b4b-b52a-882258912e0astreet written two waysmerged17
2026-11-19 20:37insertdoordash 24755980 ↔ mi-lcc L-000434916Claude judge: samemerged17
2026-11-19 20:37insertdoordash 24755980 ↔ mi-lcc L-000434917Claude judge: samemerged17
2026-11-18 18:58insertab-inbev 4530805 ↔ overture fd8b092b-1574-4b4b-b52a-882258912e0astreet written two waysmerged15
2026-11-18 18:58insertoverture fd8b092b-1574-4b4b-b52a-882258912e0a ↔ vtinfo a54081cf2c4dccb8street written two waysmerged15
2026-11-18 18:58insertdoordash 24755980 ↔ overture fd8b092b-1574-4b4b-b52a-882258912e0asame address and namemerged15
2026-11-16 14:56insertab-inbev 4530805 ↔ doordash 24755980street written two waysmerged15
2026-11-16 14:56insertdoordash 24755980 ↔ vtinfo a54081cf2c4dccb8street written two waysmerged15
2026-11-11 12:56insertab-inbev 4530805 ↔ vtinfo a54081cf2c4dccb8same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000434916 ↔ mi-lcc L-000434917one store listed twicemerged