Match tracker

SCOTCH CASTLE PARTY STORE
mi-lcc · 2867 E 7 Mile Rd, Detroit, MI, 48234
Trace another record of this outlet: ab-inbevmi-lcc ✓mi-lccoverturevtinfo
Joined with 4 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: SCOTCH CASTLE PARTY STORE✓ Street with a house number: 2867 E 7 Mile Rd✓ ZIP: 48234✓ City + state: Detroit, MI✓ Pin (lat/lng): 42.43298, -83.07451✓ Phone: 3133687500

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 SCOTCH CASTLE PARTY STORE
2867 E 7 Mile Rd, Detroit, MI, 48234
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
11 maddress+name rule: does not pass (name similarity 0.64)same outlet (through another record)
vtinfo SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
56 maddress+name rule: does not pass (name similarity 0.64)same outlet (through another record)

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
mi-lcc SCOTCH CASTLE PARTY STORE
2867 E 7 Mile Rd, Detroit, MI, 48234
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
11 maddress+name rule: does not pass (name similarity 0.64)same outlet (through another record)
vtinfo SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
56 maddress+name rule: does not pass (name similarity 0.64)same outlet (through another record)
doordash bellacino's detroit 7 mile detroit
2867 E 7 Mile Rd, Detroit, MI
56 maddress+name rule: does not pass (name similarity 0.11)not joined

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 Scotch Castle Liquor Land
2867 7 Mile Rd E, Detroit, MI, 48234
52 mstreet-variant rule: does not passsame outlet (through another record)
ubereats Bellacino's Pizza & Grinders
2867 Seven Mile East, Detroit, MI, 48234
46 mstreet-variant rule: does not passnot joined

5. Nearby pins found, not joined

Anyone within 100 m?
9 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 SCOTCH CASTLE PARTY STORE
2867 E 7 Mile Rd, Detroit, MI, 48234
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
11 mstratum nearsame outlet (through another record)
overture Scotch Castle Liquor Land
2867 7 Mile Rd E, Detroit, MI, 48234
52 mstratum nearsame outlet (through another record)
vtinfo SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
56 mstratum nearsame outlet (through another record)
ubereats Bellacino's Pizza & Grinders
2867 Seven Mile East, Detroit, MI, 48234
46 mstratum controlnot joined
doordash bellacino's detroit 7 mile detroit
2867 E 7 Mile Rd, Detroit, MI
56 mstratum same-addressnot joined
3 more
RecordDistanceWhat the rule saysWhat the master did
overture Conant Street Grill
19132 Conant, Detroit, MI, 48234
72 mstratum controlnot joined
doordash the new conant street grill detroit
19132 Conant Street, Detroit, MI, 48234
77 mstratum controlnot joined
doordash deluxe coney island detroit
2923 Seven Mile East, Detroit, MI, 48234
100 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 O3da6d5296ccd: 5 record(s) from ab-inbev, mi-lcc, overture, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
mi-lcc SCOTCH CASTLE PARTY STORE
2867 E 7 Mile Rd, Detroit, MI, 48234
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
ab-inbev SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
11 maddress+name rule: does not pass (name similarity 0.64)same outlet (through another record)
overture Scotch Castle Liquor Land
2867 7 Mile Rd E, Detroit, MI, 48234
52 maddress+name rule: does not pass (name similarity 0.56)same outlet (through another record)
vtinfo SCOTCH CASTLE LIQUOR
2867 E 7 MILE RD, DETROIT, MI, 48234
56 maddress+name rule: does not pass (name similarity 0.64)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.