Match tracker

CVS/PHARMACY #8191
mi-lcc · 4025 18 Mile Rd, Sterling Heights, MI, 48314
Joined with 7 other record(s) — by duplicate-listing, judge-same.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng), phone
✓ Name: CVS/PHARMACY #8191✓ Street with a house number: 4025 18 Mile Rd✓ ZIP: 48314✓ City + state: Sterling Heights, MI✓ Pin (lat/lng): 42.59367, -83.07052✓ Phone: 5868036271

2. Address joined

Is anyone else at this street + ZIP?
4 found (3 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 maddress+name rule: does not pass (name similarity 0.75)same outlet (through another record)
doordash cvs sterling heights
4025 18 Mile Road, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
72 maddress+name rule: does not pass (name similarity 0.75)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 CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 maddress+name rule: does not pass (name similarity 0.75)same outlet (through another record)
doordash cvs sterling heights
4025 18 Mile Road, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
72 maddress+name rule: does not pass (name similarity 0.75)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
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
71 mstreet-variant rule: does not passsame outlet (through another record)
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
78 mstreet-variant rule: does not passsame outlet (through another record)

5. Nearby pins found, not joined

Anyone within 100 m?
7 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 CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 mstratum nearsame outlet (through another record)
ubereats CVS
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 48160
53 mstratum nearsame outlet (through another record)
doordash cvs sterling heights
4025 18 Mile Road, Sterling Heights, MI, 48314
62 mstratum same-addressjoined (judge-same)
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
71 mstratum nearsame outlet (through another record)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
72 mstratum nearsame outlet (through another record)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
78 mstratum nearsame outlet (through another record)

6. Claude judge joined

What did Claude's judge say?
answered 1 pair(s); its 'same' joined
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 cvs sterling heights
4025 18 Mile Road, Sterling Heights, MI, 48314
claude-haiku-5-5:v9:medium: same (0.93) — Both records are CVS at 4025 18 Mile Road, Sterling Heights, MI 48314 (coordinates within about 60 m), with the DoorDash listing matching the CVS pharmacy licensed premises, and Michigan's rule treats a chain store's alcohol listing at its
claude-opus-5-5:v12:low · pinned: same (0.90) — Same CVS store address; pharmacy listing is same outlet.
joined (judge-same)

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 7 other record(s)
Outlet O0e2bb8eadc93: 8 record(s) from ab-inbev, cvs, doordash, mi-lcc, overture, ubereats, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
mi-lcc CVS/PHARMACY #8191
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
cvs CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
0 maddress+name rule: does not pass (name similarity 0.75)same outlet (through another record)
ubereats CVS
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 48160
53 maddress+name rule: does not pass (name similarity 0.32)same outlet (through another record)
doordash cvs sterling heights
4025 18 Mile Road, Sterling Heights, MI, 48314
62 maddress+name rule: does not pass (name similarity 0.32)joined (judge-same)
ab-inbev CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
71 maddress+name rule: does not pass (name similarity 0.75)same outlet (through another record)
overture CVS Pharmacy
4025 18 Mile Rd, Sterling Heights, MI, 48314
72 maddress+name rule: does not pass (name similarity 0.75)same outlet (through another record)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo CVS PHARMACY
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314
78 maddress+name rule: does not pass (name similarity 0.75)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.