Off The Wagon

CLAWSON, MI 48017 · O26e4d1a0e1ff · first seen 2026-10-08
5 sourcesoff premisealcohol: 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
Off The Wagon 3 other
a licence name in capitals, cleaned (derived; record_title.py)
OFF THE WAGON 2 LLC mi-lcc ×2
off the wagon clawson doordash
Off the Wagon Market overture
Street
1500 N CROOKS RD 1 other
mi-lcc
1500 North Crooks Road doordash
City
CLAWSON
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48017
mi-lccno other value
Pin
42.54659, -83.16594 map 2 other
doordash
56 m away mi-lcc ×2
99 m away ab-inbev
Phone
2484354464
vtinfono other value
Licences
mi-lcc L-000465090 · mi-lcc L-000465091
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaf1dacaae72e; Oeb3918adc569; O4149ce21d6a2; O4dc20c41bc34; Oaaeb997b6f1a

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-inbevOFF THE WAGON
3240628
1500 N CROOKS RD, CLAWSON, MI, 4801742.54740, -83.166432026-11-112026-11-12
doordashoff the wagon clawson
28276951
1500 North Crooks Road, Clawson, MI, 4801742.54659, -83.165942026-10-082026-11-12
mi-lccOFF THE WAGON 2 LLC
L-000465090
1500 N CROOKS RD, CLAWSON, MI, 4801742.54694, -83.166432026-11-032026-11-12
mi-lccOFF THE WAGON 2 LLC
L-000465091
1500 N CROOKS RD, CLAWSON, MI, 4801742.54694, -83.166432026-11-032026-11-12
overtureOff the Wagon Market
2f62f2a2-ffe0-4bc7-92c6-d2bbae08c9ec
1500 N Crooks Rd, Clawson, MI, 48017248435446442.54660, -83.166052026-11-132026-11-13
vtinfoOFF THE WAGON
9a2510beb9abca60
1500 N CROOKS RD, CLAWSON, MI, 48017248435446442.54644, -83.165822026-11-122026-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 OFF THE WAGONdoordash off the wagon clawson1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 99 m apart · name similarity 1.00
ab-inbev OFF THE WAGONvtinfo OFF THE WAGON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 118 m apart · name similarity 1.00
doordash off the wagon clawsonvtinfo OFF THE WAGON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
mi-lcc OFF THE WAGON 2 LLCmi-lcc OFF THE WAGON 2 LLC1.00one store listed twicemergedsame street + ZIP · name: identical
doordash off the wagon clawsonmi-lcc OFF THE WAGON 2 LLC0.78Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “near” pair)
The DoorDash slug 'off the wagon' (with its appended city, Clawson) matches the licensee OFF THE WAGON 2 LLC at the identical address, 1500 N Crooks Rd, Clawson 48017, and only one business is known a
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Off the Wagon name matches, same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 1500 N Crooks Rd, Clawson MI 48017, with about 56 m between coordinates, and the names match: the DoorDash slug 'off the wagon clawson' corresponds to the Michigan licence filed by 'OFF THE WAGON 2 LLC', with no other business at that address.
pair 01c1e3737126f0008cb6
doordash off the wagon clawsonmi-lcc OFF THE WAGON 2 LLC0.78Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “near” pair)
The DoorDash slug 'off the wagon clawson' (name plus appended city) matches the licensee OFF THE WAGON 2 LLC at the same street address, 1500 N Crooks Rd, Clawson 48017, and only one business is known
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Off the Wagon at same address.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 1500 N Crooks Rd, Clawson MI 48017 with matching coordinates within about 56 m, the DoorDash slug 'off the wagon clawson' matches the Michigan licensee's trade name 'OFF THE WAGON 2 LLC', and no other business is listed at that address.
pair 04479f95291b091ff0b3
ab-inbev OFF THE WAGONoverture Off the Wagon Market0.69same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.74 · same street + ZIP · pins 95 m apart · name similarity 0.69
doordash off the wagon clawsonoverture Off the Wagon Market0.69same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.74 · same street + ZIP · pins 9 m apart · name similarity 0.69
overture Off the Wagon Marketvtinfo OFF THE WAGON0.69same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.74 · same street + city + state · pins 26 m apart · name similarity 0.69 · phone: equal

Attributes

Channel
off_premise — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
OFF THE WAGON 2 LLC — 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:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
85 within 1 mi · 693 within 3 mi
Off / on premise
19 / 53 within 1 mi · 166 / 403 within 3 mi
Selling alcohol
36 within 1 mi · 343 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.09 mi
Setting
urban (3,449 people per sq mi)
People within 3 mi
97,508 (76,634 adults 21+, 44,408 households) from 29 tract(s), tracts within 3 mi
Income
per capita $65,501 · median household ~$110,249 (weighted mean of tract medians)
Age and education
median age ~40.5 · bachelor's or higher 64%
Ethnicity
Hispanic 4% · White 73% · Black 6% · Asian 14%
Adults per alcohol outlet
223
Alcohol spend within 3 mi
$36,074,917 a year ($15,992,111 at home, $20,069,367 away) · $104,869 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-13 14:10insertoverture 2f62f2a2-ffe0-4bc7-92c6-d2bbae08c9ec ↔ vtinfo 9a2510beb9abca60same address and namemerged15
2026-11-13 14:10insertdoordash 28276951 ↔ overture 2f62f2a2-ffe0-4bc7-92c6-d2bbae08c9ecsame address and namemerged15
2026-11-13 14:10insertab-inbev 3240628 ↔ overture 2f62f2a2-ffe0-4bc7-92c6-d2bbae08c9ecsame address and namemerged15
2026-11-12 14:25insertdoordash 28276951 ↔ mi-lcc L-000465091Claude judge: samemerged12
2026-11-12 14:25insertdoordash 28276951 ↔ mi-lcc L-000465090Claude judge: samemerged12
2026-11-12 14:25insertdoordash 28276951 ↔ vtinfo 9a2510beb9abca60same address and namemerged12
2026-11-12 14:25insertab-inbev 3240628 ↔ vtinfo 9a2510beb9abca60same address and namemerged12
2026-11-11 12:56insertab-inbev 3240628 ↔ doordash 28276951same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000465090 ↔ mi-lcc L-000465091one store listed twicemerged