Ralphs

CARLSBAD, CA 92009 · O5131a8ea64da · 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 3 other
the most common name a source states
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
RALPHS STORE #164 ca-abc ×2
ralphs carlsbad doordash
Street
7660 EL CAMINO REAL
ca-abcno other value
City
CARLSBAD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92009
ca-abcno other value
Pin
33.08717, -117.26737 map 2 other
ubereats
1905 m away ca-abc ×2
137 m away ab-inbev
Phone
7602300630
vtinfono other value
Licences
ca-abc 00677889|21|LIC|0 · ca-abc 00677889|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oecb3ecb6c65d; Of6a0701cc358; Oc44d0a8f6bfc; Oa59f1bfa4a12; O8b5f65f8aae3; Oda25867a67f7; O732877703e07

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
4968593
7660 EL CAMINO REAL, CARLSBAD, CA, 9200933.08731, -117.268832026-11-112026-11-11
ca-abcRALPHS STORE #164
legal name: RALPHS GROCERY COMPANY
00677889|21|LIC|0
7660 EL CAMINO REAL, CARLSBAD, CA, 9200933.10430, -117.266772026-10-082026-11-09
ca-abcRALPHS STORE #164
legal name: RALPHS GROCERY COMPANY
00677889|86|LIC|0
7660 EL CAMINO REAL, CARLSBAD, CA, 9200933.10430, -117.266772026-10-082026-11-09
doordashralphs carlsbad
46588407
7660 El Camino Real, Carlsbad, CA, 9200933.08706, -117.267202026-10-082026-11-09
overtureRalphs
cfb2b0e3-52eb-46e2-9c8e-22818d017493
7660 El Camino Real, Carlsbad, CA, 9200933.08736, -117.267042026-11-062026-11-06
ubereatsRalphs
rPQlcIz5UMOnuIH6QaWJtw
7660 El Camino Real, Carlsbad, CA, 9200933.08717, -117.267372026-10-092026-11-09
vtinfoRALPHS
6b4368f67a3a9d0e
7660 EL CAMINO REAL, CARLSBAD, CA, 92009760230063033.08707, -117.267582026-11-122026-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 carlsbad1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 154 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 167 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 137 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 120 m apart · name similarity 1.00
ca-abc RALPHS STORE #164ca-abc RALPHS STORE #1641.00one licence filemergedfile: 00677889 · same_address
ca-abc RALPHS STORE #164overture b09ae44d-0604-4825-ba17-aa898cd3cbed1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1887 m apart · name similarity 1.00
ca-abc RALPHS STORE #164overture b09ae44d-0604-4825-ba17-aa898cd3cbed1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1887 m apart · name similarity 1.00
doordash ralphs carlsbadoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00
doordash ralphs carlsbadubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
doordash ralphs carlsbadvtinfo 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 Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
overture Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00
ubereats Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00
ab-inbev RALPHSca-abc RALPHS STORE #1640.62Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Same Ralphs address, chain name matches.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records are Ralphs at the identical street address 7660 El Camino Real in Carlsbad, 92009, with the only building occupant being Ralphs; the CA ABC record's legal name RALPHS GROCERY COMPANY and store #164 banner match the chain store listing, and the off-sale licence is the store's own alcohol sales.
pair 1c0a1d712cc669e49ebb
ca-abc RALPHS STORE #164doordash ralphs carlsbad0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain store at the same street address and ZIP in Carlsbad (7660 El Camino Real, 92009), with an off-sale grocery licence and only one business known at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the identical street address 7660 El Camino Real, Carlsbad 92009, with no conflicting suite numbers and only one business at the address; the DoorDash listing is the store's own alcohol/storefront listing under the same chain, and California treats grocery alcohol as the store's own department, so this is one outlet despite the coordinate gap of about 1.9 km (which reflects geocoding, not a different business).
pair c0ff45651b86b4a2830a
ca-abc RALPHS STORE #164ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
Same chain (Ralphs) at the identical street address and ZIP in Carlsbad, with only one business recorded there and an active off-sale licence matching a supermarket.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are the Ralphs store at 7660 El Camino Real, Carlsbad, CA 92009, the only business at that address, with matching street, city and ZIP; the CA off-sale licence is the store's own alcohol department, and the coordinate gap is just geocoding noise.
pair be788bce791f928f666b
ca-abc RALPHS STORE #164doordash ralphs carlsbad0.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 in Carlsbad, no other business is recorded at that address, and the off-sale licence fits a supermarket.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Ralphs same street address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the identical street address 7660 El Camino Real, Carlsbad 92009, with no conflicting suite and only one business at the address; the California rule makes the DoorDash Ralphs listing the store's own alcohol department, so it is the same outlet.</br>
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the identical street address 7660 El Camino Real, Carlsbad, ZIP 92009, with no conflicting suite numbers and only one business at that address; the DoorDash listing is the store's own alcohol/storefront listing under the same chain, and California's rule makes the store's alcohol department part of the same premises, so this is one outlet despite the coordinate gap, which is just geocoding variance.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city and ZIP (7660 El Camino Real, Carlsbad, 92009), the ABC record is an active off-sale store licence under the Ralphs store name, and the DoorDash slug 'ralphs carlsbad' is the same chain store; only one business is held at that address, so the match is strong.
pair 12cfd8570f0791c761ed
ca-abc RALPHS STORE #164ubereats Ralphs0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
Same Ralphs chain at the identical street address and ZIP with only one business there, and the off-sale general licence fits a supermarket.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are the Ralphs chain at the identical street address 7660 El Camino Real, Carlsbad, ZIP 92009, with no conflicting suite or business at that address, and the California rule makes a chain store's alcohol sales its own department of the same store, so this is one outlet.</br>
pair 7e3c12e9d91aca963185

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:17.
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
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
30 within 1 mi · 486 within 3 mi
Off / on premise
9 / 17 within 1 mi · 125 / 256 within 3 mi
Selling alcohol
17 within 1 mi · 314 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.07 mi
Setting
urban (3,075 people per sq mi)
People within 3 mi
86,944 (64,422 adults 21+, 32,671 households) from 18 tract(s), tracts within 3 mi
Income
per capita $80,474 · median household ~$162,513 (weighted mean of tract medians)
Age and education
median age ~44.0 · bachelor's or higher 68%
Ethnicity
Hispanic 16% · White 73% · Black 1% · Asian 8%
Adults per alcohol outlet
205
Alcohol spend within 3 mi
$34,023,636 a year ($14,382,374 at home, $19,631,473 away) · $108,012 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-12 17:29insertab-inbev 4968593 ↔ ca-abc 00677889|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4968593 ↔ vtinfo 6b4368f67a3a9d0esame address and namemerged12
2026-11-12 14:25insertoverture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ vtinfo 6b4368f67a3a9d0esame address and namemerged12
2026-11-12 14:25insertdoordash 46588407 ↔ vtinfo 6b4368f67a3a9d0esame address and namemerged12
2026-11-12 14:25insertubereats rPQlcIz5UMOnuIH6QaWJtw ↔ vtinfo 6b4368f67a3a9d0esame address and namemerged12
2026-11-11 12:56insertab-inbev 4968593 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493same address and namemerged12
2026-11-11 12:56insertab-inbev 4968593 ↔ doordash 46588407same address and namemerged12
2026-11-11 12:56insertab-inbev 4968593 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwsame address and namemerged12
2026-11-09 15:32updatedoordash 46588407 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493same address and namemerged11
2026-11-09 15:32updateoverture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwsame address and namemerged11
2026-11-06 18:13insertca-abc 00677889|86|LIC|0 ↔ overture b09ae44d-0604-4825-ba17-aa898cd3cbedsame address and namemerged11
2026-11-06 18:13insertdoordash 46588407 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00677889|21|LIC|0 ↔ overture b09ae44d-0604-4825-ba17-aa898cd3cbedsame address and namemerged11
2026-11-02 23:02backfillca-abc 00677889|21|LIC|0 ↔ doordash 46588407Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00677889|21|LIC|0 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00677889|86|LIC|0 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00677889|86|LIC|0 ↔ doordash 46588407Claude judge: samemerged
2026-10-11 15:03backfilldoordash 46588407 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtwsame address and namemerged
2026-10-09 13:59backfillca-abc 00677889|21|LIC|0 ↔ ca-abc 00677889|86|LIC|0one licence filemerged