Ralphs

SAN CLEMENTE, CA 92673 · O361f8263cca1 · first seen 2026-10-08
7 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 4 other
the most common name a source states
RALPHS 287 ca-abc ×2
RALPHS FRESH FARE ab-inbevvtinfo ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
ralphs san clemente doordash
Street
811 Avenida Talega
ralphsno other value
City
San Clemente
ralphsno other value
State
CA
ralphsno other value
ZIP
92673
ralphsno other value
Pin
33.46222, -117.59827 map 1 other
ralphs
157 m away ab-inbev
Phone
9494921648
ralphsno other value
Licences
ca-abc 00447745|21|LIC|0 · ca-abc 00447745|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O683fda6ca17f; Of268989eb7a9; O827ed3adf5d2; O5ccb8e0120af; Oe832557b2f6d; O644fc2cdfdea; O7a787e0ffc57

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
2908005
811 AVENIDA TALEGA, SAN CLEMENTE, CA, 9267333.46359, -117.597872026-11-112026-11-12
ca-abcRALPHS 287
legal name: RALPHS GROCERY COMPANY
00447745|21|LIC|0
811 AVENIDA TALEGA, SAN CLEMENTE, CA, 926732026-10-082026-11-06
ca-abcRALPHS 287
legal name: RALPHS GROCERY COMPANY
00447745|86|LIC|0
811 AVENIDA TALEGA, SAN CLEMENTE, CA, 926732026-10-082026-11-06
doordashralphs san clemente
35800681
811 Avenida Talega, San Clemente, CA, 9267333.46233, -117.598182026-10-082026-11-06
overtureRalphs
69cfcccf-f1b5-48af-8491-93981fe3785d
811 Avenida Talega, San Clemente, CA, 92673949492164833.46222, -117.598272026-11-062026-11-06
ralphsRalphs
811|92673
811 Avenida Talega, San Clemente, CA, 92673949492164833.46222, -117.598272026-11-102026-11-10
ubereatsRalphs
_XTiWhWBXPe6RFfcU-Y7tg
811 Avenida Talega, San Clemente, CA, 9267333.46244, -117.598022026-10-272026-11-06
vtinfoRALPHS FRESH FARE
cb323ec37909f0d2
811 AVENIDA TALEGA, SAN CLEMENTE, CA, 92673949492164833.46223, -117.598082026-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 287overture 384e8b24-9ff7-4d40-8fb8-0b2b8e14a9a31.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc RALPHS 287overture 384e8b24-9ff7-4d40-8fb8-0b2b8e14a9a31.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · 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 + ZIP · pins 152 m apart · name similarity 1.00
ca-abc RALPHS 287ca-abc RALPHS 2871.00one licence filemergedfile: 00447745 · same_address
doordash ralphs san clementeoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 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 16 m apart · name similarity 1.00
doordash ralphs san clementeubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 19 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 34 m apart · name similarity 1.00
ralphs Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ca-abc RALPHS 287doordash ralphs san clemente0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (94% confident; asked as a “near” pair)
Both are the Ralphs supermarket at 811 Avenida Talega, San Clemente 92673, with the same chain name and an off-sale store licence; the second business counted at that address does not change this, bec
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at 811 Avenida Talega, San Clemente, ZIP 92673; the ABC record is the store's off-sale licence (Type 21) and the DoorDash listing is the same store's storefront, with no suite conflict and the chain matching, though businesses_at_address is 2 so the shared building lowers confidence slightly.
pair bd1f29d50640a590134d
ca-abc RALPHS 287ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical street address and ZIP, and the CA off-sale general licence fits a supermarket; the store number is the only difference.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are Ralphs at the same street address and ZIP in San Clemente; the ABC record is a Ralphs store (287) with an off-sale liquor licence and the Uber Eats listing is the same chain store, and California treats the store's alcohol sales as its own department, so they are one outlet despite the shared building count of 2 and no suite on either side.
pair e5c2f5e48fa7eadf418b
ca-abc RALPHS 287doordash ralphs san clemente0.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 identical street address 811 Avenida Talega, San Clemente 92673, and the off-sale licence fits a supermarket, so this is one store under two listings despite a
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Ralphs at identical address
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records are at 811 Avenida Talega, San Clemente 92673 and both belong to the Ralphs chain; the DoorDash 'ralphs san clemente' listing is the store's own alcohol/store department under the same banner, and California's rule treats it as the store's own department.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are Ralphs at 811 Avenida Talega, San Clemente, ZIP 92673, and the ABC licence is a Type 21 off-sale store licence at that address, matching the DoorDash Ralphs listing as its alcohol-capable storefront; the unit field is one-side and no differing suite is named, and businesses_at_address is 2 but the other business is not a differently named competitor evidenced here, so the Ralphs name and exact street match support SAME.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records are the Ralphs store at 811 Avenida Talega, San Clemente 92673; the ABC record 'RALPHS 287' and the DoorDash slug 'ralphs san clemente' agree on the chain name, and the store number is the only difference, which the rules treat as the same outlet even though the building holds two businesses.
pair 4245d51036401dbd62fd
ca-abc RALPHS 287ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain at the same street address and ZIP (811 Avenida Talega, 92673), and the CA off-sale general licence fits the grocery store, so the names agree despite the shared buil
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are the Ralphs store at 811 Avenida Talega, San Clemente, ZIP 92673, and the ABC licence is a Type 21 off-sale general held by the Ralphs 287 premises, matching the Uber Eats Ralphs listing; the shared-building count of 2 is offset by the matching chain name and identical street address with no differing suite numbers, and California's rule makes the store's alcohol listing its own department.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records are Ralphs at the identical street address, city and ZIP, and the ABC record's 'RALPHS 287' is the chain's store-numbered name for the same off-sale market; the other business at the address does not contradict this since the names agree.
pair 64fc4558798234ce6981
ab-inbev RALPHS FRESH FAREca-abc RALPHS 2870.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Same Ralphs store at identical address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the identical address 811 Avenida Talega, San Clemente, ZIP 92673; the ca-abc record is the store's own off-sale licence (legal entity Ralphs Grocery Company) and the ab-inbev listing 'Ralphs Fresh Fare' is the same store's department, with the coordinates within a few hundred metres of each other and no conflicting suite numbers.
pair 1b43aa5310fe78bae00a

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_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
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"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
47 within 1 mi · 262 within 3 mi
Off / on premise
16 / 17 within 1 mi · 55 / 130 within 3 mi
Selling alcohol
36 within 1 mi · 170 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.09 mi
Setting
suburban (1,749 people per sq mi)
People within 3 mi
49,456 (36,719 adults 21+, 17,792 households) from 10 tract(s), tracts within 3 mi
Income
per capita $76,787 · median household ~$159,197 (weighted mean of tract medians)
Age and education
median age ~45.4 · bachelor's or higher 54%
Ethnicity
Hispanic 18% · White 75% · Black 1% · Asian 5%
Adults per alcohol outlet
215
Alcohol spend within 3 mi
$18,012,417 a year ($7,639,564 at home, $10,367,518 away) · $105,336 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-15 16:24insertab-inbev 2908005 ↔ vtinfo cb323ec37909f0d2same address and namemerged15
2026-11-12 17:29insertab-inbev 2908005 ↔ ca-abc 00447745|21|LIC|0Claude judge: samemerged14
2026-11-10 17:05insertralphs 811|92673 ↔ ubereats _XTiWhWBXPe6RFfcU-Y7tgsame address and namemerged12
2026-11-10 17:05insertdoordash 35800681 ↔ ralphs 811|92673same address and namemerged12
2026-11-10 17:05insertoverture 69cfcccf-f1b5-48af-8491-93981fe3785d ↔ ralphs 811|92673same address and namemerged12
2026-11-06 18:13insertca-abc 00447745|21|LIC|0 ↔ overture 384e8b24-9ff7-4d40-8fb8-0b2b8e14a9a3same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00447745|86|LIC|0 ↔ overture 384e8b24-9ff7-4d40-8fb8-0b2b8e14a9a3same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 69cfcccf-f1b5-48af-8491-93981fe3785d ↔ ubereats _XTiWhWBXPe6RFfcU-Y7tgsame address and namemerged11
2026-11-06 18:13insertdoordash 35800681 ↔ overture 69cfcccf-f1b5-48af-8491-93981fe3785dsame address and namemerged11
2026-11-02 23:02backfillca-abc 00447745|21|LIC|0 ↔ ubereats _XTiWhWBXPe6RFfcU-Y7tgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00447745|21|LIC|0 ↔ doordash 35800681Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00447745|86|LIC|0 ↔ ubereats _XTiWhWBXPe6RFfcU-Y7tgClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00447745|86|LIC|0 ↔ doordash 35800681Claude judge: samemerged
2026-10-27 01:03backfilldoordash 35800681 ↔ ubereats _XTiWhWBXPe6RFfcU-Y7tgsame address and namemerged
2026-10-09 13:59backfillca-abc 00447745|21|LIC|0 ↔ ca-abc 00447745|86|LIC|0one licence filemerged