Outlets /
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.
| Field | Master value | Taken from | What 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-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48084 | mi-lcc | no other value |
| Pin | 42.56164, -83.16123 map | doordash | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | GRANITE CITY FOOD & BREWERY 3433177 | 699 W BIG BEAVER RD, TROY, MI, 48084 | 42.56184, -83.16107 | 2026-11-11 | 2026-11-11 | |
| doordash | granite city troy 897563 | 699 West Big Beaver Road, Troy, MI, 48084 | 42.56164, -83.16123 | 2026-10-08 | 2026-11-12 | |
| mi-lcc | GRANITE CITY FOOD & BREWERY L-000435060 | 699 W Big Beaver Rd, Troy, MI, 48084 | 9522941300 | 42.56185, -83.16147 | 2026-11-03 | 2026-11-11 |
| mi-lcc | GRANITE CITY FOOD & BREWERY L-000435061 | 699 W Big Beaver Rd, Troy, MI, 48084 | 9522941300 | 42.56185, -83.16147 | 2026-11-03 | 2026-11-11 |
| mi-lcc | GRANITE CITY FOOD & BREWERY L-000435062 | 699 W Big Beaver Rd, Troy, MI, 48084 | 9522941300 | 42.56185, -83.16147 | 2026-11-03 | 2026-11-11 |
| overture | Granite City Food & Brewery 87980282-b7df-48c2-b632-c91add1a1464 | 699 W Big Beaver Rd, Troy, MI, 48084 | 2485191040 | 42.56149, -83.16125 | 2026-11-06 | 2026-11-11 |
| vtinfo | GRANITE CITY FOOD & BREWERY 2b21e64b8438cab7 | 699 W BIG BEAVER RD, TROY, MI, 48084 | 6122503564 | 42.56153, -83.16110 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev GRANITE CITY FOOD & BREWERY | mi-lcc GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ab-inbev GRANITE CITY FOOD & BREWERY | mi-lcc GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ab-inbev GRANITE CITY FOOD & BREWERY | mi-lcc GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ab-inbev GRANITE CITY FOOD & BREWERY | overture Granite City Food & Brewery | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00 |
| ab-inbev GRANITE CITY FOOD & BREWERY | vtinfo GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address 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 & BREWERY | mi-lcc GRANITE CITY FOOD & BREWERY | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc GRANITE CITY FOOD & BREWERY | mi-lcc GRANITE CITY FOOD & BREWERY | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc GRANITE CITY FOOD & BREWERY | overture Granite City Food & Brewery | 1.00 | same address and name | merged | address 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 & BREWERY | vtinfo GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address 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 & BREWERY | overture Granite City Food & Brewery | 1.00 | same address and name | merged | address 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 & BREWERY | vtinfo GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address 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 & BREWERY | overture Granite City Food & Brewery | 1.00 | same address and name | merged | address 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 & BREWERY | vtinfo GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address 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 & Brewery | vtinfo GRANITE CITY FOOD & BREWERY | 1.00 | same address and name | merged | address 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 & BREWERY | doordash granite city troy | 0.57 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ab-inbev 3433177 ↔ doordash 897563 | Claude judge: same | merged | 12 |
| 2026-11-12 14:25 | insert | mi-lcc L-000435060 ↔ vtinfo 2b21e64b8438cab7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture 87980282-b7df-48c2-b632-c91add1a1464 ↔ vtinfo 2b21e64b8438cab7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | mi-lcc L-000435061 ↔ vtinfo 2b21e64b8438cab7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | mi-lcc L-000435062 ↔ vtinfo 2b21e64b8438cab7 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 3433177 ↔ vtinfo 2b21e64b8438cab7 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3433177 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3433177 ↔ mi-lcc L-000435061 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3433177 ↔ mi-lcc L-000435062 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3433177 ↔ mi-lcc L-000435060 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | mi-lcc L-000435061 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000435062 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000435060 ↔ overture 87980282-b7df-48c2-b632-c91add1a1464 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000435060 ↔ mi-lcc L-000435062 | one store listed twice | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000435060 ↔ mi-lcc L-000435061 | one store listed twice | merged |