Shogun Restaurant

PASADENA, CA 91107 · O2472ef467057 · first seen 2026-10-08
5 sourceson premise · restaurantchain: Shogun 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 Restaurant 3 other
a source's own spelling of the licence name (record_title.py)
SHIN NIHON KOSAN INC ca-abc (legal name) ×2
SHOGUN TEPPAN STEAK & SUSHI ab-inbevvtinfo ×2
shogun restaurant pasadena doordash
Street
470 N HALSTEAD ST 1 other
ca-abc
470 N HALSTEAD AVE ab-inbevvtinfo ×2
City
PASADENA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91107
ca-abcno other value
Pin
34.15432, -118.07902 map
doordashno other value
Phone
6263518945
vtinfono other value
Licences
ca-abc 00081714|47|APP|0 · ca-abc 00081714|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe1e6b6cbc9f0; O91d7e4ae4439; O8e7b43fdbe92; Od0276be8adda; O8df5127d0914

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 TEPPAN STEAK & SUSHI
2214411
470 N HALSTEAD AVE, PASADENA, CA, 9110734.15409, -118.079382026-11-112026-11-12
ca-abcSHOGUN RESTAURANT
legal name: SHIN NIHON KOSAN INC
00081714|47|APP|0
470 N HALSTEAD ST, PASADENA, CA, 9110734.15418, -118.079342026-10-082026-11-05
ca-abcSHOGUN RESTAURANT
legal name: SHIN NIHON KOSAN INC
00081714|47|LIC|0
470 N HALSTEAD ST, PASADENA, CA, 9110734.15418, -118.079342026-10-082026-11-05
doordashshogun restaurant pasadena
30883725
470 N Halstead St, Pasadena, CA, 9110734.15432, -118.079022026-10-082026-11-11
overtureShogun Restaurant
56a0a5e6-c733-4498-b299-e0b37c2fc14a
470 N Halstead St, Pasadena, CA, 91107626351894534.15428, -118.079032026-11-062026-11-06
vtinfoSHOGUN TEPPAN STEAK & SUSHI
9ea7fd756c6cd88e
470 N HALSTEAD AVE, PASADENA, CA, 91107626351894534.15417, -118.079072026-11-122026-11-13

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 SHOGUN TEPPAN STEAK & SUSHIvtinfo SHOGUN TEPPAN STEAK & SUSHI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
ca-abc SHOGUN RESTAURANTca-abc SHOGUN RESTAURANT1.00one licence filemergedfile: 00081714 · same_address
ca-abc SHOGUN RESTAURANTdoordash shogun restaurant pasadena1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
ca-abc SHOGUN RESTAURANToverture Shogun Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ca-abc SHOGUN RESTAURANTdoordash shogun restaurant pasadena1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
ca-abc SHOGUN RESTAURANToverture Shogun Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
doordash shogun restaurant pasadenaoverture Shogun Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
ab-inbev SHOGUN TEPPAN STEAK & SUSHIdoordash shogun restaurant pasadena0.24Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Shogun restaurant at same number, Pasadena
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 470 N Halstead in Pasadena 91107 about 40 m apart, and the DoorDash slug 'shogun restaurant pasadena' matches the AB InBev account 'SHOGUN TEPPAN STEAK & SUSHI' as the same single restaurant, with no other business at that address.
pair 0cb9a533dd0b38b92eff

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
Shogun Restaurant — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
SHIN NIHON KOSAN INC — 4 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
133 within 1 mi · 705 within 3 mi
Off / on premise
46 / 72 within 1 mi · 153 / 434 within 3 mi
Selling alcohol
68 within 1 mi · 318 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
urban (4,812 people per sq mi)
People within 3 mi
136,059 (107,120 adults 21+, 53,644 households) from 32 tract(s), tracts within 3 mi
Income
per capita $65,363 · median household ~$120,608 (weighted mean of tract medians)
Age and education
median age ~43.6 · bachelor's or higher 60%
Ethnicity
Hispanic 23% · White 38% · Black 5% · Asian 32%
Adults per alcohol outlet
336
Alcohol spend within 3 mi
$47,023,877 a year ($20,444,010 at home, $26,562,556 away) · $147,410 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 2214411 ↔ doordash 30883725Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2214411 ↔ vtinfo 9ea7fd756c6cd88esame address and namemerged12
2026-11-10 17:05insertdoordash 30883725 ↔ overture 56a0a5e6-c733-4498-b299-e0b37c2fc14asame address and namemerged12
2026-11-10 17:05insertca-abc 00081714|47|APP|0 ↔ doordash 30883725same address and namemerged12
2026-11-10 17:05insertca-abc 00081714|47|LIC|0 ↔ doordash 30883725same address and namemerged12
2026-11-06 18:13insertca-abc 00081714|47|APP|0 ↔ overture 56a0a5e6-c733-4498-b299-e0b37c2fc14asame address and namemerged11
2026-11-06 18:13insertca-abc 00081714|47|LIC|0 ↔ overture 56a0a5e6-c733-4498-b299-e0b37c2fc14asame address and namemerged11
2026-10-09 13:59backfillca-abc 00081714|47|APP|0 ↔ ca-abc 00081714|47|LIC|0one licence filemerged