Outlets /
Vallarta Supermarket
HESPERIA, CA 92345 · O2a02abffb374 · first seen 2026-10-08
6 sourcesoff premisechain: Vallarta Supermarketsalcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Vallarta Supermarket 5 other | a licence name in capitals, cleaned (derived; record_title.py) | VALLARTA SUPERMARKETS ca-abcoverture ×2 vallarta supermarkets la cocina hesperia doordash ×2 VALLARTA FOOD ENTERPRISES INC ca-abc (legal name) Vallarta Supermarket #45 ubereats vallarta supermarkets hesperia doordash |
| Street | 17390 MAIN ST 1 other | ca-abc | 17390 Main Street doordash ×3 |
| City | HESPERIA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92345 | ca-abc | no other value |
| Pin | 34.41898, -117.28322 map 4 other | ubereats | 155 m away doordash ×3 180 m away ab-inbev 172 m away overture 160 m away vtinfo |
| Phone | 4426003020 | vtinfo | no other value |
| Licences | ca-abc 00536611|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Of2b27ed02ce8; O905c70b8c65f; O7f551a9c5f82; O7fb4d9a23597; O5248618874d4; Of851027a7018; Oc557118f7e81
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | VALLARTA SUPERMARKET 3650811 | 17390 MAIN ST, HESPERIA, CA, 92345 | 34.41920, -117.28516 | 2026-11-11 | 2026-11-11 | |
| ca-abc | VALLARTA SUPERMARKETS legal name: VALLARTA FOOD ENTERPRISES INC 00536611|21|LIC|0 | 17390 MAIN ST, HESPERIA, CA, 92345 | 34.41891, -117.28331 | 2026-10-08 | 2026-11-06 | |
| doordash | vallarta supermarkets la cocina hesperia 1216932 | 17390 Main Street, Hesperia, CA, 92345 | 34.42038, -117.28320 | 2026-10-08 | 2026-11-15 | |
| doordash | vallarta supermarkets la cocina hesperia 26038685 | 17390 Main Street, Hesperia, CA, 92345 | 34.42026, -117.28340 | 2026-10-08 | 2026-11-18 | |
| doordash | vallarta supermarkets hesperia 27797800 | 17390 Main Street, Hesperia, CA, 92345 | 34.42026, -117.28340 | 2026-10-08 | 2026-11-06 | |
| overture | Vallarta Supermarkets ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | 17390 Main St, Hesperia, CA, 92345 | 4426003020 | 34.42039, -117.28399 | 2026-11-06 | 2026-11-06 |
| ubereats | Vallarta Supermarket #45 PH38cvY1QeCfQ60ZeSxL1g | 17390 Main St, Hesperia, CA, 92345 | 34.41898, -117.28322 | 2026-10-17 | 2026-11-06 | |
| vtinfo | VALLARTA SUPERMARKET f5b9be64ae0d9dc0 | 17390 MAIN ST, HESPERIA, CA, 92345 | 4426003020 | 34.42042, -117.28333 | 2026-11-13 | 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 VALLARTA SUPERMARKET | ubereats Vallarta Supermarket #45 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 180 m apart · name similarity 1.00 |
| ab-inbev VALLARTA SUPERMARKET | vtinfo VALLARTA SUPERMARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 216 m apart · name similarity 1.00 |
| ca-abc VALLARTA SUPERMARKETS | doordash vallarta supermarkets hesperia | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 151 m apart · name similarity 1.00 |
| ca-abc VALLARTA SUPERMARKETS | overture Vallarta Supermarkets | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 176 m apart · name similarity 1.00 |
| doordash vallarta supermarkets la cocina hesperia | doordash vallarta supermarkets la cocina hesperia | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| doordash vallarta supermarkets hesperia | overture Vallarta Supermarkets | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00 |
| ubereats Vallarta Supermarket #45 | vtinfo VALLARTA SUPERMARKET | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 160 m apart · name similarity 1.00 |
| ab-inbev VALLARTA SUPERMARKET | ca-abc VALLARTA SUPERMARKETS | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 173 m apart · name similarity 0.65 |
| ab-inbev VALLARTA SUPERMARKET | doordash vallarta supermarkets hesperia | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 200 m apart · name similarity 0.65 |
| ab-inbev VALLARTA SUPERMARKET | overture Vallarta Supermarkets | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 171 m apart · name similarity 0.65 |
| ca-abc VALLARTA SUPERMARKETS | doordash vallarta supermarkets la cocina hesperia | 0.65 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 163 m apart · name similarity 0.65 |
| ca-abc VALLARTA SUPERMARKETS | doordash vallarta supermarkets la cocina hesperia | 0.65 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 151 m apart · name similarity 0.65 |
| ca-abc VALLARTA SUPERMARKETS | vtinfo VALLARTA SUPERMARKET | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 168 m apart · name similarity 0.65 |
| doordash vallarta supermarkets la cocina hesperia | overture Vallarta Supermarkets | 0.65 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 72 m apart · name similarity 0.65 |
| doordash vallarta supermarkets la cocina hesperia | overture Vallarta Supermarkets | 0.65 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: cocina · name Jaro-Winkler 0.73 · same street + ZIP · pins 56 m apart · name similarity 0.65 |
| doordash vallarta supermarkets hesperia | vtinfo VALLARTA SUPERMARKET | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 19 m apart · name similarity 0.65 |
| overture Vallarta Supermarkets | ubereats Vallarta Supermarket #45 | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 172 m apart · name similarity 0.65 |
| overture Vallarta Supermarkets | vtinfo VALLARTA SUPERMARKET | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 61 m apart · name similarity 0.65 · phone: equal |
| ca-abc VALLARTA SUPERMARKETS | ubereats Vallarta Supermarket #45 | 0.58 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Same chain name (Vallarta Supermarkets) at the identical street address and ZIP, with an off-sale market licence and only one business recorded at that address. Other Claude answers on this pair:
pair 9ee01486c17190aa904c |
| doordash vallarta supermarkets hesperia | ubereats Vallarta Supermarket #45 | 0.58 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Both records are the Vallarta Supermarket at the same street address (17390 Main St, Hesperia 92345), with only one business on file there, so they are one store listed under two spellings. Other Claude answers on this pair:
pair cb2d92b5eadd1d01f51a |
Attributes
- Channel
- off_premise — ca-licence conflicting evidence
- Chain
- Vallarta Supermarkets — name-prefix
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- VALLARTA FOOD ENTERPRISES INC — 42 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
"ue_location": [
"DEFAULT"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 56 within 1 mi · 140 within 3 mi
- Off / on premise
- 16 / 35 within 1 mi · 47 / 76 within 3 mi
- Selling alcohol
- 32 within 1 mi · 92 within 3 mi
- Nearest
- same channel 0.06 mi · licensed 0.06 mi
- Setting
- suburban (1,863 people per sq mi)
- People within 3 mi
- 52,668 (35,586 adults 21+, 15,692 households) from 10 tract(s), tracts within 3 mi
- Income
- per capita $25,048 · median household ~$70,323 (weighted mean of tract medians)
- Age and education
- median age ~33.5 · bachelor's or higher 11%
- Ethnicity
- Hispanic 61% · White 46% · Black 6% · Asian 1%
- Adults per alcohol outlet
- 383
- Alcohol spend within 3 mi
- $8,678,839 a year ($4,133,517 at home, $4,541,354 away) · $93,321 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-18 18:58 | insert | doordash 26038685 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | merged | 15 |
| 2026-11-18 18:58 | insert | ca-abc 00536611|21|LIC|0 ↔ doordash 26038685 | same address and name | merged | 15 |
| 2026-11-18 18:58 | insert | overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c ↔ ubereats PH38cvY1QeCfQ60ZeSxL1g | same address and name | merged | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 3650811 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1g | same address and name | merged | 15 |
| 2026-11-18 18:58 | insert | ubereats PH38cvY1QeCfQ60ZeSxL1g ↔ vtinfo f5b9be64ae0d9dc0 | same address and name | merged | 15 |
| 2026-11-18 18:58 | insert | doordash 1216932 ↔ doordash 26038685 | one store listed twice | merged | 15 |
| 2026-11-15 16:24 | update | doordash 1216932 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | merged | 15 |
| 2026-11-15 16:24 | update | ca-abc 00536611|21|LIC|0 ↔ doordash 1216932 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | doordash 1216932 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | held: same-source-conflict | 15 |
| 2026-11-14 20:23 | insert | ca-abc 00536611|21|LIC|0 ↔ doordash 1216932 | same address and name | held: same-source-conflict | 15 |
| 2026-11-13 14:10 | insert | doordash 27797800 ↔ vtinfo f5b9be64ae0d9dc0 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c ↔ vtinfo f5b9be64ae0d9dc0 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ca-abc 00536611|21|LIC|0 ↔ vtinfo f5b9be64ae0d9dc0 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 3650811 ↔ vtinfo f5b9be64ae0d9dc0 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | doordash 27797800 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1g | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3650811 ↔ ca-abc 00536611|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3650811 ↔ doordash 27797800 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3650811 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00536611|21|LIC|0 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 27797800 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c | same address and name | merged | 11 |
| 2026-11-05 23:10 | backfill | ca-abc 00536611|21|LIC|0 ↔ doordash 27797800 | same address and name | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00536611|21|LIC|0 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1g | Claude judge: same | merged |