TAPPER'S PUB

Rochester Hills, MI 48307 · O0a5e74f84c9a · first seen 2026-11-03
4 sourceson premise · baralcohol: 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
TAPPER'S PUB 2 other
the most common name a source states
HEMBREE HOUSE, INC. mi-lcc (legal name) ×2
TAPPERS PUB ab-inbevvtinfo ×2
Street
877 E Auburn Rd 1 other
mi-lcc
877 E AUBURN AVE ab-inbevvtinfo ×2
City
Rochester Hills 1 other
mi-lcc
ROCHESTER ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48307
mi-lccno other value
Pin
42.63781, -83.11353 map 3 other
overture
122 m away mi-lcc ×2
108 m away ab-inbev
113 m away vtinfo
Phone
2488521983
vtinfono other value
Licences
mi-lcc L-000232852 · mi-lcc L-000232853
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7eb9db1f2650; O482c2ca3feed; Odc90446b5884; O262b899d9f5a

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-inbevTAPPERS PUB
2763532
877 E AUBURN AVE, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
42.63702, -83.112762026-11-112026-11-11
mi-lccTAPPER'S PUB
legal name: HEMBREE HOUSE, INC.
L-000232852
877 E Auburn Rd, Rochester Hills, MI, 48307248852198342.63673, -83.113322026-11-032026-11-06
mi-lccTAPPER'S PUB
legal name: HEMBREE HOUSE, INC.
L-000232853
877 E Auburn Rd, Rochester Hills, MI, 48307248852198342.63673, -83.113322026-11-032026-11-06
overtureTapper's Pub
6ba468fc-62f0-46b4-a144-d48abf45d8ae
877 E Auburn Rd, Rochester Hills, MI, 48307248852198342.63781, -83.113532026-11-062026-11-06
vtinfoTAPPERS PUB
529c0e5a13054e81
877 E AUBURN AVE, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
248852198342.63680, -83.113562026-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
mi-lcc TAPPER'S PUBoverture 31c57b24-ac66-46ea-bbe3-229847b2aa791.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · matched through the licence's legal name: HEMBREE HOUSE, INC. · name similarity 1.00
mi-lcc TAPPER'S PUBoverture 31c57b24-ac66-46ea-bbe3-229847b2aa791.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · matched through the licence's legal name: HEMBREE HOUSE, INC. · name similarity 1.00
ab-inbev TAPPERS PUBmi-lcc TAPPER'S PUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 56 m apart · name similarity 1.00 · street similarity 0.78
ab-inbev TAPPERS PUBmi-lcc TAPPER'S PUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 56 m apart · name similarity 1.00 · street similarity 0.78
ab-inbev TAPPERS PUBoverture Tapper's Pub1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 108 m apart · name similarity 1.00 · street similarity 0.78
ab-inbev TAPPERS PUBvtinfo TAPPERS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 70 m apart · name similarity 1.00
mi-lcc TAPPER'S PUBmi-lcc TAPPER'S PUB1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc TAPPER'S PUBoverture Tapper's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 122 m apart · name similarity 1.00 · phone: equal
mi-lcc TAPPER'S PUBoverture Tapper's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 122 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HEMBREE HOUSE, INC. — 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": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
71 within 1 mi · 249 within 3 mi
Off / on premise
22 / 39 within 1 mi · 68 / 128 within 3 mi
Selling alcohol
27 within 1 mi · 122 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.10 mi
Setting
suburban (2,407 people per sq mi)
People within 3 mi
68,062 (51,181 adults 21+, 27,221 households) from 16 tract(s), tracts within 3 mi
Income
per capita $51,926 · median household ~$109,849 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 52%
Ethnicity
Hispanic 4% · White 68% · Black 5% · Asian 17%
Adults per alcohol outlet
416
Alcohol spend within 3 mi
$21,689,810 a year ($9,655,526 at home, $12,025,623 away) · $176,340 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:25insertab-inbev 2763532 ↔ vtinfo 529c0e5a13054e81same address and namemerged12
2026-11-11 12:56insertab-inbev 2763532 ↔ mi-lcc L-000232852street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763532 ↔ mi-lcc L-000232853street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763532 ↔ overture 6ba468fc-62f0-46b4-a144-d48abf45d8aestreet written two waysmerged12
2026-11-06 18:13insertmi-lcc L-000232852 ↔ overture 31c57b24-ac66-46ea-bbe3-229847b2aa79same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000232852 ↔ overture 6ba468fc-62f0-46b4-a144-d48abf45d8aesame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000232853 ↔ overture 31c57b24-ac66-46ea-bbe3-229847b2aa79same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000232853 ↔ overture 6ba468fc-62f0-46b4-a144-d48abf45d8aesame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000232852 ↔ mi-lcc L-000232853one store listed twicemerged