El Ranchito Mexican Rest

UNION, MO 63084 · O6ce826eaa4b4 · first seen 2026-11-03
3 sourceson premise · restaurantalcohol: 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
El Ranchito Mexican Rest 1 other
a licence name in capitals, cleaned (derived; record_title.py)
EL RANCHITO MEXICAN RESTAURANT mo-atcoverture ×2
Street
501 E MAIN STREET 2 other
mo-atc
501 E Main St overture
501 MAIN ST ab-inbev
City
UNION
mo-atcno other value
State
MO
mo-atcno other value
ZIP
63084
mo-atcno other value
Pin
38.44554, -91.00468 map
overtureno other value
Phone
6365838990 1 other
overture
6363902063 mo-atc
Licences
mo-atc MO|120249
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocdb97be4199b; O786cd8e66eb7

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-inbevEL RANCHITO MEXICAN REST
3089634
501 MAIN ST, UNION, MO, 6308438.44555, -91.004592026-11-122026-11-12
mo-atcEL RANCHITO MEXICAN RESTAURANT
MO|120249
501 E MAIN STREET, UNION, MO, 63084636390206338.44552, -91.004652026-11-032026-11-12
overtureEl Ranchito Mexican Restaurant
2c6c85cf-cc17-4377-8851-d472763d3df2
501 E Main St, Union, MO, 63084636583899038.44554, -91.004682026-11-062026-11-12

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
mo-atc EL RANCHITO MEXICAN RESTAURANToverture El Ranchito Mexican Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 · phone: differs
ab-inbev EL RANCHITO MEXICAN RESTmo-atc EL RANCHITO MEXICAN RESTAURANT0.74street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 6 m apart · name similarity 0.74 · street similarity 0.88
ab-inbev EL RANCHITO MEXICAN RESToverture El Ranchito Mexican Restaurant0.74street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 8 m apart · name similarity 0.74 · street similarity 0.88

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — MO Retail by Drink
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
45 within 1 mi · 77 within 3 mi
Off / on premise
16 / 15 within 1 mi · 28 / 25 within 3 mi
Selling alcohol
33 within 1 mi · 55 within 3 mi
Nearest
same channel 0.12 mi · licensed 0.11 mi
Setting
rural (445 people per sq mi)
People within 3 mi
12,573 (9,127 adults 21+, 4,734 households) from 3 tract(s), tracts within 3 mi
Income
per capita $32,125 · median household ~$72,590 (weighted mean of tract medians)
Age and education
median age ~37.0 · bachelor's or higher 20%
Ethnicity
Hispanic 2% · White 92% · Black 1% · Asian 1%
Adults per alcohol outlet
163
Alcohol spend within 3 mi
$2,798,856 a year ($1,317,654 at home, $1,479,984 away) · $49,980 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:25insertab-inbev 3089634 ↔ overture 2c6c85cf-cc17-4377-8851-d472763d3df2street written two waysmerged12
2026-11-12 14:25insertab-inbev 3089634 ↔ mo-atc MO|120249street written two waysmerged12
2026-11-06 18:13insertmo-atc MO|120249 ↔ overture 2c6c85cf-cc17-4377-8851-d472763d3df2same address and namemerged11