Outlets /
Ralphs
Pasadena, CA 91107 · O2bed878b96fb · 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Ralphs 7 other | the most common name a source states | RALPHS FRESH FARE ab-inbevvtinfo ×2 Bloom Haus by Ralphs ubereats bloom haus by ralphs pasadena doordash Fresh & Ready from Ralphs ubereats HUGHES MARKETS INC ca-abc (legal name) RALPHS 730 ca-abc ralphs pasadena doordash |
| Street | 3601 E Foothill Blvd 1 other | ralphs | 3601 East Foothill Boulevard doordash |
| City | Pasadena | ralphs | no other value |
| State | CA | ralphs | no other value |
| ZIP | 91107 | ralphs | no other value |
| Pin | 34.15133, -118.07533 map 1 other | ralphs | 145 m away ca-abc |
| Phone | 6263518806 | ralphs | no other value |
| Licences | ca-abc 00128673|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oa1192a417005; O983e07a997c7; O8d3b7b3da0b7; O4ca241b2446e; Ob69cea732f8d; O872bac8f290b; O472c5def9b04; O4e46176d6d16
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 4879384 | 3601 E FOOTHILL BLVD, PASADENA, CA, 91107 | 34.15119, -118.07490 | 2026-11-11 | 2026-11-12 | |
| ca-abc | RALPHS 730 legal name: HUGHES MARKETS INC 00128673|21|LIC|0 | 3601 E FOOTHILL BLVD, PASADENA, CA, 91107 | 34.15022, -118.07617 | 2026-10-08 | 2026-11-05 | |
| doordash | bloom haus by ralphs pasadena 24199704 | 3601 East Foothill Boulevard, Pasadena, CA, 91107 | 34.15131, -118.07535 | 2026-10-08 | 2026-11-13 | |
| doordash | ralphs pasadena 35800663 | 3601 E Foothill Blvd, Pasadena, CA, 91107 | 34.15127, -118.07543 | 2026-10-08 | 2026-10-14 | |
| overture | Ralphs d19862e6-f2f8-46ff-b7e2-dbe3dcc81853 | 3601 E Foothill Blvd, Pasadena, CA, 91107 | 6263518806 | 34.15133, -118.07533 | 2026-11-06 | 2026-11-06 |
| ralphs | Ralphs 3601|91107 | 3601 E Foothill Blvd, Pasadena, CA, 91107 | 6263518806 | 34.15133, -118.07533 | 2026-11-10 | 2026-11-10 |
| ubereats | Bloom Haus by Ralphs 34gZcxsYXuCflCCOJ1zhkA | 3601 E Foothill Blvd, Pasadena, CA, 91107 | 34.15105, -118.07548 | 2026-10-14 | 2026-11-13 | |
| ubereats | Fresh & Ready from Ralphs EIdTDChBXiSSiokjSVN5FA | 3601 E Foothill Blvd, Pasadena, CA, 91107 | 34.15124, -118.07581 | 2026-10-20 | 2026-11-02 | |
| vtinfo | RALPHS FRESH FARE cb64337ecec8695e | 3601 E FOOTHILL BLVD, PASADENA, CA, 91107 | 6263518806 | 34.15124, -118.07581 | 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 |
|---|---|---|---|---|---|
| ca-abc RALPHS 730 | overture d6ee23a7-1e9b-480b-af20-dd7c3c093333 | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 140 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 84 m apart · name similarity 1.00 |
| doordash bloom haus by ralphs pasadena | ubereats Bloom Haus by Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 32 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 12 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 12 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 |
| ca-abc RALPHS 730 | 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 (3601 E Foothill Blvd, Pasadena 91107), with an off-sale general licence matching a supermarket, and the names agree despite the sh Other Claude answers on this pair:
pair 3b4ea3bf18961c9df747 |
| ab-inbev RALPHS FRESH FARE | ca-abc RALPHS 730 | 0.38 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair) Ralphs Fresh Fare is Ralphs store at same address Other Claude answers on this pair:
pair 0839f8c155f8660548ca |
| doordash ralphs pasadena | ubereats Bloom Haus by Ralphs | 0.36 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair) Bloom Haus is Ralphs' floral department at same address Other Claude answers on this pair:
pair 158b70654c965f5292dc |
| ca-abc RALPHS 730 | ubereats Bloom Haus by Ralphs | 0.33 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair) Bloom Haus is Ralphs floral department at same address Other Claude answers on this pair:
pair 0b5e93ed159070b48396 |
| doordash ralphs pasadena | ubereats Fresh & Ready from Ralphs | 0.33 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records are the Ralphs chain at the identical address, 3601 E Foothill Blvd, Pasadena 91107, and 'Fresh & Ready from Ralphs' is Ralphs' own second Uber Eats listing of the same store, not another Other Claude answers on this pair:
pair 997930fc8b5fe7afcbca |
| ca-abc RALPHS 730 | ubereats Fresh & Ready from Ralphs | 0.31 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records are the Ralphs store at 3601 E Foothill Blvd, Pasadena 91107, and 'Fresh & Ready from Ralphs' is that same store's Uber Eats listing, not a separate operation. Other Claude answers on this pair:
pair 66e2a6b1ef2835598d24 |
Attributes
- Channel
- off_premise · grocery — ca-licence conflicting evidence
- Chain
- Ralphs — chain-locator
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- HUGHES MARKETS INC — 32 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:16.
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",
"specialty_food"
],
[
"doordash-url",
"off_premise",
null
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 100 within 1 mi · 535 within 3 mi
- Off / on premise
- 39 / 46 within 1 mi · 140 / 269 within 3 mi
- Selling alcohol
- 65 within 1 mi · 310 within 3 mi
- Nearest
- same channel 0.03 mi · licensed 0.06 mi
- Setting
- urban (4,960 people per sq mi)
- People within 3 mi
- 140,233 (109,574 adults 21+, 53,852 households) from 32 tract(s), tracts within 3 mi
- Income
- per capita $63,078 · median household ~$117,649 (weighted mean of tract medians)
- Age and education
- median age ~43.5 · bachelor's or higher 58%
- Ethnicity
- Hispanic 22% · White 32% · Black 4% · Asian 40%
- Adults per alcohol outlet
- 352
- Alcohol spend within 3 mi
- $46,716,464 a year ($20,359,674 at home, $26,339,444 away) · $150,214 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-13 14:10 | update | ca-abc 00128673|21|LIC|0 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkA | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | doordash 35800663 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkA | Claude judge: same | merged | 15 |
| 2026-11-12 17:29 | insert | ca-abc 00128673|21|LIC|0 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkA | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 17:29 | insert | doordash 35800663 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkA | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 4879384 ↔ ca-abc 00128673|21|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-11 12:56 | insert | ab-inbev 4879384 ↔ vtinfo cb64337ecec8695e | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture d19862e6-f2f8-46ff-b7e2-dbe3dcc81853 ↔ ralphs 3601|91107 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35800663 ↔ ralphs 3601|91107 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00128673|21|LIC|0 ↔ overture d6ee23a7-1e9b-480b-af20-dd7c3c093333 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | doordash 35800663 ↔ overture d19862e6-f2f8-46ff-b7e2-dbe3dcc81853 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00128673|21|LIC|0 ↔ ubereats EIdTDChBXiSSiokjSVN5FA | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 35800663 ↔ ubereats EIdTDChBXiSSiokjSVN5FA | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00128673|21|LIC|0 ↔ doordash 35800663 | Claude judge: same | merged | |
| 2026-10-14 18:03 | backfill | doordash 24199704 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkA | same address and name | merged |