Ralphs

Pasadena, CA 91101 · O1afce27557dc · first seen 2026-10-08
7 sourcesoff premise · grocerychain: Ralphsalcohol: 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
Ralphs 5 other
the most common name a source states
Bloom Haus by Ralphs ubereats
Fresh & Ready from Ralphs ubereats
RALPHS 96 ca-abc
RALPHS GROCERY COMPANY ca-abc (legal name)
ralphs pasadena doordash
Street
160 N Lake Ave
ralphsno other value
City
Pasadena
ralphsno other value
State
CA
ralphsno other value
ZIP
91101
ralphsno other value
Pin
34.14896, -118.13142 map 2 other
ralphs
98 m away ab-inbev
84 m away ca-abc
Phone
6267937480
ralphsno other value
Licences
ca-abc 00407130|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocec0ce5963d6; O45527a8b0bfa; O2ce319d8d991; O2360b0e0242a; Oa0fd130da68e; O4d7cf4f15e4e; O1b2bd37f5903; Odee0d4f18eee

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
72445
160 N LAKE AVE, PASADENA, CA, 9110134.14847, -118.132312026-11-112026-11-13
ca-abcRALPHS 96
legal name: RALPHS GROCERY COMPANY
00407130|21|LIC|0
160 N LAKE AVE, PASADENA, CA, 9110134.14878, -118.132312026-10-082026-11-13
doordashralphs pasadena
35802318
160 N Lake Ave, Pasadena, CA, 9110134.14902, -118.131452026-10-082026-11-13
overtureRalphs
a830ffc4-f963-4a58-bdef-797e76da6a82
160 N Lake Ave, Pasadena, CA, 91101626793748034.14896, -118.131422026-11-062026-11-13
ralphsRalphs
160|91101
160 N Lake Ave, Pasadena, CA, 91101626793748034.14896, -118.131422026-11-102026-11-13
ubereatsBloom Haus by Ralphs
fFyeRrOqXzuW_bpfFpgbgg
160 N Lake Ave, Pasadena, CA, 9110134.14914, -118.131522026-10-202026-10-20
ubereatsRalphs
qX_SI621XmSn38Glwskd6Q
160 N Lake Ave, Pasadena, CA, 9110134.14897, -118.131552026-10-102026-11-13
ubereatsFresh & Ready from Ralphs
s6iFfIoDVEC3qZqQ2X6whQ
160 N Lake Ave, Pasadena, CA, 9110134.14892, -118.131552026-10-202026-11-13
vtinfoRALPHS
e39b8015497b5ee8
160 N LAKE AVE, PASADENA, CA, 91101626793748034.14897, -118.131292026-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 RALPHSdoordash ralphs pasadena1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 100 m apart · name similarity 1.00
ab-inbev RALPHSoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 98 m apart · name similarity 1.00
ab-inbev RALPHSralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 98 m apart · name similarity 1.00
ab-inbev RALPHSubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 89 m apart · name similarity 1.00
ab-inbev RALPHSvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 109 m apart · name similarity 1.00
doordash ralphs pasadenaoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash ralphs pasadenaralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash ralphs pasadenaubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
doordash ralphs pasadenavtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
overture Ralphsralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal
overture Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
overture Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00 · phone: equal
ralphs Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ralphs Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00 · phone: equal
ubereats Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
ca-abc RALPHS 96doordash ralphs pasadena0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain store at the same street address and ZIP (160 N Lake Ave, Pasadena 91101), and the ABC off-sale general licence matches a supermarket; the names agree despite the sha
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — The ca-abc record is an active Type 21 off-sale licence at 160 N Lake Ave, Pasadena, matching the DoorDash Ralphs listing at the same street address and ZIP, with coordinates about 84 m apart; both are Ralphs, and California treats a chain store's alcohol listing as the store's own department, so this is one outlet despite the building holding three businesses.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give 160 N Lake Ave, Pasadena 91101, and the names match the Ralphs chain (RALPHS 96 vs ralphs pasadena), which the rules treat as one chain store under different spellings at one address, though the building houses three businesses and the names are the only real discriminator.
pair 6344c365d543a1c4b4ab
ca-abc RALPHS 96ubereats Ralphs0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records name the Ralphs chain at the identical street address and ZIP (160 N Lake Ave, Pasadena 91101), and A's off-sale licence fits a supermarket, so this is one Ralphs store even though the bu
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records are Ralphs at 160 N Lake Ave, Pasadena 91101, about 73 m apart, and the ABC licence is for a Ralphs store number 96 (a chain store with its number), so the names agree and this is one grocery store, though the building holds three businesses.
pair 7155bc5d4ef378588ce9
ab-inbev RALPHSubereats Bloom Haus by Ralphs0.36Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Bloom Haus is Ralphs' floral department, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 160 N Lake Ave, Pasadena (about 0.1 km apart) and belong to the Ralphs chain; the Uber Eats listing 'Bloom Haus by Ralphs' is Kroger's floral department of the same Ralphs store, so it is the store's own department rather than a concession, though the building holds three businesses and the names only partly agree.
pair 0e5bbf027b5c45d51521
ca-abc RALPHS 96ubereats 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 Ralphs at 160 N Lake Ave, Pasadena 91101, and 'Fresh & Ready from Ralphs' is an Uber Eats listing of that same Ralphs store, which holds the off-sale licence; under California's rule
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 62% confident — Both records sit at the same street address and about 72 m apart, and both belong to the Ralphs chain; the Uber Eats listing reads as a Ralphs store's own food department, but the shared building (3 businesses) and the different naming keep this from being certain.
pair 942df2271bae5c602f76

