Ron's Pub

Houston, TX 77057 · O281a09d7bf3f · 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
Ron's Pub 2 other
the most common name a source states
RONS PUB ab-inbevvtinfo ×2
RPWHI, LLC tx-tabc (legal name)
Street
1826 Fountain View Dr 1 other
tx-tabc
1836 FOUNTAINVIEW ab-inbevvtinfo ×2
City
Houston
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77057
tx-tabcno other value
Pin
29.74857, -95.48638 map 1 other
overture
52 m away ab-inbev
Phone
7139774820
vtinfono other value
Licences
tx-tabc 200158036
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6e47778340ac; Oae545a91ae3f; O3df9568c0f19

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-inbevRONS PUB
155623
1836 FOUNTAINVIEW, HOUSTON, TX, 7705729.74810, -95.486352026-11-122026-11-12
overtureRon's Pub
5286042b-f2be-4089-a019-a7744f5ee27f
1826 Fountain View Dr, Houston, TX, 77057713977482029.74857, -95.486382026-11-062026-11-19
tx-tabcRon's Pub
legal name: RPWHI, LLC
200158036
1826 Fountain View Dr, Houston, TX, 7705729.74879, -95.486072026-11-022026-11-19
vtinfoRONS PUB
fe75165a0022cd32
1836 FOUNTAINVIEW, HOUSTON, TX, 77057713977482029.74817, -95.486222026-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 RONS PUBtx-tabc Ron's Pub1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same name, nearby number, 82 m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — The names match (RONS PUB and Ron's Pub), the city and ZIP agree, the coordinates are 82 m apart, and only one business is held at the address. The street numbers differ (1836 vs 1826), but that small gap is consistent with a transcription or geocoding error on the same street.
pair 1d405fbf9c8074da75e5
ab-inbev RONS PUBvtinfo RONS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
overture Ron's Pubtx-tabc Ron's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
tx-tabc Ron's Pubvtinfo RONS PUB1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Ron's Pub, adjacent street numbers, 70m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are named Ron's Pub (RONS PUB) in Houston 77057 with coordinates about 70 m apart, and only one business is held at the address; the street numbers differ (1826 vs 1836), but that is probably a data-entry variance for one independent pub, so they are most likely the same outlet.
pair 2864e1b995e33796a65d

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RPWHI, LLC — 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-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
181 within 1 mi · 1,066 within 3 mi
Off / on premise
31 / 67 within 1 mi · 172 / 346 within 3 mi
Selling alcohol
141 within 1 mi · 815 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
urban (7,160 people per sq mi)
People within 3 mi
202,446 (156,419 adults 21+, 94,085 households) from 69 tract(s), tracts within 3 mi
Income
per capita $62,950 · median household ~$84,375 (weighted mean of tract medians)
Age and education
median age ~36.0 · bachelor's or higher 52%
Ethnicity
Hispanic 39% · White 39% · Black 13% · Asian 10%
Adults per alcohol outlet
192
Alcohol spend within 3 mi
$62,264,912 a year ($28,395,186 at home, $33,853,025 away) · $76,305 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-19 20:37inserttx-tabc 200158036 ↔ vtinfo fe75165a0022cd32Claude judge: samemerged17
2026-11-19 20:37insertab-inbev 155623 ↔ tx-tabc 200158036Claude judge: samemerged17
2026-11-12 14:25insertab-inbev 155623 ↔ vtinfo fe75165a0022cd32same address and namemerged12
2026-11-06 18:13insertoverture 5286042b-f2be-4089-a019-a7744f5ee27f ↔ tx-tabc 200158036same address and namemerged11