LIQUORLAND

FRESNO, CA 93727 · O3199758a6ef9 · first seen 2026-10-08
4 sourcesoff premisealcohol: 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
LIQUORLAND 1 other
the most common name a source states
SIDHU BALJIT SINGH ca-abc (legal name)
Street
5816 E SHIELDS AVE 1 other
ca-abc
5816 E SHIELDS AVE STE 101 ab-inbevvtinfo ×2
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93727 1 other
ca-abc
93722 vtinfo
Pin
36.77901, -119.69089 map
overtureno other value
Phone
5598400133
vtinfono other value
Licences
ca-abc 00592009|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O454984e783e3; O7bb3bc029471; O62e0966c8700

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-inbevLIQUORLAND
4127640
5816 E SHIELDS AVE STE 101, FRESNO, CA, 9372736.77907, -119.691042026-11-112026-11-11
ca-abcLIQUORLAND
legal name: SIDHU BALJIT SINGH
00592009|21|LIC|0
5816 E SHIELDS AVE, FRESNO, CA, 937272026-10-082026-11-06
overtureLiquorland
51587c44-6026-4ed3-8603-a51107f2909b
5816 E Shields Ave, Fresno, CA, 93727559840013336.77901, -119.690892026-11-062026-11-06
vtinfoLIQUORLAND
2b0ee9d79e8ccf07
5816 E SHIELDS AVE STE 101, FRESNO, CA, 93722559840013336.77901, -119.690892026-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 LIQUORLANDca-abc LIQUORLAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev LIQUORLANDoverture Liquorland1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ab-inbev LIQUORLANDvtinfo LIQUORLAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
ca-abc LIQUORLANDoverture Liquorland1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc LIQUORLANDvtinfo LIQUORLAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
overture Liquorlandvtinfo LIQUORLAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise — 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 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
23 within 1 mi · 451 within 3 mi
Off / on premise
6 / 16 within 1 mi · 134 / 264 within 3 mi
Selling alcohol
9 within 1 mi · 226 within 3 mi
Nearest
same channel 0.29 mi · licensed 0.48 mi
Setting
urban (4,022 people per sq mi)
People within 3 mi
113,721 (76,060 adults 21+, 36,134 households) from 22 tract(s), tracts within 3 mi
Income
per capita $32,986 · median household ~$87,513 (weighted mean of tract medians)
Age and education
median age ~33.9 · bachelor's or higher 26%
Ethnicity
Hispanic 44% · White 36% · Black 3% · Asian 19%
Adults per alcohol outlet
335
Alcohol spend within 3 mi
$24,125,937 a year ($11,061,112 at home, $13,053,993 away) · $106,282 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-12 14:25insertab-inbev 4127640 ↔ vtinfo 2b0ee9d79e8ccf07same address and namemerged12
2026-11-12 14:25insertoverture 51587c44-6026-4ed3-8603-a51107f2909b ↔ vtinfo 2b0ee9d79e8ccf07same address and namemerged12
2026-11-12 14:25insertca-abc 00592009|21|LIC|0 ↔ vtinfo 2b0ee9d79e8ccf07same address and namemerged12
2026-11-11 12:56insertab-inbev 4127640 ↔ ca-abc 00592009|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4127640 ↔ overture 51587c44-6026-4ed3-8603-a51107f2909bsame address and namemerged12
2026-11-06 18:13insertca-abc 00592009|21|LIC|0 ↔ overture 51587c44-6026-4ed3-8603-a51107f2909bsame address and namemerged11