The Blue Rooster

HOUSTON, TX 77065 · O257095037085 · 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
The Blue Rooster 2 other
a licence name in capitals, cleaned (derived; record_title.py)
CJJC Group LLC tx-tabc (legal name)
The Blue Rooster Irish Pub tx-tabc
Street
19817 Northwest Fwy
tx-tabcno other value
City
Houston
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77065
tx-tabcno other value
Pin
29.91246, -95.61357 map 2 other
tx-tabc
221 m away ab-inbev
229 m away vtinfo
Phone
3465696034
vtinfono other value
Licences
tx-tabc 200133384
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of9babca7a6e6; Od22ec515be82

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-inbevTHE BLUE ROOSTER
4815317
19817 NORTHWEST FWY, HOUSTON, TX, 7706529.91380, -95.615262026-11-112026-11-13
tx-tabcThe Blue Rooster Irish Pub
legal name: CJJC Group LLC
200133384
19817 Northwest Fwy, Houston, TX, 7706529.91246, -95.613572026-11-022026-11-16
vtinfoTHE BLUE ROOSTER
84c1182c967cd8cd
19817 NORTHWEST FWY, HOUSTON, TX, 77065346569603429.91388, -95.615292026-11-132026-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 THE BLUE ROOSTERvtinfo THE BLUE ROOSTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ab-inbev THE BLUE ROOSTERtx-tabc The Blue Rooster Irish Pub0.60one name contains the other, same addressmergedjudge: None · pair_id: aa0f44f980522fced315 · person: None · rule: names contained at one address · stratum: near
tx-tabc The Blue Rooster Irish Pubvtinfo THE BLUE ROOSTER0.60one name contains the other, same addressmergedjudge: None · pair_id: d48502a5e100dccfa2a8 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CJJC Group LLC — 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
57 within 1 mi · 390 within 3 mi
Off / on premise
14 / 20 within 1 mi · 93 / 111 within 3 mi
Selling alcohol
42 within 1 mi · 285 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.01 mi
Setting
urban (3,641 people per sq mi)
People within 3 mi
102,933 (76,742 adults 21+, 39,580 households) from 23 tract(s), tracts within 3 mi
Income
per capita $39,270 · median household ~$81,700 (weighted mean of tract medians)
Age and education
median age ~37.8 · bachelor's or higher 35%
Ethnicity
Hispanic 38% · White 36% · Black 16% · Asian 12%
Adults per alcohol outlet
268
Alcohol spend within 3 mi
$25,758,924 a year ($11,910,128 at home, $13,837,847 away) · $90,066 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-16 14:56inserttx-tabc 200133384 ↔ vtinfo 84c1182c967cd8cdone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4815317 ↔ tx-tabc 200133384one name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 4815317 ↔ vtinfo 84c1182c967cd8cdsame address and namemerged15