The Blue Bar

Mercedes, TX 78570 · O5a521c6a08f3 · 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
The Blue Bar 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Trevino's Blue Bar overture
Trevino’s Blue Bar LLC tx-tabc
Street
313 S Ohio Ave 1 other
tx-tabc
313 S OHIO ST ab-inbevvtinfo ×2
City
Mercedes
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
78570
tx-tabcno other value
Pin
26.14865, -97.91229 map
overtureno other value
Phone
9565659077 1 other
vtinfo
9568904773 overture
Licences
tx-tabc 200097420
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7f2aea02b414; O6667b3a94856; O70b5f9303f2a

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 BAR
2400647
313 S OHIO ST, MERCEDES, TX, 7857026.14844, -97.912242026-11-112026-11-15
overtureTrevino's Blue Bar
bf67b8c4-c059-4dde-ae64-50dc2dc45e57
313 S Ohio Ave, Mercedes, TX, 78570956890477326.14865, -97.912292026-11-062026-11-19
tx-tabcTrevino’s Blue Bar LLC
200097420
313 S Ohio Ave, Mercedes, TX, 7857026.14881, -97.912252026-11-022026-11-19
vtinfoTHE BLUE BAR
df918ef2a03b0be6
313 S OHIO ST, MERCEDES, TX, 78570956565907726.14867, -97.912532026-11-152026-11-15

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 BARvtinfo THE BLUE BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
overture Trevino's Blue Bartx-tabc Trevino’s Blue Bar LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
tx-tabc Trevino’s Blue Bar LLCvtinfo THE BLUE BAR0.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Blue Bar at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records sit at 313 S Ohio (St/Ave) in Mercedes, TX 78570, about 33 m apart, with only one business at that address, and the names share the distinctive 'Blue Bar' with Trevino's Blue Bar LLC being the legal entity behind THE BLUE BAR listing.
pair 219f4023d552e1d5f6b5

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Trevino’s Blue Bar LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — TX Retail/BG
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 69 within 3 mi
Off / on premise
13 / 6 within 1 mi · 21 / 14 within 3 mi
Selling alcohol
30 within 1 mi · 59 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.02 mi
Setting
suburban (743 people per sq mi)
People within 3 mi
21,005 (13,563 adults 21+, 6,428 households) from 4 tract(s), tracts within 3 mi
Income
per capita $19,276 · median household ~$47,084 (weighted mean of tract medians)
Age and education
median age ~31.8 · bachelor's or higher 16%
Ethnicity
Hispanic 94% · White 41% · Black 1% · Asian 0%
Adults per alcohol outlet
226
Alcohol spend within 3 mi
$3,005,503 a year ($1,472,688 at home, $1,530,804 away) · $50,092 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 200097420 ↔ vtinfo df918ef2a03b0be6Claude judge: samemerged17
2026-11-15 16:24insertab-inbev 2400647 ↔ vtinfo df918ef2a03b0be6same address and namemerged15
2026-11-06 18:13insertoverture bf67b8c4-c059-4dde-ae64-50dc2dc45e57 ↔ tx-tabc 200097420same address and namemerged11