Rochester Mills Beer

Rochester, MI 48307 · O2b9a6b00c5d6 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed3 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
Rochester Mills Beer 3 other
a licence name in capitals, cleaned (derived; record_title.py)
ROCHESTER MILLS BEER COMPANY mi-lccoverturevtinfo ×5
ROCHESTER MILLS BEER CO inspections
rochester mills beer company rochester doordash
Street
400 Water St 2 other
mi-lcc
400 WATER ST STE 101 inspectionsvtinfo ×2
400 Water Street doordash
City
Rochester
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48307
mi-lccno other value
Pin
42.68065, -83.13128 map 2 other
doordash
127 m away mi-lcc ×3
92 m away inspections
Phone
2486505080 1 other
vtinfo
2486502824 mi-lcc ×3
Licences
mi-lcc L-000041198 · mi-lcc L-000093040 · mi-lcc L-000415221
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaec6f531747b; Oa0271093b09b; Oa6838ffe90b0; Occ898b4c1c82; O7331cfc0e1f0; O60c4faac4e29

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
doordashrochester mills beer company rochester
27810171
400 Water Street, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
42.68065, -83.131282026-10-082026-11-20
inspectionsROCHESTER MILLS BEER CO
inspections|mi|SFE-3963-075169
400 WATER ST STE 101, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
42.68147, -83.131462026-11-202026-11-20
mi-lccROCHESTER MILLS BEER COMPANY
L-000041198
400 Water St, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
248650282442.67951, -83.131412026-11-032026-11-20
mi-lccROCHESTER MILLS BEER COMPANY
L-000093040
400 Water St, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
248650282442.67951, -83.131412026-11-032026-11-20
mi-lccROCHESTER MILLS BEER COMPANY
L-000415221
400 Water St, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
248650282442.67951, -83.131412026-11-032026-11-20
overtureRochester Mills Beer Company
ec967c83-17ba-406d-aa56-46bdab37b11b
400 Water St, Rochester, MI, 48307
ZIP lookup: Rochester Hills, MI
248650508042.68078, -83.131332026-11-062026-11-20
vtinfoROCHESTER MILLS BEER COMPANY
d3188ae03d0412db
400 WATER ST STE 101, ROCHESTER, MI, 48307
ZIP lookup: Rochester Hills, MI
248650508042.68050, -83.131222026-11-152026-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
doordash rochester mills beer company rochesterinspections ROCHESTER MILLS BEER CO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 92 m apart · name similarity 1.00
doordash rochester mills beer company rochestermi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · name similarity 1.00
doordash rochester mills beer company rochestermi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · name similarity 1.00
doordash rochester mills beer company rochestermi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · name similarity 1.00
doordash rochester mills beer company rochesteroverture Rochester Mills Beer Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 15 m apart · name similarity 1.00
doordash rochester mills beer company rochestervtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 18 m apart · name similarity 1.00
inspections ROCHESTER MILLS BEER COmi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 218 m apart · name similarity 1.00
inspections ROCHESTER MILLS BEER COmi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 218 m apart · name similarity 1.00
inspections ROCHESTER MILLS BEER COmi-lcc ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 218 m apart · name similarity 1.00
inspections ROCHESTER MILLS BEER COoverture Rochester Mills Beer Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
inspections ROCHESTER MILLS BEER COvtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 110 m apart · name similarity 1.00
mi-lcc ROCHESTER MILLS BEER COMPANYmi-lcc ROCHESTER MILLS BEER COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ROCHESTER MILLS BEER COMPANYmi-lcc ROCHESTER MILLS BEER COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ROCHESTER MILLS BEER COMPANYoverture Rochester Mills Beer Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 141 m apart · name similarity 1.00 · phone: differs
mi-lcc ROCHESTER MILLS BEER COMPANYvtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 111 m apart · name similarity 1.00 · phone: differs
mi-lcc ROCHESTER MILLS BEER COMPANYoverture Rochester Mills Beer Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 141 m apart · name similarity 1.00 · phone: differs
mi-lcc ROCHESTER MILLS BEER COMPANYvtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 111 m apart · name similarity 1.00 · phone: differs
mi-lcc ROCHESTER MILLS BEER COMPANYoverture Rochester Mills Beer Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 141 m apart · name similarity 1.00 · phone: differs
mi-lcc ROCHESTER MILLS BEER COMPANYvtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 111 m apart · name similarity 1.00 · phone: differs
overture Rochester Mills Beer Companyvtinfo ROCHESTER MILLS BEER COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROCHESTER MILLS BEER COMPANY — 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/Brew Pub; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-3963-075169 ↔ overture ec967c83-17ba-406d-aa56-46bdab37b11bsame address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-075169 ↔ vtinfo d3188ae03d0412dbsame address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-075169 ↔ mi-lcc L-000093040same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-075169 ↔ mi-lcc L-000041198same address and namemerged17
2026-11-20 22:08insertdoordash 27810171 ↔ inspections inspections|mi|SFE-3963-075169same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-075169 ↔ mi-lcc L-000415221same address and namemerged17
2026-11-15 16:24insertoverture ec967c83-17ba-406d-aa56-46bdab37b11b ↔ vtinfo d3188ae03d0412dbsame address and namemerged15
2026-11-15 16:24insertmi-lcc L-000415221 ↔ vtinfo d3188ae03d0412dbsame address and namemerged15
2026-11-15 16:24insertmi-lcc L-000093040 ↔ vtinfo d3188ae03d0412dbsame address and namemerged15
2026-11-15 16:24insertmi-lcc L-000041198 ↔ vtinfo d3188ae03d0412dbsame address and namemerged15
2026-11-15 16:24insertdoordash 27810171 ↔ vtinfo d3188ae03d0412dbsame address and namemerged15
2026-11-06 18:13insertmi-lcc L-000415221 ↔ overture ec967c83-17ba-406d-aa56-46bdab37b11bsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000093040 ↔ overture ec967c83-17ba-406d-aa56-46bdab37b11bsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000041198 ↔ overture ec967c83-17ba-406d-aa56-46bdab37b11bsame address and namemerged11
2026-11-06 18:13insertdoordash 27810171 ↔ overture ec967c83-17ba-406d-aa56-46bdab37b11bsame address and namemerged11
2026-11-03 13:33backfilldoordash 27810171 ↔ mi-lcc L-000415221same address and namemerged
2026-11-03 13:33backfilldoordash 27810171 ↔ mi-lcc L-000093040same address and namemerged
2026-11-03 13:33backfilldoordash 27810171 ↔ mi-lcc L-000041198same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000041198 ↔ mi-lcc L-000415221one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000041198 ↔ mi-lcc L-000093040one store listed twicemerged