MC Avans

SYRACUSE, NY 13204 · O278c8fd8eeaf · first seen 2026-11-02
5 sourceson premise · baralcohol: 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
MC Avans 2 other
a licence name in capitals, cleaned (derived; record_title.py)
McAvan's Pub inspectionsoverture ×2
MCAVANS PUB ny-sla
Street
1217 W FAYETTE ST 1 other
ny-sla
1217 WEST Fayette STREET inspections
City
SYRACUSE
ny-slano other value
State
NY
ny-slano other value
ZIP
13204
ny-slano other value
Pin
43.04711, -76.17652 map 1 other
overture
65 m away inspections
Phone
3154231583
vtinfono other value
Licences
ny-sla 0370-23-231846
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oed549d913bfd; Of2923f7ce614; O79ead5ed0b02; Ob0f33b126472

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-inbevMC AVANS
2630323
1217 W FAYETTE ST, SYRACUSE, NY, 1320443.04726, -76.176922026-11-112026-11-11
inspectionsMcAvan's Pub
inspections|nys|292585
1217 WEST Fayette STREET, Syracuse, NY, 1320443.04682, -76.175822026-11-192026-11-19
ny-slaMCAVANS PUB
0370-23-231846
1217 W FAYETTE ST, SYRACUSE, NY, 1320443.04717, -76.176482026-11-022026-11-16
overtureMcAvan's Pub
c24a9a28-ab33-4e9f-a540-4f03e8142bba
1217 W Fayette St, Syracuse, NY, 13204315423158343.04711, -76.176522026-11-062026-11-16
vtinfoMC AVANS
f10d095fa462691e
1217 W FAYETTE ST, SYRACUSE, NY, 13204315423158343.04697, -76.176582026-11-122026-11-14

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 MC AVANSvtinfo MC AVANS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 42 m apart · name similarity 1.00
inspections McAvan's Pubny-sla MCAVANS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00
inspections McAvan's Puboverture McAvan's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ny-sla MCAVANS PUBoverture McAvan's Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev MC AVANSny-sla MCAVANS PUB0.32one name contains the other, same addressmergedjudge: None · pair_id: f876b28e3719d30474f1 · person: None · rule: names contained at one address · stratum: same-address
ny-sla MCAVANS PUBvtinfo MC AVANS0.32one name contains the other, same addressmergedjudge: None · pair_id: 11f403c7a0d9fa026c36 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
75 within 1 mi · 768 within 3 mi
Off / on premise
18 / 31 within 1 mi · 159 / 315 within 3 mi
Selling alcohol
56 within 1 mi · 499 within 3 mi
Nearest
same channel 0.28 mi · licensed 0.09 mi
Setting
urban (4,194 people per sq mi)
People within 3 mi
118,588 (81,275 adults 21+, 49,045 households) from 46 tract(s), tracts within 3 mi
Income
per capita $29,088 · median household ~$52,791 (weighted mean of tract medians)
Age and education
median age ~33.5 · bachelor's or higher 30%
Ethnicity
Hispanic 10% · White 52% · Black 26% · Asian 7%
Adults per alcohol outlet
163
Alcohol spend within 3 mi
$24,067,007 a year ($11,656,013 at home, $12,396,998 away) · $48,134 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-19 20:37insertinspections inspections|nys|292585 ↔ overture c24a9a28-ab33-4e9f-a540-4f03e8142bbasame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|292585 ↔ ny-sla 0370-23-231846same address and namemerged17
2026-11-16 14:56insertny-sla 0370-23-231846 ↔ vtinfo f10d095fa462691eone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2630323 ↔ ny-sla 0370-23-231846one name contains the other, same addressmerged15
2026-11-12 14:25insertab-inbev 2630323 ↔ vtinfo f10d095fa462691esame address and namemerged12
2026-11-06 18:13insertny-sla 0370-23-231846 ↔ overture c24a9a28-ab33-4e9f-a540-4f03e8142bbasame address and namemerged11