Match tracker

WALMART SUPERCENTER 1645
ca-abc · 250 S 12TH AVE, HANFORD, CA, 93230
Trace another record of this outlet: ab-inbevca-abcca-abc ✓overturewalmart-stores
Joined with 4 other record(s) — by address+name, premises-id.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: WALMART SUPERCENTER 1645✓ Street with a house number: 250 S 12TH AVE✓ ZIP: 93230✓ City + state: HANFORD, CA✓ Pin (lat/lng): 36.32547, -119.67302✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
4 found (3 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc WALMART SUPERCENTER 1645
250 S 12TH AVE, HANFORD, CA, 93230
0 msame source — identical name: a duplicate listingjoined (premises-id)
overture Walmart Pharmacy
250 S 12th Ave, Hanford, CA, 93230
300 maddress+name rule: does not pass (name similarity 0.55)same outlet (through another record)
ab-inbev WALMART SUPERCENTER
250 S 12TH AVE, HANFORD, CA, 93230
457 maddress+name rule: does not pass (name similarity 0.78)same outlet (through another record)
walmart-stores Walmart
250 S 12th Ave, Hanford, CA, 93230
506 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 (3 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc WALMART SUPERCENTER 1645
250 S 12TH AVE, HANFORD, CA, 93230
0 msame source — identical name: a duplicate listingjoined (premises-id)
overture Walmart Pharmacy
250 S 12th Ave, Hanford, CA, 93230
300 maddress+name rule: does not pass (name similarity 0.55)same outlet (through another record)
ab-inbev WALMART SUPERCENTER
250 S 12TH AVE, HANFORD, CA, 93230
457 maddress+name rule: does not pass (name similarity 0.78)same outlet (through another record)
walmart-stores Walmart
250 S 12th Ave, Hanford, CA, 93230
506 maddress+name rule: passes (name similarity 1.00)joined (address+name)

4. Street spelling found, not joined

Same house number, street written differently?
4 found (4 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
ubereats Wetzel's Pretzels
250 12th Avenue, Hanford, CA, 93230
490 mstreet-variant rule: does not passnot joined
overture Wetzel's Pretzels
250 12th Ave, Hanford, CA, 93230
507 mstreet-variant rule: does not passnot joined
doordash modern farmhouse cookies hanford
250 West 8th Street, Hanford, CA, 93230
2.2 kmstreet-variant rule: does not passnot joined
overture Modern Farmhouse Cookies
250 W 8th St, Hanford, CA, 93230
2.2 kmstreet-variant rule: does not passnot joined

5. Nearby pins found, not joined

Anyone within 100 m?
23 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 WALMART SUPERCENTER 1645
250 S 12TH AVE, HANFORD, CA, 93230
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc TOSHIKO JAPANESE CUISINE
258 N 12TH AVE, HANFORD, CA, 93230
15 msame source — different name: never merged within one sourcenot joined
overture Dunkin'
1695 W Lacey Blvd, Hanford, CA, 93230
38 mstratum controlnot joined
doordash starbucks hanford
240 N 12th Ave, Hanford, CA, 93230
43 mstratum controlnot joined
doordash dunkin' hanford
1695 West Lacey Boulevard, Hanford, CA, 93230
45 mstratum controlnot joined
ubereats Michaels
204 N 12th Ave, Hanford, CA, 93230
50 mstratum controlnot joined
17 more
RecordDistanceWhat the rule saysWhat the master did
doordash round table pizza hanford
208 12th Avenue, Hanford, CA, 93230
54 mstratum controlnot joined
doordash kabab city hanford
240 N 12th Ave Ste 111 # Ste, Hanford, CA, 93230
55 mstratum controlnot joined
doordash jamba juice hanford
186 12th Avenue, Hanford, CA, 93230
59 mstratum controlnot joined
overture Cold Stone Creamery
186 N 12th Ave, Ste 111, Hanford, CA, 93230
59 mstratum controlnot joined
doordash dickey's barbecue pit catering hanford
240 12th Avenue, Hanford, CA, 93230
59 mstratum controlnot joined
doordash cold stone creamery hanford
186 12th Avenue, Hanford, CA, 93230
66 mstratum controlnot joined
ubereats Cold Stone Creamery
186 N 12Th Ave Ste 111, Hanford, CA, 93230
67 mstratum controlnot joined
doordash pieology pizzeria hanford
1693 West Lacey Boulevard, Hanford, CA, 93230
69 mstratum controlnot joined
overture Pieology Pizzeria
1693 W Lacey Blvd Suite B, Hanford, CA, 93230
72 mstratum controlnot joined
overture GameStop
186 N 12th Ave, Hanford, CA, 93230
72 mstratum controlnot joined
ca-abc SUPER BUFFET
208 N 12TH AVE, HANFORD, CA, 93230
79 msame source — different name: never merged within one sourcenot joined
ca-abc ROUND TABLE PIZZA #1005
208 N 12TH AVE, HANFORD, CA, 93230
79 msame source — different name: never merged within one sourcenot joined
ca-abc ROUND TABLE PIZZA STORE #1005
208 N 12TH AVE, HANFORD, CA, 93230
79 msame source — different name: never merged within one sourcenot joined
roundtable Round Table Pizza
208 North 12th Avenue, Hanford, CA, 93230
79 mstratum controlnot joined
ab-inbev ROUND TABLE PIZZA
208 N 12TH AVE STE 112 113, HANFORD, CA, 93230
88 mstratum controlnot joined
doordash subway hanford
186 12th Avenue, Hanford, CA, 93230
93 mstratum controlnot joined
ubereats GameStop
186 NORTH 12th AVE STE 109, Hanford, CA, 93230
94 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 O4d7a124b143a: 5 record(s) from ab-inbev, ca-abc, overture, walmart-stores.
RecordDistanceWhat the rule saysWhat the master did
ca-abc WALMART SUPERCENTER 1645
250 S 12TH AVE, HANFORD, CA, 93230
0 msame source — identical name: a duplicate listingjoined (premises-id)
overture Walmart Pharmacy
250 S 12th Ave, Hanford, CA, 93230
300 maddress+name rule: does not pass (name similarity 0.55)same outlet (through another record)
ab-inbev WALMART SUPERCENTER
250 S 12TH AVE, HANFORD, CA, 93230
457 maddress+name rule: does not pass (name similarity 0.78)same outlet (through another record)
walmart-stores Walmart
250 S 12th Ave, Hanford, CA, 93230
506 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.