Outlets /
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.
| Field | Master value | Taken from | What 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-sla | no other value |
| ZIP | 14841 | ny-sla | no 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 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | RED NEWT CELLARS INC 00449930|82|LIC|0 | 3675 TICHENOR RD, HECTOR, NY, 14841 | 42.50089, -76.86806 | 2026-10-08 | 2026-11-03 | |
| inspections | RED NEWT CELLARS inspections|nys|342168 | 3675 TICHENOR ROAD, Hector, NY, 14841 | 42.50091, -76.86705 | 2026-11-19 | 2026-11-19 | |
| ny-sla | RED NEWT CELLARS 0032-22-301464 | 3675 TICHENOR RD, HECTOR, NY, 14841 | 42.50087, -76.86680 | 2026-11-02 | 2026-11-03 | |
| ny-sla | TRESTLE 31 legal name: TRADEWINDS WINE COMPANY, LLC 0032-23-341822 | 3675 Tichenor Rd, Hector, NY, 14841 | 42.50087, -76.86679 | 2026-11-02 | 2026-11-05 | |
| overture | Red Newt Cellars d4347da9-e7cd-4757-aeb2-4d13114348fa | 3675 Tichenor Rd, Hector, NY, 14841 | 6075464100 | 42.50154, -76.86674 | 2026-11-06 | 2026-11-09 |
| ttb | Trestle 31 legal name: TRADEWINDS WINE COMPANY, LLC NY-W-21141 | 3675 TICHENOR RD, HECTOR, NY, 14841 | 42.50089, -76.86806 | 2026-11-03 | 2026-11-05 | |
| ttb | COLIN AND CHRISTINA, LLC NY-W-21574 | 3675 TICHENOR RD, HECTOR, NY, 14841 | 42.50089, -76.86806 | 2026-11-03 | 2026-11-05 | |
| ttb | WES ANDREW WINE LLC NY-W-21613 | 3675 TICHENOR RD, HECOTOR, NY, 14841 | 42.50089, -76.86806 | 2026-11-03 | 2026-11-05 | |
| ttb | RED NEWT CELLARS, INC. NY-W-250 | 3675 TICHENOR RD, HECTOR, NY, 14841 | 42.50089, -76.86806 | 2026-11-03 | 2026-11-04 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc RED NEWT CELLARS INC | inspections RED NEWT CELLARS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | mi-lcc L-000269299 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | ny-sla RED NEWT CELLARS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | overture ba975fac-70d9-4194-bb9a-91b6f76fca3f | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 133 m apart · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | overture Red Newt Cellars | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ca-abc RED NEWT CELLARS INC | tx-tabc 101430116 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| inspections RED NEWT CELLARS | ny-sla RED NEWT CELLARS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00 |
| inspections RED NEWT CELLARS | overture Red Newt Cellars | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00 |
| inspections RED NEWT CELLARS | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00 |
| mi-lcc L-000269299 | ny-sla RED NEWT CELLARS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| mi-lcc L-000269299 | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ny-sla RED NEWT CELLARS | overture ba975fac-70d9-4194-bb9a-91b6f76fca3f | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · name similarity 1.00 |
| ny-sla RED NEWT CELLARS | overture Red Newt Cellars | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00 |
| ny-sla RED NEWT CELLARS | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ny-sla RED NEWT CELLARS | tx-tabc 101430116 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ny-sla TRESTLE 31 | ttb Trestle 31 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| overture ba975fac-70d9-4194-bb9a-91b6f76fca3f | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 133 m apart · name similarity 1.00 |
| overture Red Newt Cellars | ttb RED NEWT CELLARS, INC. | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · name similarity 1.00 |
| ttb Trestle 31 | ttb COLIN AND CHRISTINA, LLC | 1.00 | one store listed twice | merged | facility: producer · same street + ZIP |
| ttb Trestle 31 | ttb WES ANDREW WINE LLC | 1.00 | one store listed twice | merged | facility: producer · same street + ZIP |
| ttb Trestle 31 | ttb RED NEWT CELLARS, INC. | 1.00 | one store listed twice | merged | facility: producer · same street + ZIP |
| ttb RED NEWT CELLARS, INC. | tx-tabc 101430116 | 1.00 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | inspections inspections|nys|342168 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fa | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys|342168 ↔ ttb NY-W-250 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys|342168 ↔ ny-sla 0032-22-301464 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00449930|82|LIC|0 ↔ inspections inspections|nys|342168 | same address and name | merged | 17 |
| 2026-11-09 15:32 | update | overture d4347da9-e7cd-4757-aeb2-4d13114348fa ↔ ttb NY-W-250 | same address and name | merged | 11 |
| 2026-11-09 15:32 | update | ny-sla 0032-22-301464 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fa | same address and name | merged | 11 |
| 2026-11-09 15:32 | update | ca-abc 00449930|82|LIC|0 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fa | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture d4347da9-e7cd-4757-aeb2-4d13114348fa ↔ ttb NY-W-250 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | overture ba975fac-70d9-4194-bb9a-91b6f76fca3f ↔ ttb NY-W-250 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ny-sla 0032-22-301464 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fa | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ny-sla 0032-22-301464 ↔ overture ba975fac-70d9-4194-bb9a-91b6f76fca3f | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00449930|82|LIC|0 ↔ overture d4347da9-e7cd-4757-aeb2-4d13114348fa | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00449930|82|LIC|0 ↔ overture ba975fac-70d9-4194-bb9a-91b6f76fca3f | same address and name | merged | 11 |
| 2026-11-05 18:28 | backfill | ttb NY-W-21141 ↔ ttb NY-W-250 | one store listed twice | merged | |
| 2026-11-05 18:28 | backfill | ttb NY-W-21141 ↔ ttb NY-W-21613 | one store listed twice | merged | |
| 2026-11-05 18:28 | backfill | ttb NY-W-21141 ↔ ttb NY-W-21574 | one store listed twice | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000269299 ↔ ttb NY-W-250 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ny-sla 0032-23-341822 ↔ ttb NY-W-21141 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ny-sla 0032-22-301464 ↔ ttb NY-W-250 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000269299 ↔ ny-sla 0032-22-301464 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ttb NY-W-250 ↔ tx-tabc 101430116 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ny-sla 0032-22-301464 ↔ tx-tabc 101430116 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ca-abc 00449930|82|LIC|0 ↔ ttb NY-W-250 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ca-abc 00449930|82|LIC|0 ↔ mi-lcc L-000269299 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ca-abc 00449930|82|LIC|0 ↔ ny-sla 0032-22-301464 | same address and name | merged | |
| 2026-11-03 13:33 | backfill | ca-abc 00449930|82|LIC|0 ↔ tx-tabc 101430116 | same address and name | merged |