Match tracker

FRANKS LIQUOR
ca-abc · 416 N WILLIS ST, VISALIA, CA, 93291
Trace another record of this outlet: ab-inbevca-abc ✓ca-abcca-abcdoordashoverturevtinfo
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
RecordDistanceWhat the rule saysWhat the master did
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
overture Frank's Liquor and Superette
416 N Willis St, Visalia, CA, 93291
44 maddress+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 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev FRANKS LIQUOR & SUPERETTE
416 N WILLIS ST, VISALIA, CA, 93291
73 maddress+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
RecordDistanceWhat the rule saysWhat the master did
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
overture Frank's Liquor and Superette
416 N Willis St, Visalia, CA, 93291
44 maddress+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 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev FRANKS LIQUOR & SUPERETTE
416 N WILLIS ST, VISALIA, CA, 93291
73 maddress+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.
RecordDistanceWhat the rule saysWhat the master did
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
overture Frank's Liquor and Superette
416 N Willis St, Visalia, CA, 93291
44 mstratum nearsame outlet (through another record)
vtinfo FRANKS LIQUOR & SUPERETTE
416 N WILLIS ST, VISALIA, CA, 93291
48 mstratum nearjoined (name-contained)
doordash frank's liquor visalia
416 N Willis St, Visalia, CA, 93291
51 mstratum addr-agreejoined (address+name)
ab-inbev FRANKS LIQUOR & SUPERETTE
416 N WILLIS ST, VISALIA, CA, 93291
73 mstratum nearjoined (name-contained)
10 more
RecordDistanceWhat the rule saysWhat the master did
overture Davorn's Place
400 N Willis St, Visalia, CA, 93291
6 mstratum controlnot joined
ca-abc DAVORN'S PLACE
400 N WILLIS ST, VISALIA, CA, 93291
14 msame source — different name: never merged within one sourcenot joined
ca-abc EL SAN MARCOS
409 N WILLIS ST, VISALIA, CA, 93291
15 msame source — different name: never merged within one sourcenot joined
ubereats The SmokeHouse Visalia
400 N Willis St, Visalia, CA, 93291
17 mstratum controlnot joined
overture El San Marcos Mexican Restaurant
409 N Willis St, Visalia, CA, 93291
37 mstratum controlnot joined
doordash el san marcos mexican restaurant visalia
409 North Willis Street, Visalia, CA, 93291
38 mstratum controlnot joined
ab-inbev DAVORNS PLACE
400 N WILLIS ST, VISALIA, CA, 93291
73 mstratum controlnot joined
ca-abc BUKY'S SUSHI Y MARISCOS LLC
619 W MURRAY AVE, VISALIA, CA, 93291
79 msame source — different name: never merged within one sourcenot joined
doordash bukys sushi y marisco 619 w murray ave visalia
619 W Murray Ave, Visalia, CA, 93291
83 mstratum controlnot joined
ca-abc THE RANCH
604 W MURRAY AVE, VISALIA, CA, 93291
88 msame source — different name: never merged within one sourcenot 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 withAnswerWhat 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 withAnswerWhat 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 numbejoined (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.
RecordDistanceWhat the rule saysWhat the master did
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc FRANKS LIQUOR
416 N WILLIS ST, VISALIA, CA, 93291
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
overture Frank's Liquor and Superette
416 N Willis St, Visalia, CA, 93291
44 maddress+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 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev FRANKS LIQUOR & SUPERETTE
416 N WILLIS ST, VISALIA, CA, 93291
73 maddress+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.