Mad Dogs

SAN ANTONIO, TX 78205 · O31ad5e9ded0c · first seen 2026-11-02
3 sourceson premise · predictedalcohol: 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
Mad Dogs 1 other
a licence name in capitals, cleaned (derived; record_title.py)
MD BEVCO INC. tx-tabc
Street
123 LOSOYA ST SUITE 19 1 other
tx-tabc
123 LOSOYA ST STE 19 ab-inbevvtinfo ×2
City
San Antonio
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
78205
tx-tabcno other value
Pin
29.42585, -98.48799 map
tx-tabcno other value
Phone
2102220220
vtinfono other value
Licences
tx-tabc 100086139
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe34935f10ad1; Obc7098357cc6

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-inbevMAD DOGS
159699
123 LOSOYA ST STE 19, SAN ANTONIO, TX, 7820529.42563, -98.487982026-11-132026-11-18
tx-tabcMD BEVCO INC.
100086139
123 LOSOYA ST SUITE 19, San Antonio, TX, 7820529.42585, -98.487992026-11-022026-11-04
vtinfoMAD DOGS
591259d7b6f96080
123 LOSOYA ST STE 19, SAN ANTONIO, TX, 78205210222022029.42557, -98.488242026-11-122026-11-18

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 MAD DOGSvtinfo MAD DOGS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00
ab-inbev MAD DOGStx-tabc MD BEVCO INC.0.25Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Same suite; MD Bevco plausibly Mad Dogs entity
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records sit at the same street address and suite (123 Losoya St Ste 19, ZIP 78205) with coordinates 24 m apart, and 'MD BEVCO INC.' plausibly is the legal entity behind the trade name 'MAD DOGS' (MD = Mad Dogs), though the names do not match outright in a building with five businesses.
pair 675190841fbf995e56bd
tx-tabc MD BEVCO INC.vtinfo MAD DOGS0.25Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Same suite; MD Bevco plausibly Mad Dogs legal entity.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 62% confident — Both records sit in the same suite (Suite 19 / Ste 19) at 123 Losoya St, ZIP 78205, with coordinates about 40 m apart, and 'MD BEVCO' reads like a beverage company whose initials could stand for MAD DOGS, but the names do not agree outright and the building holds five businesses, so the match rests on the suite and the plausible initials.
pair 5e3313cde68baf2671d2

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MD BEVCO INC. — 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": []
}

Trade area

Other outlets
520 within 1 mi · 1,179 within 3 mi
Off / on premise
44 / 159 within 1 mi · 161 / 347 within 3 mi
Selling alcohol
446 within 1 mi · 944 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
urban (4,719 people per sq mi)
People within 3 mi
133,419 (98,884 adults 21+, 51,534 households) from 37 tract(s), tracts within 3 mi
Income
per capita $30,166 · median household ~$52,773 (weighted mean of tract medians)
Age and education
median age ~35.5 · bachelor's or higher 22%
Ethnicity
Hispanic 75% · White 36% · Black 6% · Asian 1%
Adults per alcohol outlet
105
Alcohol spend within 3 mi
$25,571,461 a year ($12,337,218 at home, $13,220,408 away) · $27,060 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-18 18:58insertab-inbev 159699 ↔ tx-tabc 100086139Claude judge: samemerged15
2026-11-18 18:58inserttx-tabc 100086139 ↔ vtinfo 591259d7b6f96080Claude judge: samemerged15
2026-11-13 14:10insertab-inbev 159699 ↔ vtinfo 591259d7b6f96080same address and namemerged15