Sushi Yu

Alhambra, CA 91801 · O0fb049550740 · 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
Sushi Yu 2 other
the most common name a source states
OKUKU INC ca-abc (legal name)
sushi yu alhambra doordash
Street
115 W MAIN ST
ca-abcno other value
City
ALHAMBRA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91801
ca-abcno other value
Pin
34.09461, -118.12837 map
ubereatsno other value
Phone
6269437872
overtureno other value
Licences
ca-abc 00670527|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6ce8e064d183; O8e04722bd75d; Ocbf098f73e04; O3d24d7ee5513

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
ca-abcSUSHI YU
legal name: OKUKU INC
00670527|41|LIC|0
115 W MAIN ST, ALHAMBRA, CA, 9180134.09463, -118.128132026-10-082026-11-19
doordashsushi yu alhambra
34543069
115 W Main St, Alhambra, CA, 9180134.09463, -118.128372026-10-082026-11-19
inspectionsSUSHI YU
inspections|la|FA0358664|PR0319953
115 W MAIN ST, Alhambra, CA, 918012026-11-192026-11-19
overtureSushi Yu
47297bed-1b25-4469-963e-4902af6368a2
115 W Main St, Alhambra, CA, 91801626943787234.09458, -118.128292026-11-062026-11-19
ubereatsSushi Yu
FhTis6B_Uliydyua8PSHiA
115 W Main St, Alhambra, CA, 9180134.09461, -118.128372026-11-032026-11-19

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
ca-abc SUSHI YUdoordash sushi yu alhambra1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00
ca-abc SUSHI YUinspections SUSHI YU1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc SUSHI YUoverture Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc SUSHI YUubereats Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash sushi yu alhambrainspections SUSHI YU1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash sushi yu alhambraoverture Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
doordash sushi yu alhambraubereats Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
inspections SUSHI YUoverture Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections SUSHI YUubereats Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Sushi Yuubereats Sushi Yu1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 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
OKUKU INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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:37insertinspections inspections|la|FA0358664|PR0319953 ↔ ubereats FhTis6B_Uliydyua8PSHiAsame address and namemerged17
2026-11-19 20:37insertca-abc 00670527|41|LIC|0 ↔ inspections inspections|la|FA0358664|PR0319953same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0358664|PR0319953 ↔ overture 47297bed-1b25-4469-963e-4902af6368a2same address and namemerged17
2026-11-19 20:37insertdoordash 34543069 ↔ inspections inspections|la|FA0358664|PR0319953same address and namemerged17
2026-11-12 14:25insertdoordash 34543069 ↔ ubereats FhTis6B_Uliydyua8PSHiAsame address and namemerged12
2026-11-12 14:25insertca-abc 00670527|41|LIC|0 ↔ doordash 34543069same address and namemerged12
2026-11-12 14:25insertdoordash 34543069 ↔ overture 47297bed-1b25-4469-963e-4902af6368a2same address and namemerged12
2026-11-06 18:13insertca-abc 00670527|41|LIC|0 ↔ overture 47297bed-1b25-4469-963e-4902af6368a2same address and namemerged11
2026-11-06 18:13insertoverture 47297bed-1b25-4469-963e-4902af6368a2 ↔ ubereats FhTis6B_Uliydyua8PSHiAsame address and namemerged11
2026-11-03 13:33backfillca-abc 00670527|41|LIC|0 ↔ ubereats FhTis6B_Uliydyua8PSHiAsame address and namemerged