OFARRELL LIQUORS

SAN FRANCISCO, CA 94102 · O127427365e44 · first seen 2026-10-08
5 sourcesoff premise · conveniencealcohol: licensed1 licence40 products on the shelf

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
OFARRELL LIQUORS 3 other
the most common name a source states
GAUTAM AMAR ca-abc (legal name)
o'farrell liquor san francisco doordash
O'Farrell Liquors overture
Street
405 OFARRELL ST 2 other
ca-abc
405 O'Farrell St overture
405 O'Farrell Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94102
ca-abcno other value
Pin
37.78597, -122.41154 map 1 other
doordash
62 m away ab-inbev
Phone
4159212256
vtinfono other value
Licences
ca-abc 00384188|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob780b771e1e3; O23b382e5d59c; Of2bc04d6b722; Ob312a3aa54b2

Carries

Products seen on this outlet’s shelf in store-level catalogs.

40products placed
134listings
94listings with no product match yet
doordashfrom
Showing 60 of 134 listings: matched products first.
ProductSourcePriceStockSeen
Casamigos 80 Proof Blanco Tequila Bottle (750 ml)
Casamigos · 750
doordash$75.99—2026-11-09
Golden Road Brewing Mango Cart Wheat Ale Can (12 fl oz)
Golden Road Brewing · 72
doordash$17.99—2026-11-09
Stone Delicious IPA
Stone Brewing · 72
doordash$17.99—2026-11-09
Don Julio 80 Proof Reposado Tequila Bottle (750 ml)
750
doordash$86.99—2026-11-09
Joel Gott Sauvignon Blanc California White Wine, 750 ml
Joel Gott Wines · 1.0
doordash$22.99—2026-11-09
Bread & Butter Wines Chardonnay Bottle California (750 ml)
Bread & Butter · 750
doordash$20.99—2026-11-09
Svedka 80 Proof Vodka (750 ml)
Svedka · 750
doordash$23.99—2026-11-09
Lagunitas Brewing Company A Little Sumpin' Sumpin' Smooth & Silky IPA Bottles (12 fl oz x 12 ct)
Lagunitas Brewing Company · 144
doordash$30.99—2026-11-09
Elysian Brewing Space Dust Craft IPA Bottle (12 fl oz)
Elysian Brewing · 12
doordash$5.99—2026-11-09
Four Loko Fruit Punch Malt Beverage Can (23.5 fl oz)
Four Loko · 23.5
doordash$5.99—2026-11-09
Espolon 80 Proof 100% Puro Agave Reposado Tequila Bottle (750 ml)
750
doordash$51.99—2026-11-09
Cupcake Vineyards d'Asti Italy Moscato Bottle (750 ml)
Cupcake · 750
doordash$17.99—2026-11-09
Lagavulin Distillery 86 Proof Islay Single Malt 16 Year Scotch Whisky Bottle (750 ml)
750
doordash$125.99—2026-11-09
Fort Point KSA Kolsch Style Ale Can (12 oz)
12
doordash$18.99—2026-11-09
Mike's Hard Lemonade Classic Lime Margarita Bottles (11 oz x 6 ct)
11.2
doordash$16.99—2026-11-09
Golden State Bay Cider Brut Can (19.2 oz)
Golden State Cider · 19.2
doordash$20.99—2026-11-09
Bacardí Gluten Free 80 Proof Gold Rum Bottle (750 ml)
750
doordash$26.99—2026-11-09
Bear Republic Brewing Company Racer 5 IPA Bottles (12 fl oz x 12 ct)
Bear Republic Brewing Co. · 144
doordash$30.99—2026-11-09
Hoegaarden Original Belgian Wheat Beer Bottles (11.2 fl oz x 12 ct)
Hoegaarden Brewery · 134.4
doordash$30.99—2026-11-09
Heineken 0.0 Alcohol Free Malt Beverage Bottle (11.2 fl oz)
11.2
doordash$16.99—2026-11-09
Macallan 86 Proof Double Cask Highland & Single Malt 12 Year Scotch Whisky Bottle (750 ml)
The Macallan · 750
doordash$125.99—2026-11-09
White Claw Gluten Free Hard Seltzer Variety Pack No. 3 (12 fl oz × 12 ct)
144
doordash$30.99—2026-11-09
Jose Cuervo Especial 80 Proof Blue Agave Gold Tequila Bottle (750 ml)
Jose Cuervo · 750
doordash$29.99—2026-11-09
Espolon 80 Proof Blanco Tequila Bottle (750 ml)
Espolon · 750
doordash$48.99—2026-11-09
Bread & Butter Wines Cabernet Sauvignon Bottle California (750 ml)
Bread & Butter · 750
doordash$20.99—2026-11-09
Bogle Vineyards California 2017 Cabernet Sauvignon Bottle (750 ml)
750
doordash$17.99—2026-11-09
White Claw No. 1 Hard Seltzer Variety Pack (12 fl oz × 12 ct)
144
doordash$30.99—2026-11-09
Line 39 Cabernet Sauvignon Bottle California (750 ml)
Line 39 · 750
doordash$17.99—2026-11-09
Joel Gott Wines 815 Cabernet Sauvignon Bottle California (750 ml)
Joel Gott Wines · 750
doordash$24.99—2026-11-09
Francis Coppola Chardonnay Bottle Sonoma County (750 ml)
750
doordash$23.99—2026-11-09
Alamos Malbec Bottle Argentina (750 ml)
750
doordash$17.99—2026-11-09
White Claw Mango
White Claw · 2130
doordash$16.99—2026-11-09
Kim Crawford Marlborough New Zealand Sauvignon Blanc Bottle (750 ml)
Kim Crawford · 750
doordash$32.99—2026-11-09
Line 39 Chardonnay Bottle (24 fl oz)
Line 39 · 24
doordash$17.99—2026-11-09
Tito's Gluten-Free 80 Proof Handmade Vodka Bottle (750 ml)
TITOS · 750
doordash$36.99—2026-11-09
Svedka Vodka 80 Proof (1.75 L)
Svedka · 1.75
doordash$42.99—2026-11-09
Bombay Sapphire 94 Proof Imported Infused Distilled London Dry Gin Bottle (750 ml)
750
doordash$42.99—2026-11-09
Stella Artois Premium Lager Bottles (11.2 fl oz x 6 ct)
Stella Artois · 67.2
doordash$16.99—2026-11-09
Peroni Nastro Azzurro Lager Beer, 12 Pack, 11.2 fl. oz. Bottles, 5.1% ABV
Peroni · 1.0
doordash$29.99—2026-11-09
Firestone Walker Brewing Company 805 Golden Ale Bottles (12 fl oz x 12 ct)
Firestone Walker Brewing Company · 144
doordash$30.99—2026-11-09
Kendall-Jackson Grand Reserve Chardonnay White Wine (750 ml)
not matched to a product yet
doordash$24.99—2026-11-09
Sutter Home California Sauvignon Blanc Bottle (750 ml)
not matched to a product yet
doordash$10.99—2026-11-09
Robert Mondavi Private Selection Bourbon Barrel-Aged Cabernet Sauvignon Red Wine (750 ml)
not matched to a product yet
doordash$17.99—2026-11-09
Barefoot Bubbly Brut Cuvee Champagne Bottle California (750 ml)
not matched to a product yet
doordash$17.99—2026-11-09
Barefoot Sauvignon Blanc Bottle California (750 ml)
not matched to a product yet
doordash$12.99—2026-11-09
Apothic Brew Red Blend Bottle (750 ml)
not matched to a product yet
doordash$17.99—2026-11-09
Bogle Vineyards California Pinot Noir Bottle (750 ml)
not matched to a product yet
doordash$17.99—2026-11-09
Hornitos Reposado Tequila (750 ml)
not matched to a product yet
doordash$32.99—2026-11-09
Cazadores 80 Proof Reposado Tequila Bottle (750 ml)
not matched to a product yet
doordash$43.99—2026-11-09
Patrón Silver Tequila (375 ml)
not matched to a product yet
doordash$39.99—2026-11-09
Stone Cellars California Pinot Noir Bottle (750 ml)
not matched to a product yet
doordash$16.99—2026-11-09
Sutter Home California Chardonnay Bottle (750 ml)
not matched to a product yet
doordash$10.99—2026-11-09
Sutter Home California Cabernet Sauvignon Bottle (750 ml)
not matched to a product yet
doordash$10.99—2026-11-09
Stone Cellars Chardonnay Bottle California (750 ml)
not matched to a product yet
doordash$14.99—2026-11-09
Opus One Red Blend Bottle California (750 ml)
not matched to a product yet
doordash$479.00—2026-11-09
Casamigos 80 Proof Reposado Tequila Bottle (750 ml)
not matched to a product yet
doordash$77.99—2026-11-09
Veuve Clicquot Yellow Label Brut Champagne Bottle (700 ml)
not matched to a product yet
doordash$98.99—2026-11-09
Clos Du Bois Reserve Russian River Valley Sonoma Country 2022 Chardonnay Bottle (750 ml)
not matched to a product yet
doordash$21.99—2026-11-09
La Crema Monterey Pinot Noir Red Wine (750 ml)
not matched to a product yet
doordash$34.99—2026-11-09
Yellow Tail Sauvignon Blanc (750 ml)
not matched to a product yet
doordash$12.99—2026-11-09

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevOFARRELL LIQUORS
2213541
405 OFARRELL ST, SAN FRANCISCO, CA, 9410237.78583, -122.412222026-11-132026-11-13
ca-abcOFARRELL LIQUORS
legal name: GAUTAM AMAR
00384188|21|LIC|0
405 OFARRELL ST, SAN FRANCISCO, CA, 9410237.78592, -122.411452026-10-082026-11-05
doordasho'farrell liquor san francisco
333787
405 O'Farrell Street, San Francisco, CA, 9410237.78597, -122.411542026-10-082026-11-03
overtureO'Farrell Liquors
3be0ef11-69b1-49d2-850e-71e829fa28a7
405 O'Farrell St, San Francisco, CA, 94102415921225637.78591, -122.411482026-11-062026-11-06
vtinfoOFARRELL LIQUORS
f5d0b0f488f50ceb
405 OFARRELL ST, SAN FRANCISCO, CA, 94102415921225637.78577, -122.411532026-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 OFARRELL LIQUORSca-abc OFARRELL LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00
ab-inbev OFARRELL LIQUORSoverture O'Farrell Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00
ab-inbev OFARRELL LIQUORSvtinfo OFARRELL LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 61 m apart · name similarity 1.00
ca-abc OFARRELL LIQUORSoverture O'Farrell Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ca-abc OFARRELL LIQUORSvtinfo OFARRELL LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
overture O'Farrell Liquorsvtinfo OFARRELL LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 · phone: equal
ab-inbev OFARRELL LIQUORSdoordash o'farrell liquor san francisco0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 62 m apart · name similarity 0.65
ca-abc OFARRELL LIQUORSdoordash o'farrell liquor san francisco0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 10 m apart · name similarity 0.65
doordash o'farrell liquor san franciscooverture O'Farrell Liquors0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 9 m apart · name similarity 0.65
doordash o'farrell liquor san franciscovtinfo OFARRELL LIQUORS0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 23 m apart · name similarity 0.65

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
2,256 within 1 mi · 4,921 within 3 mi
Off / on premise
234 / 1,346 within 1 mi · 692 / 2,938 within 3 mi
Selling alcohol
1,351 within 1 mi · 3,220 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.01 mi
Setting
urban (15,418 people per sq mi)
People within 3 mi
435,940 (382,099 adults 21+, 221,649 households) from 144 tract(s), tracts within 3 mi
Income
per capita $109,311 · median household ~$152,663 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 67%
Ethnicity
Hispanic 16% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
119
Alcohol spend within 3 mi
$211,254,100 a year ($89,759,302 at home, $121,429,540 away) · $65,586 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”).
WhenEventPairRuleDecisionRule version
2026-11-13 17:47insertab-inbev 2213541 ↔ doordash 333787same address and namemerged15
2026-11-13 17:47insertab-inbev 2213541 ↔ vtinfo f5d0b0f488f50cebsame address and namemerged15
2026-11-13 17:47insertab-inbev 2213541 ↔ overture 3be0ef11-69b1-49d2-850e-71e829fa28a7same address and namemerged15
2026-11-13 17:47insertab-inbev 2213541 ↔ ca-abc 00384188|21|LIC|0same address and namemerged15
2026-11-11 12:56insertdoordash 333787 ↔ vtinfo f5d0b0f488f50cebsame address and namemerged12
2026-11-11 12:56insertoverture 3be0ef11-69b1-49d2-850e-71e829fa28a7 ↔ vtinfo f5d0b0f488f50cebsame address and namemerged12
2026-11-11 12:56insertca-abc 00384188|21|LIC|0 ↔ vtinfo f5d0b0f488f50cebsame address and namemerged12
2026-11-06 18:13insertdoordash 333787 ↔ overture 3be0ef11-69b1-49d2-850e-71e829fa28a7same address and namemerged11
2026-11-06 18:13insertca-abc 00384188|21|LIC|0 ↔ overture 3be0ef11-69b1-49d2-850e-71e829fa28a7same address and namemerged11
2026-11-03 13:33backfillca-abc 00384188|21|LIC|0 ↔ doordash 333787same address and namemerged