MARIOS BOHEMIAN CIGAR STORE

SAN FRANCISCO, CA 94133 · O027898a71f8b · first seen 2026-10-08
4 sourceson premise · baralcohol: 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
MARIOS BOHEMIAN CIGAR STORE 4 other
the most common name a source states
BOHEMIAN CIGAR STORE INC ca-abc (legal name)
Mario's Bohemian Cigar Store Cafe overture
mario's bohemian cigar store cafe san francisco doordash
MARIOS BOHEMIAN CIGAR STORE CAFE vtinfo
Street
566 COLUMBUS AVE 1 other
ca-abc
566 Columbus Avenue doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94133
ca-abcno other value
Pin
37.80025, -122.40988 map
doordashno other value
Phone
4153620536
vtinfono other value
Licences
ca-abc 00168724|42|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa901145370f0; O7ffc8c03f261; Oeef72f456f64

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-abcMARIOS BOHEMIAN CIGAR STORE
legal name: BOHEMIAN CIGAR STORE INC
00168724|42|LIC|0
566 COLUMBUS AVE, SAN FRANCISCO, CA, 9413337.80008, -122.409752026-10-082026-11-06
doordashmario's bohemian cigar store cafe san francisco
23994167
566 Columbus Avenue, San Francisco, CA, 9413337.80025, -122.409882026-10-082026-11-06
overtureMario's Bohemian Cigar Store Cafe
608fa6ca-22dd-4cbd-ae90-dae0fa49c750
566 Columbus Ave, San Francisco, CA, 94133415362053637.80025, -122.409812026-11-062026-11-06
vtinfoMARIOS BOHEMIAN CIGAR STORE CAFE
efb10a6a80ea9a77
566 COLUMBUS AVE, SAN FRANCISCO, CA, 94133415362053637.80021, -122.409802026-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
doordash mario's bohemian cigar store cafe san franciscooverture Mario's Bohemian Cigar Store Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
doordash mario's bohemian cigar store cafe san franciscovtinfo MARIOS BOHEMIAN CIGAR STORE CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
overture Mario's Bohemian Cigar Store Cafevtinfo MARIOS BOHEMIAN CIGAR STORE CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: equal
ca-abc MARIOS BOHEMIAN CIGAR STOREoverture Mario's Bohemian Cigar Store Cafe0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 20 m apart · name similarity 0.82
ca-abc MARIOS BOHEMIAN CIGAR STOREvtinfo MARIOS BOHEMIAN CIGAR STORE CAFE0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 16 m apart · name similarity 0.82
ca-abc MARIOS BOHEMIAN CIGAR STOREdoordash mario's bohemian cigar store cafe san francisco0.60Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Both records carry the same distinctive independent name, Mario's Bohemian Cigar Store, at the identical address, 566 Columbus Ave, San Francisco 94133, so the bar licence and the DoorDash cafe listin
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — The DoorDash slug "mario's bohemian cigar store cafe san francisco" matches the CA ABC DBA "MARIOS BOHEMIAN CIGAR STORE" at the same street address, ZIP and city, and the licence is an on-sale public premises (bar) consistent with a cafe; the shared building is resolved because the names agree closely.
pair c8a5a100cdcc2e51f6ed

Attributes

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

Trade area

Other outlets
1,547 within 1 mi · 4,185 within 3 mi
Off / on premise
179 / 912 within 1 mi · 566 / 2,478 within 3 mi
Selling alcohol
955 within 1 mi · 2,711 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (12,089 people per sq mi)
People within 3 mi
341,814 (302,809 adults 21+, 178,622 households) from 117 tract(s), tracts within 3 mi
Income
per capita $105,234 · median household ~$143,023 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 65%
Ethnicity
Hispanic 15% · White 45% · Black 6% · Asian 30%
Adults per alcohol outlet
112
Alcohol spend within 3 mi
$163,660,279 a year ($69,919,649 at home, $93,687,009 away) · $60,347 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-12 14:25insertca-abc 00168724|42|LIC|0 ↔ vtinfo efb10a6a80ea9a77same address and namemerged12
2026-11-12 14:25insertdoordash 23994167 ↔ vtinfo efb10a6a80ea9a77same address and namemerged12
2026-11-12 14:25insertoverture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750 ↔ vtinfo efb10a6a80ea9a77same address and namemerged12
2026-11-06 18:13insertca-abc 00168724|42|LIC|0 ↔ overture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750same address and namemerged11
2026-11-06 18:13insertdoordash 23994167 ↔ overture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750same address and namemerged11
2026-11-02 23:02backfillca-abc 00168724|42|LIC|0 ↔ doordash 23994167Claude judge: samemerged