Match tracker
KEG N BOTTLE #9
ca-abc · 3773 AVOCADO BLVD, LA MESA, CA, 91941
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: KEG N BOTTLE #9✓ Street with a house number: 3773 AVOCADO BLVD✓ ZIP: 91941✓ City + state: LA MESA, CA✓ Pin (lat/lng): 32.74815, -116.96192✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
5 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| inspections KEG N BOTTLE 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc KEG N BOTTLE #9 3773 AVOCADO BLVD, LA MESA, CA, 91941 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| snap Keg N Bottle 9 3773 Avocado Blvd, La Mesa, CA, 91941 | 10 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-tobacco KEG N BOTTLE - RANCHO SAN DIEGO 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | address+name rule: does not pass (name similarity 0.54) | not joined |
| ubereats Pink Dot Rancho San Diego 3773 Avocado Boulevard, La Mesa, CA, 91941 | 127 m | address+name rule: does not pass (name similarity 0.18) | not joined |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
5 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| inspections KEG N BOTTLE 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc KEG N BOTTLE #9 3773 AVOCADO BLVD, LA MESA, CA, 91941 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| snap Keg N Bottle 9 3773 Avocado Blvd, La Mesa, CA, 91941 | 10 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-tobacco KEG N BOTTLE - RANCHO SAN DIEGO 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | address+name rule: does not pass (name similarity 0.54) | not joined |
| ubereats Pink Dot Rancho San Diego 3773 Avocado Boulevard, La Mesa, CA, 91941 | 127 m | address+name rule: does not pass (name similarity 0.18) | 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?
39 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 |
|---|---|---|---|
| inspections KEG N BOTTLE 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | stratum addr-agree | joined (address+name) |
| ca-abc KEG N BOTTLE #9 3773 AVOCADO BLVD, LA MESA, CA, 91941 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| snap Keg N Bottle 9 3773 Avocado Blvd, La Mesa, CA, 91941 | 10 m | stratum addr-agree | joined (address+name) |
| ca-tobacco KEG N BOTTLE - RANCHO SAN DIEGO 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | stratum near | not joined |
| inspections STARBUCKS 3777 AVOCADO BLVD, La Mesa, CA, 91941 | 1 m | stratum control | not joined |
| inspections MCDONALDS 5579 3781 AVOCADO BLVD, La Mesa, CA, 91941 | 1 m | stratum control | not joined |
33 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| inspections WING STOP #136 3759 AVOCADO BLVD, La Mesa, CA, 91941 | 2 m | stratum control | not joined |
| inspections MACHO TACOS 3757 AVOCADO BLVD, La Mesa, CA, 91941 | 2 m | stratum control | not joined |
| inspections NUTRIMART RANCHO SAN DIEGO 3753 AVOCADO BLVD, La Mesa, CA, 91941 | 3 m | stratum control | not joined |
| nppes CVS Pharmacy #09162 3749 AVOCADO BLVD, La Mesa, CA, 91941 | 3 m | stratum control | not joined |
| ca-abc CVS PHARMACY STORE 9162 3749 AVOCADO BLVD, LA MESA, CA, 91941 | 3 m | same source — different name: never merged within one source | not joined |
| inspections CVS PHARMACY #9162 3749 AVOCADO BLVD, La Mesa, CA, 91941 | 3 m | stratum control | not joined |
| cvs CVS Pharmacy 3749 Avocado Blvd, La Mesa, CA, 91941 | 3 m | stratum control | not joined |
| ca-abc FRANKS PIZZA JOINT 3741 AVOCADO BLVD, LA MESA, CA, 91941 | 4 m | same source — different name: never merged within one source | not joined |
| inspections FRANKS PIZZA JOINT 3741 AVOCADO BLVD, La Mesa, CA, 91941 | 4 m | stratum control | not joined |
| inspections SUBWAY 3739 AVOCADO BLVD 11B, La Mesa, CA, 91941 | 5 m | stratum control | not joined |
| inspections FRUITY LOCO 3723 AVOCADO BLVD, La Mesa, CA, 91941 | 7 m | stratum control | not joined |
| ca-abc TAPPI SUSHI & GRILL 3709 AVOCADO BLVD, LA MESA, CA, 91941 | 9 m | same source — different name: never merged within one source | not joined |
| inspections TAPPI SUSHI AND GRILL 3709 AVOCADO BLVD, La Mesa, CA, 91941 | 9 m | stratum control | not joined |
| dominos Domino's 3707 Avocado Blvd., La Mesa, CA, 91941 | 9 m | stratum control | not joined |
| inspections DOMINOS PIZZA #8562 3707 AVOCADO BLVD, La Mesa, CA, 91941 | 9 m | stratum control | not joined |
| ca-abc PHRA RAM 9 3705 AVOCADO BLVD, LA MESA, CA, 91941 | 9 m | same source — different name: never merged within one source | not joined |
| inspections PR9 THAI REESTAURANT 3705 AVOCADO BLVD, La Mesa, CA, 91941 | 9 m | stratum control | not joined |
| inspections PADA SUSHI 3681 AVOCADO BLVD, La Mesa, CA, 91941 | 13 m | stratum control | not joined |
| inspections SMART AND FINAL EXTRA #934 3681 AVOCADO BLVD, La Mesa, CA, 91941 | 13 m | stratum control | not joined |
| ca-abc SMART & FINAL STORE #934 3681 AVOCADO BLVD, LA MESA, CA, 91941 | 13 m | same source — different name: never merged within one source | not joined |
| inspections GOLDEN BAY ASIAN FOOD 3641 AVOCADO BLVD, La Mesa, CA, 91941 | 18 m | stratum control | not joined |
| ca-abc JJANG KOREAN BBQ 3637 AVOCADO BLVD, LA MESA, CA, 91941 | 19 m | same source — different name: never merged within one source | not joined |
| inspections JJANG KOREAN BBQ 3637 AVOCADO BLVD, La Mesa, CA, 91941 | 19 m | stratum control | not joined |
| inspections 24 HOUR FITNESS 3633 AVOCADO BLVD, La Mesa, CA, 91941 | 19 m | stratum control | not joined |
| snap CVS Pharmacy 9162 3749 Avocado Blvd, La Mesa, CA, 91941 | 69 m | stratum control | not joined |
| doordash swipe connect la mesa 3835 Avocado Blvd, La Mesa, CA, 91941 | 79 m | stratum control | not joined |
| ab-inbev FRANKS PIZZA JOINT 3741 AVOCADO BLVD, LA MESA, CA, 91941 | 82 m | stratum control | not joined |
| ab-inbev TOPPI SUSHI & GRILL 3709 AVOCADO BLVD, LA MESA, CA, 91941 | 82 m | stratum control | not joined |
| ab-inbev CVS PHARMACY 3749 AVOCADO BLVD, LA MESA, CA, 91941 | 82 m | stratum control | not joined |
| overture McDonald's 3781 Avocado Blvd, La Mesa, CA, 91941 | 86 m | stratum control | not joined |
| ubereats McDonald's® 3781 Avocado Blvd, La Mesa, CA, 91941 | 91 m | stratum control | not joined |
| doordash mcdonalds la mesa 3781 Avocado Boulevard, La Mesa, CA, 91941 | 93 m | stratum control | not joined |
| overture Swipe Connect 3835 Avocado Blvd Ste. 260, La Mesa, CA, 91941 | 95 m | stratum control | not 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 with | Answer | What the master did |
|---|---|---|
| ubereats Keg N Bottle - La Mesa 7301 3681 Avocado Blvd, La Mesa, CA, 91941 | claude-haiku-5-5:v7:medium: same (0.72) — Both records name Keg N Bottle in La Mesa, CA 91941, and their coordinates are about 128 m apart, which supports one premises. The street numbers differ (3773 vs a garbled 7301 3681), so the address match is imperfect, and the Uber Eats lis claude-opus-5-5:v7:medium: same (0.68) — Both are Keg N Bottle in La Mesa on Avocado Blvd, 128 m apart, with only one business recorded at the address; the Uber Eats street number '7301 3681' looks garbled rather than a separate branch, and the listing is named simply 'Keg N Bottl | same outlet (through another record) |
| ubereats Pink Dot Rancho San Diego 3773 Avocado Boulevard, La Mesa, CA, 91941 | claude-haiku-5-5:v9:medium: different (0.80) — Both records share 3773 Avocado Blvd, La Mesa, but the names are unrelated (KEG N BOTTLE #9 off-sale liquor licence versus the Pink Dot Rancho San Diego Uber Eats listing for the Pink Dot @ Raas chain), and the address holds two differently | 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 O5cc869e12784: 5 record(s) from ca-abc, inspections, snap, ubereats.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| inspections KEG N BOTTLE 3773 AVOCADO BLVD, La Mesa, CA, 91941 | 0 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc KEG N BOTTLE #9 3773 AVOCADO BLVD, LA MESA, CA, 91941 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| snap Keg N Bottle 9 3773 Avocado Blvd, La Mesa, CA, 91941 | 10 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ubereats Keg N Bottle - La Mesa 7301 3681 Avocado Blvd, La Mesa, CA, 91941 | 128 m | address+name rule: does not pass (name similarity 0.68) | 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.