Clarkston Union

Clarkston, MI 48346 · O0a6dd78b6120 · 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
Clarkston Union 4 other
a licence name in capitals, cleaned (derived; record_title.py)
CLARK BAR, INC. mi-lcc (legal name) ×2
THE CLARKSTON UNION mi-lcc ×2
Clarkston Union Bar & Kitchen overture
clarkston union bar kitchen city of the village of clarkston doordash
Street
54 S Main St 1 other
mi-lcc
54 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.73418, -83.41877 map 1 other
doordash
50 m away ab-inbev
Phone
2486206100
vtinfono other value
Licences
mi-lcc L-000019402 · mi-lcc L-000040908
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc2e1fc4aff86; O941c38651fd1; O9303601f09c5; O1febffec8fcc; Obd0e9474c6c0

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-inbevCLARKSTON UNION
2503099
54 S MAIN ST, CLARKSTON, MI, 4834642.73459, -83.419032026-11-112026-11-13
doordashclarkston union bar kitchen city of the village of clarkston
27592111
54 South Main Street, City of the Village of Clarkston, MI, 48346
ZIP lookup: Clarkston, MI
42.73418, -83.418772026-10-082026-11-13
mi-lccTHE CLARKSTON UNION
legal name: CLARK BAR, INC.
L-000019402
54 S Main St, Clarkston, MI, 48346248620610042.73441, -83.419012026-11-032026-11-13
mi-lccTHE CLARKSTON UNION
legal name: CLARK BAR, INC.
L-000040908
54 S Main St, Clarkston, MI, 48346248620610042.73441, -83.419012026-11-032026-11-13
overtureClarkston Union Bar & Kitchen
534121c2-37d9-4ec2-9579-cc34b6fcba6e
54 S Main St, Clarkston, MI, 48346248620610042.73413, -83.418792026-11-132026-11-13
vtinfoCLARKSTON UNION
12b46b97d6e25ce7
54 S MAIN ST, CLARKSTON, MI, 48346248620610042.73413, -83.418772026-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 CLARKSTON UNIONmi-lcc THE CLARKSTON UNION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev CLARKSTON UNIONmi-lcc THE CLARKSTON UNION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev CLARKSTON UNIONvtinfo CLARKSTON UNION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
mi-lcc THE CLARKSTON UNIONmi-lcc THE CLARKSTON UNION1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE CLARKSTON UNIONvtinfo CLARKSTON UNION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00 · phone: equal
mi-lcc THE CLARKSTON UNIONvtinfo CLARKSTON UNION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00 · phone: equal
ab-inbev CLARKSTON UNIONoverture Clarkston Union Bar & Kitchen0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, kitchen · name Jaro-Winkler 0.70 · same street + ZIP · pins 54 m apart · name similarity 0.61
mi-lcc THE CLARKSTON UNIONoverture Clarkston Union Bar & Kitchen0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, kitchen · name Jaro-Winkler 0.87 · same street + ZIP · pins 35 m apart · name similarity 0.61 · phone: equal
mi-lcc THE CLARKSTON UNIONoverture Clarkston Union Bar & Kitchen0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, kitchen · name Jaro-Winkler 0.87 · same street + ZIP · pins 35 m apart · name similarity 0.61 · phone: equal
overture Clarkston Union Bar & Kitchenvtinfo CLARKSTON UNION0.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, kitchen · name Jaro-Winkler 0.70 · same street + ZIP · pins 2 m apart · name similarity 0.61 · phone: equal
ab-inbev CLARKSTON UNIONdoordash clarkston union bar kitchen city of the village of clarkston0.44Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “same-address” pair)
Same name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address (54 S Main St / 54 South Main Street) in Clarkston, MI 48346 with a very short distance, and the names 'CLARKSTON UNION' and 'clarkston union bar kitchen' match as one operation; no other business is held at that address.
pair 3c68451bad9e3d6797b6

Attributes

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

Trade area

Other outlets
29 within 1 mi · 150 within 3 mi
Off / on premise
4 / 17 within 1 mi · 32 / 77 within 3 mi
Selling alcohol
20 within 1 mi · 87 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.06 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:24insertoverture 534121c2-37d9-4ec2-9579-cc34b6fcba6e ↔ vtinfo 12b46b97d6e25ce7same address and namemerged15
2026-11-15 16:24insertab-inbev 2503099 ↔ vtinfo 12b46b97d6e25ce7same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000019402 ↔ vtinfo 12b46b97d6e25ce7same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000040908 ↔ vtinfo 12b46b97d6e25ce7same address and namemerged15
2026-11-13 14:10insertab-inbev 2503099 ↔ overture 534121c2-37d9-4ec2-9579-cc34b6fcba6esame address and namemerged15
2026-11-13 14:10insertmi-lcc L-000019402 ↔ overture 534121c2-37d9-4ec2-9579-cc34b6fcba6esame address and namemerged15
2026-11-13 14:10insertmi-lcc L-000040908 ↔ overture 534121c2-37d9-4ec2-9579-cc34b6fcba6esame address and namemerged15
2026-11-12 17:29insertab-inbev 2503099 ↔ doordash 27592111Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2503099 ↔ mi-lcc L-000040908same address and namemerged12
2026-11-11 12:56insertab-inbev 2503099 ↔ mi-lcc L-000019402same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000019402 ↔ mi-lcc L-000040908one store listed twicemerged