Ralphs

Irvine, CA 92614 · O278cb2b7a60f · 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 5 other
the most common name a source states
RALPHS 80 ca-abc ×2
RALPHS GROCERY COMPANY ca-abc (legal name) ×2
Fresh & Ready from Ralphs ubereats
RALPHS FRESH FARE vtinfo
ralphs irvine doordash
Street
17605 Harvard Ave
ralphsno other value
City
Irvine
ralphsno other value
State
CA
ralphsno other value
ZIP
92614
ralphsno other value
Pin
33.67708, -117.83305 map
ralphsno other value
Phone
9498513161
ralphsno other value
Licences
ca-abc 00407337|21|LIC|0 · ca-abc 00407337|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of35d513ae01b; Of2465cfd2261; O94cee714a609; Oc9275061fdfa; O36566421a698; Ob33e7f5a452d; Oea244587693e; O679810c5bf98

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
ca-abcRALPHS 80
legal name: RALPHS GROCERY COMPANY
00407337|21|LIC|0
17605 HARVARD AVE, IRVINE, CA, 926142026-10-082026-11-09
ca-abcRALPHS 80
legal name: RALPHS GROCERY COMPANY
00407337|86|LIC|0
17605 HARVARD AVE, IRVINE, CA, 926142026-10-082026-11-09
doordashralphs irvine
35801601
17605 Harvard Ave, Irvine, CA, 9261433.67709, -117.833002026-10-082026-11-09
overtureRalphs
b2207473-6887-4c12-aa50-2363d2ef0391
17605 Harvard Ave, Irvine, CA, 92614949851316133.67708, -117.833052026-11-062026-11-06
ralphsRalphs
17605|92614
17605 Harvard Ave, Irvine, CA, 92614949851316133.67708, -117.833052026-11-102026-11-10
ubereatsFresh & Ready from Ralphs
KVjavtyxWjyABoWuiRiIkA
17605 Harvard Ave, Irvine, CA, 9261433.67711, -117.832792026-10-142026-11-13
ubereatsRalphs
UjwC-asBUo62vZKNoM73UQ
17605 Harvard Ave, Irvine, CA, 9261433.67702, -117.832832026-10-092026-11-09
vtinfoRALPHS FRESH FARE
37ccd3073e57f39e
17605 HARVARD AVE, IRVINE, CA, 92614949851316133.67713, -117.833162026-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 80ca-abc RALPHS 801.00one licence filemergedfile: 00407337 · same_address
ca-abc RALPHS 80overture cfa08474-4a6a-428d-acaa-d9516f25233e1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc RALPHS 80overture cfa08474-4a6a-428d-acaa-d9516f25233e1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash ralphs irvineoverture Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash ralphs irvineralphs Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash ralphs irvineubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 18 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 Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ralphs Ralphsubereats Ralphs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ca-abc RALPHS 80doordash ralphs irvine0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are Ralphs at the identical street address and ZIP (17605 Harvard Ave, Irvine 92614), and the DoorDash slug's city suffix matches; the off-sale licence is the store itself, and the names
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Ralphs same address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are Ralphs at the same street address and ZIP in Irvine; the CA ABC record's off-sale store licence (legal entity Ralphs Grocery Company) and the DoorDash 'ralphs irvine' listing are one store's own alcohol sales under the same banner, and the state rule treats this as the store's own department, though three businesses at the address lowers confidence slightly.
  • Claude Haiku 5.5, prompt v7: same, 87% confident — Both records are Ralphs at the same street address and ZIP in Irvine; the CA ABC licence is a Type 21 off-sale store licence under the Ralphs 80 store name, and the DoorDash listing is the same store's storefront, with the businesses-at-address count of 3 lowering confidence somewhat.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Both records give the same street address, city and ZIP (17605 Harvard Ave, Irvine 92614), and the names match as the Ralphs banner: the ABC off-sale store licence under 'RALPHS 80' and the DoorDash listing 'ralphs irvine'. Neither record names a suite, and the names agree despite the three businesses at the address.
pair 38b3632d955aba635745
ca-abc RALPHS 80ubereats Ralphs0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are the Ralphs chain at the identical street address 17605 Harvard Ave, Irvine 92614, and A's off-sale general licence is the store's own. Neither record names a suite, so the shared buil
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v9: same, 96% confident — The Ralphs chain store #80 off-sale licence and the Uber Eats Ralphs listing share the same street address and ZIP, so they are one store.
  • Claude Opus 5.5, prompt v8: same, 95% confident — Both records name the Ralphs chain at the identical street address and ZIP in Irvine; the CA licence 'RALPHS 80' is an off-sale store licence matching the Uber Eats Ralphs listing.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are the Ralphs store at 17605 Harvard Ave, Irvine 92614; the CA ABC off-sale licence on that address is the store's own liquor licence, and the Uber Eats listing is the same store's storefront, with the state rule treating the alcohol listing as the store's own department, though three businesses share the building, which lowers confidence somewhat.
  • Claude Haiku 5.5, prompt v4: same, 90% confident — Ralphs 80 is the Ralphs chain store with a store number, and the ABC off-sale grocery licence matches an Uber Eats Ralphs at the identical street address, city and ZIP; the names agree despite the three-business building, and no suite numbers conflict.
