Outlets /
Joe's Market
Ypsilanti, MI 48197 · O0b24d4f37337 · first seen 2026-11-03
3 sourcesoff premise · conveniencealcohol: licensed2 licences
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 | Joe's Market 1 other | a source's own spelling of the licence name (record_title.py) | Ypsilanti Business Ventures, LLC snapmi-lcc (legal name) ×3 |
| Street | 454 S Huron St | mi-lcc | no other value |
| City | Ypsilanti | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48197 | mi-lcc | no other value |
| Pin | 42.23382, -83.61432 map 1 other | overture | 104 m away mi-lcc ×2 |
| Phone | 7349618444 1 other | overture | 5869430591 mi-lcc ×2 |
| Licences | mi-lcc L-000463984 · mi-lcc L-000463985 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O77f433230156; O1fb3feaee53f; O1f589c985371
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 |
|---|---|---|---|---|---|---|
| mi-lcc | JOE'S MARKET legal name: YPSILANTI BUSINESS VENTURES LLC L-000463984 | 454 S Huron St, Ypsilanti, MI, 48197 | 5869430591 | 42.23465, -83.61375 | 2026-11-03 | 2026-11-06 |
| mi-lcc | JOE'S MARKET legal name: YPSILANTI BUSINESS VENTURES LLC L-000463985 | 454 S Huron St, Ypsilanti, MI, 48197 | 5869430591 | 42.23465, -83.61375 | 2026-11-03 | 2026-11-06 |
| overture | Joe's Market df437f81-7f72-4861-a6c9-21ff05934415 | 454 S Huron St, Ypsilanti, MI, 48197 | 7349618444 | 42.23382, -83.61432 | 2026-11-06 | 2026-11-06 |
| snap | Ypsilanti Business Ventures, LLC snap|us|1564207 | 454 S Huron St, Ypsilanti, MI, 48197 | 42.23387, -83.61420 | 2026-11-19 | 2026-11-19 |
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 |
|---|---|---|---|---|---|
| mi-lcc JOE'S MARKET | mi-lcc JOE'S MARKET | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc JOE'S MARKET | overture Joe's Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00 · phone: differs |
| mi-lcc JOE'S MARKET | snap Ypsilanti Business Ventures, LLC | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · matched through the licence's legal name: YPSILANTI BUSINESS VENTURES LLC · name similarity 1.00 |
| mi-lcc JOE'S MARKET | overture Joe's Market | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00 · phone: differs |
| mi-lcc JOE'S MARKET | snap Ypsilanti Business Ventures, LLC | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · matched through the licence's legal name: YPSILANTI BUSINESS VENTURES LLC · name similarity 1.00 |
Attributes
- Channel
- off_premise · convenience — overture-category
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- YPSILANTI BUSINESS VENTURES LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"off_premise",
"convenience"
]
]
}Trade area
- Other outlets
- 96 within 1 mi · 307 within 3 mi
- Off / on premise
- 17 / 59 within 1 mi · 79 / 173 within 3 mi
- Selling alcohol
- 51 within 1 mi · 140 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.45 mi
- Setting
- suburban (2,387 people per sq mi)
- People within 3 mi
- 67,499 (49,841 adults 21+, 30,027 households) from 23 tract(s), tracts within 3 mi
- Income
- per capita $35,529 · median household ~$65,924 (weighted mean of tract medians)
- Age and education
- median age ~34.3 · bachelor's or higher 42%
- Ethnicity
- Hispanic 8% · White 52% · Black 30% · Asian 5%
- Adults per alcohol outlet
- 353
- Alcohol spend within 3 mi
- $16,380,254 a year ($7,794,225 at home, $8,578,397 away) · $116,172 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-19 20:37 | insert | mi-lcc L-000463984 ↔ snap snap|us|1564207 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | mi-lcc L-000463985 ↔ snap snap|us|1564207 | same address and name | merged | 17 |
| 2026-11-06 18:13 | insert | mi-lcc L-000463984 ↔ overture df437f81-7f72-4861-a6c9-21ff05934415 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000463985 ↔ overture df437f81-7f72-4861-a6c9-21ff05934415 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000463984 ↔ mi-lcc L-000463985 | one store listed twice | merged |