Hamlin Pub

Clinton Township, MI 48038 · O01d9111a955c · first seen 2026-10-08
5 sourceson premise · restaurantchain: Hamlinpubalcohol: 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 Pub 2 other
the most common name a source states
HAMLIN PUB CLINTON TWP ab-inbevvtinfo ×2
hamlin pub clinton township doordash
Street
42305 Garfield Road 1 other
ubereats
42305 GARFIELD RD ab-inbevdoordashoverturevtinfo ×4
City
Clinton Township
ubereatsno other value
State
MI
ubereatsno other value
ZIP
48038
ubereatsno other value
Pin
42.60768, -82.95337 map 1 other
ubereats
65 m away ab-inbev
Phone
5867651680
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob5e5e7ce793e; O140496f1160e; Oc83c6f6e0afa; Of3974ac6ebe8

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 PUB CLINTON TWP
4890047
42305 GARFIELD RD, CLINTON TOWNSHIP, MI, 4803842.60809, -82.952802026-11-112026-11-11
doordashhamlin pub clinton township
38903734
42305 Garfield Rd, Clinton Township, MI, 4803842.60769, -82.953372026-10-082026-11-10
overtureHamlin Pub
f24bf6cc-4e92-48a5-a77e-5730e57e0d8d
42305 Garfield Rd, Clinton Township, MI, 48038586765168042.60762, -82.953382026-11-092026-11-09
ubereatsHamlin Pub
57apn6wTWKqjwXABOzgYaw
42305 Garfield Road, Clinton Township, MI, 4803842.60768, -82.953372026-11-072026-11-09
vtinfoHAMLIN PUB CLINTON TWP
f499ef3f0e34eac3
42305 GARFIELD RD, CLINTON TOWNSHIP, MI, 48038586765168042.60762, -82.953572026-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 PUB CLINTON TWPvtinfo HAMLIN PUB CLINTON TWP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 81 m apart · name similarity 1.00
doordash hamlin pub clinton townshipoverture Hamlin Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
doordash hamlin pub clinton townshipubereats Hamlin Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00
overture Hamlin Pububereats Hamlin Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ab-inbev HAMLIN PUB CLINTON TWPdoordash hamlin pub clinton township0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 65 m apart · name similarity 0.75
doordash hamlin pub clinton townshipvtinfo HAMLIN PUB CLINTON TWP0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + city + state · pins 17 m apart · name similarity 0.75

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Hamlinpub — ubereats-parent
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +11 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)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
65 within 1 mi · 428 within 3 mi
Off / on premise
15 / 37 within 1 mi · 122 / 250 within 3 mi
Selling alcohol
31 within 1 mi · 193 within 3 mi
Nearest
same channel 0.15 mi · licensed 0.04 mi
Setting
urban (4,218 people per sq mi)
People within 3 mi
119,261 (92,282 adults 21+, 49,824 households) from 30 tract(s), tracts within 3 mi
Income
per capita $42,960 · median household ~$86,483 (weighted mean of tract medians)
Age and education
median age ~42.0 · bachelor's or higher 31%
Ethnicity
Hispanic 3% · White 80% · Black 9% · Asian 3%
Adults per alcohol outlet
476
Alcohol spend within 3 mi
$33,841,786 a year ($15,549,256 at home, $18,276,829 away) · $174,442 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 14:25insertdoordash 38903734 ↔ vtinfo f499ef3f0e34eac3same address and namemerged12
2026-11-12 14:25insertab-inbev 4890047 ↔ vtinfo f499ef3f0e34eac3same address and namemerged12
2026-11-11 12:56insertab-inbev 4890047 ↔ doordash 38903734same address and namemerged12
2026-11-09 15:32insertdoordash 38903734 ↔ overture f24bf6cc-4e92-48a5-a77e-5730e57e0d8dsame address and namemerged11
2026-11-09 15:32insertoverture f24bf6cc-4e92-48a5-a77e-5730e57e0d8d ↔ ubereats 57apn6wTWKqjwXABOzgYawsame address and namemerged11
2026-11-09 14:23insertdoordash 38903734 ↔ ubereats 57apn6wTWKqjwXABOzgYawsame address and namemerged11