The Hamilton Mercantile

Wells, NY 12190 · O9bb04e657086 · first seen 2026-11-02
2 sourcesoff premisealcohol: licensed1 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
The Hamilton Mercantile 1 other
the most common name a source states
TIBERGUS LLC ny-sla (legal name)
Street
1359 STATE RTE 30 1 other
ny-sla
1359 NY-30 overture
City
WELLS
ny-slano other value
State
NY
ny-slano other value
ZIP
12190
ny-slano other value
Pin
43.39420, -74.29042 map
overtureno other value
Phone
5189243477
overtureno other value
Licences
ny-sla 0081-23-203396
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oadbb1b1a1a0a

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
ny-slaTHE HAMILTON MERCANTILE
legal name: TIBERGUS LLC
0081-23-203396
1359 STATE RTE 30, WELLS, NY, 1219043.39409, -74.290152026-11-022026-11-06
overtureThe Hamilton Mercantile
e69ca3ae-5a00-4be1-bf07-e656fb21c826
1359 NY-30, Wells, NY, 12190518924347743.39420, -74.290422026-11-062026-11-06

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
ny-sla THE HAMILTON MERCANTILEoverture The Hamilton Mercantile1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00

Attributes

Channel
off_premise — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TIBERGUS LLC — 1 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
1 within 1 mi · 1 within 3 mi
Off / on premise
1 / 0 within 1 mi · 1 / 0 within 3 mi
Selling alcohol
1 within 1 mi · 1 within 3 mi
Nearest
same channel 0.86 mi · licensed 0.86 mi
Setting
rural (54 people per sq mi)
People within 3 mi
1,529 (1,249 adults 21+, 640 households) from 1 tract(s), tracts within 3 mi
Income
per capita $38,430 · median household ~$72,143 (weighted mean of tract medians)
Age and education
median age ~53.6 · bachelor's or higher 21%
Ethnicity
Hispanic 2% · White 95% · Black 0% · Asian 0%
Adults per alcohol outlet
624
Alcohol spend within 3 mi
$389,106 a year ($183,308 at home, $205,673 away) · $194,553 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-06 18:13insertny-sla 0081-23-203396 ↔ overture e69ca3ae-5a00-4be1-bf07-e656fb21c826same address and namemerged11