Wasabi Bistro Japanese Restaurant

San Francisco, CA 94114 · O1ce9aeb42425 · 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
Wasabi Bistro Japanese Restaurant 3 other
a licence name in capitals, cleaned (derived; record_title.py)
UNITED RESTAURANT CORP ca-abc (legal name)
Wasabi Bistro overture
wasabi bistro san francisco doordash
Street
524 CASTRO ST 1 other
ca-abc
524 Castro Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94114
ca-abcno other value
Pin
37.76043, -122.43515 map
doordashno other value
Phone
4157010082
overtureno other value
Licences
ca-abc 00588851|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O1d79680126c9; O4e1968273851

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-abcWASABI BISTRO JAPANESE RESTAURANT
legal name: UNITED RESTAURANT CORP
00588851|41|LIC|0
524 CASTRO ST, SAN FRANCISCO, CA, 9411437.76041, -122.435032026-10-082026-11-11
doordashwasabi bistro san francisco
890728
524 Castro Street, San Francisco, CA, 9411437.76043, -122.435152026-10-082026-11-09
overtureWasabi Bistro
6d9b401e-b6d0-4ccd-b9d8-5c10d104d449
524 Castro St, San Francisco, CA, 94114415701008237.76042, -122.435102026-11-092026-11-09

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
doordash wasabi bistro san franciscooverture Wasabi Bistro1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ca-abc WASABI BISTRO JAPANESE RESTAURANTdoordash wasabi bistro san francisco0.53Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The names match: the DoorDash slug 'wasabi bistro san francisco' is 'Wasabi Bistro' with the city appended. Both records give 524 Castro St, 94114, and only one business is known at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same street address, ZIP and city in San Francisco, and the names match (Wasabi Bistro Japanese Restaurant and wasabi bistro), with the coordinates about 11 metres apart and no other business at the address.
pair 72866c6cdd711fb6c97b
ca-abc WASABI BISTRO JAPANESE RESTAURANToverture Wasabi Bistro0.53same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bistro, japanese, restaurant · name Jaro-Winkler 0.79 · same street + ZIP · pins 7 m apart · name similarity 0.53

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
UNITED RESTAURANT CORP — 2 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"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
862 within 1 mi · 6,001 within 3 mi
Off / on premise
135 / 561 within 1 mi · 862 / 3,866 within 3 mi
Selling alcohol
596 within 1 mi · 3,711 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (21,758 people per sq mi)
People within 3 mi
615,185 (524,578 adults 21+, 280,860 households) from 177 tract(s), tracts within 3 mi
Income
per capita $98,534 · median household ~$153,809 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 63%
Ethnicity
Hispanic 17% · White 43% · Black 4% · Asian 32%
Adults per alcohol outlet
141
Alcohol spend within 3 mi
$271,503,653 a year ($115,266,982 at home, $156,153,904 away) · $73,142 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:29insertca-abc 00588851|41|LIC|0 ↔ overture 6d9b401e-b6d0-4ccd-b9d8-5c10d104d449same address and namemerged14
2026-11-11 12:56insertca-abc 00588851|41|LIC|0 ↔ doordash 890728Claude judge: samemerged12
2026-11-09 15:32insertdoordash 890728 ↔ overture 6d9b401e-b6d0-4ccd-b9d8-5c10d104d449same address and namemerged11