Johnny Blacks Shelby

Utica, MI 48315 · O029e3889e88f · 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 Shelby 4 other
a licence name in capitals, cleaned (derived; record_title.py)
JOHNNY BLACKS TAPHOUSE ab-inbevvtinfo ×2
M&D SHELBY LLC mi-lcc (legal name) ×2
johnny black's public house shelby township doordash
Johnny Black's Taphouse overture
Street
49035 Schoenherr Rd
mi-lccno other value
City
Utica 1 other
mi-lcc
Shelby Township doordashoverture ×2
State
MI
mi-lccno other value
ZIP
48315
mi-lccno other value
Pin
42.65609, -82.99468 map
doordashno other value
Phone
5867311990
vtinfono other value
Licences
mi-lcc L-000460100 · mi-lcc L-000460101
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4db2cfd94afa; O35fd573f26ca; Oeed18f6ac286; O18dc1df289fd; O31ff903f2f8e

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 TAPHOUSE
4732143
49035 SCHOENHERR RD, UTICA, MI, 4831542.65611, -82.994222026-11-112026-11-18
doordashjohnny black's public house shelby township
29718209
49035 Schoenherr Rd, Shelby Township, MI, 4831542.65609, -82.994682026-10-082026-11-18
mi-lccJOHNNY BLACKS SHELBY
legal name: M&D SHELBY LLC
L-000460100
49035 Schoenherr Rd, Utica, MI, 48315586731199042.65602, -82.994242026-11-032026-11-05
mi-lccJOHNNY BLACKS SHELBY
legal name: M&D SHELBY LLC
L-000460101
49035 Schoenherr Rd, Utica, MI, 48315586731199042.65602, -82.994242026-11-032026-11-05
overtureJohnny Black's Taphouse
fdde9ed2-6581-4d4f-8483-fe6f997bd67d
49035 Schoenherr Rd, Shelby Township, MI, 48315586731199042.65615, -82.994792026-11-132026-11-18
vtinfoJOHNNY BLACKS TAPHOUSE
1867c377311853d0
49035 SCHOENHERR RD, UTICA, MI, 48315586731199042.65605, -82.994632026-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 TAPHOUSEoverture Johnny Black's Taphouse1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00
ab-inbev JOHNNY BLACKS TAPHOUSEvtinfo JOHNNY BLACKS TAPHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
mi-lcc JOHNNY BLACKS SHELBYmi-lcc JOHNNY BLACKS SHELBY1.00one store listed twicemergedsame street + ZIP · name: identical
overture Johnny Black's Taphousevtinfo JOHNNY BLACKS TAPHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 · phone: equal
ab-inbev JOHNNY BLACKS TAPHOUSEmi-lcc JOHNNY BLACKS SHELBY0.63Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Johnny Blacks same address, location-name variant
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records sit at the same street address and ZIP (49035 Schoenherr Rd, 48315), 0.01 km apart, with no other business at that address, and both carry the distinctive 'JOHNNY BLACKS' brand, so they are one taphouse, with 'Shelby' likely the township name in the licensee's trade name.
pair 6883d2477c4e37f9f3f2
ab-inbev JOHNNY BLACKS TAPHOUSEmi-lcc JOHNNY BLACKS SHELBY0.63Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Johnny Blacks at same address; Shelby variant
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at the same street address and ZIP (49035 Schoenherr Rd, 48315), 10 m apart, with no other business at that address, and both carry the Johnny Blacks name; 'Shelby' reads as the township name, so this is one taphouse with its Michigan licence under the legal entity M&D Shelby LLC.
pair dcfaaa5bc2349911a012
mi-lcc JOHNNY BLACKS SHELBYvtinfo JOHNNY BLACKS TAPHOUSE0.63Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same address, phone, Johnny Blacks name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records share the same street address, ZIP, and identical phone number (5867311990), and the names match as a licensed legal entity M&D SHELBY LLC operating the trade name Johnny Blacks Shelby versus Johnny Blacks Taphouse, with no other businesses at the address and coordinates within 32 meters.
pair 0bd53b272d9e200b364e
mi-lcc JOHNNY BLACKS SHELBYvtinfo JOHNNY BLACKS TAPHOUSE0.63Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same name stem, address and phone.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records share the same street address, ZIP, and phone number (5867311990), with coordinates about 32 m apart and only one business at the address; record A's legal name M&D SHELBY LLC operates Johnny Blacks Shelby, and record B is the same taphouse listed under its trade name, so it is one outlet.
pair 8d937158ee7bdc8f9b6e
doordash johnny black's public house shelby townshipmi-lcc JOHNNY BLACKS SHELBY0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Johnny Black's same address, matching name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records sit at 49035 Schoenherr Rd, ZIP 48315, about 37 m apart, with no other business at that address, and the names 'johnny black's public house shelby township' and 'JOHNNY BLACKS SHELBY' match as the same bar/restaurant operation (the MI licence's legal entity M&D SHELBY LLC is consistent with a trade name).
pair 3855b8677b0b1ae4e944
doordash johnny black's public house shelby townshipmi-lcc JOHNNY BLACKS SHELBY0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Johnny Black's Shelby at identical address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 49035 Schoenherr Rd, ZIP 48315, about 37 meters apart, with only one business at the address, and the DoorDash slug 'johnny black's public house shelby township' matches the Michigan licence trade name 'JOHNNY BLACKS SHELBY' filed by M&D Shelby LLC.
pair a280d1bb0f84a5aa09f1
ab-inbev JOHNNY BLACKS TAPHOUSEdoordash johnny black's public house shelby township0.39Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Johnny Black's at identical address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records give the same street address (49035 Schoenherr Rd, ZIP 48315) with coordinates about 38 m apart, no other business is held at that address, and the names 'Johnny Blacks Taphouse' and 'johnny black's public house' are close variants of one bar/restaurant, though the DoorDash slug's city of Shelby Township versus Utica is a minor mismatch since both are in the same ZIP.
pair 501e9760a32875678216
doordash johnny black's public house shelby townshipvtinfo JOHNNY BLACKS TAPHOUSE0.39Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Johnny Black's name and address match
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at the same street address (49035 Schoenherr Rd, ZIP 48315) with coordinates about 6 m apart, and the names are essentially the same venue, Johnny Black's public house/Johnny Blacks Taphouse; the address is the only building at that address in our data, so the match is strong despite the DoorDash record's city being Shelby Township versus Utica on the VTInfo record, which is a common postal/township discrepancy.
pair 1a2581cd7725bf30dece

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 SHELBY 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:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
31 within 1 mi · 475 within 3 mi
Off / on premise
6 / 22 within 1 mi · 122 / 266 within 3 mi
Selling alcohol
14 within 1 mi · 238 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.06 mi
Setting
suburban (2,944 people per sq mi)
People within 3 mi
83,246 (63,507 adults 21+, 33,053 households) from 18 tract(s), tracts within 3 mi
Income
per capita $43,626 · median household ~$92,256 (weighted mean of tract medians)
Age and education
median age ~45.4 · bachelor's or higher 34%
Ethnicity
Hispanic 2% · White 87% · Black 4% · Asian 4%
Adults per alcohol outlet
266
Alcohol spend within 3 mi
$23,824,182 a year ($10,856,279 at home, $12,956,977 away) · $99,683 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-18 18:58insertab-inbev 4732143 ↔ doordash 29718209Claude judge: samemerged15
2026-11-18 18:58insertdoordash 29718209 ↔ vtinfo 1867c377311853d0Claude judge: samemerged15
2026-11-18 18:58insertdoordash 29718209 ↔ mi-lcc L-000460101Claude judge: samemerged15
2026-11-18 18:58insertdoordash 29718209 ↔ mi-lcc L-000460100Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4732143 ↔ mi-lcc L-000460101Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000460101 ↔ vtinfo 1867c377311853d0Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4732143 ↔ mi-lcc L-000460100Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000460100 ↔ vtinfo 1867c377311853d0Claude judge: samemerged15
2026-11-14 20:23insertoverture fdde9ed2-6581-4d4f-8483-fe6f997bd67d ↔ vtinfo 1867c377311853d0same address and namemerged15
2026-11-13 14:10insertab-inbev 4732143 ↔ overture fdde9ed2-6581-4d4f-8483-fe6f997bd67dsame address and namemerged15
2026-11-12 14:25insertab-inbev 4732143 ↔ vtinfo 1867c377311853d0same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000460100 ↔ mi-lcc L-000460101one store listed twicemerged