Scotch Castle Liquor

Detroit, MI 48234 · O3da6d5296ccd · first seen 2026-11-03
4 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
Scotch Castle Liquor 2 other
a licence name in capitals, cleaned (derived; record_title.py)
SCOTCH CASTLE PARTY STORE mi-lcc ×2
Scotch Castle Liquor Land overture
Street
2867 E 7 Mile Rd 1 other
mi-lcc
2867 7 Mile Rd E overture
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48234
mi-lccno other value
Pin
42.43341, -83.07426 map 1 other
overture
52 m away mi-lcc ×2
Phone
3133669551 1 other
vtinfo
3133687500 mi-lcc ×2
Licences
mi-lcc L-000013888 · mi-lcc L-000017911
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of7854370e25d; Of505d4562b8e; Oaac1b1083650; O5fd5aa6b47f7; O465ddd6cbc08

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-inbevSCOTCH CASTLE LIQUOR
2534832
2867 E 7 MILE RD, DETROIT, MI, 4823442.43300, -83.074382026-11-112026-11-18
mi-lccSCOTCH CASTLE PARTY STORE
L-000013888
2867 E 7 Mile Rd, Detroit, MI, 48234313368750042.43298, -83.074512026-11-032026-11-18
mi-lccSCOTCH CASTLE PARTY STORE
L-000017911
2867 E 7 Mile Rd, Detroit, MI, 48234313368750042.43298, -83.074512026-11-032026-11-18
overtureScotch Castle Liquor Land
745e2dfe-c7fc-46aa-9924-57b4861829b7
2867 7 Mile Rd E, Detroit, MI, 48234313366955142.43341, -83.074262026-11-182026-11-18
vtinfoSCOTCH CASTLE LIQUOR
fcb7097fd228bda0
2867 E 7 MILE RD, DETROIT, MI, 48234313366955142.43343, -83.074232026-11-122026-11-18

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 SCOTCH CASTLE LIQUORvtinfo SCOTCH CASTLE 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
mi-lcc SCOTCH CASTLE PARTY STOREmi-lcc SCOTCH CASTLE PARTY STORE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SCOTCH CASTLE PARTY STOREoverture a35b0d82-ac14-4359-81d7-4e649acf5f9b1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
mi-lcc SCOTCH CASTLE PARTY STOREoverture a35b0d82-ac14-4359-81d7-4e649acf5f9b1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev SCOTCH CASTLE LIQUORoverture Scotch Castle Liquor Land0.82street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 46 m apart · name similarity 0.82 · street similarity 0.90
overture Scotch Castle Liquor Landvtinfo SCOTCH CASTLE LIQUOR0.82street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 4 m apart · name similarity 0.82 · street similarity 0.90
ab-inbev SCOTCH CASTLE LIQUORmi-lcc SCOTCH CASTLE PARTY STORE0.64Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “near” pair)
Same distinctive name 'Scotch Castle' at the identical street address and ZIP, with only one business recorded there; 'Liquor' and 'Party Store' are interchangeable descriptors for a Michigan package
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Scotch Castle name and address match.
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at the same street address and ZIP in Detroit with near-identical coordinates, the names share the distinctive 'SCOTCH CASTLE' core (liquor store vs party store), and no other business is at the address, so this is one liquor outlet listed under two names.
pair 063f0c678e8af520292f

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
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:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-18 18:58insertoverture 745e2dfe-c7fc-46aa-9924-57b4861829b7 ↔ vtinfo fcb7097fd228bda0street written two waysmerged15
2026-11-18 18:58insertab-inbev 2534832 ↔ overture 745e2dfe-c7fc-46aa-9924-57b4861829b7street written two waysmerged15
2026-11-12 14:25insertab-inbev 2534832 ↔ mi-lcc L-000017911Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 2534832 ↔ vtinfo fcb7097fd228bda0same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000017911 ↔ overture a35b0d82-ac14-4359-81d7-4e649acf5f9bsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000013888 ↔ overture a35b0d82-ac14-4359-81d7-4e649acf5f9bsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000013888 ↔ mi-lcc L-000017911one store listed twicemerged