Blackwells Wine & Spirits

SAN FRANCISCO, CA 94121 · O44d697431406 · first seen 2026-10-08
3 sourcesoff premise · liquor_storealcohol: licensed2 licences

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
Blackwells Wine & Spirits 3 other
a licence name in capitals, cleaned (derived; record_title.py)
TWENTY SIX SHOTS INC ca-abc (legal name) ×2
Blackwell's Wines & Spirits overture
BLACKWELLS WINE & SPIRIT vtinfo
Street
5620 GEARY BLVD
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94121
ca-abcno other value
Pin
37.78058, -122.47995 map
overtureno other value
Phone
4153869463
vtinfono other value
Licences
ca-abc 00413229|21|LIC|0 · ca-abc 00413229|42|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O941b4388f5e0; O5e644fafe568; O6932b8152d2d

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
ca-abcBLACKWELLS WINE & SPIRITS
legal name: TWENTY SIX SHOTS INC
00413229|21|LIC|0
5620 GEARY BLVD, SAN FRANCISCO, CA, 9412137.78045, -122.479652026-10-082026-11-05
ca-abcBLACKWELLS WINE & SPIRITS
legal name: TWENTY SIX SHOTS INC
00413229|42|LIC|0
5620 GEARY BLVD, SAN FRANCISCO, CA, 9412137.78045, -122.479652026-10-082026-11-05
overtureBlackwell's Wines & Spirits
030dac1a-a42e-41a2-9333-62a31e8d1db8
5620 Geary Blvd, San Francisco, CA, 94121415386946337.78058, -122.479952026-11-062026-11-06
vtinfoBLACKWELLS WINE & SPIRIT
c3686a4c6e9fe1ad
5620 GEARY BLVD, SAN FRANCISCO, CA, 94121415386946337.78053, -122.479762026-11-122026-11-22

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 BLACKWELLS WINE & SPIRITSca-abc BLACKWELLS WINE & SPIRITS1.00one licence filemergedfile: 00413229 · same_address
ca-abc BLACKWELLS WINE & SPIRITSoverture Blackwell's Wines & Spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 30 m apart · name similarity 0.74
ca-abc BLACKWELLS WINE & SPIRITSvtinfo BLACKWELLS WINE & SPIRIT0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 13 m apart · name similarity 0.74
ca-abc BLACKWELLS WINE & SPIRITSoverture Blackwell's Wines & Spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 30 m apart · name similarity 0.74
ca-abc BLACKWELLS WINE & SPIRITSvtinfo BLACKWELLS WINE & SPIRIT0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 13 m apart · name similarity 0.74
overture Blackwell's Wines & Spiritsvtinfo BLACKWELLS WINE & SPIRIT0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 18 m apart · name similarity 0.58 · phone: equal

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TWENTY SIX SHOTS INC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_off — CA 21; CA 42
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
336 within 1 mi · 2,042 within 3 mi
Off / on premise
56 / 240 within 1 mi · 359 / 1,353 within 3 mi
Selling alcohol
225 within 1 mi · 1,383 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
urban (11,017 people per sq mi)
People within 3 mi
311,490 (262,296 adults 21+, 138,645 households) from 86 tract(s), tracts within 3 mi
Income
per capita $105,161 · median household ~$163,356 (weighted mean of tract medians)
Age and education
median age ~41.4 · bachelor's or higher 70%
Ethnicity
Hispanic 11% · White 49% · Black 3% · Asian 32%
Adults per alcohol outlet
190
Alcohol spend within 3 mi
$142,411,744 a year ($60,047,227 at home, $82,323,389 away) · $102,899 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-12 14:25insertoverture 030dac1a-a42e-41a2-9333-62a31e8d1db8 ↔ vtinfo c3686a4c6e9fe1adsame address and namemerged12
2026-11-12 14:25insertca-abc 00413229|21|LIC|0 ↔ vtinfo c3686a4c6e9fe1adsame address and namemerged12
2026-11-12 14:25insertca-abc 00413229|42|LIC|0 ↔ vtinfo c3686a4c6e9fe1adsame address and namemerged12
2026-11-06 18:13insertca-abc 00413229|21|LIC|0 ↔ overture 030dac1a-a42e-41a2-9333-62a31e8d1db8same address and namemerged11
2026-11-06 18:13insertca-abc 00413229|42|LIC|0 ↔ overture 030dac1a-a42e-41a2-9333-62a31e8d1db8same address and namemerged11
2026-10-09 13:59backfillca-abc 00413229|21|LIC|0 ↔ ca-abc 00413229|42|LIC|0one licence filemerged