Shamrock Wines & Liquors

Bronx, NY 10471 · O46d7723e0a47 · first seen 2026-10-14
5 sourcesoff premise · liquor_storechain: Shamrock Wines & Liquorsalcohol: 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
Shamrock Wines & Liquors 3 other
the most common name a source states
BWAY & 242ND ST LLC ny-sla (legal name)
SHAMROCK WINE & LIQUORS ny-sla
SHAMROCK WINE LIQUOR vtinfo
Street
5995 BROADWAY
ny-slano other value
City
BRONX
ny-slano other value
State
NY
ny-slano other value
ZIP
10471
ny-slano other value
Pin
40.89027, -73.89825 map
ubereatsno other value
Phone
7187965507
vtinfono other value
Licences
ny-sla 0100-23-124547
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa0fd7ad4ebec; O91aabe5ab38b; O92fbf4b01628; Oe3343ddee200

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
lotterySHAMROCK WINES & LIQUORS
lottery|ny|083552
5995 BROADWAY, Bronx, NY, 1047140.89019, -73.898162026-11-202026-11-20
ny-slaSHAMROCK WINE & LIQUORS
legal name: BWAY & 242ND ST LLC
0100-23-124547
5995 BROADWAY, BRONX, NY, 1047140.89022, -73.897992026-11-022026-11-06
overtureShamrock Wines & Liquors
cbab1a88-2477-4d41-b32a-5aa84232af09
5995 Broadway, Bronx, NY, 10471718796550740.89022, -73.898192026-11-062026-11-06
ubereatsShamrock Wines & Liquors
quIxX2J6QVWr4IDCkuYMpA
5995 Broadway, Bronx, NY, 1047140.89027, -73.898252026-10-142026-11-06
vtinfoSHAMROCK WINE LIQUOR
b9b3d5358293f6c5
5995 BROADWAY, BRONX, NY, 10471718796550740.89031, -73.898252026-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
ny-sla SHAMROCK WINE & LIQUORSvtinfo BROADWAY & 242ND ST0.68same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 24 m apart · matched through the licence's legal name: BWAY & 242ND ST LLC · name similarity 0.68
lottery SHAMROCK WINES & LIQUORSoverture Shamrock Wines & Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
lottery SHAMROCK WINES & LIQUORSubereats Shamrock Wines & Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
overture Shamrock Wines & Liquorsubereats Shamrock Wines & Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
lottery SHAMROCK WINES & LIQUORSny-sla SHAMROCK WINE & LIQUORS0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 14 m apart · name similarity 0.74
ny-sla SHAMROCK WINE & LIQUORSoverture Shamrock Wines & Liquors0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 17 m apart · name similarity 0.74
ny-sla SHAMROCK WINE & LIQUORSubereats Shamrock Wines & Liquors0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 23 m apart · name similarity 0.74
ny-sla SHAMROCK WINE & LIQUORSvtinfo SHAMROCK WINE LIQUOR0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 24 m apart · name similarity 0.74
lottery SHAMROCK WINES & LIQUORSvtinfo SHAMROCK WINE LIQUOR0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 15 m apart · name similarity 0.58
overture Shamrock Wines & Liquorsvtinfo SHAMROCK WINE LIQUOR0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 11 m apart · name similarity 0.58 · phone: equal
ubereats Shamrock Wines & Liquorsvtinfo SHAMROCK WINE LIQUOR0.58same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + city + state · pins 5 m apart · name similarity 0.58

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
Shamrock Wines & Liquors — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
BWAY & 242ND ST LLC — 1 outlets in the master under this operator
Licence privileges
wine_off, spirits_off — NY 0100
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
250 within 1 mi · 2,510 within 3 mi
Off / on premise
38 / 155 within 1 mi · 435 / 1,282 within 3 mi
Selling alcohol
121 within 1 mi · 1,435 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.03 mi
Setting
urban (25,832 people per sq mi)
People within 3 mi
730,396 (536,811 adults 21+, 281,495 households) from 180 tract(s), tracts within 3 mi
Income
per capita $33,364 · median household ~$64,293 (weighted mean of tract medians)
Age and education
median age ~38.0 · bachelor's or higher 28%
Ethnicity
Hispanic 55% · White 18% · Black 26% · Asian 4%
Adults per alcohol outlet
374
Alcohol spend within 3 mi
$158,416,063 a year ($74,431,072 at home, $83,896,559 away) · $110,318 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-20 22:08insertlottery lottery|ny|083552 ↔ vtinfo b9b3d5358293f6c5same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|083552 ↔ ny-sla 0100-23-124547same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|083552 ↔ overture cbab1a88-2477-4d41-b32a-5aa84232af09same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|083552 ↔ ubereats quIxX2J6QVWr4IDCkuYMpAsame address and namemerged17
2026-11-14 20:23updateny-sla 0100-23-124547 ↔ vtinfo d3d7544acae987f0same address and nameheld: same-source-conflict15
2026-11-12 14:25insertoverture cbab1a88-2477-4d41-b32a-5aa84232af09 ↔ vtinfo b9b3d5358293f6c5same address and namemerged12
2026-11-12 14:25insertubereats quIxX2J6QVWr4IDCkuYMpA ↔ vtinfo b9b3d5358293f6c5same address and namemerged12
2026-11-12 14:25insertny-sla 0100-23-124547 ↔ vtinfo d3d7544acae987f0same address and nameheld: same-source-conflict12
2026-11-12 14:25insertny-sla 0100-23-124547 ↔ vtinfo b9b3d5358293f6c5same address and namemerged12
2026-11-06 18:13insertny-sla 0100-23-124547 ↔ overture cbab1a88-2477-4d41-b32a-5aa84232af09same address and namemerged11
2026-11-06 18:13insertoverture cbab1a88-2477-4d41-b32a-5aa84232af09 ↔ ubereats quIxX2J6QVWr4IDCkuYMpAsame address and namemerged11
2026-11-03 13:33backfillny-sla 0100-23-124547 ↔ ubereats quIxX2J6QVWr4IDCkuYMpAsame address and namemerged