Ham's Liquor Store

Barstow, CA 92311 · O351116d03d61 · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: Hams Liquor Storealcohol: licensed1 licence2 products on the shelf

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
Ham's Liquor Store 2 other
the most common name a source states
HAMS LIQUOR STORE ab-inbevca-abc ×2
ham's liquor store barstow doordash
Street
1491 W MAIN ST 2 other
ca-abc
1491 Main St overture
1491 Main Street ubereats
City
BARSTOW
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92311
ca-abcno other value
Pin
34.89492, -117.04540 map 1 other
ubereats
137 m away ab-inbev
Phone
7602565188
overtureno other value
Licences
ca-abc 00638352|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe97b841c2f96; O9098549ab0c8; Ocedcbf966b2f; O73483271b897

Carries

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

2products placed
592listings
590listings with no product match yet
doordashfrom
Showing 60 of 592 listings: matched products first.
ProductSourcePriceStockSeen
Gran Malo Spicy Tamarind Tequila Shot (50 ml)
GRAN MALO · 50 ml
doordash$4.99—2026-11-16
Gran Malo Spicy Tamarind Flavored Tequila Bottle (750 ml)
GRAN MALO · 750 ml
doordash$36.99—2026-11-16
New Amsterdam Mango Flavored Vodka (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
Twang Michelada Beer Salt (1 oz)
not matched to a product yet
doordash$2.99—2026-11-16
Taaka Pineapple Vodka (375 ml)
not matched to a product yet
doordash$5.99—2026-11-16
New Amsterdam Red Berry Flavored Vodka (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
The Club Mudslide Can (200 ml)
not matched to a product yet
doordash$4.99—2026-11-16
Mike's Hard Black Cherry Lemonade Premium Malt Beverage Bottles (11.2 fl oz x 6 ct)
not matched to a product yet
doordash——2026-11-16
Realemon 100% Lemon Juice PET Bottle (2.5 fl oz)
not matched to a product yet
doordash$1.99—2026-11-16
Jose Cuervo Classic Lime Margarita Mix Bottle (1 L)
not matched to a product yet
doordash$6.99—2026-11-16
New Amsterdam 80 Proof Vodka Flask Bottle (375 ml)
not matched to a product yet
doordash$11.99—2026-11-16
New Amsterdam 80 Proof No. 525 Vodka Bottle (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
Potter's 80 Proof Premium Triple Distilled Vodka Pet Bottle (750 ml)
not matched to a product yet
doordash$9.99—2026-11-16
Popov Vodka Bottle (200 ml)
not matched to a product yet
doordash$4.99—2026-11-16
Blanco Lovers
not matched to a product yet
doordash——2026-11-16
Patrón Silver Tequila (375 ml)
not matched to a product yet
doordash——2026-11-16
Mike's Harder Lemonade Premium Malt Beverage Can (16 fl oz)
not matched to a product yet
doordash——2026-11-16
Twisted Tea Original Hard Ice Tea Can (12 oz x 12 ct)
not matched to a product yet
doordash$29.99—2026-11-16
Jack Daniel's Tennessee Honey Lemonade Tennessee Whiskey Can (12 fl oz)
not matched to a product yet
doordash$4.99—2026-11-16
Smirnoff Ice Green Apple, Single Serve Bottle, 24 fl oz, 4.5% ABV
not matched to a product yet
doordash$4.99—2026-11-16
Michelada Antojitos Drink Mix Cup (24 oz)
not matched to a product yet
doordash$2.99—2026-11-16
Twang Lime Beer Salt (1.4 oz)
not matched to a product yet
doordash$2.99—2026-11-16
Crystal Palace Vodka (375 ml)
not matched to a product yet
doordash$6.99—2026-11-16
Fleischmann's Royal Vodka (375 ml)
not matched to a product yet
doordash$4.99—2026-11-16
New Amsterdam Passionfruit Flavored Vodka (750 ml)
not matched to a product yet
doordash$20.99—2026-11-16
Pink Whitney Lemonade Vodka Bottle (375 ml)
not matched to a product yet
doordash$11.99—2026-11-16
Absolut Vodka Original Flavored Vodka (50 ml)
not matched to a product yet
doordash$3.99—2026-11-16
UV Pink Lemonade Vodka Bottle (375 ml)
not matched to a product yet
doordash$7.99—2026-11-16
New Amsterdam Tangerine Flavored Vodka (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
New Amsterdam Grapefruit Flavored Vodka (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
Bar Cart Essentials #1
not matched to a product yet
doordash$75.99—2026-11-16
Smirnoff Gluten-Free Green Apple Infused Vodka PET Flask Bottle (375 ml)
not matched to a product yet
doordash——2026-11-16
Monaco Cocktails Black Raspberry Vodka Cocktail (12 fl oz)
not matched to a product yet
doordash$3.99—2026-11-16
Beatbox Beverages Blue Razzberry Carton (750 ml)
not matched to a product yet
doordash$4.99—2026-11-16
Mickey's Fine Malt Liquor Can (24 fl oz)
not matched to a product yet
doordash$3.99—2026-11-16
Bud Light Original Chelada Clamato Beer Tall Can (25 fl oz)
not matched to a product yet
doordash$3.99—2026-11-16
BuzzBallz Peachballz RTD Vodka Cocktail (200 ml)
not matched to a product yet
doordash$6.99—2026-11-16
Mike's Hard Lemonade Cranberry Premium Malt Beverage Bottles (11.2 fl oz x 6 ct)
not matched to a product yet
doordash$14.99—2026-11-16
Jack Daniel's Tennessee Honey Lemonade RTD Whiskey Cocktail Cans (355 ml x 4 ct)
not matched to a product yet
doordash$18.99—2026-11-16
Smirnoff Ice Original, Single Serve Glass Bottle, 24 fl oz, 4.5% ABV
not matched to a product yet
doordash$5.99—2026-11-16
Smirnoff Ice Screwdriver (11.2 fl oz × 6 ct)
not matched to a product yet
doordash$14.99—2026-11-16
Truly Citrus Hard Seltzer Cans Variety Pack (12 fl oz x 12 ct)
not matched to a product yet
doordash$28.99—2026-11-16
Clamato Original Tomato Cocktail Juice Bottle (16 fl oz)
not matched to a product yet
doordash$3.99—2026-11-16
Calypso Ocean Blue Lemonade (16 fl oz)
not matched to a product yet
doordash$3.99—2026-11-16
Canada Dry Club Soda Bottle (1 L)
not matched to a product yet
doordash$2.99—2026-11-16
Artic Glacier Premium Ice Bag (7 lb)
not matched to a product yet
doordash$3.99—2026-11-16
Popov Vodka (375 ml)
not matched to a product yet
doordash$7.99—2026-11-16
Taaka 80 Proof Vodka Bottle (375 ml)
not matched to a product yet
doordash$4.99—2026-11-16
Smirnoff Vodka 100 Proof No. 57 Blue Vodka Bottle (375 ml)
not matched to a product yet
doordash——2026-11-16
New Amsterdam Pink Whitney Pink Lemonade Vodka Bottle (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
New Amsterdam Peach Vodka Bottle (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
Grey Goose 80 Proof Original Imported Vodka Bottle (375 ml)
not matched to a product yet
doordash$27.99—2026-11-16
New Amsterdam Peach Vodka Flask Bottle (375 ml)
not matched to a product yet
doordash$11.99—2026-11-16
New Amsterdam Apple Flavored Vodka (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
New Amsterdam Tangerine Flavored Vodka (375 ml)
not matched to a product yet
doordash$11.99—2026-11-16
Fleischmann's Royal Vodka Traveler Bottle (750 ml)
not matched to a product yet
doordash$11.99—2026-11-16
Potter's Vodka Bottle (375 ml)
not matched to a product yet
doordash$4.99—2026-11-16
Western Son 80 Proof Original Vodka Bottle (50 ml)
not matched to a product yet
doordash$1.99—2026-11-16
New Amsterdam Vodka PET Bottles (50 ml x 10 ct)
not matched to a product yet
doordash$13.99—2026-11-16
Smirnoff Ice Green Apple, 6 pack Bottles, 11.2 fl oz, 4.5% ABV
not matched to a product yet
doordash$14.99—2026-11-16

Sources

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

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevHAMS LIQUOR STORE
2212339
1491 W MAIN ST, BARSTOW, CA, 9231134.89506, -117.043912026-11-122026-11-12
ca-abcHAMS LIQUOR STORE
00638352|21|LIC|0
1491 W MAIN ST, BARSTOW, CA, 9231134.89470, -117.045332026-10-082026-11-12
doordashham's liquor store barstow
33154951
1491 W Main St, Barstow, CA, 9231134.89496, -117.045402026-10-082026-11-12
overtureHam's Liquor Store
76608531-6a8f-4bbb-8e7a-974bf2415109
1491 Main St, Barstow, CA, 92311760256518834.89487, -117.045322026-11-152026-11-15
ubereatsHam's Liquor Store
RIEjSj-PXpG1sJtvhbaDjA
1491 Main Street, Barstow, CA, 9231134.89492, -117.045402026-11-142026-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 HAMS LIQUOR STOREca-abc HAMS LIQUOR STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 136 m apart · name similarity 1.00
ab-inbev HAMS LIQUOR STOREdoordash ham's liquor store barstow1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 136 m apart · name similarity 1.00
ab-inbev HAMS LIQUOR STOREoverture Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 130 m apart · name similarity 1.00 · street similarity 0.88
ab-inbev HAMS LIQUOR STOREubereats Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 137 m apart · name similarity 1.00 · street similarity 0.88
ca-abc HAMS LIQUOR STOREoverture Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 19 m apart · name similarity 1.00 · street similarity 0.88
ca-abc HAMS LIQUOR STOREubereats Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 26 m apart · name similarity 1.00 · street similarity 0.88
doordash ham's liquor store barstowoverture Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 12 m apart · name similarity 1.00 · street similarity 0.88
doordash ham's liquor store barstowubereats Ham's Liquor Store1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 4 m apart · name similarity 1.00 · street similarity 0.88
overture Ham's Liquor Storeubereats Ham's Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
ca-abc HAMS LIQUOR STOREdoordash ham's liquor store barstow0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The names agree ('Hams Liquor Store' and the slug 'ham's liquor store barstow' with the city appended), the street address and ZIP are identical, and the active off-sale licence fits a liquor store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 88% confident — Both records are a liquor store at 1491 W Main St, Barstow, CA 92311, and the names match (HAMS LIQUOR STORE vs ham's liquor store barstow); the other business at the address has a different name, so the matching name is what decides it.
pair 97587985e688311ef686

Attributes

Channel
off_premise · convenience — doordash-url
Chain
Hams Liquor Store — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
20 within 1 mi · 116 within 3 mi
Off / on premise
14 / 3 within 1 mi · 54 / 47 within 3 mi
Selling alcohol
19 within 1 mi · 82 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.08 mi
Setting
suburban (680 people per sq mi)
People within 3 mi
19,222 (12,159 adults 21+, 7,007 households) from 5 tract(s), tracts within 3 mi
Income
per capita $27,606 · median household ~$59,103 (weighted mean of tract medians)
Age and education
median age ~33.1 · bachelor's or higher 13%
Ethnicity
Hispanic 49% · White 33% · Black 16% · Asian 3%
Adults per alcohol outlet
146
Alcohol spend within 3 mi
$3,681,696 a year ($1,772,550 at home, $1,907,132 away) · $44,358 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-15 17:57insertdoordash 33154951 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109street written two waysmerged15
2026-11-15 17:57insertca-abc 00638352|21|LIC|0 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109street written two waysmerged15
2026-11-15 17:57insertab-inbev 2212339 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109street written two waysmerged15
2026-11-15 17:57insertoverture 76608531-6a8f-4bbb-8e7a-974bf2415109 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjAsame address and namemerged15
2026-11-14 20:23insertdoordash 33154951 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjAstreet written two waysmerged15
2026-11-14 20:23insertca-abc 00638352|21|LIC|0 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjAstreet written two waysmerged15
2026-11-14 20:23insertab-inbev 2212339 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjAstreet written two waysmerged15
2026-11-12 14:25insertab-inbev 2212339 ↔ doordash 33154951same address and namemerged12
2026-11-12 14:25insertab-inbev 2212339 ↔ ca-abc 00638352|21|LIC|0same address and namemerged12
2026-11-02 23:02backfillca-abc 00638352|21|LIC|0 ↔ doordash 33154951Claude judge: samemerged