Ralphs

Dana Point, CA 92629 · O22eb36f66a06 · 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 3 other
the most common name a source states
RALPHS 188 ca-abc
ralphs dana point doordash
RALPHS GROCERY COMPANY ca-abc (legal name)
Street
24871 Del Prado Ave 1 other
ralphs
24871 DEL PRADO ab-inbevca-abcdoordashubereatsvtinfo ×5
City
Dana Point
ralphsno other value
State
CA
ralphsno other value
ZIP
92629
ralphsno other value
Pin
33.46660, -117.69622 map 1 other
ralphs
95 m away ab-inbev
Phone
9496614145
ralphsno other value
Licences
ca-abc 00407345|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofe4da39e2255; Od97270e8696e; Obdb14bfacf3f; Oc4df12fcd592; Ob13a69c1dd6d; O79d90b5a1146

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
46526
24871 DEL PRADO, DANA POINT, CA, 9262933.46580, -117.696592026-11-112026-11-11
ca-abcRALPHS 188
legal name: RALPHS GROCERY COMPANY
00407345|21|LIC|0
24871 DEL PRADO, DANA POINT, CA, 9262933.46626, -117.696072026-10-082026-11-05
doordashralphs dana point
35802211
24871 Del Prado, Dana Point, CA, 9262933.46656, -117.696172026-10-082026-10-11
overtureRalphs
e087a9fa-aec0-44af-a0ab-b08bf11dc63e
24871 Del Prado Ave, Dana Point, CA, 92629949661414533.46660, -117.696222026-11-132026-11-13
ralphsRalphs
24871|92629
24871 Del Prado Ave, Dana Point, CA, 92629949661414533.46660, -117.696222026-11-102026-11-10
ubereatsRalphs
Y7wz4e0eV6Ogz0SdZwmT2w
24871 Del Prado, Dana Point, CA, 9262933.46655, -117.696272026-11-022026-11-02
vtinfoRALPHS
4fe7bf335610cfca
24871 DEL PRADO, DANA POINT, CA, 92629949661414533.46635, -117.695892026-11-132026-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
ab-inbev RALPHSdoordash ralphs dana point1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00
ab-inbev RALPHSoverture Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 95 m apart · name similarity 1.00 · street similarity 0.82
ab-inbev RALPHSralphs Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 95 m apart · name similarity 1.00 · street similarity 0.82
ab-inbev RALPHSubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 89 m apart · name similarity 1.00
ab-inbev RALPHSvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 90 m apart · name similarity 1.00
doordash ralphs dana pointoverture Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 7 m apart · name similarity 1.00 · street similarity 0.82
doordash ralphs dana pointralphs Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 7 m apart · name similarity 1.00 · street similarity 0.82
doordash ralphs dana pointubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
doordash ralphs dana pointvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 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.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 7 m apart · name similarity 1.00 · street similarity 0.82
overture Ralphsvtinfo RALPHS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 41 m apart · name similarity 1.00 · street similarity 0.82
ralphs Ralphsubereats Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 7 m apart · name similarity 1.00 · street similarity 0.82
ralphs Ralphsvtinfo RALPHS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 41 m apart · name similarity 1.00 · street similarity 0.82
ubereats Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 42 m apart · name similarity 1.00
ca-abc RALPHS 188doordash ralphs dana point0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
Both records are the Ralphs chain at the same street address and ZIP, 24871 Del Prado, Dana Point 92629, with one business at that address and an active off-sale general licence, so they are one store
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 Dana Point, with matching chain and city, and the coordinates lie about 34 m apart; the DoorDash listing is the store's own alcohol-selling listing, and businesses_at_address is 1 with no conflicting suite data.
pair 7d2f927ad5ad6761c7af
ca-abc RALPHS 188ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical street address and ZIP (24871 Del Prado, 92629), with an off-sale licence and only one business at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Ralphs same address
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records are the Ralphs store at 24871 Del Prado, Dana Point (ZIP 92629), with matching legal entity Ralphs Grocery Company, the single business at that address, and coordinates about 36 m apart; the Uber Eats listing is the store's own alcohol/grocery storefront on the same premises.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are Ralphs at the same street address and ZIP with coordinates about 36 m apart, the only building-level business is this one, and the ABC licence is the store's own off-sale liquor licence, so the Uber Eats listing is the same store's listing rather than a separate premises.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city and ZIP in Dana Point, and the names agree as the Ralphs chain (store number 188 on the ABC record is just a store number), with only one business at that address in the data.
pair 35b004b74d1595f365b4

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_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
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
  ]
 ]
}

