RALPHS 1

LA CRESCENTA, CA 91214 · O11af9240eec6 · 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 1 5 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 la crescenta doordash
Street
2675 FOOTHILL BLVD
ca-abcno other value
City
LA CRESCENTA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91214
ca-abcno other value
Pin
34.22248, -118.23714 map 4 other
ubereats
92 m away ab-inbev
91 m away doordash
100 m away overture
84 m away ubereats
Phone
8182495448
vtinfono other value
Licences
ca-abc 00407396|21|LIC|0 · ca-abc 00407396|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob60eab1bb50f; O7fcb6c18a2f2; O1c311923b91b; O8b001e85d1eb; O3f5acb8bce18; O166b67cabd65; O42521a4aada1; O64b18c3cc777

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
72521
2675 FOOTHILL BLVD, LA CRESCENTA, CA, 9121434.22291, -118.236292026-11-112026-11-12
ca-abcRALPHS 1
legal name: RALPHS GROCERY COMPANY
00407396|21|LIC|0
2675 FOOTHILL BLVD, LA CRESCENTA, CA, 9121434.22230, -118.236852026-10-082026-11-12
ca-abcRALPHS 1
legal name: RALPHS GROCERY COMPANY
00407396|86|LIC|0
2675 FOOTHILL BLVD, LA CRESCENTA, CA, 9121434.22230, -118.236852026-10-082026-11-12
doordashralphs la crescenta
35799111
2675 Foothill Blvd, La Crescenta, CA, 9121434.22316, -118.236592026-10-082026-11-12
overtureRalphs Fresh Fare
e91fb060-838c-4dad-838e-fbd6e583b966
2675 Foothill Blvd, La Crescenta, CA, 91214818249544834.22333, -118.236802026-11-132026-11-13
ubereatsFresh & Ready From Ralphs
J9C0rZwjUPuhSApuSmhf2w
2675 Foothill Blvd, La Crescenta, CA, 9121434.22248, -118.237142026-10-142026-11-12
ubereatsRalphs
RCkPgMNrU46ZdVK_7FCpJQ
2675 Foothill Blvd, La Crescenta, CA, 9121434.22314, -118.236702026-11-092026-11-13
vtinfoRALPHS FRESH FARE
c106318219d646b4
2675 FOOTHILL BLVD, LA CRESCENTA, CA, 91214818249544834.22253, -118.237082026-11-122026-11-13

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 66 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 84 m apart · name similarity 1.00
ca-abc RALPHS 1ca-abc RALPHS 11.00one licence filemergedfile: 00407396 · same_address
doordash ralphs la crescentaubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 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 92 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 1doordash ralphs la crescenta0.68Claude 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 identical street address 2675 Foothill Blvd, La Crescenta 91214, and the CA off-sale licence fits a supermarket, so the shared building does not split them sin
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at 2675 Foothill Blvd, La Crescenta, 91214, with coordinates about 0.1 km apart; the CA ABC off-sale licence is the store's own alcohol department, and California treats it as the store's own department, so this is one outlet despite the businesses_at_address count of 3 and the 'RALPHS 1' name.
pair f76b3ff50bb8e46d8504
ca-abc RALPHS 1ubereats Ralphs0.68Claude 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 (2675 Foothill Blvd, 91214), and the California licence is off-sale general, which matches a supermarket; the names agree, so the s
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — The CA ABC off-sale general licence at 2675 Foothill Blvd is the Ralphs store's alcohol licence, and the Uber Eats Ralphs listing matches the same street address, ZIP, and coordinates (0.09 km apart), with California's rule making a chain store's alcohol sales its own department; the 'RALPHS 1' name suffix and the shared building (3 businesses) are the main residual uncertainty.
pair 5b9af2a48f5053ee761f
ca-abc RALPHS 1doordash ralphs la crescenta0.68Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the Ralphs supermarket at 2675 Foothill Blvd, La Crescenta 91214, where A holds an off-sale general licence, and the names agree despite the shared building.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are the Ralphs store at 2675 Foothill Blvd, La Crescenta 91214, with coordinates about 0.1 km apart, and California's rule makes the store's alcohol listing its own department, so the ABC off-sale licence and the DoorDash listing are one operation; the shared building (3 businesses) is outweighed by the matching chain name and street address.
pair 7722f8ec2cb0c961a344
ca-abc RALPHS 1ubereats Ralphs0.68Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name the Ralphs chain at the identical street address and ZIP (2675 Foothill Blvd, 91214), the coordinates are 94 m apart, and the off-sale general licence matches a supermarket, so the s
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs same address, same chain.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are the Ralphs store at 2675 Foothill Blvd, La Crescenta, ZIP 91214, about 94 m apart; the CA ABC off-sale licence (legal name Ralphs Grocery Company, name 'RALPHS 1') and the Uber Eats 'Ralphs' listing share the same chain and street address, and the state rule makes a chain store's alcohol listing its own department, so this is one outlet despite the shared-building count of 3.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the same street address and ZIP with matching coordinates within 0.1 km, and the CA ABC off-sale general licence at that address is the grocery store's own alcohol licence, so the Uber Eats listing is the same store's storefront; the suite-free addresses and three businesses at the address lower confidence slightly, but the chain name and address agree closely.
pair 2ab587a1b81ffe402255
ca-abc RALPHS 1overture e563b182-9b24-4c09-b0b4-0c403b3bc0420.61same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 121 m apart · name similarity 0.61
ca-abc RALPHS 1overture e563b182-9b24-4c09-b0b4-0c403b3bc0420.61same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 121 m apart · name similarity 0.61
ab-inbev RALPHS FRESH FAREca-abc RALPHS 10.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Ralphs Fresh Fare and Ralphs licence at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the identical street address (2675 Foothill Blvd, La Crescenta, ZIP 91214) with coordinates about 85 m apart; the ab-inbev 'Ralphs Fresh Fare' listing and the CA ABC off-sale licence under 'RALPHS 1' (legal Ralphs Grocery Company) are the same store's alcohol/brand listing, and no differing suite numbers or separate operator appear.
pair 3a5eb8f4760ed3b4bc9a
ab-inbev RALPHS FRESH FAREdoordash ralphs la crescenta0.43Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “same-address” pair)
Both records are the Ralphs at the same street address, 2675 Foothill Blvd, La Crescenta 91214; 'Ralphs Fresh Fare' is a Ralphs store banner and the DoorDash slug is the chain name plus the city, so t
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Ralphs at same address, Fresh Fare is banner variant
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the same street address in La Crescenta, CA 91214, with coordinates 0.039 km apart; the DoorDash listing is the store's own alcohol/storefront listing, and California's rule makes it the store's own department, so it is the same outlet.
pair 0315584c7de8f95fe5b5
doordash ralphs la crescentaubereats Fresh & Ready From Ralphs0.34Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records are Ralphs at the same street address and ZIP, 91 m apart; 'Fresh & Ready From Ralphs' is Ralphs' own prepared-food listing for the store, so this is one store under a second delivery-app
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 87% confident — Fresh & Ready is Ralphs prepared-food department, same address.
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records are Ralphs at the same street address and ZIP, 0.09 km apart; 'Fresh & Ready From Ralphs' is Ralphs' own prepared-food department brand, so it is the store's own listing, not a concession, despite the building holding three businesses.
  • Claude Haiku 5.5, prompt v7: same, 72% confident — Both records are Ralphs at the same street address and ZIP, with coordinates about 91 m apart and no conflicting suite numbers; the Uber Eats 'Fresh & Ready From Ralphs' listing reads as a Ralphs department listing rather than a separate operation, though the shared building (3 businesses at the address) leaves some doubt.
  • Claude Haiku 5.5, prompt v4: same, 72% confident — Both records sit at 2675 Foothill Blvd (about 90 m apart) and both carry the Ralphs banner, and 'Fresh & Ready From Ralphs' reads as the store's own prepared-food department listed on Uber Eats, which counts as a second listing of one operation; the shared building (3 businesses) and the possibility of a separately run concession keep this from being certain.
