Mulcahys

WANTAGH, NY 11793 · O2ad726e56b14 · first seen 2026-11-02
3 sourceson premise · predictedalcohol: 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
Mulcahys 2 other
a licence name in capitals, cleaned (derived; record_title.py)
MULCAHY'S ny-sla
ROADBLOCK BAR INC ny-sla (legal name)
Street
3232 3234 RAILROAD AVE 1 other
ny-sla
3234 RAILROAD AVE ab-inbevvtinfo ×2
City
WANTAGH
ny-slano other value
State
NY
ny-slano other value
ZIP
11793
ny-slano other value
Pin
40.67268, -73.51002 map
ny-slano other value
Phone
5167859398
vtinfono other value
Licences
ny-sla 0417-22-100458
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O703a1906c26b; Ob622483127eb

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-inbevMULCAHYS
2625510
3234 RAILROAD AVE, WANTAGH, NY, 1179340.67268, -73.509592026-11-112026-11-11
ny-slaMULCAHY'S
legal name: ROADBLOCK BAR INC
0417-22-100458
3232 3234 RAILROAD AVE, WANTAGH, NY, 1179340.67268, -73.510022026-11-022026-11-12
vtinfoMULCAHYS
41d6cc8e9c61d8a4
3234 RAILROAD AVE, WANTAGH, NY, 11793516785939840.67253, -73.509972026-11-112026-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
inspections MULCAHY'S PUBny-sla MULCAHY'S1.00street written two waysheld same-source-conflictname Jaro-Winkler 1.00 · matched on zip · pins 99 m apart · name similarity 1.00 · street similarity 0.83
ab-inbev MULCAHYSny-sla MULCAHY'S1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Mulcahy's same address range.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records name Mulcahy's at 3234 Railroad Ave in Wantagh (the NY-SLA address is 3232-3234, covering 3234), and the names agree despite punctuation, with coordinates 36 m apart; the shared building is resolved by the matching name.
pair 49a85c43a41dba55155a
ab-inbev MULCAHYSvtinfo MULCAHYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROADBLOCK BAR INC — 2 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0417
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
154 within 1 mi · 741 within 3 mi
Off / on premise
32 / 89 within 1 mi · 161 / 398 within 3 mi
Selling alcohol
99 within 1 mi · 441 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
urban (5,212 people per sq mi)
People within 3 mi
147,379 (110,633 adults 21+, 48,733 households) from 30 tract(s), tracts within 3 mi
Income
per capita $66,440 · median household ~$168,708 (weighted mean of tract medians)
Age and education
median age ~41.9 · bachelor's or higher 53%
Ethnicity
Hispanic 10% · White 84% · Black 2% · Asian 4%
Adults per alcohol outlet
250
Alcohol spend within 3 mi
$52,505,426 a year ($22,204,104 at home, $30,284,532 away) · $118,791 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|577943 ↔ ny-sla 0417-22-100458street written two waysheld: same-source-conflict17
2026-11-12 17:29insertab-inbev 2625510 ↔ ny-sla 0417-22-100458Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2625510 ↔ vtinfo 41d6cc8e9c61d8a4same address and namemerged12