Match tracker

TOTAL WINE & MORE
ca-abc · 1750 HARRISON ST, SAN FRANCISCO, CA, 94103
Joined with 7 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: TOTAL WINE & MORE✓ Street with a house number: 1750 HARRISON ST✓ ZIP: 94103✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.76906, -122.41350✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
7 found (5 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingjoined (premises-id)
ubereats Total Wine & More
1750 Harrison Street, San Francisco, CA, 94103
47 maddress+name rule: passes (name similarity 1.00)joined (address+name)
totalwine Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)joined (address+name)

3. City key joined

Anyone at this street in this city (no ZIP needed)?
7 found (5 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingjoined (premises-id)
ubereats Total Wine & More
1750 Harrison Street, San Francisco, CA, 94103
47 maddress+name rule: passes (name similarity 1.00)joined (address+name)
totalwine Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)joined (address+name)

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 TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingjoined (premises-id)
ubereats Total Wine & More
1750 Harrison Street, San Francisco, CA, 94103
47 mstratum addr-agreejoined (address+name)
totalwine Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 mstratum addr-agreejoined (address+name)
overture Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 mstratum addr-agreejoined (address+name)
ab-inbev TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 mstratum addr-agreejoined (address+name)
7 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 mstratum addr-agreejoined (address+name)
doordash el tonayense san francisco
1719 Harrison St, San Francisco, CA, 94103
27 mstratum controlnot joined
overture El Tonayense
1719 Harrison St, San Francisco, CA, 94103
29 mstratum controlnot joined
ubereats Best Buy
1717 Harrison St, San Francisco, CA, 94103
41 mstratum controlnot joined
ca-abc SUE MILLS INC
1830 HARRISON ST, SAN FRANCISCO, CA, 94103
69 msame source — different name: never merged within one sourcenot joined
overture Best Buy
1717 Harrison St, San Francisco, CA, 94103
74 mstratum controlnot joined
doordash best buy san francisco
1717 Harrison Street, San Francisco, CA, 94103
79 mstratum controlnot 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
ubereats Total Wine & More
1750 Harrison Street, San Francisco, CA, 94103
claude-opus-5-5:v3:medium: same (0.97) — The name is identical and both records give the same street address and ZIP, 1750 Harrison St, San Francisco 94103, with only one business recorded at that address.joined (address+name)

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 O2109079e6b95: 8 record(s) from ab-inbev, ca-abc, overture, totalwine, ubereats, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
0 msame source — identical name: a duplicate listingjoined (premises-id)
ubereats Total Wine & More
1750 Harrison Street, San Francisco, CA, 94103
47 maddress+name rule: passes (name similarity 1.00)joined (address+name)
totalwine Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture Total Wine & More
1750 Harrison St, San Francisco, CA, 94103
61 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo TOTAL WINE & MORE
1750 HARRISON ST, SAN FRANCISCO, CA, 94103
63 maddress+name rule: passes (name similarity 1.00)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.