Mike's Subs Express Brighton Arena

TONAWANDA, NY 14150 · O3ff99e09c045 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
Mike's Subs Express Brighton Arena 4 other
a licence name in capitals, cleaned (derived; record_title.py)
MIKES SUBS EXPRESS BRIGHTON ARENA ab-inbevvtinfo ×2
BAM Food Services, LLC ny-sla (legal name)
Mike's Subs Express ny-sla
mike's subs tonawanda doordash
Street
251 Brompton Rd
ny-slano other value
City
Tonawanda
ny-slano other value
State
NY
ny-slano other value
ZIP
14150
ny-slano other value
Pin
43.00212, -78.83949 map 1 other
doordash
430 m away vtinfo
Phone
7168776000
vtinfono other value
Licences
ny-sla 0267-24-339755
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of7dce17ade05; Oe4c66a19daed; Ofc9328635234

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-inbevMIKES SUBS EXPRESS BRIGHTON ARENA
4793505
251 BROMPTON RD, TONAWANDA, NY, 1415043.00230, -78.839132026-11-112026-11-12
doordashmike's subs tonawanda
31727229
251 Brompton Rd, Tonawanda, NY, 1415043.00212, -78.839492026-10-082026-11-10
ny-slaMike's Subs Express
legal name: BAM Food Services, LLC
0267-24-339755
251 Brompton Rd, Tonawanda, NY, 1415043.00232, -78.839172026-11-022026-11-12
vtinfoMIKES SUBS EXPRESS BRIGHTON ARENA
8b1f5fac0ca03323
251 BROMPTON RD, TONAWANDA, NY, 14150716877600043.00427, -78.843892026-11-152026-11-15

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 MIKES SUBS EXPRESS BRIGHTON ARENAvtinfo MIKES SUBS EXPRESS BRIGHTON ARENA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 445 m apart · name similarity 1.00
doordash mike's subs tonawandany-sla Mike's Subs Express0.69Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Same address, Mike's Subs name matches.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records sit at 251 Brompton Rd, Tonawanda NY 14150, with the only business at that address in the data, and the names match closely (Mike's Subs Tonawanda on DoorDash vs Mike's Subs Express on the NY SLA licence, with the city appended in the slug), so they are most likely one sub shop.
pair 0dabf56b39de243c364a
ab-inbev MIKES SUBS EXPRESS BRIGHTON ARENAny-sla Mike's Subs Express0.65Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “near” pair)
Same name (Mike's Subs Express, with the arena location appended) at the identical address, and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Same name and address; arena location suffix only.
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 251 Brompton Rd, Tonawanda NY 14150 with coordinates within 4 metres, and the only business at that address is Mike's Subs Express (the AB InBev name adds the arena location, and the NY licence's legal entity BAM Food Services is the operator behind the trade name), so this is one outlet.
pair 0378ace48824aa6f2e6a
ab-inbev MIKES SUBS EXPRESS BRIGHTON ARENAdoordash mike's subs tonawanda0.43Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Mike's Subs at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 55% confident — Both records share the same street address, ZIP and a very close distance, and the names are similar (Mike's Subs), but record A's name 'Mikes Subs Express Brighton Arena' differs from B's slug 'mike's subs tonawanda', and Mike's Subs is a franchise chain, so the records alone do not firmly establish the same outlet.
pair 354ba7e30bb5695cd951

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BAM Food Services, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0267
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
73 within 1 mi · 586 within 3 mi
Off / on premise
21 / 35 within 1 mi · 137 / 317 within 3 mi
Selling alcohol
41 within 1 mi · 336 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.09 mi
Setting
urban (4,203 people per sq mi)
People within 3 mi
118,840 (90,034 adults 21+, 52,687 households) from 28 tract(s), tracts within 3 mi
Income
per capita $39,243 · median household ~$70,781 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 39%
Ethnicity
Hispanic 5% · White 81% · Black 5% · Asian 6%
Adults per alcohol outlet
267
Alcohol spend within 3 mi
$31,326,182 a year ($14,737,620 at home, $16,574,291 away) · $92,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-15 16:24insertab-inbev 4793505 ↔ vtinfo 8b1f5fac0ca03323same address and namemerged15
2026-11-12 17:29insertab-inbev 4793505 ↔ doordash 31727229Claude judge: samemerged14
2026-11-12 17:29insertdoordash 31727229 ↔ ny-sla 0267-24-339755Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4793505 ↔ ny-sla 0267-24-339755Claude judge: samemerged12