Outlets /
HAMLIN PUBS
ROCHESTER, MI 48307 · O3b2ac60174a1 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed1 licence
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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | HAMLIN PUBS 3 other | the most common name a source states | HAMLIN PUB mi-lccoverture ×2 hamlin pub rochester hills doordash HAMLIN PUB, L.L.C. mi-lcc (legal name) |
| Street | 1988 S Rochester Rd 1 other | mi-lcc | 1988 South Rochester Road doordash |
| City | Rochester 1 other | mi-lcc | Rochester Hills doordashoverture ×2 |
| State | MI | mi-lcc | no other value |
| ZIP | 48307 | mi-lcc | no other value |
| Pin | 42.65280, -83.13397 map 2 other | doordash | 72 m away ab-inbev 288 m away mi-lcc |
| Phone | 2486567700 | vtinfo | no other value |
| Licences | mi-lcc L-000106918 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O8c9c9832b77a; O57325f069fcd; Oa6fee3921aa2; O78b8b6ed454a
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | HAMLIN PUBS 2763431 | 1988 S ROCHESTER RD, ROCHESTER, MI, 48307 ZIP lookup: Rochester Hills, MI | 42.65345, -83.13387 | 2026-11-11 | 2026-11-11 | |
| doordash | hamlin pub rochester hills 203892 | 1988 South Rochester Road, Rochester Hills, MI, 48307 | 42.65280, -83.13397 | 2026-10-08 | 2026-11-10 | |
| mi-lcc | HAMLIN PUB legal name: HAMLIN PUB, L.L.C. L-000106918 | 1988 S Rochester Rd, Rochester, MI, 48307 ZIP lookup: Rochester Hills, MI | 2486567700 | 42.65526, -83.13283 | 2026-11-03 | 2026-11-09 |
| overture | Hamlin Pub 340cd414-8f8d-4183-9c79-344b2ae075c5 | 1988 S Rochester Rd, Rochester Hills, MI, 48307 | 2486567700 | 42.65282, -83.13389 | 2026-11-06 | 2026-11-09 |
| vtinfo | HAMLIN PUBS 1af029cdb2fb62be | 1988 S ROCHESTER RD, ROCHESTER, MI, 48307 ZIP lookup: Rochester Hills, MI | 2486567700 | 42.65279, -83.13388 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev HAMLIN PUBS | vtinfo HAMLIN PUBS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 74 m apart · name similarity 1.00 |
| doordash hamlin pub rochester hills | overture Hamlin Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 |
| mi-lcc HAMLIN PUB | overture Hamlin Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 284 m apart · name similarity 1.00 · phone: equal |
| doordash hamlin pub rochester hills | mi-lcc HAMLIN PUB | 0.72 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 288 m apart · name similarity 0.72 |
| ab-inbev HAMLIN PUBS | mi-lcc HAMLIN PUB | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 218 m apart · name similarity 0.64 |
| ab-inbev HAMLIN PUBS | overture Hamlin Pub | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 70 m apart · name similarity 0.64 |
| mi-lcc HAMLIN PUB | vtinfo HAMLIN PUBS | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 288 m apart · name similarity 0.64 · phone: equal |
| overture Hamlin Pub | vtinfo HAMLIN PUBS | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 4 m apart · name similarity 0.64 · phone: equal |
Attributes
- Channel
- on_premise · restaurant — doordash-url
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- HAMLIN PUB, L.L.C. — 1 outlets in the master under this operator
- Licence privileges
- beer_on, wine_on, spirits_on — 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
- 58 within 1 mi · 359 within 3 mi
- Off / on premise
- 24 / 23 within 1 mi · 86 / 195 within 3 mi
- Selling alcohol
- 27 within 1 mi · 177 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.08 mi
- Setting
- suburban (2,161 people per sq mi)
- People within 3 mi
- 61,101 (45,223 adults 21+, 25,007 households) from 16 tract(s), tracts within 3 mi
- Income
- per capita $57,341 · median household ~$111,024 (weighted mean of tract medians)
- Age and education
- median age ~40.0 · bachelor's or higher 59%
- Ethnicity
- Hispanic 5% · White 71% · Black 5% · Asian 15%
- Adults per alcohol outlet
- 254
- Alcohol spend within 3 mi
- $20,667,300 a year ($9,120,932 at home, $11,538,122 away) · $116,108 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-14 20:23 | insert | overture 340cd414-8f8d-4183-9c79-344b2ae075c5 ↔ vtinfo 1af029cdb2fb62be | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | mi-lcc L-000106918 ↔ vtinfo 1af029cdb2fb62be | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2763431 ↔ vtinfo 1af029cdb2fb62be | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2763431 ↔ overture 340cd414-8f8d-4183-9c79-344b2ae075c5 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2763431 ↔ mi-lcc L-000106918 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 203892 ↔ mi-lcc L-000106918 | same address and name | merged | 12 |
| 2026-11-09 14:23 | insert | doordash 203892 ↔ overture 340cd414-8f8d-4183-9c79-344b2ae075c5 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000106918 ↔ overture 340cd414-8f8d-4183-9c79-344b2ae075c5 | same address and name | merged | 11 |