Match tracker

CVS/PHARMACY #8157
mi-lcc · 25380 5 Mile Rd, Redford, MI, 48239
Joined with 8 other record(s) — by address+name, name-contained.

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 #8157✓ Street with a house number: 25380 5 Mile Rd✓ ZIP: 48239✓ City + state: Redford, MI✓ Pin (lat/lng): 42.39975, -83.29111✓ Phone: 4017651500

2. Address joined

Is anyone else at this street + ZIP?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
nppes CVS PHARMACY #08157
25380 5 MILE RD, Redford, MI, 48239
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ubereats CVS
25380 5 Mile Rd, Redford, MI, 48239
29 maddress+name rule: passes (name similarity 0.45)joined (name-contained)
overture CVS Pharmacy
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 1.00)joined (address+name)
snap CVS 8157
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 0.65)joined (address+name)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
4 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
nppes CVS PHARMACY #08157
25380 5 MILE RD, Redford, MI, 48239
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ubereats CVS
25380 5 Mile Rd, Redford, MI, 48239
29 maddress+name rule: passes (name similarity 0.45)joined (name-contained)
overture CVS Pharmacy
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 1.00)joined (address+name)
snap CVS 8157
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 0.65)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
cvs CVS Pharmacy
25380 Five Mile Rd, Redford, MI, 48239
0 mstreet-variant rule: passessame outlet (through another record)
ab-inbev CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
25 mstreet-variant rule: passessame outlet (through another record)
vtinfo CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
35 mstreet-variant rule: passessame outlet (through another record)
doordash cvs redford charter township
25380 Five Mile Road, Redford Charter Township, MI, 48239
42 mstreet-variant rule: does not passsame outlet (through another record)

5. Nearby pins found, not joined

Anyone within 100 m?
15 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
nppes CVS PHARMACY #08157
25380 5 MILE RD, Redford, MI, 48239
0 mstratum addr-agreejoined (address+name)
cvs CVS Pharmacy
25380 Five Mile Rd, Redford, MI, 48239
0 mstratum proximitysame outlet (through another record)
ab-inbev CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
25 mstratum proximitysame outlet (through another record)
ubereats CVS
25380 5 Mile Rd, Redford, MI, 48239
29 mstratum addr-agreejoined (name-contained)
vtinfo CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
35 mstratum proximitysame outlet (through another record)
doordash cvs redford charter township
25380 Five Mile Road, Redford Charter Township, MI, 48239
42 mstratum nearsame outlet (through another record)
9 more
RecordDistanceWhat the rule saysWhat the master did
overture CVS Pharmacy
25380 5 Mile Rd, Redford, MI, 48239
43 mstratum addr-agreejoined (address+name)
snap CVS 8157
25380 5 Mile Rd, Redford, MI, 48239
43 mstratum addr-agreejoined (address+name)
inspections GOLDEN GRILL
25385 5 MILE RD, Redford, MI, 48239
19 mstratum controlnot joined
ab-inbev ANCIENT ORDER HIBERNIANS
25300 5 MILE RD, REDFORD, MI, 48239
41 mstratum controlnot joined
vtinfo ANCIENT ORDER HIBERNIANS
25300 5 MILE RD, REDFORD, MI, 48239
43 mstratum controlnot joined
inspections ANCIENT ORDER OF HIBERNIANS
25300 5 MILE RD, Redford, MI, 48239
73 mstratum controlnot joined
doordash golden grill redford redford
25385 5 Mile Rd, Redford, MI, 48239
78 mstratum controlnot joined
overture Ancient Order of Hibernians
25300 Five Mile Rd, Redford, MI, 48239
88 mstratum controlnot joined
mi-lcc ANCIENT ORDER OF HIBERNIANS BUILDING CORPORATION
25300 5 Mile Rd, Redford, MI, 48239
99 msame source — different name: never merged within one sourcenot joined

6. Claude judge found, not joined

What did Claude's judge say?
answered 1 pair(s)
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
cvs CVS Pharmacy
25380 Five Mile Rd, Redford, MI, 48239
claude-haiku-5-5:v9:medium: same (0.93) — Both records are the CVS pharmacy at 25380 Five Mile Rd (5 Mile Rd), Redford MI 48239 with identical coordinates, one business at the address, and the mi-lcc licence holder is the CVS store entity, so this is the same outlet's pharmacy depasame outlet (through another record)

7. Web agent found, not joined

What did the web agent find?
researched 1 pair(s)
Pair withAnswerWhat the master did
cvs CVS Pharmacy
25380 Five Mile Rd, Redford, MI, 48239
claude-haiku-5-5:v1:medium: same (0.85) — Both records have identical coordinates (42.39975, -83.29111) and the same chain name, and the only difference is the street spelling ("Five Mile Rd" vs "5 Mile Rd"). Public listings show the Redford CVS as store #8157 at 25380 Five Mile / same outlet (through another record)

8. Person nothing found

What did a person answer?
no answers yet

9. Result joined

Where did it end up?
one outlet with 8 other record(s)
Outlet O24fa9d592674: 9 record(s) from ab-inbev, cvs, doordash, mi-lcc, nppes, overture, snap, ubereats, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
nppes CVS PHARMACY #08157
25380 5 MILE RD, Redford, MI, 48239
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
cvs CVS Pharmacy
25380 Five Mile Rd, Redford, MI, 48239
0 maddress+name rule: does not pass (name similarity 1.00)same outlet (through another record)
ab-inbev CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
25 maddress+name rule: does not pass (name similarity 1.00)same outlet (through another record)
ubereats CVS
25380 5 Mile Rd, Redford, MI, 48239
29 maddress+name rule: passes (name similarity 0.45)joined (name-contained)
vtinfo CVS PHARMACY
25380 FIVE MILE RD, REDFORD, MI, 48239
35 maddress+name rule: does not pass (name similarity 1.00)same outlet (through another record)
doordash cvs redford charter township
25380 Five Mile Road, Redford Charter Township, MI, 48239
42 maddress+name rule: does not pass (name similarity 0.28)same outlet (through another record)
2 more
RecordDistanceWhat the rule saysWhat the master did
overture CVS Pharmacy
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 1.00)joined (address+name)
snap CVS 8157
25380 5 Mile Rd, Redford, MI, 48239
43 maddress+name rule: passes (name similarity 0.65)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.