Veterans of Foreign Wars

ROCKWOOD, MI 48173 · O60a60bb79400 · 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.

FieldMaster valueTaken fromWhat other sources say
Name
Veterans of Foreign Wars 1 other
a licence name in capitals, cleaned (derived; record_title.py)
ROCK OF GIBRALTAR POST #4230, VETERANS OF FOREIGN WARS OF THE UNITED STATES mi-lcc
Street
35427 W Jefferson Ave 1 other
mi-lcc
35427 W JEFFERSON ab-inbevvtinfo ×2
City
Rockwood
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48173
mi-lccno other value
Pin
42.05000, -83.21148 map 2 other
mi-lcc
201 m away ab-inbev
59 m away vtinfo
Phone
7343793000 1 other
vtinfo
7343799190 mi-lcc
Licences
mi-lcc L-000225283
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe8cad213a6b5; Od673acda8e97

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-inbevVETERANS OF FOREIGN WARS
139346
35427 W JEFFERSON, ROCKWOOD, MI, 4817342.04821, -83.211222026-11-112026-11-11
mi-lccROCK OF GIBRALTAR POST #4230, VETERANS OF FOREIGN WARS OF THE UNITED STATES
L-000225283
35427 W Jefferson Ave, Rockwood, MI, 48173734379919042.05000, -83.211482026-11-032026-11-18
vtinfoVETERANS OF FOREIGN WARS
4d0b5adc9e4ef5f6
35427 W JEFFERSON, ROCKWOOD, MI, 48173734379300042.04970, -83.210902026-11-162026-11-17

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 VETERANS OF FOREIGN WARSvtinfo VETERANS OF FOREIGN WARS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 168 m apart · name similarity 1.00
mi-lcc ROCK OF GIBRALTAR POST #4230, VETERANS OF FOREIGN WARS OF THE UNITED STATESvtinfo VETERANS OF FOREIGN WARS0.46Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
VFW post at identical address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at the same street address in Rockwood, MI (distance about 0.06 km), and no other business is listed there; the names are the same VFW organization, with A being the local post's licence and B the VFW account carrying brands. The differing phone numbers weaken the match somewhat.
pair dc4650b86b9d8a4ded85
ab-inbev VETERANS OF FOREIGN WARSmi-lcc ROCK OF GIBRALTAR POST #4230, VETERANS OF FOREIGN WARS OF THE UNITED STATES0.43Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “same-address” pair)
VFW post at same address; names agree
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address in Rockwood, MI 48173 (about 0.2 km apart), and both names are the Veterans of Foreign Wars, with the mi-lcc record giving the full post name; no other business is held at that address, so it is most likely the same VFW post outlet.
pair 7144b1b544fbcb5e22ec

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — MI Non-Profit/Club
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
5 within 1 mi · 31 within 3 mi
Off / on premise
0 / 2 within 1 mi · 11 / 12 within 3 mi
Selling alcohol
5 within 1 mi · 24 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.12 mi
Setting
rural (396 people per sq mi)
People within 3 mi
11,197 (8,197 adults 21+, 4,293 households) from 4 tract(s), tracts within 3 mi
Income
per capita $42,230 · median household ~$92,826 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 26%
Ethnicity
Hispanic 7% · White 90% · Black 0% · Asian 2%
Adults per alcohol outlet
328
Alcohol spend within 3 mi
$3,095,751 a year ($1,413,957 at home, $1,680,384 away) · $123,830 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-19 20:37insertmi-lcc L-000225283 ↔ vtinfo 4d0b5adc9e4ef5f6Claude judge: samemerged17
2026-11-18 18:58insertab-inbev 139346 ↔ mi-lcc L-000225283Claude judge: samemerged15
2026-11-16 14:56insertab-inbev 139346 ↔ vtinfo 4d0b5adc9e4ef5f6same address and namemerged15