Outlets /
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.
| Field | Master value | Taken from | What 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 | ralphs | no other value |
| City | Pasadena | ralphs | no other value |
| State | CA | ralphs | no other value |
| ZIP | 91105 | ralphs | no other value |
| Pin | 34.14529, -118.15703 map | ralphs | no other value |
| Phone | 6267934179 | ralphs | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | RALPHS FRESH FARE 72552 | 320 W COLORADO BLVD, PASADENA, CA, 91105 | 34.14567, -118.15683 | 2026-11-11 | 2026-11-11 | |
| ca-abc | RALPHS 743 legal name: RALPHS GROCERY COMPANY 00407143|21|LIC|0 | 320 W COLORADO BLVD, PASADENA, CA, 91105 | 34.14569, -118.15703 | 2026-10-08 | 2026-11-12 | |
| ca-abc | RALPHS 743 legal name: RALPHS GROCERY COMPANY 00407143|86|LIC|0 | 320 W COLORADO BLVD, PASADENA, CA, 91105 | 34.14569, -118.15703 | 2026-10-08 | 2026-11-12 | |
| doordash | ralphs pasadena 35801414 | 320 W Colorado Blvd, Pasadena, CA, 91105 | 34.14527, -118.15711 | 2026-10-08 | 2026-11-12 | |
| overture | Ralphs bc368a78-53fe-4b35-a01c-50187316799a | 320 W Colorado Blvd, Pasadena, CA, 91105 | 6267934179 | 34.14529, -118.15703 | 2026-11-06 | 2026-11-12 |
| ralphs | Ralphs 320|91105 | 320 W Colorado Blvd, Pasadena, CA, 91105 | 6267934179 | 34.14529, -118.15703 | 2026-11-10 | 2026-11-12 |
| ubereats | Ralphs 6gKLV0LHWgWetIac--XAHQ | 320 W Colorado Blvd, Pasadena, CA, 91105 | 34.14530, -118.15719 | 2026-10-09 | 2026-11-12 | |
| vtinfo | RALPHS FRESH FARE a73753d92fca3d9b | 320 W COLORADO BLVD, PASADENA, CA, 91105 | 6267934179 | 34.14521, -118.15712 | 2026-11-11 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| doordash ralphs pasadena | overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917 | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917 | ubereats Ralphs | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ab-inbev RALPHS FRESH FARE | vtinfo RALPHS FRESH FARE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00 |
| ca-abc RALPHS 743 | ca-abc RALPHS 743 | 1.00 | one licence file | merged | file: 00407143 · same_address |
| ca-abc RALPHS 743 | overture ecbf6ee7-7157-40f7-80f2-5ae895904573 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 54 m apart · name similarity 1.00 |
| ca-abc RALPHS 743 | overture ecbf6ee7-7157-40f7-80f2-5ae895904573 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 54 m apart · name similarity 1.00 |
| doordash ralphs pasadena | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| doordash ralphs pasadena | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| doordash ralphs pasadena | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00 |
| overture Ralphs | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal |
| overture Ralphs | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ralphs Ralphs | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ca-abc RALPHS 743 | doordash ralphs pasadena | 0.62 | Claude judge: same | merged | 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:
pair 225e2949c5a39e62d006 |
| ca-abc RALPHS 743 | ubereats Ralphs | 0.62 | Claude judge: same | merged | 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:
pair 61214fd2b67d00f25164 |
| ca-abc RALPHS 743 | doordash ralphs pasadena | 0.62 | Claude judge: same | merged | 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:
pair d5d998b94d2dfa37a73a |
| ca-abc RALPHS 743 | ubereats Ralphs | 0.62 | Claude judge: same | merged | 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:
pair 37bd1b0d963e09aaa46f |
| ab-inbev RALPHS FRESH FARE | ca-abc RALPHS 743 | 0.45 | Claude judge: same | merged | 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:
pair 47c7a78913872645c675 |
| ca-abc RALPHS 743 | vtinfo RALPHS FRESH FARE | 0.45 | Claude judge: same | merged | 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:
pair 0561ab8641064beff67a |
| ab-inbev RALPHS FRESH FARE | ubereats Ralphs | 0.43 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ab-inbev 72552 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 72552 ↔ ca-abc 00407143|21|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ca-abc 00407143|21|LIC|0 ↔ vtinfo a73753d92fca3d9b | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 72552 ↔ vtinfo a73753d92fca3d9b | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture bc368a78-53fe-4b35-a01c-50187316799a ↔ ralphs 320|91105 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35801414 ↔ ralphs 320|91105 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | ralphs 320|91105 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | same address and name | merged | 12 |
| 2026-11-09 15:32 | update | doordash 35801414 ↔ overture bc368a78-53fe-4b35-a01c-50187316799a | same address and name | merged | 11 |
| 2026-11-09 15:32 | update | overture bc368a78-53fe-4b35-a01c-50187316799a ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00407143|86|LIC|0 ↔ overture ecbf6ee7-7157-40f7-80f2-5ae895904573 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 35801414 ↔ overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | doordash 35801414 ↔ overture bc368a78-53fe-4b35-a01c-50187316799a | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture 90efe2fa-ebfb-4e9e-8bfa-22d185f9c917 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture bc368a78-53fe-4b35-a01c-50187316799a ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00407143|21|LIC|0 ↔ overture ecbf6ee7-7157-40f7-80f2-5ae895904573 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00407143|86|LIC|0 ↔ doordash 35801414 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407143|21|LIC|0 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407143|86|LIC|0 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407143|21|LIC|0 ↔ doordash 35801414 | Claude judge: same | merged | |
| 2026-10-11 15:03 | backfill | doordash 35801414 ↔ ubereats 6gKLV0LHWgWetIac--XAHQ | same address and name | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00407143|21|LIC|0 ↔ ca-abc 00407143|86|LIC|0 | one licence file | merged |