Craft Breww City

Farmington Hills, MI 48334 · O28fc4264dcb7 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: 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
Craft Breww City 3 other
a source's own spelling of the licence name (record_title.py)
12 & ORCHARD HOLDINGS, LLC mi-lcc (legal name) ×2
CRAFT BREW CITY inspections
craft breww city farmington hills doordash
Street
27843 Orchard Lake Rd 1 other
mi-lcc
27843 Orchard Lake Road doordash
City
Farmington Hills 1 other
mi-lcc
FARMINGTON ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48334
mi-lccno other value
Pin
42.50028, -83.35969 map 3 other
doordash
74 m away mi-lcc ×2
83 m away ab-inbev
88 m away inspections
Phone
2484885555
vtinfono other value
Licences
mi-lcc L-000454044 · mi-lcc L-000454045
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc1eabcc25ee3; O55f462327473; O77fc68b7a392; Ocaa1d1d0f438; O8677f47b7b21; O3b097b653faf

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-inbevCRAFT BREWW CITY
3746701
27843 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.49993, -83.358802026-11-112026-11-20
doordashcraft breww city farmington hills
26027078
27843 Orchard Lake Road, Farmington Hills, MI, 4833442.50028, -83.359692026-10-082026-11-20
inspectionsCRAFT BREW CITY
inspections|mi|SFE-4063-266098
27843 ORCHARD LAKE RD, Farmington Hills, MI, 4833442.49958, -83.359192026-11-202026-11-20
mi-lccCRAFT BREWW CITY
legal name: 12 & ORCHARD HOLDINGS, LLC
L-000454044
27843 Orchard Lake Rd, Farmington Hills, MI, 4833442.50038, -83.358802026-11-032026-11-20
mi-lccCRAFT BREWW CITY
legal name: 12 & ORCHARD HOLDINGS, LLC
L-000454045
27843 Orchard Lake Rd, Farmington Hills, MI, 4833442.50038, -83.358802026-11-032026-11-20
overtureCraft Breww City
819d8c4c-cd62-42aa-ba1b-fee96b5dad65
27843 Orchard Lake Rd, Farmington Hills, MI, 48334248488555542.50029, -83.359762026-11-062026-11-20
vtinfoCRAFT BREWW CITY
2231cc172e3e9d33
27843 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248488555542.50028, -83.359682026-11-122026-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 CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 88 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 82 m apart · name similarity 1.00
doordash craft breww city farmington hillsmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 74 m apart · name similarity 1.00
doordash craft breww city farmington hillsmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 74 m apart · name similarity 1.00
doordash craft breww city farmington hillsoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
overture Craft Breww Cityvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal
ab-inbev CRAFT BREWW CITYdoordash craft breww city farmington hills0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 83 m apart · name similarity 0.80
doordash craft breww city farmington hillsvtinfo CRAFT BREWW CITY0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 0 m apart · name similarity 0.80
ab-inbev CRAFT BREWW CITYinspections CRAFT BREW CITY0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 50 m apart · name similarity 0.73
doordash craft breww city farmington hillsinspections CRAFT BREW CITY0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 88 m apart · name similarity 0.73
inspections CRAFT BREW CITYmi-lcc CRAFT BREWW CITY0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 95 m apart · name similarity 0.73
inspections CRAFT BREW CITYmi-lcc CRAFT BREWW CITY0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 95 m apart · name similarity 0.73
inspections CRAFT BREW CITYoverture Craft Breww City0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 92 m apart · name similarity 0.73
inspections CRAFT BREW CITYvtinfo CRAFT BREWW CITY0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 88 m apart · name similarity 0.73

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
12 & ORCHARD HOLDINGS, 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:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "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-4063-266098 ↔ mi-lcc L-000454044same address and namemerged17
2026-11-20 22:08insertab-inbev 3746701 ↔ inspections inspections|mi|SFE-4063-266098same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-266098 ↔ mi-lcc L-000454045same address and namemerged17
2026-11-20 22:08insertdoordash 26027078 ↔ inspections inspections|mi|SFE-4063-266098same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-266098 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-266098 ↔ vtinfo 2231cc172e3e9d33same address and namemerged17
2026-11-14 20:23insertdoordash 26027078 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000454044 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000454045 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertoverture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-12 14:25insertab-inbev 3746701 ↔ vtinfo 2231cc172e3e9d33same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ doordash 26027078same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ mi-lcc L-000454045same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ mi-lcc L-000454044same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ mi-lcc L-000454045same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ mi-lcc L-000454044same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000454045 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000454044 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000454044 ↔ mi-lcc L-000454045one store listed twicemerged