Outlets /
Mcshanes
Ypsilanti, MI 48197 · O385a372a1391 · first seen 2026-10-08
5 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Mcshanes 3 other | a licence name in capitals, cleaned (derived; record_title.py) | McShane's Irish Pub overture mcshane's irish pub ypsilanti doordash MCSHANES IRISH PUB inspections |
| Street | 2203 Ellsworth Road 1 other | doordash | 2203 ELLSWORTH RD ab-inbevinspectionsoverturevtinfo ×4 |
| City | Ypsilanti | doordash | no other value |
| State | MI | doordash | no other value |
| ZIP | 48197 | doordash | no other value |
| Pin | 42.22933, -83.64444 map 3 other | doordash | 156 m away ab-inbev 147 m away inspections 124 m away vtinfo |
| Phone | 7344340494 | vtinfo | no other value |
| Licences | none on file | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O8fdc58f6163c; O9ed6161406e9; O775b59cbd073; O60ec3eb7cc61
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | MCSHANES 4028655 | 2203 ELLSWORTH RD, YPSILANTI, MI, 48197 | 42.23050, -83.64549 | 2026-11-11 | 2026-11-16 | |
| doordash | mcshane's irish pub ypsilanti 24365738 | 2203 Ellsworth Road, Ypsilanti, MI, 48197 | 42.22933, -83.64444 | 2026-10-08 | 2026-11-10 | |
| inspections | MCSHANES IRISH PUB inspections|mi|SFE-4781-203125 | 2203 ELLSWORTH RD, Ypsilanti, MI, 48197 | 42.23048, -83.64532 | 2026-11-20 | 2026-11-20 | |
| overture | McShane's Irish Pub 7c490d6b-7c76-4d61-90d6-241020619e98 | 2203 Ellsworth Rd, Ypsilanti, MI, 48197 | 7344340494 | 42.22929, -83.64445 | 2026-11-09 | 2026-11-09 |
| vtinfo | MCSHANES 5805984eb908f637 | 2203 ELLSWORTH RD, YPSILANTI, MI, 48197 | 7344340494 | 42.23044, -83.64445 | 2026-11-13 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev MCSHANES | vtinfo MCSHANES | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 86 m apart · name similarity 1.00 |
| doordash mcshane's irish pub ypsilanti | inspections MCSHANES IRISH PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 147 m apart · name similarity 1.00 |
| doordash mcshane's irish pub ypsilanti | overture McShane's Irish Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 |
| inspections MCSHANES IRISH PUB | overture McShane's Irish Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 150 m apart · name similarity 1.00 |
| ab-inbev MCSHANES | doordash mcshane's irish pub ypsilanti | 0.47 | one name contains the other, same address | merged | judge: None · pair_id: 91f373fdb65d3b3eeefd · person: None · rule: names contained at one address · stratum: near |
| doordash mcshane's irish pub ypsilanti | vtinfo MCSHANES | 0.47 | one name contains the other, same address | merged | judge: None · pair_id: 3035c39d5ce488fc8403 · person: None · rule: names contained at one address · stratum: near |
Attributes
- Channel
- on_premise · restaurant — doordash-url
- Chain
- none
- Alcohol
- alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +11 more by the supplier's own store finder or locator
- Operator
- none
- Licence privileges
- none
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
"votes": [
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"bar"
]
]
}Trade area
- Other outlets
- 29 within 1 mi · 390 within 3 mi
- Off / on premise
- 8 / 17 within 1 mi · 98 / 230 within 3 mi
- Selling alcohol
- 10 within 1 mi · 169 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.08 mi
- Setting
- suburban (2,221 people per sq mi)
- People within 3 mi
- 62,784 (46,830 adults 21+, 28,438 households) from 23 tract(s), tracts within 3 mi
- Income
- per capita $37,958 · median household ~$66,982 (weighted mean of tract medians)
- Age and education
- median age ~34.0 · bachelor's or higher 51%
- Ethnicity
- Hispanic 8% · White 55% · Black 24% · Asian 9%
- Adults per alcohol outlet
- 275
- Alcohol spend within 3 mi
- $16,111,250 a year ($7,597,363 at home, $8,506,627 away) · $94,772 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | inspections inspections|mi|SFE-4781-203125 ↔ overture 7c490d6b-7c76-4d61-90d6-241020619e98 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | doordash 24365738 ↔ inspections inspections|mi|SFE-4781-203125 | same address and name | merged | 17 |
| 2026-11-16 14:56 | insert | doordash 24365738 ↔ vtinfo 5805984eb908f637 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 4028655 ↔ doordash 24365738 | one name contains the other, same address | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 4028655 ↔ vtinfo 5805984eb908f637 | same address and name | merged | 15 |
| 2026-11-09 15:32 | insert | doordash 24365738 ↔ overture 7c490d6b-7c76-4d61-90d6-241020619e98 | same address and name | merged | 11 |