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.

FieldMaster valueTaken fromWhat 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
ralphsno other value
State
CA
ralphsno other value
ZIP
92691
ralphsno other value
Pin
33.65162, -117.64680 map 2 other
ralphs
138 m away ab-inbev
127 m away ca-abc
Phone
9498370380
ralphsno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevRALPHS FRESH FARE
4879246
27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 9269133.65285, -117.646632026-11-112026-11-16
ca-abcRALPHS 117
legal name: RALPHS GROCERY COMPANY
00407340|21|LIC|0
27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 9269133.65272, -117.646452026-10-082026-11-05
doordashbloom haus by ralphs mission viejo
24199485
27730 Santa Margarita Pkwy, Mission Viejo, CA, 9269133.65158, -117.646772026-10-082026-11-13
doordashralphs mission viejo
35802314
27730 Santa Margarita Pkwy, Mission Viejo, CA, 9269133.65160, -117.646702026-10-082026-10-11
overtureRalphs
78a0f077-4586-4eb9-9971-c65401e228d3
27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691949837038033.65162, -117.646802026-11-062026-11-06
ralphsRalphs
27730|92691
27730 Santa Margarita Pkwy, Mission Viejo, CA, 92691949837038033.65162, -117.646802026-11-102026-11-10
ubereatsBloom Haus by Ralphs
f-FnGTQpXm2rzXJuSHj0Tw
27730 Santa Margarita Pkw, Mission Viejo, CA, 9269133.65174, -117.646702026-11-142026-11-14
ubereatsFresh & Ready from Ralphs
QVMyW-OWVgeT8GAwPTT7wQ
27730 Santa Margarita Pkw, Mission Viejo, CA, 9269133.65166, -117.646622026-10-152026-11-02
vtinfoRALPHS FRESH FARE
d9ca3a5617ab5a99
27730 SANTA MARGARITA PKWY, MISSION VIEJO, CA, 92691949837038033.65166, -117.646622026-11-122026-11-16

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
ca-abc RALPHS 117overture 260a64fc-7d8a-4fe9-97dc-370edd924e5c1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 139 m apart · name similarity 1.00
ab-inbev RALPHS FRESH FAREvtinfo RALPHS FRESH FARE1.00same address and namemergedaddress 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 viejoubereats Bloom Haus by Ralphs1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 18 m apart · name similarity 1.00 · street similarity 0.97
doordash ralphs mission viejooverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
doordash ralphs mission viejoralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
overture Ralphsralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 117doordash ralphs mission viejo0.62Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at the same street address and ZIP in Mission Viejo, with coordinates about 0.13 km apart and a matching off-sale licence type; under California's rule the DoorDash listing is the store's own alcohol department, though the 3 businesses at the address leave some doubt and the ABC name is a store number rather than the chain name alone.
pair cc610310ab8e87a32023
ab-inbev RALPHS FRESH FAREca-abc RALPHS 1170.45one name contains the other, same addressmergedjudge: None · pair_id: bbc1218d3ba1bb9d2dfd · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 117vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 9e5f8674456d3c0c6651 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREdoordash ralphs mission viejo0.43one name contains the other, same addressmergedjudge: None · pair_id: 9ff0cf6b9ed9ec4bdff6 · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs mission viejovtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: 9115f83fcbe6f531cec8 · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs mission viejoubereats Fresh & Ready from Ralphs0.34Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records are Ralphs at the same street address, ZIP and coordinates (10 m apart), and the Uber Eats listing 'Fresh & Ready from Ralphs' reads as the store's own in-store department rather than a separate concession, though the building holds three businesses and the names only partly match.
  • Claude Haiku 5.5, prompt v4: same, 60% confident — Both records sit at the same street address and within about 10 m, and B's name 'Fresh & Ready from Ralphs' reads as a prepared-food department of the Ralphs store, like a pharmacy listing, though the building holds three businesses and a separate concession operator is possible.
pair 6bd11c9abfbe9bd7b654
ca-abc RALPHS 117ubereats Fresh & Ready from Ralphs0.31Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records are Ralphs at the identical street address and ZIP, about 0.12 km apart, and the Uber Eats listing 'Fresh & Ready from Ralphs' reads as a Ralphs department listing, though the shared building (3 businesses) and possible concession operator leave some doubt.
pair be810dc9c007d38489a8
doordash bloom haus by ralphs mission viejoubereats Fresh & Ready from Ralphs0.28Claude judge: samemerged
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:
  • Claude Opus 5.5, prompt v12: same, 80% confident — Both Ralphs departments at same store address
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records are Ralphs departments (Bloom Haus floral and Fresh & Ready prepared food) at essentially the same address about 16 m apart, and the rules treat a store brand's department listing at the store's own address as the same outlet, though the three businesses at the address leave some doubt.
  • Claude Opus 5.5, prompt v7: same, 68% confident — Both are Ralphs-owned department listings (Bloom Haus floral and Fresh & Ready prepared foods) at the same street address 16 m apart, so they are one Ralphs store sold through two delivery listings rather than a concession run by another company.
  • Claude Haiku 5.5, prompt v7: unsure, 50% confident — Both records sit at the same address with near-identical coordinates, and both carry a Ralphs banner, but they use different sub-brand names (Bloom Haus vs Fresh & Ready) and three businesses share the address, so the records cannot show whether these are one operation's two listings or two separate in-store concepts.
  • Claude Haiku 5.5, prompt v4: different, 60% confident — The two records share a street address, but the address is shared by three businesses, so the names must agree for SAME, and 'Bloom Haus by Ralphs' and 'Fresh & Ready from Ralphs' name different storefront concepts inside the Ralphs building.
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”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertdoordash 35802314 ↔ vtinfo d9ca3a5617ab5a99one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4879246 ↔ doordash 35802314one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4879246 ↔ ca-abc 00407340|21|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407340|21|LIC|0 ↔ vtinfo d9ca3a5617ab5a99one name contains the other, same addressmerged15
2026-11-14 20:23insertdoordash 24199485 ↔ ubereats f-FnGTQpXm2rzXJuSHj0Twstreet written two waysmerged15
2026-11-13 14:10updatedoordash 24199485 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQClaude judge: samemerged15
2026-11-12 14:25insertdoordash 24199485 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQClaude judge: sameheld: same-source-conflict12
2026-11-12 14:25insertab-inbev 4879246 ↔ vtinfo d9ca3a5617ab5a99same address and namemerged12
2026-11-10 17:05insertoverture 78a0f077-4586-4eb9-9971-c65401e228d3 ↔ ralphs 27730|92691same address and namemerged12
2026-11-10 17:05insertdoordash 35802314 ↔ ralphs 27730|92691same address and namemerged12
2026-11-06 18:13insertca-abc 00407340|21|LIC|0 ↔ overture 260a64fc-7d8a-4fe9-97dc-370edd924e5csame address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 35802314 ↔ overture 78a0f077-4586-4eb9-9971-c65401e228d3same address and namemerged11
2026-11-02 23:02backfillca-abc 00407340|21|LIC|0 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35802314 ↔ ubereats QVMyW-OWVgeT8GAwPTT7wQClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407340|21|LIC|0 ↔ doordash 35802314Claude judge: samemerged