Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits

Williamson, NY 14589 · O086876ed2830 · first seen 2026-11-02
4 sourcesoff premise · liquor_storealcohol: licensed6 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
Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits 4 other
the most common name a source states
Pip & Porter Inc ny-sla (legal name)ttb (legal name) ×6
ROOTSTOCK CIDER & SPIRITS ab-inbevoverture ×2
Rootstock ttb
Rootstock, Rootstock Cider & Spirits, Rootstock Spirits ttb
Street
3274 Eddy Rd 1 other
ny-sla
3274 EDDY AD ab-inbev
City
Williamson
ny-slano other value
State
NY
ny-slano other value
ZIP
14589
ny-slano other value
Pin
43.20144, -77.22485 map 1 other
overture
5.8 km away ab-inbev
Phone
3155898733
overtureno other value
Licences
ny-sla 0032-24-334085 · ny-sla 0052-24-334084 · ny-sla 0056-24-334083 · ny-sla 0370-24-335023 · ttb NY-S-20301 · ttb NY-W-21499
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O54517eac5e90; O574bb3cdecd6; Odc39d05368d9; Odb9b4ae52e3a; O45afc72a4c23; O4ee79e795e87; O828d64c84e44

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-inbevROOTSTOCK CIDER & SPIRITS
4736052
3274 EDDY AD, WILLIAMSON, NY, 1458943.23997, -77.176682026-11-152026-11-15
ny-slaRootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits
legal name: Pip & Porter Inc
0032-24-334085
3274 Eddy Rd, Williamson, NY, 1458943.20143, -77.224682026-11-022026-11-05
ny-slaRootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits
legal name: Pip & Porter Inc
0052-24-334084
3274 Eddy Rd, Williamson, NY, 1458943.20143, -77.224682026-11-022026-11-05
ny-slaRootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits
legal name: Pip & Porter Inc
0056-24-334083
3274 Eddy Rd, Williamson, NY, 1458943.20143, -77.224682026-11-022026-11-05
ny-slaRootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits
legal name: Pip & Porter Inc
0370-24-335023
3274 Eddy Rd, Williamson, NY, 1458943.20143, -77.224682026-11-022026-11-05
overtureRootstock Cider & Spirits
17fb3925-82c1-4077-bb88-3694d81b7652
3274 Eddy Rd, Williamson, NY, 14589315589873343.20144, -77.224852026-11-062026-11-06
ttbRootstock, Rootstock Cider & Spirits, Rootstock Spirits
legal name: PIP & PORTER, INC.
NY-S-20301
3274 EDDY RD, WILLIAMSON, NY, 145892026-11-032026-11-05
ttbRootstock
legal name: PIP & PORTER, INC.
NY-W-21499
3274 EDDY RD, WILLIAMSON, NY, 145892026-11-032026-11-05

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 ROOTSTOCK CIDER & SPIRITSttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00street written two waysmergedname Jaro-Winkler 0.86 · matched on zip · name similarity 1.00 · street similarity 0.86
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
ny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: PIP & PORTER, INC. · name similarity 1.00
overture Rootstock Cider & Spiritsttb Rootstock, Rootstock Cider & Spirits, Rootstock Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.86 · same street + ZIP · name similarity 1.00
ttb Rootstock, Rootstock Cider & Spirits, Rootstock Spiritsttb Rootstock1.00one store listed twicemergedfacility: producer · same street + ZIP
ab-inbev ROOTSTOCK CIDER & SPIRITSny-sla Rootstock, Rootstock Ciderworks, Rootstock Cider & Spirits, Rootstock Spirits0.78Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Rootstock Cider & Spirits trade name at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address (3274 Eddy Rd, Williamson NY 14589), only one business is held at that address, and record B's trade-name list includes 'Rootstock Cider & Spirits', matching record A's name; the 5.8 km coordinate gap is geocoding noise, not a different place.
pair 0b0da1cdda81c89a4d6a

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Pip & Porter Inc — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0032; NY 0052; NY 0056; NY 0370
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
0 within 1 mi · 18 within 3 mi
Off / on premise
0 / 0 within 1 mi · 7 / 6 within 3 mi
Selling alcohol
0 within 1 mi · 13 within 3 mi
Nearest
same channel 2.51 mi · licensed 2.46 mi
Setting
rural (374 people per sq mi)
People within 3 mi
10,582 (8,331 adults 21+, 4,565 households) from 3 tract(s), tracts within 3 mi
Income
per capita $37,924 · median household ~$71,845 (weighted mean of tract medians)
Age and education
median age ~43.6 · bachelor's or higher 20%
Ethnicity
Hispanic 5% · White 89% · Black 2% · Asian 0%
Adults per alcohol outlet
595
Alcohol spend within 3 mi
$2,667,254 a year ($1,261,406 at home, $1,404,512 away) · $190,518 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:37insertab-inbev 4736052 ↔ ny-sla 0032-24-334085Claude judge: samemerged17
2026-11-15 16:24insertab-inbev 4736052 ↔ ttb NY-S-20301street written two waysmerged15
2026-11-06 18:13insertoverture 17fb3925-82c1-4077-bb88-3694d81b7652 ↔ ttb NY-S-20301same address and namemerged11
2026-11-05 18:28backfillttb NY-S-20301 ↔ ttb NY-W-21499one store listed twicemerged
2026-11-05 16:28backfillny-sla 0370-24-335023 ↔ ttb NY-S-20301same address and namemerged
2026-11-05 16:28backfillny-sla 0032-24-334085 ↔ ttb NY-S-20301same address and namemerged
2026-11-05 16:28backfillny-sla 0056-24-334083 ↔ ttb NY-S-20301same address and namemerged
2026-11-05 16:28backfillny-sla 0052-24-334084 ↔ ttb NY-S-20301same address and namemerged
2026-11-05 16:28backfillny-sla 0370-24-335023 ↔ ttb NY-W-21499same address and namemerged
2026-11-05 16:28backfillny-sla 0056-24-334083 ↔ ttb NY-W-21499same address and namemerged
2026-11-05 16:28backfillny-sla 0052-24-334084 ↔ ttb NY-W-21499same address and namemerged
2026-11-05 16:28backfillny-sla 0032-24-334085 ↔ ttb NY-W-21499same address and namemerged
2026-11-03 13:33backfillny-sla 0032-24-334085 ↔ ny-sla 0370-24-335023one store listed twicemerged
2026-11-03 13:33backfillny-sla 0032-24-334085 ↔ ny-sla 0056-24-334083one store listed twicemerged
2026-11-03 13:33backfillny-sla 0032-24-334085 ↔ ny-sla 0052-24-334084one store listed twicemerged