McElroy's Pub

Houston, TX 77098 · O15c4fcba94c6 · first seen 2026-11-02
4 sourceson premise · baralcohol: 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
McElroy's Pub 2 other
a source's own spelling of the licence name (record_title.py)
MCELROYS PUB ab-inbevvtinfo ×2
MCELROY'S PUB INCORPORATED tx-tabc (legal name)
Street
3607 S SANDMAN ST
tx-tabcno other value
City
Houston
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77098
tx-tabcno other value
Pin
29.73387, -95.41139 map
overtureno other value
Phone
7135242444
vtinfono other value
Licences
tx-tabc 100107916
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9924cfb7fafd; Ofdaa2898d32f; O50bed43854b1

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-inbevMCELROYS PUB
159302
3607 S SANDMAN ST, HOUSTON, TX, 7709829.73372, -95.411402026-11-112026-11-11
overtureMcElroy's Pub
6b6c018d-8c61-4639-81b7-5ed254b23638
3607 S Sandman St, Houston, TX, 77098713524244429.73387, -95.411392026-11-062026-11-06
tx-tabcMCELROY'S PUB
legal name: MCELROY'S PUB INCORPORATED
100107916
3607 S SANDMAN ST, Houston, TX, 7709829.73412, -95.411392026-11-022026-11-06
vtinfoMCELROYS PUB
71951f818c233792
3607 S SANDMAN ST, HOUSTON, TX, 77098713524244429.73389, -95.411262026-11-122026-11-14

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 MCELROYS PUBoverture McElroy's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev MCELROYS PUBtx-tabc MCELROY'S PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
ab-inbev MCELROYS PUBvtinfo MCELROYS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
overture McElroy's Pubtx-tabc MCELROY'S PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
overture McElroy's Pubvtinfo MCELROYS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00 · phone: equal
tx-tabc MCELROY'S PUBvtinfo MCELROYS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MCELROY'S PUB INCORPORATED — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — TX Retail/MB
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
270 within 1 mi · 1,602 within 3 mi
Off / on premise
39 / 121 within 1 mi · 227 / 612 within 3 mi
Selling alcohol
240 within 1 mi · 1,253 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (7,197 people per sq mi)
People within 3 mi
203,488 (171,302 adults 21+, 108,108 households) from 71 tract(s), tracts within 3 mi
Income
per capita $98,857 · median household ~$122,959 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 78%
Ethnicity
Hispanic 16% · White 58% · Black 11% · Asian 13%
Adults per alcohol outlet
137
Alcohol spend within 3 mi
$93,346,042 a year ($40,608,049 at home, $52,704,868 away) · $74,439 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 14:25inserttx-tabc 100107916 ↔ vtinfo 71951f818c233792same address and namemerged12
2026-11-12 14:25insertoverture 6b6c018d-8c61-4639-81b7-5ed254b23638 ↔ vtinfo 71951f818c233792same address and namemerged12
2026-11-12 14:25insertab-inbev 159302 ↔ vtinfo 71951f818c233792same address and namemerged12
2026-11-11 12:56insertab-inbev 159302 ↔ tx-tabc 100107916same address and namemerged12
2026-11-11 12:56insertab-inbev 159302 ↔ overture 6b6c018d-8c61-4639-81b7-5ed254b23638same address and namemerged12
2026-11-06 18:13insertoverture 6b6c018d-8c61-4639-81b7-5ed254b23638 ↔ tx-tabc 100107916same address and namemerged11