SQUIRE LIQUOR

FRESNO, CA 93728 · O0fef050355d2 · first seen 2026-10-08
6 sourcesoff premise · liquor_storealcohol: 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
SQUIRE LIQUOR 3 other
the most common name a source states
SQUIRE LIQUORS ca-abcovertureubereats ×3
GS BROS CORP ca-abc (legal name)
squire liquor fresno doordash
Street
1568 N WEST AVE
ca-abcno other value
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93728
ca-abcno other value
Pin
36.76393, -119.82653 map
ubereatsno other value
Phone
5592687318 1 other
vtinfo
5598943848 overture
Licences
ca-abc 00619776|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of14bec254bfe; Oe9dac4f4103c; O7e18a9133e92; O9ad8047c91ba; Ode3b22abb4d3

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-inbevSQUIRE LIQUOR
539767
1568 N WEST AVE, FRESNO, CA, 9372836.76380, -119.826582026-11-112026-11-11
ca-abcSQUIRE LIQUORS
legal name: GS BROS CORP
00619776|21|LIC|0
1568 N WEST AVE, FRESNO, CA, 9372836.76408, -119.826642026-10-082026-11-06
doordashsquire liquor fresno
51485935
1568 N West Ave, Fresno, CA, 9372836.76409, -119.826362026-10-082026-11-06
overtureSquire liquors
ad9f8d40-8f07-4b0a-a1a7-adece469f01f
1568 N West Ave, Fresno, CA, 93728559894384836.76412, -119.826472026-11-062026-11-06
ubereatsSquire Liquors
4uSwwnRhWbKAq-_qWM15ZA
1568 N West Ave, Fresno, CA, 9372836.76393, -119.826532026-10-202026-11-06
vtinfoSQUIRE LIQUOR
568a0fc41cf9e1dc
1568 N WEST AVE, FRESNO, CA, 93728559268731836.76393, -119.826532026-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 SQUIRE LIQUORdoordash squire liquor fresno1.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 SQUIRE LIQUORvtinfo SQUIRE LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
ca-abc SQUIRE LIQUORSoverture Squire liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc SQUIRE LIQUORSubereats Squire Liquors1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
doordash squire liquor fresnovtinfo SQUIRE LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
overture Squire liquorsubereats Squire Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ab-inbev SQUIRE LIQUORca-abc SQUIRE LIQUORS0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 31 m apart · name similarity 0.65
ab-inbev SQUIRE LIQUORoverture Squire liquors0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 37 m apart · name similarity 0.65
ab-inbev SQUIRE LIQUORubereats Squire Liquors0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 16 m apart · name similarity 0.65
ca-abc SQUIRE LIQUORSdoordash squire liquor fresno0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
Same distinctive name (Squire Liquor/Liquors) at the identical street address and ZIP in Fresno, with an active off-sale licence and no other business recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records sit at 1568 N West Ave, Fresno, CA 93728, the only business at that address, and the names Squire Liquors and Squire Liquor Fresno match; the CA record is an active off-sale liquor licence, consistent with the DoorDash storefront.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records give the same street address, city, and ZIP at 1568 N West Ave, Fresno 93728, and the names match (SQUIRE LIQUORS vs squire liquor fresno), with only one business at that address and an active off-sale liquor licence fitting a DoorDash liquor store.
pair 419d982f8ac920881955
ca-abc SQUIRE LIQUORSvtinfo SQUIRE LIQUOR0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 19 m apart · name similarity 0.65
doordash squire liquor fresnooverture Squire liquors0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 10 m apart · name similarity 0.65
doordash squire liquor fresnoubereats Squire Liquors0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
The DoorDash slug 'squire liquor fresno' and the Uber Eats listing 'Squire Liquors' share the same street address and ZIP, and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the identical street address 1568 N West Ave, Fresno, ZIP 93728, coordinates about 23 m apart, and the names 'squire liquor fresno' (DoorDash slug with city appended) and 'Squire Liquors' match, with no other business at that address and no suite conflict.
pair 836eb4cf0edc098b6170
overture Squire liquorsvtinfo SQUIRE LIQUOR0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 21 m apart · name similarity 0.65 · phone: differs
ubereats Squire Liquorsvtinfo SQUIRE LIQUOR0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 0 m apart · name similarity 0.65

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GS BROS CORP — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
57 within 1 mi · 398 within 3 mi
Off / on premise
29 / 22 within 1 mi · 149 / 190 within 3 mi
Selling alcohol
46 within 1 mi · 284 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
urban (5,156 people per sq mi)
People within 3 mi
145,796 (99,092 adults 21+, 48,565 households) from 35 tract(s), tracts within 3 mi
Income
per capita $26,458 · median household ~$56,444 (weighted mean of tract medians)
Age and education
median age ~32.7 · bachelor's or higher 17%
Ethnicity
Hispanic 62% · White 28% · Black 8% · Asian 8%
Adults per alcohol outlet
348
Alcohol spend within 3 mi
$25,412,818 a year ($12,154,177 at home, $13,245,896 away) · $89,168 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”).
WhenEventPairRuleDecisionRule version
2026-11-12 14:25insertubereats 4uSwwnRhWbKAq-_qWM15ZA ↔ vtinfo 568a0fc41cf9e1dcsame address and namemerged12
2026-11-12 14:25insertca-abc 00619776|21|LIC|0 ↔ vtinfo 568a0fc41cf9e1dcsame address and namemerged12
2026-11-12 14:25insertoverture ad9f8d40-8f07-4b0a-a1a7-adece469f01f ↔ vtinfo 568a0fc41cf9e1dcsame address and namemerged12
2026-11-12 14:25insertab-inbev 539767 ↔ vtinfo 568a0fc41cf9e1dcsame address and namemerged12
2026-11-12 14:25insertdoordash 51485935 ↔ vtinfo 568a0fc41cf9e1dcsame address and namemerged12
2026-11-11 12:56insertab-inbev 539767 ↔ ca-abc 00619776|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 539767 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01fsame address and namemerged12
2026-11-11 12:56insertab-inbev 539767 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZAsame address and namemerged12
2026-11-11 12:56insertab-inbev 539767 ↔ doordash 51485935same address and namemerged12
2026-11-06 18:13insertdoordash 51485935 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01fsame address and namemerged11
2026-11-06 18:13insertoverture ad9f8d40-8f07-4b0a-a1a7-adece469f01f ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZAsame address and namemerged11
2026-11-06 18:13insertca-abc 00619776|21|LIC|0 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01fsame address and namemerged11
2026-11-02 23:02backfilldoordash 51485935 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00619776|21|LIC|0 ↔ doordash 51485935Claude judge: samemerged
2026-10-20 21:04backfillca-abc 00619776|21|LIC|0 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZAsame address and namemerged