Union Wood Shop

Clarkston, MI 48346 · O182f49adbf2a · 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
Union Wood Shop 3 other
a licence name in capitals, cleaned (derived; record_title.py)
UNION WOODSHOP mi-lccoverture ×3
CASH BAR, INC. mi-lcc (legal name) ×2
union woodshop city of the village of clarkston doordash
Street
18 S Main St 1 other
mi-lcc
18 South Main Street doordash
City
Clarkston 1 other
mi-lcc
City of the Village of Clarkston doordash
State
MI
mi-lccno other value
ZIP
48346
mi-lccno other value
Pin
42.73541, -83.41881 map
doordashno other value
Phone
2486255660
vtinfono other value
Licences
mi-lcc L-000153807 · mi-lcc L-000153808
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O523bb80139b0; O3db69006d11d; O59afa547a592; O2851084547c3; O8cbbffbb96af

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-inbevUNION WOOD SHOP
3336366
18 S MAIN ST, CLARKSTON, MI, 4834642.73572, -83.419052026-11-112026-11-11
doordashunion woodshop city of the village of clarkston
27619540
18 South Main Street, City of the Village of Clarkston, MI, 48346
ZIP lookup: Clarkston, MI
42.73541, -83.418812026-10-082026-11-12
mi-lccUNION WOODSHOP
legal name: CASH BAR, INC.
L-000153807
18 S Main St, Clarkston, MI, 48346248625566042.73534, -83.419042026-11-032026-11-06
mi-lccUNION WOODSHOP
legal name: CASH BAR, INC.
L-000153808
18 S Main St, Clarkston, MI, 48346248625566042.73534, -83.419042026-11-032026-11-06
overtureUnion Woodshop
dc8acdbe-8702-4395-90ac-8d8e936034f2
18 S Main St, Clarkston, MI, 48346248625566042.73541, -83.418982026-11-062026-11-06
vtinfoUNION WOOD SHOP
15172b927ea7767d
18 S MAIN ST, CLARKSTON, MI, 48346248625566042.73549, -83.418882026-11-152026-11-15

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 UNION WOOD SHOPvtinfo UNION WOOD SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
mi-lcc UNION WOODSHOPmi-lcc UNION WOODSHOP1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc UNION WOODSHOPoverture Union Woodshop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 · phone: equal
mi-lcc UNION WOODSHOPoverture Union Woodshop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 · phone: equal
doordash union woodshop city of the village of clarkstonmi-lcc UNION WOODSHOP0.59Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
Same distinctive name, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Union Woodshop at 18 S Main St, Clarkston MI 48346 with coordinates about 20 m apart, and the Michigan licence's legal entity is a bar operator behind the trade name, with no other business at that address.
pair 3529da558df0b824d763
ab-inbev UNION WOOD SHOPmi-lcc UNION WOODSHOP0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 42 m apart · name similarity 0.58
ab-inbev UNION WOOD SHOPmi-lcc UNION WOODSHOP0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 42 m apart · name similarity 0.58
ab-inbev UNION WOOD SHOPoverture Union Woodshop0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 35 m apart · name similarity 0.58
mi-lcc UNION WOODSHOPvtinfo UNION WOOD SHOP0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 21 m apart · name similarity 0.58 · phone: equal
mi-lcc UNION WOODSHOPvtinfo UNION WOOD SHOP0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 21 m apart · name similarity 0.58 · phone: equal
overture Union Woodshopvtinfo UNION WOOD SHOP0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 12 m apart · name similarity 0.58 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CASH BAR, 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 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
28 within 1 mi · 150 within 3 mi
Off / on premise
4 / 15 within 1 mi · 32 / 77 within 3 mi
Selling alcohol
19 within 1 mi · 87 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (906 people per sq mi)
People within 3 mi
25,617 (19,102 adults 21+, 9,840 households) from 6 tract(s), tracts within 3 mi
Income
per capita $54,564 · median household ~$110,699 (weighted mean of tract medians)
Age and education
median age ~42.8 · bachelor's or higher 46%
Ethnicity
Hispanic 6% · White 85% · Black 4% · Asian 1%
Adults per alcohol outlet
217
Alcohol spend within 3 mi
$8,195,477 a year ($3,609,831 at home, $4,582,124 away) · $93,130 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-15 16:24insertmi-lcc L-000153807 ↔ vtinfo 15172b927ea7767dsame address and namemerged15
2026-11-15 16:24insertmi-lcc L-000153808 ↔ vtinfo 15172b927ea7767dsame address and namemerged15
2026-11-15 16:24insertoverture dc8acdbe-8702-4395-90ac-8d8e936034f2 ↔ vtinfo 15172b927ea7767dsame address and namemerged15
2026-11-15 16:24insertab-inbev 3336366 ↔ vtinfo 15172b927ea7767dsame address and namemerged15
2026-11-12 17:29insertdoordash 27619540 ↔ mi-lcc L-000153807Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 3336366 ↔ mi-lcc L-000153807same address and namemerged12
2026-11-11 12:56insertab-inbev 3336366 ↔ mi-lcc L-000153808same address and namemerged12
2026-11-11 12:56insertab-inbev 3336366 ↔ overture dc8acdbe-8702-4395-90ac-8d8e936034f2same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000153807 ↔ overture dc8acdbe-8702-4395-90ac-8d8e936034f2same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000153808 ↔ overture dc8acdbe-8702-4395-90ac-8d8e936034f2same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000153807 ↔ mi-lcc L-000153808one store listed twicemerged