Mickey's Bar & Restaurant

PALMYRA, NY 14522 · O25c460df5a4e · first seen 2026-11-02
5 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
Mickey's Bar & Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
MICKEY'S RESTAURANT inspectionsoverture ×2
MICKEYS BAR & RESTAURANT ab-inbevvtinfo ×2
MICKEYS BAR & RESTAURANT INC ny-sla (legal name)
MICKEYS RESTAURANT ny-sla
Street
3495 VIENNA ST 1 other
ny-sla
3495 VIENNA STREET inspections
City
PALMYRA
ny-slano other value
State
NY
ny-slano other value
ZIP
14522
ny-slano other value
Pin
43.06023, -77.21325 map
overtureno other value
Phone
3155975131
vtinfono other value
Licences
ny-sla 0267-23-332948
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O5880bb55fd56; O6561129b5abf; O4a4e189f59c2; Ocb0d4f6cfedd

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-inbevMICKEYS BAR & RESTAURANT
2635593
3495 VIENNA ST, PALMYRA, NY, 1452243.06020, -77.213602026-11-112026-11-16
inspectionsMICKEY'S RESTAURANT
inspections|nys|326394
3495 VIENNA STREET, Palmyra, NY, 1452243.06016, -77.213522026-11-192026-11-19
ny-slaMICKEYS RESTAURANT
legal name: MICKEYS BAR & RESTAURANT INC
0267-23-332948
3495 VIENNA ST, PALMYRA, NY, 1452243.06013, -77.213602026-11-022026-11-16
overtureMickey's Restaurant
90f3f537-e1a1-408b-82fc-32d5fcaed504
3495 Vienna St, Palmyra, NY, 14522315597513143.06023, -77.213252026-11-062026-11-16
vtinfoMICKEYS BAR & RESTAURANT
1469edb576d73727
3495 VIENNA ST, PALMYRA, NY, 14522315597513143.06050, -77.213612026-11-162026-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
ab-inbev MICKEYS BAR & RESTAURANTny-sla MICKEYS RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: MICKEYS BAR & RESTAURANT INC · name similarity 1.00
ab-inbev MICKEYS BAR & RESTAURANTvtinfo MICKEYS BAR & RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
inspections MICKEY'S RESTAURANTny-sla MICKEYS RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
inspections MICKEY'S RESTAURANToverture Mickey's Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ny-sla MICKEYS RESTAURANToverture Mickey's Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ny-sla MICKEYS RESTAURANTvtinfo MICKEYS BAR & RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 42 m apart · matched through the licence's legal name: MICKEYS BAR & RESTAURANT INC · name similarity 1.00
ab-inbev MICKEYS BAR & RESTAURANTinspections MICKEY'S RESTAURANT0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.80 · same street + ZIP · pins 8 m apart · name similarity 0.78
ab-inbev MICKEYS BAR & RESTAURANToverture Mickey's Restaurant0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.80 · same street + ZIP · pins 29 m apart · name similarity 0.78
inspections MICKEY'S RESTAURANTvtinfo MICKEYS BAR & RESTAURANT0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.80 · same street + ZIP · pins 38 m apart · name similarity 0.78
overture Mickey's Restaurantvtinfo MICKEYS BAR & RESTAURANT0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, restaurant · name Jaro-Winkler 0.80 · same street + city + state · pins 42 m apart · name similarity 0.78 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MICKEYS BAR & RESTAURANT INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0267
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
19 within 1 mi · 24 within 3 mi
Off / on premise
7 / 7 within 1 mi · 8 / 8 within 3 mi
Selling alcohol
16 within 1 mi · 20 within 3 mi
Nearest
same channel 0.27 mi · licensed 0.39 mi
Setting
rural (260 people per sq mi)
People within 3 mi
7,354 (5,776 adults 21+, 3,370 households) from 3 tract(s), tracts within 3 mi
Income
per capita $36,368 · median household ~$69,265 (weighted mean of tract medians)
Age and education
median age ~42.8 · bachelor's or higher 27%
Ethnicity
Hispanic 1% · White 93% · Black 1% · Asian 2%
Adults per alcohol outlet
275
Alcohol spend within 3 mi
$1,901,798 a year ($906,899 at home, $993,870 away) · $90,562 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:37insertab-inbev 2635593 ↔ inspections inspections|nys|326394same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|326394 ↔ vtinfo 1469edb576d73727same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|326394 ↔ ny-sla 0267-23-332948same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|326394 ↔ overture 90f3f537-e1a1-408b-82fc-32d5fcaed504same address and namemerged17
2026-11-16 14:56insertoverture 90f3f537-e1a1-408b-82fc-32d5fcaed504 ↔ vtinfo 1469edb576d73727same address and namemerged15
2026-11-16 14:56insertab-inbev 2635593 ↔ vtinfo 1469edb576d73727same address and namemerged15
2026-11-16 14:56insertny-sla 0267-23-332948 ↔ vtinfo 1469edb576d73727same address and namemerged15
2026-11-12 17:29insertab-inbev 2635593 ↔ overture 90f3f537-e1a1-408b-82fc-32d5fcaed504same address and namemerged14
2026-11-11 12:56insertab-inbev 2635593 ↔ ny-sla 0267-23-332948same address and namemerged12
2026-11-06 18:13insertny-sla 0267-23-332948 ↔ overture 90f3f537-e1a1-408b-82fc-32d5fcaed504same address and namemerged11