Red Newt Cellars

HECTOR, NY 14841 · O0998e900dbea · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: licensed7 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 Newt Cellars 5 other
a source's own spelling of the licence name (record_title.py)
RED NEWT CELLARS INC ca-abcttb ×2
TRADEWINDS WINE COMPANY, LLC ny-sla (legal name)ttb (legal name) ×2
TRESTLE 31 ny-slattb ×2
COLIN AND CHRISTINA, LLC ttb
WES ANDREW WINE LLC ttb
Street
3675 TICHENOR RD 1 other
ny-sla
3675 TICHENOR ROAD inspections
City
HECTOR 1 other
ny-sla
HECOTOR ttb
State
NY
ny-slano other value
ZIP
14841
ny-slano other value
Pin
42.50154, -76.86674 map 4 other
overture
130 m away ttb ×4
75 m away ny-sla ×2
130 m away ca-abc
75 m away inspections
Phone
6075464100
overtureno other value
Licences
ca-abc 00449930|82|LIC|0 · ny-sla 0032-22-301464 · ny-sla 0032-23-341822 · ttb NY-W-21141 · ttb NY-W-21574 · ttb NY-W-21613 · ttb NY-W-250
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O3da22c43342a; Oc734cd001821; O8d846ca7ff4e; Obd2736fd2367; Oe30ec83c5041; O52626fbfd86b; O40ca59b14945; O19e982d7276d; Of7a857e03a1a; O816b4fa45687; Ob97cb02861ac

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
ca-abcRED NEWT CELLARS INC
00449930|82|LIC|0
3675 TICHENOR RD, HECTOR, NY, 1484142.50089, -76.868062026-10-082026-11-03
inspectionsRED NEWT CELLARS
inspections|nys|342168
3675 TICHENOR ROAD, Hector, NY, 1484142.50091, -76.867052026-11-192026-11-19
ny-slaRED NEWT CELLARS
0032-22-301464
3675 TICHENOR RD, HECTOR, NY, 1484142.50087, -76.866802026-11-022026-11-03
ny-slaTRESTLE 31
legal name: TRADEWINDS WINE COMPANY, LLC
0032-23-341822
3675 Tichenor Rd, Hector, NY, 1484142.50087, -76.866792026-11-022026-11-05
overtureRed Newt Cellars
d4347da9-e7cd-4757-aeb2-4d13114348fa
3675 Tichenor Rd, Hector, NY, 14841607546410042.50154, -76.866742026-11-062026-11-09
ttbTrestle 31
legal name: TRADEWINDS WINE COMPANY, LLC
NY-W-21141
3675 TICHENOR RD, HECTOR, NY, 1484142.50089, -76.868062026-11-032026-11-05
ttbCOLIN AND CHRISTINA, LLC
NY-W-21574
3675 TICHENOR RD, HECTOR, NY, 1484142.50089, -76.868062026-11-032026-11-05
ttbWES ANDREW WINE LLC
NY-W-21613
3675 TICHENOR RD, HECOTOR, NY, 1484142.50089, -76.868062026-11-032026-11-05
ttbRED NEWT CELLARS, INC.
NY-W-250
3675 TICHENOR RD, HECTOR, NY, 1484142.50089, -76.868062026-11-032026-11-04

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
ca-abc RED NEWT CELLARS INCinspections RED NEWT CELLARS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00
ca-abc RED NEWT CELLARS INCmi-lcc L-0002692991.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc RED NEWT CELLARS INCny-sla RED NEWT CELLARS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00
ca-abc RED NEWT CELLARS INCoverture ba975fac-70d9-4194-bb9a-91b6f76fca3f1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 133 m apart · name similarity 1.00
ca-abc RED NEWT CELLARS INCoverture Red Newt Cellars1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · name similarity 1.00
ca-abc RED NEWT CELLARS INCttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc RED NEWT CELLARS INCtx-tabc 1014301161.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections RED NEWT CELLARSny-sla RED NEWT CELLARS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
inspections RED NEWT CELLARSoverture Red Newt Cellars1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
inspections RED NEWT CELLARSttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00
mi-lcc L-000269299ny-sla RED NEWT CELLARS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc L-000269299ttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ny-sla RED NEWT CELLARSoverture ba975fac-70d9-4194-bb9a-91b6f76fca3f1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · name similarity 1.00
ny-sla RED NEWT CELLARSoverture Red Newt Cellars1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
ny-sla RED NEWT CELLARSttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ny-sla RED NEWT CELLARStx-tabc 1014301161.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ny-sla TRESTLE 31ttb Trestle 311.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture ba975fac-70d9-4194-bb9a-91b6f76fca3fttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 133 m apart · name similarity 1.00
overture Red Newt Cellarsttb RED NEWT CELLARS, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · name similarity 1.00
ttb Trestle 31ttb COLIN AND CHRISTINA, LLC1.00one store listed twicemergedfacility: producer · same street + ZIP
ttb Trestle 31ttb WES ANDREW WINE LLC1.00one store listed twicemergedfacility: producer · same street + ZIP
ttb Trestle 31ttb RED NEWT CELLARS, INC.1.00one store listed twicemergedfacility: producer · same street + ZIP
ttb RED NEWT CELLARS, INC.tx-tabc 1014301161.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none — CA 82; NY 0032
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
13 within 1 mi · 40 within 3 mi
Off / on premise
3 / 1 within 1 mi · 19 / 2 within 3 mi
Selling alcohol
13 within 1 mi · 40 within 3 mi
Nearest
same channel 0.33 mi · licensed 0.28 mi
Setting
rural (none people per sq mi)
People within 3 mi
3,385 (2,453 adults 21+, 1,371 households) from 1 tract(s), the nearest tract
Income
per capita $34,729 · median household ~$55,115 (weighted mean of tract medians)
Age and education
median age ~41.4 · bachelor's or higher 16%
Ethnicity
Hispanic 1% · White 93% · Black 2% · Asian 1%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$726,536 a year ($346,859 at home, $379,409 away) · none 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|342168 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fasame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|342168 ↔ ttb NY-W-250same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|342168 ↔ ny-sla 0032-22-301464same address and namemerged17
2026-11-19 20:37insertca-abc 00449930|82|LIC|0 ↔ inspections inspections|nys|342168same address and namemerged17
2026-11-09 15:32updateoverture d4347da9-e7cd-4757-aeb2-4d13114348fa ↔ ttb NY-W-250same address and namemerged11
2026-11-09 15:32updateny-sla 0032-22-301464 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fasame address and namemerged11
2026-11-09 15:32updateca-abc 00449930|82|LIC|0 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fasame address and namemerged11
2026-11-06 18:13insertoverture d4347da9-e7cd-4757-aeb2-4d13114348fa ↔ ttb NY-W-250same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture ba975fac-70d9-4194-bb9a-91b6f76fca3f ↔ ttb NY-W-250same address and namemerged11
2026-11-06 18:13insertny-sla 0032-22-301464 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fasame address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0032-22-301464 ↔ overture ba975fac-70d9-4194-bb9a-91b6f76fca3fsame address and namemerged11
2026-11-06 18:13insertca-abc 00449930|82|LIC|0 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fasame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00449930|82|LIC|0 ↔ overture ba975fac-70d9-4194-bb9a-91b6f76fca3fsame address and namemerged11
2026-11-05 18:28backfillttb NY-W-21141 ↔ ttb NY-W-250one store listed twicemerged
2026-11-05 18:28backfillttb NY-W-21141 ↔ ttb NY-W-21613one store listed twicemerged
2026-11-05 18:28backfillttb NY-W-21141 ↔ ttb NY-W-21574one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000269299 ↔ ttb NY-W-250same address and namemerged
2026-11-03 13:33backfillny-sla 0032-23-341822 ↔ ttb NY-W-21141same address and namemerged
2026-11-03 13:33backfillny-sla 0032-22-301464 ↔ ttb NY-W-250same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000269299 ↔ ny-sla 0032-22-301464same address and namemerged
2026-11-03 13:33backfillttb NY-W-250 ↔ tx-tabc 101430116same address and namemerged
2026-11-03 13:33backfillny-sla 0032-22-301464 ↔ tx-tabc 101430116same address and namemerged
2026-11-03 13:33backfillca-abc 00449930|82|LIC|0 ↔ ttb NY-W-250same address and namemerged
2026-11-03 13:33backfillca-abc 00449930|82|LIC|0 ↔ mi-lcc L-000269299same address and namemerged
2026-11-03 13:33backfillca-abc 00449930|82|LIC|0 ↔ ny-sla 0032-22-301464same address and namemerged
2026-11-03 13:33backfillca-abc 00449930|82|LIC|0 ↔ tx-tabc 101430116same address and namemerged