Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92311 | ca-abc | no other value |
| Pin | 34.89492, -117.04540 map 1 other | ubereats | 137 m away ab-inbev |
| Phone | 7602565188 | overture | no 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
| Product | Source | Price | Stock | Seen |
|---|---|---|---|---|
| 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | HAMS LIQUOR STORE 2212339 | 1491 W MAIN ST, BARSTOW, CA, 92311 | 34.89506, -117.04391 | 2026-11-12 | 2026-11-12 | |
| ca-abc | HAMS LIQUOR STORE 00638352|21|LIC|0 | 1491 W MAIN ST, BARSTOW, CA, 92311 | 34.89470, -117.04533 | 2026-10-08 | 2026-11-12 | |
| doordash | ham's liquor store barstow 33154951 | 1491 W Main St, Barstow, CA, 92311 | 34.89496, -117.04540 | 2026-10-08 | 2026-11-12 | |
| overture | Ham's Liquor Store 76608531-6a8f-4bbb-8e7a-974bf2415109 | 1491 Main St, Barstow, CA, 92311 | 7602565188 | 34.89487, -117.04532 | 2026-11-15 | 2026-11-15 |
| ubereats | Ham's Liquor Store RIEjSj-PXpG1sJtvhbaDjA | 1491 Main Street, Barstow, CA, 92311 | 34.89492, -117.04540 | 2026-11-14 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev HAMS LIQUOR STORE | ca-abc HAMS LIQUOR STORE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 136 m apart · name similarity 1.00 |
| ab-inbev HAMS LIQUOR STORE | doordash ham's liquor store barstow | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 136 m apart · name similarity 1.00 |
| ab-inbev HAMS LIQUOR STORE | overture Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 130 m apart · name similarity 1.00 · street similarity 0.88 |
| ab-inbev HAMS LIQUOR STORE | ubereats Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 137 m apart · name similarity 1.00 · street similarity 0.88 |
| ca-abc HAMS LIQUOR STORE | overture Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 19 m apart · name similarity 1.00 · street similarity 0.88 |
| ca-abc HAMS LIQUOR STORE | ubereats Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 26 m apart · name similarity 1.00 · street similarity 0.88 |
| doordash ham's liquor store barstow | overture Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 12 m apart · name similarity 1.00 · street similarity 0.88 |
| doordash ham's liquor store barstow | ubereats Ham's Liquor Store | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 4 m apart · name similarity 1.00 · street similarity 0.88 |
| overture Ham's Liquor Store | ubereats Ham's Liquor Store | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| ca-abc HAMS LIQUOR STORE | doordash ham's liquor store barstow | 0.56 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-15 17:57 | insert | doordash 33154951 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109 | street written two ways | merged | 15 |
| 2026-11-15 17:57 | insert | ca-abc 00638352|21|LIC|0 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109 | street written two ways | merged | 15 |
| 2026-11-15 17:57 | insert | ab-inbev 2212339 ↔ overture 76608531-6a8f-4bbb-8e7a-974bf2415109 | street written two ways | merged | 15 |
| 2026-11-15 17:57 | insert | overture 76608531-6a8f-4bbb-8e7a-974bf2415109 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjA | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | doordash 33154951 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjA | street written two ways | merged | 15 |
| 2026-11-14 20:23 | insert | ca-abc 00638352|21|LIC|0 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjA | street written two ways | merged | 15 |
| 2026-11-14 20:23 | insert | ab-inbev 2212339 ↔ ubereats RIEjSj-PXpG1sJtvhbaDjA | street written two ways | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2212339 ↔ doordash 33154951 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2212339 ↔ ca-abc 00638352|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-02 23:02 | backfill | ca-abc 00638352|21|LIC|0 ↔ doordash 33154951 | Claude judge: same | merged |