Longstreet Tavern

Pine Bush, NY 12566 · O551031ead8b2 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: alcohol1 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
Longstreet Tavern 2 other
the most common name a source states
ROJOLO INC ny-slainspections (legal name) ×2
longstreet tavern pine bush doordash
Street
82 MAIN ST 1 other
ny-sla
82 MAIN STREET inspectionsubereats ×2
City
PINE BUSH 1 other
ny-sla
Crawford overture
State
NY
ny-slano other value
ZIP
12566
ny-slano other value
Pin
41.60972, -74.30095 map 1 other
ubereats
94 m away ab-inbev
Phone
8455244014
overtureno other value
Licences
ny-sla 0340-22-210297
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od3ae827ca615; O77659362060f; O6d0e11d3f6a8; O71c99896da32; Oc6ed694b345e

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-inbevLONGSTREET TAVERN
4526460
82 MAIN ST, PINE BUSH, NY, 1256641.60908, -74.300212026-11-132026-11-13
doordashlongstreet tavern pine bush
39722970
82 Main St, Pine Bush, NY, 1256641.60969, -74.300962026-10-082026-10-20
inspectionsLongstreet Tavern
legal name: Rojolo Inc.
inspections|nys|1079552
82 MAIN STREET, Pine Bush, NY, 1256641.60962, -74.301092026-11-192026-11-19
ny-slaROJOLO INC
0340-22-210297
82 MAIN ST, PINE BUSH, NY, 1256641.60955, -74.301132026-11-022026-11-19
overtureLongstreet Tavern
6b648977-8d5e-4f1e-a9af-ba4c1482f960
82 Main St, Crawford, NY, 12566
ZIP lookup: Pine Bush, NY
845524401441.60961, -74.301072026-11-062026-11-06
ubereatsLongstreet Tavern
0nlN0wH6XM2gm3HLunD6Jw
82 Main Street, Pine Bush, NY, 1256641.60972, -74.300952026-10-202026-10-20

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 LONGSTREET TAVERNdoordash longstreet tavern pine bush1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 92 m apart · name similarity 1.00
ab-inbev LONGSTREET TAVERNinspections Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 94 m apart · name similarity 1.00
ab-inbev LONGSTREET TAVERNoverture Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 93 m apart · name similarity 1.00
ab-inbev LONGSTREET TAVERNubereats Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 94 m apart · name similarity 1.00
doordash longstreet tavern pine bushinspections Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
doordash longstreet tavern pine bushubereats Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
inspections Longstreet Tavernny-sla ROJOLO INC1.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: Rojolo Inc. · name similarity 1.00
inspections Longstreet Tavernoverture Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
inspections Longstreet Tavernubereats Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture Longstreet Tavernubereats Longstreet Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
34 within 1 mi · 42 within 3 mi
Off / on premise
11 / 13 within 1 mi · 13 / 15 within 3 mi
Selling alcohol
24 within 1 mi · 31 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
rural (130 people per sq mi)
People within 3 mi
3,685 (2,616 adults 21+, 1,338 households) from 1 tract(s), tracts within 3 mi
Income
per capita $43,806 · median household ~$112,188 (weighted mean of tract medians)
Age and education
median age ~35.4 · bachelor's or higher 25%
Ethnicity
Hispanic 22% · White 66% · Black 6% · Asian 0%
Adults per alcohol outlet
82
Alcohol spend within 3 mi
$1,102,954 a year ($488,579 at home, $613,783 away) · $34,467 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|1079552 ↔ overture 6b648977-8d5e-4f1e-a9af-ba4c1482f960same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|1079552 ↔ ny-sla 0340-22-210297same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|1079552 ↔ ubereats 0nlN0wH6XM2gm3HLunD6Jwsame address and namemerged17
2026-11-19 20:37insertdoordash 39722970 ↔ inspections inspections|nys|1079552same address and namemerged17
2026-11-19 20:37insertab-inbev 4526460 ↔ inspections inspections|nys|1079552same address and namemerged17
2026-11-13 14:10insertab-inbev 4526460 ↔ overture 6b648977-8d5e-4f1e-a9af-ba4c1482f960same address and namemerged15
2026-11-13 14:10insertab-inbev 4526460 ↔ ubereats 0nlN0wH6XM2gm3HLunD6Jwsame address and namemerged15
2026-11-13 14:10insertab-inbev 4526460 ↔ doordash 39722970same address and namemerged15
2026-11-06 18:13insertoverture 6b648977-8d5e-4f1e-a9af-ba4c1482f960 ↔ ubereats 0nlN0wH6XM2gm3HLunD6Jwsame address and namemerged11
2026-10-20 21:04backfilldoordash 39722970 ↔ ubereats 0nlN0wH6XM2gm3HLunD6Jwsame address and namemerged