Match tracker
SAN BRUNO LIQUORS
ca-abc · 542 SAN MATEO AVE, SAN BRUNO, CA, 94066
Joined with 5 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: SAN BRUNO LIQUORS✓ Street with a house number: 542 SAN MATEO AVE✓ ZIP: 94066✓ City + state: SAN BRUNO, CA✓ Pin (lat/lng): 37.62536, -122.41118✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
5 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-tobacco SAN BRUNO LIQUOR 542 SAN MATEO AVE, San Bruno, CA, 94066 | 0 m | address+name rule: passes (name similarity 0.73) | joined (address+name) |
| inspections SAN BRUNO LIQUORS 542 SAN MATEO AVE, San Bruno, CA, 94066 | 5 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture San Bruno Liquors 542 San Mateo Ave, San Bruno, CA, 94066 | 8 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 19 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
5 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-tobacco SAN BRUNO LIQUOR 542 SAN MATEO AVE, San Bruno, CA, 94066 | 0 m | address+name rule: passes (name similarity 0.73) | joined (address+name) |
| inspections SAN BRUNO LIQUORS 542 SAN MATEO AVE, San Bruno, CA, 94066 | 5 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture San Bruno Liquors 542 San Mateo Ave, San Bruno, CA, 94066 | 8 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 19 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
4. Street spelling nothing found
Same house number, street written differently?
no other record found
5. Nearby pins found, not joined
Anyone within 100 m?
at least 40 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-tobacco SAN BRUNO LIQUOR 542 SAN MATEO AVE, San Bruno, CA, 94066 | 0 m | stratum addr-agree | joined (address+name) |
| inspections SAN BRUNO LIQUORS 542 SAN MATEO AVE, San Bruno, CA, 94066 | 5 m | stratum addr-agree | joined (address+name) |
| vtinfo SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 17 m | stratum addr-agree | joined (address+name) |
| overture RicoPan LatinPastries 532 San Mateo Ave, San Bruno, CA, 94066 | 12 m | stratum control | not joined |
| ubereats Rich Coffee 532 San Mateo Ave, San Bruno, CA, 94066 | 15 m | stratum control | not joined |
| ab-inbev LOS PRIMOS MEAT MARKET 599 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 16 m | stratum control | not joined |
34 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ubereats RicoPan Latinpastries 532 San Mateo Ave, San Bruno, CA, 94066 | 17 m | stratum control | not joined |
| inspections RICO PAN 532 SAN MATEO AVE, San Bruno, CA, 94066 | 18 m | stratum control | not joined |
| doordash rich coffee san bruno 532 San Mateo Ave, San Bruno, CA, 94066 | 20 m | stratum none | not joined |
| ca-abc ALFREDO OROZCO LLC 551 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 21 m | same source — different name: never merged within one source | not joined |
| ca-abc PINOT'S PALETTE SAN MATEO 533 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 24 m | same source — different name: never merged within one source | not joined |
| overture Taqueria Leon 551 San Mateo Ave, San Bruno, CA, 94066 | 25 m | stratum control | not joined |
| doordash taqueria leon san bruno 551 San Mateo Avenue, San Bruno, CA, 94066 | 26 m | stratum near | not joined |
| overture Pinot's Palette 533 San Mateo Ave, San Bruno, CA, 94066 | 31 m | stratum control | not joined |
| inspections PINOTS PALETTE SAN BRUNO 533 SAN MATEO AVE, San Bruno, CA, 94066 | 40 m | stratum near | not joined |
| vtinfo PINOTS PALETTE 533 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 42 m | stratum control | not joined |
| overture Mexicana Produce Market 512 San Mateo Ave, San Bruno, CA, 94066 | 46 m | stratum control | not joined |
| snap MEXICANA PRODUCE 512 San Mateo Ave, San Bruno, CA, 94066 | 50 m | stratum control | not joined |
| inspections MEXICANA PRODUCE 512 SAN MATEO AVE, San Bruno, CA, 94066 | 51 m | stratum control | not joined |
| inspections H&R MARKET 572 SAN MATEO AVE, San Bruno, CA, 94066 | 61 m | stratum control | not joined |
| ca-abc MEXICANA PRODUCE 512 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 61 m | same source — different name: never merged within one source | not joined |
| ca-abc SUSHI HOUSE 576 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 69 m | same source — different name: never merged within one source | not joined |
| doordash starbucks san bruno 501 San Mateo Avenue, San Bruno, CA, 94066 | 70 m | stratum near | not joined |
| inspections SUSHI HOUSE 576 SAN MATEO AVE, San Bruno, CA, 94066 | 71 m | stratum control | not joined |
| ubereats Starbucks 501 San Mateo Avenue, San Bruno, CA, 94066 | 72 m | stratum control | not joined |
| inspections CHOPSTICKER LAB 500 SAN MATEO AVE, San Bruno, CA, 94066 | 74 m | stratum control | not joined |
| ubereats Sushi House 576 San Mateo Ave, San Bruno, CA, 94066 | 74 m | stratum control | not joined |
| overture Starbucks 501 San Mateo Ave, San Bruno, CA, 94066 | 74 m | stratum control | not joined |
| overture Sushi House 576 San Mateo Ave, San Bruno, CA, 94066 | 81 m | stratum control | not joined |
| doordash sugarcane hq san bruno 586a San Mateo Avenue, San Bruno, CA, 94066 | 86 m | stratum none | not joined |
| ca-abc HON LIN RESTAURANT INC 500 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 86 m | same source — different name: never merged within one source | not joined |
| ubereats Pho De Nguyen 586 San Mateo Ave, San Bruno, CA, 94066 | 86 m | stratum control | not joined |
| snap Los Primos Produce & Grocery 599 San Mateo Ave, San Bruno, CA, 94066 | 88 m | stratum control | not joined |
| ca-abc TAOYIN ASIAN INC 586 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 90 m | same source — different name: never merged within one source | not joined |
| ca-abc PHO DE NGUYEN 586 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 90 m | same source — different name: never merged within one source | not joined |
| vtinfo LOS PRIMOS MEAT MARKET 599 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 90 m | stratum control | not joined |
| overture Pho de Nguyen 586 San Mateo Ave, San Bruno, CA, 94066 | 91 m | stratum control | not joined |
| ubereats Chef Phong’s kitchen 586 San Mateo Ave, San Bruno, CA, 94066 | 91 m | stratum control | not joined |
| doordash pho de nguyen san bruno 586 San Mateo Avenue, San Bruno, CA, 94066 | 93 m | stratum none | not joined |
| ca-tobacco MAZ PARADISE HOOKAH 591 SAN MATEO AVE, San Bruno, CA, 94066 | 99 m | stratum control | not 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 5 other record(s)
Outlet O12da329a7366: 6 record(s) from ab-inbev, ca-abc, ca-tobacco, inspections, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-tobacco SAN BRUNO LIQUOR 542 SAN MATEO AVE, San Bruno, CA, 94066 | 0 m | address+name rule: passes (name similarity 0.73) | joined (address+name) |
| inspections SAN BRUNO LIQUORS 542 SAN MATEO AVE, San Bruno, CA, 94066 | 5 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture San Bruno Liquors 542 San Mateo Ave, San Bruno, CA, 94066 | 8 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev SAN BRUNO LIQUORS 542 SAN MATEO AVE, SAN BRUNO, CA, 94066 | 19 m | address+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.