Johnny Black's

Waterford, MI 48329 · O3224db4b3477 · first seen 2026-11-03
2 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
Johnny Black's 1 other
a licence name in capitals, cleaned (derived; record_title.py)
Md Waterford Inc overturemi-lcc (legal name) ×3
Street
5171 Dixie Hwy
mi-lccno other value
City
Waterford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48329
mi-lccno other value
Pin
42.69350, -83.39165 map 1 other
overture
56 m away mi-lcc ×2
Phone
none
no other value
Licences
mi-lcc L-000282085 · mi-lcc L-000282086
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O559394409771; O54265e98505f

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
mi-lccJOHNNY BLACK'S
legal name: MD WATERFORD INC.
L-000282085
5171 Dixie Hwy, Waterford, MI, 4832942.69373, -83.391052026-11-032026-11-06
mi-lccJOHNNY BLACK'S
legal name: MD WATERFORD INC.
L-000282086
5171 Dixie Hwy, Waterford, MI, 4832942.69373, -83.391052026-11-032026-11-06
overtureMd Waterford Inc
642b3e4b-9a67-480d-b60e-fa520c964d28
5171 Dixie Hwy, Waterford, MI, 4832942.69350, -83.391652026-11-062026-11-06

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
mi-lcc JOHNNY BLACK'Smi-lcc JOHNNY BLACK'S1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc JOHNNY BLACK'Soverture Md Waterford Inc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · matched through the licence's legal name: MD WATERFORD INC. · name similarity 1.00
mi-lcc JOHNNY BLACK'Soverture Md Waterford Inc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · matched through the licence's legal name: MD WATERFORD INC. · name similarity 1.00

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MD WATERFORD 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 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
62 within 1 mi · 258 within 3 mi
Off / on premise
16 / 37 within 1 mi · 60 / 145 within 3 mi
Selling alcohol
29 within 1 mi · 124 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.08 mi
Setting
suburban (1,831 people per sq mi)
People within 3 mi
51,762 (39,697 adults 21+, 21,784 households) from 13 tract(s), tracts within 3 mi
Income
per capita $45,501 · median household ~$85,247 (weighted mean of tract medians)
Age and education
median age ~41.5 · bachelor's or higher 33%
Ethnicity
Hispanic 7% · White 82% · Black 5% · Asian 2%
Adults per alcohol outlet
318
Alcohol spend within 3 mi
$15,044,501 a year ($6,897,096 at home, $8,140,671 away) · $120,356 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: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-06 18:13insertmi-lcc L-000282086 ↔ overture 642b3e4b-9a67-480d-b60e-fa520c964d28same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000282085 ↔ overture 642b3e4b-9a67-480d-b60e-fa520c964d28same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000282085 ↔ mi-lcc L-000282086one store listed twicemerged