Zippy J's #18

Brenham, TX 77833 · O28555ab0781e · first seen 2026-11-02
4 sourcesoff premise · conveniencechain: Zippy J'salcohol: 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
Zippy J's #18 4 other
a licence name in capitals, cleaned (derived; record_title.py)
Zippy J's overture
Zippy J's #18 18 snap
ZIPPY J'S BRENHAM HOLDINGS LLC tx-tabc (legal name)
ZIPPY JS ab-inbev
Street
203 S BLUE BELL RD 1 other
tx-tabc
203 S Blue Bell Rd Ste A overture
City
Brenham
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77833
tx-tabcno other value
Pin
30.16949, -96.38095 map 1 other
overture
2.6 km away ab-inbev
Phone
9793535052
overtureno other value
Licences
tx-tabc 106848591
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od78888f8cbab; O68fbf3bdbdda; Ode8fb995dc55

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-inbevZIPPY JS
4401409
203 S BLUE BELL RD, BRENHAM, TX, 7783330.18177, -96.404482026-11-112026-11-13
overtureZippy J's
f4ce50ca-be5f-4c90-a4f4-3ffa715d6768
203 S Blue Bell Rd Ste A, Brenham, TX, 77833979353505230.16949, -96.380952026-11-132026-11-13
snapZippy J's #18 18
snap|us|1467111
203 S Blue Bell Rd, Brenham, TX, 7783330.16965, -96.381232026-11-192026-11-19
tx-tabcZIPPY J'S #18
legal name: ZIPPY J'S BRENHAM HOLDINGS LLC
106848591
203 S BLUE BELL RD, Brenham, TX, 778332026-11-022026-11-13

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 ZIPPY JSoverture Zippy J's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2642 m apart · name similarity 1.00
overture Zippy J'stx-tabc ZIPPY J'S #181.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
snap Zippy J's #18 18tx-tabc ZIPPY J'S #181.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · name similarity 1.00
ab-inbev ZIPPY JStx-tabc ZIPPY J'S #180.75Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Same name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address, ZIP and city, and the names match: 'ZIPPY JS' is the same chain as 'ZIPPY J'S #18', whose legal entity ZIPPY J'S BRENHAM HOLDINGS LLC fits a single Brenham store, so the shared building with another business does not undermine the name match.
pair 4a5c54d37de43fbdfc6e

Attributes

Channel
off_premise · convenience — overture-category
Chain
Zippy J's — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
ZIPPY J'S BRENHAM HOLDINGS LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — TX Retail/BQ
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
31 within 1 mi · 136 within 3 mi
Off / on premise
8 / 8 within 1 mi · 37 / 42 within 3 mi
Selling alcohol
28 within 1 mi · 117 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.09 mi
Setting
rural (385 people per sq mi)
People within 3 mi
10,897 (7,964 adults 21+, 4,645 households) from 2 tract(s), tracts within 3 mi
Income
per capita $33,564 · median household ~$72,425 (weighted mean of tract medians)
Age and education
median age ~34.6 · bachelor's or higher 37%
Ethnicity
Hispanic 21% · White 58% · Black 20% · Asian 3%
Adults per alcohol outlet
67
Alcohol spend within 3 mi
$2,572,720 a year ($1,216,496 at home, $1,354,945 away) · $21,803 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-19 20:37insertsnap snap|us|1467111 ↔ tx-tabc 106848591same address and namemerged17
2026-11-18 18:58insertoverture f4ce50ca-be5f-4c90-a4f4-3ffa715d6768 ↔ tx-tabc 106848591same address and namemerged15
2026-11-13 14:10insertab-inbev 4401409 ↔ overture f4ce50ca-be5f-4c90-a4f4-3ffa715d6768same address and namemerged15
2026-11-12 17:29insertab-inbev 4401409 ↔ tx-tabc 106848591Claude judge: samemerged14