Jack's Liquor '76

FARMERSVILLE, CA 93223 · O03c0a0fca8ab · first seen 2026-10-08
4 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
Jack's Liquor '76 2 other
a licence name in capitals, cleaned (derived; record_title.py)
JACKS LIQUOR 76 ab-inbevvtinfo ×2
ZQT LLC ca-abcca-tobacco ×2
Street
146 N FARMERSVILLE BLVD
ca-abcno other value
City
FARMERSVILLE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93223
ca-abcno other value
Pin
36.29831, -119.20706 map
ca-abcno other value
Phone
5597473935
vtinfono other value
Licences
ca-abc 00622332|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe437c23d0a55; O63d184184270; Oa9f2be3000b7

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-inbevJACKS LIQUOR 76
3539340
146 N FARMERSVILLE BLVD, FARMERSVILLE, CA, 9322336.29820, -119.207112026-11-112026-11-18
ca-abcZQT LLC
00622332|21|LIC|0
146 N FARMERSVILLE BLVD, FARMERSVILLE, CA, 9322336.29831, -119.207062026-10-082026-11-04
ca-tobaccoZQT, LLC
ca-tobacco|230948224
146 N FARMERSVILLE BLVD, Farmersville, CA, 932232026-11-202026-11-20
vtinfoJACKS LIQUOR 76
5307d541904209b0
146 N FARMERSVILLE BLVD, FARMERSVILLE, CA, 93223559747393536.29819, -119.206902026-11-142026-11-18

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 JACKS LIQUOR 76vtinfo JACKS LIQUOR 761.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ca-abc ZQT LLCca-tobacco ZQT, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc ZQT LLCvtinfo JACKS LIQUOR 760.06Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Same address, liquor store licence matches Jacks Liquor.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records sit at the same street address with a close distance and both look like liquor retailers, but the names (ZQT LLC on an off-sale licence versus JACKS LIQUOR 76 on a brand finder) do not agree, and the address is shared with another business, so the records cannot confirm one outlet.
pair 8885ccf876764bd1ee08

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ZQT LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
26 within 1 mi · 50 within 3 mi
Off / on premise
10 / 9 within 1 mi · 17 / 24 within 3 mi
Selling alcohol
17 within 1 mi · 30 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.05 mi
Setting
suburban (713 people per sq mi)
People within 3 mi
20,158 (13,659 adults 21+, 5,622 households) from 3 tract(s), tracts within 3 mi
Income
per capita $26,046 · median household ~$80,656 (weighted mean of tract medians)
Age and education
median age ~31.5 · bachelor's or higher 14%
Ethnicity
Hispanic 74% · White 39% · Black 1% · Asian 0%
Adults per alcohol outlet
441
Alcohol spend within 3 mi
$3,604,507 a year ($1,672,947 at home, $1,929,997 away) · $116,274 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-20 22:08insertca-abc 00622332|21|LIC|0 ↔ ca-tobacco ca-tobacco|230948224same address and namemerged17
2026-11-18 18:58insertca-abc 00622332|21|LIC|0 ↔ vtinfo 5307d541904209b0Claude judge: samemerged15
2026-11-14 20:23insertab-inbev 3539340 ↔ vtinfo 5307d541904209b0same address and namemerged15