Match tracker

JOHNS GRILL
ca-abc · 63 ELLIS ST, SAN FRANCISCO, CA, 94102
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: JOHNS GRILL✓ Street with a house number: 63 ELLIS ST✓ ZIP: 94102✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.78545, -122.40777✗ 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 JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
vtinfo JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
40 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture John's Grill
63 Ellis St, San Francisco, CA, 94102
48 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
51 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash john's grill san francisco
63 Ellis St, San Francisco, CA, 94102
52 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
toast Johns Grill 63 Ellis St
63 Ellis St, San Francisco, CA, 94102
57 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 JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
vtinfo JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
40 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture John's Grill
63 Ellis St, San Francisco, CA, 94102
48 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
51 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash john's grill san francisco
63 Ellis St, San Francisco, CA, 94102
52 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
toast Johns Grill 63 Ellis St
63 Ellis St, San Francisco, CA, 94102
57 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?
at least 40 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 JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
overture John's Grill
63 Ellis St, San Francisco, CA, 94102
48 mstratum addr-agreejoined (address+name)
overture Urban Outfitters
80 Powell St, San Francisco, CA, 94102
7 mstratum controlnot joined
ca-abc HOTEL UNION SQUARE
114 POWELL ST, SAN FRANCISCO, CA, 94102
25 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
34 more
RecordDistanceWhat the rule saysWhat the master did
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL ABRI
127 ELLIS ST, SAN FRANCISCO, CA, 94102
29 msame source — different name: never merged within one sourcenot joined
ca-abc TADS STEAK RESTAURANT
120 POWELL ST, SAN FRANCISCO, CA, 94102
31 msame source — different name: never merged within one sourcenot joined
overture Burger King
35 Powell Street, San Francisco, CA, 94102
32 mstratum controlnot joined
overture CitizenM
72 Ellis St, San Francisco, CA, 94102
39 mstratum controlnot joined
overture Sephora
33 Powell St, San Francisco, CA, 94102
42 mstratum controlnot joined
ca-abc CITIZENM
72 ELLIS ST, SAN FRANCISCO, CA, 94102
42 msame source — different name: never merged within one sourcenot joined
ubereats Burger King
35 Powell Street, SAN FRANCISCO, CA, 94102
46 mstratum controlnot joined
ca-abc INFUSION LOUNGE
124 ELLIS ST, SAN FRANCISCO, CA, 94102
49 msame source — different name: never merged within one sourcenot joined
ca-abc INFUSION LOUNGE
124 ELLIS ST, SAN FRANCISCO, CA, 94102
49 msame source — different name: never merged within one sourcenot joined
doordash burger king san francisco
35 Powell St, San Francisco, CA, 94102
57 mstratum controlnot joined
overture Hotel Abri
127 Ellis St, San Francisco, CA, 94102
61 mstratum controlnot joined
doordash little sweet san francisco
28 Cyril Magnin Street, San Francisco, CA, 94102
62 mstratum controlnot joined
doordash sephora san francisco
33 Powell Street, San Francisco, CA, 94102
65 mstratum controlnot joined
doordash tad's steakhouse san francisco
38 Ellis Street, San Francisco, CA, 94102
70 mstratum controlnot joined
ca-abc ABSTEAK BY CHEF AKIRA BACK
124-140 ELLIS ST, SAN FRANCISCO, CA, 94102
71 msame source — different name: never merged within one sourcenot joined
overture Infusion Lounge
124 Ellis St, San Francisco, CA, 94102
72 mstratum controlnot joined
ubereats Walgreens
135 Powell St, CA, 94102
72 mstratum controlnot joined
overture Axiom Hotel
28 Cyril Magnin St, San Francisco, CA, 94102
72 mstratum controlnot joined
overture Magnin Street Cafe & Bistro
138 CYRIL MAGNIN St, SAN FRANCISCO, CA, 94102
84 mstratum controlnot joined
ca-abc TADS STEAKHOUSE
44 ELLIS ST, SAN FRANCISCO, CA, 94102
84 msame source — different name: never merged within one sourcenot joined
ubereats Bowl-O-India
138 Cyril Magnin St, San Francisco, CA, 94102
85 mstratum controlnot joined
ca-abc KING KEE
101 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102
87 msame source — different name: never merged within one sourcenot joined
ca-abc AMAZING KITCHEN
101 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102
87 msame source — different name: never merged within one sourcenot joined
ubereats Miyabiya Sushi and Grill
115 Cyril Magnin St, San Francisco, CA, 94102
87 mstratum controlnot joined
doordash miyabi fusion japanese cuisine inc san francisco
115 Cyril Magnin Street, San Francisco, CA, 94102
90 mstratum controlnot joined
ca-abc HANA ZEN YAKI TORI AND SUSHI BAR
115 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102
91 msame source — different name: never merged within one sourcenot joined
ca-abc CABLE CAR CITY PUB & CAFE
1 HALLIDIE PLZ, SAN FRANCISCO, CA, 94102
92 msame source — different name: never merged within one sourcenot joined
overture King Kee
101 Cyril Magnin St, San Francisco, CA, 94102
95 mstratum controlnot joined
overture Amazing Kitchen
101 Cyril Magnin St, San Francisco, CA, 94102
97 mstratum controlnot joined
doordash new delhi restaurant san francisco
160 Ellis Street, San Francisco, CA, 94102
97 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 7 other record(s)
Outlet O02a3e2ac00ef: 8 record(s) from ab-inbev, ca-abc, doordash, overture, toast, vtinfo.
RecordDistanceWhat the rule saysWhat the master did
ca-abc JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
vtinfo JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
40 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture John's Grill
63 Ellis St, San Francisco, CA, 94102
48 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev JOHNS GRILL
63 ELLIS ST, SAN FRANCISCO, CA, 94102
51 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash john's grill san francisco
63 Ellis St, San Francisco, CA, 94102
52 maddress+name rule: passes (name similarity 1.00)joined (address+name)
1 more
RecordDistanceWhat the rule saysWhat the master did
toast Johns Grill 63 Ellis St
63 Ellis St, San Francisco, CA, 94102
57 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.