Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| City | FRESNO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 93728 | ca-abc | no other value |
| Pin | 36.76393, -119.82653 map | ubereats | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SQUIRE LIQUOR 539767 | 1568 N WEST AVE, FRESNO, CA, 93728 | 36.76380, -119.82658 | 2026-11-11 | 2026-11-11 | |
| ca-abc | SQUIRE LIQUORS legal name: GS BROS CORP 00619776|21|LIC|0 | 1568 N WEST AVE, FRESNO, CA, 93728 | 36.76408, -119.82664 | 2026-10-08 | 2026-11-06 | |
| doordash | squire liquor fresno 51485935 | 1568 N West Ave, Fresno, CA, 93728 | 36.76409, -119.82636 | 2026-10-08 | 2026-11-06 | |
| overture | Squire liquors ad9f8d40-8f07-4b0a-a1a7-adece469f01f | 1568 N West Ave, Fresno, CA, 93728 | 5598943848 | 36.76412, -119.82647 | 2026-11-06 | 2026-11-06 |
| ubereats | Squire Liquors 4uSwwnRhWbKAq-_qWM15ZA | 1568 N West Ave, Fresno, CA, 93728 | 36.76393, -119.82653 | 2026-10-20 | 2026-11-06 | |
| vtinfo | SQUIRE LIQUOR 568a0fc41cf9e1dc | 1568 N WEST AVE, FRESNO, CA, 93728 | 5592687318 | 36.76393, -119.82653 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SQUIRE LIQUOR | doordash squire liquor fresno | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00 |
| ab-inbev SQUIRE LIQUOR | vtinfo SQUIRE LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 |
| ca-abc SQUIRE LIQUORS | overture Squire liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 |
| ca-abc SQUIRE LIQUORS | ubereats Squire Liquors | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · name similarity 1.00 |
| doordash squire liquor fresno | vtinfo SQUIRE LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 |
| overture Squire liquors | ubereats Squire Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00 |
| ab-inbev SQUIRE LIQUOR | ca-abc SQUIRE LIQUORS | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 31 m apart · name similarity 0.65 |
| ab-inbev SQUIRE LIQUOR | overture Squire liquors | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 37 m apart · name similarity 0.65 |
| ab-inbev SQUIRE LIQUOR | ubereats Squire Liquors | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 16 m apart · name similarity 0.65 |
| ca-abc SQUIRE LIQUORS | doordash squire liquor fresno | 0.65 | Claude judge: same | merged | 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:
pair 419d982f8ac920881955 |
| ca-abc SQUIRE LIQUORS | vtinfo SQUIRE LIQUOR | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 19 m apart · name similarity 0.65 |
| doordash squire liquor fresno | overture Squire liquors | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 10 m apart · name similarity 0.65 |
| doordash squire liquor fresno | ubereats Squire Liquors | 0.65 | Claude judge: same | merged | 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:
pair 836eb4cf0edc098b6170 |
| overture Squire liquors | vtinfo SQUIRE LIQUOR | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 21 m apart · name similarity 0.65 · phone: differs |
| ubereats Squire Liquors | vtinfo SQUIRE LIQUOR | 0.65 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ubereats 4uSwwnRhWbKAq-_qWM15ZA ↔ vtinfo 568a0fc41cf9e1dc | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00619776|21|LIC|0 ↔ vtinfo 568a0fc41cf9e1dc | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture ad9f8d40-8f07-4b0a-a1a7-adece469f01f ↔ vtinfo 568a0fc41cf9e1dc | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 539767 ↔ vtinfo 568a0fc41cf9e1dc | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | doordash 51485935 ↔ vtinfo 568a0fc41cf9e1dc | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 539767 ↔ ca-abc 00619776|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 539767 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01f | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 539767 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZA | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 539767 ↔ doordash 51485935 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 51485935 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01f | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture ad9f8d40-8f07-4b0a-a1a7-adece469f01f ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZA | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00619776|21|LIC|0 ↔ overture ad9f8d40-8f07-4b0a-a1a7-adece469f01f | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | doordash 51485935 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZA | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00619776|21|LIC|0 ↔ doordash 51485935 | Claude judge: same | merged | |
| 2026-10-20 21:04 | backfill | ca-abc 00619776|21|LIC|0 ↔ ubereats 4uSwwnRhWbKAq-_qWM15ZA | same address and name | merged |