Vallarta Supermarket

CLOVIS, CA 93612 · O105604283cb1 · first seen 2026-10-08
6 sourcesoff premise · grocerychain: 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 4 other
a licence name in capitals, cleaned (derived; record_title.py)
VALLARTA SUPERMARKETS ca-abcovertureubereats ×3
VALLARTA FOOD ENTERPRISES INC ca-abc (legal name)
vallarta supermarkets clovis doordash
vallarta supermarkets la cocina clovis doordash
Street
170 W SHAW AVE 1 other
ca-abc
170 West Shaw Avenue ubereats
City
CLOVIS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93612
ca-abcno other value
Pin
36.80733, -119.71228 map 2 other
ubereats
138 m away ca-abc
77 m away vtinfo
Phone
5555555555 1 other
vtinfo
5596280935 overture
Licences
ca-abc 00653332|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc44f2c8b48fe; O7ba828cc423c; Od91364fd8268; Ob1ac36bde953; O9f0f76313800; O8dc3e2ac8524

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
4791615
170 W SHAW AVE, CLOVIS, CA, 9361236.80746, -119.712232026-11-112026-11-11
ca-abcVALLARTA SUPERMARKETS
legal name: VALLARTA FOOD ENTERPRISES INC
00653332|21|LIC|0
170 W SHAW AVE, CLOVIS, CA, 9361236.80843, -119.712992026-10-082026-11-05
doordashvallarta supermarkets la cocina clovis
31980048
170 W Shaw Ave, Clovis, CA, 9361236.80716, -119.712432026-10-082026-11-16
doordashvallarta supermarkets clovis
32026196
170 W Shaw Ave, Clovis, CA, 9361236.80732, -119.712352026-10-082026-11-05
overtureVallarta Supermarkets
05a6df03-92c3-44d1-89dd-205325df6ec5
170 W Shaw Ave, Clovis, CA, 93612559628093536.80749, -119.712372026-11-062026-11-06
ubereatsVallarta Supermarkets
hwG5rB2uVDmLWYGIjwfNSA
170 West Shaw Avenue, Clovis, CA, 9361236.80733, -119.712282026-11-052026-11-05
vtinfoVALLARTA SUPERMARKET
97197eeed41ea968
170 W SHAW AVE, CLOVIS, CA, 93612555555555536.80678, -119.711742026-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
ca-abc VALLARTA SUPERMARKETSoverture 38ae20b2-4439-4d6e-aa78-88af4b047a590.80same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + city + state · pins 137 m apart · name similarity 0.80
doordash vallarta supermarkets clovisoverture 38ae20b2-4439-4d6e-aa78-88af4b047a590.80same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + city + state · pins 4 m apart · name similarity 0.80
overture 38ae20b2-4439-4d6e-aa78-88af4b047a59ubereats Vallarta Supermarkets0.80same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + city + state · pins 2 m apart · name similarity 0.80
ab-inbev VALLARTA SUPERMARKETvtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 87 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets clovis1.00same address and namemergedaddress similarity 1.00 · same street + city + state · 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 119 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETSubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 138 m apart · name similarity 1.00
doordash vallarta supermarkets clovisoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
doordash vallarta supermarkets clovisubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
overture Vallarta Supermarketsubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 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 128 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets clovis0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 19 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 13 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETubereats Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 15 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETSdoordash vallarta supermarkets la cocina clovis0.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 150 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 214 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina clovisoverture 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 37 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina clovisubereats 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 24 m apart · name similarity 0.65
doordash vallarta supermarkets clovisvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 80 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 96 m apart · name similarity 0.65 · phone: differs
ubereats Vallarta Supermarketsvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 77 m apart · name similarity 0.65
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets la cocina clovis0.49one name contains the other, same addressmergedjudge: None · pair_id: 7d19d8dfd6ed9a43f852 · person: None · rule: names contained at one address · stratum: near
doordash vallarta supermarkets la cocina clovisvtinfo VALLARTA SUPERMARKET0.49one name contains the other, same addressmergedjudge: None · pair_id: 1ac6287277cdb1cdcd6f · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise · grocery — ca-licence conflicting evidence
Chain
Vallarta Supermarkets — ubereats-parent
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:34.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
174 within 1 mi · 661 within 3 mi
Off / on premise
49 / 108 within 1 mi · 172 / 420 within 3 mi
Selling alcohol
80 within 1 mi · 337 within 3 mi
Nearest
same channel 0.14 mi · licensed 0.09 mi
Setting
urban (3,941 people per sq mi)
People within 3 mi
111,429 (77,666 adults 21+, 39,500 households) from 25 tract(s), tracts within 3 mi
Income
per capita $34,475 · median household ~$76,920 (weighted mean of tract medians)
Age and education
median age ~35.2 · bachelor's or higher 26%
Ethnicity
Hispanic 41% · White 46% · Black 3% · Asian 11%
Adults per alcohol outlet
230
Alcohol spend within 3 mi
$24,367,319 a year ($11,335,419 at home, $13,021,522 away) · $72,093 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-16 14:56insertab-inbev 4791615 ↔ doordash 31980048one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 31980048 ↔ vtinfo 97197eeed41ea968one name contains the other, same addressmerged15
2026-11-16 14:56updateca-abc 00653332|21|LIC|0 ↔ doordash 31980048same address and namemerged15
2026-11-16 14:56updatedoordash 31980048 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and namemerged15
2026-11-16 14:56updatedoordash 31980048 ↔ overture 05a6df03-92c3-44d1-89dd-205325df6ec5same address and namemerged15
2026-11-15 16:24insertca-abc 00653332|21|LIC|0 ↔ doordash 31980048same address and nameheld: same-source-conflict15
2026-11-15 16:24insertdoordash 31980048 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and nameheld: same-source-conflict15
2026-11-15 16:24insertdoordash 31980048 ↔ overture 05a6df03-92c3-44d1-89dd-205325df6ec5same address and nameheld: same-source-conflict15
2026-11-12 14:25insertca-abc 00653332|21|LIC|0 ↔ vtinfo 97197eeed41ea968same address and namemerged12
2026-11-12 14:25insertubereats hwG5rB2uVDmLWYGIjwfNSA ↔ vtinfo 97197eeed41ea968same address and namemerged12
2026-11-12 14:25insertoverture 05a6df03-92c3-44d1-89dd-205325df6ec5 ↔ vtinfo 97197eeed41ea968same address and namemerged12
2026-11-12 14:25insertdoordash 32026196 ↔ vtinfo 97197eeed41ea968same address and namemerged12
2026-11-12 14:25insertab-inbev 4791615 ↔ vtinfo 97197eeed41ea968same address and namemerged12
2026-11-11 12:56insertab-inbev 4791615 ↔ overture 05a6df03-92c3-44d1-89dd-205325df6ec5same address and namemerged12
2026-11-11 12:56insertab-inbev 4791615 ↔ doordash 32026196same address and namemerged12
2026-11-11 12:56insertab-inbev 4791615 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and namemerged12
2026-11-11 12:56insertab-inbev 4791615 ↔ ca-abc 00653332|21|LIC|0same address and namemerged12
2026-11-06 18:13insertdoordash 32026196 ↔ overture 38ae20b2-4439-4d6e-aa78-88af4b047a59same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 38ae20b2-4439-4d6e-aa78-88af4b047a59 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00653332|21|LIC|0 ↔ overture 38ae20b2-4439-4d6e-aa78-88af4b047a59same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 32026196 ↔ overture 05a6df03-92c3-44d1-89dd-205325df6ec5same address and namemerged11
2026-11-06 18:13insertoverture 05a6df03-92c3-44d1-89dd-205325df6ec5 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and namemerged11
2026-11-06 18:13insertca-abc 00653332|21|LIC|0 ↔ overture 05a6df03-92c3-44d1-89dd-205325df6ec5same address and namemerged11
2026-11-05 15:27backfillca-abc 00653332|21|LIC|0 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and namemerged
2026-11-05 15:27backfilldoordash 32026196 ↔ ubereats hwG5rB2uVDmLWYGIjwfNSAsame address and namemerged
2026-10-30 18:41backfillca-abc 00653332|21|LIC|0 ↔ doordash 32026196same address and namemerged