Match tracker

FOODS CO 357
ca-abc · 1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
Trace another record of this outlet: ab-inbevca-abc ✓doordashoverturevtinfo
Joined with 4 other record(s) — by judge-same.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: FOODS CO 357✓ Street with a house number: 1800 FOLSOM ST✓ ZIP: 94103✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.76848, -122.41568✗ Phone

2. Address found, not joined

Is anyone else at this street + ZIP?
5 found (5 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
doordash foods co san francisco
1800 Folsom St, San Francisco, CA, 94103
79 maddress+name rule: does not pass (name similarity 0.61)joined (judge-same)
overture Foods Co.
1800 Folsom St, San Francisco, CA, 94103
89 maddress+name rule: does not pass (name similarity 0.61)same outlet (through another record)
vtinfo FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
96 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
ab-inbev FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
122 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
doordash el alambre san francisco
1800 Folsom St, San Francisco, CA, 94103
47 maddress+name rule: does not pass (name similarity 0.12)not joined

3. City key found, not joined

Anyone at this street in this city (no ZIP needed)?
5 found (5 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
doordash foods co san francisco
1800 Folsom St, San Francisco, CA, 94103
79 maddress+name rule: does not pass (name similarity 0.61)joined (judge-same)
overture Foods Co.
1800 Folsom St, San Francisco, CA, 94103
89 maddress+name rule: does not pass (name similarity 0.61)same outlet (through another record)
vtinfo FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
96 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
ab-inbev FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
122 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
doordash el alambre san francisco
1800 Folsom St, San Francisco, CA, 94103
47 maddress+name rule: does not pass (name similarity 0.12)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?
19 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
doordash foods co san francisco
1800 Folsom St, San Francisco, CA, 94103
79 mstratum nearjoined (judge-same)
overture Foods Co.
1800 Folsom St, San Francisco, CA, 94103
89 mstratum nearsame outlet (through another record)
vtinfo FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
96 mstratum same-addresssame outlet (through another record)
ca-abc PINK ONION
64 14TH ST, SAN FRANCISCO, CA, 94103
33 msame source — different name: never merged within one sourcenot joined
ca-abc YABANI
1779 FOLSOM ST, SAN FRANCISCO, CA, 94103
36 msame source — different name: never merged within one sourcenot joined
doordash el alambre san francisco
1800 Folsom St, San Francisco, CA, 94103
47 mstratum same-addressnot joined
13 more
RecordDistanceWhat the rule saysWhat the master did
doordash bageletto san francisco
76 14th St, San Francisco, CA, 94103
61 mstratum controlnot joined
overture Bageletto
76 14th St, San Francisco, CA, 94103
62 mstratum controlnot joined
overture Rintaro
82 14th St, San Francisco, CA, 94103
63 mstratum controlnot joined
ca-abc RINTARO
82 14TH ST, SAN FRANCISCO, CA, 94103
69 msame source — different name: never merged within one sourcenot joined
ca-abc RINTARO
82 14TH ST, SAN FRANCISCO, CA, 94103
69 msame source — different name: never merged within one sourcenot joined
ubereats Bageletto
76 14th Street, San Francisco, CA, 94103
69 mstratum controlnot joined
ca-abc RAINBOW GROCERY
1745 FOLSOM ST, SAN FRANCISCO, CA, 94103
70 msame source — different name: never merged within one sourcenot joined
doordash pink onion san francisco
64 14th Street, San Francisco, CA, 94103
77 mstratum controlnot joined
overture Pink Onion
64 14th St, San Francisco, CA, 94103
77 mstratum controlnot joined
vtinfo PINK ONION
64 14TH ST, SAN FRANCISCO, CA, 94103
81 mstratum controlnot joined
vtinfo RAINBOW GROCERY
1745 FOLSOM ST, SAN FRANCISCO, CA, 94103
89 mstratum nearnot joined
overture Rainbow Grocery
1745 Folsom St, San Francisco, CA, 94103
89 mstratum nearnot joined
doordash rainbow grocery san francisco
1745 Folsom St, San Francisco, CA, 94103
94 mstratum nearnot joined

6. Claude judge joined

What did Claude's judge say?
answered 2 pair(s); its 'same' joined
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
doordash foods co san francisco
1800 Folsom St, San Francisco, CA, 94103
claude-haiku-5-5:v4:medium: same (0.87) — Both records give the same street address and ZIP (1800 Folsom St, 94103), and the only business there is the Foods Co banner; the ABC name 'FOODS CO 357' is the same chain store with its store number, matching the DoorDash slug 'foods co s
claude-haiku-5-5:v7:medium: same (0.85) — Both records share the same street address, ZIP and city, and the DoorDash listing 'foods co san francisco' matches the Foods Co store at 1800 Folsom St, with the CA ABC record showing an active off-sale liquor licence at that single-busine
claude-opus-5-5:v7:medium: same (0.95) — Both records are the FoodsCo supermarket at 1800 Folsom St, San Francisco 94103, and the address holds only one business; the DoorDash slug simply appends the city to the name.
joined (judge-same)
doordash el alambre san francisco
1800 Folsom St, San Francisco, CA, 94103
claude-haiku-5-5:v7:medium: different (0.90) — The two records share a street address, but the names differ: the California licence is Foods Co 357, a grocery off-sale liquor store, while the DoorDash listing is El Alambre, a separate restaurant, and the data holds two businesses at thi
claude-haiku-5-5:v9:medium: different (0.90) — Record A is a Ralphs/Foods Co grocery store's off-sale liquor licence at 1800 Folsom St, while B is a separate restaurant listing 'el alambre san francisco' at the same address; two businesses share the building (businesses_at_address is 2)
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 4 other record(s)
Outlet O12c34dd658bf: 5 record(s) from ab-inbev, ca-abc, doordash, overture, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
doordash foods co san francisco
1800 Folsom St, San Francisco, CA, 94103
79 maddress+name rule: does not pass (name similarity 0.61)joined (judge-same)
overture Foods Co.
1800 Folsom St, San Francisco, CA, 94103
89 maddress+name rule: does not pass (name similarity 0.61)same outlet (through another record)
vtinfo FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
96 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
ab-inbev FOODSCO
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103
122 maddress+name rule: does not pass (name similarity 0.31)same outlet (through another record)
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.