College Liquor Shoppe

Detroit, MI 48238 · O3c8b4173de42 · first seen 2026-10-14
6 sourcesoff premise · liquor_storechain: College Liquor Shoppealcohol: 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
College Liquor Shoppe 2 other
a source's own spelling of the licence name (record_title.py)
COLLEGE LIQUOR ab-inbevvtinfo ×2
SANDS MARKET, INC. mi-lcc (legal name) ×2
Street
15956 Livernois Ave 2 other
mi-lcc
15956 LIVERNOIS ab-inbevoverturevtinfo ×3
15956 Livernois Avenue ubereats
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48238
mi-lccno other value
Pin
42.40968, -83.14014 map 1 other
ubereats
102 m away mi-lcc ×2
Phone
3138612073
vtinfono other value
Licences
mi-lcc L-000000001 · mi-lcc L-000016657
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa30fdb8379aa; Odf02dd1f320a; O85a3da078aa9; O85a096098907; O5a95e8ff5d10; O45f9cc24eb33

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-inbevCOLLEGE LIQUOR
2548877
15956 LIVERNOIS, DETROIT, MI, 4823842.40975, -83.140372026-11-112026-11-19
mi-lccCOLLEGE LIQUOR SHOPPE
legal name: SANDS MARKET, INC.
L-000000001
15956 Livernois Ave, Detroit, MI, 48238313861207342.40879, -83.140422026-11-032026-11-19
mi-lccCOLLEGE LIQUOR SHOPPE
legal name: SANDS MARKET, INC.
L-000016657
15956 Livernois Ave, Detroit, MI, 48238313861207342.40879, -83.140422026-11-032026-11-19
overtureCollege Liquor Shoppe
aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1
15956 Livernois, Detroit, MI, 48238313861207342.40971, -83.140212026-11-132026-11-19
snapCOLLEGE LIQUOR SHOPPE
snap|us|659914
15956 Livernois Ave, Detroit, MI, 4823842.40976, -83.140012026-11-192026-11-19
ubereatsCollege Liquor Shoppe
Q4g0JyJuVV6StJ26E0RepQ
15956 Livernois Avenue, Detroit, MI, 4823842.40968, -83.140142026-10-142026-11-19
vtinfoCOLLEGE LIQUOR
55c3b6d2a9682094
15956 LIVERNOIS, DETROIT, MI, 48238313861207342.40976, -83.140012026-11-122026-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
ab-inbev COLLEGE LIQUORvtinfo COLLEGE LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
mi-lcc COLLEGE LIQUOR SHOPPEmi-lcc COLLEGE LIQUOR SHOPPE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc COLLEGE LIQUOR SHOPPEoverture College Liquor Shoppe1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 104 m apart · name similarity 1.00 · street similarity 0.82
mi-lcc COLLEGE LIQUOR SHOPPEsnap COLLEGE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 113 m apart · name similarity 1.00
mi-lcc COLLEGE LIQUOR SHOPPEubereats College Liquor Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc COLLEGE LIQUOR SHOPPEoverture College Liquor Shoppe1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 104 m apart · name similarity 1.00 · street similarity 0.82
mi-lcc COLLEGE LIQUOR SHOPPEsnap COLLEGE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 113 m apart · name similarity 1.00
mi-lcc COLLEGE LIQUOR SHOPPEubereats College Liquor Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture College Liquor Shoppesnap COLLEGE LIQUOR SHOPPE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 18 m apart · name similarity 1.00 · street similarity 0.82
overture College Liquor Shoppeubereats College Liquor Shoppe1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 7 m apart · name similarity 1.00 · street similarity 0.82
snap COLLEGE LIQUOR SHOPPEubereats College Liquor Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ab-inbev COLLEGE LIQUORmi-lcc COLLEGE LIQUOR SHOPPE0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 107 m apart · name similarity 0.73 · street similarity 0.82
ab-inbev COLLEGE LIQUORmi-lcc COLLEGE LIQUOR SHOPPE0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 107 m apart · name similarity 0.73 · street similarity 0.82
ab-inbev COLLEGE LIQUORsnap COLLEGE LIQUOR SHOPPE0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 30 m apart · name similarity 0.73 · street similarity 0.82
ab-inbev COLLEGE LIQUORubereats College Liquor Shoppe0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 20 m apart · name similarity 0.73 · street similarity 0.82
mi-lcc COLLEGE LIQUOR SHOPPEvtinfo COLLEGE LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on city · pins 113 m apart · name similarity 0.73 · street similarity 0.82
mi-lcc COLLEGE LIQUOR SHOPPEvtinfo COLLEGE LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on city · pins 113 m apart · name similarity 0.73 · street similarity 0.82
snap COLLEGE LIQUOR SHOPPEvtinfo COLLEGE LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 0 m apart · name similarity 0.73 · street similarity 0.82
ubereats College Liquor Shoppevtinfo COLLEGE LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on city · pins 14 m apart · name similarity 0.73 · street similarity 0.82
ab-inbev COLLEGE LIQUORoverture College Liquor Shoppe0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 14 m apart · name similarity 0.73
overture College Liquor Shoppevtinfo COLLEGE LIQUOR0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 17 m apart · name similarity 0.73 · phone: equal

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
College Liquor Shoppe — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
SANDS MARKET, INC. — 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-20 23:33.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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:37insertsnap snap|us|659914 ↔ vtinfo 55c3b6d2a9682094street written two waysmerged17
2026-11-19 20:37insertab-inbev 2548877 ↔ snap snap|us|659914street written two waysmerged17
2026-11-19 20:37insertoverture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1 ↔ snap snap|us|659914street written two waysmerged17
2026-11-19 20:37insertsnap snap|us|659914 ↔ ubereats Q4g0JyJuVV6StJ26E0RepQsame address and namemerged17
2026-11-19 20:37insertmi-lcc L-000000001 ↔ snap snap|us|659914same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000016657 ↔ snap snap|us|659914same address and namemerged17
2026-11-13 14:10insertoverture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1 ↔ vtinfo 55c3b6d2a9682094same address and namemerged15
2026-11-13 14:10insertab-inbev 2548877 ↔ overture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1same address and namemerged15
2026-11-13 14:10insertoverture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1 ↔ ubereats Q4g0JyJuVV6StJ26E0RepQstreet written two waysmerged15
2026-11-13 14:10insertmi-lcc L-000000001 ↔ overture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1street written two waysmerged15
2026-11-13 14:10insertmi-lcc L-000016657 ↔ overture aa13c6ab-e5e9-432d-8a4a-a2da720ad8e1street written two waysmerged15
2026-11-12 14:25insertubereats Q4g0JyJuVV6StJ26E0RepQ ↔ vtinfo 55c3b6d2a9682094street written two waysmerged12
2026-11-12 14:25insertmi-lcc L-000000001 ↔ vtinfo 55c3b6d2a9682094street written two waysmerged12
2026-11-12 14:25insertmi-lcc L-000016657 ↔ vtinfo 55c3b6d2a9682094street written two waysmerged12
2026-11-12 14:25insertab-inbev 2548877 ↔ vtinfo 55c3b6d2a9682094same address and namemerged12
2026-11-11 12:56insertab-inbev 2548877 ↔ ubereats Q4g0JyJuVV6StJ26E0RepQstreet written two waysmerged12
2026-11-11 12:56insertab-inbev 2548877 ↔ mi-lcc L-000000001street written two waysmerged12
2026-11-11 12:56insertab-inbev 2548877 ↔ mi-lcc L-000016657street written two waysmerged12
2026-11-03 13:33backfillmi-lcc L-000016657 ↔ ubereats Q4g0JyJuVV6StJ26E0RepQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000000001 ↔ ubereats Q4g0JyJuVV6StJ26E0RepQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000000001 ↔ mi-lcc L-000016657one store listed twicemerged