RALPHS 55

LA CANADA FLINTRIDGE, CA 91011 · O077ab2334be9 · first seen 2026-10-08
6 sourcesoff premise · grocerychain: Ralphsalcohol: licensed2 licences

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
RALPHS 55 6 other
the most common name a source states
RALPHS FRESH FARE ab-inbevoverturevtinfo ×3
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Fresh & Ready from Ralphs ubereats
Ralphs ubereats
RALPHS #55 overture
ralphs la canada doordash
Street
521 FOOTHILL BLVD
ca-abcno other value
City
LA CANADA FLINTRIDGE 1 other
ca-abc
La Canada doordashovertureubereats ×4
State
CA
ca-abcno other value
ZIP
91011
ca-abcno other value
Pin
34.20048, -118.18969 map 2 other
ubereats
310 m away ca-abc ×2
76 m away ab-inbev
Phone
8187900584
vtinfono other value
Licences
ca-abc 00407394|21|LIC|0 · ca-abc 00407394|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Off53404ae019; Oed1ab0d1425d; Ocf8057b10b69; O28df5c0b32a1; O41ba48a355a9; O17e280b65269; Offf77c2194c3; O125797026112

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-inbevRALPHS FRESH FARE
72608
521 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20011, -118.190392026-11-112026-11-16
ca-abcRALPHS 55
legal name: RALPHS GROCERY COMPANY
00407394|21|LIC|0
521 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20278, -118.191592026-10-082026-11-05
ca-abcRALPHS 55
legal name: RALPHS GROCERY COMPANY
00407394|86|LIC|0
521 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 9101134.20278, -118.191592026-10-082026-11-05
doordashralphs la canada
35801148
521 Foothill Blvd, La Canada, CA, 9101134.20071, -118.189702026-10-082026-11-02
overtureRalphs Fresh Fare
6ce10aa1-6854-42e1-b092-f614fd34a1a2
521 Foothill Blvd, La Canada Flintridge, CA, 91011818790058434.20064, -118.189702026-11-132026-11-16
overtureRALPHS #55
f77c8e59-1ff5-473a-876c-cb7a3562d0ff
521 Foothill Blvd, La Canada, CA, 9101134.20080, -118.189642026-11-062026-11-06
ubereatsRalphs
muFo6pKlXHmRyKpD5pmjpw
521 Foothill Blvd, La Canada, CA, 9101134.20048, -118.189692026-11-092026-11-13
ubereatsFresh & Ready from Ralphs
ZrqxB4LDWEOFc_qf_EnlGw
521 Foothill Blvd, La Canada, CA, 9101134.20076, -118.189832026-10-272026-11-02
vtinfoRALPHS FRESH FARE
369217dce0ad676a
521 FOOTHILL BLVD, LA CANADA FLINTRIDGE, CA, 91011818790058434.20076, -118.189832026-11-122026-11-16

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 RALPHS FRESH FAREoverture Ralphs Fresh Fare1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00
ab-inbev RALPHS FRESH FAREvtinfo RALPHS FRESH FARE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 89 m apart · name similarity 1.00
ca-abc RALPHS 55ca-abc RALPHS 551.00one licence filemergedfile: 00407394 · same_address
ca-abc RALPHS 55overture RALPHS #551.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 284 m apart · name similarity 1.00
ca-abc RALPHS 55overture RALPHS #551.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 284 m apart · name similarity 1.00
doordash ralphs la canadaubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
overture Ralphs Fresh Farevtinfo RALPHS FRESH FARE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 55doordash ralphs la canada0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the Ralphs chain at 521 Foothill Blvd, ZIP 91011, and the DoorDash slug's city matches; the second business counted at the address is likely just a variant listing, since the names ag
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at 521 Foothill Blvd, ZIP 91011, with coordinates 0.29 km apart; the CA ABC record is the store's off-sale licence and the DoorDash listing is the same chain store's storefront under the state rule, though the two-business count at the address leaves some doubt.
pair d11d1e6ec06d76203d6a
ca-abc RALPHS 55ubereats Ralphs0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the Ralphs chain at the same street address and ZIP (521 Foothill Blvd, 91011), and A's off-sale general licence fits a Ralphs supermarket, so 'RALPHS 55' is the store-numbered name o
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 87% confident — The California off-sale grocery licence under RALPHS 55 and the Uber Eats Ralphs listing share the same street address and ZIP, both are the Ralphs chain, and the store-number spelling difference is the only variation, so this is one chain store; the second business at the address is not Ralphs and the names agree for this pair.
pair abe7a614c90dd54d9a67
ca-abc RALPHS 55doordash ralphs la canada0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are a Ralphs at 521 Foothill Blvd, ZIP 91011, and the DoorDash slug 'ralphs la canada' is the chain name plus the city, so the name agreement outweighs the shared-building count.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Ralphs store at same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 521 Foothill Blvd, La Canada, ZIP 91011, with matching chain and street address; the DoorDash listing is the store's own alcohol/store listing under the same banner, and California's rule makes it the same outlet, with the small coordinate gap consistent with geocoding.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give 521 Foothill Blvd, ZIP 91011, and both are Ralphs; the ABC record's off-sale general licence and the DoorDash listing are one store's alcohol sales, and the 0.29 km distance and matching chain support it. Businesses_at_address is 2, so the shared building lowers confidence somewhat, but the name, chain, and address agree.
  • Claude Haiku 5.5, prompt v4: same, 82% confident — Both records give 521 Foothill Blvd, ZIP 91011, and a Ralphs banner (ABC 'RALPHS 55' vs DoorDash 'ralphs la canada'), which fits one chain store under different spellings; the shared building lowers confidence somewhat, but the names agree.
