RALPHS 175

CARLSBAD, CA 92011 · O0785b2651baa · first seen 2026-10-08
6 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 175 6 other
the most common name a source states
RALPHS FRESH FARE ab-inbevoverturevtinfo ×3
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Bloom Haus by Ralphs ubereats
bloom haus by ralphs carlsbad doordash
Ralphs ubereats
ralphs carlsbad doordash
Street
7140 AVENIDA ENCINAS
ca-abcno other value
City
CARLSBAD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92011
ca-abcno other value
Pin
33.10111, -117.31077 map 3 other
ubereats
155 m away ca-abc ×2
148 m away ab-inbev
132 m away vtinfo
Phone
7604311060
vtinfono other value
Licences
ca-abc 00407421|21|LIC|0 · ca-abc 00407421|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe8654e1f4e98; O88e6bfe7040f; Ocf32eba2062d; O813b8e0671bd; Oda2794969f5d; Oaacc093d8f66; O36dd4627f502; O3af87078f888

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
72648
7140 AVENIDA ENCINAS, CARLSBAD, CA, 9201133.10115, -117.312352026-11-112026-11-16
ca-abcRALPHS 175
legal name: RALPHS GROCERY COMPANY
00407421|21|LIC|0
7140 AVENIDA ENCINAS, CARLSBAD, CA, 9201133.10023, -117.312062026-10-082026-11-14
ca-abcRALPHS 175
legal name: RALPHS GROCERY COMPANY
00407421|86|LIC|0
7140 AVENIDA ENCINAS, CARLSBAD, CA, 9201133.10023, -117.312062026-10-082026-11-14
doordashbloom haus by ralphs carlsbad
24199916
7140 Avenida Encinas, Carlsbad, CA, 9201133.10110, -117.310772026-10-082026-11-14
doordashralphs carlsbad
35802209
7140 Avenida Encinas, Carlsbad, CA, 9201133.10113, -117.310662026-10-082026-11-14
overtureRalphs Fresh Fare
2ebfd2b1-9ffb-4bc3-a316-f2a64290663c
7140 Avenida Encinas, Carlsbad, CA, 92011760431106033.10105, -117.310512026-11-132026-11-16
ubereatsBloom Haus by Ralphs
UB87qSl8UaeWtMinijz-kw
7140 Avenida Encinas, Carlsbad, CA, 9201133.10111, -117.310772026-11-022026-11-14
ubereatsRalphs
XmgizJLNW9emVp9ZGySiVw
7140 Avenida Encinas, Carlsbad, CA, 9201133.10106, -117.310852026-11-142026-11-14
vtinfoRALPHS FRESH FARE
83a265dc4ca61ec5
7140 AVENIDA ENCINAS, CARLSBAD, CA, 92011760431106033.10063, -117.312062026-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
ab-inbev RALPHS FRESH FAREoverture Ralphs Fresh Fare1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 172 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 64 m apart · name similarity 1.00
ca-abc RALPHS 175ca-abc RALPHS 1751.00one licence filemergedfile: 00407421 · same_address
doordash bloom haus by ralphs carlsbadubereats Bloom Haus by Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
doordash ralphs carlsbadubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
overture Ralphs Fresh Farevtinfo RALPHS FRESH FARE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 152 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 175doordash ralphs carlsbad0.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 (7140 Avenida Encinas, Carlsbad 92011), and the off-sale licence fits a supermarket, so the shared building does not undermine the
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are Ralphs at the same street address and ZIP in Carlsbad, with the DoorDash listing matching the ABC off-sale liquor licence at that premises, and California's rule makes the grocery store's alcohol sales its own department, so this is one outlet; the 3 businesses at the address and missing suite info keep it from being fully certain.
pair 84eab27156ba2b672103
ca-abc RALPHS 175doordash ralphs carlsbad0.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 (7140 Avenida Encinas, Carlsbad 92011), with an off-sale licence matching a supermarket, so the shared building does not separ
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Ralphs same address
  • Claude Opus 5.5, prompt v9: same, 95% confident — The Ralphs off-sale licence and the DoorDash 'ralphs carlsbad' listing share the street address 7140 Avenida Encinas, Carlsbad 92011, and both belong to the Ralphs chain, so they are one store.
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Ralphs at 7140 Avenida Encinas, Carlsbad, 92011, with coordinates about 165 m apart; the ca-abc record is the Ralphs store's off-sale licence and the DoorDash listing is the store's own alcohol/storefront listing, which California's rule treats as the store's own department, so it is one outlet despite three businesses at the address.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are Ralphs at 7140 Avenida Encinas, Carlsbad, 92011, with matching street, city and ZIP, and the DoorDash listing is the store's own alcohol storefront; the CA ABC off-sale licence is for the store's grocery premises, so it is one operation, though three businesses share the address, which lowers confidence slightly.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records name Ralphs at 7140 Avenida Encinas, Carlsbad, CA 92011, and the ABC off-sale licence matches a supermarket store, so the chain store under a store-number variant is the same outlet; the shared building with 3 businesses is outweighed by the matching name at the exact street address.
pair 05e4d04a4925689b361e
ab-inbev RALPHS FRESH FAREca-abc RALPHS 1750.45one name contains the other, same addressmergedjudge: None · pair_id: 4f97cfda4211f0bf945d · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREca-abc RALPHS 1750.45one name contains the other, same addressmergedjudge: None · pair_id: adbb7d7ec1930eff43ce · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 175vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 961586825ae8810dac92 · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 175vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 45924789a81f18030673 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREdoordash ralphs carlsbad0.44one name contains the other, same addressmergedjudge: None · pair_id: ce0ce5aae87f3844640d · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs carlsbadvtinfo RALPHS FRESH FARE0.44one name contains the other, same addressmergedjudge: None · pair_id: 3352848b94e746c767d4 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev RALPHS FRESH FAREubereats Ralphs0.43one name contains the other, same addressmergedjudge: None · pair_id: f9ef7f6bb25651fc6a3a · person: None · rule: names contained at one address · stratum: same-address
ubereats Ralphsvtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: 263bb3e21f283404499f · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 175ubereats Bloom Haus by Ralphs0.36Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Bloom Haus is Ralphs floral department at store address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Uber Eats' 'Bloom Haus by Ralphs' is Ralphs' own floral department listing at the identical street address and ZIP as the Ralphs 175 California off-sale licence, and the chain-department rule treats such a listing as the same outlet.
  • Claude Haiku 5.5, prompt v7: different, 60% confident — Record A is the Ralphs 175 grocery's liquor licence at 7140 Avenida Encinas, while record B is a separately named Uber Eats brand, 'Bloom Haus by Ralphs', at the same address; the building holds three businesses and the names don't match, so this reads as a separate operation rather than one store's second listing.
  • Claude Haiku 5.5, prompt v4: different, 65% confident — Record A is the Ralphs 175 grocery store's off-sale liquor licence, while B is 'Bloom Haus by Ralphs', a separately branded operation at the same address; the shared building (3 businesses) and the 'by' branding suggest a concession run by another company rather than the same outlet.
