Match tracker

HAMMERSTEIN LIGHT HOUSE LIQUOR
mi-lcc · 13651 W 9 Mile Rd, Oak Park, MI, 48237
Trace another record of this outlet: ab-inbevdoordashmi-lcc ✓mi-lccoverturevtinfo
Joined with 5 other record(s) — by duplicate-listing.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng), phone
✓ Name: HAMMERSTEIN LIGHT HOUSE LIQUOR✓ Street with a house number: 13651 W 9 Mile Rd✓ ZIP: 48237✓ City + state: Oak Park, MI✓ Pin (lat/lng): 42.45972, -83.18264✓ Phone: 2485489790

2. Address joined

Is anyone else at this street + ZIP?
3 found (2 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMMERSTEIN LIGHT HOUSE LIQUOR
13651 W 9 Mile Rd, Oak Park, MI, 48237
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
32 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
vtinfo LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
45 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
3 found (2 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMMERSTEIN LIGHT HOUSE LIQUOR
13651 W 9 Mile Rd, Oak Park, MI, 48237
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
32 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
vtinfo LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
45 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)

4. Street spelling found, not joined

Same house number, street written differently?
2 found (2 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
overture Lighthouse Liquor
13651 W Nine Mile Rd, Oak Park, MI, 48237
36 mstreet-variant rule: does not passsame outlet (through another record)
doordash lighthouse liquor oak park
13651 West Nine Mile Road, Oak Park, MI, 48237
44 mstreet-variant rule: does not passsame outlet (through another record)

5. Nearby pins found, not joined

Anyone within 100 m?
19 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
mi-lcc HAMMERSTEIN LIGHT HOUSE LIQUOR
13651 W 9 Mile Rd, Oak Park, MI, 48237
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
32 mstratum same-addresssame outlet (through another record)
overture Lighthouse Liquor
13651 W Nine Mile Rd, Oak Park, MI, 48237
36 mstratum same-addresssame outlet (through another record)
doordash lighthouse liquor oak park
13651 West Nine Mile Road, Oak Park, MI, 48237
44 mstratum same-addresssame outlet (through another record)
vtinfo LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
45 mstratum same-addresssame outlet (through another record)
overture Tim Hortons
22211 Coolidge Hwy, Oak Park, MI, 48237
49 mstratum controlnot joined
13 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc CVS/PHARMACY #8106
23001 Coolidge Hwy, Oak Park, MI, 48237
49 msame source — different name: never merged within one sourcenot joined
mi-lcc CVS/PHARMACY #8106
23001 Coolidge Hwy, Oak Park, MI, 48237
49 msame source — different name: never merged within one sourcenot joined
cvs CVS Pharmacy
23001 Coolidge Hwy, Oak Park, MI, 48237
49 mstratum controlnot joined
doordash tim hortons oak park
22211 Coolidge Highway, Oak Park, MI, 48237
52 mstratum controlnot joined
doordash cvs oak park
23001 Coolidge Highway, Oak Park, MI, 48237
53 mstratum controlnot joined
overture CVS Pharmacy
23001 Coolidge Hwy, Oak Park, MI, 48237
53 mstratum controlnot joined
mi-lcc DANNY'S FINE WINE
23063 Coolidge Hwy, Oak Park, MI, 48237
73 msame source — different name: never merged within one sourcenot joined
ab-inbev DANNYS FINE WINE
23063 COOLIDGE RD, OAK PARK, MI, 48237
76 mstratum controlnot joined
ab-inbev CVS PHARMACY
23001 COOLIDGE HWY, OAK PARK, MI, 48237
76 mstratum controlnot joined
doordash happy's pizza oak park
13700 West Nine Mile Road, Oak Park, MI
81 mstratum controlnot joined
ubereats The Best Damn Salad
13710 West Nine Mile Road, Oak Park, MI, 48237
83 mstratum controlnot joined
doordash china city restaurant oak park
13715 W 9 Mile Rd, Oak Park, MI, 48237
90 mstratum controlnot joined
exxonmobil Mobil
13551 W.9 MILE RD., OAK PARK, MI, 48237
97 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 5 other record(s)
Outlet O27b318d39490: 6 record(s) from ab-inbev, doordash, mi-lcc, overture, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMMERSTEIN LIGHT HOUSE LIQUOR
13651 W 9 Mile Rd, Oak Park, MI, 48237
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
32 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
overture Lighthouse Liquor
13651 W Nine Mile Rd, Oak Park, MI, 48237
36 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
doordash lighthouse liquor oak park
13651 West Nine Mile Road, Oak Park, MI, 48237
44 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
vtinfo LIGHTHOUSE LIQUOR
13651 W 9 MILE RD, OAK PARK, MI, 48237
45 maddress+name rule: does not pass (name similarity 0.40)same outlet (through another record)
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.