RALPHS 147

VALENCIA, CA 91354 · O58d9bcc9e15b · first seen 2026-10-08
6 sourcesoff premise · specialty_foodchain: 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.

FieldMaster valueTaken fromWhat other sources say
Name
RALPHS 147 4 other
the most common name a source states
RALPHS FRESH FARE ab-inbevoverturevtinfo ×3
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Fresh & Ready from Ralphs ubereats
ralphs valencia doordash
Street
27760 MCBEAN PKWY
ca-abcno other value
City
VALENCIA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91354
ca-abcno other value
Pin
34.44587, -118.55217 map 2 other
ubereats
178 m away ca-abc ×2
70 m away ab-inbev
Phone
6612637690
vtinfono other value
Licences
ca-abc 00407409|21|LIC|0 · ca-abc 00407409|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O674e3208f1ba; Oebe6a7f185ff; Ob34b4409664f; O9ae07445c65f; Oa8144581e6f8; O6f948dd718b6

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
4879379
27760 MCBEAN PKWY, VALENCIA, CA, 9135434.44546, -118.551582026-11-112026-11-12
ca-abcRALPHS 147
legal name: RALPHS GROCERY COMPANY
00407409|21|LIC|0
27760 MCBEAN PKWY, VALENCIA, CA, 9135434.44738, -118.552812026-10-082026-11-05
ca-abcRALPHS 147
legal name: RALPHS GROCERY COMPANY
00407409|86|LIC|0
27760 MCBEAN PKWY, VALENCIA, CA, 9135434.44738, -118.552812026-10-082026-11-05
doordashralphs valencia
35802671
27760 Mcbean Pkwy, Valencia, CA, 9135434.44569, -118.552172026-10-082026-11-02
overtureRalphs Fresh Fare
44dc6944-9a53-4836-bc8f-30e09a17ed82
27760 McBean Pkwy, Valencia, CA, 91354661263769034.44585, -118.551982026-11-132026-11-13
ubereatsFresh & Ready from Ralphs
I3qZ7EsoUPKzIia7uu5TCA
27760 Mcbean Pkwy, Valencia, CA, 9135434.44587, -118.552172026-10-092026-11-02
vtinfoRALPHS FRESH FARE
d41f0fa84524c69c
27760 MCBEAN PKWY, VALENCIA, CA, 91354661263769034.44587, -118.552172026-11-132026-11-14

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
ab-inbev RALPHS FRESH FAREoverture Ralphs Fresh Fare1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 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 70 m apart · name similarity 1.00
ca-abc RALPHS 147ca-abc RALPHS 1471.00one licence filemergedfile: 00407409 · same_address
overture Ralphs Fresh Farevtinfo RALPHS FRESH FARE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 147doordash ralphs valencia0.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 (27760 McBean Pkwy, Valencia 91354), and A holds an off-sale store licence; the shared building has other businesses, but the
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs store and Ralphs listing at same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at 27760 McBean Pkwy, Valencia 91354, with matching chain and street address; the DoorDash listing is the store's own alcohol/grocery storefront and California's rule makes it the same store's department, with coordinates about 200 m apart.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at the same street address and ZIP in Valencia, CA, with coordinates about 0.2 km apart, and the CA rule makes a chain store's alcohol listing its own department, so the Ralphs store and its DoorDash listing are one outlet.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, city and ZIP (27760 McBean Pkwy, Valencia 91354), and the names agree as a Ralphs chain store, with A's store number 147 the only extra detail. The building holds four businesses, so the match depends on the name, and 'Ralphs' matches.
pair 1f203b0a027d085766f9
ca-abc RALPHS 147doordash ralphs valencia0.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 (27760 McBean Pkwy, Valencia 91354), and A holds an off-sale store licence; the DoorDash slug is simply the chain name plus th
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Ralphs at 27760 McBean Pkwy, Valencia 91354, with matching chain and street address and coordinates about 0.2 km apart; California's rule makes the store's alcohol listing its own department, and the DoorDash listing is the store's storefront, so this is one outlet despite four businesses in the building.
pair 6d33f0bb115dc807c239
ab-inbev RALPHS FRESH FAREca-abc RALPHS 1470.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Ralphs store at identical address on both records.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 27760 McBean Pkwy, Valencia, 91354; the ca-abc record's off-sale general licence belongs to the Ralphs store there (legal entity Ralphs Grocery Company), and the ab-inbev 'Ralphs Fresh Fare' listing is the same store's own department under the Ralphs chain, with coordinates about 0.24 km apart and no conflicting unit or chain evidence.
pair 37771068f1c692e40b25
ab-inbev RALPHS FRESH FAREdoordash ralphs valencia0.43Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Ralphs Fresh Fare is Ralphs banner at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the same street address in Valencia, CA (distance about 0.06 km), and the DoorDash listing is the store's own alcohol/grocery storefront under the same chain, which California's rule treats as the store's own department, so it is one outlet.
pair 4b6a390714d16befeb48
ca-abc RALPHS 147ubereats 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 the Ralphs store at 27760 McBean Pkwy, Valencia 91354; 'Fresh & Ready from Ralphs' is a second Uber Eats listing of that same store, and the California rule makes its alcohol part of
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Fresh & Ready is Ralphs department at store address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 27760 McBean Pkwy, Valencia, 91354; the Uber Eats listing 'Fresh & Ready from Ralphs' is the store's own prepared-food department under its banner, which counts as the same outlet as the Ralphs 147 off-sale licence, with coordinates 0.18 km apart.
  • Claude Haiku 5.5, prompt v7: same, 68% confident — Both records sit at 27760 McBean Pkwy (0.18 km apart) under the Ralphs chain, and 'Fresh & Ready from Ralphs' reads as a prepared-food listing of the Ralphs store itself rather than a separate concession, though the shared building (4 businesses) and the lack of suite or phone data leave some doubt.
  • Claude Haiku 5.5, prompt v4: different, 60% confident — Both records sit at the same street address, but the names differ: the ABC licence is for the Ralphs 147 liquor-capable grocery store, while the Uber Eats listing is 'Fresh & Ready from Ralphs', a separate ready-to-eat food storefront that reads as a distinct in-store operation rather than the store itself, and the building holds four businesses.
