BOBS LIQUOR

SAN MATEO, CA 94401 · O0cba543a7ffc · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: licensed1 licence

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
BOBS LIQUOR 2 other
the most common name a source states
Bob's Liquor Llc overture
bob's liquor san mateo doordash
Street
522 PENINSULA AVE 1 other
ca-abc
522 Peninsula Avenue doordash
City
SAN MATEO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94401
ca-abcno other value
Pin
37.58012, -122.33468 map 2 other
doordash
70 m away ab-inbev
82 m away ca-abc
Phone
6503441353 1 other
vtinfo
5122066534 overture
Licences
ca-abc 00641094|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O1f1d0c42b91e; O3b658e6a7bf0; Ob0419f788072; O88495b00cecc

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-inbevBOBS LIQUOR
4588224
522 PENINSULA AVE, SAN MATEO, CA, 9440137.57990, -122.335432026-11-112026-11-11
ca-abcBOBS LIQUOR
00641094|21|LIC|0
522 PENINSULA AVE, SAN MATEO, CA, 9440137.57969, -122.335432026-10-082026-11-04
doordashbob's liquor san mateo
24437004
522 Peninsula Avenue, San Mateo, CA, 9440137.58012, -122.334682026-10-082026-11-03
overtureBob's Liquor Llc
eba9fbd3-b350-41c2-b202-26416d11087a
522 Peninsula Ave, San Mateo, CA, 94401512206653437.58001, -122.334562026-11-062026-11-06
vtinfoBOBS LIQUOR
62dee5f4aa1b082b
522 PENINSULA AVE, SAN MATEO, CA, 94401650344135337.58001, -122.334562026-11-122026-11-14

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
ab-inbev BOBS LIQUORca-abc BOBS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00
ab-inbev BOBS LIQUORdoordash bob's liquor san mateo1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 70 m apart · name similarity 1.00
ab-inbev BOBS LIQUORoverture Bob's Liquor Llc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 78 m apart · name similarity 1.00
ab-inbev BOBS LIQUORvtinfo BOBS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 77 m apart · name similarity 1.00
ca-abc BOBS LIQUORoverture Bob's Liquor Llc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 85 m apart · name similarity 1.00
ca-abc BOBS LIQUORvtinfo BOBS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 85 m apart · name similarity 1.00
doordash bob's liquor san mateooverture Bob's Liquor Llc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
doordash bob's liquor san mateovtinfo BOBS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
overture Bob's Liquor Llcvtinfo BOBS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: differs
ca-abc BOBS LIQUORdoordash bob's liquor san mateo0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The names agree (Bob's Liquor, with the city appended in the DoorDash slug) and both records give the same street address and ZIP, 522 Peninsula Ave, 94401; the CA licence is an off-sale liquor store,
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give 522 Peninsula Avenue, San Mateo, ZIP 94401, and the names match (BOBS LIQUOR as the ABC licence name, bob's liquor san mateo on DoorDash), so the shared building is resolved by the matching name; no suite numbers conflict.
pair a134477fadc75dd95af9

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
183 within 1 mi · 782 within 3 mi
Off / on premise
33 / 115 within 1 mi · 97 / 491 within 3 mi
Selling alcohol
125 within 1 mi · 462 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.02 mi
Setting
urban (3,846 people per sq mi)
People within 3 mi
108,752 (83,232 adults 21+, 42,494 households) from 27 tract(s), tracts within 3 mi
Income
per capita $96,879 · median household ~$165,943 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 61%
Ethnicity
Hispanic 23% · White 43% · Black 1% · Asian 28%
Adults per alcohol outlet
180
Alcohol spend within 3 mi
$43,461,656 a year ($18,359,336 at home, $25,091,454 away) · $93,870 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 14:25insertoverture eba9fbd3-b350-41c2-b202-26416d11087a ↔ vtinfo 62dee5f4aa1b082bsame address and namemerged12
2026-11-12 14:25insertdoordash 24437004 ↔ vtinfo 62dee5f4aa1b082bsame address and namemerged12
2026-11-12 14:25insertca-abc 00641094|21|LIC|0 ↔ vtinfo 62dee5f4aa1b082bsame address and namemerged12
2026-11-12 14:25insertab-inbev 4588224 ↔ vtinfo 62dee5f4aa1b082bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4588224 ↔ overture eba9fbd3-b350-41c2-b202-26416d11087asame address and namemerged12
2026-11-11 12:56insertab-inbev 4588224 ↔ doordash 24437004same address and namemerged12
2026-11-11 12:56insertab-inbev 4588224 ↔ ca-abc 00641094|21|LIC|0same address and namemerged12
2026-11-06 18:13insertdoordash 24437004 ↔ overture eba9fbd3-b350-41c2-b202-26416d11087asame address and namemerged11
2026-11-06 18:13insertca-abc 00641094|21|LIC|0 ↔ overture eba9fbd3-b350-41c2-b202-26416d11087asame address and namemerged11
2026-11-02 23:02backfillca-abc 00641094|21|LIC|0 ↔ doordash 24437004Claude judge: samemerged