Johnny McElroy's Irish Pub

Houston, TX 77019 · O5fcfdb3522b0 · 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
Johnny McElroy's Irish Pub 3 other
a licence name in capitals, cleaned (derived; record_title.py)
JOHNNY MCELROYS IRISH PUB ab-inbevvtinfo ×2
Johnny McElroy's Irish Pub & Patio overture
PADDY HORAN'S IRISH PUB INC. tx-tabc (legal name)
Street
1223 WAUGH DR
tx-tabcno other value
City
Houston
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77019
tx-tabcno other value
Pin
29.75578, -95.39792 map
overtureno other value
Phone
7135200088 1 other
vtinfo
7135232444 overture
Licences
tx-tabc 101395018
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O89ad857f80ef; Oe9871095bd8b; O75b6047a4cc5

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-inbevJOHNNY MCELROYS IRISH PUB
3950736
1223 WAUGH DR, HOUSTON, TX, 7701929.75551, -95.398002026-11-112026-11-12
overtureJohnny McElroy's Irish Pub & Patio
a3f3a4b8-eecc-4700-a402-3a96a9760898
1223 Waugh Dr, Houston, TX, 77019713523244429.75578, -95.397922026-11-062026-11-12
tx-tabcJOHNNY MCELROY'S IRISH PUB
legal name: PADDY HORAN'S IRISH PUB INC.
101395018
1223 WAUGH DR, Houston, TX, 7701929.75587, -95.398022026-11-022026-11-12
vtinfoJOHNNY MCELROYS IRISH PUB
1b7514c34da43347
1223 WAUGH DR, HOUSTON, TX, 77019713520008829.75583, -95.397572026-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 JOHNNY MCELROYS IRISH PUBtx-tabc JOHNNY MCELROY'S IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
ab-inbev JOHNNY MCELROYS IRISH PUBvtinfo JOHNNY MCELROYS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 55 m apart · name similarity 1.00
tx-tabc JOHNNY MCELROY'S IRISH PUBvtinfo JOHNNY MCELROYS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 44 m apart · name similarity 1.00
ab-inbev JOHNNY MCELROYS IRISH PUBoverture Johnny McElroy's Irish Pub & Patio0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 32 m apart · name similarity 0.85
overture Johnny McElroy's Irish Pub & Patiotx-tabc JOHNNY MCELROY'S IRISH PUB0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 14 m apart · name similarity 0.85
overture Johnny McElroy's Irish Pub & Patiovtinfo JOHNNY MCELROYS IRISH PUB0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + city + state · pins 34 m apart · name similarity 0.85 · phone: differs

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PADDY HORAN'S IRISH PUB INC. — 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:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
287 within 1 mi · 2,012 within 3 mi
Off / on premise
34 / 131 within 1 mi · 251 / 752 within 3 mi
Selling alcohol
230 within 1 mi · 1,555 within 3 mi
Nearest
same channel 0.12 mi · licensed 0.02 mi
Setting
urban (7,495 people per sq mi)
People within 3 mi
211,910 (181,147 adults 21+, 108,380 households) from 67 tract(s), tracts within 3 mi
Income
per capita $95,911 · median household ~$128,851 (weighted mean of tract medians)
Age and education
median age ~36.3 · bachelor's or higher 71%
Ethnicity
Hispanic 19% · White 55% · Black 14% · Asian 10%
Adults per alcohol outlet
116
Alcohol spend within 3 mi
$96,889,995 a year ($41,916,698 at home, $54,938,710 away) · $62,269 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:25insertoverture a3f3a4b8-eecc-4700-a402-3a96a9760898 ↔ vtinfo 1b7514c34da43347same address and namemerged12
2026-11-12 14:25insertab-inbev 3950736 ↔ vtinfo 1b7514c34da43347same address and namemerged12
2026-11-12 14:25inserttx-tabc 101395018 ↔ vtinfo 1b7514c34da43347same address and namemerged12
2026-11-11 12:56insertab-inbev 3950736 ↔ overture a3f3a4b8-eecc-4700-a402-3a96a9760898same address and namemerged12
2026-11-11 12:56insertab-inbev 3950736 ↔ tx-tabc 101395018same address and namemerged12
2026-11-06 18:13insertoverture a3f3a4b8-eecc-4700-a402-3a96a9760898 ↔ tx-tabc 101395018same address and namemerged11