Doug's Train Wreck

Mount Clemens, MI 48043 · O1864763961f5 · first seen 2026-11-03
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
Doug's Train Wreck 2 other
a licence name in capitals, cleaned (derived; record_title.py)
DOUGS TRAIN WRECK ab-inbevinspectionsoverturevtinfo ×4
DOUG'S TRAIN WRECK, INC. mi-lcc ×2
Street
201 Grand Ave
mi-lccno other value
City
Mount Clemens 1 other
mi-lcc
Mt Clemens overture
State
MI
mi-lccno other value
ZIP
48043
mi-lccno other value
Pin
42.59861, -82.89187 map 2 other
overture
182 m away mi-lcc ×2
191 m away inspections
Phone
5864638135 1 other
vtinfo
2486265050 mi-lcc ×2
Licences
mi-lcc L-000472966 · mi-lcc L-000472967
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaeb245fc61c1; O81fa23d6fc1f; Oe866f92fb79d; O1b2f7fa1017b; O6c50756a849a

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-inbevDOUGS TRAIN WRECK
4713727
201 GRAND AVE, MOUNT CLEMENS, MI, 4804342.59884, -82.891812026-11-112026-11-12
inspectionsDOUGS TRAIN WRECK
inspections|mi|SFE-5550-356338
201 GRAND AVE, Mount Clemens, MI, 4804342.60013, -82.890782026-11-202026-11-20
mi-lccDOUG'S TRAIN WRECK, INC.
L-000472966
201 Grand Ave, Mount Clemens, MI, 48043248626505042.60008, -82.890872026-11-032026-11-12
mi-lccDOUG'S TRAIN WRECK, INC.
L-000472967
201 Grand Ave, Mount Clemens, MI, 48043248626505042.60008, -82.890872026-11-032026-11-12
overturedougs train wreck
a7e2b05d-01d8-4606-b380-1166c6c64c99
201 Grand Ave, Mt Clemens, MI, 48043
ZIP lookup: Mount Clemens, MI
586463813542.59861, -82.891872026-11-062026-11-12
vtinfoDOUGS TRAIN WRECK
103bee2250552784
201 GRAND AVE, MOUNT CLEMENS, MI, 48043586463813542.59863, -82.891892026-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 DOUGS TRAIN WRECKinspections DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 166 m apart · name similarity 1.00
ab-inbev DOUGS TRAIN WRECKmi-lcc DOUG'S TRAIN WRECK, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 158 m apart · name similarity 1.00
ab-inbev DOUGS TRAIN WRECKmi-lcc DOUG'S TRAIN WRECK, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 158 m apart · name similarity 1.00
ab-inbev DOUGS TRAIN WRECKoverture dougs train wreck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ab-inbev DOUGS TRAIN WRECKvtinfo DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
inspections DOUGS TRAIN WRECKmi-lcc DOUG'S TRAIN WRECK, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections DOUGS TRAIN WRECKmi-lcc DOUG'S TRAIN WRECK, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections DOUGS TRAIN WRECKoverture dougs train wreck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 191 m apart · name similarity 1.00
inspections DOUGS TRAIN WRECKvtinfo DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 189 m apart · name similarity 1.00
mi-lcc DOUG'S TRAIN WRECK, INC.mi-lcc DOUG'S TRAIN WRECK, INC.1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc DOUG'S TRAIN WRECK, INC.overture dougs train wreck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 182 m apart · name similarity 1.00 · phone: differs
mi-lcc DOUG'S TRAIN WRECK, INC.vtinfo DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 181 m apart · name similarity 1.00 · phone: differs
mi-lcc DOUG'S TRAIN WRECK, INC.overture dougs train wreck1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 182 m apart · name similarity 1.00 · phone: differs
mi-lcc DOUG'S TRAIN WRECK, INC.vtinfo DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 181 m apart · name similarity 1.00 · phone: differs
overture dougs train wreckvtinfo DOUGS TRAIN WRECK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DOUG'S TRAIN WRECK, INC. — 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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
83 within 1 mi · 269 within 3 mi
Off / on premise
22 / 40 within 1 mi · 71 / 134 within 3 mi
Selling alcohol
50 within 1 mi · 154 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.05 mi
Setting
urban (3,513 people per sq mi)
People within 3 mi
99,319 (77,820 adults 21+, 43,838 households) from 28 tract(s), tracts within 3 mi
Income
per capita $41,423 · median household ~$76,646 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 25%
Ethnicity
Hispanic 4% · White 73% · Black 15% · Asian 2%
Adults per alcohol outlet
502
Alcohol spend within 3 mi
$26,903,177 a year ($12,547,872 at home, $14,344,393 away) · $173,569 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-20 22:08insertinspections inspections|mi|SFE-5550-356338 ↔ vtinfo 103bee2250552784same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-5550-356338 ↔ overture a7e2b05d-01d8-4606-b380-1166c6c64c99same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-5550-356338 ↔ mi-lcc L-000472966same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-5550-356338 ↔ mi-lcc L-000472967same address and namemerged17
2026-11-20 22:08insertab-inbev 4713727 ↔ inspections inspections|mi|SFE-5550-356338same address and namemerged17
2026-11-14 20:23insertoverture a7e2b05d-01d8-4606-b380-1166c6c64c99 ↔ vtinfo 103bee2250552784same address and namemerged15
2026-11-12 14:25insertmi-lcc L-000472967 ↔ vtinfo 103bee2250552784same address and namemerged12
2026-11-12 14:25insertab-inbev 4713727 ↔ vtinfo 103bee2250552784same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000472966 ↔ vtinfo 103bee2250552784same address and namemerged12
2026-11-11 12:56insertab-inbev 4713727 ↔ overture a7e2b05d-01d8-4606-b380-1166c6c64c99same address and namemerged12
2026-11-11 12:56insertab-inbev 4713727 ↔ mi-lcc L-000472966same address and namemerged12
2026-11-11 12:56insertab-inbev 4713727 ↔ mi-lcc L-000472967same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000472966 ↔ overture a7e2b05d-01d8-4606-b380-1166c6c64c99same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000472967 ↔ overture a7e2b05d-01d8-4606-b380-1166c6c64c99same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000472966 ↔ mi-lcc L-000472967one store listed twicemerged