The Broken Sprocket

Brownsville, TX 78526 · O17eee1042de3 · first seen 2026-11-02
4 sourceson premise · restaurantalcohol: 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
The Broken Sprocket 1 other
a source's own spelling of the licence name (record_title.py)
TEX-US ENTERTAINMENT LLC tx-tabc (legal name)
Street
6305 Paredes Line Rd
tx-tabcno other value
City
Brownsville
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
78526
tx-tabcno other value
Pin
25.99212, -97.48412 map 2 other
overture
102 m away ab-inbev
66 m away tx-tabc
Phone
9565748300 1 other
vtinfo
9565516365 overture
Licences
tx-tabc 200167453
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of13a123cf111; Od7dd187d2ee3; O88806cc68b51

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-inbevTHE BROKEN SPROCKET
4021750
6305 PAREDES LINE RD, BROWNSVILLE, TX, 7852625.99272, -97.483352026-11-112026-11-11
overtureThe Broken Sprocket
61a853b8-1d66-4de1-ab47-46cbab205894
6305 Paredes Line Rd, Brownsville, TX, 78526956551636525.99212, -97.484122026-11-062026-11-11
tx-tabcTHE BROKEN SPROCKET
legal name: TEX-US ENTERTAINMENT LLC
200167453
6305 Paredes Line Rd, Brownsville, TX, 7852625.99208, -97.483462026-11-022026-11-11
vtinfoTHE BROKEN SPROCKET
49fe67a822024150
6305 PAREDES LINE RD, BROWNSVILLE, TX, 78526956574830025.99210, -97.483872026-11-142026-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 THE BROKEN SPROCKEToverture The Broken Sprocket1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 102 m apart · name similarity 1.00
ab-inbev THE BROKEN SPROCKETtx-tabc THE BROKEN SPROCKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev THE BROKEN SPROCKETvtinfo THE BROKEN SPROCKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00
overture The Broken Sprockettx-tabc THE BROKEN SPROCKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00
overture The Broken Sprocketvtinfo THE BROKEN SPROCKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00 · phone: differs
tx-tabc THE BROKEN SPROCKETvtinfo THE BROKEN SPROCKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TEX-US ENTERTAINMENT LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — TX Retail/MB
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
22 within 1 mi · 193 within 3 mi
Off / on premise
8 / 8 within 1 mi · 47 / 74 within 3 mi
Selling alcohol
13 within 1 mi · 152 within 3 mi
Nearest
same channel 0.49 mi · licensed 0.25 mi
Setting
suburban (1,821 people per sq mi)
People within 3 mi
51,496 (32,092 adults 21+, 15,075 households) from 11 tract(s), tracts within 3 mi
Income
per capita $27,959 · median household ~$77,232 (weighted mean of tract medians)
Age and education
median age ~31.5 · bachelor's or higher 37%
Ethnicity
Hispanic 92% · White 29% · Black 0% · Asian 2%
Adults per alcohol outlet
210
Alcohol spend within 3 mi
$9,408,576 a year ($4,409,953 at home, $4,993,217 away) · $61,494 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-14 20:23inserttx-tabc 200167453 ↔ vtinfo 49fe67a822024150same address and namemerged15
2026-11-14 20:23insertoverture 61a853b8-1d66-4de1-ab47-46cbab205894 ↔ vtinfo 49fe67a822024150same address and namemerged15
2026-11-14 20:23insertab-inbev 4021750 ↔ vtinfo 49fe67a822024150same address and namemerged15
2026-11-11 12:56insertab-inbev 4021750 ↔ tx-tabc 200167453same address and namemerged12
2026-11-11 12:56insertab-inbev 4021750 ↔ overture 61a853b8-1d66-4de1-ab47-46cbab205894same address and namemerged12
2026-11-06 18:13insertoverture 61a853b8-1d66-4de1-ab47-46cbab205894 ↔ tx-tabc 200167453same address and namemerged11