John's Bar & Grocery

Munger, MI 48747 · O45f2280993c1 · first seen 2026-11-03
4 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
John's Bar & Grocery 3 other
a licence name in capitals, cleaned (derived; record_title.py)
JOHNS BAR ab-inbevvtinfo ×2
RATAJCZAK, INC. mi-lcc (legal name) ×2
John's Bar & Party Store overture
Street
1478 S Tuscola Rd 1 other
mi-lcc
1476 S TUSCOLA RD ab-inbevoverturevtinfo ×3
City
Munger
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48747
mi-lccno other value
Pin
43.52262, -83.80775 map 2 other
overture
399 m away ab-inbev
430 m away vtinfo
Phone
9896592951
vtinfono other value
Licences
mi-lcc L-000001624 · mi-lcc L-000010593
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc75ee275a359; O8e9ad6c49031; Odf1cf317a4ca; O87988d394a32

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-inbevJOHNS BAR
2528458
1476 S TUSCOLA RD, MUNGER, MI, 4874743.51995, -83.804452026-11-112026-11-12
mi-lccJOHN'S BAR & GROCERY
legal name: RATAJCZAK, INC.
L-000001624
1478 S Tuscola Rd, Munger, MI, 4874798965929512026-11-032026-11-05
mi-lccJOHN'S BAR & GROCERY
legal name: RATAJCZAK, INC.
L-000010593
1478 S Tuscola Rd, Munger, MI, 4874798965929512026-11-032026-11-05
overtureJohn's Bar & Party Store
eecae6d5-cae6-4ce8-a857-d89cdd60010c
1476 S Tuscola Rd, Munger, MI, 48747989659295143.52262, -83.807752026-11-132026-11-13
vtinfoJOHNS BAR
9e75c17cb8d0fe4a
1476 S TUSCOLA RD, MUNGER, MI, 48747989659295143.51980, -83.804102026-11-152026-11-15

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
mi-lcc JOHN'S GROCERY & PARTY STOREvtinfo JOHNS BAR0.38Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Same phone and address, John's
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records sit at 1476 S Tuscola Rd, Munger, MI 48747 with the same phone number, and only one business is held at that address, so they are most likely one licensed premises; the names differ (grocery and party store versus 'JOHNS BAR'), which lowers confidence somewhat.
pair 66992b2694db54707c87
mi-lcc JOHN'S GROCERY & PARTY STOREvtinfo JOHNS BAR0.38Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Same address and phone; John's naming agrees.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records share the same street address, ZIP, and phone number, and only one business is held at that address, so the Michigan licence and the VTInfo account are very likely the same outlet despite the different trade names (John's Grocery & Party Store vs JOHNS BAR).
pair 4c455de433f8696b2f90
ab-inbev JOHNS BARvtinfo JOHNS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
mi-lcc JOHN'S BAR & GROCERYmi-lcc JOHN'S BAR & GROCERY1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev JOHNS BARoverture John's Bar & Party Store0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 399 m apart · name similarity 0.71
overture John's Bar & Party Storevtinfo JOHNS BAR0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 430 m apart · name similarity 0.71 · phone: equal
ab-inbev JOHNS BARmi-lcc JOHN'S BAR & GROCERY0.68Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
John's Bar adjacent street number, same name
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are in Munger, MI, on S Tuscola Rd with house numbers 1476 and 1478, and the names 'JOHNS BAR' and "JOHN'S BAR & GROCERY" match closely; the two-number address gap is minor and only one business is counted at the address, so this is most likely one bar-grocery operation.
pair 173ee863ca39f67fcd88
ab-inbev JOHNS BARmi-lcc JOHN'S BAR & GROCERY0.68Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
John's Bar matches, adjacent street numbers 1476/1478, same town.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name a single John's Bar in Munger, MI, 48747 on South Tuscola Road, with the AB InBev 'JOHNS BAR' matching the licence trade name 'JOHN'S BAR & GROCERY'; the house numbers differ by two (1476 vs 1478), which is most likely a numbering discrepancy for one bar, and only one differently named business is recorded at that address.
pair 1de08a167f8e74ad708c

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RATAJCZAK, INC. — 2 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": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
0 within 1 mi · 6 within 3 mi
Off / on premise
0 / 0 within 1 mi · 2 / 1 within 3 mi
Selling alcohol
0 within 1 mi · 6 within 3 mi
Nearest
same channel 1.45 mi · licensed 1.41 mi
Setting
rural (162 people per sq mi)
People within 3 mi
4,589 (3,595 adults 21+, 1,828 households) from 1 tract(s), tracts within 3 mi
Income
per capita $38,630 · median household ~$81,310 (weighted mean of tract medians)
Age and education
median age ~45.0 · bachelor's or higher 22%
Ethnicity
Hispanic 6% · White 95% · Black 0% · Asian 1%
Adults per alcohol outlet
514
Alcohol spend within 3 mi
$1,168,711 a year ($547,571 at home, $620,700 away) · $166,959 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-000011035 ↔ vtinfo 9e75c17cb8d0fe4aClaude judge: sameheld: same-source-conflict15
2026-11-18 18:58insertmi-lcc L-000014778 ↔ vtinfo 9e75c17cb8d0fe4aClaude judge: sameheld: same-source-conflict15
2026-11-15 16:24insertoverture eecae6d5-cae6-4ce8-a857-d89cdd60010c ↔ vtinfo 9e75c17cb8d0fe4asame address and namemerged15
2026-11-15 16:24insertab-inbev 2528458 ↔ vtinfo 9e75c17cb8d0fe4asame address and namemerged15
2026-11-13 14:10insertab-inbev 2528458 ↔ overture eecae6d5-cae6-4ce8-a857-d89cdd60010csame address and namemerged15
2026-11-12 17:29insertab-inbev 2528458 ↔ mi-lcc L-000010593Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2528458 ↔ mi-lcc L-000001624Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000001624 ↔ mi-lcc L-000010593one store listed twicemerged