Ralphs

PASADENA, CA 91105 · O06f93e6b48db · first seen 2026-10-08
7 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 4 other
the most common name a source states
RALPHS 743 ca-abc ×2
RALPHS FRESH FARE ab-inbevvtinfo ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
ralphs pasadena doordash
Street
320 W Colorado Blvd
ralphsno other value
City
Pasadena
ralphsno other value
State
CA
ralphsno other value
ZIP
91105
ralphsno other value
Pin
34.14529, -118.15703 map
ralphsno other value
Phone
6267934179
ralphsno other value
Licences
ca-abc 00407143|21|LIC|0 · ca-abc 00407143|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oafc1ac5cf59c; Oae5cc0baf574; O88433c508a2b; O280d0b414d10; Oa4dc4e9d76d0; O9ec9292f2065; O124df9348f98; O1c27ec5b13fb

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
72552
320 W COLORADO BLVD, PASADENA, CA, 9110534.14567, -118.156832026-11-112026-11-11
ca-abcRALPHS 743
legal name: RALPHS GROCERY COMPANY
00407143|21|LIC|0
320 W COLORADO BLVD, PASADENA, CA, 9110534.14569, -118.157032026-10-082026-11-12
ca-abcRALPHS 743
legal name: RALPHS GROCERY COMPANY
00407143|86|LIC|0
320 W COLORADO BLVD, PASADENA, CA, 9110534.14569, -118.157032026-10-082026-11-12
doordashralphs pasadena
35801414
320 W Colorado Blvd, Pasadena, CA, 9110534.14527, -118.157112026-10-082026-11-12
overtureRalphs
bc368a78-53fe-4b35-a01c-50187316799a
320 W Colorado Blvd, Pasadena, CA, 91105626793417934.14529, -118.157032026-11-062026-11-12
ralphsRalphs
320|91105
320 W Colorado Blvd, Pasadena, CA, 91105626793417934.14529, -118.157032026-11-102026-11-12
ubereatsRalphs
6gKLV0LHWgWetIac--XAHQ
320 W Colorado Blvd, Pasadena, CA, 9110534.14530, -118.157192026-10-092026-11-12
vtinfoRALPHS FRESH FARE
a73753d92fca3d9b
320 W COLORADO BLVD, PASADENA, CA, 91105626793417934.14521, -118.157122026-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
doordash ralphs pasadenaoverture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c9171.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917ubereats Ralphs1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 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 58 m apart · name similarity 1.00
ca-abc RALPHS 743ca-abc RALPHS 7431.00one licence filemergedfile: 00407143 · same_address
ca-abc RALPHS 743overture ecbf6ee7-7157-40f7-80f2-5ae8959045731.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 54 m apart · name similarity 1.00
ca-abc RALPHS 743overture ecbf6ee7-7157-40f7-80f2-5ae8959045731.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 54 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 7 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 7 m apart · name similarity 1.00
doordash ralphs pasadenaubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 8 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 15 m apart · name similarity 1.00
ralphs Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ca-abc RALPHS 743doordash ralphs pasadena0.62Claude 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 and ZIP (320 W Colorado Blvd, Pasadena 91105), and the off-sale licence fits a supermarket; the second business counted at that addres
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Ralphs licence and Ralphs listing at same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 320 W Colorado Blvd, Pasadena 91105, about 47 m apart; the California ABC off-sale licence is the store's own liquor license, and the DoorDash listing is the same store's storefront, so no separate premises rule applies.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are the Ralphs store at 320 W Colorado Blvd, Pasadena 91105, with matching street, city, ZIP and coordinates within 50 m; the CA ABC off-sale licence is the store's own alcohol department, and the DoorDash listing is that store's storefront, with the businesses_at_address count of 2 being the only doubt but the names agree on the chain.
  • Claude Haiku 5.5, prompt v4: same, 82% confident — Both records are the Ralphs chain at the identical street address and ZIP 91105 in Pasadena; the chain name matches with and without the store number (743 vs 'pasadena'), though the building is shared with another business, so the match rests on the Ralphs name agreeing.
pair 225e2949c5a39e62d006
ca-abc RALPHS 743ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical street address and ZIP, and the CA licence is an off-sale general store licence, so this is one supermarket despite the shared-address count.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the same street address and ZIP with matching coordinates 0.045 km apart, and California's rule makes the Uber Eats Ralphs listing the store's own department selling from the same premises as the Type 21 off-sale licence; the businesses_at_address count of 2 is explained by the store's tasting add-on and the shared address alone isn't decisive, but the chain name, address and location all agree.
  • Claude Haiku 5.5, prompt v4: same, 87% confident — Both records are Ralphs at 320 W Colorado Blvd, Pasadena 91105; the ABC record's 'RALPHS 743' is a store-numbered chain name matching the Uber Eats 'Ralphs' listing, and the names agree despite the shared building, with the active off-sale licence fitting a grocery store.
