Outlets /
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.
| Field | Master value | Taken from | What 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-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48234 | mi-lcc | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SCOTCH CASTLE LIQUOR 2534832 | 2867 E 7 MILE RD, DETROIT, MI, 48234 | 42.43300, -83.07438 | 2026-11-11 | 2026-11-18 | |
| mi-lcc | SCOTCH CASTLE PARTY STORE L-000013888 | 2867 E 7 Mile Rd, Detroit, MI, 48234 | 3133687500 | 42.43298, -83.07451 | 2026-11-03 | 2026-11-18 |
| mi-lcc | SCOTCH CASTLE PARTY STORE L-000017911 | 2867 E 7 Mile Rd, Detroit, MI, 48234 | 3133687500 | 42.43298, -83.07451 | 2026-11-03 | 2026-11-18 |
| overture | Scotch Castle Liquor Land 745e2dfe-c7fc-46aa-9924-57b4861829b7 | 2867 7 Mile Rd E, Detroit, MI, 48234 | 3133669551 | 42.43341, -83.07426 | 2026-11-18 | 2026-11-18 |
| vtinfo | SCOTCH CASTLE LIQUOR fcb7097fd228bda0 | 2867 E 7 MILE RD, DETROIT, MI, 48234 | 3133669551 | 42.43343, -83.07423 | 2026-11-12 | 2026-11-18 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SCOTCH CASTLE LIQUOR | vtinfo SCOTCH CASTLE LIQUOR | 1.00 | same address and name | merged | address 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 STORE | mi-lcc SCOTCH CASTLE PARTY STORE | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc SCOTCH CASTLE PARTY STORE | overture a35b0d82-ac14-4359-81d7-4e649acf5f9b | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 |
| mi-lcc SCOTCH CASTLE PARTY STORE | overture a35b0d82-ac14-4359-81d7-4e649acf5f9b | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 |
| ab-inbev SCOTCH CASTLE LIQUOR | overture Scotch Castle Liquor Land | 0.82 | street written two ways | merged | name Jaro-Winkler 0.93 · matched on zip · pins 46 m apart · name similarity 0.82 · street similarity 0.90 |
| overture Scotch Castle Liquor Land | vtinfo SCOTCH CASTLE LIQUOR | 0.82 | street written two ways | merged | name Jaro-Winkler 0.93 · matched on zip · pins 4 m apart · name similarity 0.82 · street similarity 0.90 |
| ab-inbev SCOTCH CASTLE LIQUOR | mi-lcc SCOTCH CASTLE PARTY STORE | 0.64 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-18 18:58 | insert | overture 745e2dfe-c7fc-46aa-9924-57b4861829b7 ↔ vtinfo fcb7097fd228bda0 | street written two ways | merged | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 2534832 ↔ overture 745e2dfe-c7fc-46aa-9924-57b4861829b7 | street written two ways | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2534832 ↔ mi-lcc L-000017911 | Claude judge: same | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 2534832 ↔ vtinfo fcb7097fd228bda0 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | mi-lcc L-000017911 ↔ overture a35b0d82-ac14-4359-81d7-4e649acf5f9b | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000013888 ↔ overture a35b0d82-ac14-4359-81d7-4e649acf5f9b | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000013888 ↔ mi-lcc L-000017911 | one store listed twice | merged |