Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94114 | ca-abc | no other value |
| Pin | 37.76043, -122.43515 map | doordash | no other value |
| Phone | 4157010082 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | WASABI BISTRO JAPANESE RESTAURANT legal name: UNITED RESTAURANT CORP 00588851|41|LIC|0 | 524 CASTRO ST, SAN FRANCISCO, CA, 94114 | 37.76041, -122.43503 | 2026-10-08 | 2026-11-11 | |
| doordash | wasabi bistro san francisco 890728 | 524 Castro Street, San Francisco, CA, 94114 | 37.76043, -122.43515 | 2026-10-08 | 2026-11-09 | |
| overture | Wasabi Bistro 6d9b401e-b6d0-4ccd-b9d8-5c10d104d449 | 524 Castro St, San Francisco, CA, 94114 | 4157010082 | 37.76042, -122.43510 | 2026-11-09 | 2026-11-09 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| doordash wasabi bistro san francisco | overture Wasabi Bistro | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| ca-abc WASABI BISTRO JAPANESE RESTAURANT | doordash wasabi bistro san francisco | 0.53 | Claude judge: same | merged | 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:
pair 72866c6cdd711fb6c97b |
| ca-abc WASABI BISTRO JAPANESE RESTAURANT | overture Wasabi Bistro | 0.53 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ca-abc 00588851|41|LIC|0 ↔ overture 6d9b401e-b6d0-4ccd-b9d8-5c10d104d449 | same address and name | merged | 14 |
| 2026-11-11 12:56 | insert | ca-abc 00588851|41|LIC|0 ↔ doordash 890728 | Claude judge: same | merged | 12 |
| 2026-11-09 15:32 | insert | doordash 890728 ↔ overture 6d9b401e-b6d0-4ccd-b9d8-5c10d104d449 | same address and name | merged | 11 |