Subway Troy Walmart

Troy, AL 36081 · O07363a3a1445 · 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 Troy Walmart 2 other
the most common name a source states
Subway overture
subway troy doordash
Street
1420 Highway 231 S 2 other
ubereats
1420 U.S. 231 doordash
1420 US 231 South overture
City
Troy
ubereatsno other value
State
AL
ubereatsno other value
ZIP
36081
ubereatsno other value
Pin
31.78081, -85.93940 map 2 other
ubereats
63 m away doordash
77 m away overture
Phone
3346706399
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofb39e2eb6720; O9e9ee5ce572f; O3e4f8b125992

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 troy
652714
1420 U.S. 231, Troy, AL, 3608131.78039, -85.938962026-10-082026-11-03
overtureSubway
11b17779-644d-46f1-a6c5-6a3d1a313d8b
1420 US 231 South, Troy, AL, 36081334670639931.78026, -85.938902026-11-182026-11-18
ubereatsSubway Troy Walmart
bSdqkO7yR_6vii3uOsPCpA
1420 Highway 231 S, Troy, AL, 3608131.78081, -85.939402026-10-272026-11-03
ubereatsSubway Troy Walmart
EfcTN9PfTM-hVpvm1kSuaA
1420 Highway 231 S, Troy, AL, 3608131.78081, -85.939402026-10-272026-11-03

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 troyoverture Subway1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 15 m apart · name similarity 1.00 · street similarity 0.88
ubereats Subway Troy Walmartubereats Subway Troy Walmart1.00one store listed twicemergedsame street + ZIP · name: identical
doordash subway troyubereats Subway Troy Walmart0.70Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
Both records are the Subway at 1420 US 231 / Highway 231 S in Troy (the Walmart location), 63 m apart, with only one business recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Subway in Troy, AL at 1420 Highway 231 (U.S. 231) with coordinates 63 m apart and the same ZIP, and the address matches with only one business at that address; the 'Walmart' suffix on B is a host store location, not a separate liquor outlet, and neither listing is a spirits store, so the Alabama rule does not split them.
  • Claude Haiku 5.5, prompt v4: same, 92% confident — Both records are a Subway in Troy, AL at the same street address (1420 US 231 / Highway 231 S, ZIP 36081), with coordinates 63 m apart and no other business at that address; 'Subway Troy Walmart' is the same Subway store listed with its host store name.
pair 66b91525f896d882930c
doordash subway troyubereats Subway Troy Walmart0.70Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
Both records are the Subway at 1420 US-231 / Highway 231 S in Troy, AL 36081, the same road written two ways, 63 m apart, and only one business is listed at that address; the Walmart label just says w
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are Subway at the same street address in Troy, AL (1420 U.S. 231 / 1420 Highway 231 S, about 63 m apart, one business at the address), and neither is a spirits or liquor listing, so the Alabama rule does not split them.
  • Claude Haiku 5.5, prompt v4: same, 92% confident — Both records are Subway Troy at the same address (1420 US 231 / Highway 231 S, Troy AL 36081), with coordinates 63 m apart and no competing business at the address, so the Walmart-labelled Uber Eats listing is the same Subway outlet as the DoorDash slug.
pair 273664e746539cb61a9b

Attributes

Channel
on_premise · restaurant — doordash-url
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:32.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
46 within 1 mi · 91 within 3 mi
Off / on premise
8 / 29 within 1 mi · 20 / 61 within 3 mi
Selling alcohol
11 within 1 mi · 19 within 3 mi
Nearest
same channel 0.16 mi · licensed none within 3 mi
Setting
rural (443 people per sq mi)
People within 3 mi
12,535 (8,002 adults 21+, 4,412 households) from 4 tract(s), tracts within 3 mi
Income
per capita $22,757 · median household ~$48,288 (weighted mean of tract medians)
Age and education
median age ~27.7 · bachelor's or higher 39%
Ethnicity
Hispanic 2% · White 58% · Black 34% · Asian 3%
Adults per alcohol outlet
421
Alcohol spend within 3 mi
$1,960,963 a year ($966,684 at home, $993,174 away) · $103,209 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-18 18:58insertdoordash 652714 ↔ overture 11b17779-644d-46f1-a6c5-6a3d1a313d8bstreet written two waysmerged15
2026-11-02 23:02backfilldoordash 652714 ↔ ubereats bSdqkO7yR_6vii3uOsPCpAClaude judge: samemerged
2026-11-02 23:02backfilldoordash 652714 ↔ ubereats EfcTN9PfTM-hVpvm1kSuaAClaude judge: samemerged
2026-10-27 01:03backfillubereats EfcTN9PfTM-hVpvm1kSuaA ↔ ubereats bSdqkO7yR_6vii3uOsPCpAone store listed twicemerged