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.

FieldMaster valueTaken fromWhat 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
ralphsno other value
State
CA
ralphsno other value
ZIP
91107
ralphsno other value
Pin
34.15133, -118.07533 map 1 other
ralphs
145 m away ca-abc
Phone
6263518806
ralphsno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevRALPHS FRESH FARE
4879384
3601 E FOOTHILL BLVD, PASADENA, CA, 9110734.15119, -118.074902026-11-112026-11-12
ca-abcRALPHS 730
legal name: HUGHES MARKETS INC
00128673|21|LIC|0
3601 E FOOTHILL BLVD, PASADENA, CA, 9110734.15022, -118.076172026-10-082026-11-05
doordashbloom haus by ralphs pasadena
24199704
3601 East Foothill Boulevard, Pasadena, CA, 9110734.15131, -118.075352026-10-082026-11-13
doordashralphs pasadena
35800663
3601 E Foothill Blvd, Pasadena, CA, 9110734.15127, -118.075432026-10-082026-10-14
overtureRalphs
d19862e6-f2f8-46ff-b7e2-dbe3dcc81853
3601 E Foothill Blvd, Pasadena, CA, 91107626351880634.15133, -118.075332026-11-062026-11-06
ralphsRalphs
3601|91107
3601 E Foothill Blvd, Pasadena, CA, 91107626351880634.15133, -118.075332026-11-102026-11-10
ubereatsBloom Haus by Ralphs
34gZcxsYXuCflCCOJ1zhkA
3601 E Foothill Blvd, Pasadena, CA, 9110734.15105, -118.075482026-10-142026-11-13
ubereatsFresh & Ready from Ralphs
EIdTDChBXiSSiokjSVN5FA
3601 E Foothill Blvd, Pasadena, CA, 9110734.15124, -118.075812026-10-202026-11-02
vtinfoRALPHS FRESH FARE
cb64337ecec8695e
3601 E FOOTHILL BLVD, PASADENA, CA, 91107626351880634.15124, -118.075812026-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
ca-abc RALPHS 730overture d6ee23a7-1e9b-480b-af20-dd7c3c0933331.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 140 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
doordash bloom haus by ralphs pasadenaubereats Bloom Haus by Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 32 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 12 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 12 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
ca-abc RALPHS 730doordash 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 (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:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Ralphs store at same address; Hughes Markets is Ralphs entity
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 3601 E Foothill Blvd, Pasadena 91107, about 135 m apart; the DoorDash listing is the store's own alcohol/grocery storefront on the same address, and California's rule makes that listing the store's own department, so it is one outlet selling through two listings.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at the same street address and ZIP in Pasadena, with the ABC off-sale licence matching the store and coordinates about 135 m apart; California treats the store's alcohol listing as its own department, so this is one outlet, though three businesses share the address and the DoorDash listing has no unit to confirm it.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, ZIP and city, and the names agree (RALPHS 730 and 'ralphs pasadena'), with the ABC off-sale grocery licence matching a Ralphs store; the shared building with three businesses is outweighed by the name match.
pair 3b4ea3bf18961c9df747
ab-inbev RALPHS FRESH FAREca-abc RALPHS 7300.38Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 3601 E Foothill Blvd, Pasadena 91107 with near-identical coordinates (0.159 km), and the CA licence is an off-sale general licence held by Hughes Markets, Ralphs' operator, so this is the store's own alcohol department; the 'Fresh Fare' vs '730' store-number naming difference is a store banner, not a separate business, though the shared building with three businesses adds some uncertainty.
pair 0839f8c155f8660548ca
doordash ralphs pasadenaubereats 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 at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 3601 E Foothill Blvd (0.025 km apart); Bloom Haus is Kroger's floral department brand, so the Uber Eats listing is the store's own department, the same outlet as the DoorDash Ralphs listing.
  • Claude Haiku 5.5, prompt v7: different, 60% confident — Both records sit at the same address, but the building holds three businesses and the names do not agree: 'Bloom Haus by Ralphs' reads like a separately branded concession inside the Ralphs store, not a department listing of it, and nothing marks it as the same operation's alcohol or pharmacy listing.
  • Claude Haiku 5.5, prompt v4: different, 62% confident — Both records sit at 3601 E Foothill Blvd, but the address is shared by three businesses and the names differ; 'Bloom Haus by Ralphs' reads as a separately branded concession or sub-brand inside the Ralphs store rather than the same operation as 'ralphs pasadena'.
pair 158b70654c965f5292dc
ca-abc RALPHS 730ubereats Bloom Haus by Ralphs0.33Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Ralphs 730 liquor licence at 3601 E Foothill Blvd matches the Bloom Haus by Ralphs floral department listing at the same address and ZIP; a Ralphs department brand at the store's own address is the same outlet under the California rule, and the coordinates are within about 110 m.
  • Claude Haiku 5.5, prompt v7: different, 60% confident — The Uber Eats listing is branded 'Bloom Haus by Ralphs', which reads as a separate concession or brand inside a shared building (three businesses are held at this address), not the Ralphs 730 off-sale licensee, so the names do not agree for SAME.
  • Claude Haiku 5.5, prompt v4: different, 60% confident — Both records share the street address, but the building holds three businesses in our data, so the names must agree; 'Bloom Haus by Ralphs' is a separately branded storefront rather than the licensed 'RALPHS 730' liquor store, and the Uber Eats listing does not show it is the same operation.
pair 0b5e93ed159070b48396
doordash ralphs pasadenaubereats 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 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:
  • Claude Haiku 5.5, prompt v7: same, 75% confident — Both records are Ralphs at the identical street address and ZIP, with coordinates about 35 m apart, and the Uber Eats listing is Ralphs' own 'Fresh & Ready' department, so it reads as a second listing of one store rather than a separate business; the shared-building count of 3 lowers confidence somewhat.
pair 997930fc8b5fe7afcbca
ca-abc RALPHS 730ubereats Fresh & Ready from Ralphs0.31Claude 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 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:
  • Claude Haiku 5.5, prompt v7: same, 72% confident — Both records are Ralphs at 3601 E Foothill Blvd, Pasadena 91107, with coordinates about 118 m apart; the Uber Eats 'Fresh & Ready from Ralphs' listing reads as a Ralphs department or second listing of the same store. Three businesses share the building and no suite is given, so confidence is held below certainty.
  • Claude Haiku 5.5, prompt v4: same, 75% confident — Both records give the same street address, city and ZIP, and the Uber Eats listing 'Fresh & Ready from Ralphs' is the Ralphs banner's own prepared-food department, so it reads as a second listing of the Ralphs 730 store. The building holds three businesses, which lowers confidence somewhat.
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”).
WhenEventPairRuleDecisionRule version
2026-11-13 14:10updateca-abc 00128673|21|LIC|0 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkAClaude judge: samemerged15
2026-11-13 14:10updatedoordash 35800663 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkAClaude judge: samemerged15
2026-11-12 17:29insertca-abc 00128673|21|LIC|0 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkAClaude judge: sameheld: same-source-conflict14
2026-11-12 17:29insertdoordash 35800663 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkAClaude judge: sameheld: same-source-conflict14
2026-11-12 17:29insertab-inbev 4879384 ↔ ca-abc 00128673|21|LIC|0Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 4879384 ↔ vtinfo cb64337ecec8695esame address and namemerged12
2026-11-10 17:05insertoverture d19862e6-f2f8-46ff-b7e2-dbe3dcc81853 ↔ ralphs 3601|91107same address and namemerged12
2026-11-10 17:05insertdoordash 35800663 ↔ ralphs 3601|91107same address and namemerged12
2026-11-06 18:13insertca-abc 00128673|21|LIC|0 ↔ overture d6ee23a7-1e9b-480b-af20-dd7c3c093333same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 35800663 ↔ overture d19862e6-f2f8-46ff-b7e2-dbe3dcc81853same address and namemerged11
2026-11-02 23:02backfillca-abc 00128673|21|LIC|0 ↔ ubereats EIdTDChBXiSSiokjSVN5FAClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35800663 ↔ ubereats EIdTDChBXiSSiokjSVN5FAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00128673|21|LIC|0 ↔ doordash 35800663Claude judge: samemerged
2026-10-14 18:03backfilldoordash 24199704 ↔ ubereats 34gZcxsYXuCflCCOJ1zhkAsame address and namemerged