MAGPIE

ROCHESTER, NY 14607 · O7a61ca41eb5c · first seen 2026-11-02
4 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
MAGPIE 2 other
the most common name a source states
MAGPIE IRISH PUB ny-slaoverture ×2
WILMER ASSOCIATES INC ny-sla (legal name)
Street
653 PARK AVE
ny-slano other value
City
ROCHESTER
ny-slano other value
State
NY
ny-slano other value
ZIP
14607
ny-slano other value
Pin
43.14812, -77.57818 map
overtureno other value
Phone
5852714150
vtinfono other value
Licences
ny-sla 0370-23-335347
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obddc54716c5c; Obc314dff2021; O8bb3a56fb6bb

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-inbevMAGPIE
2913366
653 PARK AVE, ROCHESTER, NY, 1460743.14824, -77.578442026-11-112026-11-16
ny-slaMAGPIE IRISH PUB
legal name: WILMER ASSOCIATES INC
0370-23-335347
653 PARK AVE, ROCHESTER, NY, 1460743.14821, -77.578092026-11-022026-11-06
overtureMagpie Irish Pub
0a498bde-9a20-4691-ac3f-b64afbbb6974
653 Park Ave, Rochester, NY, 14607585271415043.14812, -77.578182026-11-062026-11-06
vtinfoMAGPIE
cb3ae9a715a13559
653 PARK AVE, ROCHESTER, NY, 14607585271415043.14799, -77.578232026-11-122026-11-16

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
ny-sla MAGPIE IRISH PUBoverture Wilmer Associates Inc1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · matched through the licence's legal name: WILMER ASSOCIATES INC · name similarity 1.00
ab-inbev MAGPIEvtinfo MAGPIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
ny-sla MAGPIE IRISH PUBoverture Magpie Irish Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev MAGPIEny-sla MAGPIE IRISH PUB0.44one name contains the other, same addressmergedjudge: None · pair_id: 510e43424dc37511eade · person: None · rule: names contained at one address · stratum: same-address
ny-sla MAGPIE IRISH PUBvtinfo MAGPIE0.44one name contains the other, same addressmergedjudge: None · pair_id: 39204a8b27de46538de3 · 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
WILMER ASSOCIATES INC — 3 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
223 within 1 mi · 951 within 3 mi
Off / on premise
33 / 112 within 1 mi · 216 / 417 within 3 mi
Selling alcohol
175 within 1 mi · 684 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (5,367 people per sq mi)
People within 3 mi
151,742 (117,947 adults 21+, 71,023 households) from 59 tract(s), tracts within 3 mi
Income
per capita $40,914 · median household ~$63,154 (weighted mean of tract medians)
Age and education
median age ~36.2 · bachelor's or higher 43%
Ethnicity
Hispanic 17% · White 51% · Black 26% · Asian 3%
Adults per alcohol outlet
172
Alcohol spend within 3 mi
$40,066,706 a year ($18,882,488 at home, $21,165,839 away) · $58,492 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-16 14:56insertny-sla 0370-23-335347 ↔ vtinfo cb3ae9a715a13559one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2913366 ↔ ny-sla 0370-23-335347one name contains the other, same addressmerged15
2026-11-12 14:25insertab-inbev 2913366 ↔ vtinfo cb3ae9a715a13559same address and namemerged12
2026-11-06 18:13insertny-sla 0370-23-335347 ↔ overture 9b34a0f9-60eb-444f-8fc1-273f6e99d401same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0370-23-335347 ↔ overture 0a498bde-9a20-4691-ac3f-b64afbbb6974same address and namemerged11