Cancun Mexican Grill

Saint Johns, MI 48879 · O560c881fa74f · first seen 2026-10-08
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
Cancun Mexican Grill 3 other
a licence name in capitals, cleaned (derived; record_title.py)
CANCUN-ST. JOHNS, INC. mi-lcc (legal name) ×2
Cancun Mexican Grill Saint Johns overture
cancun mexican grill saint johns saint johns doordash
Street
1067 S US 27 2 other
mi-lcc
1071 Old U.S. 27 doordashoverture ×2
1071 S US HWY 27 ab-inbev
City
Saint Johns 1 other
mi-lcc
St Johns overture
State
MI
mi-lccno other value
ZIP
48879
mi-lccno other value
Pin
42.99243, -84.54591 map 2 other
doordash
7.1 km away mi-lcc ×2
162 m away ab-inbev
Phone
9892275800
overtureno other value
Licences
mi-lcc L-000419253 · mi-lcc L-000419254
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob108cac24f49; Odf98820320be; Oac8486a4111d; O617b895f2af8

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-inbevCANCUN MEXICAN GRILL
3867265
1071 S US HWY 27, SAINT JOHNS, MI, 4887942.99117, -84.544912026-11-122026-11-12
doordashcancun mexican grill saint johns saint johns
25859075
1071 Old U.S. 27, Saint Johns, MI, 4887942.99243, -84.545912026-10-082026-11-12
mi-lccCANCUN MEXICAN GRILL
legal name: CANCUN-ST. JOHNS, INC.
L-000419253
1067 S US 27, Saint Johns, MI, 48879989227580042.92906, -84.541522026-11-032026-11-18
mi-lccCANCUN MEXICAN GRILL
legal name: CANCUN-ST. JOHNS, INC.
L-000419254
1067 S US 27, Saint Johns, MI, 48879989227580042.92906, -84.541522026-11-032026-11-18
overtureCancun Mexican Grill Saint Johns
6b402aed-1ac8-4b66-8676-6f46aff164ca
1071 Old U.S. 27, St Johns, MI, 48879989227580042.99243, -84.545902026-11-092026-11-12

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 CANCUN MEXICAN GRILLdoordash cancun mexican grill saint johns saint johns1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 162 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev CANCUN MEXICAN GRILLmi-lcc CANCUN MEXICAN GRILL1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Same name, near-identical address; distance likely geocode error.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records have the same name, CANCUN MEXICAN GRILL, in Saint Johns MI on the same highway (US 27) with street numbers 1067 and 1071 that differ only slightly, and the mi-lcc legal entity CANCUN-ST. JOHNS, INC. fits a single local restaurant; the 6.9 km coordinate gap is a geocoding discrepancy that leaves some doubt.
pair daa21492d569e17bf846
ab-inbev CANCUN MEXICAN GRILLmi-lcc CANCUN MEXICAN GRILL1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same distinctive name, adjacent street numbers, same city
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records carry the identical name CANCUN MEXICAN GRILL in the same city and ZIP on the same highway (1071 vs 1067 S US 27, a minor house-number discrepancy), with the MI-LCC legal entity CANCUN-ST. JOHNS, INC. plausibly behind the trade name; the 6.9 km coordinate gap weakens confidence, but it is likely a geocoding error and only one business is at that address.
pair 5ca54d353f21c53d3569
doordash cancun mexican grill saint johns saint johnsoverture Cancun Mexican Grill Saint Johns1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.91 · same street + ZIP · pins 1 m apart · name similarity 1.00
mi-lcc CANCUN MEXICAN GRILLmi-lcc CANCUN MEXICAN GRILL1.00one store listed twicemergedsame street + ZIP · name: identical

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CANCUN-ST. JOHNS, INC. — 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:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
48 within 1 mi · 53 within 3 mi
Off / on premise
16 / 25 within 1 mi · 17 / 27 within 3 mi
Selling alcohol
25 within 1 mi · 29 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
rural (376 people per sq mi)
People within 3 mi
10,637 (7,959 adults 21+, 4,409 households) from 3 tract(s), tracts within 3 mi
Income
per capita $40,015 · median household ~$67,204 (weighted mean of tract medians)
Age and education
median age ~44.7 · bachelor's or higher 27%
Ethnicity
Hispanic 3% · White 92% · Black 1% · Asian 1%
Adults per alcohol outlet
265
Alcohol spend within 3 mi
$2,678,595 a year ($1,255,469 at home, $1,421,942 away) · $89,286 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 3867265 ↔ mi-lcc L-000419253Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3867265 ↔ mi-lcc L-000419254Claude judge: samemerged15
2026-11-12 14:25insertab-inbev 3867265 ↔ doordash 25859075street written two waysmerged12
2026-11-09 15:32insertdoordash 25859075 ↔ overture 6b402aed-1ac8-4b66-8676-6f46aff164casame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000419253 ↔ mi-lcc L-000419254one store listed twicemerged