Outlets /
Ralphs
Seal Beach, CA 90740 · O20809ce43d73 · first seen 2026-10-08
7 sourcesoff premise · grocerychain: Ralphsalcohol: licensed1 licence
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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Ralphs 7 other | the most common name a source states | RALPHS FRESH FARE ab-inbevvtinfo ×2 Bloom Haus by Ralphs ubereats bloom haus by ralphs seal beach doordash Fresh & Ready From Ralphs ubereats RALPHS 604 ca-abc RALPHS GROCERY COMPANY ca-abc (legal name) ralphs seal beach doordash |
| Street | 12470 Seal Beach Blvd | ralphs | no other value |
| City | Seal Beach | ralphs | no other value |
| State | CA | ralphs | no other value |
| ZIP | 90740 | ralphs | no other value |
| Pin | 33.78109, -118.06973 map 1 other | ralphs | 197 m away ca-abc |
| Phone | 5625983128 | ralphs | no other value |
| Licences | ca-abc 00407468|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O5075232dc610; O720e91ca7f02; Ocdec6f3a9508; O31a7327eb217; O423da5e0821f; O9e628767d7c4; Oda65f13df684; O291b0e28bd0b; O6d58d64417b6
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | RALPHS FRESH FARE 72410 | 12470 SEAL BEACH BLVD, SEAL BEACH, CA, 90740 | 33.78106, -118.06967 | 2026-11-11 | 2026-11-16 | |
| ca-abc | RALPHS 604 legal name: RALPHS GROCERY COMPANY 00407468|21|LIC|0 | 12470 SEAL BEACH BLVD, SEAL BEACH, CA, 90740 | 33.78092, -118.07184 | 2026-10-08 | 2026-11-13 | |
| doordash | bloom haus by ralphs seal beach 24199809 | 12470 Seal Beach Blvd, Seal Beach, CA, 90740 | 33.78122, -118.06988 | 2026-10-08 | 2026-11-03 | |
| doordash | ralphs seal beach 35800672 | 12470 Seal Beach Blvd, Seal Beach, CA, 90740 | 33.78113, -118.06985 | 2026-10-08 | 2026-11-13 | |
| overture | Ralphs 84a76ff6-961a-4c2f-a096-3e6829bceb5b | 12470 Seal Beach Blvd, Seal Beach, CA, 90740 | 5625983128 | 33.78109, -118.06973 | 2026-11-06 | 2026-11-13 |
| ralphs | Ralphs 12470|90740 | 12470 Seal Beach Blvd, Seal Beach, CA, 90740 | 5625983128 | 33.78109, -118.06973 | 2026-11-10 | 2026-11-13 |
| ubereats | Bloom Haus by Ralphs Xgd_yIdkVAKul0DuMSj-7g | 12470 SEal Beach Blvd, Seal Beach, CA, 90740 | 33.78126, -118.06993 | 2026-10-28 | 2026-11-03 | |
| ubereats | Fresh & Ready From Ralphs -ZUAGc3oWFCkSZnmaCtNnQ | 12470 SEal Beach Blvd, Seal Beach, CA, 90740 | 33.78104, -118.06950 | 2026-10-27 | 2026-11-13 | |
| vtinfo | RALPHS FRESH FARE 5fe23d03c6161c98 | 12470 SEAL BEACH BLVD, SEAL BEACH, CA, 90740 | 5625983128 | 33.78104, -118.06950 | 2026-11-12 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev RALPHS FRESH FARE | vtinfo RALPHS FRESH FARE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00 |
| ca-abc RALPHS 604 | overture a6cc2e7a-6055-4779-b1af-a0aa1ea7a762 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 150 m apart · name similarity 1.00 |
| doordash bloom haus by ralphs seal beach | ubereats Bloom Haus by Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 |
| doordash ralphs seal beach | overture Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| doordash ralphs seal beach | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| overture Ralphs | ralphs Ralphs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal |
| ca-abc RALPHS 604 | doordash ralphs seal beach | 0.62 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) Both records name the Ralphs chain at the identical street address and ZIP in Seal Beach (the DoorDash slug is just chain plus city), and the off-sale licence matches a supermarket, so the shared buil Other Claude answers on this pair:
pair 719710afdda4ae7fa4f1 |
| ab-inbev RALPHS FRESH FARE | ca-abc RALPHS 604 | 0.45 | one name contains the other, same address | merged | judge: None · pair_id: 6a25429e34857bdd97a0 · person: None · rule: names contained at one address · stratum: same-address |
| ca-abc RALPHS 604 | vtinfo RALPHS FRESH FARE | 0.45 | one name contains the other, same address | merged | judge: None · pair_id: 75136e6ee2ca2e959ee2 · person: None · rule: names contained at one address · stratum: same-address |
| ab-inbev RALPHS FRESH FARE | doordash ralphs seal beach | 0.43 | one name contains the other, same address | merged | judge: None · pair_id: 923450921c6418e63b4f · person: None · rule: names contained at one address · stratum: same-address |
| doordash ralphs seal beach | vtinfo RALPHS FRESH FARE | 0.43 | one name contains the other, same address | merged | judge: None · pair_id: 9c0e7c5d1a6432a5d604 · person: None · rule: names contained at one address · stratum: same-address |
| doordash ralphs seal beach | ubereats Fresh & Ready From Ralphs | 0.38 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair) Both records are the Ralphs store at 12470 Seal Beach Blvd, 90740, and 'Fresh & Ready From Ralphs' is the store's own Uber Eats listing, not a separate business, even though four businesses share the Other Claude answers on this pair:
pair db7c7ae23eff75061013 |
| ca-abc RALPHS 604 | doordash bloom haus by ralphs seal beach | 0.36 | Claude judge: same | merged | 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:
pair 32e16f7866ec401e87f9 |
| doordash ralphs seal beach | ubereats Bloom Haus by Ralphs | 0.36 | Claude judge: same | merged | 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:
pair 0db8cbe1578c7a15ccaf |
| ca-abc RALPHS 604 | ubereats Fresh & Ready From Ralphs | 0.31 | Claude judge: same | merged | 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 and ZIP, and 'Fresh & Ready From Ralphs' is an Uber Eats listing of the same Ralphs store, not a separately licensed premises. Other Claude answers on this pair:
pair 8c82609f91c8a16b411d |
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_off, wine_off, spirits_off — CA 21
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",
"non_beverage",
"florist"
],
[
"ubereats-type",
"off_premise",
"specialty_food"
],
[
"doordash-url",
"off_premise",
null
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 36 within 1 mi · 388 within 3 mi
- Off / on premise
- 12 / 17 within 1 mi · 103 / 207 within 3 mi
- Selling alcohol
- 25 within 1 mi · 254 within 3 mi
- Nearest
- same channel none within 3 mi · licensed 0.03 mi
- Setting
- urban (4,063 people per sq mi)
- People within 3 mi
- 114,870 (87,703 adults 21+, 43,116 households) from 33 tract(s), tracts within 3 mi
- Income
- per capita $60,738 · median household ~$131,937 (weighted mean of tract medians)
- Age and education
- median age ~46.5 · bachelor's or higher 51%
- Ethnicity
- Hispanic 19% · White 59% · Black 2% · Asian 18%
- Adults per alcohol outlet
- 344
- Alcohol spend within 3 mi
- $39,068,028 a year ($16,913,334 at home, $22,141,253 away) · $153,208 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-16 14:56 | insert | doordash 35800672 ↔ vtinfo 5fe23d03c6161c98 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 72410 ↔ doordash 35800672 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ca-abc 00407468|21|LIC|0 ↔ vtinfo 5fe23d03c6161c98 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 72410 ↔ ca-abc 00407468|21|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-13 14:10 | update | doordash 35800672 ↔ ubereats Xgd_yIdkVAKul0DuMSj-7g | Claude judge: same | merged | 15 |
| 2026-11-13 14:10 | update | ca-abc 00407468|21|LIC|0 ↔ doordash 24199809 | Claude judge: same | merged | 15 |
| 2026-11-12 17:29 | insert | doordash 35800672 ↔ ubereats Xgd_yIdkVAKul0DuMSj-7g | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 17:29 | insert | ca-abc 00407468|21|LIC|0 ↔ doordash 24199809 | Claude judge: same | held: same-source-conflict | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 72410 ↔ vtinfo 5fe23d03c6161c98 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | overture 84a76ff6-961a-4c2f-a096-3e6829bceb5b ↔ ralphs 12470|90740 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 35800672 ↔ ralphs 12470|90740 | same address and name | merged | 12 |
| 2026-11-09 15:32 | update | doordash 35800672 ↔ overture 84a76ff6-961a-4c2f-a096-3e6829bceb5b | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 35800672 ↔ overture 84a76ff6-961a-4c2f-a096-3e6829bceb5b | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00407468|21|LIC|0 ↔ overture a6cc2e7a-6055-4779-b1af-a0aa1ea7a762 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00407468|21|LIC|0 ↔ ubereats -ZUAGc3oWFCkSZnmaCtNnQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 35800672 ↔ ubereats -ZUAGc3oWFCkSZnmaCtNnQ | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00407468|21|LIC|0 ↔ doordash 35800672 | Claude judge: same | merged | |
| 2026-10-28 02:02 | backfill | doordash 24199809 ↔ ubereats Xgd_yIdkVAKul0DuMSj-7g | same address and name | merged |