Foodsco

SAN FRANCISCO, CA 94103 · O12c34dd658bf · 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 357 ca-abc
foods co san francisco doordash
Foods Co. overture
RALPHS GROCERY COMPANY ca-abc (legal name)
Street
1800 FOLSOM ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.76790, -122.41622 map 2 other
doordash
79 m away ab-inbev
79 m away ca-abc
Phone
4155589137
vtinfono other value
Licences
ca-abc 00407198|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of36b6e385c02; O461a19c7218c; O4091eca1eb85; O5516e808f35b

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
70282
1800 FOLSOM ST, SAN FRANCISCO, CA, 9410337.76738, -122.415612026-11-132026-11-13
ca-abcFOODS CO 357
legal name: RALPHS GROCERY COMPANY
00407198|21|LIC|0
1800 FOLSOM ST, SAN FRANCISCO, CA, 9410337.76848, -122.415682026-10-082026-11-06
doordashfoods co san francisco
35799803
1800 Folsom St, San Francisco, CA, 9410337.76790, -122.416222026-10-082026-11-06
overtureFoods Co.
9d24f0c5-5585-4836-9e65-b876bc1b0d02
1800 Folsom St, San Francisco, CA, 94103415558913737.76775, -122.416112026-11-062026-11-06
vtinfoFOODSCO
63933b4ff0fc8654
1800 FOLSOM ST, SAN FRANCISCO, CA, 94103415558913737.76763, -122.415852026-11-112026-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
ab-inbev FOODSCOvtinfo FOODSCO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 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 20 m apart · name similarity 1.00
ca-abc FOODS CO 357doordash foods co san francisco0.61Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (94% confident; asked as a “near” pair)
The FoodsCo store #357 licence and the DoorDash 'foods co san francisco' listing share the same street address and ZIP (1800 Folsom St, 94103), our data holds only one business there, and the licence
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records share the same street address, ZIP and city, and the DoorDash listing 'foods co san francisco' matches the Foods Co store at 1800 Folsom St, with the CA ABC record showing an active off-sale liquor licence at that single-business address.
  • Claude Haiku 5.5, prompt v4: same, 87% confident — Both records give the same street address and ZIP (1800 Folsom St, 94103), and the only business there is the Foods Co banner; the ABC name 'FOODS CO 357' is the same chain store with its store number, matching the DoorDash slug 'foods co san francisco'.
pair 53266e357b70759bc889
ab-inbev FOODSCOdoordash foods co san francisco0.42same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 79 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 60 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 44 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 26 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
1,288 within 1 mi · 6,247 within 3 mi
Off / on premise
163 / 815 within 1 mi · 848 / 3,908 within 3 mi
Selling alcohol
782 within 1 mi · 3,857 within 3 mi
Nearest
same channel 0.11 mi · licensed 0.07 mi
Setting
urban (18,986 people per sq mi)
People within 3 mi
536,825 (462,610 adults 21+, 258,662 households) from 167 tract(s), tracts within 3 mi
Income
per capita $104,543 · median household ~$154,548 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 65%
Ethnicity
Hispanic 16% · White 45% · Black 5% · Asian 29%
Adults per alcohol outlet
120
Alcohol spend within 3 mi
$249,430,040 a year ($105,870,233 at home, $143,484,183 away) · $64,653 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 70282 ↔ doordash 35799803same address and namemerged15
2026-11-13 17:47insertab-inbev 70282 ↔ overture 9d24f0c5-5585-4836-9e65-b876bc1b0d02same address and namemerged15
2026-11-13 17:47insertab-inbev 70282 ↔ vtinfo 63933b4ff0fc8654same address and namemerged15
2026-11-11 12:56insertdoordash 35799803 ↔ vtinfo 63933b4ff0fc8654same address and namemerged12
2026-11-11 12:56insertoverture 9d24f0c5-5585-4836-9e65-b876bc1b0d02 ↔ vtinfo 63933b4ff0fc8654same address and namemerged12
2026-11-06 18:13insertdoordash 35799803 ↔ overture 9d24f0c5-5585-4836-9e65-b876bc1b0d02same address and namemerged11
2026-11-02 23:02backfillca-abc 00407198|21|LIC|0 ↔ doordash 35799803Claude judge: samemerged