Tubby's Sub Shop

Detroit, MI 48227 · O32f29ce9bbdd · first seen 2026-10-08
3 sourceson premise · restaurantchain: Tubby's Sub Shopsalcohol: unknown

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
Tubby's Sub Shop 1 other
the most common name a source states
tubby's sub shop detroit doordash
Street
16543 Grand River Avenue 1 other
doordash
16543 GRAND RIVER AVE inspectionsoverture ×2
City
Detroit
doordashno other value
State
MI
doordashno other value
ZIP
48227
doordashno other value
Pin
42.39697, -83.20950 map
doordashno other value
Phone
3138377566
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od887f5de192d; Oabbc663663b2

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
doordashtubby's sub shop detroit
214966
16543 Grand River Avenue, Detroit, MI, 4822742.39697, -83.209502026-10-082026-11-20
inspectionsTubby's Sub Shop
inspections|detroit|51625237
16543 GRAND RIVER AVE, Detroit, MI, 4822742.39694, -83.209542026-11-202026-11-20
overtureTubby's Sub Shop
cd56d49b-9233-4a19-a257-57087a179641
16543 Grand River Ave, Detroit, MI, 48227313837756642.39705, -83.209482026-11-152026-11-20

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 tubby's sub shop detroitinspections Tubby's Sub Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash tubby's sub shop detroitoverture Tubby's Sub Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
inspections Tubby's Sub Shopoverture Tubby's Sub Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Tubby's Sub Shops — overture-brand
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-20 22:08insertdoordash 214966 ↔ inspections inspections|detroit|51625237same address and namemerged17
2026-11-20 22:08insertinspections inspections|detroit|51625237 ↔ overture cd56d49b-9233-4a19-a257-57087a179641same address and namemerged17
2026-11-15 17:57insertdoordash 214966 ↔ overture cd56d49b-9233-4a19-a257-57087a179641same address and namemerged15