Amigo Liquor and Mini Mart

Houston, TX 77017 · O6cf45377da2d · first seen 2026-11-02
6 sourcesoff premise · liquor_storealcohol: 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
Amigo Liquor and Mini Mart 2 other
the most common name a source states
AMIGO LIQUOR ab-inbevvtinfo ×2
C N D ENT LLC ttb (legal name)tx-tabc (legal name) ×2
Street
1508 Ahrens St
tx-tabcno other value
City
Houston
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77017
tx-tabcno other value
Pin
29.68804, -95.24588 map 1 other
ubereats
50 m away ab-inbev
Phone
8325825818
vtinfono other value
Licences
ttb TX-P-22546 · tx-tabc 200168799
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8ae4c74dae58; O85636b420578; Oec4e1f144453; Oda83f3d35cc4; Obb5af322e1f6

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-inbevAMIGO LIQUOR
4903677
1508 AHRENS ST, HOUSTON, TX, 7701729.68760, -95.246002026-11-112026-11-12
overtureAmigo Liquor And Mini Mart
cfc58ab6-a49b-4f99-a4a8-aca3a3563de2
1508 Ahrens St, Houston, TX, 77017832582581829.68789, -95.245772026-11-062026-11-06
ttbAmigo Liquor and Mini Mart
legal name: C N D ENT LLC
TX-P-22546
1508 AHRENS ST, HOUSTON, TX, 7701729.68785, -95.245672026-11-032026-11-05
tx-tabcAmigo Liquor and Mini Mart
legal name: C N D ENT LLC
200168799
1508 Ahrens St, Houston, TX, 7701729.68785, -95.245672026-11-022026-11-05
ubereatsAmigo Liquor and Mini Mart
fn-gF4X-X9eWmFnrE_rNyQ
1508 Ahrens St, Houston, TX, 7701729.68804, -95.245882026-11-022026-11-03
vtinfoAMIGO LIQUOR
2b1aeff77e73451b
1508 AHRENS ST, HOUSTON, TX, 77017832582581829.68787, -95.245742026-11-122026-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 AMIGO LIQUORvtinfo AMIGO LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
overture Amigo Liquor And Mini Martttb Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
overture Amigo Liquor And Mini Marttx-tabc Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
overture Amigo Liquor And Mini Martubereats Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ttb Amigo Liquor and Mini Marttx-tabc Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ttb Amigo Liquor and Mini Martubereats Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
tx-tabc Amigo Liquor and Mini Martubereats Amigo Liquor and Mini Mart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev AMIGO LIQUORubereats Amigo Liquor and Mini Mart0.60Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Same name core, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 1508 Ahrens St, Houston 77017 (distance about 50 m), only one business is held at that address, and the names 'AMIGO LIQUOR' and 'Amigo Liquor and Mini Mart' clearly refer to the same liquor store operation.
pair 33a513e857920dbc53d0

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
C N D ENT LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — TX Retail/P
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
22 within 1 mi · 454 within 3 mi
Off / on premise
9 / 2 within 1 mi · 122 / 110 within 3 mi
Selling alcohol
20 within 1 mi · 372 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.03 mi
Setting
urban (4,390 people per sq mi)
People within 3 mi
124,119 (83,950 adults 21+, 41,537 households) from 36 tract(s), tracts within 3 mi
Income
per capita $22,332 · median household ~$52,485 (weighted mean of tract medians)
Age and education
median age ~33.3 · bachelor's or higher 11%
Ethnicity
Hispanic 83% · White 19% · Black 8% · Asian 3%
Adults per alcohol outlet
225
Alcohol spend within 3 mi
$19,669,101 a year ($9,659,135 at home, $10,001,550 away) · $52,732 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-12 17:29insertab-inbev 4903677 ↔ ubereats fn-gF4X-X9eWmFnrE_rNyQClaude judge: samemerged14
2026-11-12 14:25insertab-inbev 4903677 ↔ vtinfo 2b1aeff77e73451bsame address and namemerged12
2026-11-06 18:13insertoverture cfc58ab6-a49b-4f99-a4a8-aca3a3563de2 ↔ ttb TX-P-22546same address and namemerged11
2026-11-06 18:13insertoverture cfc58ab6-a49b-4f99-a4a8-aca3a3563de2 ↔ ubereats fn-gF4X-X9eWmFnrE_rNyQsame address and namemerged11
2026-11-06 18:13insertoverture cfc58ab6-a49b-4f99-a4a8-aca3a3563de2 ↔ tx-tabc 200168799same address and namemerged11
2026-11-03 13:33backfillttb TX-P-22546 ↔ ubereats fn-gF4X-X9eWmFnrE_rNyQsame address and namemerged
2026-11-03 13:33backfillttb TX-P-22546 ↔ tx-tabc 200168799same address and namemerged
2026-11-03 13:33backfilltx-tabc 200168799 ↔ ubereats fn-gF4X-X9eWmFnrE_rNyQsame address and namemerged