HAMLIN PUB

Shelby Township, MI 48316 · O227eed399b91 · first seen 2026-10-08
4 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
HAMLIN PUB 3 other
the most common name a source states
HAMLIN PUBS ab-inbevvtinfo ×2
VAN DYKE BOYS, LLC mi-lcc (legal name) ×2
hamlin pub shelby township doordash
Street
55076-55082-55088-55094 Van Dyke Ave 2 other
mi-lcc
55076 VAN DYKE ab-inbevvtinfo ×2
55076 Van Dyke Avenue doordash
City
Shelby Township 1 other
mi-lcc
UTICA ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48316
mi-lccno other value
Pin
42.69900, -83.03235 map 3 other
doordash
195 m away mi-lcc ×2
192 m away ab-inbev
200 m away vtinfo
Phone
5867869350 1 other
vtinfo
2484966660 mi-lcc ×2
Licences
mi-lcc L-000158593 · mi-lcc L-000158594
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O22b454f55ed7; O956a45808f39; Obb7b044862a7; O689bc1445510

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-inbevHAMLIN PUBS
2920340
55076 VAN DYKE, UTICA, MI, 48316
ZIP lookup: Shelby Township, MI
42.69871, -83.034672026-11-112026-11-12
doordashhamlin pub shelby township
387360
55076 Van Dyke Avenue, Shelby Township, MI, 4831642.69900, -83.032352026-10-082026-11-12
mi-lccHAMLIN PUB
legal name: VAN DYKE BOYS, LLC
L-000158593
55076-55082-55088-55094 Van Dyke Ave, Shelby Township, MI, 48316248496666042.69937, -83.034692026-11-032026-11-05
mi-lccHAMLIN PUB
legal name: VAN DYKE BOYS, LLC
L-000158594
55076-55082-55088-55094 Van Dyke Ave, Shelby Township, MI, 48316248496666042.69937, -83.034692026-11-032026-11-05
vtinfoHAMLIN PUBS
782c0f0774653597
55076 VAN DYKE, UTICA, MI, 48316
ZIP lookup: Shelby Township, MI
586786935042.69975, -83.034582026-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 HAMLIN PUBSvtinfo HAMLIN PUBS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 116 m apart · name similarity 1.00
doordash hamlin pub shelby townshipmi-lcc HAMLIN PUB1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
Hamlin Pub same name, address range includes
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Hamlin Pub in Shelby Township, MI 48316, and the DoorDash address 55076 Van Dyke Avenue is the first number in the liquor licence's multi-number address range; the licence's trade name matches the delivery listing, with no competing business at the address.
pair 1038cad5aec16e04f989
doordash hamlin pub shelby townshipmi-lcc HAMLIN PUB1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same name, address range includes 55076, same city.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — The DoorDash listing 'hamlin pub shelby township' at 55076 Van Dyke Avenue matches the Michigan licence trading as HAMLIN PUB, whose address range includes 55076, in the same city and ZIP, with coordinates about 0.2 km apart and no other business at that address.
pair 448076c746536d6a68d5
mi-lcc HAMLIN PUBmi-lcc HAMLIN PUB1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev HAMLIN PUBSmi-lcc HAMLIN PUB0.64Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Hamlin Pub same address range.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Hamlin Pub at the same Van Dyke address in ZIP 48316 with coordinates about 73 m apart, and the mi-lcc legal entity VAN DYKE BOYS, LLC fits the same operation; the only mismatch is the 'PUBS' vs 'PUB' spelling and the city label Utica vs Shelby Township, which is the same postal area.
pair 37eea68f5c46a332452d
ab-inbev HAMLIN PUBSdoordash hamlin pub shelby township0.64street written two waysmergedname Jaro-Winkler 0.98 · matched on zip · pins 192 m apart · name similarity 0.64 · street similarity 0.80

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
VAN DYKE BOYS, 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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
46 within 1 mi · 229 within 3 mi
Off / on premise
12 / 25 within 1 mi · 52 / 130 within 3 mi
Selling alcohol
22 within 1 mi · 119 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.10 mi
Setting
suburban (2,193 people per sq mi)
People within 3 mi
61,999 (47,783 adults 21+, 24,426 households) from 13 tract(s), tracts within 3 mi
Income
per capita $49,427 · median household ~$104,578 (weighted mean of tract medians)
Age and education
median age ~46.6 · bachelor's or higher 39%
Ethnicity
Hispanic 4% · White 88% · Black 2% · Asian 3%
Adults per alcohol outlet
398
Alcohol spend within 3 mi
$19,291,790 a year ($8,616,162 at home, $10,666,950 away) · $160,765 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 2920340 ↔ mi-lcc L-000158593Claude judge: samemerged14
2026-11-12 17:29insertdoordash 387360 ↔ mi-lcc L-000158594Claude judge: samemerged14
2026-11-12 17:29insertdoordash 387360 ↔ mi-lcc L-000158593Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2920340 ↔ vtinfo 782c0f0774653597same address and namemerged12
2026-11-11 12:56insertab-inbev 2920340 ↔ doordash 387360street written two waysmerged12
2026-11-03 13:33backfillmi-lcc L-000158593 ↔ mi-lcc L-000158594one store listed twicemerged