Match tracker

LIQUORAMA
ca-abc · 901 W FOOTHILL BLVD, UPLAND, CA, 91786
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: LIQUORAMA✓ Street with a house number: 901 W FOOTHILL BLVD✓ ZIP: 91786✓ City + state: UPLAND, CA✓ Pin (lat/lng): 34.10703, -117.66309✗ 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 LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ab-inbev LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
135 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ubereats The Liquor Store - Upland
901 W. Foothill Blvd., Upland, CA, 91786
136 maddress+name rule: passes (name similarity 0.61)joined (address+name)
overture Liquorama
901 W Foothill Blvd, Upland, CA, 91786
137 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash liquorama upland
901 W Foothill Blvd, Upland, CA, 91786
138 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
164 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 LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ab-inbev LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
135 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ubereats The Liquor Store - Upland
901 W. Foothill Blvd., Upland, CA, 91786
136 maddress+name rule: passes (name similarity 0.61)joined (address+name)
overture Liquorama
901 W Foothill Blvd, Upland, CA, 91786
137 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash liquorama upland
901 W Foothill Blvd, Upland, CA, 91786
138 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
164 maddress+name rule: passes (name similarity 1.00)joined (address+name)

4. Street spelling found, not joined

Same house number, street written differently?
1 found (1 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
ubereats Liquorama
901 W Foothill Blvd A Suite A, Upland, CA, 91786
142 mstreet-variant rule: passesheld (street-variant: same-source-conflict)

5. Nearby pins found, not joined

Anyone within 100 m?
14 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 LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc RED DEVIL PIZZA
907 W FOOTHILL BLVD, UPLAND, CA, 91786
12 msame source — different name: never merged within one sourcenot joined
ca-abc THE TACO MAN TAQUERIA
891 W FOOTHILL BLVD, UPLAND, CA, 91786
20 msame source — different name: never merged within one sourcenot joined
vtinfo HI BROW LOUNGE
925 W FOOTHILL BLVD, UPLAND, CA, 91786
46 mstratum controlnot joined
ca-abc HI BROW
925-927 W FOOTHILL BLVD, UPLAND, CA, 91786
53 msame source — different name: never merged within one sourcenot joined
8 more
RecordDistanceWhat the rule saysWhat the master did
doordash tanya's lebanese kabab halal upland
915 West Foothill Boulevard, Upland, CA
63 mstratum controlnot joined
ab-inbev RED DEVIL PIZZA
907 W FOOTHILL BLVD, UPLAND, CA, 91786
80 mstratum controlnot joined
ab-inbev HI BROW LOUNGE
925 W FOOTHILL BLVD, UPLAND, CA, 91786
80 mstratum controlnot joined
overture India Bazaar - Upland
919 W Foothill Blvd, Upland, CA, 91786
92 mstratum controlnot joined
overture Red Devil Pizza
907 W Foothill Blvd, Upland, CA, 91786
93 mstratum controlnot joined
toast Mr D S Diner La Verne 919 West Foothill Boulevard
919 West Foothill Boulevard, La Verne, CA, 91750
93 mstratum controlnot joined
vtinfo RED DEVIL PIZZA
907 W FOOTHILL BLVD, UPLAND, CA, 91786
93 mstratum controlnot joined
ubereats India Bazaar Upland
919 W Foothill Blvd, Upland, CA, 91786
99 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 The Liquor Store - Upland
901 W. Foothill Blvd., Upland, CA, 91786
claude-haiku-5-5:v7:medium: different (0.70) — Both records sit at 901 W Foothill Blvd, Upland 91786, but the building is shared (businesses_at_address is 2), so the address alone does not identify the outlet, and the names do not agree: LIQUORAMA (ABC licensee with a bar licence) versujoined (address+name)
doordash liquorama upland
901 W Foothill Blvd, Upland, CA, 91786
claude-opus-5-5:v4:medium: same (0.92) — The DoorDash slug 'liquorama upland' matches the licensed name LIQUORAMA at the identical street address, and the off-sale licence marks it as a store, so the second business at the address does not undermine the name match.
claude-haiku-5-5:v4:medium: same (0.82) — Both records give LIQUORAMA at 901 W Foothill Blvd, Upland, CA 91786, and the DoorDash slug 'liquorama upland' matches the ABC DBA name at the same street address and city. Record A's off-sale liquor licence is the store itself, and its bar
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 O0995672a54b1: 8 record(s) from ab-inbev, ca-abc, doordash, overture, ubereats, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
ca-abc LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc LIQUORAMA
901 W FOOTHILL BLVD, UPLAND, CA, 91786
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ab-inbev LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
135 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ubereats The Liquor Store - Upland
901 W. Foothill Blvd., Upland, CA, 91786
136 maddress+name rule: passes (name similarity 0.61)joined (address+name)
overture Liquorama
901 W Foothill Blvd, Upland, CA, 91786
137 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash liquorama upland
901 W Foothill Blvd, Upland, CA, 91786
138 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
vtinfo LIQUORAMA
901 W FOOTHILL BLVD STE A, UPLAND, CA, 91786
164 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.