HORSESHOE TAVERN

SAN FRANCISCO, CA 94123 · O2e5025ec5b3e · first seen 2026-10-08
4 sourceson premise · baralcohol: licensed3 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
HORSESHOE TAVERN 1 other
the most common name a source states
BSB PROPERTIES INC ca-abc (legal name) ×3
Street
2024 CHESTNUT ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94123
ca-abcno other value
Pin
37.80084, -122.43695 map
overtureno other value
Phone
4153461430
vtinfono other value
Licences
ca-abc 00259075|48|APP|0 · ca-abc 00259075|48|APP|1 · ca-abc 00259075|48|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofefba673ef74; O966cccb9a14b; O7028bab99b64; Obb4c6fc360ac; Oc1eb8b85d5ed

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-inbevHORSESHOE TAVERN
2014788
2024 CHESTNUT ST, SAN FRANCISCO, CA, 9412337.80084, -122.436702026-11-132026-11-13
ca-abcHORSESHOE TAVERN
legal name: BSB PROPERTIES INC
00259075|48|APP|0
2024 CHESTNUT ST, SAN FRANCISCO, CA, 9412337.80081, -122.436802026-10-082026-11-06
ca-abcHORSESHOE TAVERN
legal name: BSB PROPERTIES INC
00259075|48|APP|1
2024 CHESTNUT ST, SAN FRANCISCO, CA, 9412337.80081, -122.436802026-10-082026-11-06
ca-abcHORSESHOE TAVERN
legal name: BSB PROPERTIES INC
00259075|48|LIC|0
2024 CHESTNUT ST, SAN FRANCISCO, CA, 9412337.80081, -122.436802026-10-082026-11-06
overtureHorseshoe Tavern
1e7c9286-7355-4990-ad79-f1362d48452f
2024 Chestnut St, San Francisco, CA, 94123415346143037.80084, -122.436952026-11-062026-11-06
vtinfoHORSESHOE TAVERN
497fa8bb870cc50b
2024 CHESTNUT ST, SAN FRANCISCO, CA, 94123415346143037.80092, -122.436962026-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 HORSESHOE TAVERNca-abc HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev HORSESHOE TAVERNca-abc HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev HORSESHOE TAVERNca-abc HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev HORSESHOE TAVERNoverture Horseshoe Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev HORSESHOE TAVERNvtinfo HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNca-abc HORSESHOE TAVERN1.00one licence filemergedfile: 00259075 · same_address
ca-abc HORSESHOE TAVERNca-abc HORSESHOE TAVERN1.00one licence filemergedfile: 00259075 · same_address
ca-abc HORSESHOE TAVERNoverture Horseshoe Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNvtinfo HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNoverture Horseshoe Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNvtinfo HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNoverture Horseshoe Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ca-abc HORSESHOE TAVERNvtinfo HORSESHOE TAVERN1.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 Horseshoe Tavernvtinfo HORSESHOE TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BSB PROPERTIES INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 48
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
518 within 1 mi · 5,139 within 3 mi
Off / on premise
95 / 322 within 1 mi · 662 / 3,264 within 3 mi
Selling alcohol
372 within 1 mi · 3,194 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (13,183 people per sq mi)
People within 3 mi
372,729 (327,928 adults 21+, 192,865 households) from 125 tract(s), tracts within 3 mi
Income
per capita $107,030 · median household ~$146,096 (weighted mean of tract medians)
Age and education
median age ~39.8 · bachelor's or higher 66%
Ethnicity
Hispanic 14% · White 48% · Black 5% · Asian 29%
Adults per alcohol outlet
103
Alcohol spend within 3 mi
$179,815,614 a year ($76,685,135 at home, $103,072,526 away) · $56,280 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 2014788 ↔ vtinfo 497fa8bb870cc50bsame address and namemerged15
2026-11-13 17:47insertab-inbev 2014788 ↔ ca-abc 00259075|48|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 2014788 ↔ ca-abc 00259075|48|APP|0same address and namemerged15
2026-11-13 17:47insertab-inbev 2014788 ↔ overture 1e7c9286-7355-4990-ad79-f1362d48452fsame address and namemerged15
2026-11-13 17:47insertab-inbev 2014788 ↔ ca-abc 00259075|48|APP|1same address and namemerged15
2026-11-11 12:56insertca-abc 00259075|48|APP|1 ↔ vtinfo 497fa8bb870cc50bsame address and namemerged12
2026-11-11 12:56insertca-abc 00259075|48|LIC|0 ↔ vtinfo 497fa8bb870cc50bsame address and namemerged12
2026-11-11 12:56insertca-abc 00259075|48|APP|0 ↔ vtinfo 497fa8bb870cc50bsame address and namemerged12
2026-11-11 12:56insertoverture 1e7c9286-7355-4990-ad79-f1362d48452f ↔ vtinfo 497fa8bb870cc50bsame address and namemerged12
2026-11-06 18:13insertca-abc 00259075|48|APP|1 ↔ overture 1e7c9286-7355-4990-ad79-f1362d48452fsame address and namemerged11
2026-11-06 18:13insertca-abc 00259075|48|LIC|0 ↔ overture 1e7c9286-7355-4990-ad79-f1362d48452fsame address and namemerged11
2026-11-06 18:13insertca-abc 00259075|48|APP|0 ↔ overture 1e7c9286-7355-4990-ad79-f1362d48452fsame address and namemerged11
2026-10-09 13:59backfillca-abc 00259075|48|APP|0 ↔ ca-abc 00259075|48|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00259075|48|APP|0 ↔ ca-abc 00259075|48|APP|1one licence filemerged