Cognac Castle

Detroit, MI 48224 · O0513f4edc5b2 · 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
Cognac Castle 1 other
a source's own spelling of the licence name (record_title.py)
DHD LIQUOR, INC. mi-lcc (legal name) ×2
Street
15415 Harper Ave 1 other
mi-lcc
15415 HARPER ab-inbevvtinfo ×2
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48224
mi-lccno other value
Pin
42.40754, -82.95502 map
overtureno other value
Phone
3138395001 1 other
vtinfo
3133826515 mi-lcc ×2
Licences
mi-lcc L-000279934 · mi-lcc L-000279935
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob10e1afe1a06; O58cd91a30be2; Odf89acb5425d; O1b96f791b024

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-inbevCOGNAC CASTLE
2548709
15415 HARPER, DETROIT, MI, 4822442.40757, -82.954692026-11-112026-11-12
mi-lccCOGNAC CASTLE
legal name: DHD LIQUOR, INC.
L-000279934
15415 Harper Ave, Detroit, MI, 48224313382651542.40741, -82.955322026-11-032026-11-12
mi-lccCOGNAC CASTLE
legal name: DHD LIQUOR, INC.
L-000279935
15415 Harper Ave, Detroit, MI, 48224313382651542.40741, -82.955322026-11-032026-11-12
overtureCognac Castle
80c3dfdd-4a7c-4f6d-b34e-b0609148fce4
15415 Harper Ave, Detroit, MI, 48224313839500142.40754, -82.955022026-11-062026-11-12
vtinfoCOGNAC CASTLE
371ef0de61830d84
15415 HARPER, DETROIT, MI, 48224313839500142.40760, -82.955192026-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 COGNAC CASTLEmi-lcc COGNAC CASTLE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 55 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev COGNAC CASTLEmi-lcc COGNAC CASTLE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 55 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev COGNAC CASTLEoverture Cognac Castle1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 27 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev COGNAC CASTLEvtinfo COGNAC CASTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
mi-lcc COGNAC CASTLEmi-lcc COGNAC CASTLE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc COGNAC CASTLEoverture Cognac Castle1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 · phone: differs
mi-lcc COGNAC CASTLEvtinfo COGNAC CASTLE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 24 m apart · name similarity 1.00 · street similarity 0.75
mi-lcc COGNAC CASTLEoverture Cognac Castle1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 · phone: differs
mi-lcc COGNAC CASTLEvtinfo COGNAC CASTLE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 24 m apart · name similarity 1.00 · street similarity 0.75
overture Cognac Castlevtinfo COGNAC CASTLE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 16 m apart · name similarity 1.00 · street similarity 0.75

Attributes

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

Trade area

Other outlets
57 within 1 mi · 451 within 3 mi
Off / on premise
17 / 30 within 1 mi · 148 / 215 within 3 mi
Selling alcohol
28 within 1 mi · 260 within 3 mi
Nearest
same channel 0.27 mi · licensed 0.51 mi
Setting
urban (4,902 people per sq mi)
People within 3 mi
138,591 (96,026 adults 21+, 52,284 households) from 52 tract(s), tracts within 3 mi
Income
per capita $30,652 · median household ~$61,359 (weighted mean of tract medians)
Age and education
median age ~35.9 · bachelor's or higher 25%
Ethnicity
Hispanic 2% · White 22% · Black 73% · Asian 1%
Adults per alcohol outlet
368
Alcohol spend within 3 mi
$27,331,229 a year ($13,069,505 at home, $14,247,999 away) · $104,717 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-000279934 ↔ vtinfo 371ef0de61830d84street written two waysmerged12
2026-11-12 14:25insertmi-lcc L-000279935 ↔ vtinfo 371ef0de61830d84street written two waysmerged12
2026-11-12 14:25insertoverture 80c3dfdd-4a7c-4f6d-b34e-b0609148fce4 ↔ vtinfo 371ef0de61830d84street written two waysmerged12
2026-11-12 14:25insertab-inbev 2548709 ↔ vtinfo 371ef0de61830d84same address and namemerged12
2026-11-11 12:56insertab-inbev 2548709 ↔ mi-lcc L-000279934street written two waysmerged12
2026-11-11 12:56insertab-inbev 2548709 ↔ mi-lcc L-000279935street written two waysmerged12
2026-11-11 12:56insertab-inbev 2548709 ↔ overture 80c3dfdd-4a7c-4f6d-b34e-b0609148fce4street written two waysmerged12
2026-11-06 18:13insertmi-lcc L-000279934 ↔ overture 80c3dfdd-4a7c-4f6d-b34e-b0609148fce4same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000279935 ↔ overture 80c3dfdd-4a7c-4f6d-b34e-b0609148fce4same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000279934 ↔ mi-lcc L-000279935one store listed twicemerged