AMERICAN LEGION

Comstock Park, MI 49321 · O0cd16a2429d1 · first seen 2026-11-03
3 sourceson premise · predictedalcohol: 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
AMERICAN LEGION 1 other
the most common name a source states
LOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGAN mi-lcc ×2
Street
3811 West River Dr NE 1 other
mi-lcc
3811 W RIVER DR NE ab-inbevvtinfo ×2
City
Comstock Park
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49321
mi-lccno other value
Pin
43.03200, -85.66806 map 1 other
mi-lcc
75 m away vtinfo
Phone
6167846280
vtinfono other value
Licences
mi-lcc L-000013412 · mi-lcc L-000020545
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of857c7b01ba6; Oe9b2dfbf1897; O1c8e02d8402b

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-inbevAMERICAN LEGION
2537619
3811 W RIVER DR NE, COMSTOCK PARK, MI, 4932143.03163, -85.668262026-11-112026-11-12
mi-lccLOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGAN
L-000013412
3811 West River Dr NE, Comstock Park, MI, 49321616784628043.03200, -85.668062026-11-032026-11-05
mi-lccLOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGAN
L-000020545
3811 West River Dr NE, Comstock Park, MI, 49321616784628043.03200, -85.668062026-11-032026-11-05
vtinfoAMERICAN LEGION
531e0814d32b79de
3811 W RIVER DR NE, COMSTOCK PARK, MI, 49321616784628043.03189, -85.668962026-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 AMERICAN LEGIONvtinfo AMERICAN LEGION1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 64 m apart · name similarity 1.00
mi-lcc LOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGANmi-lcc LOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGAN1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev AMERICAN LEGIONmi-lcc LOUIS TEISTLER POST NO. 47, AMERICAN LEGION, DEPARTMENT OF MICHIGAN0.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
American Legion post at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are the American Legion at 3811 West River Dr NE, Comstock Park, MI 49321, with coordinates 0.044 km apart; the AB InBev account 'AMERICAN LEGION' matches the Michigan licence filed for Louis Teistler Post No. 47, American Legion, so they are one operation, though the address is shared with another business.
pair 37f69dd502d10d4f4d2e

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Non-Profit/Club; MI Retail - Off Premises/Specially Designated Merchant
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
11 within 1 mi · 276 within 3 mi
Off / on premise
4 / 6 within 1 mi · 77 / 135 within 3 mi
Selling alcohol
7 within 1 mi · 155 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.05 mi
Setting
suburban (1,665 people per sq mi)
People within 3 mi
47,077 (36,271 adults 21+, 20,426 households) from 13 tract(s), tracts within 3 mi
Income
per capita $37,199 · median household ~$72,422 (weighted mean of tract medians)
Age and education
median age ~35.8 · bachelor's or higher 36%
Ethnicity
Hispanic 11% · White 77% · Black 7% · Asian 3%
Adults per alcohol outlet
233
Alcohol spend within 3 mi
$11,773,059 a year ($5,586,928 at home, $6,180,865 away) · $75,468 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 2537619 ↔ mi-lcc L-000013412Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2537619 ↔ vtinfo 531e0814d32b79desame address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000013412 ↔ mi-lcc L-000020545one store listed twicemerged