Shogun Japanese and Chinese Bistro

Saint Clair Shores, MI 48080 · O151bf0422385 · 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
Shogun Japanese and Chinese Bistro 4 other
a source's own spelling of the licence name (record_title.py)
G G YUNG ENTERPRISES, INC. mi-lcc (legal name) ×2
SHOGUN JAPANESE/CHINESE BISTRO mi-lcc ×2
SHOGUN BISTRO ab-inbev
shogun chinese and japanese bistro saint clair shores doordash
Street
23195 Marter Rd 2 other
mi-lcc
23195 Marter Road doordash
23195 MARTER ST 100 ab-inbev
City
Saint Clair Shores 1 other
mi-lcc
St Clair Shores overture
State
MI
mi-lccno other value
ZIP
48080
mi-lccno other value
Pin
42.45996, -82.88284 map 1 other
doordash
67 m away mi-lcc ×2
Phone
5863500927 1 other
overture
5869445331 mi-lcc ×2
Licences
mi-lcc L-000184841 · mi-lcc L-000184842
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa65dcaaf2436; Ob5e44955eef6; Oceb40c6d064a; O56d6c32dd895

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-inbevSHOGUN BISTRO
3141313
23195 MARTER ST 100, SAINT CLAIR SHORES, MI, 4808042.45995, -82.882702026-11-132026-11-18
doordashshogun chinese and japanese bistro saint clair shores
215275
23195 Marter Road, Saint Clair Shores, MI, 4808042.45996, -82.882842026-10-082026-11-17
mi-lccSHOGUN JAPANESE/CHINESE BISTRO
legal name: G G YUNG ENTERPRISES, INC.
L-000184841
23195 Marter Rd, Saint Clair Shores, MI, 48080586944533142.45947, -82.883312026-11-032026-11-05
mi-lccSHOGUN JAPANESE/CHINESE BISTRO
legal name: G G YUNG ENTERPRISES, INC.
L-000184842
23195 Marter Rd, Saint Clair Shores, MI, 48080586944533142.45947, -82.883312026-11-032026-11-05
overtureShogun Japanese and Chinese Bistro
ab7e4fe0-9336-499d-b9df-6c0ab84aaf51
23195 Marter Rd, St Clair Shores, MI, 48080586350092742.45997, -82.882832026-11-062026-11-06

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
doordash shogun chinese and japanese bistro saint clair shoresmi-lcc SHOGUN JAPANESE/CHINESE BISTRO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 67 m apart · name similarity 1.00
doordash shogun chinese and japanese bistro saint clair shoresmi-lcc SHOGUN JAPANESE/CHINESE BISTRO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 67 m apart · name similarity 1.00
mi-lcc SHOGUN JAPANESE/CHINESE BISTROmi-lcc SHOGUN JAPANESE/CHINESE BISTRO1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SHOGUN JAPANESE/CHINESE BISTROoverture Shogun Japanese and Chinese Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00 · phone: differs
mi-lcc SHOGUN JAPANESE/CHINESE BISTROoverture Shogun Japanese and Chinese Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00 · phone: differs
doordash shogun chinese and japanese bistro saint clair shoresoverture Shogun Japanese and Chinese Bistro0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 2 m apart · name similarity 0.85
ab-inbev SHOGUN BISTROdoordash shogun chinese and japanese bistro saint clair shores0.55Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Same distinctive name Shogun bistro at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records sit at 23195 Marter (St/Road) in Saint Clair Shores 48080, about 12 m apart, with no other business at that address; the names 'SHOGUN BISTRO' and 'shogun chinese and japanese bistro' match, so they are most likely one restaurant listed on two platforms.
pair 744276b6c3aac361daf2
ab-inbev SHOGUN BISTROmi-lcc SHOGUN JAPANESE/CHINESE BISTRO0.55Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Same Shogun Bistro name at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Shogun bistro at the same street address (23195 Marter, Saint Clair Shores, MI 48080) with coordinates about 74 m apart, and no other business is held at that address, so the AB InBev account and the Michigan licence are the same restaurant.
pair b3c50e39d91007558bc3
ab-inbev SHOGUN BISTROmi-lcc SHOGUN JAPANESE/CHINESE BISTRO0.55Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Shogun bistro names match at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are the same bistro name (Shogun) at the same street address (23195 Marter, Saint Clair Shores, MI 48080) with coordinates about 74 m apart, and no other business is held at that address, so the AB InBev account and the Michigan liquor licence are one outlet.
pair 06d917f5850fc9b61b21

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
G G YUNG 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 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
64 within 1 mi · 338 within 3 mi
Off / on premise
13 / 25 within 1 mi · 96 / 159 within 3 mi
Selling alcohol
46 within 1 mi · 196 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.03 mi
Setting
suburban (2,695 people per sq mi)
People within 3 mi
76,203 (58,415 adults 21+, 33,093 households) from 26 tract(s), tracts within 3 mi
Income
per capita $46,826 · median household ~$87,594 (weighted mean of tract medians)
Age and education
median age ~43.2 · bachelor's or higher 38%
Ethnicity
Hispanic 3% · White 74% · Black 18% · Asian 2%
Adults per alcohol outlet
297
Alcohol spend within 3 mi
$22,392,764 a year ($10,287,057 at home, $12,095,816 away) · $113,669 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-19 20:37insertab-inbev 3141313 ↔ doordash 215275Claude judge: samemerged17
2026-11-18 18:58insertab-inbev 3141313 ↔ mi-lcc L-000184841Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3141313 ↔ mi-lcc L-000184842Claude judge: samemerged15
2026-11-17 17:19insertdoordash 215275 ↔ overture ab7e4fe0-9336-499d-b9df-6c0ab84aaf51same address and namemerged15
2026-11-16 14:56insertdoordash 215275 ↔ mi-lcc L-000184841same address and namemerged15
2026-11-16 14:56insertdoordash 215275 ↔ mi-lcc L-000184842same address and namemerged15
2026-11-06 18:13insertmi-lcc L-000184841 ↔ overture ab7e4fe0-9336-499d-b9df-6c0ab84aaf51same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000184842 ↔ overture ab7e4fe0-9336-499d-b9df-6c0ab84aaf51same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000184841 ↔ mi-lcc L-000184842one store listed twicemerged