Ralphs

San Clemente, CA 92673 · O35c3381686db · 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 4 other
the most common name a source states
Fresh & Ready From Ralphs ubereats
RALPHS 15 ca-abc
RALPHS GROCERY COMPANY ca-abc (legal name)
ralphs san clemente doordash
Street
638 Camino De Los Mares 1 other
ralphs
638 CAMINO DE LOS MARES STE B ab-inbevvtinfo ×2
City
San Clemente
ralphsno other value
State
CA
ralphsno other value
ZIP
92673
ralphsno other value
Pin
33.45743, -117.65153 map 3 other
ralphs
182 m away ab-inbev
226 m away ca-abc
135 m away vtinfo
Phone
9494968616
ralphsno other value
Licences
ca-abc 00407321|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe596ad632c4c; Ob92d86a21c3f; Oa28722603a8e; O4c5ddcd87362; O48b5d5729138; O6e9f4360d52d; O485a87da99a9

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
72634
638 CAMINO DE LOS MARES STE B, SAN CLEMENTE, CA, 9267333.45825, -117.649832026-11-112026-11-11
ca-abcRALPHS 15
legal name: RALPHS GROCERY COMPANY
00407321|21|LIC|0
638 CAMINO DE LOS MARES, SAN CLEMENTE, CA, 9267333.45943, -117.651952026-10-082026-11-11
doordashralphs san clemente
35802163
638 Camino De Los Mares, San Clemente, CA, 9267333.45756, -117.651572026-10-082026-11-11
overtureRalphs
0d1ed6b7-3dc4-4ecb-890e-ea2029560554
638 Camino De Los Mares, San Clemente, CA, 92673949496861633.45743, -117.651532026-11-062026-11-11
ralphsRalphs
638|92673
638 Camino De Los Mares, San Clemente, CA, 92673949496861633.45743, -117.651532026-11-102026-11-11
ubereatsFresh & Ready From Ralphs
Lh5X4ZQeWeayuaGi0azNiQ
638 Camino De Los Mares, San Clemente, CA, 9267333.45768, -117.651492026-10-092026-11-13
ubereatsRalphs
RFjgm8oQU6el9NJ1uYT0-g
638 Camino DE Los Mares, San Clemente, CA, 9267333.45763, -117.651582026-10-142026-11-11
vtinfoRALPHS
8ad496b18569306b
638 CAMINO DE LOS MARES STE B, SAN CLEMENTE, CA, 92673949496861633.45863, -117.651332026-11-152026-11-15

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 15overture 3b24486a-5cc8-4848-a5b6-b8542b94057e1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 180 m apart · name similarity 1.00
ab-inbev RALPHSdoordash ralphs san clemente1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 179 m apart · name similarity 1.00
ab-inbev RALPHSoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 182 m apart · name similarity 1.00
ab-inbev RALPHSralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 182 m apart · name similarity 1.00
ab-inbev RALPHSubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 176 m apart · name similarity 1.00
ab-inbev RALPHSvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 145 m apart · name similarity 1.00
doordash ralphs san clementeoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
doordash ralphs san clementeralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
doordash ralphs san clementeubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash ralphs san clementevtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 121 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.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
overture Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 135 m apart · name similarity 1.00 · phone: equal
ralphs Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ralphs Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 135 m apart · name similarity 1.00 · phone: equal
ubereats Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 114 m apart · name similarity 1.00
ca-abc RALPHS 15doordash ralphs san clemente0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name the same Ralphs chain store, one as 'RALPHS 15' with an off-sale general licence and one as the DoorDash slug 'ralphs san clemente', at the identical street address and ZIP; the name
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Ralphs same address, names agree
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are the Ralphs store at 638 Camino De Los Mares, San Clemente, ZIP 92673 (legal entity RALPHS GROCERY COMPANY matches the Ralphs chain), and the DoorDash listing is the store's own alcohol/storefront listing at the same address, which California's rule treats as the store's own department, so it is the same outlet.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at the same street address and ZIP in San Clemente, with the ca-abc record's off-sale licence (a grocery store licence) matching the DoorDash listing's store; the business count of 7 at the address and the 0.21 km distance leave some doubt, but the name and address agree and California treats a chain store's alcohol listing as its own department.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records place a Ralphs grocery at 638 Camino De Los Mares, San Clemente, ZIP 92673, with the ABC off-sale licence matching the DoorDash store; the chain name agrees with or without the store number, though the building holds 7 businesses, so the name match carries the decision.
pair 43e71c66466cb061d3ca
ca-abc RALPHS 15ubereats Ralphs0.65Claude 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 identical street address and ZIP, and the licence is an off-sale general for a market; the shared building (7 businesses) is not a concern because the names ag
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are Ralphs at the same street address and ZIP, with coordinates about 0.2 km apart, and the ABC licence is the store's off-sale general licence, so the Uber Eats listing is the same store; the shared building (7 businesses) is offset by the matching chain name.
pair b7723d66aa350e612eb7
doordash ralphs san clementeubereats Fresh & Ready From Ralphs0.34Claude 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 street address (15 m apart), and 'Fresh & Ready From Ralphs' is a department listing of the same Ralphs store on Uber Eats, run by Ralphs itself rath
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 15 m apart, and 'Fresh & Ready From Ralphs' reads as the store's own prepared-food listing rather than a separately run business, though the building holds 7 businesses so the match rests mainly on the chain and address.
pair 8d6b856ca97d785e9d88
ca-abc RALPHS 15ubereats Fresh & Ready From Ralphs0.32Claude 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 street address and ZIP. 'Fresh & Ready From Ralphs' reads as a second Uber Eats listing (prepared foods) of the same Ralphs store, not a separate bus
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 70% confident — Both records are Ralphs at the identical street address and ZIP, with about 0.2 km between coordinates, and the Uber Eats listing is the chain's own 'Fresh & Ready From Ralphs' department, which counts as one operation's second listing; the shared building (7 businesses) and the lack of a suite number keep confidence below certain.
pair aea1d83b7a9c60d87d85

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:16.
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"
  ],
  [
   "ubereats-type",
   "off_premise",
   "specialty_food"
  ],
  [
   "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”).
WhenEventPairRuleDecisionRule version
2026-11-15 16:24insertab-inbev 72634 ↔ vtinfo 8ad496b18569306bsame address and namemerged15
2026-11-15 16:24insertdoordash 35802163 ↔ vtinfo 8ad496b18569306bsame address and namemerged15
2026-11-15 16:24insertoverture 0d1ed6b7-3dc4-4ecb-890e-ea2029560554 ↔ vtinfo 8ad496b18569306bsame address and namemerged15
2026-11-15 16:24insertralphs 638|92673 ↔ vtinfo 8ad496b18569306bsame address and namemerged15
2026-11-15 16:24insertubereats RFjgm8oQU6el9NJ1uYT0-g ↔ vtinfo 8ad496b18569306bsame address and namemerged15
2026-11-13 14:10updateca-abc 00407321|21|LIC|0 ↔ ubereats Lh5X4ZQeWeayuaGi0azNiQClaude judge: samemerged15
2026-11-13 14:10updatedoordash 35802163 ↔ ubereats Lh5X4ZQeWeayuaGi0azNiQClaude judge: samemerged15
2026-11-11 12:56insertab-inbev 72634 ↔ ubereats RFjgm8oQU6el9NJ1uYT0-gsame address and namemerged12
2026-11-11 12:56insertab-inbev 72634 ↔ doordash 35802163same address and namemerged12
2026-11-11 12:56insertab-inbev 72634 ↔ overture 0d1ed6b7-3dc4-4ecb-890e-ea2029560554same address and namemerged12
2026-11-11 12:56insertab-inbev 72634 ↔ ralphs 638|92673same address and namemerged12
2026-11-10 17:05insertralphs 638|92673 ↔ ubereats RFjgm8oQU6el9NJ1uYT0-gsame address and namemerged12
2026-11-10 17:05insertdoordash 35802163 ↔ ralphs 638|92673same address and namemerged12
2026-11-10 17:05insertoverture 0d1ed6b7-3dc4-4ecb-890e-ea2029560554 ↔ ralphs 638|92673same address and namemerged12
2026-11-06 18:13insertca-abc 00407321|21|LIC|0 ↔ overture 3b24486a-5cc8-4848-a5b6-b8542b94057esame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 0d1ed6b7-3dc4-4ecb-890e-ea2029560554 ↔ ubereats RFjgm8oQU6el9NJ1uYT0-gsame address and namemerged11
2026-11-06 18:13insertdoordash 35802163 ↔ overture 0d1ed6b7-3dc4-4ecb-890e-ea2029560554same address and namemerged11
2026-11-02 23:02backfillca-abc 00407321|21|LIC|0 ↔ ubereats Lh5X4ZQeWeayuaGi0azNiQClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfilldoordash 35802163 ↔ ubereats Lh5X4ZQeWeayuaGi0azNiQClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407321|21|LIC|0 ↔ ubereats RFjgm8oQU6el9NJ1uYT0-gClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407321|21|LIC|0 ↔ doordash 35802163Claude judge: samemerged
2026-10-14 18:03backfilldoordash 35802163 ↔ ubereats RFjgm8oQU6el9NJ1uYT0-gsame address and namemerged