Match tracker

ROCKY
ca-abc · 3860 E COLORADO BLVD, PASADENA, CA, 91107
Trace another record of this outlet: ca-abc ✓ca-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 3 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:v7:medium: different (0.82) — The California record is only an active application for an off-sale licence under the name ROCKY, while the Uber Eats listing at the same address is Garry Liquor; the names don't match, the building holds two businesses, and an application not joined
doordash garry liquor pasadena
3860 E Colorado Blvd, Pasadena, CA, 91107
claude-haiku-5-5:v7:medium: different (0.80) — The California record is an off-sale licence still at the application stage under the DBA ROCKY, while the DoorDash listing is 'garry liquor pasadena'; the names don't match, the building holds two businesses, and an application at an addrenot joined
ab-inbev ROCKY LIQUOR
3860 E COLORADO BLVD, PASADENA, CA, 91107
claude-haiku-5-5:v9:medium: same (0.85) — Both records sit at 3860 E Colorado Blvd, Pasadena 91107 (distance about 26 m) and carry the same distinctive name 'Rocky' (ROCKY LIQUOR vs ROCKY, legal entity ROCKY GM CORP), with a California off-sale general licence matching a liquor sto
claude-opus-5-5:v9:medium: same (0.87) — Same street address and ZIP, and the names agree: the off-sale liquor-store licence 'ROCKY' (ROCKY GM CORP.) matches the retailer 'ROCKY LIQUOR'.
held (address+name: same-source-conflict)

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.