pair 1e3e9bdd5faea9498c99
ca-abc RALPHS 55ubereats Ralphs0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the Ralphs chain at the same street address and ZIP (521 Foothill Blvd, 91011), and the CA licence is an off-sale general for a market, which fits one Ralphs store with its store numb
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are the Ralphs chain store at 521 Foothill Blvd, La Canada, ZIP 91011, and the CA off-sale grocery licence fits the store itself; the name matches once the store number 55 is dropped, and the 0.31 km gap is consistent with geocoding. The shared building (2 businesses) is a caution, but the names agree, so this is the same outlet.
pair f1bff5316ec1ea1d1977
ab-inbev RALPHS FRESH FAREca-abc RALPHS 550.45one name contains the other, same addressmergedjudge: None · pair_id: b100c9b3a162b66d421a · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREca-abc RALPHS 550.45one name contains the other, same addressmergedjudge: None · pair_id: 9ea59fa35c29e9a6251c · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 55vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: c8a4a844c97687b0f713 · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 55vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: b9fb9458084b0cfa5cbc · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREdoordash ralphs la canada0.43one name contains the other, same addressmergedjudge: None · pair_id: 800aa01817f8137475f2 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREubereats Ralphs0.43one name contains the other, same addressmergedjudge: None · pair_id: 97d05e2304d50f973f8f · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs la canadavtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: 37c8fa1dc3d427613e7b · person: None · rule: names contained at one address · stratum: same-address
ubereats Ralphsvtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: b1544828e99528531388 · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs la canadaubereats Fresh & Ready from Ralphs0.33Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records are the Ralphs store at 521 Foothill Blvd, La Canada, 91011, and 'Fresh & Ready from Ralphs' reads as the store's own second Uber Eats listing (a ready-to-eat or quick-order storefront) r
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 75% confident — Both records are Ralphs at the identical street address and ZIP, with coordinates about 14 m apart; 'Fresh & Ready from Ralphs' reads as the store's own prepared-food listing rather than a separately run business, though the name differs and it is not clearly an alcohol listing.
pair 9dcd9724b0e80d76c41d
ca-abc RALPHS 55ubereats Fresh & Ready from Ralphs0.32Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records are the Ralphs store at 521 Foothill Blvd, 91011: one is the licensed premises 'RALPHS 55' and the other is Uber Eats' 'Fresh & Ready from Ralphs' listing, which reads as a storefront of
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Ralphs Fresh & Ready department at Ralphs address
  • Claude Opus 5.5, prompt v9: same, 93% confident — The 'Fresh & Ready from Ralphs' listing is Ralphs' own prepared-food department brand, and it sits at the same street address and ZIP (521 Foothill Blvd, 91011) as the RALPHS 55 off-sale licence, so both records describe one store.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 521 Foothill Blvd, La Canada, ZIP 91011; B is the store's own Fresh & Ready prepared-food department listing on Uber Eats, and A is the store's off-sale licence with matching chain and address, so this is one outlet.
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records are Ralphs at the same street address and ZIP, with the Uber Eats listing branded 'Fresh & Ready from Ralphs' reading as a second listing of the Ralphs store; the shared-building count of 2 and the differing names keep this from being certain.
  • Claude Haiku 5.5, prompt v4: different, 80% confident — Record A is a licensed off-sale liquor store named RALPHS 55 at 521 Foothill Blvd, while B is a separate Uber Eats storefront 'Fresh & Ready from Ralphs' at the same address; the data shows two businesses at this address, and the names describe different operations (a liquor/market licence versus a prepared-food storefront), so the address match alone does not establish one outlet.
