Ralphs

SHERMAN OAKS, CA 91423 · O38f05fb5400c · first seen 2026-10-08
7 sourcesoff premise · grocerychain: 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 5 other
the most common name a source states
RALPHS 222 ca-abc ×2
RALPHS FRESH FARE ab-inbevvtinfo ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Bloom Haus by Ralphs ubereats
ralphs sherman oaks doordash
Street
14049 Ventura Blvd
ralphsno other value
City
Sherman Oaks 1 other
ralphs
Los Angeles ubereats
State
CA
ralphsno other value
ZIP
91423
ralphsno other value
Pin
34.14993, -118.43941 map 2 other
ralphs
94 m away ca-abc ×2
66 m away ab-inbev
Phone
7472336100
ralphsno other value
Licences
ca-abc 00407400|21|LIC|0 · ca-abc 00407400|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7f3c8c5efe7a; O5fdf0ce5ff88; O5907e358c184; Od9bd82e0e46e; O3ce1a5ec62d6; O84db11f598a1; O472cead7030c; O60bed1104947

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
72423
14049 VENTURA BLVD, SHERMAN OAKS, CA, 9142334.14940, -118.439082026-11-122026-11-16
ca-abcRALPHS 222
legal name: RALPHS GROCERY COMPANY
00407400|21|LIC|0
14049 VENTURA BLVD, SHERMAN OAKS, CA, 9142334.14932, -118.438702026-10-082026-11-10
ca-abcRALPHS 222
legal name: RALPHS GROCERY COMPANY
00407400|86|LIC|0
14049 VENTURA BLVD, SHERMAN OAKS, CA, 9142334.14932, -118.438702026-10-082026-11-10
doordashralphs sherman oaks
35800998
14049 Ventura Blvd, Sherman Oaks, CA, 9142334.14994, -118.439582026-10-082026-11-10
overtureRalphs
057e9564-e84b-4ca7-808e-7e3dc9fdbdea
14049 Ventura Blvd, Sherman Oaks, CA, 91423747233610034.14993, -118.439412026-11-062026-11-10
ralphsRalphs
14049|91423
14049 Ventura Blvd, Sherman Oaks, CA, 91423747233610034.14993, -118.439412026-11-102026-11-10
ubereatsBloom Haus by Ralphs
DnXmunpqWZeK11K3Qv7IPw
14049 Ventura Blvd., Los Angeles, CA, 91423
ZIP lookup: Sherman Oaks, CA
34.14986, -118.439622026-10-282026-11-12
vtinfoRALPHS FRESH FARE
0eda05344e41914e
14049 VENTURA BLVD, SHERMAN OAKS, CA, 91423747233610034.14985, -118.439152026-11-112026-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
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 50 m apart · name similarity 1.00
ca-abc RALPHS 222ca-abc RALPHS 2221.00one licence filemergedfile: 00407400 · same_address
ca-abc RALPHS 222overture f5f1ec2b-aa12-4010-a1be-dec36f544acc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ca-abc RALPHS 222overture f5f1ec2b-aa12-4010-a1be-dec36f544acc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
doordash ralphs sherman oaksoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
doordash ralphs sherman oaksralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 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 222doordash ralphs sherman oaks0.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 same street address and ZIP (14049 Ventura Blvd, 91423), and the off-sale general licence fits a supermarket, so the names agree despite the shared building.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at 14049 Ventura Blvd, Sherman Oaks, 91423, with coordinates about 0.1 km apart, and the CA ABC licence is an off-sale general store licence matching the DoorDash listing as the store's own alcohol department; the shared-building count of 3 and the lack of a suite on either record leave some doubt, but the chain name and street address line up.
  • Claude Haiku 5.5, prompt v4: same, 86% confident — Both records are Ralphs at the identical street address, 14049 Ventura Blvd, Sherman Oaks, ZIP 91423, and the ABC record's off-sale general grocery licence fits a Ralphs store; the store-number difference ('222' vs none) is the chain-store spelling case, and the names agree despite the building housing three businesses.
