Match tracker

CALIFORNIA WINE & COMPANY
ca-abc · 3742 E COLORADO BLVD, PASADENA, CA, 91107
Trace another record of this outlet: ca-abcca-abcca-abcca-abc ✓ttb
Joined with 4 other record(s) — by address+name, premises-id.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: CALIFORNIA WINE & COMPANY✓ Street with a house number: 3742 E COLORADO BLVD✓ ZIP: 91107✓ City + state: PASADENA, CA✓ Pin (lat/lng): 34.14624, -118.07212✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
5 found (2 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ttb CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ttb Kukta Wine & Spirits
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 maddress+name rule: does not pass (name similarity 0.40)not joined

3. City key joined

Anyone at this street in this city (no ZIP needed)?
5 found (2 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ttb CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ttb Kukta Wine & Spirits
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 maddress+name rule: does not pass (name similarity 0.40)not joined

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?
23 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
ttb CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 mstratum addr-agreejoined (address+name)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingjoined (premises-id)
ttb Kukta Wine & Spirits
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 mstratum same-addressnot joined
ca-abc THE RESERVE MARKET
3744 E COLORADO BLVD, PASADENA, CA, 91107
5 msame source — different name: never merged within one sourcenot joined
17 more
RecordDistanceWhat the rule saysWhat the master did
inspections R PLACE
3739 E COLORADO BLVD, Pasadena, CA, 91107
16 mstratum controlnot joined
ca-abc R PLACE
3739 E COLORADO BLVD, PASADENA, CA, 91107
16 msame source — different name: never merged within one sourcenot joined
ca-abc R PLACE
3739 E COLORADO BLVD, PASADENA, CA, 91107
16 msame source — different name: never merged within one sourcenot joined
ca-abc R PLACE
3739 E COLORADO BLVD, PASADENA, CA, 91107
16 msame source — different name: never merged within one sourcenot joined
inspections AKINORI SUSHI
3735 E COLORADO BLVD, Pasadena, CA, 91107
24 mstratum controlnot joined
ca-abc AKINORI SUSHI
3735 E COLORADO BLVD, PASADENA, CA, 91107
24 msame source — different name: never merged within one sourcenot joined
doordash akinori sushi pasadena
3735 E Colorado Blvd, Pasadena, CA, 91107
25 mstratum controlnot joined
overture R Place
3739 E Colorado Blvd, Pasadena, CA, 91107
30 mstratum controlnot joined
vtinfo R PLACE
3739 E COLORADO BLVD, PASADENA, CA, 91107
32 mstratum controlnot joined
overture Akinori Sushi
3735 E Colorado Blvd, Pasadena, CA, 91107
32 mstratum controlnot joined
doordash big 5 sporting goods pasadena
3719 E Colorado Blvd, Pasadena, CA, 91107
55 mstratum controlnot joined
ab-inbev R PLACE
3739 E COLORADO BLVD, PASADENA, CA, 91107
67 mstratum controlnot joined
inspections MANDARIN COFFEE STAND
3768 E COLORADO BLVD, Pasadena, CA, 91107
67 mstratum controlnot joined
ubereats Big 5 Sporting Goods
3719 East Colorado Boulevard, Pasadena, CA, 91107
72 mstratum controlnot joined
overture Big 5 Sporting Goods
3719 E Colorado Blvd, Pasadena, CA, 91107
89 mstratum controlnot joined
ca-abc YANG CHOW RESTAURANT
3777 E COLORADO BLVD, PASADENA, CA, 91107
89 msame source — different name: never merged within one sourcenot joined
inspections YANG CHOW RESTAURANT
3777 E COLORADO BLVD, Pasadena, CA, 91107
89 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 O3a6c9d06cb36: 5 record(s) from ca-abc, ttb.
RecordDistanceWhat the rule saysWhat the master did
ttb CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 E COLORADO BLVD, PASADENA, CA, 91107
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc CALIFORNIA WINE & COMPANY
3742 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.