Outlets /
AMERICAN LEGION
FARMINGTON, MI 48336 · O08174960d2b9 · first seen 2026-11-03
3 sourcesunknownalcohol: licensed1 licence
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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | AMERICAN LEGION 1 other | the most common name a source states | GROVES-WALKER POST NO. 346, AMERICAN LEGION, DEPARTMENT OF MICHIGAN, INC. mi-lcc |
| Street | 21023 Farmington Rd | mi-lcc | no other value |
| City | Farmington Hills 1 other | mi-lcc | FARMINGTON ab-inbevvtinfo ×2 |
| State | MI | mi-lcc | no other value |
| ZIP | 48336 | mi-lcc | no other value |
| Pin | 42.44424, -83.37555 map | mi-lcc | no other value |
| Phone | 2482859813 1 other | vtinfo | 2488956674 mi-lcc |
| Licences | mi-lcc L-000021080 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O815252638789; O10fadba9ad4c
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | AMERICAN LEGION 4796871 | 21023 FARMINGTON RD, FARMINGTON, MI, 48336 | 42.44469, -83.37554 | 2026-11-11 | 2026-11-13 | |
| mi-lcc | GROVES-WALKER POST NO. 346, AMERICAN LEGION, DEPARTMENT OF MICHIGAN, INC. L-000021080 | 21023 Farmington Rd, Farmington Hills, MI, 48336 | 2488956674 | 42.44424, -83.37555 | 2026-11-03 | 2026-11-13 |
| vtinfo | AMERICAN LEGION 8cf2c3b70a22b788 | 21023 FARMINGTON RD, FARMINGTON, MI, 48336 | 2482859813 | 42.44441, -83.37565 | 2026-11-13 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev AMERICAN LEGION | vtinfo AMERICAN LEGION | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00 |
| ab-inbev AMERICAN LEGION | mi-lcc GROVES-WALKER POST NO. 346, AMERICAN LEGION, DEPARTMENT OF MICHIGAN, INC. | 0.33 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (88% confident; asked as a “same-address” pair) Same street address and ZIP, and the licence's legal name is the American Legion post, so the generic 'AMERICAN LEGION' account is that same post's premises. Other Claude answers on this pair:
pair 02dd1ad347f3f2618a92 |
Attributes
- Channel
- unknown
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- GROVES-WALKER POST NO. 346, AMERICAN LEGION, DEPARTMENT OF MICHIGAN, INC. — 1 outlets in the master under this operator
- Licence privileges
- beer_on, wine_on, spirits_on — MI Non-Profit/Club
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
"votes": []
}Trade area
- Other outlets
- 43 within 1 mi · 340 within 3 mi
- Off / on premise
- 8 / 26 within 1 mi · 95 / 178 within 3 mi
- Selling alcohol
- 20 within 1 mi · 169 within 3 mi
- Nearest
- same channel none within 3 mi · licensed 0.04 mi
- Setting
- urban (3,020 people per sq mi)
- People within 3 mi
- 85,402 (68,084 adults 21+, 37,482 households) from 25 tract(s), tracts within 3 mi
- Income
- per capita $53,585 · median household ~$97,771 (weighted mean of tract medians)
- Age and education
- median age ~44.7 · bachelor's or higher 50%
- Ethnicity
- Hispanic 4% · White 66% · Black 11% · Asian 14%
- Adults per alcohol outlet
- 400
- Alcohol spend within 3 mi
- $28,087,329 a year ($12,669,272 at home, $15,405,106 away) · $165,220 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-13 14:10 | insert | ab-inbev 4796871 ↔ vtinfo 8cf2c3b70a22b788 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 4796871 ↔ mi-lcc L-000021080 | Claude judge: same | merged | 12 |