The Alley

Port Huron, MI 48060 · O0c16ded700d3 · first seen 2026-11-03
4 sourceson premise · baralcohol: 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
The Alley 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ALLEY LLC inspectionsmi-lcc ×3
THE ALLEY ROOM ab-inbevoverture ×2
Street
409 Quay St
mi-lccno other value
City
Port Huron
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48060
mi-lccno other value
Pin
42.97606, -82.42370 map 1 other
overture
64 m away inspections
Phone
8102958747 1 other
overture
5863441334 mi-lcc ×2
Licences
mi-lcc L-000433977 · mi-lcc L-000433978
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocb24a69a984c; Odd5ac08bd427; Oaf0535c9ddb9; O44c6351a4a5a

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-inbevTHE ALLEY ROOM
3122957
409 QUAY ST, PORT HURON, MI, 4806042.97594, -82.423752026-11-112026-11-20
inspectionsALLEY LLC
inspections|mi|SFE-4374-252323
409 QUAY ST, Port Huron, MI, 4806042.97566, -82.423132026-11-202026-11-20
mi-lccALLEY LLC
L-000433977
409 Quay St, Port Huron, MI, 48060586344133442.97596, -82.423482026-11-032026-11-20
mi-lccALLEY LLC
L-000433978
409 Quay St, Port Huron, MI, 48060586344133442.97596, -82.423482026-11-032026-11-20
overtureThe Alley Room
339b6212-2de9-4ba7-9eed-62cccf7ec737
409 Quay St, Port Huron, MI, 48060810295874742.97606, -82.423702026-11-132026-11-20

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 THE ALLEY ROOMoverture The Alley Room1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
inspections ALLEY LLCmi-lcc ALLEY LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
inspections ALLEY LLCmi-lcc ALLEY LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
mi-lcc ALLEY LLCmi-lcc ALLEY LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev THE ALLEY ROOMmi-lcc ALLEY LLC0.58one name contains the other, same addressmergedjudge: None · pair_id: bf52e899403ff931629c · person: None · rule: names contained at one address · stratum: near
ab-inbev THE ALLEY ROOMmi-lcc ALLEY LLC0.58one name contains the other, same addressmergedjudge: None · pair_id: 5a9946b773cc4a1a9dbb · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ALLEY 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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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-20 22:08insertinspections inspections|mi|SFE-4374-252323 ↔ mi-lcc L-000433978same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4374-252323 ↔ mi-lcc L-000433977same address and namemerged17
2026-11-16 14:56insertab-inbev 3122957 ↔ mi-lcc L-000433978one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 3122957 ↔ mi-lcc L-000433977one name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 3122957 ↔ overture 339b6212-2de9-4ba7-9eed-62cccf7ec737same address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000433977 ↔ mi-lcc L-000433978one store listed twicemerged