Mr B's Pub

Utica, MI 48317 · O142c094c8c83 · first seen 2026-10-08
5 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
Mr B's Pub 5 other
a licence name in capitals, cleaned (derived; record_title.py)
MR BS PUB ab-inbevvtinfo ×2
MR. B'S SHELBY mi-lcc ×2
SHELBY K-D, LLC mi-lcc (legal name) ×2
Mr. B's. Bar And Grill overture
mr. bs shelby shelby township doordash
Street
48560 Van Dyke Ave 1 other
mi-lcc
48550 VAN DYKE AVE ab-inbevdoordashoverturevtinfo ×4
City
Utica 1 other
mi-lcc
Shelby Township doordashoverture ×2
State
MI
mi-lccno other value
ZIP
48317
mi-lccno other value
Pin
42.65185, -83.03281 map 1 other
doordash
55 m away ab-inbev
Phone
5867310700 1 other
vtinfo
8107310770 overture
Licences
mi-lcc L-000229629 · mi-lcc L-000229630
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeb21aa6a68bf; Oe9057d33b285; Off61401e0fcd; Oaa6b8146c59d; Obe2dc211453b

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-inbevMR BS PUB
2551837
48550 VAN DYKE AVE, UTICA, MI, 4831742.65223, -83.033252026-11-112026-11-12
doordashmr. bs shelby shelby township
37155819
48550 Van Dyke Ave, Shelby Township, MI42.65185, -83.032812026-10-082026-11-18
mi-lccMR. B'S SHELBY
legal name: SHELBY K-D, LLC
L-000229629
48560 Van Dyke Ave, Utica, MI, 48317586731070042.65187, -83.033252026-11-032026-11-18
mi-lccMR. B'S SHELBY
legal name: SHELBY K-D, LLC
L-000229630
48560 Van Dyke Ave, Utica, MI, 48317586731070042.65187, -83.033252026-11-032026-11-18
overtureMr. B's. Bar And Grill
b6465767-5b9c-4abb-b766-bf0dc6d75bbc
48550 Van Dyke Ave, Shelby Township, MI, 48317810731077042.65189, -83.033032026-11-132026-11-13
vtinfoMR BS PUB
16c6fd70fada0314
48550 VAN DYKE AVE, UTICA, MI, 48317586731070042.65184, -83.032712026-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
ab-inbev MR BS PUBvtinfo MR BS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 62 m apart · name similarity 1.00
mi-lcc MR. B'S SHELBYmi-lcc MR. B'S SHELBY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc MR. B'S SHELBYvtinfo MR BS PUB0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same phone, Mr B's name, adjacent street number.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records share the same phone number (5867310700), the coordinates are about 44 m apart, and both carry the Mr. B's name (MR. B'S SHELBY vs MR BS PUB) in Utica, MI, so they likely describe one pub-and-liquor operation, though the street numbers differ (48560 vs 48550).
pair 6b3aad78e590df9b3f4f
mi-lcc MR. B'S SHELBYvtinfo MR BS PUB0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Same phone, Mr B's name, adjacent street numbers.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records share the same phone number (5867310700), the names are the same bar (Mr. B's Shelby / Mr B's Pub), the coordinates are about 44 m apart, and the ZIP matches; the only mismatch is a 10-number difference in street address (48560 vs 48550), which is likely a numbering quirk for one building.
pair ddbe24887f1ea6e9fb5d
doordash mr. bs shelby shelby townshipoverture Mr. B's. Bar And Grill0.50same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.65 · same street + city + state · pins 18 m apart · name similarity 0.50
ab-inbev MR BS PUBoverture Mr. B's. Bar And Grill0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, pub · name Jaro-Winkler 0.62 · same street + ZIP · pins 42 m apart · name similarity 0.41
overture Mr. B's. Bar And Grillvtinfo MR BS PUB0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, pub · name Jaro-Winkler 0.62 · same street + ZIP · pins 27 m apart · name similarity 0.41 · phone: differs

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SHELBY K-D, 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
55 within 1 mi · 421 within 3 mi
Off / on premise
8 / 35 within 1 mi · 112 / 234 within 3 mi
Selling alcohol
26 within 1 mi · 202 within 3 mi
Nearest
same channel 0.10 mi · licensed 0.01 mi
Setting
suburban (2,866 people per sq mi)
People within 3 mi
81,023 (62,720 adults 21+, 34,726 households) from 18 tract(s), tracts within 3 mi
Income
per capita $43,519 · median household ~$81,858 (weighted mean of tract medians)
Age and education
median age ~44.3 · bachelor's or higher 33%
Ethnicity
Hispanic 4% · White 83% · Black 4% · Asian 5%
Adults per alcohol outlet
309
Alcohol spend within 3 mi
$23,188,556 a year ($10,657,888 at home, $12,520,582 away) · $114,229 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:58insertmi-lcc L-000229630 ↔ vtinfo 16c6fd70fada0314Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000229629 ↔ vtinfo 16c6fd70fada0314Claude judge: samemerged15
2026-11-18 18:58insertdoordash 37155819 ↔ overture b6465767-5b9c-4abb-b766-bf0dc6d75bbcsame address and namemerged15
2026-11-14 20:23insertoverture b6465767-5b9c-4abb-b766-bf0dc6d75bbc ↔ vtinfo 16c6fd70fada0314same address and namemerged15
2026-11-13 14:10insertab-inbev 2551837 ↔ overture b6465767-5b9c-4abb-b766-bf0dc6d75bbcsame address and namemerged15
2026-11-12 14:25insertab-inbev 2551837 ↔ vtinfo 16c6fd70fada0314same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000229629 ↔ mi-lcc L-000229630one store listed twicemerged