Outlets /
Ralphs
Escondido, CA 92027 · O026de7def756 · 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Ralphs 5 other | the most common name a source states | Bloom Haus by Ralphs ubereats bloom haus by ralphs escondido doordash RALPHS 90 ca-abc ralphs escondido doordash RALPHS GROCERY COMPANY ca-abc (legal name) |
| Street | 2417 E Valley Pkwy 1 other | ralphs | 2417 East Valley Parkway doordash |
| City | Escondido | ralphs | no other value |
| State | CA | ralphs | no other value |
| ZIP | 92027 | ralphs | no other value |
| Pin | 33.14046, -117.04282 map 2 other | ralphs | 69 m away ab-inbev 115 m away ca-abc |
| Phone | 7607400334 | ralphs | no other value |
| Licences | ca-abc 00407423|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oecffaee815ae; O2ce008eadd71; O3f30a351f4cf; O22e5757edcf2; O34a6322cb8d4; O701381a0d47d; Oac10492e7260; O9ddcb4604c2c
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 72501 | 2417 E VALLEY PKWY, ESCONDIDO, CA, 92027 | 33.14088, -117.04227 | 2026-11-11 | 2026-11-11 | |
| ca-abc | RALPHS 90 legal name: RALPHS GROCERY COMPANY 00407423|21|LIC|0 | 2417 E VALLEY PKWY, ESCONDIDO, CA, 92027 | 33.14146, -117.04310 | 2026-10-08 | 2026-11-05 | |
| doordash | bloom haus by ralphs escondido 24194892 | 2417 East Valley Parkway, Escondido, CA, 92027 | 33.14051, -117.04293 | 2026-10-08 | 2026-11-13 | |
| doordash | ralphs escondido 35802541 | 2417 E Valley Pkwy, Escondido, CA, 92027 | 33.14047, -117.04283 | 2026-10-08 | 2026-11-03 | |
| overture | Ralphs e267c27b-e213-46c0-958d-60564784d1ba | 2417 E Valley Pkwy, Escondido, CA, 92027 | 7607400334 | 33.14046, -117.04282 | 2026-11-06 | 2026-11-06 |
| ralphs | Ralphs 2417|92027 | 2417 E Valley Pkwy, Escondido, CA, 92027 | 7607400334 | 33.14046, -117.04282 | 2026-11-10 | 2026-11-10 |
| ubereats | Ralphs b7VYkQ4xVOKo3M6Aw1GYUQ | 2417 E Valley Pkwy, Escondido, CA, 92027 | 33.14059, -117.04280 | 2026-11-02 | 2026-11-03 | |
| ubereats | Bloom Haus by Ralphs IvJZZNFPUimgx0e0AXSBuA | 2417 E Valley Pkwy, Escondido, CA, 92027 | 33.14051, -117.04298 | 2026-10-21 | 2026-11-13 | |
| vtinfo | RALPHS cdf6d99933d63a95 | 2417 E VALLEY PKWY, ESCONDIDO, CA, 92027 | 7607400334 | 33.14068, -117.04290 | 2026-11-14 | 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 |
|---|---|---|---|---|---|
| ca-abc RALPHS 90 | overture 55d051de-7882-4a30-9a44-1a32c5d2d1b2 | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 125 m apart · name similarity 1.00 |
| ab-inbev RALPHS | doordash ralphs escondido | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 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 69 m apart · name similarity 1.00 |
| ab-inbev RALPHS | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 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 59 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 + ZIP · pins 63 m apart · name similarity 1.00 |
| doordash bloom haus by ralphs escondido | ubereats Bloom Haus by Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 |
| doordash ralphs escondido | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00 |
| doordash ralphs escondido | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00 |
| doordash ralphs escondido | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00 |
| doordash ralphs escondido | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00 |
| overture Ralphs | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal |
| overture Ralphs | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 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 + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal |
| ralphs Ralphs | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ralphs Ralphs | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal |
| ubereats Ralphs | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00 |
| ca-abc RALPHS 90 | doordash ralphs escondido | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) Both records are the Ralphs chain store at the identical street address 2417 E Valley Pkwy, Escondido 92027, and the DoorDash slug 'ralphs escondido' matches the licensed off-sale Ralphs #90, so the n Other Claude answers on this pair:
pair ef418c4f65f7a2f47b5d |
| ca-abc RALPHS 90 | ubereats Ralphs | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) Both records name the Ralphs chain at the identical street address and ZIP in Escondido, and A's off-sale general licence matches a supermarket, so this is one store with its store number in one recor Other Claude answers on this pair:
pair 2ada7d4539f8f8dd3792 |
| ca-abc RALPHS 90 | doordash bloom haus by ralphs escondido | 0.36 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair) Ralphs store and its Bloom Haus floral department Other Claude answers on this pair:
pair 2e66aab5b0b0f50c7526 |
| ab-inbev RALPHS | doordash bloom haus by ralphs escondido | 0.36 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair) Bloom Haus department at same Ralphs address Other Claude answers on this pair:
pair 4a5267f92a85981c6e46 |
| doordash bloom haus by ralphs escondido | ubereats Ralphs | 0.36 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair) Bloom Haus floral department of Ralphs at same address Other Claude answers on this pair:
pair 0a0292c916e4060e6732 |
Attributes
- Channel
- off_premise · grocery — ca-licence conflicting evidence
- 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:14.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"chain-locator",
"off_premise",
"grocery"
],
[
"ubereats-type",
"non_beverage",
"florist"
],
[
"ubereats-type",
"off_premise",
"grocery"
],
[
"doordash-url",
"off_premise",
null
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 26 within 1 mi · 232 within 3 mi
- Off / on premise
- 10 / 12 within 1 mi · 80 / 121 within 3 mi
- Selling alcohol
- 19 within 1 mi · 172 within 3 mi
- Nearest
- same channel 0.04 mi · licensed 0.04 mi
- Setting
- urban (3,320 people per sq mi)
- People within 3 mi
- 93,878 (67,188 adults 21+, 29,744 households) from 19 tract(s), tracts within 3 mi
- Income
- per capita $34,401 · median household ~$86,518 (weighted mean of tract medians)
- Age and education
- median age ~35.2 · bachelor's or higher 24%
- Ethnicity
- Hispanic 61% · White 34% · Black 2% · Asian 6%
- Adults per alcohol outlet
- 388
- Alcohol spend within 3 mi
- $20,375,384 a year ($9,279,529 at home, $11,086,589 away) · $117,777 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-14 20:23 | insert | overture e267c27b-e213-46c0-958d-60564784d1ba ↔ vtinfo cdf6d99933d63a95 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ab-inbev 72501 ↔ vtinfo cdf6d99933d63a95 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ubereats b7VYkQ4xVOKo3M6Aw1GYUQ ↔ vtinfo cdf6d99933d63a95 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | doordash 35802541 ↔ vtinfo cdf6d99933d63a95 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ralphs 2417|92027 ↔ vtinfo cdf6d99933d63a95 | same address and name | merged | 15 |
| 2026-11-13 14:10 | update | ab-inbev 72501 ↔ doordash 24194892 | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | doordash 24194892 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | ca-abc 00407423|21|LIC|0 ↔ doordash 24194892 | Claude judge: same | merged | 15 |
| 2026-11-12 17:29 | insert | ab-inbev 72501 ↔ doordash 24194892 | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 17:29 | insert | doordash 24194892 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 17:29 | insert | ca-abc 00407423|21|LIC|0 ↔ doordash 24194892 | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-11 12:56 | insert | ab-inbev 72501 ↔ overture e267c27b-e213-46c0-958d-60564784d1ba | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 72501 ↔ ralphs 2417|92027 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 72501 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 72501 ↔ doordash 35802541 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture e267c27b-e213-46c0-958d-60564784d1ba ↔ ralphs 2417|92027 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | ralphs 2417|92027 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35802541 ↔ ralphs 2417|92027 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00407423|21|LIC|0 ↔ overture 55d051de-7882-4a30-9a44-1a32c5d2d1b2 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture e267c27b-e213-46c0-958d-60564784d1ba ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 35802541 ↔ overture e267c27b-e213-46c0-958d-60564784d1ba | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | doordash 35802541 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | same address and name | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407423|21|LIC|0 ↔ doordash 35802541 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407423|21|LIC|0 ↔ ubereats b7VYkQ4xVOKo3M6Aw1GYUQ | Claude judge: same | merged | |
| 2026-10-21 22:03 | backfill | doordash 24194892 ↔ ubereats IvJZZNFPUimgx0e0AXSBuA | same address and name | merged |