pair 15ca57fe53146eb7646f
ca-abc RALPHS 1ubereats 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 2675 Foothill Blvd, La Crescenta 91214, and 'Fresh & Ready From Ralphs' reads as Uber Eats' prepared-food listing of that one store rather than a concession run by
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 2675 Foothill Blvd, La Crescenta 91214 with coordinates about 33 m apart, and both are Ralphs: the ABC off-sale licence is the Ralphs store's own liquor department, matching the Uber Eats 'Fresh & Ready From Ralphs' listing, though the shared building (3 businesses) and the absence of a suite on either side leave some doubt.
pair f8b750ededb3a5e7f430
ca-abc RALPHS 1ubereats 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 2675 Foothill Blvd, La Crescenta: the Uber Eats 'Fresh & Ready From Ralphs' listing is a storefront of the same Ralphs off-sale premises, not a separate business,
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at the same street address and ZIP with matching coordinates 33 m apart; the Uber Eats listing 'Fresh & Ready From Ralphs' is the store's own alcohol/food listing, and CA's rule makes the store's alcohol sales its own department, though 'businesses_at_address' is 3 so the shared building lowers confidence slightly.
pair 73ef2b651645115ad913

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:15.
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
64 within 1 mi · 271 within 3 mi
Off / on premise
22 / 31 within 1 mi · 70 / 170 within 3 mi
Selling alcohol
34 within 1 mi · 156 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (2,719 people per sq mi)
People within 3 mi
76,873 (56,027 adults 21+, 27,258 households) from 15 tract(s), tracts within 3 mi
Income
per capita $73,780 · median household ~$152,534 (weighted mean of tract medians)
Age and education
median age ~43.7 · bachelor's or higher 62%
Ethnicity
Hispanic 13% · White 57% · Black 1% · Asian 23%
Adults per alcohol outlet
357
Alcohol spend within 3 mi
$27,178,437 a year ($11,531,688 at home, $15,638,822 away) · $173,111 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-13 14:10updateca-abc 00407396|21|LIC|0 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQClaude judge: samemerged15
2026-11-13 14:10updateca-abc 00407396|86|LIC|0 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQClaude judge: samemerged15
2026-11-13 14:10insertoverture e91fb060-838c-4dad-838e-fbd6e583b966 ↔ vtinfo c106318219d646b4same address and namemerged15
2026-11-13 14:10insertab-inbev 72521 ↔ overture e91fb060-838c-4dad-838e-fbd6e583b966same address and namemerged15
2026-11-13 14:10updatedoordash 35799111 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQsame address and namemerged15
2026-11-12 17:29insertab-inbev 72521 ↔ ca-abc 00407396|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 72521 ↔ doordash 35799111Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 72521 ↔ vtinfo c106318219d646b4same address and namemerged12
2026-11-11 12:56insertca-abc 00407396|21|LIC|0 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQClaude judge: sameheld: same-source-conflict12
2026-11-11 12:56insertca-abc 00407396|86|LIC|0 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQClaude judge: sameheld: same-source-conflict12
2026-11-09 01:04insertdoordash 35799111 ↔ ubereats RCkPgMNrU46ZdVK_7FCpJQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407396|21|LIC|0 ↔ overture e563b182-9b24-4c09-b0b4-0c403b3bc042same address and namemerged11
2026-11-06 18:13insertca-abc 00407396|86|LIC|0 ↔ overture e563b182-9b24-4c09-b0b4-0c403b3bc042same address and namemerged11
2026-11-02 23:02backfillca-abc 00407396|21|LIC|0 ↔ ubereats J9C0rZwjUPuhSApuSmhf2wClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407396|86|LIC|0 ↔ ubereats J9C0rZwjUPuhSApuSmhf2wClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35799111 ↔ ubereats J9C0rZwjUPuhSApuSmhf2wClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407396|21|LIC|0 ↔ doordash 35799111Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407396|86|LIC|0 ↔ doordash 35799111Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407396|21|LIC|0 ↔ ca-abc 00407396|86|LIC|0one licence filemerged