CJ's Upper Deck

Waterford, MI 48328 · O0211b3f3e90f · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
CJ's Upper Deck 3 other
the most common name a source states
ALEKLODI LLC mi-lcc (legal name) ×2
CJS UPPER DECK ab-inbevvtinfo ×2
cj's upper deck waterford township doordash
Street
3270 W Huron St 1 other
mi-lcc
3270 West Huron Street doordash
City
Waterford 1 other
mi-lcc
Waterford Township doordash
State
MI
mi-lccno other value
ZIP
48328
mi-lccno other value
Pin
42.63897, -83.35095 map 1 other
doordash
74 m away mi-lcc ×2
Phone
2486826200 1 other
vtinfo
5862151985 mi-lcc ×2
Licences
mi-lcc L-000461128 · mi-lcc L-000461129
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7e9228c09b06; O5bff3fe9148f; O4ec531be69a7; Ofeac268a8aa9; Oa0988860c89f

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-inbevCJS UPPER DECK
3198183
3270 W HURON ST, WATERFORD, MI, 4832842.63885, -83.351262026-11-112026-11-11
doordashcj's upper deck waterford township
24870998
3270 West Huron Street, Waterford Township, MI, 48328
ZIP lookup: Waterford, MI
42.63897, -83.350952026-10-082026-11-12
mi-lccCJ's Upper Deck
legal name: ALEKLODI LLC
L-000461128
3270 W Huron St, Waterford, MI, 48328586215198542.63921, -83.351802026-11-032026-11-11
mi-lccCJ's Upper Deck
legal name: ALEKLODI LLC
L-000461129
3270 W Huron St, Waterford, MI, 48328586215198542.63921, -83.351802026-11-032026-11-11
overtureCJ's Upper Deck
e6eb35fc-db98-457a-ba55-b63d86b975a2
3270 W Huron St, Waterford, MI, 48328248682620042.63904, -83.351042026-11-062026-11-11
vtinfoCJS UPPER DECK
9e6276cff6111d2a
3270 W HURON ST, WATERFORD, MI, 48328248682620042.63899, -83.350952026-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 CJS UPPER DECKmi-lcc CJ's Upper Deck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev CJS UPPER DECKmi-lcc CJ's Upper Deck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev CJS UPPER DECKoverture CJ's Upper Deck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ab-inbev CJS UPPER DECKvtinfo CJS UPPER DECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
mi-lcc CJ's Upper Deckmi-lcc CJ's Upper Deck1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CJ's Upper Deckoverture CJ's Upper Deck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00 · phone: differs
mi-lcc CJ's Upper Deckvtinfo CJS UPPER DECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 73 m apart · name similarity 1.00 · phone: differs
mi-lcc CJ's Upper Deckoverture CJ's Upper Deck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00 · phone: differs
mi-lcc CJ's Upper Deckvtinfo CJS UPPER DECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 73 m apart · name similarity 1.00 · phone: differs
overture CJ's Upper Deckvtinfo CJS UPPER DECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal
doordash cj's upper deck waterford townshipmi-lcc CJ's Upper Deck0.75Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
CJ's Upper Deck same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name CJ's Upper Deck at 3270 W Huron Street, Waterford, MI 48328, with coordinates about 74 m apart, and the address is the only business at that address in the data, so the DoorDash listing is the same bar as the Michigan liquor licence (filed under the legal entity ALEKLODI LLC).
pair 11dd011336b451c75da6

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ALEKLODI LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
48 within 1 mi · 300 within 3 mi
Off / on premise
15 / 24 within 1 mi · 81 / 147 within 3 mi
Selling alcohol
24 within 1 mi · 172 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.11 mi
Setting
suburban (2,186 people per sq mi)
People within 3 mi
61,796 (48,254 adults 21+, 26,809 households) from 20 tract(s), tracts within 3 mi
Income
per capita $40,584 · median household ~$68,557 (weighted mean of tract medians)
Age and education
median age ~41.0 · bachelor's or higher 27%
Ethnicity
Hispanic 12% · White 61% · Black 19% · Asian 3%
Adults per alcohol outlet
279
Alcohol spend within 3 mi
$16,103,540 a year ($7,515,256 at home, $8,581,607 away) · $93,084 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 17:29insertdoordash 24870998 ↔ mi-lcc L-000461129Claude judge: samemerged14
2026-11-12 14:25insertoverture e6eb35fc-db98-457a-ba55-b63d86b975a2 ↔ vtinfo 9e6276cff6111d2asame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000461128 ↔ vtinfo 9e6276cff6111d2asame address and namemerged12
2026-11-12 14:25insertab-inbev 3198183 ↔ vtinfo 9e6276cff6111d2asame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000461129 ↔ vtinfo 9e6276cff6111d2asame address and namemerged12
2026-11-11 12:56insertab-inbev 3198183 ↔ overture e6eb35fc-db98-457a-ba55-b63d86b975a2same address and namemerged12
2026-11-11 12:56insertab-inbev 3198183 ↔ mi-lcc L-000461129same address and namemerged12
2026-11-11 12:56insertab-inbev 3198183 ↔ mi-lcc L-000461128same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000461129 ↔ overture e6eb35fc-db98-457a-ba55-b63d86b975a2same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000461128 ↔ overture e6eb35fc-db98-457a-ba55-b63d86b975a2same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000461128 ↔ mi-lcc L-000461129one store listed twicemerged