pair 25dec398ad4be040579f
ca-abc RALPHS 175doordash bloom haus by ralphs carlsbad0.36Claude 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, 90% confident — The Ralphs store at 7140 Avenida Encinas (CA ABC off-sale licence) and the DoorDash 'Bloom Haus by Ralphs' listing at the same street address and ZIP are the same chain's store, with the Bloom Haus floral counter being the store's own department per the chain-department rule, and the coordinates are within about 150 m.
  • Claude Haiku 5.5, prompt v7: different, 62% confident — The ABC record is the Ralphs 175 grocery licence, while the DoorDash listing is branded 'Bloom Haus by Ralphs', a separately named operation; with three businesses at this address, the names must agree for SAME, and the different brand suggests a separate concession or storefront under the banner.
  • Claude Opus 5.5, prompt v7: same, 70% confident — Bloom Haus by Ralphs is Ralphs' own floral storefront on DoorDash, at the same address as the licensed Ralphs 175. It is a department listing of one store, not a concession run by another company.
  • Claude Haiku 5.5, prompt v4: different, 70% confident — Both records share the exact address, but the DoorDash name 'bloom haus by ralphs' reads as a separately branded concession operating within the Ralphs store rather than the Ralphs 175 supermarket itself, and the address is shared by three businesses, so the names don't clearly agree.
