Ralphs

SAN LUIS OBISPO, CA 93405 · O07ac4ac4cf63 · 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 4 other
the most common name a source states
RALPHS 656 ca-abc ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Fresh & Ready From Ralphs ubereats
ralphs san luis obispo doordash
Street
201 Madonna Rd
ralphsno other value
City
San Luis Obispo
ralphsno other value
State
CA
ralphsno other value
ZIP
93405
ralphsno other value
Pin
35.26338, -120.67577 map 2 other
ralphs
100 m away ca-abc ×2
137 m away ab-inbev
Phone
8055460407
ralphsno other value
Licences
ca-abc 00407276|21|LIC|0 · ca-abc 00407276|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O3e2b1801597a; Oc1227f8a125a; O91d23ffbc2f6; Of8ce230bad48; Of3bdeb627878; O0823f6e43560; O2573835717f0

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
72477
201 MADONNA RD, SAN LUIS OBISPO, CA, 9340535.26241, -120.674832026-11-112026-11-11
ca-abcRALPHS 656
legal name: RALPHS GROCERY COMPANY
00407276|21|LIC|0
201 MADONNA RD, SAN LUIS OBISPO, CA, 9340535.26428, -120.675802026-10-082026-11-05
ca-abcRALPHS 656
legal name: RALPHS GROCERY COMPANY
00407276|86|LIC|0
201 MADONNA RD, SAN LUIS OBISPO, CA, 9340535.26428, -120.675802026-10-082026-11-05
doordashralphs san luis obispo
35800621
201 Madonna Rd, San Luis Obispo, CA, 9340535.26337, -120.675792026-10-082026-11-02
overtureRalphs
0b9b18b9-562d-4425-97e9-ad6b42ccbefc
201 Madonna Rd, San Luis Obispo, CA, 93405805546040735.26338, -120.675772026-11-062026-11-06
ralphsRalphs
201|93405
201 Madonna Rd, San Luis Obispo, CA, 93405805546040735.26338, -120.675772026-11-102026-11-10
ubereatsFresh & Ready From Ralphs
CK4UxT5bUVW_TWhCaEBeGA
201 Madonna Rd, San Luis Obispo, CA, 9340535.26348, -120.676052026-10-082026-11-02
vtinfoRALPHS
63ee5994e9016329
201 MADONNA RD, SAN LUIS OBISPO, CA, 93405805546040735.26348, -120.676052026-11-142026-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
ca-abc RALPHS 656overture 9146b624-49c2-41a5-98e7-d4c2f7aead261.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 146 m apart · name similarity 1.00
ca-abc RALPHS 656overture 9146b624-49c2-41a5-98e7-d4c2f7aead261.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 146 m apart · name similarity 1.00
ab-inbev RALPHSdoordash ralphs san luis obispo1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 138 m apart · name similarity 1.00
ab-inbev RALPHSoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 137 m apart · name similarity 1.00
ab-inbev RALPHSralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 137 m apart · name similarity 1.00
ab-inbev RALPHSvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 162 m apart · name similarity 1.00
ca-abc RALPHS 656ca-abc RALPHS 6561.00one licence filemergedfile: 00407276 · same_address
doordash ralphs san luis obispooverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
doordash ralphs san luis obisporalphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
doordash ralphs san luis obispovtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 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
overture Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 · phone: equal
ralphs Ralphsvtinfo RALPHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 · phone: equal
ca-abc RALPHS 656doordash ralphs san luis obispo0.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, 201 Madonna Rd, San Luis Obispo 93405, and the ABC off-sale licence matches a grocery store, so this is one store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 88% confident — Both records are Ralphs at 201 Madonna Rd, San Luis Obispo, ZIP 93405, with coordinates about 0.1 km apart; the CA ABC licence is an off-sale general store licence at that address, and under California's rule the chain store's alcohol listing is the store's own department, so this is one outlet. The shared building (2 businesses) and the ABC record's 'RALPHS 656' store number do not contradict this, since the DoorDash listing is the same Ralphs store.
pair ef65fc6cfff85a96eea2
ca-abc RALPHS 656doordash ralphs san luis obispo0.62Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the Ralphs store at 201 Madonna Rd, San Luis Obispo 93405: the CA off-sale licence 'RALPHS 656' and DoorDash's 'ralphs san luis obispo', which is the chain name plus the appended city
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, with coordinates about 100 m apart, and the CA off-sale licence sits on the grocery store's own premises, so the DoorDash listing is the store's alcohol storefront; the shared building (two businesses at the address) lowers confidence somewhat.
pair 7914f301199fdc1a5561
doordash ralphs san luis obispoubereats 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 201 Madonna Rd, San Luis Obispo; 'Fresh & Ready From Ralphs' is Ralphs' own prepared-food listing of the same store on Uber Eats, not a concession run by another c
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, 26 m apart, and the Uber Eats listing 'Fresh & Ready From Ralphs' reads as the store's own department or second listing rather than a separately run concession, so this is one outlet.
pair f8108b1c2d838255043a
ca-abc RALPHS 656ubereats 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 Ralphs at 201 Madonna Rd, San Luis Obispo 93405; 'Fresh & Ready From Ralphs' is a department-style Uber Eats listing of the same store, not a concession run by another company.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Ralphs Fresh & Ready department at same store address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Ralphs store 656 at 201 Madonna Rd holds the off-sale liquor licence, and the Uber Eats listing 'Fresh & Ready From Ralphs' at the same address is the store's own prepared-food department under the Ralphs banner, so it is the same outlet, with coordinates within about 90 m.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Ralphs at the same street address and ZIP, with the Uber Eats listing 'Fresh & Ready From Ralphs' 0.09 km from the ABC-licensed Ralphs 656 store, and the chain facts show both belong to Ralphs. The 'Fresh & Ready' name reads as a Ralphs-branded department or second listing rather than a separate operation, though the shared-building count of 2 adds some doubt.
  • Claude Haiku 5.5, prompt v4: same, 70% confident — Both records sit at 201 Madonna Rd, ZIP 93405, and 'Fresh & Ready From Ralphs' is the in-store ready-food counter of the same Ralphs 656 grocery, so it reads as a second listing of one operation rather than a separate business, though the shared building and the name difference keep this from being certain.
