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