Shiki Sushi BBQ Teppan & Sports Bar

REDLANDS, CA 92374 · O7b91cf895c8a · first seen 2026-10-08
3 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
Shiki Sushi BBQ Teppan & Sports Bar 1 other
a licence name in capitals, cleaned (derived; record_title.py)
NGUYEN TIM ca-abc (legal name)
Street
27641 SAN BERNARDINO AVE 1 other
ca-abc
27461 SAN BERNARDINO AVE ab-inbevvtinfo ×2
City
REDLANDS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92374
ca-abcno other value
Pin
34.07741, -117.20637 map 2 other
ca-abc
221 m away ab-inbev
230 m away vtinfo
Phone
9093071920
vtinfono other value
Licences
ca-abc 00562214|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe76355917db8; Oc09c43610c17

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-inbevSHIKI SUSHI BBQ TEPPAN & SPORTS BAR
3991543
27461 SAN BERNARDINO AVE, REDLANDS, CA, 9237434.07556, -117.205492026-11-112026-11-12
ca-abcSHIKI SUSHI BBQ TEPPAN & SPORTS BAR
legal name: NGUYEN TIM
00562214|47|LIC|0
27641 SAN BERNARDINO AVE, REDLANDS, CA, 9237434.07741, -117.206372026-10-082026-11-12
vtinfoSHIKI SUSHI BBQ TEPPAN & SPORTS BAR
4691f91742fa5a0e
27461 SAN BERNARDINO AVE, REDLANDS, CA, 92374909307192034.07555, -117.205282026-11-122026-11-14

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 SHIKI SUSHI BBQ TEPPAN & SPORTS BARca-abc SHIKI SUSHI BBQ TEPPAN & SPORTS BAR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Identical distinctive name; address digit transposition, 0.2km
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 60% confident — The two records carry the identical name 'SHIKI SUSHI BBQ TEPPAN & SPORTS BAR' in the same city and ZIP, with coordinates about 220 m apart, but the street numbers differ (27461 vs 27641), so the address match is only approximate.
pair 43d4c6b79dcaa7c4fbce
ab-inbev SHIKI SUSHI BBQ TEPPAN & SPORTS BARvtinfo SHIKI SUSHI BBQ TEPPAN & SPORTS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
106 within 1 mi · 524 within 3 mi
Off / on premise
41 / 52 within 1 mi · 142 / 315 within 3 mi
Selling alcohol
49 within 1 mi · 294 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.05 mi
Setting
suburban (2,674 people per sq mi)
People within 3 mi
75,597 (53,843 adults 21+, 25,202 households) from 17 tract(s), tracts within 3 mi
Income
per capita $35,169 · median household ~$85,840 (weighted mean of tract medians)
Age and education
median age ~32.7 · bachelor's or higher 31%
Ethnicity
Hispanic 46% · White 35% · Black 8% · Asian 13%
Adults per alcohol outlet
183
Alcohol spend within 3 mi
$16,697,327 a year ($7,668,292 at home, $9,020,743 away) · $56,601 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 3991543 ↔ ca-abc 00562214|47|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 3991543 ↔ vtinfo 4691f91742fa5a0esame address and namemerged12