El Mariachi of Hamilton Mexican Restaurant & Cantina

Hamilton, OH 45013 · O33a3ae4480ed · 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 Mariachi of Hamilton Mexican Restaurant & Cantina 5 other
the most common name a source states
EL MARIACHI ab-inbev
el mariachi hamilton doordash
El Mariachi II ubereats
El Mariachi Mexican Restaurant & Cantina ubereats
El Mariachi of Hamilton overture
Street
787 NW Washington Blvd 1 other
ubereats
787 Northwest Washington Boulevard doordash
City
Hamilton
ubereatsno other value
State
OH
ubereatsno other value
ZIP
45013
ubereatsno other value
Pin
39.42628, -84.59325 map 1 other
ubereats
142 m away ab-inbev
Phone
5138926300
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O92ab90b663e7; Oec51959f2034; O987ff4cf22ea; O4bf9695c9733; O8bf3fe0877dd; O61d24ccdf1ae

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 MARIACHI
2646385
787 NW WASHINGTON BLVD, HAMILTON, OH, 4501339.42671, -84.594812026-11-132026-11-13
doordashel mariachi hamilton
172871
787 Northwest Washington Boulevard, Hamilton, OH, 4501339.42640, -84.593252026-10-082026-11-14
overtureEl Mariachi of Hamilton
1fc4f034-24f0-43e7-b048-74b094557b60
787 NW Washington Blvd, Hamilton, OH, 45013513892630039.42635, -84.593282026-11-132026-11-13
ubereatsEl Mariachi of Hamilton Mexican Restaurant & Cantina
feZW5J0OUDaFjHiCaZg-cw
787 NW Washington Blvd, Hamilton, OH, 4501339.42628, -84.593252026-11-162026-11-16
ubereatsEl Mariachi Mexican Restaurant & Cantina
HJuf1K6JX7GxbJqngprDNg
787 NW Washington Blvd, Hamilton, OH, 4501339.42627, -84.593252026-10-302026-11-13
ubereatsEl Mariachi of Hamilton Mexican Restaurant & Cantina
-k3HUq9aXBOvblvQBcejTQ
787 NW Washington Blvd, Hamilton, OH, 4501339.42643, -84.593272026-10-112026-11-13
ubereatsEl Mariachi II
L88nCN9VSEKrrXsVOcdSgg
787 NW Washington Blvd, Hamilton, OH, 4501339.42662, -84.593282026-10-252026-11-16

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 MARIACHIdoordash el mariachi hamilton1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 138 m apart · name similarity 1.00
doordash el mariachi hamiltonoverture El Mariachi of Hamilton1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
ubereats El Mariachi of Hamilton Mexican Restaurant & Cantinaubereats El Mariachi of Hamilton Mexican Restaurant & Cantina1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev EL MARIACHIubereats El Mariachi II0.77one name contains the other, same addressmergedjudge: None · pair_id: 72457e52e3901b132891 · person: None · rule: names contained at one address · stratum: near
doordash el mariachi hamiltonubereats El Mariachi II0.77one name contains the other, same addressmergedjudge: None · pair_id: 0bd7e661a602d378321d · person: None · rule: names contained at one address · stratum: near
doordash el mariachi hamiltonubereats El Mariachi of Hamilton Mexican Restaurant & Cantina0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.65 · same street + ZIP · pins 14 m apart · name similarity 0.55
doordash el mariachi hamiltonubereats El Mariachi of Hamilton Mexican Restaurant & Cantina0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.65 · same street + city + state · pins 4 m apart · name similarity 0.55
overture El Mariachi of Hamiltonubereats El Mariachi of Hamilton Mexican Restaurant & Cantina0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.65 · same street + ZIP · pins 8 m apart · name similarity 0.55
overture El Mariachi of Hamiltonubereats El Mariachi of Hamilton Mexican Restaurant & Cantina0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.65 · same street + ZIP · pins 9 m apart · name similarity 0.55
ab-inbev EL MARIACHIubereats El Mariachi Mexican Restaurant & Cantina0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.60 · same street + ZIP · pins 143 m apart · name similarity 0.42
doordash el mariachi hamiltonubereats El Mariachi Mexican Restaurant & Cantina0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cantina, mexican, restaurant · name Jaro-Winkler 0.65 · same street + city + state · pins 14 m apart · name similarity 0.42

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — Uber Eats menu sells alcohol: 'MARGARITAS & COCKTAILS'
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT",
  "PHYSICAL"
 ],
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
73 within 1 mi · 166 within 3 mi
Off / on premise
22 / 44 within 1 mi · 44 / 81 within 3 mi
Selling alcohol
31 within 1 mi · 99 within 3 mi
Nearest
same channel 0.08 mi · licensed 2.30 mi
Setting
suburban (1,227 people per sq mi)
People within 3 mi
34,698 (25,199 adults 21+, 13,867 households) from 8 tract(s), tracts within 3 mi
Income
per capita $30,929 · median household ~$61,688 (weighted mean of tract medians)
Age and education
median age ~37.3 · bachelor's or higher 18%
Ethnicity
Hispanic 6% · White 82% · Black 4% · Asian 1%
Adults per alcohol outlet
252
Alcohol spend within 3 mi
$7,368,254 a year ($3,551,670 at home, $3,813,881 away) · $73,683 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-16 14:56insertdoordash 172871 ↔ ubereats L88nCN9VSEKrrXsVOcdSggone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2646385 ↔ ubereats L88nCN9VSEKrrXsVOcdSggone name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 172871 ↔ ubereats feZW5J0OUDaFjHiCaZg-cwsame address and namemerged15
2026-11-16 14:56insertoverture 1fc4f034-24f0-43e7-b048-74b094557b60 ↔ ubereats feZW5J0OUDaFjHiCaZg-cwsame address and namemerged15
2026-11-16 14:56insertubereats -k3HUq9aXBOvblvQBcejTQ ↔ ubereats feZW5J0OUDaFjHiCaZg-cwone store listed twicemerged15
2026-11-13 17:47insertdoordash 172871 ↔ ubereats HJuf1K6JX7GxbJqngprDNgsame address and namemerged15
2026-11-13 17:47insertdoordash 172871 ↔ ubereats -k3HUq9aXBOvblvQBcejTQsame address and namemerged15
2026-11-13 17:47insertdoordash 172871 ↔ overture 1fc4f034-24f0-43e7-b048-74b094557b60same address and namemerged15
2026-11-13 17:47insertab-inbev 2646385 ↔ doordash 172871same address and namemerged15
2026-11-13 14:10insertab-inbev 2646385 ↔ ubereats HJuf1K6JX7GxbJqngprDNgsame address and namemerged15
2026-11-13 14:10insertoverture 1fc4f034-24f0-43e7-b048-74b094557b60 ↔ ubereats -k3HUq9aXBOvblvQBcejTQsame address and namemerged15