BUBBLES MARKET & SPIRITS

SAN DIEGO, CA 92103 · O2c59d72e919a · first seen 2026-10-08
4 sourcesoff premise · liquor_storealcohol: licensed2 licences

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
BUBBLES MARKET & SPIRITS 1 other
the most common name a source states
DEL MISSION INC ca-abc (legal name) ×2
Street
135 WASHINGTON ST
ca-abcno other value
City
SAN DIEGO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92103
ca-abcno other value
Pin
32.74964, -117.16312 map 1 other
overture
55 m away ca-abc ×2
Phone
6192918550 1 other
vtinfo
6193105782 overture
Licences
ca-abc 00627271|21|LIC|0 · ca-abc 00627271|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O489eab34b404; O50ba304a4d08; O67b4b38a7273; Oe1b01cf568ba

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevBUBBLES MARKET & SPIRITS
4622089
135 WASHINGTON ST, SAN DIEGO, CA, 9210332.74954, -117.163122026-11-112026-11-11
ca-abcBUBBLES MARKET & SPIRITS
legal name: DEL MISSION INC
00627271|21|LIC|0
135 WASHINGTON ST, SAN DIEGO, CA, 9210332.74985, -117.163662026-10-082026-11-05
ca-abcBUBBLES MARKET & SPIRITS
legal name: DEL MISSION INC
00627271|86|LIC|0
135 WASHINGTON ST, SAN DIEGO, CA, 9210332.74985, -117.163662026-10-082026-11-05
overtureBubbles Market & Spirits
912d4b32-7833-4418-804c-ec5df5e3476a
135 Washington St, San Diego, CA, 92103619310578232.74964, -117.163122026-11-062026-11-06
vtinfoBUBBLES MARKET & SPIRITS
a45be517380be360
135 WASHINGTON ST, SAN DIEGO, CA, 92103619291855032.74953, -117.163102026-11-112026-11-13

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ca-abc BUBBLES MARKET & SPIRITSubereats Del Mission Liquor0.71Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Uber name matches licensee legal entity Del Mission, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 135 Washington St, San Diego 92103 (0.058 km apart), and record A's legal entity DEL MISSION INC matches the 'Del Mission Liquor' Uber Eats listing, which is a liquor store like A's off-sale licence; the differing DBA 'Bubbles Market & Spirits' and the second business at the address leave some doubt.
  • Claude Haiku 5.5, prompt v7: different, 85% confident — Same street address and ZIP, but the names differ (Bubbles Market & Spirits vs Del Mission Liquor) and the data holds two businesses at this address, so the address match alone does not establish one outlet.
  • Claude Haiku 5.5, prompt v4: different, 90% confident — Both records share the same street address and ZIP, but the names disagree (BUBBLES MARKET & SPIRITS vs Del Mission Liquor) and the data holds two differently named businesses at that address, so the shared building does not establish one outlet.
pair 323cf30f57e335a868de
ab-inbev BUBBLES MARKET & SPIRITSca-abc BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00
ab-inbev BUBBLES MARKET & SPIRITSca-abc BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00
ab-inbev BUBBLES MARKET & SPIRITSoverture Bubbles Market & Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev BUBBLES MARKET & SPIRITSvtinfo BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
ca-abc BUBBLES MARKET & SPIRITSca-abc BUBBLES MARKET & SPIRITS1.00one licence filemergedfile: 00627271 · same_address
ca-abc BUBBLES MARKET & SPIRITSoverture Bubbles Market & Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
ca-abc BUBBLES MARKET & SPIRITSvtinfo BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 63 m apart · name similarity 1.00
ca-abc BUBBLES MARKET & SPIRITSoverture Bubbles Market & Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
ca-abc BUBBLES MARKET & SPIRITSvtinfo BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 63 m apart · name similarity 1.00
overture Bubbles Market & Spiritsvtinfo BUBBLES MARKET & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DEL MISSION INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
297 within 1 mi · 2,561 within 3 mi
Off / on premise
42 / 197 within 1 mi · 420 / 1,537 within 3 mi
Selling alcohol
203 within 1 mi · 1,737 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.04 mi
Setting
urban (8,358 people per sq mi)
People within 3 mi
236,310 (203,546 adults 21+, 118,790 households) from 68 tract(s), tracts within 3 mi
Income
per capita $65,558 · median household ~$100,776 (weighted mean of tract medians)
Age and education
median age ~37.0 · bachelor's or higher 56%
Ethnicity
Hispanic 28% · White 57% · Black 6% · Asian 10%
Adults per alcohol outlet
117
Alcohol spend within 3 mi
$91,781,099 a year ($40,877,685 at home, $50,862,335 away) · $52,808 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-12 17:29insertca-abc 00627271|86|LIC|0 ↔ ubereats qmxq05OQQdCEYKom40yLogClaude judge: sameheld: same-source-conflict14
2026-11-11 12:56insertoverture 912d4b32-7833-4418-804c-ec5df5e3476a ↔ vtinfo a45be517380be360same address and namemerged12
2026-11-11 12:56insertab-inbev 4622089 ↔ vtinfo a45be517380be360same address and namemerged12
2026-11-11 12:56insertca-abc 00627271|86|LIC|0 ↔ vtinfo a45be517380be360same address and namemerged12
2026-11-11 12:56insertca-abc 00627271|21|LIC|0 ↔ vtinfo a45be517380be360same address and namemerged12
2026-11-11 12:56insertab-inbev 4622089 ↔ overture 912d4b32-7833-4418-804c-ec5df5e3476asame address and namemerged12
2026-11-11 12:56insertab-inbev 4622089 ↔ ca-abc 00627271|86|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4622089 ↔ ca-abc 00627271|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00627271|86|LIC|0 ↔ overture 912d4b32-7833-4418-804c-ec5df5e3476asame address and namemerged11
2026-11-06 18:13insertca-abc 00627271|21|LIC|0 ↔ overture 912d4b32-7833-4418-804c-ec5df5e3476asame address and namemerged11
2026-10-09 13:59backfillca-abc 00627271|21|LIC|0 ↔ ca-abc 00627271|86|LIC|0one licence filemerged