Legacy - Spec's - Huntsville

Huntsville, TX 77340 · O0c27c891ec0f · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: Spec'salcohol: licensed2 licences

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
Legacy - Spec's - Huntsville 5 other
the most common name a source states
SPEC'S FAMILY CORP. ttb (legal name)tx-tabc (legal name)tx-tobacco (legal name) ×3
Spec's Wines & Spirits Spec's Liquor #44 SFP Distribution ttbtx-tabc ×2
Spec's - Huntsville ubereats
SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST tx-tobacco
SPECS WINE SPIRITS & FINER FOODS ab-inbev
Street
207 IH 45 S 4 other
tx-tabc
207 INTERSTATE 45 S ab-inbevtx-tobacco ×2
207 Interstate 45 South ubereats
207 Interstate 45 South , Hunstville ubereats
207 S IH 45 ttb
City
Huntsville 2 other
tx-tabc
Houston ubereats
Hunstville ubereats
State
TX
tx-tabcno other value
ZIP
77340
tx-tabcno other value
Pin
30.71129, -95.56658 map 2 other
ubereats
350 m away ab-inbev
2.9 km away ttb
Phone
none
no other value
Licences
ttb TX-P-22249 · tx-tabc 104139732
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O59ba86bd72e6; O3c06b85d3ac9; O6fdd2e049295; O9f84bc45c1db; O3ac72b9c8314

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-inbevSPECS WINE SPIRITS & FINER FOODS
3773037
207 INTERSTATE 45 S, HUNTSVILLE, TX, 7734030.70893, -95.564162026-11-112026-11-18
ttbSpec's Wines & Spirits Spec's Liquor #44 SFP Distribution
legal name: SPEC'S FAMILY CORP.
TX-P-22249
207 S IH 45, HUNTSVILLE, TX, 7734030.70565, -95.536522026-11-032026-11-12
tx-tabcSPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION
legal name: SPEC'S FAMILY CORP
104139732
207 IH 45 S, Huntsville, TX, 773402026-11-022026-11-12
tx-tobaccoSPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST
legal name: SPEC'S FAMILY CORP.
tx-tobacco|17427437011|126
207 INTERSTATE 45 S, Huntsville, TX, 773402026-11-202026-11-20
ubereatsSpec's - Huntsville
5MYkXyU-Wi-yMO3DTGm1TQ
207 Interstate 45 South , Hunstville, Houston, TX, 77340
ZIP lookup: Huntsville, TX
30.71129, -95.566582026-10-082026-11-19
ubereatsLegacy - Spec's - Huntsville
F_11fPYqXE2_wX3q6w-reQ
207 Interstate 45 South, Hunstville, TX, 77340
ZIP lookup: Huntsville, TX
30.71112, -95.566332026-10-082026-11-03

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
ttb Spec's Wines & Spirits Spec's Liquor #44 SFP Distributiontx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.87
ttb Spec's Wines & Spirits Spec's Liquor #44 SFP Distributiontx-tobacco SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.87
tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTIONtx-tobacco SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: SPEC'S FAMILY CORP · name similarity 1.00
tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTIONubereats Spec's - Huntsville0.45Claude judge: samemerged both outlets held a record of one source, each naming the same business
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Spec's Huntsville at same address, both Spec's.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are Spec's at 207 IH 45 S / 207 Interstate 45 South with ZIP 77340 and Huntsville in the name, and the coordinates fall in Huntsville, so the city 'Houston' is an Uber Eats error; this is one Spec's store seen through the TABC licence and its delivery listing, not a separate liquor premises.
pair 60b1672c81154ad737d8
ab-inbev SPECS WINE SPIRITS & FINER FOODStx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION0.42Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Spec's store same address; both Spec's liquor store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Spec's at 207 Interstate 45 S / IH 45 S, Huntsville TX 77340, and the tx-tabc legal entity SPEC'S FAMILY CORP is the chain's operator, so the AB InBev listing and the TABC licence describe the same Spec's store rather than a separate concession.
pair fb802d86a14b5f3e4830
tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTIONubereats Legacy - Spec's - Huntsville0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Spec's store itself, same address; Uber listing is the store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 82% confident — Both records are Spec's at 207 Interstate 45 South, Huntsville, ZIP 77340, and the TABC licensee SPEC'S FAMILY CORP is the Spec's chain entity, so the Uber Eats listing reads as the same store's own listing rather than a separate premises.
pair 1a1b2857cb82c750895e
ab-inbev SPECS WINE SPIRITS & FINER FOODSubereats Spec's - Huntsville0.26Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “control” pair)
Spec's Huntsville at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are Spec's stores at 207 Interstate 45 South, Huntsville, ZIP 77340, with coordinates about 0.35 km apart and the same chain name; the Uber Eats city field reads 'Houston' and the street has a typo, but the address and ZIP agree, so this looks like the same store listed on the delivery app.
pair 6c8c4c4872df14c6fa78
ab-inbev SPECS WINE SPIRITS & FINER FOODSubereats Legacy - Spec's - Huntsville0.24Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Spec's at same address in Huntsville
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 207 Interstate 45 South in Huntsville, TX (ZIP 77340, with a city typo on one side), and Uber Eats lists the store as a Spec's location, matching the AB InBev 'Specs Wine Spirits & Finer Foods' entry at the same address; the two businesses at the address are not in dispute here since the Legacy/Spec's listing is the same store's storefront.
pair b011010c85dcf0db87c3

Attributes

Channel
off_premise · liquor_store — name
Chain
Spec's — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
SPEC'S FAMILY CORP — 246 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — TX Retail/P
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": []
}

Trade area

Other outlets
89 within 1 mi · 174 within 3 mi
Off / on premise
22 / 40 within 1 mi · 49 / 58 within 3 mi
Selling alcohol
59 within 1 mi · 136 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
suburban (1,140 people per sq mi)
People within 3 mi
32,244 (21,986 adults 21+, 11,434 households) from 4 tract(s), tracts within 3 mi
Income
per capita $19,182 · median household ~$37,090 (weighted mean of tract medians)
Age and education
median age ~26.2 · bachelor's or higher 21%
Ethnicity
Hispanic 24% · White 53% · Black 24% · Asian 1%
Adults per alcohol outlet
160
Alcohol spend within 3 mi
$4,246,826 a year ($2,209,689 at home, $2,035,396 away) · $30,999 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:08insertttb TX-P-22249 ↔ tx-tobacco tx-tobacco|17427437011|126street written two waysmerged17
2026-11-20 22:08inserttx-tabc 104139732 ↔ tx-tobacco tx-tobacco|17427437011|126same address and namemerged17
2026-11-19 20:37updateab-inbev 3773037 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQClaude judge: samemerged17
2026-11-19 20:37updatetx-tabc 104139732 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQClaude judge: samemerged17
2026-11-18 18:58insertab-inbev 3773037 ↔ ubereats F_11fPYqXE2_wX3q6w-reQClaude judge: samemerged15
2026-11-18 18:58insertab-inbev 3773037 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQClaude judge: sameheld: same-source-conflict15
2026-11-18 18:58insertab-inbev 3773037 ↔ tx-tabc 104139732Claude judge: samemerged15
2026-11-18 18:58inserttx-tabc 104139732 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQClaude judge: sameheld: same-source-conflict15
2026-11-12 17:29inserttx-tabc 104139732 ↔ ubereats F_11fPYqXE2_wX3q6w-reQClaude judge: samemerged14
2026-11-03 17:53backfillttb TX-P-22249 ↔ tx-tabc 104139732street written two waysmerged