Match tracker

OFARRELL LIQUORS
ab-inbev · 405 OFARRELL ST, SAN FRANCISCO, CA, 94102
Trace another record of this outlet: ab-inbev ✓ca-abcdoordashoverturevtinfo
Joined with 4 other record(s) — by address+name.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: OFARRELL LIQUORS✓ Street with a house number: 405 OFARRELL ST✓ ZIP: 94102✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.78583, -122.41222✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
vtinfo OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash o'farrell liquor san francisco
405 O'Farrell Street, San Francisco, CA, 94102
62 maddress+name rule: passes (name similarity 0.65)joined (address+name)
overture O'Farrell Liquors
405 O'Farrell St, San Francisco, CA, 94102
66 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
69 maddress+name rule: passes (name similarity 1.00)joined (address+name)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
vtinfo OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash o'farrell liquor san francisco
405 O'Farrell Street, San Francisco, CA, 94102
62 maddress+name rule: passes (name similarity 0.65)joined (address+name)
overture O'Farrell Liquors
405 O'Farrell St, San Francisco, CA, 94102
66 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
69 maddress+name rule: passes (name similarity 1.00)joined (address+name)

4. Street spelling found, not joined

Same house number, street written differently?
2 found (2 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
vtinfo HOTEL SPERO
405 TAYLOR ST, SAN FRANCISCO, CA, 94102
63 mstreet-variant rule: does not passnot joined
overture Hotel Serrano
405 Taylor St, San Francisco, CA, 94102
64 mstreet-variant rule: does not passnot joined

5. Nearby pins found, not joined

Anyone within 100 m?
39 within 100 m — distance alone never merges; these are questions for Claude
Pins are often geocoded from the address itself, so two pins agree whenever the addresses do — they cannot confirm a match, and never merge on their own.
RecordDistanceWhat the rule saysWhat the master did
vtinfo OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
61 mstratum addr-agreejoined (address+name)
ttb WEST COAST WINE EXPORTS LLC
449 O'FARRELL ST APT 506, SAN FRANCISCO, CA, 94102
1 mstratum controlnot joined
ca-abc XPRESS MARKET INC
451 & 453 OFARRELL ST, SAN FRANCISCO, CA, 94102
6 mstratum controlnot joined
ab-inbev XPRESS MARKET
498 OFARRELL ST, SAN FRANCISCO, CA, 94102
33 msame source — different name: never merged within one sourcenot joined
doordash marrakech moroccan restaurant san francisco
419 O'Farrell Street, San Francisco, CA, 94102
42 mstratum controlnot joined
doordash el mariachi sf san francisco
345 Taylor St, San Francisco, CA, 94102
53 mstratum controlnot joined
33 more
RecordDistanceWhat the rule saysWhat the master did
doordash le carousel patisserie san francisco
345 Taylor St, San Francisco, CA, 94102
53 mstratum controlnot joined
ubereats Fire Ass Thai by Million Thai Restaurant
385 Taylor St, San Francisco, CA, 94102
61 mstratum controlnot joined
vtinfo TILDEN HOTEL
345 TAYLOR ST, SAN FRANCISCO, CA, 94102
62 mstratum controlnot joined
vtinfo HOTEL SPERO
405 TAYLOR ST, SAN FRANCISCO, CA, 94102
63 mstratum controlnot joined
overture Tilden Hotel
345 Taylor St, San Francisco, CA, 94102
63 mstratum controlnot joined
overture Hotel Serrano
405 Taylor St, San Francisco, CA, 94102
64 mstratum controlnot joined
overture Khun Mae Thai Noodles
385 Taylor St, San Francisco, CA, 94102
67 mstratum controlnot joined
ca-abc BOURBON AND BRANCH
501-503-505 JONES ST, SAN FRANCISCO, CA, 94102
74 mstratum controlnot joined
overture Le Carousel Patisserie at Tilden
345 Taylor St, San Francisco, CA, 94102
74 mstratum controlnot joined
ca-abc MILLION THAI
385 TAYLOR ST, SAN FRANCISCO, CA, 94102
75 mstratum controlnot joined
overture Red Chilli
522 Jones St, San Francisco, CA, 94102
76 mstratum controlnot joined
ca-abc HOTEL SPERO
403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102
76 mstratum controlnot joined
ca-abc HOTEL SPERO
403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102
76 mstratum controlnot joined
ca-abc HOTEL SPERO
403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102
76 mstratum controlnot joined
ca-abc HOTEL SPERO
403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102
76 mstratum controlnot joined
ca-abc NAPA VALLEY WINERY EXCHANGE
415 TAYLOR ST, SAN FRANCISCO, CA, 94102
78 mstratum controlnot joined
ca-abc OX & TIGER
552 JONES ST, SAN FRANCISCO, CA, 94102
79 mstratum controlnot joined
ubereats Shalimar Restaurant
532 Jones Street, San Francisco, CA, 94102
82 mstratum controlnot joined
doordash pakwan restaurant san francisco
501 O'Farrell Street, San Francisco, CA, 94102
82 mstratum controlnot joined
overture Pakwan
501 O'Farrell St, San Francisco, CA, 94102
83 mstratum controlnot joined
vtinfo ZOMBIE VILLAGE
441 JONES ST, SAN FRANCISCO, CA, 94102
84 mstratum controlnot joined
overture The Zombie Village
441 Jones St, San Francisco, CA, 94102
85 mstratum controlnot joined
ab-inbev YOUNG ELLIS PRODUCE
398 ELLIS ST, SAN FRANCISCO, CA, 94102
86 msame source — different name: never merged within one sourcenot joined
overture Bourbon and Branch
501 Jones St, San Francisco, CA, 94102
89 mstratum controlnot joined
ca-abc TILDEN HOTEL
345 TAYLOR ST, SAN FRANCISCO, CA, 94102
90 mstratum controlnot joined
vtinfo SWIG
561 GEARY ST, SAN FRANCISCO, CA, 94102
93 mstratum controlnot joined
ubereats Blue Earth South Indian
511 Jones St, San Francisco, CA, 94102
94 mstratum controlnot joined
doordash cargado arriba san francisco
345 Taylor St, San Francisco, CA
95 mstratum controlnot joined
doordash dirty burger san francisco
345 Taylor St, San Francisco, CA
95 mstratum controlnot joined
doordash leadoff breakfast burrito san francisco
345 Taylor St, San Francisco, CA
95 mstratum controlnot joined
doordash million thai san francisco
385 Taylor Street, San Francisco, CA, 94102
96 mstratum controlnot joined
vtinfo YOUNG ELLIS PRODUCE
398 ELLIS ST, SAN FRANCISCO, CA, 94102
96 mstratum controlnot joined
ubereats Le Carousel Patisserie At Tilden
345 Taylor Street, San Francisco, CA, 94102
97 mstratum controlnot joined

6. Claude judge nothing found

What did Claude's judge say?
no judgement on these pairs
Haiku screens every candidate pair; only Opus judge claude-opus-5-5:v12:low can merge, at confidence ≥ 0.8, with a numbered street on both sides.

7. Web agent nothing found

What did the web agent find?
not asked

8. Person nothing found

What did a person answer?
no answers yet

9. Result joined

Where did it end up?
one outlet with 4 other record(s)
Outlet O127427365e44: 5 record(s) from ab-inbev, ca-abc, doordash, overture, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
vtinfo OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash o'farrell liquor san francisco
405 O'Farrell Street, San Francisco, CA, 94102
62 maddress+name rule: passes (name similarity 0.65)joined (address+name)
overture O'Farrell Liquors
405 O'Farrell St, San Francisco, CA, 94102
66 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc OFARRELL LIQUORS
405 OFARRELL ST, SAN FRANCISCO, CA, 94102
69 maddress+name rule: passes (name similarity 1.00)joined (address+name)
Read-only. Every candidate is scored by the same code the master build uses, and "what the master did" is what the last build stored. Each search shows at most 40 records.