El Rancho Mexican Restaurant

Detroit, MI 48209 · O2381220b8b9d · first seen 2026-11-03
5 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 Rancho Mexican Restaurant 1 other
a source's own spelling of the licence name (record_title.py)
EL RANCHO MEXICAN RESTAURANT L.L.C. mi-lcc (legal name)
Street
5900 W Vernor Hwy 2 other
mi-lcc
5900 W VERNOR ab-inbevvtinfo ×2
5900 W Vernor St inspections
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48209
mi-lccno other value
Pin
42.31642, -83.10567 map 1 other
overture
78 m away mi-lcc
Phone
3138432151
vtinfono other value
Licences
mi-lcc L-000071026
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe3811a45a34a; O459113f46417; O5515ecd9d198; Oc758ec802e7f

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 RANCHO MEXICAN RESTAURANT
137295
5900 W VERNOR, DETROIT, MI, 4820942.31640, -83.105452026-11-132026-11-13
inspectionsEl Rancho Mexican Restaurant
inspections|detroit|1147
5900 W Vernor St, Detroit, MI, 4820942.31650, -83.105632026-11-202026-11-20
mi-lccEL RANCHO MEXICAN RESTAURANT
legal name: EL RANCHO MEXICAN RESTAURANT L.L.C.
L-000071026
5900 W Vernor Hwy, Detroit, MI, 48209313843215142.31668, -83.104782026-11-032026-11-12
overtureEl Rancho Mexican Restaurant
fca08937-457d-4434-b248-73d4fb40227e
5900 W Vernor Hwy, Detroit, MI, 48209313843215142.31642, -83.105672026-11-062026-11-12
vtinfoEL RANCHO MEXICAN RESTAURANT
b24fe129cc0baeb0
5900 W VERNOR, DETROIT, MI, 48209313843215142.31643, -83.105622026-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 EL RANCHO MEXICAN RESTAURANTinspections El Rancho Mexican Restaurant1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 18 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev EL RANCHO MEXICAN RESTAURANTmi-lcc EL RANCHO MEXICAN RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 63 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev EL RANCHO MEXICAN RESTAURANToverture El Rancho Mexican Restaurant1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 18 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev EL RANCHO MEXICAN RESTAURANTvtinfo EL RANCHO MEXICAN RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00
inspections El Rancho Mexican Restaurantmi-lcc EL RANCHO MEXICAN RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 72 m apart · name similarity 1.00 · street similarity 0.78
inspections El Rancho Mexican Restaurantoverture El Rancho Mexican Restaurant1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 9 m apart · name similarity 1.00 · street similarity 0.78
inspections El Rancho Mexican Restaurantvtinfo EL RANCHO MEXICAN RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 8 m apart · name similarity 1.00 · street similarity 0.84
mi-lcc EL RANCHO MEXICAN RESTAURANToverture El Rancho Mexican Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 78 m apart · name similarity 1.00 · phone: equal
mi-lcc EL RANCHO MEXICAN RESTAURANTvtinfo EL RANCHO MEXICAN RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 75 m apart · name similarity 1.00 · street similarity 0.80
overture El Rancho Mexican Restaurantvtinfo EL RANCHO MEXICAN RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 4 m apart · name similarity 1.00 · street similarity 0.80

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
EL RANCHO MEXICAN RESTAURANT L.L.C. — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
95 within 1 mi · 497 within 3 mi
Off / on premise
19 / 51 within 1 mi · 92 / 246 within 3 mi
Selling alcohol
52 within 1 mi · 312 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.10 mi
Setting
suburban (2,977 people per sq mi)
People within 3 mi
84,175 (56,371 adults 21+, 32,810 households) from 40 tract(s), tracts within 3 mi
Income
per capita $23,852 · median household ~$39,912 (weighted mean of tract medians)
Age and education
median age ~32.7 · bachelor's or higher 18%
Ethnicity
Hispanic 46% · White 28% · Black 24% · Asian 1%
Adults per alcohol outlet
180
Alcohol spend within 3 mi
$14,204,271 a year ($7,019,617 at home, $7,176,177 away) · $45,381 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-20 22:08insertinspections inspections|detroit|1147 ↔ vtinfo b24fe129cc0baeb0street written two waysmerged17
2026-11-20 22:08insertab-inbev 137295 ↔ inspections inspections|detroit|1147street written two waysmerged17
2026-11-20 22:08insertinspections inspections|detroit|1147 ↔ mi-lcc L-000071026street written two waysmerged17
2026-11-20 22:08insertinspections inspections|detroit|1147 ↔ overture fca08937-457d-4434-b248-73d4fb40227estreet written two waysmerged17
2026-11-13 14:10insertab-inbev 137295 ↔ mi-lcc L-000071026street written two waysmerged15
2026-11-13 14:10insertab-inbev 137295 ↔ overture fca08937-457d-4434-b248-73d4fb40227estreet written two waysmerged15
2026-11-13 14:10insertab-inbev 137295 ↔ vtinfo b24fe129cc0baeb0same address and namemerged15
2026-11-12 14:25insertmi-lcc L-000071026 ↔ vtinfo b24fe129cc0baeb0street written two waysmerged12
2026-11-12 14:25insertoverture fca08937-457d-4434-b248-73d4fb40227e ↔ vtinfo b24fe129cc0baeb0street written two waysmerged12
2026-11-06 18:13insertmi-lcc L-000071026 ↔ overture fca08937-457d-4434-b248-73d4fb40227esame address and namemerged11