Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| City | CARLSBAD | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92009 | ca-abc | no other value |
| Pin | 33.08717, -117.26737 map 2 other | ubereats | 1905 m away ca-abc ×2 137 m away ab-inbev |
| Phone | 7602300630 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | RALPHS 4968593 | 7660 EL CAMINO REAL, CARLSBAD, CA, 92009 | 33.08731, -117.26883 | 2026-11-11 | 2026-11-11 | |
| ca-abc | RALPHS STORE #164 legal name: RALPHS GROCERY COMPANY 00677889|21|LIC|0 | 7660 EL CAMINO REAL, CARLSBAD, CA, 92009 | 33.10430, -117.26677 | 2026-10-08 | 2026-11-09 | |
| ca-abc | RALPHS STORE #164 legal name: RALPHS GROCERY COMPANY 00677889|86|LIC|0 | 7660 EL CAMINO REAL, CARLSBAD, CA, 92009 | 33.10430, -117.26677 | 2026-10-08 | 2026-11-09 | |
| doordash | ralphs carlsbad 46588407 | 7660 El Camino Real, Carlsbad, CA, 92009 | 33.08706, -117.26720 | 2026-10-08 | 2026-11-09 | |
| overture | Ralphs cfb2b0e3-52eb-46e2-9c8e-22818d017493 | 7660 El Camino Real, Carlsbad, CA, 92009 | 33.08736, -117.26704 | 2026-11-06 | 2026-11-06 | |
| ubereats | Ralphs rPQlcIz5UMOnuIH6QaWJtw | 7660 El Camino Real, Carlsbad, CA, 92009 | 33.08717, -117.26737 | 2026-10-09 | 2026-11-09 | |
| vtinfo | RALPHS 6b4368f67a3a9d0e | 7660 EL CAMINO REAL, CARLSBAD, CA, 92009 | 7602300630 | 33.08707, -117.26758 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev RALPHS | doordash ralphs carlsbad | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 154 m apart · name similarity 1.00 |
| ab-inbev RALPHS | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 167 m apart · name similarity 1.00 |
| ab-inbev RALPHS | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 137 m apart · name similarity 1.00 |
| ab-inbev RALPHS | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 120 m apart · name similarity 1.00 |
| ca-abc RALPHS STORE #164 | ca-abc RALPHS STORE #164 | 1.00 | one licence file | merged | file: 00677889 · same_address |
| ca-abc RALPHS STORE #164 | overture b09ae44d-0604-4825-ba17-aa898cd3cbed | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1887 m apart · name similarity 1.00 |
| ca-abc RALPHS STORE #164 | overture b09ae44d-0604-4825-ba17-aa898cd3cbed | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1887 m apart · name similarity 1.00 |
| doordash ralphs carlsbad | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00 |
| doordash ralphs carlsbad | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 |
| doordash ralphs carlsbad | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00 |
| overture Ralphs | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00 |
| overture Ralphs | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00 |
| ubereats Ralphs | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00 |
| ab-inbev RALPHS | ca-abc RALPHS STORE #164 | 0.62 | Claude judge: same | merged | 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:
pair 1c0a1d712cc669e49ebb |
| ca-abc RALPHS STORE #164 | doordash ralphs carlsbad | 0.62 | Claude judge: same | merged | 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:
pair c0ff45651b86b4a2830a |
| ca-abc RALPHS STORE #164 | ubereats Ralphs | 0.62 | Claude judge: same | merged | 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:
pair be788bce791f928f666b |
| ca-abc RALPHS STORE #164 | doordash ralphs carlsbad | 0.62 | Claude judge: same | merged | 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:
pair 12cfd8570f0791c761ed |
| ca-abc RALPHS STORE #164 | ubereats Ralphs | 0.62 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ab-inbev 4968593 ↔ ca-abc 00677889|21|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 4968593 ↔ vtinfo 6b4368f67a3a9d0e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ vtinfo 6b4368f67a3a9d0e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 46588407 ↔ vtinfo 6b4368f67a3a9d0e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ubereats rPQlcIz5UMOnuIH6QaWJtw ↔ vtinfo 6b4368f67a3a9d0e | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4968593 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4968593 ↔ doordash 46588407 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4968593 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | same address and name | merged | 12 |
| 2026-11-09 15:32 | update | doordash 46588407 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 | same address and name | merged | 11 |
| 2026-11-09 15:32 | update | overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00677889|86|LIC|0 ↔ overture b09ae44d-0604-4825-ba17-aa898cd3cbed | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 46588407 ↔ overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture cfb2b0e3-52eb-46e2-9c8e-22818d017493 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00677889|21|LIC|0 ↔ overture b09ae44d-0604-4825-ba17-aa898cd3cbed | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00677889|21|LIC|0 ↔ doordash 46588407 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00677889|21|LIC|0 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00677889|86|LIC|0 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00677889|86|LIC|0 ↔ doordash 46588407 | Claude judge: same | merged | |
| 2026-10-11 15:03 | backfill | doordash 46588407 ↔ ubereats rPQlcIz5UMOnuIH6QaWJtw | same address and name | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00677889|21|LIC|0 ↔ ca-abc 00677889|86|LIC|0 | one licence file | merged |