YE OLD LIQUOR SHOPPE

WEST HAVEN, CT 06516 · O07e1f99d087d · first seen 2026-10-08
7 sourcesoff premise · liquor_storechain: Ye Old Spiritsalcohol: 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
YE OLD LIQUOR SHOPPE 3 other
the most common name a source states
YE OLD SPIRITS ct-dcpovertureubereats ×3
NJC HOLDINGS LLC ct-dcp (legal name)
ye old spirits west haven doordash
Street
174 MAIN ST 1 other
ct-dcp
174 Main Street doordash
City
WEST HAVEN
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06516
ct-dcpno other value
Pin
41.27434, -72.94350 map 1 other
ubereats
58 m away ab-inbev
Phone
2039332775 1 other
hemp
2033905913 overture
Licences
ct-dcp CT|LIP.0016047
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O58fd7ef8aafe; Oa1282765d2b5; O464e94db5279; O0b6ad43de097; O5d0e89a4902e; O8cbb4a2cea21; O8e8bff1737cc

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-inbevYE OLD LIQUOR SHOPPE
2453227
174 MAIN ST, WEST HAVEN, CT, 0651641.27463, -72.942922026-11-112026-11-11
ct-dcpYE OLD SPIRITS
legal name: NJC HOLDINGS LLC
CT|LIP.0016047
174 MAIN ST, WEST HAVEN, CT, 0651641.27446, -72.943482026-11-032026-11-06
doordashye old spirits west haven
24709834
174 Main Street, West Haven, CT, 0651641.27425, -72.943542026-10-082026-11-06
hempYE OLD LIQUOR SHOPPE
25e93727261aba42
174 MAIN ST, WEST HAVEN, CT, 06516203933277541.27437, -72.943582026-10-082026-11-06
overtureYe Old Spirits
e2198484-11ad-4aba-aa13-37a9a2211cdc
174 Main St, West Haven, CT, 06516203390591341.27433, -72.943392026-11-062026-11-09
ubereatsYe Old Spirits
ZZDiXLO4WGCGiyOv3qeDog
174 Main St, West Haven, CT, 0651641.27434, -72.943502026-10-092026-11-06
vtinfoYE OLD LIQUOR SHOPPE
b44db9fdb3cdfd81
174 MAIN ST, WEST HAVEN, CT, 06516203933277541.27437, -72.943582026-11-122026-11-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 YE OLD LIQUOR SHOPPEhemp YE OLD LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00
ab-inbev YE OLD LIQUOR SHOPPEvtinfo YE OLD LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 62 m apart · name similarity 1.00
ct-dcp YE OLD SPIRITSdoordash ye old spirits west haven1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ct-dcp YE OLD SPIRITSoverture Ye Old Spirits1.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 YE OLD SPIRITSubereats Ye Old Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash ye old spirits west havenoverture Ye Old Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
doordash ye old spirits west havenubereats Ye Old Spirits1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
hemp YE OLD LIQUOR SHOPPEoverture 37920587-ec2f-4e17-b3e6-3aa8cfa21df61.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 · phone: equal
hemp YE OLD LIQUOR SHOPPEvtinfo YE OLD LIQUOR SHOPPE1.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
overture Ye Old Spiritsubereats Ye Old Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev YE OLD LIQUOR SHOPPEdoordash ye old spirits west haven0.47Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Ye Old liquor/spirits, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records give the same street address (174 Main Street, West Haven, CT 06516) with no other business at that address, and the names 'Ye Old Liquor Shoppe' and 'ye old spirits west haven' share the distinctive 'ye old' branding, so they most likely describe one liquor outlet listed by an alcohol-focused source and a delivery app.
pair 3c56eb3690bbc5403078
doordash ye old spirits west havenhemp YE OLD LIQUOR SHOPPE0.47Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records are at 174 Main St, West Haven, CT, only 13 m apart, and our data holds a single business there; 'Ye Old Spirits' and 'Ye Old Liquor Shoppe' share the distinctive 'Ye Old' name of one liq
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records sit at 174 Main Street, West Haven CT 06516 with coordinates about 13 m apart, and the only business at that address is the same, so 'ye old spirits' (DoorDash slug) and 'YE OLD LIQUOR SHOPPE' (hemp finder) look like one independent shop under different names, though the names differ and the hemp listing gives no further proof.
pair dbc6378d466ddd7650fc
hemp YE OLD LIQUOR SHOPPEubereats Ye Old Spirits0.47Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records sit at the same street address, 174 Main St, West Haven CT, which our data shows holds only one business, and the names 'Ye Old Liquor Shoppe' and 'Ye Old Spirits' share the distinctive '
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 82% confident — Both records sit at 174 Main St, West Haven, CT 06516, with coordinates about 7 m apart and only one business in our data at that address, and the names share the distinctive 'Ye Old' prefix, so this is most likely one liquor shop listed under two names (hemp listing vs Uber Eats trade name), though the differing second word leaves some doubt.
pair 86fac3285e5c71131b21

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
Ye Old Spirits — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
NJC HOLDINGS 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"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
71 within 1 mi · 459 within 3 mi
Off / on premise
10 / 38 within 1 mi · 87 / 217 within 3 mi
Selling alcohol
47 within 1 mi · 283 within 3 mi
Nearest
same channel 0.31 mi · licensed 0.09 mi
Setting
urban (3,829 people per sq mi)
People within 3 mi
108,276 (77,730 adults 21+, 42,756 households) from 26 tract(s), tracts within 3 mi
Income
per capita $34,069 · median household ~$66,816 (weighted mean of tract medians)
Age and education
median age ~34.4 · bachelor's or higher 34%
Ethnicity
Hispanic 30% · White 42% · Black 23% · Asian 7%
Adults per alcohol outlet
274
Alcohol spend within 3 mi
$24,590,352 a year ($11,548,184 at home, $13,029,921 away) · $86,586 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 2453227 ↔ doordash 24709834Claude judge: samemerged14
2026-11-12 14:25inserthemp 25e93727261aba42 ↔ vtinfo b44db9fdb3cdfd81same address and namemerged12
2026-11-12 14:25insertab-inbev 2453227 ↔ vtinfo b44db9fdb3cdfd81same address and namemerged12
2026-11-11 12:56insertab-inbev 2453227 ↔ hemp 25e93727261aba42same address and namemerged12
2026-11-09 15:32updatect-dcp CT|LIP.0016047 ↔ overture e2198484-11ad-4aba-aa13-37a9a2211cdcsame address and namemerged11
2026-11-09 15:32updateoverture e2198484-11ad-4aba-aa13-37a9a2211cdc ↔ ubereats ZZDiXLO4WGCGiyOv3qeDogsame address and namemerged11
2026-11-09 15:32updatedoordash 24709834 ↔ overture e2198484-11ad-4aba-aa13-37a9a2211cdcsame address and namemerged11
2026-11-06 18:13insertct-dcp CT|LIP.0016047 ↔ overture e2198484-11ad-4aba-aa13-37a9a2211cdcsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 24709834 ↔ overture e2198484-11ad-4aba-aa13-37a9a2211cdcsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture e2198484-11ad-4aba-aa13-37a9a2211cdc ↔ ubereats ZZDiXLO4WGCGiyOv3qeDogsame address and nameheld: same-source-conflict11
2026-11-06 18:13inserthemp 25e93727261aba42 ↔ overture 37920587-ec2f-4e17-b3e6-3aa8cfa21df6same address and namemerged11
2026-11-03 13:33backfillct-dcp CT|LIP.0016047 ↔ doordash 24709834same address and namemerged
2026-11-03 13:33backfillct-dcp CT|LIP.0016047 ↔ ubereats ZZDiXLO4WGCGiyOv3qeDogsame address and namemerged
2026-11-02 23:02backfilldoordash 24709834 ↔ hemp 25e93727261aba42Claude judge: samemerged
2026-11-02 23:02backfillhemp 25e93727261aba42 ↔ ubereats ZZDiXLO4WGCGiyOv3qeDogClaude judge: samemerged
2026-10-09 13:59backfilldoordash 24709834 ↔ ubereats ZZDiXLO4WGCGiyOv3qeDogsame address and namemerged