Vallarta Supermarket

PASADENA, CA 91103 · O0c82845b6914 · 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 5 other
a licence name in capitals, cleaned (derived; record_title.py)
Vallarta Supermarkets overtureubereats ×2
vallarta supermarkets la cocina pasadena doordash ×2
VALLARTA FOOD ENTERPRISES INC ca-abc (legal name)
VALLARTA SUPERMARKETS #51 ca-abc
vallarta supermarkets pasadena doordash
Street
655 N FAIR OAKS AVE 1 other
ca-abc
655 North Fair Oaks Avenue doordash ×2
City
PASADENA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91103
ca-abcno other value
Pin
34.15701, -118.15187 map 3 other
ubereats
128 m away ab-inbev
114 m away ca-abc
102 m away vtinfo
Phone
6262046960
vtinfono other value
Licences
ca-abc 00580642|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of1294c6bf679; O152a4bf8b6e3; Oa5e84c47b34b; Oae9baf5336df; O378a0b0ee277; Ob4b3c6232c62; O852e958d83fd

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
4068458
655 N FAIR OAKS AVE, PASADENA, CA, 9110334.15757, -118.150652026-11-112026-11-11
ca-abcVALLARTA SUPERMARKETS #51
legal name: VALLARTA FOOD ENTERPRISES INC
00580642|21|LIC|0
655 N FAIR OAKS AVE, PASADENA, CA, 9110334.15690, -118.150642026-10-082026-11-06
doordashvallarta supermarkets la cocina pasadena
1216936
655 North Fair Oaks Avenue, Pasadena, CA, 9110334.15694, -118.152022026-10-082026-11-17
doordashvallarta supermarkets la cocina pasadena
26035344
655 North Fair Oaks Avenue, Pasadena, CA, 9110334.15686, -118.151942026-10-162026-11-17
doordashvallarta supermarkets pasadena
27797767
655 N Fair Oaks Ave, Pasadena, CA, 9110334.15686, -118.151952026-10-082026-11-06
overtureVallarta Supermarkets
0b885126-fa34-41c7-9f22-b6b01a20c049
655 N Fair Oaks Ave, Pasadena, CA, 91103626204696034.15692, -118.152082026-11-062026-11-06
ubereatsVallarta Supermarkets
D3MRAuiGV0y6u20h_OXTxA
655 N Fair Oaks Ave, Pasadena, CA, 9110334.15701, -118.151872026-11-092026-11-09
vtinfoVALLARTA SUPERMARKET
74a8251df06eed78
655 N FAIR OAKS AVE, PASADENA, CA, 91103626204696034.15696, -118.150752026-11-112026-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 SUPERMARKETvtinfo VALLARTA SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 68 m apart · name similarity 1.00
doordash vallarta supermarkets la cocina pasadenadoordash vallarta supermarkets la cocina pasadena1.00one store listed twicemergedsame street + city + state · name: identical
doordash vallarta supermarkets pasadenaoverture Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
doordash vallarta supermarkets pasadenaubereats Vallarta Supermarkets1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 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 23 m apart · name similarity 1.00
ca-abc VALLARTA SUPERMARKETS #51doordash vallarta supermarkets pasadena0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + city + state · pins 121 m apart · name similarity 0.80
ca-abc VALLARTA SUPERMARKETS #51overture Vallarta Supermarkets0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + ZIP · pins 133 m apart · name similarity 0.80
ca-abc VALLARTA SUPERMARKETS #51ubereats Vallarta Supermarkets0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.85 · same street + ZIP · pins 114 m apart · name similarity 0.80
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets pasadena0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 143 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 151 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 128 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETS #51vtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 13 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina pasadenaoverture 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 7 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina pasadenaubereats 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 16 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina pasadenaoverture 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 15 m apart · name similarity 0.65
doordash vallarta supermarkets la cocina pasadenaubereats 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 18 m apart · name similarity 0.65
doordash vallarta supermarkets pasadenavtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 110 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 123 m apart · name similarity 0.65 · phone: equal
ubereats Vallarta Supermarketsvtinfo VALLARTA SUPERMARKET0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 102 m apart · name similarity 0.65
ca-abc VALLARTA SUPERMARKETS #51doordash vallarta supermarkets la cocina pasadena0.60one name contains the other, same addressmergedjudge: None · pair_id: 4a892c0c871ed785e6b1 · person: None · rule: names contained at one address · stratum: near
ca-abc VALLARTA SUPERMARKETS #51doordash vallarta supermarkets la cocina pasadena0.60one name contains the other, same addressmergedjudge: None · pair_id: 41d63da4f1cc90a93849 · person: None · rule: names contained at one address · stratum: near
ab-inbev VALLARTA SUPERMARKETca-abc VALLARTA SUPERMARKETS #510.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Vallarta Supermarket same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are at 655 N Fair Oaks Ave, Pasadena, 91103, with matching names (VALLARTA SUPERMARKET and VALLARTA SUPERMARKETS #51, the latter with the store number dropped), and the CA licence is an off-sale general store licence, so it is the same supermarket outlet.
pair 3002232de4f91cedec77
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets la cocina pasadena0.49one name contains the other, same addressmergedjudge: None · pair_id: 09666e9fd785d0aa99c9 · person: None · rule: names contained at one address · stratum: near
ab-inbev VALLARTA SUPERMARKETdoordash vallarta supermarkets la cocina pasadena0.49one name contains the other, same addressmergedjudge: None · pair_id: 9ac626a80f8c9746490b · person: None · rule: names contained at one address · stratum: near
doordash vallarta supermarkets la cocina pasadenavtinfo VALLARTA SUPERMARKET0.49one name contains the other, same addressmergedjudge: None · pair_id: 2ff0abf3a1317ed876d4 · person: None · rule: names contained at one address · stratum: near
doordash vallarta supermarkets la cocina pasadenavtinfo VALLARTA SUPERMARKET0.49one name contains the other, same addressmergedjudge: None · pair_id: db7b08143973903e6227 · 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
281 within 1 mi · 946 within 3 mi
Off / on premise
36 / 189 within 1 mi · 160 / 619 within 3 mi
Selling alcohol
160 within 1 mi · 528 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (5,974 people per sq mi)
People within 3 mi
168,914 (134,672 adults 21+, 68,668 households) from 40 tract(s), tracts within 3 mi
Income
per capita $64,494 · median household ~$113,326 (weighted mean of tract medians)
Age and education
median age ~41.0 · bachelor's or higher 55%
Ethnicity
Hispanic 34% · White 40% · Black 9% · Asian 15%
Adults per alcohol outlet
255
Alcohol spend within 3 mi
$57,723,612 a year ($25,234,755 at home, $32,466,503 away) · $109,118 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:58insertca-abc 00580642|21|LIC|0 ↔ vtinfo 74a8251df06eed78same address and namemerged15
2026-11-17 17:19insertab-inbev 4068458 ↔ doordash 26035344one name contains the other, same addressmerged15
2026-11-17 17:19insertab-inbev 4068458 ↔ doordash 1216936one name contains the other, same addressmerged15
2026-11-17 17:19insertdoordash 26035344 ↔ vtinfo 74a8251df06eed78one name contains the other, same addressmerged15
2026-11-17 17:19insertdoordash 1216936 ↔ vtinfo 74a8251df06eed78one name contains the other, same addressmerged15
2026-11-17 17:19insertca-abc 00580642|21|LIC|0 ↔ doordash 26035344one name contains the other, same addressmerged15
2026-11-17 17:19insertca-abc 00580642|21|LIC|0 ↔ doordash 1216936one name contains the other, same addressmerged15
2026-11-17 17:19updatedoordash 1216936 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and namemerged15
2026-11-17 17:19updatedoordash 1216936 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged15
2026-11-17 17:19updatedoordash 26035344 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and namemerged15
2026-11-17 17:19updatedoordash 26035344 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged15
2026-11-16 14:56insertdoordash 1216936 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and nameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 1216936 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and nameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 26035344 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and nameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 26035344 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and nameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 1216936 ↔ doordash 26035344one store listed twicemerged15
2026-11-12 17:29insertab-inbev 4068458 ↔ ca-abc 00580642|21|LIC|0Claude judge: samemerged14
2026-11-11 12:56insertdoordash 27797767 ↔ vtinfo 74a8251df06eed78same address and namemerged12
2026-11-11 12:56insertoverture 0b885126-fa34-41c7-9f22-b6b01a20c049 ↔ vtinfo 74a8251df06eed78same address and namemerged12
2026-11-11 12:56insertubereats D3MRAuiGV0y6u20h_OXTxA ↔ vtinfo 74a8251df06eed78same address and namemerged12
2026-11-11 12:56insertab-inbev 4068458 ↔ doordash 27797767same address and namemerged12
2026-11-11 12:56insertab-inbev 4068458 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and namemerged12
2026-11-11 12:56insertab-inbev 4068458 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged12
2026-11-11 12:56insertab-inbev 4068458 ↔ vtinfo 74a8251df06eed78same address and namemerged12
2026-11-09 01:04insertca-abc 00580642|21|LIC|0 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged11
2026-11-09 01:04insertdoordash 27797767 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged11
2026-11-09 01:04insertoverture 0b885126-fa34-41c7-9f22-b6b01a20c049 ↔ ubereats D3MRAuiGV0y6u20h_OXTxAsame address and namemerged11
2026-11-06 18:13insertca-abc 00580642|21|LIC|0 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and namemerged11
2026-11-06 18:13insertdoordash 27797767 ↔ overture 0b885126-fa34-41c7-9f22-b6b01a20c049same address and namemerged11
2026-11-03 13:33backfillca-abc 00580642|21|LIC|0 ↔ doordash 27797767same address and namemerged