Match tracker
FRANKS LIQUOR
ca-abc · 416 N WILLIS ST, VISALIA, CA, 93291
Joined with 6 other record(s) — by address+name, duplicate-listing, 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 | joined (premises-id) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| 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 | joined (premises-id) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| 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 | joined (premises-id) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| 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:v4:medium: different (0.60) — The names and street address match, but the only California licence at the address is an on-sale public premises (bar) licence, while the DoorDash listing is a liquor store, and the guidance treats a bar licence against a liquor store as a claude-haiku-5-5:v7:medium: different (0.60) — The names match and the address and ZIP agree, but the shared building (2 businesses at the address) means the name must carry the match, and the California record's only premises licence is an on-sale bar licence, while the DoorDash listin | joined (address+name) |
7. Web agent found, not joined
What did the web agent find?
researched 1 pair(s)
| Pair with | Answer | What the master did |
|---|---|---|
| doordash frank's liquor visalia 416 N Willis St, Visalia, CA, 93291 | claude-haiku-5-5:v1:medium: same (0.87) — Record A (ABC) and B (DoorDash) both give 416 N Willis St, Visalia 93291 with coordinates about 20 m apart. Independent listings (Yelp, BBB, Yahoo Local, Wheree, cmac) all show one "Frank's Liquor" at that address, with the same phone numbe | joined (address+name) |
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 | joined (premises-id) |
| ca-abc FRANKS LIQUOR 416 N WILLIS ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| 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.