pair 4ca38a88f1c40a7ac80a
ca-abc RALPHS 80doordash ralphs irvine0.65Claude 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, 17605 Harvard Ave, Irvine 92614, and the off-sale licence fits a supermarket; the DoorDash slug is simply the chain name plus
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v8: same, 95% confident — Both are the Ralphs chain store at the identical street address 17605 Harvard Ave, Irvine 92614: an off-sale licence and the DoorDash storefront slug 'ralphs irvine', with the names agreeing despite the shared building.
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records are the Ralphs store at 17605 Harvard Ave, Irvine CA 92614, and the CA licence is a Type 21 off-sale for the store itself, with the DoorDash listing being the same store's alcohol storefront; the shared building (3 businesses) and the lack of a suite on either record lower confidence somewhat, but the chain name and exact street match support SAME.
pair c25994a1db045c77c0a0
ca-abc RALPHS 80ubereats Ralphs0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records name the same Ralphs chain store at an identical street address and ZIP (17605 Harvard Ave, Irvine 92614), and the CA off-sale general licence fits a supermarket, so the shared building d
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 94% confident — Ralphs same address, same chain
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are the Ralphs store at 17605 Harvard Ave, Irvine 92614: the CA off-sale licence (legal entity Ralphs Grocery Company, store '80') matches the Uber Eats Ralphs listing at the same street address and ZIP, and the California rule makes a chain store's alcohol listing its own department, so it is one outlet despite the three businesses at the address.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are the Ralphs store at 17605 Harvard Ave, Irvine 92614; the ABC record's off-sale general licence is the grocery store's alcohol sales, and under California's rule the chain store's alcohol listing is its own department at the same address, with matching chain and ZIP. Three businesses at the address lowers confidence somewhat, but the name and address match closely.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records sit at 17605 Harvard Ave, Irvine 92614, and the ABC off-sale general licence belongs to the Ralphs store (RALPHS 80 is a Ralphs store number), so the names agree with the chain banner at one premises; the tasting permit is only an add-on. Three businesses share the address, which lowers confidence somewhat, but no suite numbers conflict.
pair 1d01de0f218eb365f244
ca-abc RALPHS 80vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 0eb6b0d458893f9c4dbc · person: None · rule: names contained at one address · stratum: same-address
ca-abc RALPHS 80vtinfo RALPHS FRESH FARE0.45one name contains the other, same addressmergedjudge: None · pair_id: 0712cab08cdd17e75951 · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs irvinevtinfo RALPHS FRESH FARE0.43one name contains the other, same addressmergedjudge: None · pair_id: 832065b875f4aa9b2e44 · 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: 671ba05d46429c5ff7df · person: None · rule: names contained at one address · stratum: same-address
doordash ralphs irvineubereats Fresh & Ready from Ralphs0.35Claude 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 (17605 Harvard Ave, Irvine, 0.02 km apart), and 'Fresh & Ready from Ralphs' reads as a second delivery-app listing of that same store,
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 72% confident — Both records are Ralphs at the identical street address and ZIP, 0.02 km apart, with the same chain; 'Fresh & Ready from Ralphs' reads as Ralphs' own prepared-food listing, a department of one store rather than a separate company's concession, though the three businesses at this address leave some doubt.
pair bdbb54838e530fb27da0
ca-abc RALPHS 80ubereats Fresh & Ready from Ralphs0.32Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records are Ralphs at the identical street address 17605 Harvard Ave, Irvine 92614. 'Fresh & Ready from Ralphs' reads as the store's own Uber Eats listing rather than a separately run concession,
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 70% confident — Both records sit at the same street address, ZIP and city and belong to the Ralphs chain; the ABC record is Ralphs 80's off-sale store licence and the Uber Eats listing reads as Ralphs' own prepared-food/grocery storefront, which fits one operation with a second listing. The shared building (3 businesses) and the 'Fresh & Ready' wording leave some doubt that it is a separately run concession.
pair c602470998cbfab4f6fb
ca-abc RALPHS 80ubereats Fresh & Ready from Ralphs0.32Claude 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 same street and ZIP (17605 Harvard Ave, Irvine 92614), and 'Fresh & Ready from Ralphs' is an Uber Eats storefront for that store's grocery, which the off-sale
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 — Ralphs store at 17605 Harvard Ave, Irvine 92614 matches the Uber Eats listing 'Fresh & Ready from Ralphs', which is the store's own prepared-food department of the same chain at the same address, and the CA off-sale licence is the store's licence; the shared building (3 businesses) is offset by the chain-department match at the identical address and city.
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records sit at 17605 Harvard Ave, Irvine 92614, and both belong to the Ralphs chain; the CA rule treats a chain store's alcohol licence as the store's own department, so the Uber Eats 'Fresh & Ready from Ralphs' listing most likely belongs to the same Ralphs store. Three businesses share the address and the Fresh & Ready name is distinct, which keeps confidence moderate.
  • Claude Haiku 5.5, prompt v4: different, 70% confident — Both records sit at 17605 Harvard Ave in Irvine, but the address is shared by three businesses, and the names don't clearly agree. The ABC record is the Ralphs 80 liquor store, while the Uber Eats listing is 'Fresh & Ready from Ralphs', which reads as a separate food concept or concession operating inside the store rather than the same liquor outlet.
