Outlets /
Spec's Wine Spirits & Finer Foods
College Station, TX 77845 · O314b673ccd03 · first seen 2026-10-08
7 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 | Spec's Wine Spirits & Finer Foods 7 other | a licence name in capitals, cleaned (derived; record_title.py) | Spec's specsubereats ×2 SPEC'S FAMILY CORP. ttb (legal name)tx-tabc (legal name) ×2 SPECS WINE SPIRITS & FINER FOODS ab-inbevvtinfo ×2 JJ's Liquor Distribution Spec's Liquor Wine & Beer ttb JJ'S LIQUORS SFP DISTRIBUTION SPEC'S LIQUOR WINE & BEER SPE tx-tabc Legacy - Spec's - Longmire ubereats Spec's Wines, Spirits & Finer Foods overture |
| Street | 3505 Longmire Dr 2 other | specs | 3505 LONGMIRE DR STE G ab-inbevttbtx-tabcubereatsvtinfo ×5 3505 Longmire Drive Ste G ubereats |
| City | College Station | specs | no other value |
| State | TX | specs | no other value |
| ZIP | 77845 | specs | no other value |
| Pin | 30.58300, -96.28600 map 4 other | specs | 77 m away ab-inbev 123 m away ttb 123 m away tx-tabc 194 m away vtinfo |
| Phone | 9796962002 | specs | no other value |
| Licences | ttb TX-P-22107 · tx-tabc 102688100 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe44f9d7832e7; Oe831cb385402; O7e2ac39e5237; Od79685361834; O6edff2585f94; Oa5bc3abcd50b; Obc47c4bfe4b7
Carries
Products seen on this outlet’s shelf in store-level catalogs.
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 2394550 | 3505 LONGMIRE DR STE G, COLLEGE STATION, TX, 77845 | 30.58280, -96.28677 | 2026-11-11 | 2026-11-12 | |
| overture | Spec's Wines, Spirits & Finer Foods 146766bf-0f3c-453e-a87c-2576981a2230 | 3505 Longmire Dr, College Station, TX, 77845 | 9796962002 | 30.58299, -96.28626 | 2026-11-13 | 2026-11-13 |
| specs | Spec's 7 | 3505 Longmire Dr, College Station, TX, 77845 | 9796962002 | 30.58300, -96.28600 | 2026-11-04 | 2026-11-19 |
| ttb | JJ's Liquor Distribution Spec's Liquor Wine & Beer legal name: SPEC'S FAMILY CORP. TX-P-22107 | 3505 LONGMIRE DR STE G, COLLEGE STATION, TX, 77845 | 30.58360, -96.28708 | 2026-11-03 | 2026-11-19 | |
| tx-tabc | JJ'S LIQUORS SFP DISTRIBUTION SPEC'S LIQUOR WINE & BEER SPE legal name: SPEC'S FAMILY CORP 102688100 | 3505 LONGMIRE DR STE G, College Station, TX, 77845 | 30.58360, -96.28708 | 2026-11-02 | 2026-11-19 | |
| ubereats | Legacy - Spec's - Longmire r7OhN4e0VFuFBN1Hzwsy4g | 3505 Longmire Drive Ste G, College Station, TX, 77845 | 30.58283, -96.28641 | 2026-10-08 | 2026-11-03 | |
| ubereats | Spec's YxSbKbbBUQO8W-qNNQyLLg | 3505 Longmire Dr, Ste G, College Station, TX, 77845 | 30.58300, -96.28615 | 2026-10-14 | 2026-11-19 | |
| vtinfo | SPECS WINE SPIRITS & FINER FOODS 6bb25e2852104530 | 3505 LONGMIRE DR STE G, COLLEGE STATION, TX, 77845 | 9796962002 | 30.58128, -96.28562 | 2026-11-13 | 2026-11-14 |
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 |
|---|---|---|---|---|---|
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | vtinfo SPECS WINE SPIRITS & FINER FOODS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 202 m apart · name similarity 1.00 |
| specs Spec's | ubereats Spec's | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | overture Spec's Wines, Spirits & Finer Foods | 0.82 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 53 m apart · name similarity 0.82 |
| overture Spec's Wines, Spirits & Finer Foods | vtinfo SPECS WINE SPIRITS & FINER FOODS | 0.82 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 199 m apart · name similarity 0.82 · phone: equal |
| ttb JJ's Liquor Distribution Spec's Liquor Wine & Beer | tx-tabc JJ'S LIQUORS SFP DISTRIBUTION SPEC'S LIQUOR WINE & BEER SPE | 0.75 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · name similarity 0.75 |
| tx-tabc JJ'S LIQUORS SFP DISTRIBUTION SPEC'S LIQUOR WINE & BEER SPE | ubereats Spec's | 0.54 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair) Spec's legal entity, same address and suite G. Other Claude answers on this pair:
pair 33dd3986f7cd954b568e |
| tx-tabc JJ'S LIQUORS SFP DISTRIBUTION SPEC'S LIQUOR WINE & BEER SPE | vtinfo SPECS WINE SPIRITS & FINER FOODS | 0.27 | 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 (88% confident; asked as a “same-address” pair) Spec's at same address and suite. Other Claude answers on this pair:
pair 07027d8e42f529358249 |
| ab-inbev SPECS WINE SPIRITS & FINER FOODS | ubereats Legacy - Spec's - Longmire | 0.23 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair) Spec's same address and suite Other Claude answers on this pair:
pair 39322a904381c652b37e |
Attributes
- Channel
- off_premise · liquor_store — chain-locator
- Chain
- Spec's — chain-locator
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- SPEC'S FAMILY CORP — 253 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — TX Retail/P
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"chain-locator",
"off_premise",
"liquor_store"
],
[
"ubereats-type",
"off_premise",
"liquor_store"
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 30 within 1 mi · 199 within 3 mi
- Off / on premise
- 7 / 11 within 1 mi · 48 / 72 within 3 mi
- Selling alcohol
- 19 within 1 mi · 137 within 3 mi
- Nearest
- same channel 0.03 mi · licensed 0.01 mi
- Setting
- suburban (2,470 people per sq mi)
- People within 3 mi
- 69,851 (48,677 adults 21+, 29,233 households) from 17 tract(s), tracts within 3 mi
- Income
- per capita $40,006 · median household ~$76,252 (weighted mean of tract medians)
- Age and education
- median age ~32.6 · bachelor's or higher 57%
- Ethnicity
- Hispanic 18% · White 65% · Black 8% · Asian 11%
- Adults per alcohol outlet
- 353
- Alcohol spend within 3 mi
- $18,039,941 a year ($8,341,357 at home, $9,691,015 away) · $130,724 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-19 20:37 | insert | tx-tabc 102688100 ↔ vtinfo 6bb25e2852104530 | Claude judge: same | merged | 17 |
| 2026-11-13 14:10 | insert | overture 146766bf-0f3c-453e-a87c-2576981a2230 ↔ vtinfo 6bb25e2852104530 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2394550 ↔ overture 146766bf-0f3c-453e-a87c-2576981a2230 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2394550 ↔ vtinfo 6bb25e2852104530 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | ab-inbev 2394550 ↔ ubereats r7OhN4e0VFuFBN1Hzwsy4g | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | tx-tabc 102688100 ↔ ubereats YxSbKbbBUQO8W-qNNQyLLg | Claude judge: same | merged | 14 |
| 2026-11-04 18:12 | backfill | specs 7 ↔ ubereats YxSbKbbBUQO8W-qNNQyLLg | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ttb TX-P-22107 ↔ tx-tabc 102688100 | same address and name | merged |