Outlets /
Amvets
Harper Woods, MI 48225 · O04d349734c04 · first seen 2026-11-03
4 sourceson premise · predictedalcohol: 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 | Amvets 2 other | a licence name in capitals, cleaned (derived; record_title.py) | AMVETS RICHARD S. HAYES POST 57 mi-lcc RICHARD S HAYES AMVETS POST 57 inspections |
| Street | 19730 Harper Ave 1 other | mi-lcc | 19730 HARPER ab-inbevvtinfo ×2 |
| City | Harper Woods | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48225 | mi-lcc | no other value |
| Pin | 42.43315, -82.92205 map | inspections | no other value |
| Phone | 3138859659 | vtinfo | no other value |
| Licences | mi-lcc L-000020125 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe8aa27eb9127; Obb9b6ebd83ce; O2282e6d49ab2
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 | AMVETS 136506 | 19730 HARPER, HARPER WOODS, MI, 48225 | 42.43324, -82.92207 | 2026-11-11 | 2026-11-20 | |
| inspections | RICHARD S HAYES AMVETS POST 57 inspections|mi|SFE-4882-030609 | 19730 HARPER AVE, Harper Woods, MI, 48225 | 42.43315, -82.92205 | 2026-11-20 | 2026-11-20 | |
| mi-lcc | AMVETS RICHARD S. HAYES POST 57 L-000020125 | 19730 Harper Ave, Harper Woods, MI, 48225 | 3138859659 | 42.43326, -82.92205 | 2026-11-03 | 2026-11-20 |
| vtinfo | AMVETS bce9b852d010605b | 19730 HARPER, HARPER WOODS, MI, 48225 | 3138859659 | 42.43305, -82.92183 | 2026-11-12 | 2026-11-20 |
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 AMVETS | vtinfo AMVETS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00 |
| inspections RICHARD S HAYES AMVETS POST 57 | mi-lcc AMVETS RICHARD S. HAYES POST 57 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00 |
| ab-inbev AMVETS | mi-lcc AMVETS RICHARD S. HAYES POST 57 | 0.25 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “control” pair) AMVETS post at same address Other Claude answers on this pair:
pair 111451e628c502e9d0ba |
| mi-lcc AMVETS RICHARD S. HAYES POST 57 | vtinfo AMVETS | 0.25 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair) AMVETS post with equal phone, same address Other Claude answers on this pair:
pair 22cff783e82344ceed61 |
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:31.
Every vote behind these (raw)
{
"votes": []
}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-20 22:08 | insert | inspections inspections|mi|SFE-4882-030609 ↔ mi-lcc L-000020125 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | mi-lcc L-000020125 ↔ vtinfo bce9b852d010605b | Claude judge: same | merged | 17 |
| 2026-11-12 17:29 | insert | ab-inbev 136506 ↔ mi-lcc L-000020125 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 136506 ↔ vtinfo bce9b852d010605b | same address and name | merged | 12 |