Stoney Creek Roadhouse

Shelby Township, MI 48316 · O88d73e9b806b · 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
Stoney Creek Roadhouse 3 other
a licence name in capitals, cleaned (derived; record_title.py)
STONY CREEK ROADHOUSE mi-lccoverture ×3
M.C.J. ENTERPRISES, INC. mi-lcc (legal name) ×2
stony creek roadhouse shelby township doordash
Street
3000 26 Mile Rd 1 other
mi-lcc
3000 26 Mile Road doordash
City
Shelby Township 2 other
mi-lcc
UTICA ab-inbevvtinfo ×2
Shelby Twp overture
State
MI
mi-lccno other value
ZIP
48316
mi-lccno other value
Pin
42.71189, -83.08390 map 2 other
doordash
95 m away mi-lcc ×2
91 m away ab-inbev
Phone
5867819108
vtinfono other value
Licences
mi-lcc L-000013162 · mi-lcc L-000040843
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oba24b473a459; Oa6d1a6a8dc65; O9a4ee843fae7; O8ff50a9c15aa; Of6c474aed11e

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-inbevSTONEY CREEK ROADHOUSE
2763454
3000 26 MILE RD, UTICA, MI, 48316
ZIP lookup: Shelby Township, MI
42.71260, -83.083352026-11-112026-11-11
doordashstony creek roadhouse shelby township
1535197
3000 26 Mile Road, Shelby Township, MI, 4831642.71189, -83.083902026-10-082026-11-03
mi-lccSTONY CREEK ROADHOUSE
legal name: M.C.J. ENTERPRISES, INC.
L-000013162
3000 26 Mile Rd, Shelby Township, MI, 48316586781910842.71256, -83.084622026-11-032026-11-05
mi-lccSTONY CREEK ROADHOUSE
legal name: M.C.J. ENTERPRISES, INC.
L-000040843
3000 26 Mile Rd, Shelby Township, MI, 48316586781910842.71256, -83.084622026-11-032026-11-05
overtureStony Creek Roadhouse
f0b3c6f3-cbfc-459e-8d42-9b6bb1a74c97
3000 26 Mile Rd, Shelby Twp, MI, 48316
ZIP lookup: Shelby Township, MI
586781910842.71190, -83.083952026-11-062026-11-06
vtinfoSTONEY CREEK ROADHOUSE
7d5e1267c48c41d0
3000 26 MILE RD, UTICA, MI586781910842.71173, -83.083962026-11-182026-11-18

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 STONEY CREEK ROADHOUSEvtinfo STONEY CREEK ROADHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 109 m apart · name similarity 1.00
doordash stony creek roadhouse shelby townshipmi-lcc STONY CREEK ROADHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash stony creek roadhouse shelby townshipmi-lcc STONY CREEK ROADHOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc STONY CREEK ROADHOUSEmi-lcc STONY CREEK ROADHOUSE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc STONY CREEK ROADHOUSEoverture Stony Creek Roadhouse1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00 · phone: equal
mi-lcc STONY CREEK ROADHOUSEoverture Stony Creek Roadhouse1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00 · phone: equal
doordash stony creek roadhouse shelby townshipoverture Stony Creek Roadhouse0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 4 m apart · name similarity 0.79
ab-inbev STONEY CREEK ROADHOUSEmi-lcc STONY CREEK ROADHOUSE0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 104 m apart · name similarity 0.74
ab-inbev STONEY CREEK ROADHOUSEmi-lcc STONY CREEK ROADHOUSE0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 104 m apart · name similarity 0.74
ab-inbev STONEY CREEK ROADHOUSEoverture Stony Creek Roadhouse0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 92 m apart · name similarity 0.74
ab-inbev STONEY CREEK ROADHOUSEdoordash stony creek roadhouse shelby township0.52Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Stoney Creek Roadhouse spelling variant, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records give 3000 26 Mile Road, ZIP 48316, about 90 m apart, and the names are essentially the same (STONEY vs stony spelling, with the DoorDash slug adding the township), so this is one roadhouse; the shared building with one other business is outweighed by the close name match.
pair 1b084c1520039842178e

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
M.C.J. ENTERPRISES, 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 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2 within 1 mi · 139 within 3 mi
Off / on premise
0 / 0 within 1 mi · 36 / 77 within 3 mi
Selling alcohol
2 within 1 mi · 75 within 3 mi
Nearest
same channel 1.09 mi · licensed 0.57 mi
Setting
suburban (1,880 people per sq mi)
People within 3 mi
53,152 (40,502 adults 21+, 21,090 households) from 11 tract(s), tracts within 3 mi
Income
per capita $58,077 · median household ~$116,690 (weighted mean of tract medians)
Age and education
median age ~45.6 · bachelor's or higher 49%
Ethnicity
Hispanic 3% · White 88% · Black 2% · Asian 4%
Adults per alcohol outlet
533
Alcohol spend within 3 mi
$18,228,806 a year ($7,986,086 at home, $10,235,600 away) · $239,853 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 2763454 ↔ vtinfo 7d5e1267c48c41d0same address and namemerged15
2026-11-12 17:29insertab-inbev 2763454 ↔ doordash 1535197Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2763454 ↔ mi-lcc L-000013162same address and namemerged12
2026-11-11 12:56insertab-inbev 2763454 ↔ overture f0b3c6f3-cbfc-459e-8d42-9b6bb1a74c97same address and namemerged12
2026-11-11 12:56insertab-inbev 2763454 ↔ mi-lcc L-000040843same address and namemerged12
2026-11-06 18:13insertdoordash 1535197 ↔ overture f0b3c6f3-cbfc-459e-8d42-9b6bb1a74c97same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000013162 ↔ overture f0b3c6f3-cbfc-459e-8d42-9b6bb1a74c97same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000040843 ↔ overture f0b3c6f3-cbfc-459e-8d42-9b6bb1a74c97same address and namemerged11
2026-11-03 13:33backfilldoordash 1535197 ↔ mi-lcc L-000040843same address and namemerged
2026-11-03 13:33backfilldoordash 1535197 ↔ mi-lcc L-000013162same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000013162 ↔ mi-lcc L-000040843one store listed twicemerged