Trade area

Other outlets
100 within 1 mi · 277 within 3 mi
Off / on premise
18 / 59 within 1 mi · 63 / 149 within 3 mi
Selling alcohol
80 within 1 mi · 208 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.05 mi
Setting
suburban (1,933 people per sq mi)
People within 3 mi
54,657 (44,578 adults 21+, 23,226 households) from 12 tract(s), tracts within 3 mi
Income
per capita $83,321 · median household ~$137,364 (weighted mean of tract medians)
Age and education
median age ~49.8 · bachelor's or higher 56%
Ethnicity
Hispanic 18% · White 74% · Black 2% · Asian 5%
Adults per alcohol outlet
213
Alcohol spend within 3 mi
$22,206,462 a year ($9,524,172 at home, $12,674,761 away) · $106,251 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:10insertralphs 24871|92629 ↔ vtinfo 4fe7bf335610cfcastreet written two waysmerged15
2026-11-13 14:10insertoverture e087a9fa-aec0-44af-a0ab-b08bf11dc63e ↔ vtinfo 4fe7bf335610cfcastreet written two waysmerged15
2026-11-13 14:10insertab-inbev 46526 ↔ overture e087a9fa-aec0-44af-a0ab-b08bf11dc63estreet written two waysmerged15
2026-11-13 14:10insertoverture e087a9fa-aec0-44af-a0ab-b08bf11dc63e ↔ ubereats Y7wz4e0eV6Ogz0SdZwmT2wstreet written two waysmerged15
2026-11-13 14:10insertdoordash 35802211 ↔ overture e087a9fa-aec0-44af-a0ab-b08bf11dc63estreet written two waysmerged15
2026-11-13 14:10insertab-inbev 46526 ↔ vtinfo 4fe7bf335610cfcasame address and namemerged15
2026-11-13 14:10insertubereats Y7wz4e0eV6Ogz0SdZwmT2w ↔ vtinfo 4fe7bf335610cfcasame address and namemerged15
2026-11-13 14:10insertdoordash 35802211 ↔ vtinfo 4fe7bf335610cfcasame address and namemerged15
2026-11-13 14:10insertoverture e087a9fa-aec0-44af-a0ab-b08bf11dc63e ↔ ralphs 24871|92629same address and namemerged15
2026-11-11 12:56insertab-inbev 46526 ↔ ralphs 24871|92629street written two waysmerged12
2026-11-11 12:56insertab-inbev 46526 ↔ ubereats Y7wz4e0eV6Ogz0SdZwmT2wsame address and namemerged12
2026-11-11 12:56insertab-inbev 46526 ↔ doordash 35802211same address and namemerged12
2026-11-10 17:05insertralphs 24871|92629 ↔ ubereats Y7wz4e0eV6Ogz0SdZwmT2wstreet written two waysmerged12
2026-11-10 17:05insertdoordash 35802211 ↔ ralphs 24871|92629street written two waysmerged12
2026-11-03 13:33backfilldoordash 35802211 ↔ ubereats Y7wz4e0eV6Ogz0SdZwmT2wsame address and namemerged
2026-11-02 23:02backfillca-abc 00407345|21|LIC|0 ↔ doordash 35802211Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407345|21|LIC|0 ↔ ubereats Y7wz4e0eV6Ogz0SdZwmT2wClaude judge: samemerged