Frankie's Cheesesteaks & Hoagies

Tucson, AZ 85741 · O377bb78b84a3 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: alcohol

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
Frankie's Cheesesteaks & Hoagies 3 other
a licence name in capitals, cleaned (derived; record_title.py)
frankie's south philadelphia cheesesteak tucson doordash
Frankie's South Philly Cheesesteaks overture
FRANKIES CHEESESTEAKS & HOAGIES ab-inbev
Street
3780 West Ina Road 2 other
doordash
3780 W Ina Rd overture
3780 W INA RD #184 ab-inbev
City
Tucson
doordashno other value
State
AZ
doordashno other value
ZIP
85741
doordashno other value
Pin
32.33904, -111.04640 map 1 other
doordash
391 m away ab-inbev
Phone
5209897557
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9df0c7dd19be; Oa7fdb0131553

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-inbevFRANKIES CHEESESTEAKS & HOAGIES
4387724
3780 W INA RD #184, TUCSON, AZ, 8574132.34172, -111.043702026-11-132026-11-14
doordashfrankie's south philadelphia cheesesteak tucson
1152118
3780 West Ina Road, Tucson, AZ, 8574132.33904, -111.046402026-10-082026-11-18
overtureFrankie's South Philly Cheesesteaks
be6f66ed-b98b-42da-b074-2a7c1f72b9b2
3780 W Ina Rd, Tucson, AZ, 85741520989755732.33895, -111.046442026-11-132026-11-13

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 FRANKIES CHEESESTEAKS & HOAGIESoverture Frankie's South Philly Cheesesteaks0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 56 m apart · name similarity 0.58
ab-inbev FRANKIES CHEESESTEAKS & HOAGIESdoordash frankie's south philadelphia cheesesteak tucson0.42Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Frankie's cheesesteak at same street address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records give the same street address and ZIP in Tucson, and the names are closely matched cheesesteak shops (Frankies Cheesesteaks & Hoagies vs Frankie's South Philadelphia Cheesesteak), though the building holds three businesses and only one record names a suite, so the match rests on the name.
pair 7a4998aff47e64ea1ef3

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
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
73 within 1 mi · 212 within 3 mi
Off / on premise
19 / 47 within 1 mi · 49 / 133 within 3 mi
Selling alcohol
31 within 1 mi · 82 within 3 mi
Nearest
same channel 0.00 mi · licensed 1.29 mi
Setting
suburban (2,165 people per sq mi)
People within 3 mi
61,215 (46,188 adults 21+, 25,110 households) from 15 tract(s), tracts within 3 mi
Income
per capita $40,609 · median household ~$80,565 (weighted mean of tract medians)
Age and education
median age ~38.6 · bachelor's or higher 34%
Ethnicity
Hispanic 30% · White 65% · Black 2% · Asian 4%
Adults per alcohol outlet
556
Alcohol spend within 3 mi
$15,953,125 a year ($7,427,519 at home, $8,518,716 away) · $192,206 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:58insertab-inbev 4387724 ↔ doordash 1152118Claude judge: samemerged15
2026-11-13 19:03insertab-inbev 4387724 ↔ overture be6f66ed-b98b-42da-b074-2a7c1f72b9b2same address and namemerged15