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.

FieldMaster valueTaken fromWhat 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-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94124
ca-abcno other value
Pin
37.72993, -122.39886 map
doordashno other value
Phone
4153301870
vtinfono 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevFOODSCO
70287
345 WILLIAMS AVE, SAN FRANCISCO, CA, 9412437.73016, -122.399342026-11-132026-11-13
ca-abcFOODS CO #351
legal name: RALPHS GROCERY COMPANY
00538243|21|LIC|0
345 WILLIAMS AVE, SAN FRANCISCO, CA, 9412437.73007, -122.398712026-10-082026-11-12
doordashfoods co san francisco
35800023
345 Williams Ave, San Francisco, CA, 9412437.72993, -122.398862026-10-082026-11-12
overtureFoods Co.
cf9d6731-1870-4692-bc99-006eb6a0c61f
345 Williams Ave, San Francisco, CA, 94124415330187037.72989, -122.399042026-11-062026-11-12
vtinfoFOODSCO
2f1e874d2d050f75
345 WILLIAMS AVE, SAN FRANCISCO, CA, 94124415330187037.72984, -122.398792026-11-122026-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 FOODS CO #351overture 5b7d5602-fed6-4fb1-af02-b918a5637e5e1.00same address and nameheld same-source-conflictaddress 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 FOODSCOvtinfo FOODSCO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00
doordash foods co san franciscooverture Foods Co.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc FOODS CO #351doordash foods co san francisco0.61Claude judge: samemerged
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:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same street address, city and ZIP (345 Williams Ave, San Francisco 94124), the building holds only this one business, and the name 'FOODS CO #351' matches the DoorDash slug 'foods co san francisco' as a Foods Co store, with the coordinates about 21 m apart.
pair af497f2501b345b89ae4
ab-inbev FOODSCOdoordash foods co san francisco0.42same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 49 m apart · name similarity 0.42
ab-inbev FOODSCOoverture Foods Co.0.42same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 40 m apart · name similarity 0.42
doordash foods co san franciscovtinfo FOODSCO0.42same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 12 m apart · name similarity 0.42
overture Foods Co.vtinfo FOODSCO0.42same address and namemergedaddress 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”).
WhenEventPairRuleDecisionRule version
2026-11-13 17:47insertab-inbev 70287 ↔ doordash 35800023same address and namemerged15
2026-11-13 17:47insertab-inbev 70287 ↔ overture cf9d6731-1870-4692-bc99-006eb6a0c61fsame address and namemerged15
2026-11-13 17:47insertab-inbev 70287 ↔ vtinfo 2f1e874d2d050f75same address and namemerged15
2026-11-12 14:25insertoverture cf9d6731-1870-4692-bc99-006eb6a0c61f ↔ vtinfo 2f1e874d2d050f75same address and namemerged12
2026-11-12 14:25insertdoordash 35800023 ↔ vtinfo 2f1e874d2d050f75same address and namemerged12
2026-11-06 18:13insertca-abc 00538243|21|LIC|0 ↔ overture 5b7d5602-fed6-4fb1-af02-b918a5637e5esame address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 35800023 ↔ overture cf9d6731-1870-4692-bc99-006eb6a0c61fsame address and namemerged11
2026-11-02 23:02backfillca-abc 00538243|21|LIC|0 ↔ doordash 35800023Claude judge: samemerged