CC's Liquor

Troy, MI 48085 · O05c6d22024f7 · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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
CC's Liquor 4 other
a source's own spelling of the licence name (record_title.py)
CCS LIQUOR ab-inbevvtinfo ×2
CCS MARKET, LLC mi-lcc (legal name) ×2
ccs liquor troy doordash
CC’s Liquor ubereats
Street
75 E Square Lake Rd
mi-lccno other value
City
Troy
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48085
mi-lccno other value
Pin
42.60677, -83.14829 map 1 other
ubereats
57 m away ab-inbev
Phone
6194572538
vtinfono other value
Licences
mi-lcc L-000499960 · mi-lcc L-000499961
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8f6d0536d37c; O7d04b1d05e4a; O32532d1f7fde; Oe203e82f8941; O3bf15e9a00f4

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-inbevCCS LIQUOR
4969955
75 E SQUARE LAKE RD, TROY, MI, 4808542.60653, -83.148902026-11-112026-11-11
doordashccs liquor troy
47395493
75 E Square Lake Rd, Troy, MI, 4808542.60678, -83.147952026-10-082026-11-03
mi-lccCC'S LIQUOR
legal name: CCS MARKET, LLC
L-000499960
75 E Square Lake Rd, Troy, MI, 4808542.60653, -83.148462026-11-032026-11-05
mi-lccCC'S LIQUOR
legal name: CCS MARKET, LLC
L-000499961
75 E Square Lake Rd, Troy, MI, 4808542.60653, -83.148462026-11-032026-11-05
ubereatsCC’s Liquor
zIfA0NCgX0G_iypP8eU7Dg
75 E Square Lake Rd, Troy, MI, 4808542.60677, -83.148292026-10-202026-11-03
vtinfoCCS LIQUOR
72edbb962e2bb228
75 E SQUARE LAKE RD, TROY, MI, 48085619457253842.60678, -83.148392026-11-122026-11-14

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 CCS LIQUORdoordash ccs liquor troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00
ab-inbev CCS LIQUORmi-lcc CC'S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ab-inbev CCS LIQUORmi-lcc CC'S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ab-inbev CCS LIQUORubereats CC’s Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
ab-inbev CCS LIQUORvtinfo CCS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
doordash ccs liquor troymi-lcc CC'S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash ccs liquor troymi-lcc CC'S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash ccs liquor troyvtinfo CCS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00
mi-lcc CC'S LIQUORmi-lcc CC'S LIQUOR1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CC'S LIQUORubereats CC’s Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc CC'S LIQUORvtinfo CCS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
mi-lcc CC'S LIQUORubereats CC’s Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc CC'S LIQUORvtinfo CCS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
ubereats CC’s Liquorvtinfo CCS LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
doordash ccs liquor troyubereats CC’s Liquor0.55Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The DoorDash slug 'ccs liquor troy' is 'CC's Liquor' with the city appended, and both records give the same street address, 75 E Square Lake Rd, Troy, 48085, with coordinates 28 m apart; the names agr
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the identical street address, ZIP and city in Troy, MI, and the names 'ccs liquor troy' and 'CC's Liquor' match once the appended city slug is removed; the coordinates are 28 m apart, though two businesses share the address so the name match is the deciding evidence.
pair 878291f60941619f819f

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CCS MARKET, 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 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
16 within 1 mi · 255 within 3 mi
Off / on premise
3 / 8 within 1 mi · 58 / 148 within 3 mi
Selling alcohol
9 within 1 mi · 112 within 3 mi
Nearest
same channel 0.90 mi · licensed 0.09 mi
Setting
suburban (2,814 people per sq mi)
People within 3 mi
79,576 (59,708 adults 21+, 29,422 households) from 18 tract(s), tracts within 3 mi
Income
per capita $61,191 · median household ~$138,041 (weighted mean of tract medians)
Age and education
median age ~43.6 · bachelor's or higher 65%
Ethnicity
Hispanic 2% · White 64% · Black 3% · Asian 27%
Adults per alcohol outlet
528
Alcohol spend within 3 mi
$27,813,617 a year ($12,044,338 at home, $15,758,741 away) · $246,138 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-12 14:25insertmi-lcc L-000499960 ↔ vtinfo 72edbb962e2bb228same address and namemerged12
2026-11-12 14:25insertubereats zIfA0NCgX0G_iypP8eU7Dg ↔ vtinfo 72edbb962e2bb228same address and namemerged12
2026-11-12 14:25insertdoordash 47395493 ↔ vtinfo 72edbb962e2bb228same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000499961 ↔ vtinfo 72edbb962e2bb228same address and namemerged12
2026-11-12 14:25insertab-inbev 4969955 ↔ vtinfo 72edbb962e2bb228same address and namemerged12
2026-11-11 12:56insertab-inbev 4969955 ↔ mi-lcc L-000499960same address and namemerged12
2026-11-11 12:56insertab-inbev 4969955 ↔ ubereats zIfA0NCgX0G_iypP8eU7Dgsame address and namemerged12
2026-11-11 12:56insertab-inbev 4969955 ↔ doordash 47395493same address and namemerged12
2026-11-11 12:56insertab-inbev 4969955 ↔ mi-lcc L-000499961same address and namemerged12
2026-11-03 13:33backfilldoordash 47395493 ↔ mi-lcc L-000499961same address and namemerged
2026-11-03 13:33backfilldoordash 47395493 ↔ mi-lcc L-000499960same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000499961 ↔ ubereats zIfA0NCgX0G_iypP8eU7Dgsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000499960 ↔ ubereats zIfA0NCgX0G_iypP8eU7Dgsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000499960 ↔ mi-lcc L-000499961one store listed twicemerged
2026-11-02 23:02backfilldoordash 47395493 ↔ ubereats zIfA0NCgX0G_iypP8eU7DgClaude judge: samemerged