Johnny Black's Public House

Waterford, MI 48329 · O06a197d72e7a · first seen 2026-10-08
5 sourceson premise · restaurantchain: Johnny Black's PUBLICHOUSE EASTalcohol: 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
Johnny Black's Public House 2 other
a source's own spelling of the licence name (record_title.py)
JOHNNY BLACKS PUBLIC HOUSE ab-inbevinspectionsvtinfo ×3
johnny black's public house waterford township doordash
Street
5171 Dixie Highway 1 other
doordash
5171 DIXIE HWY ab-inbevinspectionsoverturevtinfo ×4
City
Waterford Township 1 other
doordash
WATERFORD ab-inbevinspectionsoverturevtinfo ×4
State
MI
doordashno other value
ZIP
48329
doordashno other value
Pin
42.69360, -83.39169 map 1 other
doordash
60 m away inspections
Phone
2486183228 1 other
vtinfo
2485999001 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8c7966f20bac; O164145863160; O89efa1d858dd; O138cced72b0e

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
4192097
5171 DIXIE HWY, WATERFORD, MI, 4832942.69389, -83.391272026-11-112026-11-20
doordashjohnny black's public house waterford township
602096
5171 Dixie Highway, Waterford Township, MI, 48329
ZIP lookup: Waterford, MI
42.69360, -83.391692026-10-082026-11-20
inspectionsJOHNNY BLACKS PUBLIC HOUSE
inspections|mi|SFE-3963-234108
5171 DIXIE HWY, Waterford, MI, 4832942.69362, -83.390962026-11-202026-11-20
overtureJohnny Black's Public House
98c641f7-bd66-4293-a318-a2d25f2e2d68
5171 Dixie Hwy, Waterford, MI, 48329248599900142.69356, -83.391612026-11-062026-11-20
vtinfoJOHNNY BLACKS PUBLIC HOUSE
722e740f864aab5d
5171 DIXIE HWY, WATERFORD, MI, 48329248618322842.69351, -83.391662026-11-152026-11-20

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'S0.58one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: a709f7c7a70f06ad8017 · person: None · rule: names contained at one address · stratum: near
ab-inbev JOHNNY BLACKS PUBLIC HOUSEmi-lcc JOHNNY BLACK'S0.58one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d6e4ab19d4b798cc5d17 · person: None · rule: names contained at one address · stratum: near
mi-lcc JOHNNY BLACK'Svtinfo JOHNNY BLACKS PUBLIC HOUSE0.58one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d1aae01b1a214d789f53 · person: None · rule: names contained at one address · stratum: near
mi-lcc JOHNNY BLACK'Svtinfo JOHNNY BLACKS PUBLIC HOUSE0.58one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 571a5a0b0facdc033d4f · person: None · rule: names contained at one address · stratum: near
doordash johnny black's public house waterford townshipmi-lcc JOHNNY BLACK'S0.47one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: a39289dd0b59ed94589a · person: None · rule: names contained at one address · stratum: near
doordash johnny black's public house waterford townshipmi-lcc JOHNNY BLACK'S0.47one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: a4365eaa3f5aa9ffda8f · person: None · rule: names contained at one address · stratum: near
ab-inbev JOHNNY BLACKS PUBLIC HOUSEinspections JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
ab-inbev JOHNNY BLACKS PUBLIC HOUSEoverture Johnny Black's Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 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 + ZIP · pins 53 m apart · name similarity 1.00
inspections JOHNNY BLACKS PUBLIC HOUSEoverture Johnny Black's Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 53 m apart · name similarity 1.00
inspections JOHNNY BLACKS PUBLIC HOUSEvtinfo JOHNNY BLACKS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 59 m apart · name similarity 1.00
overture 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 8 m apart · name similarity 1.00 · phone: differs
ab-inbev JOHNNY BLACKS PUBLIC HOUSEdoordash johnny black's public house waterford township0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 47 m apart · name similarity 0.83
doordash johnny black's public house waterford townshipinspections JOHNNY BLACKS PUBLIC HOUSE0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 60 m apart · name similarity 0.83
doordash johnny black's public house waterford townshipoverture Johnny Black's Public House0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 8 m apart · name similarity 0.83
doordash johnny black's public house waterford townshipvtinfo JOHNNY BLACKS PUBLIC HOUSE0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 11 m apart · name similarity 0.83

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Johnny Black's PUBLICHOUSE EAST — overture-brand
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +12 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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-20 22:08insertdoordash 602096 ↔ inspections inspections|mi|SFE-3963-234108same address and namemerged17
2026-11-20 22:08insertab-inbev 4192097 ↔ inspections inspections|mi|SFE-3963-234108same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-234108 ↔ overture 98c641f7-bd66-4293-a318-a2d25f2e2d68same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-234108 ↔ vtinfo 722e740f864aab5dsame address and namemerged17
2026-11-16 14:56insertdoordash 602096 ↔ mi-lcc L-000282086one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertdoordash 602096 ↔ mi-lcc L-000282085one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4192097 ↔ mi-lcc L-000282086one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4192097 ↔ mi-lcc L-000282085one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertmi-lcc L-000282086 ↔ vtinfo 722e740f864aab5done name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertmi-lcc L-000282085 ↔ vtinfo 722e740f864aab5done name contains the other, same addressheld: same-source-conflict15
2026-11-15 16:24insertdoordash 602096 ↔ vtinfo 722e740f864aab5dsame address and namemerged15
2026-11-15 16:24insertab-inbev 4192097 ↔ vtinfo 722e740f864aab5dsame address and namemerged15
2026-11-15 16:24insertoverture 98c641f7-bd66-4293-a318-a2d25f2e2d68 ↔ vtinfo 722e740f864aab5dsame address and namemerged15
2026-11-11 12:56insertab-inbev 4192097 ↔ doordash 602096same address and namemerged12
2026-11-11 12:56insertab-inbev 4192097 ↔ overture 98c641f7-bd66-4293-a318-a2d25f2e2d68same address and namemerged12
2026-11-06 18:13insertdoordash 602096 ↔ overture 98c641f7-bd66-4293-a318-a2d25f2e2d68same address and namemerged11