Flying Pig Grill and Cantina

OLMITO, TX 78575 · O066800ebb92f · 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
Flying Pig Grill and Cantina 1 other
a licence name in capitals, cleaned (derived; record_title.py)
PUERQUITO ENTERPRISES LLC tx-tabc (legal name)
Street
7197 N EXPRESSWAY 77 1 other
tx-tabc
7197 HWY 83 N ab-inbevvtinfo ×2
City
Brownsville 1 other
tx-tabc
OLMITO ab-inbevvtinfo ×2
State
TX
tx-tabcno other value
ZIP
78575
tx-tabcno other value
Pin
26.02656, -97.53205 map
ab-inbevno other value
Phone
9563505555
vtinfono other value
Licences
tx-tabc 103115957
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc45361c4821c; O5606a6498d73

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-inbevFLYING PIG GRILL AND CANTINA
3428358
7197 HWY 83 N, OLMITO, TX, 7857526.02656, -97.532052026-11-112026-11-14
tx-tabcFLYING PIG GRILL AND CANTINA
legal name: PUERQUITO ENTERPRISES LLC
103115957
7197 N EXPRESSWAY 77, Brownsville, TX, 785752026-11-022026-11-18
vtinfoFLYING PIG GRILL AND CANTINA
88705da8db2ffe5b
7197 HWY 83 N, OLMITO, TX, 78575956350555526.02656, -97.532052026-11-142026-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 FLYING PIG GRILL AND CANTINAtx-tabc FLYING PIG GRILL AND CANTINA1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Identical distinctive name, same number, same ZIP highway
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records carry the identical name 'Flying Pig Grill and Cantina', the same street number 7197, the same ZIP 78575, and nearby cities (Olmito and Brownsville), with only one business at the address; the road names (Hwy 83 N and Expressway 77) plausibly describe the same highway frontage.
pair c92997cdfaeaebf2fa26
ab-inbev FLYING PIG GRILL AND CANTINAvtinfo FLYING PIG GRILL AND CANTINA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
tx-tabc FLYING PIG GRILL AND CANTINAvtinfo FLYING PIG GRILL AND CANTINA1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Distinctive name, same number, same ZIP, highway aliases
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — The names match exactly (Flying Pig Grill and Cantina), the street numbers match (7197), the ZIPs match (78575), and only one business is held at that address, though the road names and cities (Brownsville vs Olmito) differ, so the address match is not perfect.
pair 2624fea34874af8d744c

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PUERQUITO ENTERPRISES 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:31.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
21 within 1 mi · 26 within 3 mi
Off / on premise
9 / 5 within 1 mi · 9 / 7 within 3 mi
Selling alcohol
18 within 1 mi · 23 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.09 mi
Setting
suburban (884 people per sq mi)
People within 3 mi
24,999 (15,259 adults 21+, 7,335 households) from 5 tract(s), tracts within 3 mi
Income
per capita $33,641 · median household ~$89,536 (weighted mean of tract medians)
Age and education
median age ~33.6 · bachelor's or higher 37%
Ethnicity
Hispanic 92% · White 31% · Black 0% · Asian 2%
Adults per alcohol outlet
636
Alcohol spend within 3 mi
$5,257,869 a year ($2,421,887 at home, $2,832,926 away) · $219,078 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-18 18:58insertab-inbev 3428358 ↔ tx-tabc 103115957Claude judge: samemerged15
2026-11-18 18:58inserttx-tabc 103115957 ↔ vtinfo 88705da8db2ffe5bClaude judge: samemerged15
2026-11-14 20:23insertab-inbev 3428358 ↔ vtinfo 88705da8db2ffe5bsame address and namemerged15