Outlets /
Echigo Homecook
San Francisco, CA 94110 · O317e9ce73759 · 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 | Echigo Homecook 4 other | a licence name in capitals, cleaned (derived; record_title.py) | BISTRO LOVESSY LLC ca-abc (legal name) Echigo Bento ubereats echigo bento san francisco doordash echigo home cook san francisco doordash |
| Street | 870 VALENCIA ST 1 other | ca-abc | 870 Valencia Street doordashubereats ×2 |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94110 | ca-abc | no other value |
| Pin | 37.75901, -122.42149 map | ubereats | no other value |
| Phone | none | no other value | |
| Licences | ca-abc 00646104|41|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ob13b6fc1ba8c; Oe3337b5bc9d6; O5ccd61683a66
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 | ECHIGO HOMECOOK legal name: BISTRO LOVESSY LLC 00646104|41|LIC|0 | 870 VALENCIA ST, SAN FRANCISCO, CA, 94110 | 37.75898, -122.42139 | 2026-10-08 | 2026-11-18 | |
| doordash | echigo bento san francisco 36686549 | 870 Valencia St, San Francisco, CA, 94110 | 37.75899, -122.42163 | 2026-10-08 | 2026-11-18 | |
| doordash | echigo home cook san francisco 511923 | 870 Valencia Street, San Francisco, CA, 94110 | 37.75899, -122.42149 | 2026-10-08 | 2026-11-18 | |
| ubereats | Echigo Bento 0iroTD3tU1S3lPszf-Bahw | 870 Valencia Street, San Francisco, CA, 94110 | 37.75901, -122.42149 | 2026-11-07 | 2026-11-18 |
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 echigo bento san francisco | ubereats Echigo Bento | 1.00 | same address and name | merged department listings of one store | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| ca-abc ECHIGO HOMECOOK | doordash echigo home cook san francisco | 0.48 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Same distinctive name (Echigo Homecook, with the city appended to the DoorDash slug) at the same street address, 870 Valencia St, with only one business recorded there; the restaurant licence fits a r Other Claude answers on this pair:
pair 0252d3e5ce076de51f2b |
| doordash echigo home cook san francisco | ubereats Echigo Bento | 0.41 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records carry the distinctive 'Echigo' name at the same street address, 870 Valencia Street, and only one business is recorded there, so 'Echigo Home Cook' and 'Echigo Bento' are likely one opera Other Claude answers on this pair:
pair 8613bb39cebab49fb29f |
| ca-abc ECHIGO HOMECOOK | ubereats Echigo Bento | 0.39 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) The address is the same (870 Valencia St, 94110), the coordinates are 0.01 km apart, our data holds only one business at that address, and the distinctive 'Echigo' name matches, so 'Echigo Homecook' a Other Claude answers on this pair:
pair fd1157e24200e0641854 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- BISTRO LOVESSY LLC — 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:33.
Every vote behind these (raw)
{
"ue_location": [
"STANDALONE_VIRTUAL"
],
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"ubereats-type",
"on_premise",
"restaurant"
],
[
"doordash-url",
"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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-18 18:58 | insert | doordash 36686549 ↔ ubereats 0iroTD3tU1S3lPszf-Bahw | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ca-abc 00646104|41|LIC|0 ↔ ubereats 0iroTD3tU1S3lPszf-Bahw | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 511923 ↔ ubereats 0iroTD3tU1S3lPszf-Bahw | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00646104|41|LIC|0 ↔ doordash 511923 | Claude judge: same | merged | 12 |