Match tracker
FRANKS LIQUOR
ca-abc · 416 N WILLIS ST, VISALIA, CA, 93291
Joined with 6 other record(s) — by address+name, name-contained, premises-id.
1. Record ready
What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: FRANKS LIQUOR✓ Street with a house number: 416 N WILLIS ST✓ ZIP: 93291✓ City + state: VISALIA, CA✓ Pin (lat/lng): 36.33303, -119.29764✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
6 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Frank's Liquor and Superette 416 N Willis St, Visalia, CA, 93291 | 44 m | address+name rule: does not pass (name similarity 0.69) | same outlet (through another record) |
| vtinfo FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 48 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | 51 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 73 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
6 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Frank's Liquor and Superette 416 N Willis St, Visalia, CA, 93291 | 44 m | address+name rule: does not pass (name similarity 0.69) | same outlet (through another record) |
| vtinfo FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 48 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | 51 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 73 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
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?
16 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-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Frank's Liquor and Superette 416 N Willis St, Visalia, CA, 93291 | 44 m | stratum near | same outlet (through another record) |
| vtinfo FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 48 m | stratum near | joined (name-contained) |
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | 51 m | stratum addr-agree | joined (address+name) |
| ab-inbev FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 73 m | stratum near | joined (name-contained) |
10 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Davorn's Place 400 N Willis St, Visalia, CA, 93291 | 6 m | stratum control | not joined |
| ca-abc DAVORN'S PLACE 400 N WILLIS ST, VISALIA, CA, 93291 | 14 m | same source — different name: never merged within one source | not joined |
| ca-abc EL SAN MARCOS 409 N WILLIS ST, VISALIA, CA, 93291 | 15 m | same source — different name: never merged within one source | not joined |
| ubereats The SmokeHouse Visalia 400 N Willis St, Visalia, CA, 93291 | 17 m | stratum control | not joined |
| overture El San Marcos Mexican Restaurant 409 N Willis St, Visalia, CA, 93291 | 37 m | stratum control | not joined |
| doordash el san marcos mexican restaurant visalia 409 North Willis Street, Visalia, CA, 93291 | 38 m | stratum control | not joined |
| ab-inbev DAVORNS PLACE 400 N WILLIS ST, VISALIA, CA, 93291 | 73 m | stratum control | not joined |
| ca-abc BUKY'S SUSHI Y MARISCOS LLC 619 W MURRAY AVE, VISALIA, CA, 93291 | 79 m | same source — different name: never merged within one source | not joined |
| doordash bukys sushi y marisco 619 w murray ave visalia 619 W Murray Ave, Visalia, CA, 93291 | 83 m | stratum control | not joined |
| ca-abc THE RANCH 604 W MURRAY AVE, VISALIA, CA, 93291 | 88 m | same source — different name: never merged within one source | not joined |
6. Claude judge found, not joined
What did Claude's judge say?
answered 1 pair(s)
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.| Pair with | Answer | What the master did |
|---|---|---|
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | claude-haiku-5-5:v7:medium: different (0.60) — The names match and the address is shared, but the only California licence at the premises is an on-sale public premises (bar) licence, which the rules treat as a different business from a liquor store, and the building also houses another | joined (address+name) |
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 6 other record(s)
Outlet O0d6a85fa42e9: 7 record(s) from ab-inbev, ca-abc, doordash, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Frank's Liquor and Superette 416 N Willis St, Visalia, CA, 93291 | 44 m | address+name rule: does not pass (name similarity 0.69) | same outlet (through another record) |
| vtinfo FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 48 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | 51 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev FRANKS LIQUOR & SUPERETTE 416 N WILLIS ST, VISALIA, CA, 93291 | 73 m | address+name rule: does not pass (name similarity 0.69) | joined (name-contained) |
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.