Mr As Liquor & Deli

Vista, CA 92083 · O185317d0fdd5 · first seen 2026-10-08
7 sourcesoff premise · conveniencealcohol: 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
Mr As Liquor & Deli 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MR. A'S LIQUOR ca-tobaccoinspectionsoverture ×3
DO INVESTMENT GROUP LLC ca-abc (legal name)
Mr As Liquor snap
Street
254 VISTA VILLAGE DR
ca-abcno other value
City
VISTA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92083
ca-abcno other value
Pin
33.19888, -117.24853 map
overtureno other value
Phone
7607580382 1 other
vtinfo
7607582460 overture
Licences
ca-abc 00533896|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob68afc805e57; Oaa6fbd7f3007; O1b7c619a75e9; O59c1995f8b2d; O9010cce5e62e; Oa6dcf1257cc1

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-inbevMR AS LIQUOR & DELI
2352590
254 VISTA VILLAGE DR, VISTA, CA, 9208333.19894, -117.248632026-11-112026-11-12
ca-abcMR AS LIQUOR & DELI
legal name: DO INVESTMENT GROUP LLC
00533896|21|LIC|0
254 VISTA VILLAGE DR, VISTA, CA, 9208333.19852, -117.248532026-10-082026-11-12
ca-tobaccoMR. A'S LIQUOR
ca-tobacco|091351791
254 VISTA VILLAGE DR, Vista, CA, 920832026-11-202026-11-20
inspectionsMR A'S LIQUOR
inspections|sdcounty|DEH2016-FFPN-001061
254 VISTA VILLAGE DR, Vista, CA, 920832026-11-202026-11-20
overtureMr A's Liquor
0d5febc0-e315-4d2b-9da3-04ccd3ba46bc
254 Vista Village Dr, Vista, CA, 92083760758246033.19888, -117.248532026-11-132026-11-13
snapMr As Liquor
snap|us|829405
254 Vista Village Dr, Vista, CA, 9208333.19860, -117.248602026-11-192026-11-19
vtinfoMR AS LIQUOR & DELI
22298a481575a515
254 VISTA VILLAGE DR, VISTA, CA, 92083760758038233.19876, -117.248562026-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 MR AS LIQUOR & DELIca-abc MR AS LIQUOR & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ab-inbev MR AS LIQUOR & DELIvtinfo MR AS LIQUOR & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
ca-abc MR AS LIQUOR & DELIvtinfo MR AS LIQUOR & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00
ca-tobacco MR. A'S LIQUORinspections MR A'S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco MR. A'S LIQUORoverture Mr A's Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco MR. A'S LIQUORsnap Mr As Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections MR A'S LIQUORoverture Mr A's Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections MR A'S LIQUORsnap Mr As Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Mr A's Liquorsnap Mr As Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ab-inbev MR AS LIQUOR & DELIca-tobacco MR. A'S LIQUOR0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
ab-inbev MR AS LIQUOR & DELIinspections MR A'S LIQUOR0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
ab-inbev MR AS LIQUOR & DELIoverture Mr A's Liquor0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · pins 12 m apart · name similarity 0.79
ab-inbev MR AS LIQUOR & DELIsnap Mr As Liquor0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · pins 38 m apart · name similarity 0.79
ca-abc MR AS LIQUOR & DELIca-tobacco MR. A'S LIQUOR0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
ca-abc MR AS LIQUOR & DELIinspections MR A'S LIQUOR0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
ca-abc MR AS LIQUOR & DELIoverture Mr A's Liquor0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · pins 41 m apart · name similarity 0.79
ca-abc MR AS LIQUOR & DELIsnap Mr As Liquor0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · pins 11 m apart · name similarity 0.79
ca-tobacco MR. A'S LIQUORvtinfo MR AS LIQUOR & DELI0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
inspections MR A'S LIQUORvtinfo MR AS LIQUOR & DELI0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · name similarity 0.79
overture Mr A's Liquorvtinfo MR AS LIQUOR & DELI0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + city + state · pins 14 m apart · name similarity 0.79 · phone: differs
snap Mr As Liquorvtinfo MR AS LIQUOR & DELI0.79same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, liquor · name Jaro-Winkler 0.88 · same street + ZIP · pins 18 m apart · name similarity 0.79

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DO INVESTMENT GROUP LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
158 within 1 mi · 497 within 3 mi
Off / on premise
33 / 98 within 1 mi · 136 / 284 within 3 mi
Selling alcohol
89 within 1 mi · 281 within 3 mi
Nearest
same channel 0.14 mi · licensed 0.04 mi
Setting
urban (5,066 people per sq mi)
People within 3 mi
143,249 (104,430 adults 21+, 47,287 households) from 28 tract(s), tracts within 3 mi
Income
per capita $42,581 · median household ~$101,419 (weighted mean of tract medians)
Age and education
median age ~38.3 · bachelor's or higher 32%
Ethnicity
Hispanic 45% · White 45% · Black 3% · Asian 6%
Adults per alcohol outlet
370
Alcohol spend within 3 mi
$37,128,460 a year ($16,570,832 at home, $20,542,630 away) · $131,661 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-20 22:08insertinspections inspections|sdcounty|DEH2016-FFPN-001061 ↔ vtinfo 22298a481575a515same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091351791 ↔ vtinfo 22298a481575a515same address and namemerged17
2026-11-20 22:08insertca-abc 00533896|21|LIC|0 ↔ inspections inspections|sdcounty|DEH2016-FFPN-001061same address and namemerged17
2026-11-20 22:08insertca-abc 00533896|21|LIC|0 ↔ ca-tobacco ca-tobacco|091351791same address and namemerged17
2026-11-20 22:08insertab-inbev 2352590 ↔ inspections inspections|sdcounty|DEH2016-FFPN-001061same address and namemerged17
2026-11-20 22:08insertab-inbev 2352590 ↔ ca-tobacco ca-tobacco|091351791same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2016-FFPN-001061 ↔ snap snap|us|829405same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091351791 ↔ snap snap|us|829405same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091351791 ↔ inspections inspections|sdcounty|DEH2016-FFPN-001061same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2016-FFPN-001061 ↔ overture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bcsame address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091351791 ↔ overture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bcsame address and namemerged17
2026-11-19 20:37insertsnap snap|us|829405 ↔ vtinfo 22298a481575a515same address and namemerged17
2026-11-19 20:37insertca-abc 00533896|21|LIC|0 ↔ snap snap|us|829405same address and namemerged17
2026-11-19 20:37insertab-inbev 2352590 ↔ snap snap|us|829405same address and namemerged17
2026-11-19 20:37insertoverture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bc ↔ snap snap|us|829405same address and namemerged17
2026-11-13 14:10insertoverture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bc ↔ vtinfo 22298a481575a515same address and namemerged15
2026-11-13 14:10insertca-abc 00533896|21|LIC|0 ↔ overture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bcsame address and namemerged15
2026-11-13 14:10insertab-inbev 2352590 ↔ overture 0d5febc0-e315-4d2b-9da3-04ccd3ba46bcsame address and namemerged15
2026-11-12 14:25insertab-inbev 2352590 ↔ vtinfo 22298a481575a515same address and namemerged12
2026-11-12 14:25insertca-abc 00533896|21|LIC|0 ↔ vtinfo 22298a481575a515same address and namemerged12
2026-11-11 12:56insertab-inbev 2352590 ↔ ca-abc 00533896|21|LIC|0same address and namemerged12