Grand Tavern

Farmington Hills, MI 48335 · O0c3463675a96 · 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
Grand Tavern 2 other
a source's own spelling of the licence name (record_title.py)
Grand Tavern - Farmington overture
grand tavern farmington hills doordash
Street
35450 Grand River Ave 2 other
mi-lcc
35450 GRANDRIVER HWY ab-inbevvtinfo ×2
35450 Grand River Avenue doordash
City
Farmington Hills 1 other
mi-lcc
FARMINGTON ab-inbevubereatsvtinfo ×3
State
MI
mi-lccno other value
ZIP
48335
mi-lccno other value
Pin
42.47017, -83.39685 map 2 other
ubereats
116 m away mi-lcc ×2
85 m away ab-inbev
Phone
2484765700
vtinfono other value
Licences
mi-lcc L-000174949 · mi-lcc L-000174950
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of26b00623869; Oa8cfd863ad74; Od0ba22e475ea; O63e0899d893c; O44da8538ae8d; O1ce7f48d6215

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-inbevGRAND TAVERN
2983002
35450 GRANDRIVER HWY, FARMINGTON, MI, 4833542.46941, -83.396912026-11-112026-11-13
doordashgrand tavern farmington hills
205908
35450 Grand River Avenue, Farmington Hills, MI, 4833542.47013, -83.396902026-10-082026-11-13
mi-lccGRAND TAVERN
L-000174949
35450 Grand River Ave, Farmington Hills, MI, 48335248476570042.46913, -83.396922026-11-032026-11-13
mi-lccGRAND TAVERN
L-000174950
35450 Grand River Ave, Farmington Hills, MI, 48335248476570042.46913, -83.396922026-11-032026-11-13
overtureGrand Tavern - Farmington
7aeff82d-fd75-4022-8c96-9d81c4efe49c
35450 Grand River Ave, Farmington Hills, MI, 48335248476570042.47014, -83.396812026-11-062026-11-13
ubereatsGrand Tavern
TKbfZSo_VVyWEQ8jjEBtcQ
35450 Grand River Ave, Farmington, MI, 4833542.47017, -83.396852026-10-202026-11-13
vtinfoGRAND TAVERN
360b1814caf979fe
35450 GRANDRIVER HWY, FARMINGTON, MI, 48335248476570042.47011, -83.396992026-11-132026-11-14

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 GRAND TAVERNmi-lcc GRAND TAVERN1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name, same street number, Grand River.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name GRAND TAVERN at the same street address (35450 Grand River) and ZIP 48335, with coordinates about 31 m apart and no competing businesses at the address, so they describe one outlet despite the city-name difference (Farmington vs Farmington Hills, same ZIP).
pair 4228b7a956d1839fbf8d
ab-inbev GRAND TAVERNubereats Grand Tavern1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Grand Tavern same address, spelling variant.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Grand Tavern at 35450 Grand River in Farmington, MI 48335, with coordinates about 85 m apart and no other business at that address, so this is one operation at one premises.
pair 2052dc474aff4ac6a4e0
ab-inbev GRAND TAVERNvtinfo GRAND TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 79 m apart · name similarity 1.00
doordash grand tavern farmington hillsmi-lcc GRAND TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash grand tavern farmington hillsmi-lcc GRAND TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GRAND TAVERNmi-lcc GRAND TAVERN1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GRAND TAVERNubereats Grand Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GRAND TAVERNubereats Grand Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash grand tavern farmington hillsoverture Grand Tavern - Farmington0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 7 m apart · name similarity 0.82
doordash grand tavern farmington hillsubereats Grand Tavern0.73Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The name 'Grand Tavern' matches once DoorDash's appended city is dropped, and both records give the same street address and ZIP, 6 m apart, with only one business known at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records name Grand Tavern at 35450 Grand River Ave, ZIP 48335, with coordinates about 6 meters apart and no other business at that address, so they are one storefront listed on two delivery apps; the city difference (Farmington Hills vs Farmington) is the same postal area.
pair c3a9de4e06658ec9ba83

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 315 within 3 mi
Off / on premise
11 / 17 within 1 mi · 67 / 181 within 3 mi
Selling alcohol
19 within 1 mi · 158 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.05 mi
Setting
suburban (2,538 people per sq mi)
People within 3 mi
71,757 (56,222 adults 21+, 31,374 households) from 20 tract(s), tracts within 3 mi
Income
per capita $57,890 · median household ~$108,352 (weighted mean of tract medians)
Age and education
median age ~44.1 · bachelor's or higher 60%
Ethnicity
Hispanic 3% · White 59% · Black 14% · Asian 18%
Adults per alcohol outlet
354
Alcohol spend within 3 mi
$24,994,026 a year ($11,119,482 at home, $13,863,803 away) · $157,195 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-13 14:10insertab-inbev 2983002 ↔ vtinfo 360b1814caf979fesame address and namemerged15
2026-11-12 17:29insertab-inbev 2983002 ↔ mi-lcc L-000174950Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2983002 ↔ ubereats TKbfZSo_VVyWEQ8jjEBtcQClaude judge: samemerged14
2026-11-06 18:13insertdoordash 205908 ↔ overture 7aeff82d-fd75-4022-8c96-9d81c4efe49csame address and namemerged11
2026-11-03 13:33backfilldoordash 205908 ↔ mi-lcc L-000174950same address and namemerged
2026-11-03 13:33backfilldoordash 205908 ↔ mi-lcc L-000174949same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000174950 ↔ ubereats TKbfZSo_VVyWEQ8jjEBtcQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000174949 ↔ ubereats TKbfZSo_VVyWEQ8jjEBtcQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000174949 ↔ mi-lcc L-000174950one store listed twicemerged
2026-11-02 23:02backfilldoordash 205908 ↔ ubereats TKbfZSo_VVyWEQ8jjEBtcQClaude judge: samemerged