Harveys Wine & Spirit

WEST HARTFORD, CT 06117 · O46f0929e0e17 · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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
Harveys Wine & Spirit 3 other
a licence name in capitals, cleaned (derived; record_title.py)
HARVEY'S WINE & SPIRIT SHOPPE ct-dcp
Harvey's Wine and Spirit Shoppe overture
HOWARD-ADAM CORPORATION ct-dcp (legal name)
Street
2542 ALBANY AVENUE 1 other
ct-dcp
2542 ALBANY AVE ab-inbevhempoverturevtinfo ×4
City
WEST HARTFORD
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06117
ct-dcpno other value
Pin
41.78617, -72.74905 map 4 other
overture
133 m away ab-inbev
140 m away ct-dcp
116 m away hemp
116 m away vtinfo
Phone
8602362236
vtinfono other value
Licences
ct-dcp CT|LIP.0012448
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of5ce82292f6b; Odd3cc7e14c12; O863b6ae0d827; O8d6523daefbc

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-inbevHARVEYS WINE & SPIRIT
179894
2542 ALBANY AVE, WEST HARTFORD, CT, 0611741.78579, -72.747532026-11-122026-11-12
ct-dcpHARVEY'S WINE & SPIRIT SHOPPE
legal name: HOWARD-ADAM CORPORATION
CT|LIP.0012448
2542 ALBANY AVENUE, WEST HARTFORD, CT, 0611741.78579, -72.750672026-11-032026-11-12
hempHARVEYS WINE & SPIRIT
acef0936cb300462
2542 ALBANY AVE, WEST HARTFORD, CT, 06117860236223641.78586, -72.747712026-10-082026-11-12
overtureHarvey's Wine and Spirit Shoppe
fd9dc8d3-a0b7-4d95-81f5-131f65e354eb
2542 Albany Ave, West Hartford, CT, 06117860236223641.78617, -72.749052026-11-062026-11-12
vtinfoHARVEYS WINE & SPIRIT
61b609b626d9339f
2542 ALBANY AVE, WEST HARTFORD, CT, 06117860236223641.78586, -72.747712026-11-112026-11-13

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 HARVEYS WINE & SPIRIThemp HARVEYS WINE & SPIRIT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev HARVEYS WINE & SPIRITvtinfo HARVEYS WINE & SPIRIT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ct-dcp HARVEY'S WINE & SPIRIT SHOPPEoverture Harvey's Wine and Spirit Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 140 m apart · name similarity 1.00
hemp HARVEYS WINE & SPIRITvtinfo HARVEYS WINE & SPIRIT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00 · phone: equal
ct-dcp HARVEY'S WINE & SPIRIT SHOPPEhemp HARVEYS WINE & SPIRIT0.80Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same name variant, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records are at 2542 Albany Ave in West Hartford 06117, and the names are nearly identical (HARVEY'S WINE & SPIRIT SHOPPE vs HARVEYS WINE & SPIRIT), so this is most likely one liquor shop listed by the licence source and the hemp finder, though the other business at that address keeps this from being certain.
pair 2a44239d5928c90f5b43
ct-dcp HARVEY'S WINE & SPIRIT SHOPPEvtinfo HARVEYS WINE & SPIRIT0.80Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
Same Harvey's Wine & Spirit name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 2542 Albany Ave, West Hartford CT 06117 and the names match closely (HARVEY'S WINE & SPIRIT SHOPPE vs HARVEYS WINE & SPIRIT), with the CT licence's legal entity and the VIP brand finder account describing the same independent liquor shop; the address is shared with another business, but the names agree, so this is one outlet.
pair 31c5810c8dddfeab60bc

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HOWARD-ADAM CORPORATION — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CT LIP
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
35 within 1 mi · 335 within 3 mi
Off / on premise
14 / 14 within 1 mi · 79 / 187 within 3 mi
Selling alcohol
21 within 1 mi · 199 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.09 mi
Setting
suburban (2,808 people per sq mi)
People within 3 mi
79,392 (59,437 adults 21+, 32,779 households) from 22 tract(s), tracts within 3 mi
Income
per capita $60,219 · median household ~$107,972 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 53%
Ethnicity
Hispanic 15% · White 52% · Black 27% · Asian 5%
Adults per alcohol outlet
297
Alcohol spend within 3 mi
$25,646,818 a year ($11,337,938 at home, $14,298,939 away) · $128,234 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:37insertct-dcp CT|LIP.0012448 ↔ vtinfo 61b609b626d9339fClaude judge: samemerged17
2026-11-12 17:29insertct-dcp CT|LIP.0012448 ↔ hemp acef0936cb300462Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 179894 ↔ hemp acef0936cb300462same address and namemerged12
2026-11-12 14:25insertab-inbev 179894 ↔ vtinfo 61b609b626d9339fsame address and namemerged12
2026-11-11 12:56inserthemp acef0936cb300462 ↔ vtinfo 61b609b626d9339fsame address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIP.0012448 ↔ overture fd9dc8d3-a0b7-4d95-81f5-131f65e354ebsame address and namemerged11