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.

FieldMaster valueTaken fromWhat 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-abcno other value
State
CA
ca-abcno other value
ZIP
92345
ca-abcno 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
vtinfono 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevVALLARTA SUPERMARKET
3650811
17390 MAIN ST, HESPERIA, CA, 9234534.41920, -117.285162026-11-112026-11-11
ca-abcVALLARTA SUPERMARKETS
legal name: VALLARTA FOOD ENTERPRISES INC
00536611|21|LIC|0
17390 MAIN ST, HESPERIA, CA, 9234534.41891, -117.283312026-10-082026-11-06
doordashvallarta supermarkets la cocina hesperia
1216932
17390 Main Street, Hesperia, CA, 9234534.42038, -117.283202026-10-082026-11-15
doordashvallarta supermarkets la cocina hesperia
26038685
17390 Main Street, Hesperia, CA, 9234534.42026, -117.283402026-10-082026-11-18
doordashvallarta supermarkets hesperia
27797800
17390 Main Street, Hesperia, CA, 9234534.42026, -117.283402026-10-082026-11-06
overtureVallarta Supermarkets
ba2dbeaa-8b43-476f-9b46-4c2d2c52131c
17390 Main St, Hesperia, CA, 92345442600302034.42039, -117.283992026-11-062026-11-06
ubereatsVallarta Supermarket #45
PH38cvY1QeCfQ60ZeSxL1g
17390 Main St, Hesperia, CA, 9234534.41898, -117.283222026-10-172026-11-06
vtinfoVALLARTA SUPERMARKET
f5b9be64ae0d9dc0
17390 MAIN ST, HESPERIA, CA, 92345442600302034.42042, -117.283332026-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 VALLARTA SUPERMARKETubereats Vallarta Supermarket #451.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 180 m apart · name similarity 1.00
ab-inbev VALLARTA SUPERMARKETvtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 216 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets hesperia1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 151 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 176 m apart · name similarity 1.00
doordash vallarta supermarkets la cocina hesperiadoordash vallarta supermarkets la cocina hesperia1.00one store listed twicemergedsame street + ZIP · name: identical
doordash vallarta supermarkets hesperiaoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ubereats Vallarta Supermarket #45vtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 160 m apart · name similarity 1.00
ab-inbev VALLARTA SUPERMARKETca-abc VALLARTA SUPERMARKETS0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 173 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets hesperia0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 200 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKEToverture Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 171 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets la cocina hesperia0.65same address and namemergedaddress 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 SUPERMARKETSdoordash vallarta supermarkets la cocina hesperia0.65same address and namemergedaddress 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 SUPERMARKETSvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress 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 hesperiaoverture Vallarta Supermarkets0.65same address and namemergedaddress 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 hesperiaoverture Vallarta Supermarkets0.65same address and namemergedaddress 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 hesperiavtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 19 m apart · name similarity 0.65
overture Vallarta Supermarketsubereats Vallarta Supermarket #450.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 172 m apart · name similarity 0.65
overture Vallarta Supermarketsvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress 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 SUPERMARKETSubereats Vallarta Supermarket #450.58Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records sit at 17390 Main St, Hesperia CA 92345 with matching coordinates, the only business at that address, and the names are the same supermarket chain (Vallarta Supermarkets, store #45), with the CA record an off-sale liquor licence for the market.
pair 9ee01486c17190aa904c
doordash vallarta supermarkets hesperiaubereats Vallarta Supermarket #450.58Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are Vallarta Supermarket at 17390 Main Street, Hesperia, CA 92345, with one businesses-at-address count and coordinates about 0.14 km apart; the store number in B and the city-appended DoorDash slug in A are just naming differences for the same store.
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”).
WhenEventPairRuleDecisionRule version
2026-11-18 18:58insertdoordash 26038685 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and namemerged15
2026-11-18 18:58insertca-abc 00536611|21|LIC|0 ↔ doordash 26038685same address and namemerged15
2026-11-18 18:58insertoverture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c ↔ ubereats PH38cvY1QeCfQ60ZeSxL1gsame address and namemerged15
2026-11-18 18:58insertab-inbev 3650811 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1gsame address and namemerged15
2026-11-18 18:58insertubereats PH38cvY1QeCfQ60ZeSxL1g ↔ vtinfo f5b9be64ae0d9dc0same address and namemerged15
2026-11-18 18:58insertdoordash 1216932 ↔ doordash 26038685one store listed twicemerged15
2026-11-15 16:24updatedoordash 1216932 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and namemerged15
2026-11-15 16:24updateca-abc 00536611|21|LIC|0 ↔ doordash 1216932same address and namemerged15
2026-11-14 20:23insertdoordash 1216932 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and nameheld: same-source-conflict15
2026-11-14 20:23insertca-abc 00536611|21|LIC|0 ↔ doordash 1216932same address and nameheld: same-source-conflict15
2026-11-13 14:10insertdoordash 27797800 ↔ vtinfo f5b9be64ae0d9dc0same address and namemerged15
2026-11-13 14:10insertoverture ba2dbeaa-8b43-476f-9b46-4c2d2c52131c ↔ vtinfo f5b9be64ae0d9dc0same address and namemerged15
2026-11-13 14:10insertca-abc 00536611|21|LIC|0 ↔ vtinfo f5b9be64ae0d9dc0same address and namemerged15
2026-11-13 14:10insertab-inbev 3650811 ↔ vtinfo f5b9be64ae0d9dc0same address and namemerged15
2026-11-11 12:56insertdoordash 27797800 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1gClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 3650811 ↔ ca-abc 00536611|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3650811 ↔ doordash 27797800same address and namemerged12
2026-11-11 12:56insertab-inbev 3650811 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and namemerged12
2026-11-06 18:13insertca-abc 00536611|21|LIC|0 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and namemerged11
2026-11-06 18:13insertdoordash 27797800 ↔ overture ba2dbeaa-8b43-476f-9b46-4c2d2c52131csame address and namemerged11
2026-11-05 23:10backfillca-abc 00536611|21|LIC|0 ↔ doordash 27797800same address and namemerged
2026-11-02 23:02backfillca-abc 00536611|21|LIC|0 ↔ ubereats PH38cvY1QeCfQ60ZeSxL1gClaude judge: samemerged