Sunny Discount Liquors

PUTNAM, CT 06260 · O6e6b3c4d4efe · first seen 2026-10-08
4 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
Sunny Discount Liquors 3 other
a licence name in capitals, cleaned (derived; record_title.py)
PARI PATEL LLC ct-dcp (legal name)
Sunny Discount Liquor overture
sunny discount liquor putnam doordash
Street
150 PROVIDENCE ST
ct-dcpno other value
City
PUTNAM
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06260
ct-dcpno other value
Pin
41.92317, -71.90825 map
doordashno other value
Phone
8609285886
hempno other value
Licences
ct-dcp CT|LIP.0014488
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of1c2f0fb97a5; Ob69ba2b239bf; Of677a49499aa

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
ct-dcpSUNNY DISCOUNT LIQUORS
legal name: PARI PATEL LLC
CT|LIP.0014488
150 PROVIDENCE ST, PUTNAM, CT, 0626041.92337, -71.908292026-11-032026-11-05
doordashsunny discount liquor putnam
37011479
150 Providence St, Putnam, CT, 0626041.92317, -71.908252026-10-082026-11-03
hempSUNNY DISCOUNT LIQUORS
79e2cdd82390d30d
150 PROVIDENCE ST, PUTNAM, CT, 06260860928588641.92318, -71.908252026-10-162026-11-03
overtureSunny Discount Liquor
2d6a2d6b-0cbb-4266-aca3-440ca27a665d
150 Providence St, Putnam, CT, 06260860928588641.92327, -71.908152026-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
ct-dcp SUNNY DISCOUNT LIQUORShemp SUNNY DISCOUNT LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash sunny discount liquor putnamoverture Sunny Discount Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ct-dcp SUNNY DISCOUNT LIQUORSdoordash sunny discount liquor putnam0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · name similarity 0.74
ct-dcp SUNNY DISCOUNT LIQUORSoverture Sunny Discount Liquor0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 16 m apart · name similarity 0.74
doordash sunny discount liquor putnamhemp SUNNY DISCOUNT LIQUORS0.74Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair)
The DoorDash slug 'sunny discount liquor putnam' matches 'Sunny Discount Liquors' once the appended city is dropped, the street address (150 Providence St, Putnam) is identical, and only one business
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records give the same street address, city, state and coordinates (0.0 km apart), and the names 'sunny discount liquor putnam' and 'SUNNY DISCOUNT LIQUORS' match, with no other business at that address, so they are one liquor store.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records give the identical street address, city, state and coordinates (0.0 km apart), and the names 'sunny discount liquor' and 'SUNNY DISCOUNT LIQUORS' are the same distinctive business name with only a plural/punctuation difference, with no other business at that address.
pair 1bcfc1d6f85705bc2d66
hemp SUNNY DISCOUNT LIQUORSoverture Sunny Discount Liquor0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 14 m apart · name similarity 0.74 · phone: equal

Attributes

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

Trade area

Other outlets
40 within 1 mi · 75 within 3 mi
Off / on premise
11 / 15 within 1 mi · 21 / 28 within 3 mi
Selling alcohol
32 within 1 mi · 56 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
suburban (504 people per sq mi)
People within 3 mi
14,247 (11,421 adults 21+, 6,387 households) from 4 tract(s), tracts within 3 mi
Income
per capita $41,611 · median household ~$75,066 (weighted mean of tract medians)
Age and education
median age ~47.6 · bachelor's or higher 19%
Ethnicity
Hispanic 4% · White 88% · Black 1% · Asian 1%
Adults per alcohol outlet
200
Alcohol spend within 3 mi
$3,962,747 a year ($1,852,541 at home, $2,108,101 away) · $69,522 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:13insertct-dcp CT|LIP.0014488 ↔ overture 2d6a2d6b-0cbb-4266-aca3-440ca27a665dsame address and namemerged11
2026-11-06 18:13inserthemp 79e2cdd82390d30d ↔ overture 2d6a2d6b-0cbb-4266-aca3-440ca27a665dsame address and namemerged11
2026-11-06 18:13insertdoordash 37011479 ↔ overture 2d6a2d6b-0cbb-4266-aca3-440ca27a665dsame address and namemerged11
2026-11-03 13:33backfillct-dcp CT|LIP.0014488 ↔ doordash 37011479same address and namemerged
2026-11-03 13:33backfillct-dcp CT|LIP.0014488 ↔ hemp 79e2cdd82390d30dsame address and namemerged
2026-11-02 23:02backfilldoordash 37011479 ↔ hemp 79e2cdd82390d30dClaude judge: samemerged