Vallarta Supermarket

FRESNO, CA 93726 · O2926c32bd32e · first seen 2026-10-08
5 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 4 other
a licence name in capitals, cleaned (derived; record_title.py)
vallarta supermarkets la cocina fresno doordash ×2
VALLARTA FOOD ENTERPRISES INC ca-abc (legal name)
Vallarta Supermarkets overture
vallarta supermarkets fresno doordash
Street
3850 N CEDAR AVE 1 other
ca-abc
3850 North Cedar Avenue doordash ×2
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93726
ca-abcno other value
Pin
36.78785, -119.75260 map 2 other
doordash
150 m away ca-abc
57 m away vtinfo
Phone
5594763070
vtinfono other value
Licences
ca-abc 00459952|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O34c53cf296c5; O4014a3918c5b; O6f7d80fa89ab; O42f9c2fd0499; Oc3716b182b08; O484e95b06ee5

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
2940244
3850 N CEDAR AVE, FRESNO, CA, 9372636.78756, -119.752972026-11-112026-11-11
ca-abcVALLARTA SUPERMARKET
legal name: VALLARTA FOOD ENTERPRISES INC
00459952|21|LIC|0
3850 N CEDAR AVE, FRESNO, CA, 9372636.78753, -119.754232026-10-082026-11-05
doordashvallarta supermarkets la cocina fresno
1217103
3850 North Cedar Avenue, Fresno, CA, 9372636.78785, -119.752602026-10-082026-11-18
doordashvallarta supermarkets la cocina fresno
27647167
3850 North Cedar Avenue, Fresno, CA, 9372636.78762, -119.752822026-10-082026-11-18
doordashvallarta supermarkets fresno
27797796
3850 N Cedar Ave, Fresno, CA, 9372636.78760, -119.752782026-10-082026-11-02
overtureVallarta Supermarkets
7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5
3850 N Cedar Ave, Fresno, CA, 93726559476307036.78755, -119.752702026-11-062026-11-06
vtinfoVALLARTA SUPERMARKET
eef343720e76a54f
3850 N CEDAR AVE, FRESNO, CA, 93726559476307036.78738, -119.752882026-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
doordash vallarta supermarkets fresnooverture cc76b17e-002b-441e-bbc6-036a3fdab9060.80same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + ZIP · pins 10 m apart · name similarity 0.80
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets la cocina fresno0.49one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 1f4fe9972b912bd01812 · person: None · rule: names contained at one address · stratum: near
ca-abc VALLARTA SUPERMARKETdoordash vallarta supermarkets la cocina fresno0.49one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: fa63788be4298307861a · person: None · rule: names contained at one address · stratum: near
doordash vallarta supermarkets la cocina fresnovtinfo VALLARTA SUPERMARKET0.49one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 2194433b49ceec2b0a64 · person: None · rule: names contained at one address · stratum: near
ab-inbev VALLARTA SUPERMARKETca-abc VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 113 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 21 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETvtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 121 m apart · name similarity 1.00
doordash vallarta supermarkets la cocina fresnodoordash vallarta supermarkets la cocina fresno1.00one store listed twicemergedsame street + city + state · name: identical
doordash vallarta supermarkets fresnooverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets fresno0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 18 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 24 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETdoordash vallarta supermarkets fresno0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The two records share the same street address and ZIP, and the names match: the DoorDash slug is 'vallarta supermarkets' with the city appended, against the ABC record's 'VALLARTA SUPERMARKET'. The of
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, city and ZIP in Fresno, CA, and the DoorDash slug 'vallarta supermarkets fresno' matches the California ABC record 'VALLARTA SUPERMARKET' with no competing business at that address and no suite conflict.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city, and ZIP in Fresno, and the DoorDash slug 'vallarta supermarkets fresno' matches the California ABC DBA 'VALLARTA SUPERMARKET' with only a plural difference; the address is the only building at that street with one business, and the off-sale licence fits a supermarket.
pair 3ea3eb442a861f691e5d
ca-abc VALLARTA SUPERMARKEToverture Vallarta Supermarkets0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 136 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina fresnooverture 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 35 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina fresnooverture 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 14 m apart · name similarity 0.65
doordash vallarta supermarkets fresnovtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 26 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 24 m apart · name similarity 0.65 · phone: equal

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)
{
 "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
52 within 1 mi · 761 within 3 mi
Off / on premise
18 / 26 within 1 mi · 252 / 418 within 3 mi
Selling alcohol
32 within 1 mi · 412 within 3 mi
Nearest
same channel 0.43 mi · licensed 0.07 mi
Setting
urban (5,900 people per sq mi)
People within 3 mi
166,831 (112,261 adults 21+, 56,235 households) from 36 tract(s), tracts within 3 mi
Income
per capita $24,143 · median household ~$56,921 (weighted mean of tract medians)
Age and education
median age ~31.7 · bachelor's or higher 16%
Ethnicity
Hispanic 58% · White 30% · Black 5% · Asian 12%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$27,893,511 a year ($13,579,842 at home, $14,299,490 away) · $67,539 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:58updatedoordash 1217103 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and namemerged15
2026-11-18 18:58updatedoordash 27647167 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and namemerged15
2026-11-16 14:56insertca-abc 00459952|21|LIC|0 ↔ doordash 1217103one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 2940244 ↔ doordash 1217103one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertdoordash 1217103 ↔ vtinfo eef343720e76a54fone name contains the other, same addressheld: same-source-conflict15
2026-11-15 16:24updatedoordash 1217103 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and nameheld: same-source-conflict15
2026-11-14 20:23insertdoordash 1217103 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and nameheld: same-source-conflict15
2026-11-14 20:23insertdoordash 1217103 ↔ doordash 27647167one store listed twicemerged15
2026-11-12 17:29insertdoordash 27647167 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and nameheld: same-source-conflict14
2026-11-12 14:25insertoverture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5 ↔ vtinfo eef343720e76a54fsame address and namemerged12
2026-11-12 14:25insertdoordash 27797796 ↔ vtinfo eef343720e76a54fsame address and namemerged12
2026-11-12 14:25insertab-inbev 2940244 ↔ vtinfo eef343720e76a54fsame address and namemerged12
2026-11-12 14:25insertca-abc 00459952|21|LIC|0 ↔ vtinfo eef343720e76a54fsame address and namemerged12
2026-11-11 12:56insertab-inbev 2940244 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and namemerged12
2026-11-11 12:56insertab-inbev 2940244 ↔ doordash 27797796same address and namemerged12
2026-11-11 12:56insertab-inbev 2940244 ↔ ca-abc 00459952|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00459952|21|LIC|0 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and namemerged11
2026-11-06 18:13insertdoordash 27797796 ↔ overture cc76b17e-002b-441e-bbc6-036a3fdab906same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 27797796 ↔ overture 7a9a182f-2bdc-4b95-ac9d-1f1ee76c59a5same address and namemerged11
2026-11-02 23:02backfillca-abc 00459952|21|LIC|0 ↔ doordash 27797796Claude judge: samemerged