HAMLIN PUBS

UTICA, MI 48315 · O0589f34fdcb6 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: alcohol

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 PUBS 2 other
the most common name a source states
Hamlin Pub overture
hamlin pub shelby charter township doordash
Street
48929 Hayes Road 1 other
doordash
48929 HAYES RD ab-inbevoverturevtinfo ×3
City
Shelby charter Township 2 other
doordash
UTICA ab-inbevvtinfo ×2
Shelby Twp overture
State
MI
doordashno other value
ZIP
48315
doordashno other value
Pin
42.65582, -82.97641 map 2 other
doordash
159 m away ab-inbev
148 m away vtinfo
Phone
5862474100
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O94df533e0f87; O0bc96d5e48d3; O84e79f1db0f5

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
2763424
48929 HAYES RD, UTICA, MI, 4831542.65610, -82.974502026-11-112026-11-12
doordashhamlin pub shelby charter township
203888
48929 Hayes Road, Shelby charter Township, MI, 4831542.65582, -82.976412026-10-082026-11-07
overtureHamlin Pub
85337085-5c2f-419d-a98b-b63eb60a5f17
48929 Hayes Rd, Shelby Twp, MI, 48315586247410042.65594, -82.976352026-11-132026-11-13
vtinfoHAMLIN PUBS
fc357fac83cce8f6
48929 HAYES RD, UTICA, MI, 48315586247410042.65597, -82.974612026-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 17 m apart · name similarity 1.00
ab-inbev HAMLIN PUBSoverture Hamlin Pub0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 152 m apart · name similarity 0.64
overture Hamlin Pubvtinfo HAMLIN PUBS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 142 m apart · name similarity 0.64 · phone: equal
ab-inbev HAMLIN PUBSdoordash hamlin pub shelby charter township0.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Hamlin Pub at identical address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 48929 Hayes Road in ZIP 48315 with coordinates about 160 m apart, no other business is held at that address, and the names match (Hamlin Pubs vs. Hamlin Pub, with the DoorDash slug carrying the township name as its city suffix).
pair 12acd11429cddd766dc5

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +9 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
32 within 1 mi · 452 within 3 mi
Off / on premise
11 / 16 within 1 mi · 122 / 258 within 3 mi
Selling alcohol
17 within 1 mi · 213 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.10 mi
Setting
urban (3,256 people per sq mi)
People within 3 mi
92,072 (69,917 adults 21+, 35,925 households) from 21 tract(s), tracts within 3 mi
Income
per capita $44,459 · median household ~$96,397 (weighted mean of tract medians)
Age and education
median age ~45.1 · bachelor's or higher 35%
Ethnicity
Hispanic 2% · White 86% · Black 5% · Asian 4%
Adults per alcohol outlet
327
Alcohol spend within 3 mi
$26,731,958 a year ($12,080,059 at home, $14,640,115 away) · $124,916 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-14 20:23insertoverture 85337085-5c2f-419d-a98b-b63eb60a5f17 ↔ vtinfo fc357fac83cce8f6same address and namemerged15
2026-11-13 14:10insertab-inbev 2763424 ↔ overture 85337085-5c2f-419d-a98b-b63eb60a5f17same address and namemerged15
2026-11-12 17:29insertab-inbev 2763424 ↔ doordash 203888Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2763424 ↔ vtinfo fc357fac83cce8f6same address and namemerged12