RALPHS 681

Bermuda Dunes, CA 92203 · O05a1d2f09ca1 · first seen 2026-10-08
6 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 681 5 other
the most common name a source states
RALPHS FRESH FARE ab-inbevvtinfo ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Ralphs ubereats
RALPHS #681 overture
ralphs bermuda dunes doordash
Street
42150 WASHINGTON ST
ca-abcno other value
City
BERMUDA DUNES 1 other
ca-abc
INDIO ab-inbevvtinfo ×2
State
CA
ca-abcno other value
ZIP
92203 1 other
ca-abc
92201 ubereats
Pin
33.74211, -116.30245 map 2 other
ubereats
124 m away ca-abc ×2
116 m away ab-inbev
Phone
7602000272
vtinfono other value
Licences
ca-abc 00407443|21|LIC|0 · ca-abc 00407443|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe7078db5cfef; Of1296ea3e62a; Oe3babd1c3077; O6e8da6f313cb; O4ef631fb68b9; Oe9bd40d5b517

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
2901434
42150 WASHINGTON ST, INDIO, CA, 9220333.74204, -116.303712026-11-112026-11-12
ca-abcRALPHS 681
legal name: RALPHS GROCERY COMPANY
00407443|21|LIC|0
42150 WASHINGTON ST, BERMUDA DUNES, CA, 9220333.74221, -116.303792026-10-082026-11-06
ca-abcRALPHS 681
legal name: RALPHS GROCERY COMPANY
00407443|86|LIC|0
42150 WASHINGTON ST, BERMUDA DUNES, CA, 9220333.74221, -116.303792026-10-082026-11-06
doordashralphs bermuda dunes
35800931
42150 Washington St, Bermuda Dunes, CA, 9220333.74203, -116.302292026-10-082026-11-06
overtureRALPHS #681
540be608-5b95-4ed5-ae37-70056359533b
42150 Washington St, Bermuda Dunes, CA, 9220333.74196, -116.302532026-11-062026-11-06
ubereatsRalphs
C2hUMXhrWGGb1CS9ddZPGA
42150 Washington St, Bermuda Dunes, CA, 92201
ZIP lookup: Indio, CA
33.74211, -116.302452026-10-282026-11-06
vtinfoRALPHS FRESH FARE
005dfa30d8c44633
42150 WASHINGTON ST, INDIO, CA, 92203760200027233.74208, -116.302582026-11-142026-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 bermuda dunesubereats Fresh & Ready from Ralphs0.33Claude judge: sameheld same-source-conflict
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 street address, 28 m apart, and 'Fresh & Ready from Ralphs' reads as an Uber Eats listing of that same store rather than a separately run business.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 75% confident — Both records are Ralphs at the identical street address with coordinates about 28 m apart, and the Uber Eats listing 'Fresh & Ready from Ralphs' is the chain's own prepared-food listing for that store rather than a separately run concession, so it reads as a second listing of one operation.
pair 9838160e9d166b9eceb0
ca-abc RALPHS 681ubereats Fresh & Ready from Ralphs0.31Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both are Ralphs at the identical street address and ZIP; 'Fresh & Ready from Ralphs' is a delivery-app listing of the same Ralphs store, which holds the off-sale licence there, and there is no sign of
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 72% confident — Both records are Ralphs at the same street address and ZIP, with coordinates 0.11 km apart and no conflicting suite numbers. 'Fresh & Ready from Ralphs' reads as the store's own Uber Eats listing rather than a separate operator, though the shared building with three businesses keeps this from being certain.
pair fe86ce6166596ff41615
ca-abc RALPHS 681ubereats Fresh & Ready from Ralphs0.31Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records name a Ralphs at the identical address, 42150 Washington St, Bermuda Dunes 92203; 'Fresh & Ready from Ralphs' is a delivery-app listing of that one store, not a separately licensed operat
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 74% confident — Both records are Ralphs at the same street address and ZIP, 0.11 km apart, and the Uber Eats listing 'Fresh & Ready from Ralphs' reads as the store's own food-counter listing, so this is most likely one store; the shared building (3 businesses) and the Fresh & Ready concession question keep confidence moderate.
pair a7fab2ab0700754a7ca0
ab-inbev RALPHS FRESH FAREvtinfo RALPHS FRESH FARE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00
ca-abc RALPHS 681ca-abc RALPHS 6811.00one licence filemergedfile: 00407443 · same_address
ca-abc RALPHS 681overture RALPHS #6811.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 120 m apart · name similarity 1.00
ca-abc RALPHS 681overture RALPHS #6811.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 120 m apart · name similarity 1.00
doordash ralphs bermuda dunesubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
ca-abc RALPHS 681doordash ralphs bermuda dunes0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (94% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical street address and ZIP in Bermuda Dunes, and A's off-sale general licence fits the supermarket that B's DoorDash slug names, so the shared building d
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 in Bermuda Dunes, with coordinates 0.14 km apart; the DoorDash listing is the store's own storefront and the ABC record's off-sale general licence is the same store's alcohol sales, so they are one outlet even though three businesses are listed at this address.
pair eb0cd48dc85ea49037c3
ca-abc RALPHS 681doordash ralphs bermuda dunes0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (94% confident; asked as a “near” pair)
Both records are the Ralphs store at 42150 Washington St, Bermuda Dunes 92203, and the off-sale general licence matches a supermarket, so the names agree despite the shared building.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs store same address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 42150 Washington St, Bermuda Dunes, CA 92203, with near-identical coordinates (0.14 km); the CA ABC record is the store's off-sale licence and the DoorDash listing is the store's own storefront, so this is one outlet rather than a separate concession, though three businesses at the address makes the match slightly less certain.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at 42150 Washington St, Bermuda Dunes 92203, with matching chain, street, city and ZIP, and coordinates about 0.14 km apart; the DoorDash listing reads as the store's own alcohol department, and the CA ABC off-sale licence sits at that same premises, so this is one outlet despite the three businesses at the address.
  • Claude Haiku 5.5, prompt v4: same, 86% confident — Both records place Ralphs at 42150 Washington St, Bermuda Dunes, ZIP 92203, with the ABC off-sale licence matching a supermarket storefront; 'RALPHS 681' and 'ralphs bermuda dunes' are the same chain store under different spellings, and the shared building is resolved by the matching Ralphs name.
pair 343f5e0f8c62f6b7da97
ab-inbev RALPHS FRESH FAREca-abc RALPHS 6810.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Ralphs at same address, same ZIP.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at the same street address and ZIP 92203 with nearly identical coordinates (21 m apart), the ab-inbev 'Ralphs Fresh Fare' listing is the store's own banner, and the CA ABC off-sale licence is the store's liquor licence; the city difference (Indio vs Bermuda Dunes) is a mailing/postal-area variation for the same ZIP, though the businesses-at-address count of 3 gives some doubt.
pair 1bb178a63985202399df

Attributes

Channel
off_premise · grocery — ca-licence
Chain
Ralphs — ubereats-parent
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
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 289 within 3 mi
Off / on premise
10 / 18 within 1 mi · 79 / 172 within 3 mi
Selling alcohol
17 within 1 mi · 185 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
suburban (1,589 people per sq mi)
People within 3 mi
44,914 (36,506 adults 21+, 19,744 households) from 12 tract(s), tracts within 3 mi
Income
per capita $60,376 · median household ~$93,619 (weighted mean of tract medians)
Age and education
median age ~51.2 · bachelor's or higher 42%
Ethnicity
Hispanic 28% · White 66% · Black 1% · Asian 5%
Adults per alcohol outlet
196
Alcohol spend within 3 mi
$14,495,324 a year ($6,551,065 at home, $7,938,944 away) · $77,932 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

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-14 20:23insertab-inbev 2901434 ↔ vtinfo 005dfa30d8c44633same address and namemerged15
2026-11-12 17:29insertab-inbev 2901434 ↔ ca-abc 00407443|21|LIC|0Claude judge: samemerged14
2026-11-06 18:13insertca-abc 00407443|21|LIC|0 ↔ overture 540be608-5b95-4ed5-ae37-70056359533bsame address and namemerged11
2026-11-06 18:13insertca-abc 00407443|86|LIC|0 ↔ overture 540be608-5b95-4ed5-ae37-70056359533bsame address and namemerged11
2026-11-02 23:02backfillca-abc 00407443|21|LIC|0 ↔ ubereats WZpAubWBWAy2s52un1VTUwClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407443|86|LIC|0 ↔ ubereats WZpAubWBWAy2s52un1VTUwClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfilldoordash 35800931 ↔ ubereats WZpAubWBWAy2s52un1VTUwClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407443|21|LIC|0 ↔ doordash 35800931Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407443|86|LIC|0 ↔ doordash 35800931Claude judge: samemerged
2026-10-28 02:02backfilldoordash 35800931 ↔ ubereats C2hUMXhrWGGb1CS9ddZPGAsame address and namemerged
2026-10-09 13:59backfillca-abc 00407443|21|LIC|0 ↔ ca-abc 00407443|86|LIC|0one licence filemerged