HAMLIN PUB

Clarkston, MI 48346 · O2c161423df3e · first seen 2026-10-08
5 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
SASHABAW ROAD VENTURES, LLC mi-lcc (legal name) ×2
hamlin pub independence charter township doordash
Street
6397 Sashabaw Rd 1 other
mi-lcc
6397 Sashabaw Road doordash
City
Clarkston 1 other
mi-lcc
Independence charter Township doordash
State
MI
mi-lccno other value
ZIP
48346
mi-lccno other value
Pin
42.73174, -83.38017 map 3 other
doordash
476 m away mi-lcc ×2
62 m away ab-inbev
64 m away vtinfo
Phone
2489221700
vtinfono other value
Licences
mi-lcc L-000152752 · mi-lcc L-000152753
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of470b96728b7; O6b10edd67429; O61b342192a98; Ocb5526f0703c; O6ec6a20f13cf

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
2894683
6397 SASHABAW RD, CLARKSTON, MI, 4834642.73134, -83.379632026-11-112026-11-11
doordashhamlin pub independence charter township
238457
6397 Sashabaw Road, Independence charter Township, MI, 48346
ZIP lookup: Clarkston, MI
42.73174, -83.380172026-10-082026-11-16
mi-lccHAMLIN PUB
legal name: SASHABAW ROAD VENTURES, LLC
L-000152752
6397 Sashabaw Rd, Clarkston, MI, 48346248922170042.72750, -83.379372026-11-032026-11-05
mi-lccHAMLIN PUB
legal name: SASHABAW ROAD VENTURES, LLC
L-000152753
6397 Sashabaw Rd, Clarkston, MI, 48346248922170042.72750, -83.379372026-11-032026-11-05
overtureHamlin Pub
a8cdf811-f56d-489c-a53c-a6d94e863465
6397 Sashabaw Rd, Clarkston, MI, 48346248922170042.73172, -83.380142026-11-062026-11-06
vtinfoHAMLIN PUBS
26d31c1ad4700ba8
6397 SASHABAW RD, CLARKSTON, MI, 48346248922170042.73201, -83.380852026-11-152026-11-15

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 + ZIP · pins 124 m apart · name similarity 1.00
mi-lcc HAMLIN PUBmi-lcc HAMLIN PUB1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc HAMLIN PUBoverture Hamlin Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 473 m apart · name similarity 1.00 · phone: equal
mi-lcc HAMLIN PUBoverture Hamlin Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 473 m apart · name similarity 1.00 · phone: equal
ab-inbev HAMLIN PUBSmi-lcc HAMLIN PUB0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 428 m apart · name similarity 0.64
ab-inbev HAMLIN PUBSmi-lcc HAMLIN PUB0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 428 m apart · name similarity 0.64
ab-inbev HAMLIN PUBSoverture Hamlin Pub0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 59 m apart · name similarity 0.64
mi-lcc HAMLIN PUBvtinfo HAMLIN PUBS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 516 m apart · name similarity 0.64 · phone: equal
mi-lcc HAMLIN PUBvtinfo HAMLIN PUBS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 516 m apart · name similarity 0.64 · phone: equal
overture Hamlin Pubvtinfo HAMLIN PUBS0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 67 m apart · name similarity 0.64 · phone: equal
doordash hamlin pub independence charter townshipmi-lcc HAMLIN PUB0.40one name contains the other, same addressmergedjudge: None · pair_id: a5d26c144ce3cfc27ed4 · person: None · rule: names contained at one address · stratum: same-address
doordash hamlin pub independence charter townshipmi-lcc HAMLIN PUB0.40one name contains the other, same addressmergedjudge: None · pair_id: 94e94bfdaffa0d8191dd · person: None · rule: names contained at one address · stratum: same-address
ab-inbev HAMLIN PUBSdoordash hamlin pub independence charter township0.30one name contains the other, same addressmergedjudge: None · pair_id: dace4224b3ff93729aae · person: None · rule: names contained at one address · stratum: same-address
doordash hamlin pub independence charter townshipvtinfo HAMLIN PUBS0.30one name contains the other, same addressmergedjudge: None · pair_id: 7f7722cf62ce6c3ca390 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SASHABAW ROAD VENTURES, 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:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
53 within 1 mi · 183 within 3 mi
Off / on premise
11 / 31 within 1 mi · 41 / 100 within 3 mi
Selling alcohol
22 within 1 mi · 98 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
suburban (1,487 people per sq mi)
People within 3 mi
42,055 (30,653 adults 21+, 15,982 households) from 9 tract(s), tracts within 3 mi
Income
per capita $55,391 · median household ~$114,298 (weighted mean of tract medians)
Age and education
median age ~41.1 · bachelor's or higher 46%
Ethnicity
Hispanic 7% · White 84% · Black 3% · Asian 2%
Adults per alcohol outlet
310
Alcohol spend within 3 mi
$13,350,670 a year ($5,878,259 at home, $7,466,784 away) · $134,855 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-16 14:56insertab-inbev 2894683 ↔ doordash 238457one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 238457 ↔ vtinfo 26d31c1ad4700ba8one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 238457 ↔ mi-lcc L-000152753one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 238457 ↔ mi-lcc L-000152752one name contains the other, same addressmerged15
2026-11-15 16:24insertoverture a8cdf811-f56d-489c-a53c-a6d94e863465 ↔ vtinfo 26d31c1ad4700ba8same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000152752 ↔ vtinfo 26d31c1ad4700ba8same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000152753 ↔ vtinfo 26d31c1ad4700ba8same address and namemerged15
2026-11-15 16:24insertab-inbev 2894683 ↔ vtinfo 26d31c1ad4700ba8same address and namemerged15
2026-11-11 12:56insertab-inbev 2894683 ↔ overture a8cdf811-f56d-489c-a53c-a6d94e863465same address and namemerged12
2026-11-11 12:56insertab-inbev 2894683 ↔ mi-lcc L-000152752same address and namemerged12
2026-11-11 12:56insertab-inbev 2894683 ↔ mi-lcc L-000152753same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000152752 ↔ overture a8cdf811-f56d-489c-a53c-a6d94e863465same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000152753 ↔ overture a8cdf811-f56d-489c-a53c-a6d94e863465same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000152752 ↔ mi-lcc L-000152753one store listed twicemerged