Red Hat on the River

Irvington, NY 10533 · O16d6eafdf67d · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed2 licences

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
Red Hat on the River 3 other
a source's own spelling of the licence name (record_title.py)
RED HAT BISTRO LLC ny-slainspections (legal name)ny-sla (legal name) ×3
red hat bistro llc irvington doordash
Red Hat On The River 1 Bridge Street toast
Street
1 BRIDGE STREET SUITE 150 2 other
ny-sla
1 Bridge Street doordashinspectionstoast ×3
1 Bridge St overturevtinfo ×2
City
IRVINGTON
ny-slano other value
State
NY
ny-slano other value
ZIP
10533
ny-slano other value
Pin
41.03957, -73.87403 map 4 other
toast
64 m away ny-sla ×2
280 m away doordash
176 m away inspections
171 m away vtinfo
Phone
9145915888
vtinfono other value
Licences
ny-sla 0340-23-132843 · ny-sla 0423-23-135340
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe3a7c48006be; O6643ba429f29; O382d60e17f5e; Oa32446c60f81; O8689e3ec6a23; O233f8c54db92

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
doordashred hat bistro llc irvington
24255533
1 Bridge Street, Irvington, NY, 1053341.04192, -73.872792026-10-082026-11-19
inspectionsRED HAT ON THE RIVER
legal name: RED HAT BISTRO LLC
inspections|nys|590013
1 BRIDGE STREET, Irvington, NY, 1053341.04103, -73.873212026-11-192026-11-19
ny-slaRED HAT ON THE RIVER
legal name: RED HAT BISTRO LLC
0340-23-132843
1 BRIDGE STREET SUITE 150, IRVINGTON, NY, 1053341.03966, -73.873272026-11-022026-11-19
ny-slaRED HAT BISTRO LLC
0423-23-135340
1 BRIDGE STREET SUITE 150, IRVINGTON, NY, 1053341.03966, -73.873272026-11-022026-11-02
overtureRed Hat on the River
d67bcdc7-286f-4811-84a7-80f22bdfce22
1 Bridge St, Irvington, NY, 10533914591588841.03963, -73.874492026-11-062026-11-19
toastRed Hat On The River 1 Bridge Street
legal name: Red Hat On The River
9fe0ebe9-802d-4410-a5d6-2af2d182a637
1 Bridge Street, Irvington, NY, 10533914591588841.03957, -73.874032026-11-062026-11-19
vtinfoRED HAT ON THE RIVER
3d682a5e48e3d22d
1 BRIDGE ST, IRVINGTON, NY, 10533914591588841.04101, -73.873282026-11-122026-11-19

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
doordash red hat bistro llc irvingtonny-sla RED HAT BISTRO LLC1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 254 m apart · name similarity 1.00
inspections RED HAT ON THE RIVERny-sla RED HAT BISTRO LLC1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 152 m apart · matched through the licence's legal name: RED HAT BISTRO LLC · name similarity 1.00
doordash red hat bistro llc irvingtoninspections RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · matched through the licence's legal name: RED HAT BISTRO LLC · name similarity 1.00
doordash red hat bistro llc irvingtonny-sla RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 254 m apart · matched through the licence's legal name: RED HAT BISTRO LLC · name similarity 1.00
inspections RED HAT ON THE RIVERny-sla RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 152 m apart · name similarity 1.00
inspections RED HAT ON THE RIVERoverture Red Hat on the River1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 190 m apart · name similarity 1.00
inspections RED HAT ON THE RIVERtoast Red Hat On The River 1 Bridge Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 176 m apart · matched through the licence's legal name: Red Hat On The River · name similarity 1.00
inspections RED HAT ON THE RIVERvtinfo RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ny-sla RED HAT ON THE RIVERoverture Red Hat on the River1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00
ny-sla RED HAT ON THE RIVERtoast Red Hat On The River 1 Bridge Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 64 m apart · matched through the licence's legal name: Red Hat On The River · name similarity 1.00
ny-sla RED HAT ON THE RIVERvtinfo RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 150 m apart · name similarity 1.00
overture Red Hat on the Rivertoast Red Hat On The River 1 Bridge Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 40 m apart · matched through the licence's legal name: Red Hat On The River · name similarity 1.00 · phone: equal
overture Red Hat on the Rivervtinfo RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 184 m apart · name similarity 1.00 · phone: equal
toast Red Hat On The River 1 Bridge Streetvtinfo RED HAT ON THE RIVER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 171 m apart · matched through the licence's legal name: Red Hat On The River · name similarity 1.00 · phone: equal
ny-sla RED HAT BISTRO LLCvtinfo RED HAT ON THE RIVER0.43Claude judge: samemerged both outlets held a record of one source, each naming the same business
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Red Hat names agree at 1 Bridge St.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records share the distinctive 'Red Hat' name at 1 Bridge Street, Irvington, and the VIP account is plausibly the trade name of the NY bistro licence, though the building holds three businesses and the names are not identical.
pair 6ba1f53c9e87238d62a6

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RED HAT BISTRO LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340; NY 0423 (add-on: follows the base licence)
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
26 within 1 mi · 320 within 3 mi
Off / on premise
4 / 13 within 1 mi · 58 / 160 within 3 mi
Selling alcohol
24 within 1 mi · 244 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.02 mi
Setting
suburban (1,767 people per sq mi)
People within 3 mi
49,963 (37,341 adults 21+, 19,240 households) from 11 tract(s), tracts within 3 mi
Income
per capita $84,855 · median household ~$155,293 (weighted mean of tract medians)
Age and education
median age ~42.6 · bachelor's or higher 69%
Ethnicity
Hispanic 14% · White 67% · Black 4% · Asian 11%
Adults per alcohol outlet
152
Alcohol spend within 3 mi
$19,436,390 a year ($8,255,202 at home, $11,175,397 away) · $79,332 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:37insertny-sla 0423-23-135340 ↔ vtinfo 3d682a5e48e3d22dClaude judge: samemerged17
2026-11-19 20:37insertinspections inspections|nys|590013 ↔ toast 9fe0ebe9-802d-4410-a5d6-2af2d182a637same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|590013 ↔ vtinfo 3d682a5e48e3d22dsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|590013 ↔ ny-sla 0423-23-135340same address and nameheld: same-source-conflict17
2026-11-19 20:37insertdoordash 24255533 ↔ inspections inspections|nys|590013same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|590013 ↔ overture d67bcdc7-286f-4811-84a7-80f22bdfce22same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|590013 ↔ ny-sla 0340-23-132843same address and namemerged17
2026-11-18 18:58insertdoordash 24255533 ↔ ny-sla 0423-23-135340same address and nameheld: same-source-conflict15
2026-11-18 18:58insertdoordash 24255533 ↔ ny-sla 0340-23-132843same address and namemerged15
2026-11-12 14:25insertoverture d67bcdc7-286f-4811-84a7-80f22bdfce22 ↔ vtinfo 3d682a5e48e3d22dsame address and namemerged12
2026-11-12 14:25insertny-sla 0340-23-132843 ↔ vtinfo 3d682a5e48e3d22dsame address and namemerged12
2026-11-12 14:25insertoverture d67bcdc7-286f-4811-84a7-80f22bdfce22 ↔ toast 9fe0ebe9-802d-4410-a5d6-2af2d182a637same address and namemerged12
2026-11-12 14:25insertny-sla 0340-23-132843 ↔ toast 9fe0ebe9-802d-4410-a5d6-2af2d182a637same address and namemerged12
2026-11-12 14:25inserttoast 9fe0ebe9-802d-4410-a5d6-2af2d182a637 ↔ vtinfo 3d682a5e48e3d22dsame address and namemerged12
2026-11-06 18:13insertny-sla 0340-23-132843 ↔ overture d67bcdc7-286f-4811-84a7-80f22bdfce22same address and namemerged11