Aji Ichi

SAN BRUNO, CA 94066 · O1e6a4a04d3e3 · first seen 2026-10-08
1 sourceon 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
Aji Ichi 1 other
a licence name in capitals, cleaned (derived; record_title.py)
AJI ICHI INC ca-abc
Street
695 SAN MATEO AVE
ca-abcno other value
City
SAN BRUNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94066
ca-abcno other value
Pin
37.62830, -122.41138 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00555713|41|LIC|0
every licence and permit record in the outlet
Joined by singleton · absorbed ids: none

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-abcAJI ICHI INC
00555713|41|LIC|0
695 SAN MATEO AVE, SAN BRUNO, CA, 9406637.62830, -122.411382026-10-082026-11-02

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 AJI ICHI INCdoordash aji ichi japanese restaurant san bruno0.47same address and nameheld same-source-conflictaddress similarity 1.00 · names match with these kind-of-place words set aside: japanese, restaurant · name Jaro-Winkler 0.86 · same street + ZIP · pins 15 m apart · name similarity 0.47
ca-abc AJI ICHI INCinspections AJI ICHI JAPANESE RESTAURANT0.47same address and nameheld same-source-conflictaddress similarity 1.00 · names match with these kind-of-place words set aside: japanese, restaurant · name Jaro-Winkler 0.86 · same street + ZIP · pins 11 m apart · name similarity 0.47
ca-abc AJI ICHI INCoverture Aji Ichi Japanese Restaurant0.47same address and nameheld same-source-conflictaddress similarity 1.00 · names match with these kind-of-place words set aside: japanese, restaurant · name Jaro-Winkler 0.86 · same street + ZIP · pins 13 m apart · name similarity 0.47

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
AJI ICHI 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-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
293 within 1 mi · 902 within 3 mi
Off / on premise
33 / 137 within 1 mi · 142 / 475 within 3 mi
Selling alcohol
187 within 1 mi · 585 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (4,135 people per sq mi)
People within 3 mi
116,913 (92,428 adults 21+, 41,306 households) from 28 tract(s), tracts within 3 mi
Income
per capita $66,658 · median household ~$141,256 (weighted mean of tract medians)
Age and education
median age ~42.3 · bachelor's or higher 44%
Ethnicity
Hispanic 28% · White 29% · Black 2% · Asian 39%
Adults per alcohol outlet
158
Alcohol spend within 3 mi
$39,797,033 a year ($17,067,226 at home, $22,717,305 away) · $67,913 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-20 22:08insertca-abc 00555713|41|LIC|0 ↔ inspections inspections|sanmateo|BLA-0000012380same address and nameheld: same-source-conflict17
2026-11-12 17:29updateca-abc 00555713|41|LIC|0 ↔ doordash 30095same address and nameheld: same-source-conflict14
2026-11-12 17:29insertca-abc 00555713|41|LIC|0 ↔ overture ef7ce437-3107-41ff-8ba2-e83eed9d40d3same address and nameheld: same-source-conflict14
2026-11-11 12:56insertca-abc 00555713|41|LIC|0 ↔ doordash 30095Claude judge: sameheld: same-source-conflict12