Outlets /
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.
| Field | Master value | Taken from | What 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-tabc | no other value |
| ZIP | 77340 | tx-tabc | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SPECS WINE SPIRITS & FINER FOODS 3773037 | 207 INTERSTATE 45 S, HUNTSVILLE, TX, 77340 | 30.70893, -95.56416 | 2026-11-11 | 2026-11-18 | |
| ttb | Spec's Wines & Spirits Spec's Liquor #44 SFP Distribution legal name: SPEC'S FAMILY CORP. TX-P-22249 | 207 S IH 45, HUNTSVILLE, TX, 77340 | 30.70565, -95.53652 | 2026-11-03 | 2026-11-12 | |
| tx-tabc | SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION legal name: SPEC'S FAMILY CORP 104139732 | 207 IH 45 S, Huntsville, TX, 77340 | 2026-11-02 | 2026-11-12 | ||
| tx-tobacco | SPEC'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, 77340 | 2026-11-20 | 2026-11-20 | ||
| ubereats | Spec's - Huntsville 5MYkXyU-Wi-yMO3DTGm1TQ | 207 Interstate 45 South , Hunstville, Houston, TX, 77340 ZIP lookup: Huntsville, TX | 30.71129, -95.56658 | 2026-10-08 | 2026-11-19 | |
| ubereats | Legacy - Spec's - Huntsville F_11fPYqXE2_wX3q6w-reQ | 207 Interstate 45 South, Hunstville, TX, 77340 ZIP lookup: Huntsville, TX | 30.71112, -95.56633 | 2026-10-08 | 2026-11-03 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ttb Spec's Wines & Spirits Spec's Liquor #44 SFP Distribution | tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION | 1.00 | street written two ways | merged | name 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 Distribution | tx-tobacco SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST | 1.00 | street written two ways | merged | name 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 DISTRIBUTION | tx-tobacco SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DIST | 1.00 | same address and name | merged | address 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 DISTRIBUTION | ubereats Spec's - Huntsville | 0.45 | Claude judge: same | merged 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:
pair 60b1672c81154ad737d8 |
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION | 0.42 | Claude judge: same | merged | 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:
pair fb802d86a14b5f3e4830 |
| tx-tabc SPEC'S WINES & SPIRITS SPEC'S LIQUOR #44 SFP DISTRIBUTION | ubereats Legacy - Spec's - Huntsville | 0.38 | Claude judge: same | merged | 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:
pair 1a1b2857cb82c750895e |
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | ubereats Spec's - Huntsville | 0.26 | Claude judge: same | merged | 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:
pair 6c8c4c4872df14c6fa78 |
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | ubereats Legacy - Spec's - Huntsville | 0.24 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | ttb TX-P-22249 ↔ tx-tobacco tx-tobacco|17427437011|126 | street written two ways | merged | 17 |
| 2026-11-20 22:08 | insert | tx-tabc 104139732 ↔ tx-tobacco tx-tobacco|17427437011|126 | same address and name | merged | 17 |
| 2026-11-19 20:37 | update | ab-inbev 3773037 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQ | Claude judge: same | merged | 17 |
| 2026-11-19 20:37 | update | tx-tabc 104139732 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQ | Claude judge: same | merged | 17 |
| 2026-11-18 18:58 | insert | ab-inbev 3773037 ↔ ubereats F_11fPYqXE2_wX3q6w-reQ | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 3773037 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQ | Claude judge: same | held: same-source-conflict | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 3773037 ↔ tx-tabc 104139732 | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | tx-tabc 104139732 ↔ ubereats 5MYkXyU-Wi-yMO3DTGm1TQ | Claude judge: same | held: same-source-conflict | 15 |
| 2026-11-12 17:29 | insert | tx-tabc 104139732 ↔ ubereats F_11fPYqXE2_wX3q6w-reQ | Claude judge: same | merged | 14 |
| 2026-11-03 17:53 | backfill | ttb TX-P-22249 ↔ tx-tabc 104139732 | street written two ways | merged |