Outlets /
Foodsco
SAN FRANCISCO, CA 94124 · O020ba3679262 · 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 #351 ca-abc foods co san francisco doordash Foods Co. overture RALPHS GROCERY COMPANY ca-abc (legal name) |
| Street | 345 WILLIAMS AVE | ca-abc | no other value |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94124 | ca-abc | no other value |
| Pin | 37.72993, -122.39886 map | doordash | no other value |
| Phone | 4153301870 | vtinfo | no other value |
| Licences | ca-abc 00538243|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O84d191e5ff72; O4d38ef3e924c; O267a9c5664f0; O10a32fdabd20
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 70287 | 345 WILLIAMS AVE, SAN FRANCISCO, CA, 94124 | 37.73016, -122.39934 | 2026-11-13 | 2026-11-13 | |
| ca-abc | FOODS CO #351 legal name: RALPHS GROCERY COMPANY 00538243|21|LIC|0 | 345 WILLIAMS AVE, SAN FRANCISCO, CA, 94124 | 37.73007, -122.39871 | 2026-10-08 | 2026-11-12 | |
| doordash | foods co san francisco 35800023 | 345 Williams Ave, San Francisco, CA, 94124 | 37.72993, -122.39886 | 2026-10-08 | 2026-11-12 | |
| overture | Foods Co. cf9d6731-1870-4692-bc99-006eb6a0c61f | 345 Williams Ave, San Francisco, CA, 94124 | 4153301870 | 37.72989, -122.39904 | 2026-11-06 | 2026-11-12 |
| vtinfo | FOODSCO 2f1e874d2d050f75 | 345 WILLIAMS AVE, SAN FRANCISCO, CA, 94124 | 4153301870 | 37.72984, -122.39879 | 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 |
|---|---|---|---|---|---|
| ca-abc FOODS CO #351 | overture 5b7d5602-fed6-4fb1-af02-b918a5637e5e | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · matched through the licence's legal name: RALPHS GROCERY COMPANY · name similarity 1.00 |
| 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 60 m apart · name similarity 1.00 |
| doordash foods co san francisco | overture Foods Co. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 |
| ca-abc FOODS CO #351 | doordash foods co san francisco | 0.61 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Both records name the same chain store (Foods Co) at the identical street address and ZIP, and only one business is known at that address. Other Claude answers on this pair:
pair af497f2501b345b89ae4 |
| ab-inbev FOODSCO | doordash foods co san francisco | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 49 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 40 m apart · name similarity 0.42 |
| doordash foods co san francisco | vtinfo FOODSCO | 0.42 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 12 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 23 m apart · name similarity 0.42 · phone: equal |
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
- 285 within 1 mi · 1,955 within 3 mi
- Off / on premise
- 53 / 126 within 1 mi · 337 / 1,182 within 3 mi
- Selling alcohol
- 129 within 1 mi · 1,224 within 3 mi
- Nearest
- same channel 0.23 mi · licensed 0.28 mi
- Setting
- urban (10,022 people per sq mi)
- People within 3 mi
- 283,361 (229,899 adults 21+, 107,343 households) from 77 tract(s), tracts within 3 mi
- Income
- per capita $83,101 · median household ~$157,516 (weighted mean of tract medians)
- Age and education
- median age ~41.2 · bachelor's or higher 53%
- Ethnicity
- Hispanic 23% · White 33% · Black 6% · Asian 35%
- Adults per alcohol outlet
- 188
- Alcohol spend within 3 mi
- $106,585,641 a year ($45,174,358 at home, $61,380,616 away) · $87,009 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-13 17:47 | insert | ab-inbev 70287 ↔ doordash 35800023 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 70287 ↔ overture cf9d6731-1870-4692-bc99-006eb6a0c61f | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 70287 ↔ vtinfo 2f1e874d2d050f75 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | overture cf9d6731-1870-4692-bc99-006eb6a0c61f ↔ vtinfo 2f1e874d2d050f75 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 35800023 ↔ vtinfo 2f1e874d2d050f75 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00538243|21|LIC|0 ↔ overture 5b7d5602-fed6-4fb1-af02-b918a5637e5e | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | doordash 35800023 ↔ overture cf9d6731-1870-4692-bc99-006eb6a0c61f | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00538243|21|LIC|0 ↔ doordash 35800023 | Claude judge: same | merged |