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.

FieldMaster valueTaken fromWhat 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-lccno other value
City
Ypsilanti
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48197
mi-lccno 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
mi-lccJOE'S MARKET
legal name: YPSILANTI BUSINESS VENTURES LLC
L-000463984
454 S Huron St, Ypsilanti, MI, 48197586943059142.23465, -83.613752026-11-032026-11-06
mi-lccJOE'S MARKET
legal name: YPSILANTI BUSINESS VENTURES LLC
L-000463985
454 S Huron St, Ypsilanti, MI, 48197586943059142.23465, -83.613752026-11-032026-11-06
overtureJoe's Market
df437f81-7f72-4861-a6c9-21ff05934415
454 S Huron St, Ypsilanti, MI, 48197734961844442.23382, -83.614322026-11-062026-11-06
snapYpsilanti Business Ventures, LLC
snap|us|1564207
454 S Huron St, Ypsilanti, MI, 4819742.23387, -83.614202026-11-192026-11-19

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
mi-lcc JOE'S MARKETmi-lcc JOE'S MARKET1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc JOE'S MARKEToverture Joe's Market1.00same address and namemergedaddress 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 MARKETsnap Ypsilanti Business Ventures, LLC1.00same address and namemergedaddress 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 MARKEToverture Joe's Market1.00same address and namemergedaddress 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 MARKETsnap Ypsilanti Business Ventures, LLC1.00same address and namemergedaddress 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”).
WhenEventPairRuleDecisionRule version
2026-11-19 20:37insertmi-lcc L-000463984 ↔ snap snap|us|1564207same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000463985 ↔ snap snap|us|1564207same address and namemerged17
2026-11-06 18:13insertmi-lcc L-000463984 ↔ overture df437f81-7f72-4861-a6c9-21ff05934415same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000463985 ↔ overture df437f81-7f72-4861-a6c9-21ff05934415same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000463984 ↔ mi-lcc L-000463985one store listed twicemerged