The Hudson Cafe

TROY, MI 48084 · O0b38f712a5a1 · first seen 2026-10-08
5 sourceson premise · restaurantchain: The Hudson Cafealcohol: 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 Hudson Cafe 2 other
a source's own spelling of the licence name (record_title.py)
THE HUDSON CAFE TROY LLC mi-lcc (legal name) ×2
hudson cafe troy troy doordash
Street
700 W BIG BEAVER RD 1 other
mi-lcc
700 West Big Beaver Road doordash
City
TROY
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48084
mi-lccno other value
Pin
42.56254, -83.16325 map 2 other
ubereats
111 m away mi-lcc ×2
160 m away vtinfo
Phone
2485097695 1 other
vtinfo
3134106400 mi-lcc ×2
Licences
mi-lcc L-000475602 · mi-lcc L-000475603
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obfe52e3d2bf2; O195ee34abf04; Oc000e03c424f; Oaa916986f8e2; O6a98ba111b62

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
doordashhudson cafe troy troy
27803834
700 West Big Beaver Road, Troy, MI, 4808442.56256, -83.163202026-10-082026-11-13
mi-lccTHE HUDSON CAFE
legal name: THE HUDSON CAFE TROY LLC
L-000475602
700 W BIG BEAVER RD, TROY, MI, 48084313410640042.56222, -83.161962026-11-032026-11-05
mi-lccTHE HUDSON CAFE
legal name: THE HUDSON CAFE TROY LLC
L-000475603
700 W BIG BEAVER RD, TROY, MI, 48084313410640042.56222, -83.161962026-11-032026-11-05
overtureThe Hudson Cafe
71ec1640-a14d-4c9d-ace1-c0a845af7a75
700 W Big Beaver Rd, Troy, MI, 48084248509769542.56240, -83.163212026-11-062026-11-06
ubereatsThe Hudson Cafe
cCFF34x0WjCLzT1rTMiWQQ
700 W Big Beaver Rd, Troy, MI, 4808442.56254, -83.163252026-10-252026-10-25
vtinfoTHE HUDSON CAFE
69c1e3df33ffb0c3
700 W BIG BEAVER RD, TROY, MI, 48084248509769542.56273, -83.165192026-11-122026-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
doordash hudson cafe troy troymi-lcc THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 108 m apart · name similarity 1.00
doordash hudson cafe troy troymi-lcc THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 108 m apart · name similarity 1.00
doordash hudson cafe troy troyoverture The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
doordash hudson cafe troy troyubereats The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash hudson cafe troy troyvtinfo THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 164 m apart · name similarity 1.00
mi-lcc THE HUDSON CAFEmi-lcc THE HUDSON CAFE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE HUDSON CAFEoverture The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00 · phone: differs
mi-lcc THE HUDSON CAFEubereats The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc THE HUDSON CAFEvtinfo THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 270 m apart · name similarity 1.00 · phone: differs
mi-lcc THE HUDSON CAFEoverture The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · name similarity 1.00 · phone: differs
mi-lcc THE HUDSON CAFEubereats The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc THE HUDSON CAFEvtinfo THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 270 m apart · name similarity 1.00 · phone: differs
overture The Hudson Cafeubereats The Hudson Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture The Hudson Cafevtinfo THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 166 m apart · name similarity 1.00 · phone: equal
ubereats The Hudson Cafevtinfo THE HUDSON CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 160 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
The Hudson Cafe — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
THE HUDSON CAFE TROY 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 10, computed 2026-11-18 20:34.
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
78 within 1 mi · 639 within 3 mi
Off / on premise
7 / 57 within 1 mi · 142 / 384 within 3 mi
Selling alcohol
44 within 1 mi · 319 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (3,008 people per sq mi)
People within 3 mi
85,047 (65,886 adults 21+, 36,658 households) from 25 tract(s), tracts within 3 mi
Income
per capita $64,528 · median household ~$116,922 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 66%
Ethnicity
Hispanic 3% · White 68% · Black 4% · Asian 20%
Adults per alcohol outlet
206
Alcohol spend within 3 mi
$30,894,617 a year ($13,605,636 at home, $17,277,284 away) · $96,546 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-12 14:25insertubereats cCFF34x0WjCLzT1rTMiWQQ ↔ vtinfo 69c1e3df33ffb0c3same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000475602 ↔ vtinfo 69c1e3df33ffb0c3same address and namemerged12
2026-11-12 14:25insertoverture 71ec1640-a14d-4c9d-ace1-c0a845af7a75 ↔ vtinfo 69c1e3df33ffb0c3same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000475603 ↔ vtinfo 69c1e3df33ffb0c3same address and namemerged12
2026-11-12 14:25insertdoordash 27803834 ↔ ubereats cCFF34x0WjCLzT1rTMiWQQsame address and namemerged12
2026-11-12 14:25insertdoordash 27803834 ↔ mi-lcc L-000475602same address and namemerged12
2026-11-12 14:25insertdoordash 27803834 ↔ overture 71ec1640-a14d-4c9d-ace1-c0a845af7a75same address and namemerged12
2026-11-12 14:25insertdoordash 27803834 ↔ mi-lcc L-000475603same address and namemerged12
2026-11-12 14:25insertdoordash 27803834 ↔ vtinfo 69c1e3df33ffb0c3same address and namemerged12
2026-11-06 18:13insertoverture 71ec1640-a14d-4c9d-ace1-c0a845af7a75 ↔ ubereats cCFF34x0WjCLzT1rTMiWQQsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000475603 ↔ overture 71ec1640-a14d-4c9d-ace1-c0a845af7a75same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000475602 ↔ overture 71ec1640-a14d-4c9d-ace1-c0a845af7a75same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000475603 ↔ ubereats cCFF34x0WjCLzT1rTMiWQQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000475602 ↔ ubereats cCFF34x0WjCLzT1rTMiWQQsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000475602 ↔ mi-lcc L-000475603one store listed twicemerged