pair 25ef0fb4ea0d93dc858c
doordash ralphs valenciaubereats 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 the Ralphs chain at the identical street address (27760 Mcbean Pkwy, Valencia), and 'Fresh & Ready from Ralphs' is a delivery-app listing of that same store rather than a separate ope
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Fresh & Ready is Ralphs department at same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both listings are Ralphs at the same street address in Valencia, CA, with coordinates 0.02 km apart; B is the store's own Fresh & Ready prepared-food department, which the rules treat as the same outlet rather than a concession, despite four businesses at the address.
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records are Ralphs at the identical street address, ZIP and near-identical coordinates, and 'Fresh & Ready from Ralphs' reads as the store's own prepared-food department listed separately, though the four businesses at this address make the building shared and the name difference leaves some doubt.
  • Claude Haiku 5.5, prompt v4: same, 70% confident — Both records sit at the same street address with nearly identical coordinates (0.02 km), and B's 'Fresh & Ready from Ralphs' reads as the in-store food department of the Ralphs store listed in A, which is a second listing of one operation; the shared building (4 businesses) and the lack of a separate operator name keep this from being certain.
pair 2faac00146f201955d71
ca-abc RALPHS 147ubereats 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 are the Ralphs store at 27760 McBean Pkwy, Valencia 91354, and 'Fresh & Ready from Ralphs' is that store's own Uber Eats listing rather than a concession run by another company.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Ralphs prepared-food department at the store's address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — The ca-abc record is Ralphs 147 with an off-sale general licence at 27760 McBean Pkwy, and the Uber Eats listing is Ralphs' Fresh & Ready prepared-food department at the same street address and ZIP, which the rules treat as the store's own department rather than a concession, though the four businesses at this address warrant some caution.
  • Claude Haiku 5.5, prompt v7: same, 70% confident — Both records are Ralphs at the identical street address and ZIP, and the Uber Eats listing is branded 'from Ralphs', which fits a second listing of the same store; the shared building (4 businesses) and the prepared-food branding leave some doubt.
  • Claude Haiku 5.5, prompt v4: same, 70% confident — Both records give the identical street address and ZIP, and B's name 'Fresh & Ready from Ralphs' is the Ralphs banner, so it reads as a department or second listing of the Ralphs store rather than a separate business. The four businesses at this address and the lack of a suite number keep confidence moderate, not high.
pair 4abf9c1597d281fa85e0

Attributes

Channel
off_premise · specialty_food — 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",
   "specialty_food"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 475 within 3 mi
Off / on premise
7 / 25 within 1 mi · 107 / 306 within 3 mi
Selling alcohol
20 within 1 mi · 234 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.06 mi
Setting
urban (3,082 people per sq mi)
People within 3 mi
87,139 (64,344 adults 21+, 29,186 households) from 19 tract(s), tracts within 3 mi
Income
per capita $57,870 · median household ~$139,718 (weighted mean of tract medians)
Age and education
median age ~41.1 · bachelor's or higher 46%
Ethnicity
Hispanic 25% · White 54% · Black 6% · Asian 14%
Adults per alcohol outlet
274
Alcohol spend within 3 mi
$28,088,072 a year ($12,091,296 at home, $15,986,627 away) · $119,524 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”).
WhenEventPairRuleDecisionRule version
2026-11-13 14:10insertab-inbev 4879379 ↔ vtinfo d41f0fa84524c69csame address and namemerged15
2026-11-13 14:10insertoverture 44dc6944-9a53-4836-bc8f-30e09a17ed82 ↔ vtinfo d41f0fa84524c69csame address and namemerged15
2026-11-13 14:10insertab-inbev 4879379 ↔ overture 44dc6944-9a53-4836-bc8f-30e09a17ed82same address and namemerged15
2026-11-12 17:29insertab-inbev 4879379 ↔ doordash 35802671Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 4879379 ↔ ca-abc 00407409|86|LIC|0Claude judge: samemerged14
2026-11-06 18:13insertca-abc 00407409|21|LIC|0 ↔ ubereats I3qZ7EsoUPKzIia7uu5TCAClaude judge: samemerged11
2026-11-02 23:02backfillca-abc 00407409|86|LIC|0 ↔ ubereats I3qZ7EsoUPKzIia7uu5TCAClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35802671 ↔ ubereats I3qZ7EsoUPKzIia7uu5TCAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407409|86|LIC|0 ↔ doordash 35802671Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407409|21|LIC|0 ↔ doordash 35802671Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407409|21|LIC|0 ↔ ca-abc 00407409|86|LIC|0one licence filemerged