Red Robin Gourmet Burgers & Spirits

Ypsilanti, MI 48197 · O38f17b0fdd79 · first seen 2026-10-08
5 sourceson premise · restaurantchain: Red Robin Gourmet Burgersalcohol: licensed1 licence

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
Red Robin Gourmet Burgers & Spirits 4 other
a licence name in capitals, cleaned (derived; record_title.py)
PITTSFIELD ROBIN, INC. mi-lcc (legal name)
Red Robin Gourmet Burgers overture
red robin gourmet burgers and brews ypsilanti doordash
RED ROBIN HAMBURGER & SPIRITS EMPORIUM mi-lcc
Street
3797 Carpenter Rd 1 other
mi-lcc
3797 Carpenter Road doordash
City
Ypsilanti
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48197
mi-lccno other value
Pin
42.23565, -83.67971 map 2 other
doordash
145 m away ab-inbev
116 m away mi-lcc
Phone
7347942000
vtinfono other value
Licences
mi-lcc L-000107422
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O74972c76f189; O39619e695e00; Oe0a55d2e3ccf; O5621e44dcdef

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-inbevRED ROBIN GOURMET BURGERS & SPIRITS
92441
3797 CARPENTER RD, YPSILANTI, MI, 4819742.23691, -83.680182026-11-112026-11-11
doordashred robin gourmet burgers and brews ypsilanti
802710
3797 Carpenter Road, Ypsilanti, MI, 4819742.23565, -83.679712026-10-082026-11-11
mi-lccRED ROBIN HAMBURGER & SPIRITS EMPORIUM
legal name: PITTSFIELD ROBIN, INC.
L-000107422
3797 Carpenter Rd, Ypsilanti, MI, 48197734794200042.23465, -83.680092026-11-032026-11-12
overtureRed Robin Gourmet Burgers
91f4f709-cf85-4938-b495-7c928dacb10f
3797 Carpenter Rd, Ypsilanti, MI, 48197734794200042.23564, -83.679682026-11-062026-11-11
vtinfoRED ROBIN GOURMET BURGERS & SPIRITS
3efd764d087e99b4
3797 CARPENTER RD, YPSILANTI, MI, 48197734794200042.23559, -83.679562026-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 RED ROBIN GOURMET BURGERS & SPIRITSvtinfo RED ROBIN GOURMET BURGERS & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 156 m apart · name similarity 1.00
doordash red robin gourmet burgers and brews ypsilantioverture Red Robin Gourmet Burgers0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 2 m apart · name similarity 0.85
ab-inbev RED ROBIN GOURMET BURGERS & SPIRITSoverture Red Robin Gourmet Burgers0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 147 m apart · name similarity 0.83
overture Red Robin Gourmet Burgersvtinfo RED ROBIN GOURMET BURGERS & SPIRITS0.83same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 11 m apart · name similarity 0.83 · phone: equal
ab-inbev RED ROBIN GOURMET BURGERS & SPIRITSdoordash red robin gourmet burgers and brews ypsilanti0.72same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: spirits · name Jaro-Winkler 0.81 · same street + ZIP · pins 145 m apart · name similarity 0.72
doordash red robin gourmet burgers and brews ypsilantivtinfo RED ROBIN GOURMET BURGERS & SPIRITS0.72same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: spirits · name Jaro-Winkler 0.81 · same street + city + state · pins 14 m apart · name similarity 0.72
ab-inbev RED ROBIN GOURMET BURGERS & SPIRITSmi-lcc RED ROBIN HAMBURGER & SPIRITS EMPORIUM0.56Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Red Robin same address, name variants
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 3797 Carpenter Rd, Ypsilanti, MI 48197 with nearly identical coordinates, and the names are the same Red Robin restaurant brand with a spirits-themed name (Gourmet Burgers & Spirits vs Hamburger & Spirits Emporium); the MI-LCC record's legal entity PITTSFIELD ROBIN is consistent with a Red Robin franchisee, and the only building at that address is this one outlet.
pair 101a1664e3cf43f0ab3a
doordash red robin gourmet burgers and brews ypsilantimi-lcc RED ROBIN HAMBURGER & SPIRITS EMPORIUM0.40Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Red Robin same address, licence entity name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 3797 Carpenter Road, Ypsilanti, MI 48197 (about 0.12 km apart) and carry the Red Robin name, with B's legal entity PITTSFIELD ROBIN, INC. operating the trade name; the only business at that address is Red Robin, so the DoorDash listing and the Michigan liquor licence point to one restaurant.
pair 307724f5f26d3dafa531

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Red Robin Gourmet Burgers — name-prefix
Alcohol
licensed — a licence or TTB permit on file
Operator
PITTSFIELD ROBIN, INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
48 within 1 mi · 324 within 3 mi
Off / on premise
13 / 29 within 1 mi · 88 / 181 within 3 mi
Selling alcohol
22 within 1 mi · 129 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.04 mi
Setting
suburban (2,420 people per sq mi)
People within 3 mi
68,431 (51,254 adults 21+, 30,778 households) from 21 tract(s), tracts within 3 mi
Income
per capita $48,764 · median household ~$83,272 (weighted mean of tract medians)
Age and education
median age ~34.6 · bachelor's or higher 61%
Ethnicity
Hispanic 8% · White 59% · Black 18% · Asian 11%
Adults per alcohol outlet
394
Alcohol spend within 3 mi
$20,039,589 a year ($9,208,293 at home, $10,823,777 away) · $154,151 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:10insertdoordash 802710 ↔ vtinfo 3efd764d087e99b4same address and namemerged15
2026-11-13 14:10insertoverture 91f4f709-cf85-4938-b495-7c928dacb10f ↔ vtinfo 3efd764d087e99b4same address and namemerged15
2026-11-13 14:10insertab-inbev 92441 ↔ vtinfo 3efd764d087e99b4same address and namemerged15
2026-11-12 17:29insertdoordash 802710 ↔ mi-lcc L-000107422Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 92441 ↔ mi-lcc L-000107422Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 92441 ↔ doordash 802710same address and namemerged14
2026-11-11 12:56insertab-inbev 92441 ↔ overture 91f4f709-cf85-4938-b495-7c928dacb10fsame address and namemerged12
2026-11-06 18:13insertdoordash 802710 ↔ overture 91f4f709-cf85-4938-b495-7c928dacb10fsame address and namemerged11