BULLSHEAD RESTAURANT

SAN FRANCISCO, CA 94127 · O2f129f9ae305 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: licensed2 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
BULLSHEAD RESTAURANT 1 other
the most common name a source states
SHIM TOM JUNG ca-abc (legal name) ×2
Street
840 ULLOA ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94127
ca-abcno other value
Pin
37.74087, -122.46552 map
overtureno other value
Phone
4156654350
overtureno other value
Licences
ca-abc 00572539|41|LIC|0 · ca-abc 00572539|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc88deb16a3b8; O71ea1b0edb56; O5be2ad54d73e

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-inbevBULLSHEAD RESTAURANT
1341100
840 ULLOA ST, SAN FRANCISCO, CA, 9412737.74083, -122.465512026-11-132026-11-13
ca-abcBULLSHEAD RESTAURANT
legal name: SHIM TOM JUNG
00572539|41|LIC|0
840 ULLOA ST, SAN FRANCISCO, CA, 9412737.74075, -122.465362026-10-082026-11-05
ca-abcBULLSHEAD RESTAURANT
legal name: SHIM TOM JUNG
00572539|58|LIC|0
840 ULLOA ST, SAN FRANCISCO, CA, 9412737.74075, -122.465362026-11-052026-11-05
overtureBullshead Restaurant
5ca66e90-9f7b-47fa-8941-f5249329dfaf
840 Ulloa St, San Francisco, CA, 94127415665435037.74087, -122.465522026-11-062026-11-06

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 BULLSHEAD RESTAURANTca-abc BULLSHEAD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev BULLSHEAD RESTAURANTca-abc BULLSHEAD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev BULLSHEAD RESTAURANToverture Bullshead Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ca-abc BULLSHEAD RESTAURANTca-abc BULLSHEAD RESTAURANT1.00one licence filemergedfile: 00572539 · same_address
ca-abc BULLSHEAD RESTAURANToverture Bullshead Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ca-abc BULLSHEAD RESTAURANToverture Bullshead Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41; 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
153 within 1 mi · 2,567 within 3 mi
Off / on premise
27 / 100 within 1 mi · 457 / 1,690 within 3 mi
Selling alcohol
97 within 1 mi · 1,690 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (16,186 people per sq mi)
People within 3 mi
457,643 (376,856 adults 21+, 179,383 households) from 113 tract(s), tracts within 3 mi
Income
per capita $86,958 · median household ~$161,382 (weighted mean of tract medians)
Age and education
median age ~41.7 · bachelor's or higher 61%
Ethnicity
Hispanic 17% · White 38% · Black 3% · Asian 37%
Adults per alcohol outlet
223
Alcohol spend within 3 mi
$181,744,561 a year ($76,897,456 at home, $104,792,866 away) · $107,478 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 1341100 ↔ overture 5ca66e90-9f7b-47fa-8941-f5249329dfafsame address and namemerged15
2026-11-13 17:47insertab-inbev 1341100 ↔ ca-abc 00572539|58|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 1341100 ↔ ca-abc 00572539|41|LIC|0same address and namemerged15
2026-11-06 18:13insertca-abc 00572539|58|LIC|0 ↔ overture 5ca66e90-9f7b-47fa-8941-f5249329dfafsame address and namemerged11
2026-11-06 18:13insertca-abc 00572539|41|LIC|0 ↔ overture 5ca66e90-9f7b-47fa-8941-f5249329dfafsame address and namemerged11
2026-11-05 23:10backfillca-abc 00572539|41|LIC|0 ↔ ca-abc 00572539|58|LIC|0one licence filemerged