Bottoms Up Package Store

HAMDEN, CT 06518 · O44c8166acf85 · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: BOTTOMS UP PACKAGE 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
Bottoms Up Package Store 2 other
a source's own spelling of the licence name (record_title.py)
bottom's up hamden doordash
BOTTOMS UP WINE & SPIRITS LLC ct-dcp (legal name)
Street
3540 WHITNEY AVE 1 other
ct-dcp
3540 Whitney Avenue doordash
City
HAMDEN
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06518
ct-dcpno other value
Pin
41.42235, -72.90546 map
ubereatsno other value
Phone
2039922007
overtureno other value
Licences
ct-dcp CT|LIP.0015038
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O96353c938436; Obe9745c6e973; O578b55c61a5c; Oe7e6ea5d0ccb

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-inbevBOTTOMS UP PACKAGE STORE
3573102
3540 WHITNEY AVE, HAMDEN, CT, 0651841.42260, -72.905442026-11-112026-11-11
ct-dcpBOTTOMS UP PACKAGE STORE
legal name: BOTTOMS UP WINE & SPIRITS LLC
CT|LIP.0015038
3540 WHITNEY AVE, HAMDEN, CT, 0651841.42215, -72.905302026-11-032026-11-06
doordashbottom's up hamden
25113987
3540 Whitney Avenue, Hamden, CT, 0651841.42236, -72.905522026-10-082026-11-06
overtureBottoms Up Package Store
d7e8ce0e-2edd-4d30-9d1d-73316b95a703
3540 Whitney Ave, Hamden, CT, 06518203992200741.42233, -72.905432026-11-062026-11-06
ubereatsBOTTOMS UP PACKAGE STORE
iPiFDRoDVPqXb4e0JIvc4w
3540 WHITNEY AVE, HAMDEN, CT, 0651841.42235, -72.905462026-10-162026-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
ab-inbev BOTTOMS UP PACKAGE STOREct-dcp BOTTOMS UP PACKAGE STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 52 m apart · name similarity 1.00
ab-inbev BOTTOMS UP PACKAGE STOREoverture Bottoms Up Package Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev BOTTOMS UP PACKAGE STOREubereats BOTTOMS UP PACKAGE STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ct-dcp BOTTOMS UP PACKAGE STOREoverture Bottoms Up Package Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ct-dcp BOTTOMS UP PACKAGE STOREubereats BOTTOMS UP PACKAGE STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Bottoms Up Package Storeubereats BOTTOMS UP PACKAGE STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ab-inbev BOTTOMS UP PACKAGE STOREdoordash bottom's up hamden0.69Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Bottoms Up name, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address (3540 Whitney Avenue, Hamden CT 06518) with a near-identical coordinate match of 0.028 km, no other business at the address, and the names 'Bottoms Up Package Store' and 'bottom's up hamden' are the same liquor outlet.
pair 1e151d8246e461a8d3f0
doordash bottom's up hamdenubereats BOTTOMS UP PACKAGE STORE0.45Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “same-address” pair)
The DoorDash slug 'bottom's up hamden' is the name 'Bottoms Up' with the city appended, and both records give 3540 Whitney Ave, Hamden 06518, 5 m apart, so the names agree despite the shared building.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 3540 Whitney Avenue in Hamden, CT, 5 meters apart, and the DoorDash slug 'bottom's up hamden' matches the Uber Eats name 'BOTTOMS UP PACKAGE STORE', which is a single independent store rather than a chain; the shared building (two businesses at the address) lowers confidence slightly but the names agree.
pair a23a27ab4c67d2271b8a

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
BOTTOMS UP PACKAGE STORE — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
BOTTOMS UP WINE & SPIRITS LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CT LIP
Rule version 10, computed 2026-11-18 20:36.
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
14 within 1 mi · 76 within 3 mi
Off / on premise
2 / 8 within 1 mi · 13 / 43 within 3 mi
Selling alcohol
8 within 1 mi · 47 within 3 mi
Nearest
same channel 0.56 mi · licensed 0.37 mi
Setting
suburban (959 people per sq mi)
People within 3 mi
27,125 (19,387 adults 21+, 9,394 households) from 5 tract(s), tracts within 3 mi
Income
per capita $49,297 · median household ~$116,880 (weighted mean of tract medians)
Age and education
median age ~34.7 · bachelor's or higher 50%
Ethnicity
Hispanic 8% · White 70% · Black 14% · Asian 5%
Adults per alcohol outlet
404
Alcohol spend within 3 mi
$8,020,085 a year ($3,549,407 at home, $4,467,213 away) · $167,085 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-12 17:29insertab-inbev 3573102 ↔ doordash 25113987Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 3573102 ↔ overture d7e8ce0e-2edd-4d30-9d1d-73316b95a703same address and namemerged12
2026-11-11 12:56insertab-inbev 3573102 ↔ ct-dcp CT|LIP.0015038same address and namemerged12
2026-11-11 12:56insertab-inbev 3573102 ↔ ubereats iPiFDRoDVPqXb4e0JIvc4wsame address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIP.0015038 ↔ overture d7e8ce0e-2edd-4d30-9d1d-73316b95a703same address and namemerged11
2026-11-06 18:13insertoverture d7e8ce0e-2edd-4d30-9d1d-73316b95a703 ↔ ubereats iPiFDRoDVPqXb4e0JIvc4wsame address and namemerged11
2026-11-03 13:33backfillct-dcp CT|LIP.0015038 ↔ ubereats iPiFDRoDVPqXb4e0JIvc4wsame address and namemerged
2026-11-02 23:02backfilldoordash 25113987 ↔ ubereats iPiFDRoDVPqXb4e0JIvc4wClaude judge: samemerged