pair 5724e2344aa1343160cb
ca-abc RALPHS 222doordash ralphs sherman oaks0.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 (14049 Ventura Blvd, 91423); the ABC off-sale licence is the store's own, and the names agree even though the building is shar
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs at same address, same chain
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the same street address in Sherman Oaks (14049 Ventura Blvd, ZIP 91423), about 0.1 km apart, and the DoorDash listing is the store's own alcohol department under the Ralphs banner, which the California rule treats as the same outlet; the CA off-sale licence is the store's licence at that address.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at 14049 Ventura Blvd, Sherman Oaks, 91423, with a short distance of about 0.1 km; the California ABC off-sale licence sits on the same premises as the DoorDash listing, and the state rule treats the store's alcohol listing as its own department, though the three businesses at this address and the unmatched store number leave some doubt.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city and ZIP, and the names agree: RALPHS 222 (ABC, off-sale grocery licence) is the Ralphs store at 14049 Ventura Blvd, matching the DoorDash slug 'ralphs sherman oaks'. The three businesses at that address make the building shared, but the names match, so this is one store listed twice.
pair 0b6db70bf45bb11775c6
ab-inbev RALPHS FRESH FAREca-abc RALPHS 2220.45one name contains the other, same addressmergedjudge: None · pair_id: fae73c293260bcf0ad9d · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREca-abc RALPHS 2220.45one name contains the other, same addressmergedjudge: None · pair_id: f04dad4515f7e0a0e5eb · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 222vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 2d30bd5f4ee6b717b441 · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 222vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: a618e1156fa67ed42580 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREdoordash ralphs sherman oaks0.43one name contains the other, same addressmergedjudge: None · pair_id: eea4964e6ba32fe1fc24 · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs sherman oaksvtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: 626f5acee706042a8f2a · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs sherman oaksubereats Bloom Haus by Ralphs0.34Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Bloom Haus is Ralphs floral department at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Bloom Haus by Ralphs is Ralphs' own floral department listed on Uber Eats at the same street address and ZIP, with coordinates about 9 m apart, so it is the same store's department rather than a concession; the shared building is resolved because the chain names agree.
  • Claude Haiku 5.5, prompt v7: different, 75% confident — The two records share the same street address and near-identical coordinates, but the building holds three businesses, and Uber Eats lists 'Bloom Haus by Ralphs' as its own brand rather than a Ralphs department or alcohol listing, which points to a separately run concession rather than the same Ralphs outlet.
  • Claude Haiku 5.5, prompt v4: different, 75% confident — The addresses and coordinates match, but the building is shared by three businesses and the names do not agree: 'Bloom Haus by Ralphs' reads as a separately branded concession operating under the Ralphs banner, not the same operation as 'ralphs sherman oaks'.
pair 3622da2354c2ede635d6

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_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 7, computed 2026-11-16 17:16.
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"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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 35800998 ↔ vtinfo 0eda05344e41914eone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72423 ↔ doordash 35800998one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407400|86|LIC|0 ↔ vtinfo 0eda05344e41914eone name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407400|21|LIC|0 ↔ vtinfo 0eda05344e41914eone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72423 ↔ ca-abc 00407400|86|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72423 ↔ ca-abc 00407400|21|LIC|0one name contains the other, same addressmerged15
2026-11-12 17:29insertdoordash 35800998 ↔ ubereats DnXmunpqWZeK11K3Qv7IPwClaude judge: samemerged14
2026-11-12 14:25insertab-inbev 72423 ↔ vtinfo 0eda05344e41914esame address and namemerged12
2026-11-10 17:05insertdoordash 35800998 ↔ ralphs 14049|91423same address and namemerged12
2026-11-10 17:05insertoverture 057e9564-e84b-4ca7-808e-7e3dc9fdbdea ↔ ralphs 14049|91423same address and namemerged12
2026-11-09 15:32updatedoordash 35800998 ↔ overture 057e9564-e84b-4ca7-808e-7e3dc9fdbdeasame address and namemerged11
2026-11-06 18:13insertca-abc 00407400|86|LIC|0 ↔ overture f5f1ec2b-aa12-4010-a1be-dec36f544accsame address and namemerged11
2026-11-06 18:13insertdoordash 35800998 ↔ overture 057e9564-e84b-4ca7-808e-7e3dc9fdbdeasame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407400|21|LIC|0 ↔ overture f5f1ec2b-aa12-4010-a1be-dec36f544accsame address and namemerged11
2026-11-02 23:02backfillca-abc 00407400|21|LIC|0 ↔ doordash 35800998Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407400|86|LIC|0 ↔ doordash 35800998Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407400|21|LIC|0 ↔ ca-abc 00407400|86|LIC|0one licence filemerged