SIGNATURE WINE AND SPIRIT

New Hartford, CT 06057 · O000d54e3256d · first seen 2026-10-14
5 sourcesoff premise · liquor_storechain: Signature Wine and Spirits- New Hartfordalcohol: 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
SIGNATURE WINE AND SPIRIT 4 other
the most common name a source states
Bros2 LLC ct-dcp (legal name)
Signature Wine & Spirits ct-dcp
Signature wine and spirits overture
Signature Wine and Spirits- New Hartford ubereats
Street
516 Main St. 1 other
ct-dcp
516 Main Street ubereats
City
New Hartford
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06057
ct-dcpno other value
Pin
41.87828, -72.97881 map
ubereatsno other value
Phone
8603793764
hempno other value
Licences
ct-dcp CT|LIP.0016204
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O56db2b334780; Odeae2b6ee083; O4d5c3a6204fc; Oa018880fe73a

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-inbevSIGNATURE WINE AND SPIRIT
4704420
516 MAIN ST, NEW HARTFORD, CT, 0605741.87827, -72.979052026-11-112026-11-11
ct-dcpSignature Wine & Spirits
legal name: Bros2 LLC
CT|LIP.0016204
516 Main St., New Hartford, CT, 0605741.87832, -72.979212026-11-032026-11-05
hempSIGNATURE WINE AND SPIRIT
b5ee25c9169a52a4
516 MAIN ST, NEW HARTFORD, CT, 06057860379376441.87827, -72.979052026-10-232026-11-02
overtureSignature wine and spirits
981afc59-d071-480c-871b-5e7a53e446ad
516 Main St, New Hartford, CT, 06057860379376441.87833, -72.978822026-11-062026-11-06
ubereatsSignature Wine and Spirits- New Hartford
nG4vBuVbUKennhY4FjPedg
516 Main Street, New Hartford, CT, 0605741.87828, -72.978812026-10-142026-10-14

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 SIGNATURE WINE AND SPIRIThemp SIGNATURE WINE AND SPIRIT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
ct-dcp Signature Wine & Spiritsoverture Signature wine and spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ab-inbev SIGNATURE WINE AND SPIRITct-dcp Signature Wine & Spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 14 m apart · name similarity 0.74
ab-inbev SIGNATURE WINE AND SPIRIToverture Signature wine and spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 20 m apart · name similarity 0.74
ct-dcp Signature Wine & Spiritshemp SIGNATURE WINE AND SPIRIT0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · name similarity 0.74
hemp SIGNATURE WINE AND SPIRIToverture Signature wine and spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 20 m apart · name similarity 0.74 · phone: equal
ab-inbev SIGNATURE WINE AND SPIRITubereats Signature Wine and Spirits- New Hartford0.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
Same name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Signature Wine and Spirits at 516 Main Street, New Hartford, CT 06057, with coordinates about 20 m apart and only one business at that address, so they are the same outlet.
pair 380110b92eee094584d1
hemp SIGNATURE WINE AND SPIRITubereats Signature Wine and Spirits- New Hartford0.54Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records name Signature Wine and Spirits at 516 Main St, New Hartford CT, with coordinates 0.02 km apart, and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same store name and address.
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name Signature Wine and Spirits at 516 Main Street, New Hartford CT 06057, with matching coordinates within 0.02 km and no other business at that address, so they are one store listed by a hemp brand finder and Uber Eats.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same street address (516 Main St, New Hartford CT 06057), the names match as Signature Wine and Spirit(s), coordinates are about 20 m apart, and only one business is held at that address, so they are one outlet.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records place 'Signature Wine and Spirit(s)' at 516 Main Street, New Hartford CT, with coordinates about 20 m apart, and no other business is held at that address, so the names and address agree on one operation.
pair 15e907676a6694a143c5

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
Signature Wine and Spirits- New Hartford — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
Bros2 LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CT LIP
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
3 within 1 mi · 18 within 3 mi
Off / on premise
0 / 1 within 1 mi · 6 / 5 within 3 mi
Selling alcohol
3 within 1 mi · 17 within 3 mi
Nearest
same channel 1.02 mi · licensed 0.07 mi
Setting
rural (236 people per sq mi)
People within 3 mi
6,675 (5,275 adults 21+, 2,688 households) from 1 tract(s), tracts within 3 mi
Income
per capita $76,073 · median household ~$109,695 (weighted mean of tract medians)
Age and education
median age ~50.7 · bachelor's or higher 43%
Ethnicity
Hispanic 3% · White 95% · Black 1% · Asian 1%
Adults per alcohol outlet
293
Alcohol spend within 3 mi
$2,298,813 a year ($1,011,931 at home, $1,285,971 away) · $127,712 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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-12 17:29insertab-inbev 4704420 ↔ ubereats nG4vBuVbUKennhY4FjPedgClaude judge: samemerged14
2026-11-11 12:56insertab-inbev 4704420 ↔ ct-dcp CT|LIP.0016204same address and namemerged12
2026-11-11 12:56insertab-inbev 4704420 ↔ overture 981afc59-d071-480c-871b-5e7a53e446adsame address and namemerged12
2026-11-11 12:56insertab-inbev 4704420 ↔ hemp b5ee25c9169a52a4same address and namemerged12
2026-11-06 18:13inserthemp b5ee25c9169a52a4 ↔ overture 981afc59-d071-480c-871b-5e7a53e446adsame address and namemerged11
2026-11-06 18:13insertct-dcp CT|LIP.0016204 ↔ overture 981afc59-d071-480c-871b-5e7a53e446adsame address and namemerged11
2026-11-03 13:33backfillct-dcp CT|LIP.0016204 ↔ hemp b5ee25c9169a52a4same address and namemerged
2026-11-02 23:02backfillhemp b5ee25c9169a52a4 ↔ ubereats nG4vBuVbUKennhY4FjPedgClaude judge: samemerged