Attributes

Channel
off_premise · grocery — ca-licence conflicting evidence
Chain
Ralphs — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
RALPHS GROCERY COMPANY — 183 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "ubereats-type",
   "non_beverage",
   "florist"
  ],
  [
   "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
295 within 1 mi · 832 within 3 mi
Off / on premise
42 / 188 within 1 mi · 156 / 474 within 3 mi
Selling alcohol
166 within 1 mi · 530 within 3 mi
Nearest
same channel 1.68 mi · licensed 0.01 mi
Setting
urban (6,066 people per sq mi)
People within 3 mi
171,516 (136,246 adults 21+, 69,926 households) from 40 tract(s), tracts within 3 mi
Income
per capita $67,460 · median household ~$116,515 (weighted mean of tract medians)
Age and education
median age ~41.2 · bachelor's or higher 59%
Ethnicity
Hispanic 31% · White 39% · Black 7% · Asian 20%
Adults per alcohol outlet
257
Alcohol spend within 3 mi
$59,328,039 a year ($25,886,296 at home, $33,419,043 away) · $111,729 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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 00407130|21|LIC|0 ↔ ubereats s6iFfIoDVEC3qZqQ2X6whQClaude judge: samemerged15
2026-11-13 14:10updateab-inbev 72445 ↔ ubereats fFyeRrOqXzuW_bpfFpgbggClaude judge: samemerged15
2026-11-12 17:29insertab-inbev 72445 ↔ ubereats fFyeRrOqXzuW_bpfFpgbggClaude judge: sameheld: same-source-conflict14
2026-11-11 12:56insertab-inbev 72445 ↔ vtinfo e39b8015497b5ee8same address and namemerged12
2026-11-11 12:56insertoverture a830ffc4-f963-4a58-bdef-797e76da6a82 ↔ vtinfo e39b8015497b5ee8same address and namemerged12
2026-11-11 12:56insertralphs 160|91101 ↔ vtinfo e39b8015497b5ee8same address and namemerged12
2026-11-11 12:56insertdoordash 35802318 ↔ vtinfo e39b8015497b5ee8same address and namemerged12
2026-11-11 12:56insertubereats qX_SI621XmSn38Glwskd6Q ↔ vtinfo e39b8015497b5ee8same address and namemerged12
2026-11-11 12:56insertab-inbev 72445 ↔ overture a830ffc4-f963-4a58-bdef-797e76da6a82same address and namemerged12
2026-11-11 12:56insertab-inbev 72445 ↔ ralphs 160|91101same address and namemerged12
2026-11-11 12:56insertab-inbev 72445 ↔ doordash 35802318same address and namemerged12
2026-11-11 12:56insertab-inbev 72445 ↔ ubereats qX_SI621XmSn38Glwskd6Qsame address and namemerged12
2026-11-10 17:05insertoverture a830ffc4-f963-4a58-bdef-797e76da6a82 ↔ ralphs 160|91101same address and namemerged12
2026-11-10 17:05insertdoordash 35802318 ↔ ralphs 160|91101same address and namemerged12
2026-11-10 17:05insertralphs 160|91101 ↔ ubereats qX_SI621XmSn38Glwskd6Qsame address and namemerged12
2026-11-06 18:13insertdoordash 35802318 ↔ overture a830ffc4-f963-4a58-bdef-797e76da6a82same address and namemerged11
2026-11-06 18:13insertoverture a830ffc4-f963-4a58-bdef-797e76da6a82 ↔ ubereats qX_SI621XmSn38Glwskd6Qsame address and namemerged11
2026-11-02 23:02backfillca-abc 00407130|21|LIC|0 ↔ ubereats s6iFfIoDVEC3qZqQ2X6whQClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407130|21|LIC|0 ↔ ubereats qX_SI621XmSn38Glwskd6QClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407130|21|LIC|0 ↔ doordash 35802318Claude judge: samemerged
2026-10-11 15:03backfilldoordash 35802318 ↔ ubereats qX_SI621XmSn38Glwskd6Qsame address and namemerged