pair 0707d7e9f3cda977bc48
ca-abc RALPHS 55ubereats Fresh & Ready from Ralphs0.32Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records are the Ralphs store at 521 Foothill Blvd, 91011, and 'Fresh & Ready from Ralphs' is Ralphs' own Uber Eats storefront for that store, not a separate business; the off-sale licence fits th
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Fresh & Ready is Ralphs department at same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 521 Foothill Blvd, La Canada 91011: the ca-abc record is the Ralphs store's off-sale licence and the Uber Eats listing is Ralphs' own Fresh & Ready prepared-food department at the same address, which is the store's own department rather than a concession.
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records are Ralphs at the identical street address and ZIP, and the Uber Eats listing is the chain's own food-counter storefront inside the store, so it reads as a second listing of the same operation; the shared building (2 businesses) and the unmatched name keep confidence moderate.
  • Claude Haiku 5.5, prompt v4: different, 62% confident — Both records sit at 521 Foothill Blvd, but the ABC record is the Ralphs 55 off-sale liquor store while the Uber Eats listing is 'Fresh & Ready from Ralphs', a separate prepared-food storefront; the names differ and the data holds two businesses at this address, so the address match alone does not make them one outlet.
pair 123c05ea7c928a9f3acc

Attributes

Channel
off_premise · grocery — ca-licence
Chain
Ralphs — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
RALPHS GROCERY COMPANY — 183 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "ubereats-type",
   "off_premise",
   "specialty_food"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
60 within 1 mi · 243 within 3 mi
Off / on premise
16 / 36 within 1 mi · 55 / 155 within 3 mi
Selling alcohol
31 within 1 mi · 155 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.08 mi
Setting
suburban (2,514 people per sq mi)
People within 3 mi
71,095 (52,571 adults 21+, 24,490 households) from 15 tract(s), tracts within 3 mi
Income
per capita $72,026 · median household ~$155,292 (weighted mean of tract medians)
Age and education
median age ~44.0 · bachelor's or higher 59%
Ethnicity
Hispanic 22% · White 48% · Black 10% · Asian 16%
Adults per alcohol outlet
337
Alcohol spend within 3 mi
$24,372,982 a year ($10,380,304 at home, $13,986,149 away) · $156,237 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:56insertdoordash 35801148 ↔ vtinfo 369217dce0ad676aone name contains the other, same addressmerged15
2026-11-16 14:56insertubereats muFo6pKlXHmRyKpD5pmjpw ↔ vtinfo 369217dce0ad676aone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72608 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72608 ↔ doordash 35801148one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407394|86|LIC|0 ↔ vtinfo 369217dce0ad676aone name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407394|21|LIC|0 ↔ vtinfo 369217dce0ad676aone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72608 ↔ ca-abc 00407394|86|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72608 ↔ ca-abc 00407394|21|LIC|0one name contains the other, same addressmerged15
2026-11-13 14:10updateca-abc 00407394|86|LIC|0 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwClaude judge: samemerged15
2026-11-13 14:10updateca-abc 00407394|21|LIC|0 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwClaude judge: samemerged15
2026-11-13 14:10insertoverture 6ce10aa1-6854-42e1-b092-f614fd34a1a2 ↔ vtinfo 369217dce0ad676asame address and namemerged15
2026-11-13 14:10updatedoordash 35801148 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwsame address and namemerged15
2026-11-13 14:10insertab-inbev 72608 ↔ overture 6ce10aa1-6854-42e1-b092-f614fd34a1a2same address and namemerged15
2026-11-12 14:25insertab-inbev 72608 ↔ vtinfo 369217dce0ad676asame address and namemerged12
2026-11-11 12:56insertca-abc 00407394|86|LIC|0 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwClaude judge: sameheld: same-source-conflict12
2026-11-11 12:56insertca-abc 00407394|21|LIC|0 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwClaude judge: sameheld: same-source-conflict12
2026-11-09 14:23insertdoordash 35801148 ↔ ubereats muFo6pKlXHmRyKpD5pmjpwsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407394|86|LIC|0 ↔ overture f77c8e59-1ff5-473a-876c-cb7a3562d0ffsame address and namemerged11
2026-11-06 18:13insertca-abc 00407394|21|LIC|0 ↔ overture f77c8e59-1ff5-473a-876c-cb7a3562d0ffsame address and namemerged11
2026-11-02 23:02backfillca-abc 00407394|86|LIC|0 ↔ ubereats ZrqxB4LDWEOFc_qf_EnlGwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407394|21|LIC|0 ↔ ubereats ZrqxB4LDWEOFc_qf_EnlGwClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35801148 ↔ ubereats ZrqxB4LDWEOFc_qf_EnlGwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407394|21|LIC|0 ↔ doordash 35801148Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407394|86|LIC|0 ↔ doordash 35801148Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407394|21|LIC|0 ↔ ca-abc 00407394|86|LIC|0one licence filemerged