Match tracker
DOWNTOWN ROOKIES SPORTS BAR & GRILL
ca-abc · 215 E MAIN ST, VISALIA, CA, 93291
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: DOWNTOWN ROOKIES SPORTS BAR & GRILL✓ Street with a house number: 215 E MAIN ST✓ ZIP: 93291✓ City + state: VISALIA, CA✓ Pin (lat/lng): 36.33010, -119.29097✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc DOWNTOWN ROOKIES SPORTS BAR & GRILL 215 E MAIN ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Downtown Rookies Sports Bar and Grill 215 E Main St, Visalia, CA, 93291 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 23 m | address+name rule: passes (name similarity 0.85) | joined (address+name) |
| ab-inbev DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 66 m | address+name rule: passes (name similarity 0.85) | joined (address+name) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc DOWNTOWN ROOKIES SPORTS BAR & GRILL 215 E MAIN ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Downtown Rookies Sports Bar and Grill 215 E Main St, Visalia, CA, 93291 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 23 m | address+name rule: passes (name similarity 0.85) | joined (address+name) |
| ab-inbev DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 66 m | address+name rule: passes (name similarity 0.85) | joined (address+name) |
4. Street spelling found, not joined
Same house number, street written differently?
10 found (9 from another source); none joined by this step
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo QUESADILLA GORILLA 215 W MAIN ST STE 103, VISALIA, CA, 93291 | 234 m | street-variant rule: does not pass | not joined |
| ca-abc QUESADILLA GORILLA 215 W MAIN ST, VISALIA, CA, 93291 | 240 m | same source — different name: never merged within one source | not joined |
| overture Sol Bol Acai 215 W Main St Unit 104, Visalia, CA, 93291 | 288 m | street-variant rule: does not pass | not joined |
| ubereats Bombshell Beans 215 West Main Street, Visalia, CA, 93291 | 291 m | street-variant rule: does not pass | not joined |
| doordash bombshell beans visalia 215 W Main St, Visalia, CA, 93291 | 292 m | street-variant rule: does not pass | not joined |
| ubereats Bombshell Beans 215 West Main Street, Visalia, CA, 93291 | 294 m | street-variant rule: does not pass | not joined |
4 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| doordash quesadilla gorilla visalia 215 West Main Street, Visalia, CA, 93291 | 297 m | street-variant rule: does not pass | not joined |
| doordash sol bol acai visalia 215 West Main Street, Visalia, CA, 93291 | 298 m | street-variant rule: does not pass | not joined |
| overture Quesadilla Gorilla 215 W Main St Ste 103, Visalia, CA, 93291 | 322 m | street-variant rule: does not pass | not joined |
| ab-inbev QUESADILLA GORILLA 215 W MAIN ST STE 103, VISALIA, CA, 93291 | 329 m | street-variant rule: does not pass | not joined |
5. Nearby pins found, not joined
Anyone within 100 m?
34 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc DOWNTOWN ROOKIES SPORTS BAR & GRILL 215 E MAIN ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Downtown Rookies Sports Bar and Grill 215 E Main St, Visalia, CA, 93291 | 17 m | stratum addr-agree | joined (address+name) |
| vtinfo DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 23 m | stratum addr-agree | joined (address+name) |
| ab-inbev DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 66 m | stratum addr-agree | joined (address+name) |
| ca-abc BREWBAKERS BREWING COMPANY 219 E MAIN ST, VISALIA, CA, 93291 | 4 m | same source — different name: never merged within one source | not joined |
| ca-abc TAVERN ON MAIN 221 E MAIN ST, VISALIA, CA, 93291 | 5 m | same source — different name: never merged within one source | not joined |
28 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc TAVERN ON MAIN 221 E MAIN ST, VISALIA, CA, 93291 | 5 m | same source — different name: never merged within one source | not joined |
| doordash sps burgers visalia 100 South Church Street, Visalia, CA, 93291 | 12 m | stratum control | not joined |
| ca-abc SP'S BURGERS 100 S CHURCH ST, VISALIA, CA, 93291 | 12 m | same source — different name: never merged within one source | not joined |
| ca-abc NASH'S 229 E MAIN ST, VISALIA, CA, 93291 | 12 m | same source — different name: never merged within one source | not joined |
| overture SP's Burgers 100 S Church St, Visalia, CA, 93291 | 14 m | stratum control | not joined |
| overture Brewbakers Brewing Co 219 E Main St, Visalia, CA, 93291 | 30 m | stratum control | not joined |
| ab-inbev TPK S TACOS 125 E MAIN ST, VISALIA, CA, 93291 | 32 m | stratum control | not joined |
| doordash love chick in visalia 129 East Main Street, Visalia, CA, 93291 | 37 m | stratum control | not joined |
| ubereats Tavern on Main 221 E Main St, Visalia, CA, 93291 | 40 m | stratum control | not joined |
| doordash tavern on main visalia 221 E Main St, Visalia, CA, 93291 | 40 m | stratum control | not joined |
| overture Tavern on Main 221 E Main St, Visalia, CA, 93291 | 42 m | stratum control | not joined |
| vtinfo TAVERN ON MAIN 221 E MAIN ST, VISALIA, CA, 93291 | 42 m | stratum control | not joined |
| overture TPK's Tacos 125 E Main St, Visalia, CA, 93291 | 43 m | stratum control | not joined |
| doordash tpk's tacos visalia 125 East Main Street, Visalia, CA, 93291 | 44 m | stratum control | not joined |
| ab-inbev TAVERN ON MAIN 221 E MAIN ST, VISALIA, CA, 93291 | 66 m | stratum control | not joined |
| ab-inbev SPS BURGERS 100 S CHURCH ST, VISALIA, CA, 93291 | 70 m | stratum control | not joined |
| ubereats Deli Delicious 200 Acequia Ave, Visalia, CA, 93291 | 72 m | stratum control | not joined |
| doordash deli delicious visalia 200 East Acequia Avenue, Visalia, CA, 93291 | 78 m | stratum control | not joined |
| vtinfo BLEND WINE ROOM 115 E MAIN ST STE 101, VISALIA, CA, 93291 | 79 m | stratum control | not joined |
| overture Blend Wine Room 115 E Main St, Visalia, CA, 93291 | 81 m | stratum control | not joined |
| overture Colima Mexican Restaurant 111 E Main St, Visalia, CA, 93291 | 84 m | stratum control | not joined |
| vtinfo COLIMA MEXICAN RESTAURANT 111 E MAIN ST, VISALIA, CA, 93291 | 86 m | stratum control | not joined |
| ca-abc MULLIGANS 307 E MAIN ST, VISALIA, CA, 93291 | 92 m | same source — different name: never merged within one source | not joined |
| ca-abc MULLIGANS 307 E MAIN ST, VISALIA, CA, 93291 | 92 m | same source — different name: never merged within one source | not joined |
| ca-abc TPK'S TACOS 125 E MAIN ST, VISALIA, CA, 93291 | 92 m | same source — different name: never merged within one source | not joined |
| ca-abc LOS CULICHIS SUSHI AND BAR LLC 309 E MAIN ST, VISALIA, CA, 93291 | 94 m | same source — different name: never merged within one source | not joined |
| overture Lake Bottom Brewery & Distillery - Visalia 105 E Main St, Visalia, CA, 93291 | 99 m | stratum control | not joined |
| ubereats Lake Bottom Brewery, Distillery & Restaurant 105 E Main St, Visalia, CA, 93291 | 99 m | stratum control | not 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 O018325a32b2d: 5 record(s) from ab-inbev, ca-abc, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc DOWNTOWN ROOKIES SPORTS BAR & GRILL 215 E MAIN ST, VISALIA, CA, 93291 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Downtown Rookies Sports Bar and Grill 215 E Main St, Visalia, CA, 93291 | 17 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 23 m | address+name rule: passes (name similarity 0.85) | joined (address+name) |
| ab-inbev DOWNTOWN ROOKIES SPORTS BAR 215 E MAIN ST, VISALIA, CA, 93291 | 66 m | address+name rule: passes (name similarity 0.85) | 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.