Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94133 | ca-abc | no other value |
| Pin | 37.80025, -122.40988 map | doordash | no other value |
| Phone | 4153620536 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | MARIOS BOHEMIAN CIGAR STORE legal name: BOHEMIAN CIGAR STORE INC 00168724|42|LIC|0 | 566 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 37.80008, -122.40975 | 2026-10-08 | 2026-11-06 | |
| doordash | mario's bohemian cigar store cafe san francisco 23994167 | 566 Columbus Avenue, San Francisco, CA, 94133 | 37.80025, -122.40988 | 2026-10-08 | 2026-11-06 | |
| overture | Mario's Bohemian Cigar Store Cafe 608fa6ca-22dd-4cbd-ae90-dae0fa49c750 | 566 Columbus Ave, San Francisco, CA, 94133 | 4153620536 | 37.80025, -122.40981 | 2026-11-06 | 2026-11-06 |
| vtinfo | MARIOS BOHEMIAN CIGAR STORE CAFE efb10a6a80ea9a77 | 566 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 4153620536 | 37.80021, -122.40980 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| doordash mario's bohemian cigar store cafe san francisco | overture Mario's Bohemian Cigar Store Cafe | 1.00 | same address and name | merged | address 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 francisco | vtinfo MARIOS BOHEMIAN CIGAR STORE CAFE | 1.00 | same address and name | merged | address 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 Cafe | vtinfo MARIOS BOHEMIAN CIGAR STORE CAFE | 1.00 | same address and name | merged | address 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 STORE | overture Mario's Bohemian Cigar Store Cafe | 0.82 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 20 m apart · name similarity 0.82 |
| ca-abc MARIOS BOHEMIAN CIGAR STORE | vtinfo MARIOS BOHEMIAN CIGAR STORE CAFE | 0.82 | same address and name | merged | address 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 STORE | doordash mario's bohemian cigar store cafe san francisco | 0.60 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ca-abc 00168724|42|LIC|0 ↔ vtinfo efb10a6a80ea9a77 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 23994167 ↔ vtinfo efb10a6a80ea9a77 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750 ↔ vtinfo efb10a6a80ea9a77 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00168724|42|LIC|0 ↔ overture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 23994167 ↔ overture 608fa6ca-22dd-4cbd-ae90-dae0fa49c750 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00168724|42|LIC|0 ↔ doordash 23994167 | Claude judge: same | merged |