The Sand Bar Pub & Grill

MIDDLEVILLE, MI 49333 · O08a1989295bb · first seen 2026-11-03
2 sourceson premise · predictedalcohol: 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
The Sand Bar Pub & Grill 2 other
a licence name in capitals, cleaned (derived; record_title.py)
DO BETTER BUSINESS CO mi-lcc (legal name) ×2
SAND BAR PUB & GRILL ab-inbev
Street
11368 W M 179 HWY 1 other
mi-lcc
11368 MICHIGAN 179 ab-inbev
City
MIDDLEVILLE
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49333
mi-lccno other value
Pin
42.63126, -85.51328 map 1 other
mi-lcc
55 m away ab-inbev
Phone
none
no other value
Licences
mi-lcc L-000461294 · mi-lcc L-000461295
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O99fa76b6c333; O66131dafab64

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-inbevSAND BAR PUB & GRILL
3421168
11368 MICHIGAN 179, MIDDLEVILLE, MI, 4933342.63176, -85.513322026-11-142026-11-18
mi-lccTHE SAND BAR PUB & GRILL
legal name: DO BETTER BUSINESS CO
L-000461294
11368 W M 179 HWY, MIDDLEVILLE, MI, 4933342.63126, -85.513282026-11-032026-11-05
mi-lccTHE SAND BAR PUB & GRILL
legal name: DO BETTER BUSINESS CO
L-000461295
11368 W M 179 HWY, MIDDLEVILLE, MI, 4933342.63126, -85.513282026-11-032026-11-05

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 SAND BAR PUB & GRILLmi-lcc THE SAND BAR PUB & GRILL1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same pub name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name the same pub and grill ('Sand Bar Pub & Grill') at the same street address in Middleville, MI 49333, with coordinates about 55 m apart; the Michigan record's legal entity is just the operator, and no other business shares the address.
pair fee4d0950dc957b212fe
ab-inbev SAND BAR PUB & GRILLmi-lcc THE SAND BAR PUB & GRILL1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name, same M-179 address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records give the same street address in Middleville, MI 49333 (11368 Michigan 179 / W M 179 Hwy) with nearly identical coordinates 0.055 km apart, and the names match closely as SAND BAR PUB & GRILL versus THE SAND BAR PUB & GRILL, with no other business at that address.
pair 1a4dac970b5dc052d1dd
mi-lcc THE SAND BAR PUB & GRILLmi-lcc THE SAND BAR PUB & GRILL1.00one store listed twicemergedsame street + ZIP · name: identical

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DO BETTER BUSINESS CO — 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": []
}

Trade area

Other outlets
4 within 1 mi · 17 within 3 mi
Off / on premise
0 / 1 within 1 mi · 3 / 5 within 3 mi
Selling alcohol
2 within 1 mi · 14 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.13 mi
Setting
rural (191 people per sq mi)
People within 3 mi
5,406 (4,059 adults 21+, 2,100 households) from 2 tract(s), tracts within 3 mi
Income
per capita $46,152 · median household ~$84,735 (weighted mean of tract medians)
Age and education
median age ~43.2 · bachelor's or higher 28%
Ethnicity
Hispanic 8% · White 86% · Black 1% · Asian 3%
Adults per alcohol outlet
271
Alcohol spend within 3 mi
$1,527,113 a year ($694,537 at home, $831,870 away) · $101,808 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 3421168 ↔ mi-lcc L-000461294Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3421168 ↔ mi-lcc L-000461295Claude judge: samemerged15
2026-11-03 13:33backfillmi-lcc L-000461294 ↔ mi-lcc L-000461295one store listed twicemerged