Outlets /
Foodsco
OAKLAND, CA 94605 · O2467ead021ea · first seen 2026-10-08
5 sourcesoff premisealcohol: 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 | Foodsco 4 other | a licence name in capitals, cleaned (derived; record_title.py) | FOODS CO #534 ca-abc foods co oakland doordash Foods Co. overture RALPHS GROCERY COMPANY ca-abc (legal name) |
| Street | 10790 MACARTHUR BLVD | ca-abc | no other value |
| City | OAKLAND | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94605 | ca-abc | no other value |
| Pin | 37.74299, -122.14861 map 3 other | doordash | 230 m away ab-inbev 198 m away ca-abc 222 m away vtinfo |
| Phone | 9253833666 1 other | vtinfo | 5109243060 overture |
| Licences | ca-abc 00504392|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ob4fdb5db73c2; O8a6cee7e8c42; Oede989957ffa; Oaf4b66cf7791
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 | FOODSCO 4715203 | 10790 MACARTHUR BLVD, OAKLAND, CA, 94605 | 37.74198, -122.15089 | 2026-11-11 | 2026-11-11 | |
| ca-abc | FOODS CO #534 legal name: RALPHS GROCERY COMPANY 00504392|21|LIC|0 | 10790 MACARTHUR BLVD, OAKLAND, CA, 94605 | 37.74164, -122.15007 | 2026-10-08 | 2026-11-11 | |
| doordash | foods co oakland 35800333 | 10790 Macarthur Blvd, Oakland, CA, 94605 | 37.74299, -122.14861 | 2026-10-08 | 2026-11-11 | |
| overture | Foods Co. 0710b070-1e2f-4ebb-b191-13d9d9abe67e | 10790 MacArthur Blvd, Oakland, CA, 94605 | 5109243060 | 37.74305, -122.14857 | 2026-11-06 | 2026-11-11 |
| vtinfo | FOODSCO b4a9c1a3130bda77 | 10790 MACARTHUR BLVD, OAKLAND, CA, 94605 | 9253833666 | 37.74205, -122.15084 | 2026-11-12 | 2026-11-14 |
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 FOODSCO | vtinfo FOODSCO | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 |
| doordash foods co oakland | overture Foods Co. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| ca-abc FOODS CO #534 | doordash foods co oakland | 0.61 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Both records are the Foods Co chain store at the same street address and ZIP (10790 MacArthur Blvd, Oakland 94605), and only one business is known at that address. Other Claude answers on this pair:
pair 308366d540fdb16ffb63 |
| ab-inbev FOODSCO | doordash foods co oakland | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 230 m apart · name similarity 0.42 |
| ab-inbev FOODSCO | overture Foods Co. | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 236 m apart · name similarity 0.42 |
| doordash foods co oakland | vtinfo FOODSCO | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 222 m apart · name similarity 0.42 |
| overture Foods Co. | vtinfo FOODSCO | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 228 m apart · name similarity 0.42 · phone: differs |
| ab-inbev FOODSCO | ca-abc FOODS CO #534 | 0.31 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair) Foods Co same address, name variant Other Claude answers on this pair:
pair 44a9a7807b001fd3fbe2 |
Attributes
- Channel
- off_premise — ca-licence
- Chain
- none
- 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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 55 within 1 mi · 561 within 3 mi
- Off / on premise
- 21 / 31 within 1 mi · 163 / 302 within 3 mi
- Selling alcohol
- 33 within 1 mi · 307 within 3 mi
- Nearest
- same channel 0.16 mi · licensed 0.16 mi
- Setting
- urban (6,046 people per sq mi)
- People within 3 mi
- 170,940 (127,618 adults 21+, 58,168 households) from 38 tract(s), tracts within 3 mi
- Income
- per capita $43,518 · median household ~$99,406 (weighted mean of tract medians)
- Age and education
- median age ~38.3 · bachelor's or higher 31%
- Ethnicity
- Hispanic 42% · White 17% · Black 23% · Asian 16%
- Adults per alcohol outlet
- 414
- Alcohol spend within 3 mi
- $43,496,902 a year ($19,381,232 at home, $24,098,417 away) · $141,224 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ab-inbev 4715203 ↔ ca-abc 00504392|21|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | overture 0710b070-1e2f-4ebb-b191-13d9d9abe67e ↔ vtinfo b4a9c1a3130bda77 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 35800333 ↔ vtinfo b4a9c1a3130bda77 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 4715203 ↔ vtinfo b4a9c1a3130bda77 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00504392|21|LIC|0 ↔ doordash 35800333 | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4715203 ↔ doordash 35800333 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4715203 ↔ overture 0710b070-1e2f-4ebb-b191-13d9d9abe67e | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 35800333 ↔ overture 0710b070-1e2f-4ebb-b191-13d9d9abe67e | same address and name | merged | 11 |