26th & Guerrero Market

SAN FRANCISCO, CA 94110 · O81b47d88dab0 · 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
26th & Guerrero Market 1 other
a source's own spelling of the licence name (record_title.py)
SAMRA BROS INC ca-abc (legal name)
Street
1400 GUERRERO ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94110
ca-abcno other value
Pin
37.74869, -122.42268 map
overtureno other value
Phone
4152826274
vtinfono other value
Licences
ca-abc 00603312|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O841f5ef0ef43; Of90a0d8c16a7; O82d0b2e2bf47; Oed59c6fab7de

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-inbev26TH & GUERRERO MARKET
2727305
1400 GUERRERO ST, SAN FRANCISCO, CA, 9411037.74852, -122.422612026-11-132026-11-13
ca-abc26TH & GUERRERO MARKET
legal name: SAMRA BROS INC
00603312|21|LIC|0
1400 GUERRERO ST, SAN FRANCISCO, CA, 9411037.74872, -122.422682026-10-082026-11-13
overture26th & Guerrero Market
a0ac992c-2eae-46d8-90c1-de1c06e4e5b7
1400 Guerrero St, San Francisco, CA, 94110415282627437.74869, -122.422682026-11-062026-11-13
snap26th & Guerrero Market
snap|us|1392801
1400 Guerrero St, San Francisco, CA, 9411037.74862, -122.422802026-11-192026-11-19
vtinfo26TH & GUERRERO MARKET
94d050953331d427
1400 GUERRERO ST, SAN FRANCISCO, CA, 94110415282627437.74862, -122.422872026-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
ab-inbev 26TH & GUERRERO MARKETca-abc 26TH & GUERRERO MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ab-inbev 26TH & GUERRERO MARKEToverture 26th & Guerrero Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev 26TH & GUERRERO MARKETsnap 26th & Guerrero Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev 26TH & GUERRERO MARKETvtinfo 26TH & GUERRERO MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
ca-abc 26TH & GUERRERO MARKEToverture 26th & Guerrero Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ca-abc 26TH & GUERRERO MARKETsnap 26th & Guerrero Market1.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 26TH & GUERRERO MARKETvtinfo 26TH & GUERRERO MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
overture 26th & Guerrero Marketsnap 26th & Guerrero Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
overture 26th & Guerrero Marketvtinfo 26TH & GUERRERO MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: equal
snap 26th & Guerrero Marketvtinfo 26TH & GUERRERO MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SAMRA BROS INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
728 within 1 mi · 4,753 within 3 mi
Off / on premise
118 / 476 within 1 mi · 720 / 2,975 within 3 mi
Selling alcohol
509 within 1 mi · 2,938 within 3 mi
Nearest
same channel 0.15 mi · licensed 0.06 mi
Setting
urban (19,409 people per sq mi)
People within 3 mi
548,763 (461,820 adults 21+, 237,741 households) from 153 tract(s), tracts within 3 mi
Income
per capita $89,935 · median household ~$149,542 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 59%
Ethnicity
Hispanic 19% · White 38% · Black 6% · Asian 32%
Adults per alcohol outlet
157
Alcohol spend within 3 mi
$225,389,464 a year ($95,956,308 at home, $129,362,479 away) · $76,689 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-19 20:37insertoverture a0ac992c-2eae-46d8-90c1-de1c06e4e5b7 ↔ snap snap|us|1392801same address and namemerged17
2026-11-19 20:37insertca-abc 00603312|21|LIC|0 ↔ snap snap|us|1392801same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1392801 ↔ vtinfo 94d050953331d427same address and namemerged17
2026-11-19 20:37insertab-inbev 2727305 ↔ snap snap|us|1392801same address and namemerged17
2026-11-13 17:47insertab-inbev 2727305 ↔ vtinfo 94d050953331d427same address and namemerged15
2026-11-13 17:47insertab-inbev 2727305 ↔ overture a0ac992c-2eae-46d8-90c1-de1c06e4e5b7same address and namemerged15
2026-11-13 17:47insertab-inbev 2727305 ↔ ca-abc 00603312|21|LIC|0same address and namemerged15
2026-11-12 14:25insertoverture a0ac992c-2eae-46d8-90c1-de1c06e4e5b7 ↔ vtinfo 94d050953331d427same address and namemerged12
2026-11-12 14:25insertca-abc 00603312|21|LIC|0 ↔ vtinfo 94d050953331d427same address and namemerged12
2026-11-06 18:13insertca-abc 00603312|21|LIC|0 ↔ overture a0ac992c-2eae-46d8-90c1-de1c06e4e5b7same address and namemerged11