STEAMPUNK CRAFT BEER LLC

Utica, MI 48317 · O28848b5f1a18 · first seen 2026-11-03
3 sourcesoff premise · liquor_storealcohol: 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
STEAMPUNK CRAFT BEER LLC 1 other
the most common name a source states
STEAMPUNK TAPROOM ab-inbevvtinfo ×2
Street
7722 Auburn Rd 1 other
mi-lcc
7728 AUBURN RD ab-inbevvtinfo ×2
City
Utica
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48317
mi-lccno other value
Pin
42.62597, -83.03432 map
mi-lccno other value
Phone
5862624182
vtinfono other value
Licences
mi-lcc L-000270295 · mi-lcc L-000270296
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oba08c0a9829c; Oc6883dfa6f0e; Oa72201cef2f3

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-inbevSTEAMPUNK TAPROOM
4007845
7728 AUBURN RD, UTICA, MI, 4831742.62598, -83.033812026-11-112026-11-11
mi-lccSTEAMPUNK CRAFT BEER LLC
L-000270295
7722 Auburn Rd, Utica, MI, 48317586262418242.62597, -83.034322026-11-032026-11-12
mi-lccSTEAMPUNK CRAFT BEER LLC
L-000270296
7722 Auburn Rd, Utica, MI, 48317586262418242.62597, -83.034322026-11-032026-11-12
vtinfoSTEAMPUNK TAPROOM
e0f1846f073de328
7728 AUBURN RD, UTICA, MI, 48317586262418242.62587, -83.034002026-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 STEAMPUNK TAPROOMvtinfo STEAMPUNK TAPROOM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
mi-lcc STEAMPUNK CRAFT BEER LLCmi-lcc STEAMPUNK CRAFT BEER LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev STEAMPUNK TAPROOMmi-lcc STEAMPUNK CRAFT BEER LLC0.37Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “control” pair)
Steampunk names, adjacent numbers, 42m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records are the Steampunk brewery/taproom in Utica, MI, with coordinates about 42 m apart and only one business counted at the address, though the street numbers differ (7728 vs 7722) and the LCC name is the LLC behind the taproom brand.
pair 39671b1322e8b5080b82

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
STEAMPUNK CRAFT BEER LLC — 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 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
80 within 1 mi · 417 within 3 mi
Off / on premise
20 / 41 within 1 mi · 110 / 233 within 3 mi
Selling alcohol
47 within 1 mi · 195 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.01 mi
Setting
urban (3,158 people per sq mi)
People within 3 mi
89,287 (70,447 adults 21+, 37,899 households) from 21 tract(s), tracts within 3 mi
Income
per capita $42,072 · median household ~$81,743 (weighted mean of tract medians)
Age and education
median age ~44.4 · bachelor's or higher 33%
Ethnicity
Hispanic 4% · White 80% · Black 6% · Asian 7%
Adults per alcohol outlet
359
Alcohol spend within 3 mi
$24,773,474 a year ($11,454,448 at home, $13,307,426 away) · $126,395 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 17:29insertab-inbev 4007845 ↔ mi-lcc L-000270296Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4007845 ↔ vtinfo e0f1846f073de328same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000270295 ↔ mi-lcc L-000270296one store listed twicemerged