Shogun

Sterling Heights, MI 48312 · O24fddbbef763 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Shogun 4 other
the most common name a source states
KIRIN, INC. mi-lcc (legal name)
shogun chinese and japanese bistro sterling heights doordash
SHOGUN JAPANESE STEAK HOU ab-inbev
SHOGUN JAPANESE STEAK HOUSE mi-lcc
Street
37750 Van Dyke Ave 2 other
mi-lcc
37750 VAN DYKE ab-inbev
37750 Van Dyke Avenue doordash
City
Sterling Heights
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48312
mi-lccno other value
Pin
42.57169, -83.02887 map 3 other
ubereats
57 m away doordash
70 m away mi-lcc
71 m away overture
Phone
5862684882
overtureno other value
Licences
mi-lcc L-000001408
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of8732b800887; O6d45bb643d69; Of8b29d6038d9; O2b387fa03498

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 JAPANESE STEAK HOU
2967490
37750 VAN DYKE, STERLING HEIGHTS, MI, 4831242.57181, -83.028332026-11-132026-11-13
doordashshogun chinese and japanese bistro sterling heights
1596584
37750 Van Dyke Avenue, Sterling Heights, MI, 4831242.57169, -83.028182026-10-082026-11-18
mi-lccSHOGUN JAPANESE STEAK HOUSE
legal name: KIRIN, INC.
L-000001408
37750 Van Dyke Ave, Sterling Heights, MI, 48312586268488242.57154, -83.029702026-11-032026-11-18
overtureShogun
0060e7ed-2783-4664-b42b-5eb0ffe898b0
37750 Van Dyke Ave, Sterling Heights, MI, 48312586268488242.57171, -83.028002026-11-062026-11-18
ubereatsShogun
WpDgYsgSReumDmRtPpFO1A
37750 Van Dyke Ave, Sterling Heights, MI, 4831242.57169, -83.028872026-10-292026-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
overture Shogunubereats Shogun1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00
ab-inbev SHOGUN JAPANESE STEAK HOUmi-lcc SHOGUN JAPANESE STEAK HOUSE0.78Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same restaurant name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name the same Japanese steak house (SHOGUN, truncated in the AB InBev record) at 37750 Van Dyke in Sterling Heights, MI and ZIP 48312, with coordinates about 0.12 km apart and no other business at that address.
pair 9545877d31682310b748
ab-inbev SHOGUN JAPANESE STEAK HOUdoordash shogun chinese and japanese bistro sterling heights0.48Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
Shogun at same address; naming variation of one restaurant.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 37750 Van Dyke in Sterling Heights, 18 m apart, with only one business at that address, and both carry the same Shogun Japanese name, so they are most likely one restaurant listed by a beer distributor and a delivery app.
pair a2f86ec5a51cbc3f7b5c
ab-inbev SHOGUN JAPANESE STEAK HOUubereats Shogun0.32Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Shogun at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 37750 Van Dyke in Sterling Heights with the same ZIP and nearly identical coordinates (0.046 km apart), and the names 'SHOGUN JAPANESE STEAK HOU' and 'Shogun' are the same restaurant under truncated and short forms; only one business is recorded at that address.
pair 2afbc940045fe9a0f6cd
mi-lcc SHOGUN JAPANESE STEAK HOUSEubereats Shogun0.31one name contains the other, same addressmergedjudge: None · pair_id: f555c551696d897f3c26 · person: None · rule: names contained at one address · stratum: same-address
doordash shogun chinese and japanese bistro sterling heightsoverture Shogun0.29same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bistro, chinese, japanese · name Jaro-Winkler 0.52 · same street + ZIP · pins 15 m apart · name similarity 0.29
doordash shogun chinese and japanese bistro sterling heightsubereats Shogun0.29Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “same-address” pair)
Both records name the same street address (37750 Van Dyke) in Sterling Heights, the names agree once DoorDash's appended city is dropped ('Shogun'), and only one business is known at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address (37750 Van Dyke Ave, Sterling Heights, MI 48312), only one business is recorded at that address, coordinates are within about 60 metres, and the names match as 'Shogun' with the DoorDash slug adding the descriptive words 'chinese and japanese bistro'.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give the same street address, ZIP and city (37750 Van Dyke Ave, Sterling Heights 48312), the only business at that address in the data, with coordinates 0.057 km apart and the name 'Shogun' matching the DoorDash slug 'shogun chinese and japanese bistro'.
pair 1b5c22c7aaea949d50cb

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
KIRIN, INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
43 within 1 mi · 335 within 3 mi
Off / on premise
11 / 27 within 1 mi · 91 / 175 within 3 mi
Selling alcohol
19 within 1 mi · 155 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
urban (3,810 people per sq mi)
People within 3 mi
107,728 (82,499 adults 21+, 40,339 households) from 25 tract(s), tracts within 3 mi
Income
per capita $37,113 · median household ~$79,927 (weighted mean of tract medians)
Age and education
median age ~41.1 · bachelor's or higher 30%
Ethnicity
Hispanic 3% · White 77% · Black 7% · Asian 9%
Adults per alcohol outlet
532
Alcohol spend within 3 mi
$26,174,778 a year ($12,125,850 at home, $14,036,519 away) · $168,870 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 2967490 ↔ ubereats WpDgYsgSReumDmRtPpFO1AClaude judge: samemerged15
2026-11-18 18:58insertab-inbev 2967490 ↔ doordash 1596584Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 2967490 ↔ mi-lcc L-000001408Claude judge: samemerged15
2026-11-16 14:56insertmi-lcc L-000001408 ↔ ubereats WpDgYsgSReumDmRtPpFO1Aone name contains the other, same addressmerged15
2026-11-12 17:29insertdoordash 1596584 ↔ overture 0060e7ed-2783-4664-b42b-5eb0ffe898b0same address and namemerged14
2026-11-11 12:56insertdoordash 1596584 ↔ ubereats WpDgYsgSReumDmRtPpFO1AClaude judge: samemerged12
2026-11-06 18:13insertoverture 0060e7ed-2783-4664-b42b-5eb0ffe898b0 ↔ ubereats WpDgYsgSReumDmRtPpFO1Asame address and namemerged11