El Ranchero Mexican Restaurant

BLUE SPRINGS, MO 64014 · O9c9c41e6c865 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: alcohol

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 Ranchero Mexican Restaurant 2 other
a licence name in capitals, cleaned (derived; record_title.py)
El Ranchero overture
el ranchero mexican restaurant blue springs doordash
Street
1867 SW State Route 7 2 other
doordash
1867 S MO HWY 7 ab-inbevvtinfo ×2
1867 SW State Rte 7 overture
City
Blue Springs
doordashno other value
State
MO
doordashno other value
ZIP
64015 1 other
doordash
64014 ab-inbevoverturevtinfo ×3
Pin
38.99743, -94.27396 map 2 other
doordash
2.4 km away ab-inbev
2.4 km away vtinfo
Phone
8162284697
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob2e89826af10; Of220521317f1; Oa988884fd586

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 RANCHERO MEXICAN RESTAURANT
4033402
1867 S MO HWY 7, BLUE SPRINGS, MO, 6401439.01640, -94.259802026-11-112026-11-14
doordashel ranchero mexican restaurant blue springs
39840029
1867 SW State Route 7, Blue Springs, MO, 6401538.99743, -94.273962026-10-082026-11-14
overtureEl Ranchero
30ec5786-b88c-4580-b8c1-a4319d9deeb3
1867 SW State Rte 7, Blue Springs, MO, 64014816228469738.99710, -94.273832026-11-132026-11-14
vtinfoEL RANCHERO MEXICAN RESTAURANT
5c5e960f3d200215
1867 S MO HWY 7, BLUE SPRINGS, MO, 64014816228469739.01640, -94.259802026-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 EL RANCHERO MEXICAN RESTAURANTdoordash el ranchero mexican restaurant blue springs1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same restaurant, same number on Highway 7
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records name the same restaurant, El Ranchero Mexican Restaurant in Blue Springs, MO, at 1867 on Missouri Route 7 (S MO Hwy 7 and SW State Route 7 are the same road), with only one business at that address; the ZIP difference (64014 vs 64015) and 2.4 km coordinate gap look like geocoding variation.
pair 4546c79c3d58d1dfab45
ab-inbev EL RANCHERO MEXICAN RESTAURANTvtinfo EL RANCHERO MEXICAN RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
doordash el ranchero mexican restaurant blue springsoverture El Ranchero0.52same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.79 · same street + city + state · pins 38 m apart · name similarity 0.52

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Michelob Ultra (AB InBev), Proximo Spirits (Jose Cuervo) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
85 within 1 mi · 266 within 3 mi
Off / on premise
23 / 43 within 1 mi · 77 / 126 within 3 mi
Selling alcohol
41 within 1 mi · 136 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.05 mi
Setting
suburban (1,495 people per sq mi)
People within 3 mi
42,282 (29,735 adults 21+, 16,441 households) from 12 tract(s), tracts within 3 mi
Income
per capita $40,752 · median household ~$84,458 (weighted mean of tract medians)
Age and education
median age ~37.8 · bachelor's or higher 33%
Ethnicity
Hispanic 5% · White 78% · Black 10% · Asian 1%
Adults per alcohol outlet
217
Alcohol spend within 3 mi
$10,878,114 a year ($5,018,064 at home, $5,855,811 away) · $79,402 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-14 20:23insertab-inbev 4033402 ↔ vtinfo 5c5e960f3d200215same address and namemerged15
2026-11-13 14:10insertdoordash 39840029 ↔ overture 30ec5786-b88c-4580-b8c1-a4319d9deeb3same address and namemerged15
2026-11-12 17:29insertab-inbev 4033402 ↔ doordash 39840029Claude judge: samemerged14