pair 42970552bf2515dd7b8f
ca-abc RALPHS 175ubereats Bloom Haus by Ralphs0.36Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Uber Eats' 'Bloom Haus by Ralphs' is Ralphs' floral department listed at the same street address and ZIP as the Ralphs 175 ca-abc licensed premises, and the guidance treats such a department brand at the store's address as the store's own outlet, not a concession.
  • Claude Haiku 5.5, prompt v7: different, 60% confident — The address is shared by three businesses, the names do not agree (RALPHS 175 versus 'Bloom Haus by Ralphs', which reads as a separate brand operating under the Ralphs banner), and the records give no suite match or chain-department link tying the Uber Eats listing to the licensed Ralphs store.
  • Claude Haiku 5.5, prompt v4: different, 80% confident — Same street address, but the name 'Bloom Haus by Ralphs' is a separately branded operation, not the Ralphs 175 liquor store, and the address is shared by three businesses, so the name must match for SAME and it does not.
pair 2a903ce414b613e2f9b4

Attributes

Channel
off_premise · grocery — ca-licence conflicting evidence
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:14.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "non_beverage",
   "florist"
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
25 within 1 mi · 300 within 3 mi
Off / on premise
5 / 15 within 1 mi · 63 / 167 within 3 mi
Selling alcohol
18 within 1 mi · 203 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.04 mi
Setting
suburban (1,407 people per sq mi)
People within 3 mi
39,772 (30,821 adults 21+, 16,033 households) from 8 tract(s), tracts within 3 mi
Income
per capita $82,461 · median household ~$159,366 (weighted mean of tract medians)
Age and education
median age ~46.8 · bachelor's or higher 67%
Ethnicity
Hispanic 14% · White 72% · Black 2% · Asian 8%
Adults per alcohol outlet
151
Alcohol spend within 3 mi
$16,651,209 a year ($7,057,567 at home, $9,588,516 away) · $81,624 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-16 14:56insertab-inbev 72648 ↔ ubereats XmgizJLNW9emVp9ZGySiVwone name contains the other, same addressmerged15
2026-11-16 14:56insertubereats XmgizJLNW9emVp9ZGySiVw ↔ vtinfo 83a265dc4ca61ec5one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 35802209 ↔ vtinfo 83a265dc4ca61ec5one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72648 ↔ doordash 35802209one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407421|86|LIC|0 ↔ vtinfo 83a265dc4ca61ec5one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407421|21|LIC|0 ↔ vtinfo 83a265dc4ca61ec5one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72648 ↔ ca-abc 00407421|86|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 72648 ↔ ca-abc 00407421|21|LIC|0one name contains the other, same addressmerged15
2026-11-14 20:23insertdoordash 35802209 ↔ ubereats XmgizJLNW9emVp9ZGySiVwsame address and namemerged15
2026-11-13 14:10updateca-abc 00407421|86|LIC|0 ↔ doordash 24199916Claude judge: samemerged15
2026-11-13 14:10updateca-abc 00407421|86|LIC|0 ↔ ubereats UB87qSl8UaeWtMinijz-kwClaude judge: samemerged15
2026-11-13 14:10updateca-abc 00407421|21|LIC|0 ↔ ubereats UB87qSl8UaeWtMinijz-kwClaude judge: samemerged15
2026-11-13 14:10insertoverture 2ebfd2b1-9ffb-4bc3-a316-f2a64290663c ↔ vtinfo 83a265dc4ca61ec5same address and namemerged15
2026-11-13 14:10insertab-inbev 72648 ↔ overture 2ebfd2b1-9ffb-4bc3-a316-f2a64290663csame address and namemerged15
2026-11-12 17:29insertca-abc 00407421|86|LIC|0 ↔ doordash 24199916Claude judge: sameheld: same-source-conflict14
2026-11-12 17:29insertca-abc 00407421|86|LIC|0 ↔ ubereats UB87qSl8UaeWtMinijz-kwClaude judge: sameheld: same-source-conflict14
2026-11-12 17:29insertca-abc 00407421|21|LIC|0 ↔ ubereats UB87qSl8UaeWtMinijz-kwClaude judge: sameheld: same-source-conflict14
2026-11-12 14:25insertab-inbev 72648 ↔ vtinfo 83a265dc4ca61ec5same address and namemerged12
2026-11-03 13:33backfilldoordash 24199916 ↔ ubereats UB87qSl8UaeWtMinijz-kwsame address and namemerged
2026-11-02 23:02backfillca-abc 00407421|21|LIC|0 ↔ doordash 35802209Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407421|86|LIC|0 ↔ doordash 35802209Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407421|21|LIC|0 ↔ ca-abc 00407421|86|LIC|0one licence filemerged