Bubba's Food and Liquor

FRESNO, CA 93726 · O0cc5c267b48d · first seen 2026-10-08
5 sourcesoff premise · conveniencealcohol: 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
Bubba's Food and Liquor 3 other
a source's own spelling of the licence name (record_title.py)
BUBBAS FOOD & LIQUOR ab-inbevsnapvtinfo ×3
BUBAS LIQUOR & FOOD ca-abc
SINGH GURMEET ca-abc (legal name)
Street
3281 E SHIELDS AVE
ca-abcno other value
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93726
ca-abcno other value
Pin
36.78016, -119.76920 map 2 other
overture
82 m away ca-abc
57 m away snap
Phone
5592224229
vtinfono other value
Licences
ca-abc 00452914|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od7f6fba72d26; Od51d5a9d0091; O1a04da23959a; Oe001c36bd608

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-inbevBUBBAS FOOD & LIQUOR
2779375
3281 E SHIELDS AVE, FRESNO, CA, 9372636.77980, -119.769392026-11-112026-11-11
ca-abcBUBAS LIQUOR & FOOD
legal name: SINGH GURMEET
00452914|21|LIC|0
3281 E SHIELDS AVE, FRESNO, CA, 9372636.77963, -119.769842026-10-082026-11-06
overtureBubba's Food and Liquor
680dd528-3d9e-421b-ba61-bf8fdfcecc9f
3281 E Shields Ave, Fresno, CA, 93726559222422936.78016, -119.769202026-11-062026-11-06
snapBubbas Food & Liquor
snap|us|819878
3281 E Shields Ave, Fresno, CA, 9372636.77967, -119.769002026-11-192026-11-19
vtinfoBUBBAS FOOD & LIQUOR
2d18c9db888817fc
3281 E SHIELDS AVE, FRESNO, CA, 93726559222422936.77981, -119.769052026-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 BUBBAS FOOD & LIQUORoverture Bubba's Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 43 m apart · name similarity 1.00
ab-inbev BUBBAS FOOD & LIQUORsnap Bubbas Food & Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
ab-inbev BUBBAS FOOD & LIQUORvtinfo BUBBAS FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
overture Bubba's Food and Liquorsnap Bubbas Food & Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
overture Bubba's Food and Liquorvtinfo BUBBAS FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00 · phone: equal
snap Bubbas Food & Liquorvtinfo BUBBAS FOOD & LIQUOR1.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 BUBBAS FOOD & LIQUORca-abc BUBAS LIQUOR & FOOD0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 44 m apart · name similarity 0.74
ca-abc BUBAS LIQUOR & FOODoverture Bubba's Food and Liquor0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 82 m apart · name similarity 0.74
ca-abc BUBAS LIQUOR & FOODsnap Bubbas Food & Liquor0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 75 m apart · name similarity 0.74
ca-abc BUBAS LIQUOR & FOODvtinfo BUBBAS FOOD & LIQUOR0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 73 m apart · name similarity 0.74

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
65 within 1 mi · 828 within 3 mi
Off / on premise
24 / 36 within 1 mi · 266 / 457 within 3 mi
Selling alcohol
39 within 1 mi · 475 within 3 mi
Nearest
same channel 0.13 mi · licensed 0.06 mi
Setting
urban (6,684 people per sq mi)
People within 3 mi
188,998 (128,878 adults 21+, 64,937 households) from 44 tract(s), tracts within 3 mi
Income
per capita $25,687 · median household ~$56,832 (weighted mean of tract medians)
Age and education
median age ~32.3 · bachelor's or higher 17%
Ethnicity
Hispanic 60% · White 29% · Black 6% · Asian 10%
Adults per alcohol outlet
271
Alcohol spend within 3 mi
$33,073,008 a year ($15,970,573 at home, $17,085,721 away) · $69,481 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:37insertca-abc 00452914|21|LIC|0 ↔ snap snap|us|819878same address and namemerged17
2026-11-19 20:37insertab-inbev 2779375 ↔ snap snap|us|819878same address and namemerged17
2026-11-19 20:37insertoverture 680dd528-3d9e-421b-ba61-bf8fdfcecc9f ↔ snap snap|us|819878same address and namemerged17
2026-11-19 20:37insertsnap snap|us|819878 ↔ vtinfo 2d18c9db888817fcsame address and namemerged17
2026-11-12 14:25insertca-abc 00452914|21|LIC|0 ↔ vtinfo 2d18c9db888817fcsame address and namemerged12
2026-11-12 14:25insertab-inbev 2779375 ↔ vtinfo 2d18c9db888817fcsame address and namemerged12
2026-11-12 14:25insertoverture 680dd528-3d9e-421b-ba61-bf8fdfcecc9f ↔ vtinfo 2d18c9db888817fcsame address and namemerged12
2026-11-11 12:56insertab-inbev 2779375 ↔ ca-abc 00452914|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2779375 ↔ overture 680dd528-3d9e-421b-ba61-bf8fdfcecc9fsame address and namemerged12
2026-11-06 18:13insertca-abc 00452914|21|LIC|0 ↔ overture 680dd528-3d9e-421b-ba61-bf8fdfcecc9fsame address and namemerged11