FISH BOWL

SAN FRANCISCO, CA 94115 · O34819970a5df · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: licensed4 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
FISH BOWL 4 other
the most common name a source states
THE WELSHMAN GROUP LLC ca-abc (legal name) ×4
FISHBOWL BAR & GRILL THE ca-abc ×2
THE FISHBOWL BAR & GRILL ca-abc ×2
Fishbowl Bar & Grill overture
Street
1854 DIVISADERO ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94115
ca-abcno other value
Pin
37.78687, -122.44001 map
overtureno other value
Phone
4157753630
vtinfono other value
Licences
ca-abc 00475187|47|APP|0 · ca-abc 00475187|47|LIC|0 · ca-abc 00475187|58|APP|0 · ca-abc 00475187|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O5b99deabb50d; Ofc703569b720; O59e002571511; O5562c18918b5; Of1d20e11e935; Oa0f15c69c139

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-inbevFISH BOWL
2212068
1854 DIVISADERO ST, SAN FRANCISCO, CA, 9411537.78690, -122.440122026-11-132026-11-16
ca-abcFISHBOWL BAR & GRILL THE
legal name: THE WELSHMAN GROUP LLC
00475187|47|APP|0
1854 DIVISADERO ST, SAN FRANCISCO, CA, 9411537.78670, -122.440052026-10-082026-11-06
ca-abcTHE FISHBOWL BAR & GRILL
legal name: THE WELSHMAN GROUP LLC
00475187|47|LIC|0
1854 DIVISADERO ST, SAN FRANCISCO, CA, 9411537.78670, -122.440052026-10-082026-11-06
ca-abcFISHBOWL BAR & GRILL THE
legal name: THE WELSHMAN GROUP LLC
00475187|58|APP|0
1854 DIVISADERO ST, SAN FRANCISCO, CA, 9411537.78670, -122.440052026-10-082026-11-06
ca-abcTHE FISHBOWL BAR & GRILL
legal name: THE WELSHMAN GROUP LLC
00475187|58|LIC|0
1854 DIVISADERO ST, SAN FRANCISCO, CA, 9411537.78670, -122.440052026-10-082026-11-06
overtureFishbowl Bar & Grill
00bda713-3b96-4cbc-8f18-6d5c89e21a7f
1854 Divisadero St, San Francisco, CA, 94115415775363037.78687, -122.440012026-11-062026-11-06
vtinfoFISH BOWL
3c66b5845e7bba92
1854 DIVISADERO ST, SAN FRANCISCO, CA, 94115415775363037.78667, -122.439952026-11-112026-11-16

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 FISH BOWLvtinfo FISH BOWL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
ca-abc FISHBOWL BAR & GRILL THEca-abc THE FISHBOWL BAR & GRILL1.00one licence filemergedfile: 00475187 · same_address
ca-abc FISHBOWL BAR & GRILL THEca-abc FISHBOWL BAR & GRILL THE1.00one licence filemergedfile: 00475187 · same_address
ca-abc FISHBOWL BAR & GRILL THEca-abc THE FISHBOWL BAR & GRILL1.00one licence filemergedfile: 00475187 · same_address
ca-abc FISHBOWL BAR & GRILL THEoverture Fishbowl Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ca-abc THE FISHBOWL BAR & GRILLoverture Fishbowl Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ca-abc FISHBOWL BAR & GRILL THEoverture Fishbowl Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ca-abc THE FISHBOWL BAR & GRILLoverture Fishbowl Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ab-inbev FISH BOWLca-abc FISHBOWL BAR & GRILL THE0.22one name contains the other, same addressmergedjudge: None · pair_id: c41bdfbe30e72adfa2ec · person: None · rule: names contained at one address · stratum: same-address
ab-inbev FISH BOWLca-abc THE FISHBOWL BAR & GRILL0.22one name contains the other, same addressmergedjudge: None · pair_id: 67032fd9f03b68184f24 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev FISH BOWLca-abc FISHBOWL BAR & GRILL THE0.22one name contains the other, same addressmergedjudge: None · pair_id: f920a4aa113ccab0b976 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev FISH BOWLca-abc THE FISHBOWL BAR & GRILL0.22one name contains the other, same addressmergedjudge: None · pair_id: 12d9173646e3b7a9941d · person: None · rule: names contained at one address · stratum: same-address
ca-abc FISHBOWL BAR & GRILL THEvtinfo FISH BOWL0.22one name contains the other, same addressmergedjudge: None · pair_id: cc7aa6f2c269b9bc32d5 · person: None · rule: names contained at one address · stratum: same-address
ca-abc THE FISHBOWL BAR & GRILLvtinfo FISH BOWL0.22one name contains the other, same addressmergedjudge: None · pair_id: 7602ad7361d57b1cbef7 · person: None · rule: names contained at one address · stratum: same-address
ca-abc FISHBOWL BAR & GRILL THEvtinfo FISH BOWL0.22one name contains the other, same addressmergedjudge: None · pair_id: 5dbe192e952b05d9429e · person: None · rule: names contained at one address · stratum: same-address
ca-abc THE FISHBOWL BAR & GRILLvtinfo FISH BOWL0.22one name contains the other, same addressmergedjudge: None · pair_id: 8d3b10cffa1cd263e838 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THE WELSHMAN GROUP LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
729 within 1 mi · 5,921 within 3 mi
Off / on premise
142 / 465 within 1 mi · 781 / 3,773 within 3 mi
Selling alcohol
506 within 1 mi · 3,689 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (17,250 people per sq mi)
People within 3 mi
487,742 (424,725 adults 21+, 243,860 households) from 155 tract(s), tracts within 3 mi
Income
per capita $106,539 · median household ~$151,341 (weighted mean of tract medians)
Age and education
median age ~40.0 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 47% · Black 4% · Asian 29%
Adults per alcohol outlet
115
Alcohol spend within 3 mi
$232,773,216 a year ($98,974,579 at home, $133,726,195 away) · $63,082 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-16 14:56insertca-abc 00475187|58|APP|0 ↔ vtinfo 3c66b5845e7bba92one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00475187|47|APP|0 ↔ vtinfo 3c66b5845e7bba92one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00475187|58|LIC|0 ↔ vtinfo 3c66b5845e7bba92one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00475187|47|LIC|0 ↔ vtinfo 3c66b5845e7bba92one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2212068 ↔ ca-abc 00475187|58|APP|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2212068 ↔ ca-abc 00475187|47|APP|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2212068 ↔ ca-abc 00475187|58|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2212068 ↔ ca-abc 00475187|47|LIC|0one name contains the other, same addressmerged15
2026-11-13 17:47insertab-inbev 2212068 ↔ vtinfo 3c66b5845e7bba92same address and namemerged15
2026-11-06 18:13insertca-abc 00475187|58|APP|0 ↔ overture 00bda713-3b96-4cbc-8f18-6d5c89e21a7fsame address and namemerged11
2026-11-06 18:13insertca-abc 00475187|47|APP|0 ↔ overture 00bda713-3b96-4cbc-8f18-6d5c89e21a7fsame address and namemerged11
2026-11-06 18:13insertca-abc 00475187|58|LIC|0 ↔ overture 00bda713-3b96-4cbc-8f18-6d5c89e21a7fsame address and namemerged11
2026-11-06 18:13insertca-abc 00475187|47|LIC|0 ↔ overture 00bda713-3b96-4cbc-8f18-6d5c89e21a7fsame address and namemerged11
2026-10-09 13:59backfillca-abc 00475187|47|APP|0 ↔ ca-abc 00475187|58|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00475187|47|APP|0 ↔ ca-abc 00475187|58|APP|0one licence filemerged
2026-10-09 13:59backfillca-abc 00475187|47|APP|0 ↔ ca-abc 00475187|47|LIC|0one licence filemerged