Match tracker

ROCKY
ca-abc · 3860 E COLORADO BLVD, PASADENA, CA, 91107
Trace another record of this outlet: ca-abcca-abc ✓
Joined with 1 other record(s) — by premises-id.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: ROCKY✓ Street with a house number: 3860 E COLORADO BLVD✓ ZIP: 91107✓ City + state: PASADENA, CA✓ Pin (lat/lng): 34.14726, -118.06890✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
6 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc ROCKY
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc GARRY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — different name: never merged within one sourcenot joined
ubereats Garry Liquor
3860 E Colorado Blvd, Pasadena, CA, 91107
20 maddress+name rule: does not pass (name similarity 0.15)not joined
doordash garry liquor pasadena
3860 E Colorado Blvd, Pasadena, CA, 91107
23 maddress+name rule: does not pass (name similarity 0.15)not joined
ab-inbev ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
26 maddress+name rule: passes (name similarity 0.54)held (address+name: same-source-conflict)
vtinfo ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
28 maddress+name rule: passes (name similarity 0.54)held (address+name: same-source-conflict)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
6 found (4 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc ROCKY
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc GARRY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — different name: never merged within one sourcenot joined
ubereats Garry Liquor
3860 E Colorado Blvd, Pasadena, CA, 91107
20 maddress+name rule: does not pass (name similarity 0.15)not joined
doordash garry liquor pasadena
3860 E Colorado Blvd, Pasadena, CA, 91107
23 maddress+name rule: does not pass (name similarity 0.15)not joined
ab-inbev ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
26 maddress+name rule: passes (name similarity 0.54)held (address+name: same-source-conflict)
vtinfo ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
28 maddress+name rule: passes (name similarity 0.54)held (address+name: same-source-conflict)

4. Street spelling nothing found

Same house number, street written differently?
no other record found

5. Nearby pins found, not joined

Anyone within 100 m?
13 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
ca-abc ROCKY
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc GARRY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — different name: never merged within one sourcenot joined
ubereats Garry Liquor
3860 E Colorado Blvd, Pasadena, CA, 91107
20 mstratum same-addressnot joined
doordash garry liquor pasadena
3860 E Colorado Blvd, Pasadena, CA, 91107
23 mstratum same-addressnot joined
ab-inbev ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
26 mstratum addr-agreeheld (address+name: same-source-conflict)
ab-inbev EXTRAMILE
3880 E COLORADO BLVD, PASADENA, CA, 91107
26 mstratum controlnot joined
7 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
28 mstratum addr-agreeheld (address+name: same-source-conflict)
doordash the original tops pasadena
3838 East Colorado Boulevard, Pasadena, CA, 91107
61 mstratum controlnot joined
overture The Original Tops
3838 E Colorado Blvd, Pasadena, CA, 91107
63 mstratum controlnot joined
ca-abc PASADENA CHEVRON
3880 E COLORADO BLVD, PASADENA, CA, 91107
69 msame source — different name: never merged within one sourcenot joined
ca-abc ORIGINAL TOPS THE
3838 E COLORADO BLVD, PASADENA, CA, 91107
70 msame source — different name: never merged within one sourcenot joined
ubereats Chevron Extramile
3880 E Colorado Blvd, Pasadena, CA, 91107
73 mstratum controlnot joined
overture ExtraMile
3880 E Colorado Blvd, Pasadena, CA, 91107
74 mstratum controlnot joined

6. Claude judge found, not joined

What did Claude's judge say?
answered 2 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
ubereats Garry Liquor
3860 E Colorado Blvd, Pasadena, CA, 91107
claude-haiku-5-5:v4:medium: different (0.85) — Both records share the same street address and ZIP, but the names do not agree (ROCKY vs Garry Liquor), and the building holds two businesses per our data. The California record is only an active application for an off-sale licence, which p
claude-opus-5-5:v7:medium: different (0.72) — The two records share an address, but the names 'ROCKY' and 'Garry Liquor' are unrelated, the building holds 2 differently-named businesses, and A's off-sale licence is only an application, which points to a successor business at the addres
claude-haiku-5-5:v7:medium: different (0.80) — The California record is named ROCKY and holds only an active off-sale application at 3860 E Colorado Blvd, while the Uber Eats listing is Garry Liquor at the same address. The application-only licence under a different name points to a pre
not joined
doordash garry liquor pasadena
3860 E Colorado Blvd, Pasadena, CA, 91107
claude-haiku-5-5:v7:medium: different (0.80) — The address and ZIP match, but the building holds two businesses and the names disagree: the California record is 'ROCKY', with only a pending off-sale application, while the DoorDash store is 'garry liquor pasadena'.not joined

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 1 other record(s)
Outlet Oa0962987a314: 2 record(s) from ca-abc.
RecordDistanceWhat the rule saysWhat the master did
ca-abc ROCKY
3860 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
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.