pair 125712199aaaefdd49f0

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

Trade area

Other outlets
108 within 1 mi · 764 within 3 mi
Off / on premise
18 / 55 within 1 mi · 119 / 364 within 3 mi
Selling alcohol
62 within 1 mi · 425 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
urban (5,625 people per sq mi)
People within 3 mi
159,057 (113,467 adults 21+, 56,740 households) from 28 tract(s), tracts within 3 mi
Income
per capita $57,512 · median household ~$127,115 (weighted mean of tract medians)
Age and education
median age ~34.4 · bachelor's or higher 65%
Ethnicity
Hispanic 17% · White 39% · Black 3% · Asian 35%
Adults per alcohol outlet
266
Alcohol spend within 3 mi
$50,785,784 a year ($21,957,087 at home, $28,808,372 away) · $119,215 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 35801601 ↔ vtinfo 37ccd3073e57f39eone name contains the other, same addressmerged15
2026-11-16 14:56insertubereats UjwC-asBUo62vZKNoM73UQ ↔ vtinfo 37ccd3073e57f39eone name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407337|86|LIC|0 ↔ vtinfo 37ccd3073e57f39eone name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00407337|21|LIC|0 ↔ vtinfo 37ccd3073e57f39eone name contains the other, same addressmerged15
2026-11-13 14:10updateca-abc 00407337|21|LIC|0 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: samemerged15
2026-11-13 14:10updateca-abc 00407337|86|LIC|0 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: samemerged15
2026-11-13 14:10updatedoordash 35801601 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: samemerged15
2026-11-10 17:05insertoverture b2207473-6887-4c12-aa50-2363d2ef0391 ↔ ralphs 17605|92614same address and namemerged12
2026-11-10 17:05insertdoordash 35801601 ↔ ralphs 17605|92614same address and namemerged12
2026-11-10 17:05insertralphs 17605|92614 ↔ ubereats UjwC-asBUo62vZKNoM73UQsame address and namemerged12
2026-11-09 15:32updatedoordash 35801601 ↔ overture b2207473-6887-4c12-aa50-2363d2ef0391same address and namemerged11
2026-11-09 15:32updateoverture b2207473-6887-4c12-aa50-2363d2ef0391 ↔ ubereats UjwC-asBUo62vZKNoM73UQsame address and namemerged11
2026-11-06 18:13insertca-abc 00407337|86|LIC|0 ↔ overture cfa08474-4a6a-428d-acaa-d9516f25233esame address and namemerged11
2026-11-06 18:13insertdoordash 35801601 ↔ overture b2207473-6887-4c12-aa50-2363d2ef0391same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture b2207473-6887-4c12-aa50-2363d2ef0391 ↔ ubereats UjwC-asBUo62vZKNoM73UQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00407337|21|LIC|0 ↔ overture cfa08474-4a6a-428d-acaa-d9516f25233esame address and namemerged11
2026-11-02 23:02backfillca-abc 00407337|21|LIC|0 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407337|86|LIC|0 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfilldoordash 35801601 ↔ ubereats KVjavtyxWjyABoWuiRiIkAClaude judge: sameheld: same-source-conflict
2026-11-02 23:02backfillca-abc 00407337|86|LIC|0 ↔ doordash 35801601Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407337|21|LIC|0 ↔ ubereats UjwC-asBUo62vZKNoM73UQClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00407337|21|LIC|0 ↔ doordash 35801601Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00407337|86|LIC|0 ↔ ubereats UjwC-asBUo62vZKNoM73UQClaude judge: samemerged
2026-10-09 13:59backfilldoordash 35801601 ↔ ubereats UjwC-asBUo62vZKNoM73UQsame address and namemerged
2026-10-09 13:59backfillca-abc 00407337|21|LIC|0 ↔ ca-abc 00407337|86|LIC|0one licence filemerged