Outlets /
Ralphs
Mission Viejo, CA 92691 · O2966f5fa51aa · 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 7 other | the most common name a source states | RALPHS FRESH FARE ab-inbevvtinfo ×2 Bloom Haus by Ralphs ubereats bloom haus by ralphs mission viejo doordash Fresh & Ready from Ralphs ubereats RALPHS 117 ca-abc RALPHS GROCERY COMPANY ca-abc (legal name) ralphs mission viejo doordash |
| Street | 27730 Santa Margarita Pkwy 1 other | ralphs | 27730 Santa Margarita Pkw ubereats ×2 |
| City | Mission Viejo | ralphs | no other value |
| State | CA | ralphs | no other value |
| ZIP | 92691 | ralphs | no other value |
| Pin | 33.65162, -117.64680 map 2 other | ralphs | 138 m away ab-inbev 127 m away ca-abc |
| Phone | 9498370380 | ralphs | no other value |
| Licences | ca-abc 00407340|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oa00f1e44cab1; Oa23041dc48fe; Oe97d4b3d9bef; Ob93eb60049f4; Ofe03ded02f70; O7c8932486977; Oed7f611341c3; Oebaab04c4759
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 FRESH FARE 4879246 | 27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 92691 | 33.65285, -117.64663 | 2026-11-11 | 2026-11-16 | |
| ca-abc | RALPHS 117 legal name: RALPHS GROCERY COMPANY 00407340|21|LIC|0 | 27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 92691 | 33.65272, -117.64645 | 2026-10-08 | 2026-11-05 | |
| doordash | bloom haus by ralphs mission viejo 24199485 | 27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691 | 33.65158, -117.64677 | 2026-10-08 | 2026-11-13 | |
| doordash | ralphs mission viejo 35802314 | 27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691 | 33.65160, -117.64670 | 2026-10-08 | 2026-10-11 | |
| overture | Ralphs 78a0f077-4586-4eb9-9971-c65401e228d3 | 27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691 | 9498370380 | 33.65162, -117.64680 | 2026-11-06 | 2026-11-06 |
| ralphs | Ralphs 27730|92691 | 27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691 | 9498370380 | 33.65162, -117.64680 | 2026-11-10 | 2026-11-10 |
| ubereats | Bloom Haus by Ralphs f-FnGTQpXm2rzXJuSHj0Tw | 27730 Santa Margarita Pkw, Mission Viejo, CA, 92691 | 33.65174, -117.64670 | 2026-11-14 | 2026-11-14 | |
| ubereats | Fresh & Ready from Ralphs QVMyW-OWVgeT8GAwPTT7wQ | 27730 Santa Margarita Pkw, Mission Viejo, CA, 92691 | 33.65166, -117.64662 | 2026-10-15 | 2026-11-02 | |
| vtinfo | RALPHS FRESH FARE d9ca3a5617ab5a99 | 27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 92691 | 9498370380 | 33.65166, -117.64662 | 2026-11-12 | 2026-11-16 |
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 117 | overture 260a64fc-7d8a-4fe9-97dc-370edd924e5c | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 139 m apart · name similarity 1.00 |
| ab-inbev RALPHS FRESH FARE | vtinfo RALPHS FRESH FARE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 132 m apart · name similarity 1.00 |
| doordash bloom haus by ralphs mission viejo | ubereats Bloom Haus by Ralphs | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 18 m apart · name similarity 1.00 · street similarity 0.97 |
| doordash ralphs mission viejo | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 |
| doordash ralphs mission viejo | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 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 |
| ca-abc RALPHS 117 | doordash ralphs mission viejo | 0.62 | 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 at the identical street address and ZIP in Mission Viejo, and the names agree, so the shared building does not split them. Other Claude answers on this pair:
pair cc610310ab8e87a32023 |
| ab-inbev RALPHS FRESH FARE | ca-abc RALPHS 117 | 0.45 | one name contains the other, same address | merged | judge: None · pair_id: bbc1218d3ba1bb9d2dfd · person: None · rule: names contained at one address · stratum: same-address |
| ca-abc RALPHS 117 | vtinfo RALPHS FRESH FARE | 0.45 | one name contains the other, same address | merged | judge: None · pair_id: 9e5f8674456d3c0c6651 · person: None · rule: names contained at one address · stratum: same-address |
| ab-inbev RALPHS FRESH FARE | doordash ralphs mission viejo | 0.43 | one name contains the other, same address | merged | judge: None · pair_id: 9ff0cf6b9ed9ec4bdff6 · person: None · rule: names contained at one address · stratum: same-address |
| doordash ralphs mission viejo | vtinfo RALPHS FRESH FARE | 0.43 | one name contains the other, same address | merged | judge: None · pair_id: 9115f83fcbe6f531cec8 · person: None · rule: names contained at one address · stratum: same-address |
| doordash ralphs mission viejo | ubereats Fresh & Ready from Ralphs | 0.34 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records are Ralphs at the same street address, 10 m apart, and 'Fresh & Ready from Ralphs' is the store's own prepared-food listing on Uber Eats rather than a separate business. Other Claude answers on this pair:
pair 6bd11c9abfbe9bd7b654 |
| ca-abc RALPHS 117 | ubereats Fresh & Ready from Ralphs | 0.31 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records place a Ralphs at the same street address and ZIP, and 'Fresh & Ready from Ralphs' is the Uber Eats storefront of that Ralphs store, not a separate operation. Other Claude answers on this pair:
pair be810dc9c007d38489a8 |
| doordash bloom haus by ralphs mission viejo | ubereats Fresh & Ready from Ralphs | 0.28 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (85% confident; asked as a “same-address” pair) Both are department listings (Bloom Haus floral and Fresh & Ready prepared food) of the same Ralphs store at 27730 Santa Margarita Pkwy, Mission Viejo, and the coordinates are 16 m apart, so they are Other Claude answers on this pair:
pair 04fb1c983dd938062f70 |
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",
"specialty_food"
],
[
"doordash-url",
"off_premise",
null
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 30 within 1 mi · 285 within 3 mi
- Off / on premise
- 7 / 17 within 1 mi · 73 / 142 within 3 mi
- Selling alcohol
- 18 within 1 mi · 168 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.07 mi
- Setting
- urban (4,743 people per sq mi)
- People within 3 mi
- 134,095 (101,523 adults 21+, 48,176 households) from 25 tract(s), tracts within 3 mi
- Income
- per capita $63,064 · median household ~$144,409 (weighted mean of tract medians)
- Age and education
- median age ~42.7 · bachelor's or higher 52%
- Ethnicity
- Hispanic 22% · White 56% · Black 2% · Asian 17%
- Adults per alcohol outlet
- 601
- Alcohol spend within 3 mi
- $47,599,170 a year ($20,302,477 at home, $27,280,859 away) · $281,652 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-16 14:56 | insert | doordash 35802314 ↔ vtinfo d9ca3a5617ab5a99 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 4879246 ↔ doordash 35802314 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 4879246 ↔ ca-abc 00407340|21|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ca-abc 00407340|21|LIC|0 ↔ vtinfo d9ca3a5617ab5a99 | one name contains the other, same address | merged | 15 |
| 2026-11-14 20:23 | insert | doordash 24199485 ↔ ubereats f-FnGTQpXm2rzXJuSHj0Tw | street written two ways | merged | 15 |
| 2026-11-13 14:10 | update | doordash 24199485 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQ | Claude judge: same | merged | 15 |
| 2026-11-12 14:25 | insert | doordash 24199485 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQ | Claude judge: same | held: same-source-conflict | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 4879246 ↔ vtinfo d9ca3a5617ab5a99 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture 78a0f077-4586-4eb9-9971-c65401e228d3 ↔ ralphs 27730|92691 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35802314 ↔ ralphs 27730|92691 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00407340|21|LIC|0 ↔ overture 260a64fc-7d8a-4fe9-97dc-370edd924e5c | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | doordash 35802314 ↔ overture 78a0f077-4586-4eb9-9971-c65401e228d3 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00407340|21|LIC|0 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 35802314 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407340|21|LIC|0 ↔ doordash 35802314 | Claude judge: same | merged |