GRANITE CITY FOOD & BREWERY

Troy, MI 48084 · O000d660a2651 · 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
GRANITE CITY FOOD & BREWERY 1 other
the most common name a source states
granite city troy doordash
Street
699 W Big Beaver Rd 1 other
mi-lcc
699 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.56164, -83.16123 map
doordashno other value
Phone
6122503564 2 other
vtinfo
9522941300 mi-lcc ×3
2485191040 overture
Licences
mi-lcc L-000435060 · mi-lcc L-000435061 · mi-lcc L-000435062
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa16476522f44; Oac40e67ca446; Od2fe640d98ca; O645b0e655808; Ocdea0b19bb83; Oac1e24c5bc8a

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-inbevGRANITE CITY FOOD & BREWERY
3433177
699 W BIG BEAVER RD, TROY, MI, 4808442.56184, -83.161072026-11-112026-11-11
doordashgranite city troy
897563
699 West Big Beaver Road, Troy, MI, 4808442.56164, -83.161232026-10-082026-11-12
mi-lccGRANITE CITY FOOD & BREWERY
L-000435060
699 W Big Beaver Rd, Troy, MI, 48084952294130042.56185, -83.161472026-11-032026-11-11
mi-lccGRANITE CITY FOOD & BREWERY
L-000435061
699 W Big Beaver Rd, Troy, MI, 48084952294130042.56185, -83.161472026-11-032026-11-11
mi-lccGRANITE CITY FOOD & BREWERY
L-000435062
699 W Big Beaver Rd, Troy, MI, 48084952294130042.56185, -83.161472026-11-032026-11-11
overtureGranite City Food & Brewery
87980282-b7df-48c2-b632-c91add1a1464
699 W Big Beaver Rd, Troy, MI, 48084248519104042.56149, -83.161252026-11-062026-11-11
vtinfoGRANITE CITY FOOD & BREWERY
2b21e64b8438cab7
699 W BIG BEAVER RD, TROY, MI, 48084612250356442.56153, -83.161102026-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
ab-inbev GRANITE CITY FOOD & BREWERYmi-lcc GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev GRANITE CITY FOOD & BREWERYmi-lcc GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev GRANITE CITY FOOD & BREWERYmi-lcc GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev GRANITE CITY FOOD & BREWERYoverture Granite City Food & Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00
ab-inbev GRANITE CITY FOOD & BREWERYvtinfo GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
mi-lcc GRANITE CITY FOOD & BREWERYmi-lcc GRANITE CITY FOOD & BREWERY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GRANITE CITY FOOD & BREWERYmi-lcc GRANITE CITY FOOD & BREWERY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GRANITE CITY FOOD & BREWERYoverture Granite City Food & Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00 · phone: differs
mi-lcc GRANITE CITY FOOD & BREWERYvtinfo GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00 · phone: differs
mi-lcc GRANITE CITY FOOD & BREWERYoverture Granite City Food & Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00 · phone: differs
mi-lcc GRANITE CITY FOOD & BREWERYvtinfo GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00 · phone: differs
mi-lcc GRANITE CITY FOOD & BREWERYoverture Granite City Food & Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00 · phone: differs
mi-lcc GRANITE CITY FOOD & BREWERYvtinfo GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00 · phone: differs
overture Granite City Food & Breweryvtinfo GRANITE CITY FOOD & BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00 · phone: differs
ab-inbev GRANITE CITY FOOD & BREWERYdoordash granite city troy0.57Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “near” pair)
Both records give the same street address (699 W Big Beaver Rd, Troy 48084) and the same restaurant name (DoorDash slug 'granite city troy' is Granite City with the city appended), with only one busin
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Granite City at identical address.
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records sit at 699 West Big Beaver Road, Troy, MI 48084 with coordinates about 25 m apart, and the names match as Granite City restaurant, with no other business at that address and no conflicting suite numbers.
pair 056cc9d0f36e58137b0d

Attributes

Channel
on_premise · restaurant — doordash-url
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/Brew Pub; MI Retail - On Premises/Class C
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
85 within 1 mi · 637 within 3 mi
Off / on premise
6 / 64 within 1 mi · 144 / 381 within 3 mi
Selling alcohol
48 within 1 mi · 318 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.05 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
207
Alcohol spend within 3 mi
$30,894,617 a year ($13,605,636 at home, $17,277,284 away) · $96,848 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:25insertab-inbev 3433177 ↔ doordash 897563Claude judge: samemerged12
2026-11-12 14:25insertmi-lcc L-000435060 ↔ vtinfo 2b21e64b8438cab7same address and namemerged12
2026-11-12 14:25insertoverture 87980282-b7df-48c2-b632-c91add1a1464 ↔ vtinfo 2b21e64b8438cab7same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000435061 ↔ vtinfo 2b21e64b8438cab7same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000435062 ↔ vtinfo 2b21e64b8438cab7same address and namemerged12
2026-11-12 14:25insertab-inbev 3433177 ↔ vtinfo 2b21e64b8438cab7same address and namemerged12
2026-11-11 12:56insertab-inbev 3433177 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464same address and namemerged12
2026-11-11 12:56insertab-inbev 3433177 ↔ mi-lcc L-000435061same address and namemerged12
2026-11-11 12:56insertab-inbev 3433177 ↔ mi-lcc L-000435062same address and namemerged12
2026-11-11 12:56insertab-inbev 3433177 ↔ mi-lcc L-000435060same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000435061 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000435062 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000435060 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000435060 ↔ mi-lcc L-000435062one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000435060 ↔ mi-lcc L-000435061one store listed twicemerged