Subway

Harper Woods, MI 48225 · O8744f822fe07 · first seen 2026-10-08
3 sourceson premise · restaurantchain: Subwayalcohol: no alcohol food

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
Subway 1 other
the most common name a source states
subway harper woods doordash
Street
20710 Harper Ave 1 other
ubereats
20710 Harper Avenue doordash
City
Harper Woods
ubereatsno other value
State
MI
ubereatsno other value
ZIP
48225
ubereatsno other value
Pin
42.44636, -82.91626 map
ubereatsno other value
Phone
3138865886
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc2d0376c867f; O9167c10a5146

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
doordashsubway harper woods
382171
20710 Harper Avenue, Harper Woods, MI, 4822542.44637, -82.916282026-10-082026-11-19
overtureSubway
3e1dbdfe-f2ce-40c8-9b9d-7e93c32f7494
20710 Harper Ave, Harper Woods, MI, 48225313886588642.44638, -82.916372026-11-152026-11-15
ubereatsSubway
RfxcDnoUQfeOaI7-HDPI4A
20710 Harper Ave, Harper Woods, MI, 4822542.44636, -82.916262026-11-172026-11-17

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 subway harper woodsoverture Subway1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
doordash subway harper woodsubereats Subway1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
overture Subwayubereats Subway1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Subway — ubereats-parent
Alcohol
no_alcohol_food — Subway: licensed at 9 of 9291 outlets in licence states
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
72 within 1 mi · 559 within 3 mi
Off / on premise
20 / 37 within 1 mi · 177 / 266 within 3 mi
Selling alcohol
43 within 1 mi · 298 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
urban (4,968 people per sq mi)
People within 3 mi
140,457 (102,951 adults 21+, 56,923 households) from 44 tract(s), tracts within 3 mi
Income
per capita $38,983 · median household ~$75,988 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 31%
Ethnicity
Hispanic 2% · White 48% · Black 45% · Asian 1%
Adults per alcohol outlet
345
Alcohol spend within 3 mi
$34,554,934 a year ($16,170,218 at home, $18,368,884 away) · $115,956 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-17 17:19insertdoordash 382171 ↔ ubereats RfxcDnoUQfeOaI7-HDPI4Asame address and namemerged15
2026-11-17 17:19insertoverture 3e1dbdfe-f2ce-40c8-9b9d-7e93c32f7494 ↔ ubereats RfxcDnoUQfeOaI7-HDPI4Asame address and namemerged15
2026-11-15 17:57insertdoordash 382171 ↔ overture 3e1dbdfe-f2ce-40c8-9b9d-7e93c32f7494same address and namemerged15