pair 45fe830d07acdd6a9466
ca-abc RALPHS 656ubereats Fresh & Ready From Ralphs0.31Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (82% confident; asked as a “same-address” pair)
Both records are the Ralphs store at 201 Madonna Rd, San Luis Obispo 93405, and 'Fresh & Ready From Ralphs' is Uber Eats' second listing for that store's prepared-food department, not a separate busin
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Ralphs Fresh & Ready department at store address.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Ralphs store 656 at 201 Madonna Rd holds the off-sale liquor licence, and the Uber Eats 'Fresh & Ready From Ralphs' listing is the store's own prepared-food department at the same address, with coordinates about 92 m apart and matching chain, so it is one outlet.
  • Claude Haiku 5.5, prompt v7: unsure, 60% confident — Both records are Ralphs at 201 Madonna Rd with matching ZIP and a 0.09 km distance, but the Uber Eats listing is 'Fresh & Ready From Ralphs', which may be a separate prepared-food concession inside the store, and two businesses share this address, so the records alone do not settle whether they are the same outlet.
  • Claude Haiku 5.5, prompt v4: same, 70% confident — Both records sit at 201 Madonna Rd with Ralphs branding, and the Uber Eats listing 'Fresh & Ready From Ralphs' reads as the store's own prepared-food department rather than a separately run concession, though the shared building (2 businesses) and no suite info keep this from being certain.
pair 3c5b485598c6b1531f6d

Attributes

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

Trade area

Other outlets
81 within 1 mi · 450 within 3 mi
Off / on premise
28 / 33 within 1 mi · 114 / 211 within 3 mi
Selling alcohol
54 within 1 mi · 345 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.04 mi
Setting
suburban (1,618 people per sq mi)
People within 3 mi
45,736 (29,895 adults 21+, 17,089 households) from 11 tract(s), tracts within 3 mi
Income
per capita $40,655 · median household ~$69,808 (weighted mean of tract medians)
Age and education
median age ~28.0 · bachelor's or higher 54%
Ethnicity
Hispanic 19% · White 71% · Black 1% · Asian 7%
Adults per alcohol outlet
86
Alcohol spend within 3 mi
$11,178,854 a year ($5,088,011 at home, $6,085,566 away) · $32,309 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-14 20:23insertdoordash 35800621 ↔ vtinfo 63ee5994e9016329same address and namemerged15
2026-11-14 20:23insertab-inbev 72477 ↔ vtinfo 63ee5994e9016329same address and namemerged15
2026-11-14 20:23insertoverture 0b9b18b9-562d-4425-97e9-ad6b42ccbefc ↔ vtinfo 63ee5994e9016329same address and namemerged15
2026-11-14 20:23insertralphs 201|93405 ↔ vtinfo 63ee5994e9016329same address and namemerged15
2026-11-11 12:56insertab-inbev 72477 ↔ overture 0b9b18b9-562d-4425-97e9-ad6b42ccbefcsame address and namemerged12
2026-11-11 12:56insertab-inbev 72477 ↔ ralphs 201|93405same address and namemerged12
2026-11-11 12:56insertab-inbev 72477 ↔ doordash 35800621same address and namemerged12
2026-11-10 17:05insertoverture 0b9b18b9-562d-4425-97e9-ad6b42ccbefc ↔ ralphs 201|93405same address and namemerged12
2026-11-10 17:05insertdoordash 35800621 ↔ ralphs 201|93405same address and namemerged12
2026-11-06 18:13insertca-abc 00407276|21|LIC|0 ↔ overture 9146b624-49c2-41a5-98e7-d4c2f7aead26same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407276|86|LIC|0 ↔ overture 9146b624-49c2-41a5-98e7-d4c2f7aead26same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 35800621 ↔ overture 0b9b18b9-562d-4425-97e9-ad6b42ccbefcsame address and namemerged11
2026-11-02 23:02backfillca-abc 00407276|21|LIC|0 ↔ ubereats CK4UxT5bUVW_TWhCaEBeGAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407276|86|LIC|0 ↔ ubereats CK4UxT5bUVW_TWhCaEBeGAClaude judge: samemerged
2026-11-02 23:02backfilldoordash 35800621 ↔ ubereats CK4UxT5bUVW_TWhCaEBeGAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407276|21|LIC|0 ↔ doordash 35800621Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407276|86|LIC|0 ↔ doordash 35800621Claude judge: samemerged
2026-10-09 13:59backfillca-abc 00407276|21|LIC|0 ↔ ca-abc 00407276|86|LIC|0one licence filemerged