Outlets /
Ralphs
Rancho Santa Margarita, CA 92688 · O2672a9d403c0 · 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 Fresh & Ready from Ralphs ubereats RALPHS 78 ca-abc RALPHS GROCERY COMPANY ca-abc (legal name) ralphs rancho santa margarita doordash |
| Street | 31481 Santa Margarita Pkwy 1 other | ralphs | 31481 Santa Margarita Pkw ubereats ×2 |
| City | Rancho Santa Margarita 1 other | ralphs | Rancho Santa Margari ubereats ×2 |
| State | CA | ralphs | no other value |
| ZIP | 92688 | ralphs | no other value |
| Pin | 33.65075, -117.58214 map 2 other | ralphs | 200 m away ubereats ×2 62 m away vtinfo |
| Phone | 9495890156 | ralphs | no other value |
| Licences | ca-abc 00407343|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O8e506cf56120; O6155fc4d4075; O325970169a28; Of5fcb2215446; Oacb16f2a677d; Oc08c90a38629; O84fd59d0f383; Ob3846973d23a
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 4374167 | 31481 SANTA MARGARITA PKWY, RANCHO SANTA MARGARITA, CA, 92688 | 33.65048, -117.58203 | 2026-11-11 | 2026-11-11 | |
| ca-abc | RALPHS 78 legal name: RALPHS GROCERY COMPANY 00407343|21|LIC|0 | 31481 SANTA MARGARITA PKWY, RANCHO SANTA MARGARITA, CA, 92688 | 2026-10-08 | 2026-11-06 | ||
| doordash | ralphs rancho santa margarita 35801272 | 31481 Santa Margarita Pkwy, Rancho Santa Margarita, CA, 92688 | 33.65057, -117.58224 | 2026-10-08 | 2026-11-06 | |
| overture | Ralphs 6407a568-0a5c-4cda-9c9e-85866b85faa0 | 31481 Santa Margarita Pkwy, Rancho Santa Margarita, CA, 92688 | 9495890156 | 33.65075, -117.58214 | 2026-11-06 | 2026-11-06 |
| ralphs | Ralphs 31481|92688 | 31481 Santa Margarita Pkwy, Rancho Santa Margarita, CA, 92688 | 9495890156 | 33.65075, -117.58214 | 2026-11-10 | 2026-11-10 |
| ubereats | Fresh & Ready from Ralphs 3fUlL8MUVCyDi1TsIpCKwA | 31481 Santa Margarita Pkw, Rancho Santa Margari, CA, 92688 ZIP lookup: Rancho Santa Margarita, CA | 33.65019, -117.58220 | 2026-10-09 | 2026-11-13 | |
| ubereats | Ralphs fC4aHoBMXRGa3WmnhLqpqg | 31481 Santa Margarita Pkwy, Rancho Santa Margarita, CA, 92688 | 33.65047, -117.58223 | 2026-11-02 | 2026-11-06 | |
| ubereats | Bloom Haus by Ralphs v8HTJ31yWDGM_m7mpMV0sA | 31481 Santa Margarita Pkw, Rancho Santa Margari, CA, 92688 ZIP lookup: Rancho Santa Margarita, CA | 33.64896, -117.58238 | 2026-11-09 | 2026-11-13 | |
| vtinfo | RALPHS 36cee33e382395b8 | 31481 SANTA MARGARITA PKWY, RANCHO SANTA MARGARITA, CA, 92688 | 9495890156 | 33.65019, -117.58220 | 2026-11-13 | 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 78 | overture eba57fb7-e19d-4584-8e53-7f0b5a60527c | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ab-inbev RALPHS | doordash ralphs rancho santa margarita | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 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 31 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 31 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 19 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 36 m apart · name similarity 1.00 |
| doordash ralphs rancho santa margarita | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00 |
| doordash ralphs rancho santa margarita | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00 |
| doordash ralphs rancho santa margarita | ubereats Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00 |
| doordash ralphs rancho santa margarita | vtinfo RALPHS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 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 33 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 62 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 33 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 + city + state · pins 62 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 + city + state · pins 31 m apart · name similarity 1.00 |
| ca-abc RALPHS 78 | doordash ralphs rancho santa margarita | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair) Both records are the same Ralphs chain store at the identical street address and ZIP, 31481 Santa Margarita Pkwy 92688, which no other business shares; the ABC record's active off-sale licence fits th Other Claude answers on this pair:
pair ab40533540072df75b0a |
| ca-abc RALPHS 78 | ubereats Ralphs | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair) The Ralphs chain store (#78) and the Uber Eats Ralphs listing share the same street address and ZIP, and only one business is recorded at that address. Other Claude answers on this pair:
pair c78f8dda4885b6ad420a |
| ab-inbev RALPHS | ubereats Bloom Haus by Ralphs | 0.36 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair) Bloom Haus is Ralphs floral department at same address. Other Claude answers on this pair:
pair 10d62f5f62d3a8c0d62f |
| doordash ralphs rancho santa margarita | ubereats Fresh & Ready from Ralphs | 0.33 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (82% confident; asked as a “same-address” pair) Both are Ralphs at the same street address and ZIP (43 m apart, only one business known there), and 'Fresh & Ready from Ralphs' reads as the store's own second listing on Uber Eats rather than a separ Other Claude answers on this pair:
pair 6666625cc2975ca1ddc2 |
| ca-abc RALPHS 78 | ubereats Fresh & Ready from Ralphs | 0.32 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (87% confident; asked as a “same-address” pair) Both records are the Ralphs store at 31481 Santa Margarita Pkwy, 92688, and it is the only business our data holds at that address; the Uber Eats 'Fresh & Ready from Ralphs' listing is that store's ow Other Claude answers on this pair:
pair 4ca445bc35ef6e7b8b58 |
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:15.
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"
],
[
"ubereats-type",
"off_premise",
"specialty_food"
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 54 within 1 mi · 130 within 3 mi
- Off / on premise
- 17 / 32 within 1 mi · 34 / 70 within 3 mi
- Selling alcohol
- 34 within 1 mi · 84 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.03 mi
- Setting
- suburban (1,564 people per sq mi)
- People within 3 mi
- 44,226 (33,600 adults 21+, 16,465 households) from 8 tract(s), tracts within 3 mi
- Income
- per capita $65,591 · median household ~$147,439 (weighted mean of tract medians)
- Age and education
- median age ~43.3 · bachelor's or higher 50%
- Ethnicity
- Hispanic 20% · White 63% · Black 1% · Asian 12%
- Adults per alcohol outlet
- 395
- Alcohol spend within 3 mi
- $16,500,930 a year ($7,030,238 at home, $9,465,146 away) · $194,129 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-13 14:10 | update | ca-abc 00407343|21|LIC|0 ↔ ubereats 3fUlL8MUVCyDi1TsIpCKwA | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | doordash 35801272 ↔ ubereats 3fUlL8MUVCyDi1TsIpCKwA | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | ab-inbev 4374167 ↔ ubereats v8HTJ31yWDGM_m7mpMV0sA | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 4374167 ↔ vtinfo 36cee33e382395b8 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ubereats fC4aHoBMXRGa3WmnhLqpqg ↔ vtinfo 36cee33e382395b8 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | doordash 35801272 ↔ vtinfo 36cee33e382395b8 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture 6407a568-0a5c-4cda-9c9e-85866b85faa0 ↔ vtinfo 36cee33e382395b8 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ralphs 31481|92688 ↔ vtinfo 36cee33e382395b8 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | ab-inbev 4374167 ↔ ubereats v8HTJ31yWDGM_m7mpMV0sA | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-11 12:56 | insert | ab-inbev 4374167 ↔ ubereats fC4aHoBMXRGa3WmnhLqpqg | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4374167 ↔ doordash 35801272 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4374167 ↔ overture 6407a568-0a5c-4cda-9c9e-85866b85faa0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4374167 ↔ ralphs 31481|92688 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | ralphs 31481|92688 ↔ ubereats fC4aHoBMXRGa3WmnhLqpqg | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35801272 ↔ ralphs 31481|92688 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture 6407a568-0a5c-4cda-9c9e-85866b85faa0 ↔ ralphs 31481|92688 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00407343|21|LIC|0 ↔ overture eba57fb7-e19d-4584-8e53-7f0b5a60527c | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture 6407a568-0a5c-4cda-9c9e-85866b85faa0 ↔ ubereats fC4aHoBMXRGa3WmnhLqpqg | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 35801272 ↔ overture 6407a568-0a5c-4cda-9c9e-85866b85faa0 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | doordash 35801272 ↔ ubereats fC4aHoBMXRGa3WmnhLqpqg | same address and name | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407343|21|LIC|0 ↔ ubereats 3fUlL8MUVCyDi1TsIpCKwA | Claude judge: same | held: same-source-conflict | |
| 2026-11-02 23:02 | backfill | doordash 35801272 ↔ ubereats 3fUlL8MUVCyDi1TsIpCKwA | Claude judge: same | held: same-source-conflict | |
| 2026-11-02 23:02 | backfill | ca-abc 00407343|21|LIC|0 ↔ ubereats fC4aHoBMXRGa3WmnhLqpqg | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407343|21|LIC|0 ↔ doordash 35801272 | Claude judge: same | merged |