JJ Liquor 3

Boerne, TX 78006 · O224d99039a99 · first seen 2026-11-02
3 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
JJ Liquor 3 2 other
the most common name a source states
J & G LIQUOR LLC tx-tabc (legal name)
JJ LIQUOR ab-inbev
Street
1 FM 3351 2 other
tx-tabc
1 FM 3351 S overture
1 FM 3351 S STE 150 ab-inbev
City
Boerne
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
78006
tx-tabcno other value
Pin
29.82547, -98.57256 map
overtureno other value
Phone
8302295233
overtureno other value
Licences
tx-tabc 200160998
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc49641877f58; O4f114d95f774

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-inbevJJ LIQUOR
4903103
1 FM 3351 S STE 150, BOERNE, TX, 7800629.82566, -98.572352026-11-122026-11-12
overtureJJ Liquor 3
b8e29414-6842-4cd0-a055-35175d710b76
1 FM 3351 S, Boerne, TX, 78006830229523329.82547, -98.572562026-11-182026-11-18
tx-tabcJJ Liquor 3
legal name: J & G LIQUOR LLC
200160998
1 FM 3351, Boerne, TX, 780062026-11-022026-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
overture JJ Liquor 3tx-tabc JJ Liquor 31.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.88
ab-inbev JJ LIQUORtx-tabc JJ Liquor 30.78Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
JJ Liquor name at same street address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records are at 1 FM 3351 in Boerne with near-identical names (JJ Liquor vs JJ Liquor 3), but the building holds two businesses, record A names suite 150 while B names none, and B's legal entity (J & G Liquor LLC) doesn't match, so the data can't confirm whether they're one outlet.
pair 18df0e6f44d35ebcec26

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
J & G LIQUOR LLC — 4 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — TX Retail/P
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
8 within 1 mi · 9 within 3 mi
Off / on premise
1 / 3 within 1 mi · 1 / 3 within 3 mi
Selling alcohol
7 within 1 mi · 8 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.00 mi
Setting
rural (none people per sq mi)
People within 3 mi
5,921 (4,458 adults 21+, 1,910 households) from 1 tract(s), the nearest tract
Income
per capita $85,065 · median household ~$175,577 (weighted mean of tract medians)
Age and education
median age ~45.4 · bachelor's or higher 63%
Ethnicity
Hispanic 6% · White 91% · Black 0% · Asian 2%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$2,091,717 a year ($877,763 at home, $1,213,400 away) · none 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-18 18:58insertab-inbev 4903103 ↔ tx-tabc 200160998Claude judge: samemerged15
2026-11-18 18:58insertoverture b8e29414-6842-4cd0-a055-35175d710b76 ↔ tx-tabc 200160998street written two waysmerged15