Mandell's Liquor & Wine Shop

VENTURA, CA 93003 · O48d29e02dfe5 · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: Mandells Liquor & Wine Shopalcohol: 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
Mandell's Liquor & Wine Shop 3 other
a source's own spelling of the licence name (record_title.py)
MANDELLS LIQUOR & WINE SHOP ab-inbevvtinfo ×2
Mandell's Liquor and Wine Shop overture
MANDELLS LIQUOR ca-abc
Street
3915 TELEGRAPH RD 1 other
ca-abc
3915 Telegraph Road ubereats
City
VENTURA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93003
ca-abcno other value
Pin
34.27419, -119.24206 map 2 other
ubereats
104 m away ca-abc
55 m away vtinfo
Phone
8056421148
vtinfono other value
Licences
ca-abc 00667429|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8c00d6630bd8; Obd7d2500bf50; O78ef481b5ea1; O4b63ec16b4d7; O7e28d03a5f87

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-inbevMANDELLS LIQUOR & WINE SHOP
2015717
3915 TELEGRAPH RD, VENTURA, CA, 9300334.27405, -119.241902026-11-112026-11-11
ca-abcMANDELLS LIQUOR
00667429|21|LIC|0
3915 TELEGRAPH RD, VENTURA, CA, 9300334.27419, -119.240942026-10-082026-11-11
overtureMandell's Liquor and Wine Shop
6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5
3915 Telegraph Rd, Ventura, CA, 93003805642114834.27405, -119.242132026-11-062026-11-11
ubereatsMandell's Liquor & Wine Shop
irLxP7MmXc2F_uxImKasRA
3915 Telegraph Road, Ventura, CA, 9300334.27419, -119.242062026-10-142026-11-11
vtinfoMANDELLS LIQUOR & WINE SHOP
e811719476585437
3915 TELEGRAPH RD, VENTURA, CA, 93003805642114834.27467, -119.241962026-11-132026-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 MANDELLS LIQUOR & WINE SHOPoverture Mandell's Liquor and Wine Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ab-inbev MANDELLS LIQUOR & WINE SHOPubereats Mandell's Liquor & Wine Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ab-inbev MANDELLS LIQUOR & WINE SHOPvtinfo MANDELLS LIQUOR & WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 69 m apart · name similarity 1.00
ca-abc MANDELLS LIQUORoverture 8b19e36d-f366-44a8-9adc-d19c82d34d9c1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 113 m apart · name similarity 1.00
overture Mandell's Liquor and Wine Shopubereats Mandell's Liquor & Wine Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture Mandell's Liquor and Wine Shopvtinfo MANDELLS LIQUOR & WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 71 m apart · name similarity 1.00 · phone: equal
ubereats Mandell's Liquor & Wine Shopvtinfo MANDELLS LIQUOR & WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 55 m apart · name similarity 1.00
ab-inbev MANDELLS LIQUOR & WINE SHOPca-abc MANDELLS LIQUOR0.76same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 90 m apart · name similarity 0.76
ca-abc MANDELLS LIQUORoverture Mandell's Liquor and Wine Shop0.76same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 110 m apart · name similarity 0.76
ca-abc MANDELLS LIQUORvtinfo MANDELLS LIQUOR & WINE SHOP0.76same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 108 m apart · name similarity 0.76
overture 8b19e36d-f366-44a8-9adc-d19c82d34d9cubereats Mandell's Liquor & Wine Shop0.76same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 11 m apart · name similarity 0.76
ca-abc MANDELLS LIQUORubereats Mandell's Liquor & Wine Shop0.52Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Same street address and ZIP with matching distinctive names (Mandells Liquor vs Mandell's Liquor & Wine Shop), backed by an active off-sale licence for a liquor store, so the names agree despite the s
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 3915 Telegraph Rd, Ventura 93003, and the names match closely (MANDELLS LIQUOR vs Mandell's Liquor & Wine Shop), with the CA off-sale liquor licence fitting a liquor store listed on Uber Eats. The building is shared with another business, so the name agreement is what carries the verdict.
  • Claude Haiku 5.5, prompt v4: same, 88% confident — Both records sit at 3915 Telegraph Rd, Ventura 93003, and the names agree (MANDELLS LIQUOR as the ABC off-sale licensee, Mandell's Liquor & Wine Shop on Uber Eats), so the shared building doesn't undermine the match.
pair 120bbf83f54475335f8e

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Mandells Liquor & Wine Shop — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
114 within 1 mi · 505 within 3 mi
Off / on premise
35 / 70 within 1 mi · 126 / 284 within 3 mi
Selling alcohol
49 within 1 mi · 331 within 3 mi
Nearest
same channel 0.17 mi · licensed 0.07 mi
Setting
suburban (2,136 people per sq mi)
People within 3 mi
60,386 (48,265 adults 21+, 24,443 households) from 17 tract(s), tracts within 3 mi
Income
per capita $53,407 · median household ~$102,502 (weighted mean of tract medians)
Age and education
median age ~43.5 · bachelor's or higher 45%
Ethnicity
Hispanic 30% · White 65% · Black 2% · Asian 6%
Adults per alcohol outlet
145
Alcohol spend within 3 mi
$19,027,792 a year ($8,465,475 at home, $10,554,533 away) · $57,313 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-13 14:10insertca-abc 00667429|21|LIC|0 ↔ vtinfo e811719476585437same address and namemerged15
2026-11-13 14:10insertoverture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5 ↔ vtinfo e811719476585437same address and namemerged15
2026-11-13 14:10insertubereats irLxP7MmXc2F_uxImKasRA ↔ vtinfo e811719476585437same address and namemerged15
2026-11-13 14:10insertab-inbev 2015717 ↔ vtinfo e811719476585437same address and namemerged15
2026-11-11 12:56insertab-inbev 2015717 ↔ ca-abc 00667429|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2015717 ↔ overture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5same address and namemerged12
2026-11-11 12:56insertab-inbev 2015717 ↔ ubereats irLxP7MmXc2F_uxImKasRAsame address and namemerged12
2026-11-09 15:32updateca-abc 00667429|21|LIC|0 ↔ overture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5same address and namemerged11
2026-11-09 15:32updateoverture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5 ↔ ubereats irLxP7MmXc2F_uxImKasRAsame address and namemerged11
2026-11-06 18:13insertoverture 8b19e36d-f366-44a8-9adc-d19c82d34d9c ↔ ubereats irLxP7MmXc2F_uxImKasRAsame address and namemerged11
2026-11-06 18:13insertca-abc 00667429|21|LIC|0 ↔ overture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 6ea1aa95-41c1-4a87-94fe-9edc3efcd8e5 ↔ ubereats irLxP7MmXc2F_uxImKasRAsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00667429|21|LIC|0 ↔ overture 8b19e36d-f366-44a8-9adc-d19c82d34d9csame address and namemerged11
2026-11-02 23:02backfillca-abc 00667429|21|LIC|0 ↔ ubereats irLxP7MmXc2F_uxImKasRAClaude judge: samemerged