Mikasa Restaurant

Walnut, CA 91789 · O2eda0a6e54c6 · 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
Mikasa Restaurant 2 other
the most common name a source states
GONZALEZ FRANCISCO ca-abc (legal name)
mikasa mexican restaurant walnut doordash
Street
19849 VALLEY BLVD 1 other
ca-abc
19849 Valley Boulevard doordash
City
WALNUT
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91789
ca-abcno other value
Pin
34.00511, -117.86810 map 1 other
doordash
80 m away ca-abc
Phone
9095981114
overtureno other value
Licences
ca-abc 00478547|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8c7f376e4bee; O5d3f7a5e1c37

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-abcMIKASA RESTAURANT
legal name: GONZALEZ FRANCISCO
00478547|41|LIC|0
19849 VALLEY BLVD, WALNUT, CA, 9178934.00448, -117.868522026-10-082026-11-05
doordashmikasa mexican restaurant walnut
1211751
19849 Valley Boulevard, Walnut, CA, 9178934.00511, -117.868102026-10-082026-11-15
overtureMikasa Restaurant
8ed5922d-5b2e-4801-9f0e-0080058b3caf
19849 Valley Blvd, Walnut, CA, 91789909598111434.00513, -117.868102026-11-062026-11-06

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 MIKASA RESTAURANToverture Mikasa Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 82 m apart · name similarity 1.00
ca-abc MIKASA RESTAURANTdoordash mikasa mexican restaurant walnut0.74same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.78 · same street + city + state · pins 80 m apart · name similarity 0.74
doordash mikasa mexican restaurant walnutoverture Mikasa Restaurant0.74same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.78 · same street + city + state · pins 2 m apart · name similarity 0.74

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 — CA 41
Rule version 10, computed 2026-11-18 20:35.
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
57 within 1 mi · 604 within 3 mi
Off / on premise
15 / 29 within 1 mi · 84 / 388 within 3 mi
Selling alcohol
30 within 1 mi · 278 within 3 mi
Nearest
same channel 0.45 mi · licensed 0.16 mi
Setting
urban (4,101 people per sq mi)
People within 3 mi
115,958 (89,361 adults 21+, 35,306 households) from 27 tract(s), tracts within 3 mi
Income
per capita $39,091 · median household ~$103,709 (weighted mean of tract medians)
Age and education
median age ~43.0 · bachelor's or higher 38%
Ethnicity
Hispanic 38% · White 11% · Black 2% · Asian 51%
Adults per alcohol outlet
320
Alcohol spend within 3 mi
$27,318,234 a year ($12,209,766 at home, $15,096,219 away) · $97,915 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-14 20:23insertdoordash 1211751 ↔ overture 8ed5922d-5b2e-4801-9f0e-0080058b3cafsame address and namemerged15
2026-11-14 20:23insertca-abc 00478547|41|LIC|0 ↔ doordash 1211751same address and namemerged15
2026-11-06 18:13insertca-abc 00478547|41|LIC|0 ↔ overture 8ed5922d-5b2e-4801-9f0e-0080058b3cafsame address and namemerged11