Cranks Bar & Grill

SAINT CLAIR SHORES, MI 48082 · O30f068f2e3dc · first seen 2026-11-03
3 sourceson premise · predictedalcohol: licensed1 licence

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
Cranks Bar & Grill 1 other
a licence name in capitals, cleaned (derived; record_title.py)
CITY OF ST. CLAIR SHORES & CRANKS SERVICES LLC mi-lcc
Street
22185 Masonic Blvd
mi-lccno other value
City
St Clair Shores 1 other
mi-lcc
SAINT CLAIR SHORES ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48082
mi-lccno other value
Pin
42.53252, -82.89106 map 2 other
mi-lcc
282 m away ab-inbev
786 m away vtinfo
Phone
9544613992
vtinfono other value
Licences
mi-lcc L-000420329
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oac5060e9a90b; O8125b2a6a91e

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-inbevCRANKS BAR & GRILL
4278818
22185 MASONIC BLVD, SAINT CLAIR SHORES, MI, 4808242.53259, -82.894502026-11-112026-11-12
mi-lccCITY OF ST. CLAIR SHORES & CRANKS SERVICES LLC
L-000420329
22185 Masonic Blvd, St Clair Shores, MI, 4808242.53252, -82.891062026-11-032026-11-12
vtinfoCRANKS BAR & GRILL
5c3ec28f7ede462f
22185 MASONIC BLVD, SAINT CLAIR SHORES, MI, 48082954461399242.53935, -82.893542026-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 CRANKS BAR & GRILLvtinfo CRANKS BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 756 m apart · name similarity 1.00
ab-inbev CRANKS BAR & GRILLmi-lcc CITY OF ST. CLAIR SHORES & CRANKS SERVICES LLC0.29Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Cranks name in licence, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Record B's licensee name includes 'CRANKS SERVICES LLC' at the same street address, ZIP and city, and Cranks Bar & Grill matches A's name, so the bar operator is the same. The 'City of St. Clair Shores' part suggests a shared building, which lowers confidence somewhat.
pair 0eb51a7c5fbf83bb465a

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CITY OF ST. CLAIR SHORES & CRANKS SERVICES LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
55 within 1 mi · 432 within 3 mi
Off / on premise
21 / 22 within 1 mi · 149 / 195 within 3 mi
Selling alcohol
29 within 1 mi · 226 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.07 mi
Setting
urban (3,061 people per sq mi)
People within 3 mi
86,557 (67,561 adults 21+, 40,268 households) from 29 tract(s), tracts within 3 mi
Income
per capita $39,710 · median household ~$69,075 (weighted mean of tract medians)
Age and education
median age ~41.2 · bachelor's or higher 21%
Ethnicity
Hispanic 3% · White 75% · Black 17% · Asian 2%
Adults per alcohol outlet
298
Alcohol spend within 3 mi
$22,660,172 a year ($10,802,162 at home, $11,848,863 away) · $99,825 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-12 17:29insertab-inbev 4278818 ↔ mi-lcc L-000420329Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4278818 ↔ vtinfo 5c3ec28f7ede462fsame address and namemerged12