Johnny Blacks Public House

Rochester Hills, MI 48307 · O54c4e5fe5a57 · first seen 2026-10-08
5 sourceson premise · restaurantchain: Johnny Black's PUBLICHOUSE EASTalcohol: 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
Johnny Blacks Public House 3 other
a source's own spelling of the licence name (record_title.py)
JOHNNY BLACK'S PUBLIC HOUSE mi-lcc ×2
M & D AUBURN INVESTMENTS LLC mi-lcc (legal name) ×2
johnny black's public house rochester hills doordash
Street
1711 E Auburn Rd 1 other
mi-lcc
1711 East Auburn Road doordash
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.63793, -83.09797 map
doordashno other value
Phone
2482939000 1 other
vtinfo
2486064479 mi-lccoverture ×3
Licences
mi-lcc L-000224692 · mi-lcc L-000224693
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc7544a75d639; Od70829186754; O753b8f82823a; Oe54d993da8d2; O6c69644da156; Oa6639eb8c233

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-inbevJOHNNY BLACKS PUBLIC HOUSE
3564452
1711 E AUBURN RD, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
42.63789, -83.097542026-11-112026-11-11
doordashjohnny black's public house rochester hills
400170
1711 East Auburn Road, Rochester Hills, MI, 4830742.63793, -83.097972026-10-082026-11-11
mi-lccJOHNNY BLACK'S PUBLIC HOUSE
legal name: M & D AUBURN INVESTMENTS LLC
L-000224692
1711 E Auburn Rd, Rochester Hills, MI, 48307248606447942.63777, -83.097922026-11-032026-11-11
mi-lccJOHNNY BLACK'S PUBLIC HOUSE
legal name: M & D AUBURN INVESTMENTS LLC
L-000224693
1711 E Auburn Rd, Rochester Hills, MI, 48307248606447942.63777, -83.097922026-11-032026-11-11
overtureJohnny Blacks Public House
0745c4bb-010e-4dd6-ab58-f9bbb87f789d
1711 E Auburn Rd, Rochester Hills, MI, 48307248606447942.63782, -83.097952026-11-062026-11-11
vtinfoJOHNNY BLACKS PUBLIC HOUSE
2bc26bda156c3b75
1711 E AUBURN RD, ROCHESTER, MI248293900042.63804, -83.098012026-11-122026-11-18

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 JOHNNY BLACKS PUBLIC HOUSEmi-lcc JOHNNY BLACK'S PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ab-inbev JOHNNY BLACKS PUBLIC HOUSEmi-lcc JOHNNY BLACK'S PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ab-inbev JOHNNY BLACKS PUBLIC HOUSEoverture Johnny Blacks Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ab-inbev JOHNNY BLACKS PUBLIC HOUSEvtinfo JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
doordash johnny black's public house rochester hillsmi-lcc JOHNNY BLACK'S PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
doordash johnny black's public house rochester hillsmi-lcc JOHNNY BLACK'S PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
doordash johnny black's public house rochester hillsoverture Johnny Blacks Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEmi-lcc JOHNNY BLACK'S PUBLIC HOUSE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEoverture Johnny Blacks Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEoverture 3448fcb7-e031-48c3-a4a7-18df9a9bb9551.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · matched through the licence's legal name: M & D AUBURN INVESTMENTS LLC · name similarity 1.00
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEvtinfo JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 · phone: differs
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEoverture Johnny Blacks Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEoverture 3448fcb7-e031-48c3-a4a7-18df9a9bb9551.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · matched through the licence's legal name: M & D AUBURN INVESTMENTS LLC · name similarity 1.00
mi-lcc JOHNNY BLACK'S PUBLIC HOUSEvtinfo JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 · phone: differs
overture Johnny Blacks Public Housevtinfo JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00 · phone: differs
ab-inbev JOHNNY BLACKS PUBLIC HOUSEdoordash johnny black's public house rochester hills0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 35 m apart · name similarity 0.85
doordash johnny black's public house rochester hillsvtinfo JOHNNY BLACKS PUBLIC HOUSE0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 13 m apart · name similarity 0.85

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Johnny Black's PUBLICHOUSE EAST — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
M & D AUBURN INVESTMENTS 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 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
38 within 1 mi · 243 within 3 mi
Off / on premise
10 / 21 within 1 mi · 68 / 128 within 3 mi
Selling alcohol
16 within 1 mi · 120 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.06 mi
Setting
urban (3,163 people per sq mi)
People within 3 mi
89,426 (68,156 adults 21+, 35,704 households) from 19 tract(s), tracts within 3 mi
Income
per capita $50,302 · median household ~$105,307 (weighted mean of tract medians)
Age and education
median age ~42.5 · bachelor's or higher 48%
Ethnicity
Hispanic 4% · White 71% · Black 5% · Asian 16%
Adults per alcohol outlet
563
Alcohol spend within 3 mi
$27,759,019 a year ($12,431,205 at home, $15,316,116 away) · $229,413 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:23insertdoordash 400170 ↔ vtinfo 2bc26bda156c3b75same address and namemerged15
2026-11-14 20:23insertoverture 0745c4bb-010e-4dd6-ab58-f9bbb87f789d ↔ vtinfo 2bc26bda156c3b75same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000224693 ↔ vtinfo 2bc26bda156c3b75same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000224692 ↔ vtinfo 2bc26bda156c3b75same address and namemerged15
2026-11-12 14:25insertab-inbev 3564452 ↔ vtinfo 2bc26bda156c3b75same address and namemerged12
2026-11-11 12:56insertab-inbev 3564452 ↔ doordash 400170same address and namemerged12
2026-11-11 12:56insertab-inbev 3564452 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and namemerged12
2026-11-11 12:56insertab-inbev 3564452 ↔ mi-lcc L-000224693same address and namemerged12
2026-11-11 12:56insertab-inbev 3564452 ↔ mi-lcc L-000224692same address and namemerged12
2026-11-11 12:56insertdoordash 400170 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and namemerged12
2026-11-11 12:56insertdoordash 400170 ↔ mi-lcc L-000224693same address and namemerged12
2026-11-11 12:56insertdoordash 400170 ↔ mi-lcc L-000224692same address and namemerged12
2026-11-09 15:32updatemi-lcc L-000224693 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and namemerged11
2026-11-09 15:32updatemi-lcc L-000224692 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000224693 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000224693 ↔ overture 3448fcb7-e031-48c3-a4a7-18df9a9bb955same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000224692 ↔ overture 0745c4bb-010e-4dd6-ab58-f9bbb87f789dsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000224692 ↔ overture 3448fcb7-e031-48c3-a4a7-18df9a9bb955same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000224692 ↔ mi-lcc L-000224693one store listed twicemerged