pair 61214fd2b67d00f25164
ca-abc RALPHS 743doordash ralphs pasadena0.62Claude 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 (320 W Colorado Blvd, Pasadena 91105), and the off-sale licence fits a supermarket, so the shared building does not change that the
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are the Ralphs store at 320 W Colorado Blvd, Pasadena 91105, with matching street, city, ZIP and coordinates within about 50 m; the DoorDash listing is the store's own alcohol-capable storefront under the same chain, and California treats that as the store's own department, not a separate premises.
pair d5d998b94d2dfa37a73a
ca-abc RALPHS 743ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical address, 320 W Colorado Blvd, Pasadena 91105, and A's off-sale general licence is the store's own, so the two names agree despite the shared building
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs store and listing at same address
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are the Ralphs store at 320 W Colorado Blvd, Pasadena 91105, with coordinates about 45 m apart; the CA ABC off-sale licence is the store's own alcohol department (Ralphs' own chain listing), and the state rule makes that the same outlet, with the 'businesses at address' count of 2 not contradicting since the other business is not a competing name at this address.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the same street address, ZIP and near-identical coordinates (0.045 km); the CA ABC off-sale licence is the store's own alcohol sales, and California's rule makes the Uber Eats listing the same store's alcohol department, though businesses_at_address is 2 and the suite is unnamed on both sides.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records name Ralphs at 320 W Colorado Blvd, Pasadena 91105, and the ABC record's store number (743) is just the chain's numbering, so this is one chain store listed twice. The building is shared with another business, but the names agree, and the ABC off-sale licence fits a grocery store.
pair 37bd1b0d963e09aaa46f
ab-inbev RALPHS FRESH FAREca-abc RALPHS 7430.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Ralphs store at same address, same chain.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are Ralphs at the identical street address in Pasadena with coordinates about 18 m apart, and the CA ABC licence is an off-sale general store licence held by Ralphs Grocery Company, so the 'Ralphs Fresh Fare' ab-inbev account is the same store's alcohol department at one premises (store number 743 is just a branch identifier).
pair 47c7a78913872645c675
ca-abc RALPHS 743vtinfo RALPHS FRESH FARE0.45Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (93% confident; asked as a “same-address” pair)
Both are Ralphs at 320 W Colorado Blvd, Pasadena (Ralphs Fresh Fare is the store's banner), with an off-sale licence matching a retail account carrying beer brands, so they are one store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are Ralphs at the same street address in Pasadena, with coordinates about 54 m apart; B is a Ralphs brand listing (Ralphs Fresh Fare, a store banner) and A is the Ralphs 743 store's off-sale licence, so this is the store and its own department under the same chain, though the two-business count at the address and the brand-only name on B leave some doubt.
pair 0561ab8641064beff67a
ab-inbev RALPHS FRESH FAREubereats Ralphs0.43Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Ralphs Fresh Fare is Ralphs banner at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the same street address and ZIP with nearly identical coordinates (about 52 m apart), and the Ralphs Fresh Fare name on the AB InBev record is the same chain banner, so the Uber Eats listing is the store's own alcohol/store department at one premises.
pair 4325b068ec288e83be22

Attributes

Channel
off_premise · grocery — ca-licence
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_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
  ],
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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-12 17:29insertab-inbev 72552 ↔ ubereats 6gKLV0LHWgWetIac--XAHQClaude judge: samemerged14
2026-11-12 17:29insertab-inbev 72552 ↔ ca-abc 00407143|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertca-abc 00407143|21|LIC|0 ↔ vtinfo a73753d92fca3d9bClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 72552 ↔ vtinfo a73753d92fca3d9bsame address and namemerged12
2026-11-10 17:05insertoverture bc368a78-53fe-4b35-a01c-50187316799a ↔ ralphs 320|91105same address and namemerged12
2026-11-10 17:05insertdoordash 35801414 ↔ ralphs 320|91105same address and namemerged12
2026-11-10 17:05insertralphs 320|91105 ↔ ubereats 6gKLV0LHWgWetIac--XAHQsame address and namemerged12
2026-11-09 15:32updatedoordash 35801414 ↔ overture bc368a78-53fe-4b35-a01c-50187316799asame address and namemerged11
2026-11-09 15:32updateoverture bc368a78-53fe-4b35-a01c-50187316799a ↔ ubereats 6gKLV0LHWgWetIac--XAHQsame address and namemerged11
2026-11-06 18:13insertca-abc 00407143|86|LIC|0 ↔ overture ecbf6ee7-7157-40f7-80f2-5ae895904573same address and namemerged11
2026-11-06 18:13insertdoordash 35801414 ↔ overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 35801414 ↔ overture bc368a78-53fe-4b35-a01c-50187316799asame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917 ↔ ubereats 6gKLV0LHWgWetIac--XAHQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture bc368a78-53fe-4b35-a01c-50187316799a ↔ ubereats 6gKLV0LHWgWetIac--XAHQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407143|21|LIC|0 ↔ overture ecbf6ee7-7157-40f7-80f2-5ae895904573same address and namemerged11
2026-11-02 23:02backfillca-abc 00407143|86|LIC|0 ↔ doordash 35801414Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407143|21|LIC|0 ↔ ubereats 6gKLV0LHWgWetIac--XAHQClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407143|86|LIC|0 ↔ ubereats 6gKLV0LHWgWetIac--XAHQClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407143|21|LIC|0 ↔ doordash 35801414Claude judge: samemerged
2026-10-11 15:03backfilldoordash 35801414 ↔ ubereats 6gKLV0LHWgWetIac--XAHQsame address and namemerged
2026-10-09 13:59backfillca-abc 00407143|21|LIC|0 ↔ ca-abc 00407143|86|LIC|0one licence filemerged