COLLEGE WINE SHOP

NEW HAVEN, CT 06510 · O4a0ae862a826 · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: licensed1 licence460 products on the shelf

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
COLLEGE WINE SHOP 3 other
the most common name a source states
COLLEGE WINE ct-dcpoverture ×2
CHURCH STREET LLC ct-dcp (legal name)
college wines new haven doordash
Street
68 CHURCH ST
ct-dcpno other value
City
NEW HAVEN
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06510
ct-dcpno other value
Pin
41.30524, -72.92659 map
doordashno other value
Phone
2037777597
vtinfono other value
Licences
ct-dcp CT|LIP.0015936
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O74f34beea779; Of819ba9af999; O9b194c4a35d5; Of107b126b601

Carries

Products seen on this outlet’s shelf in store-level catalogs.

460products placed
1,908listings
1,448listings with no product match yet
doordashfrom
Showing 60 of 1,908 listings: matched products first.
ProductSourcePriceStockSeen
Mike's Harder Lemonade Original Premium Malt Beverage Can (23.5 fl oz)
Mike's Harder · 23.5
doordash$4.60—2026-11-11
Chum Churum Peach Better Tomorrow Morning Soju Bottle (375 ml)
375
doordash$11.99—2026-11-11
Jose Cuervo Authentic Cuervo Margarita Grapefruit Tangerine RTD Cocktail Bottles (200 ml x 4 ct)
200
doordash$16.40—2026-11-11
Four Loko Strawberry Lemonade, Single, 23.5 oz Can
Four Loko · 1.0
doordash$4.60—2026-11-11
Angry Orchard Crisp Apple Hard Cider Bottles (12 fl oz x 6 ct)
72
doordash$16.99—2026-11-11
Sutter Home California White Zinfandel Plastic Bottles (187 ml x 4 ct)
748
doordash$11.99—2026-11-11
High Noon Zero Sugar Vodka Hard Seltzer Cans Variety Pack (12 fl oz x 12 ct)
HIGH NOON · 144
doordash$39.99—2026-11-11
Modelo Chelada Pina Picante Mexican Import Beer Can (24 fl oz)
24
doordash$4.60—2026-11-11
Grand Marnier 80 Proof Cordon Rouge Liqueur Bottle (200 ml)
200
doordash$16.99—2026-11-11
Twisted Tea Extreme Blue Razz Hard Iced Tea Can (24 fl oz)
24
doordash$4.60—2026-11-11
Four Loko Pregame Lemonade
Four Loko · 200
doordash$3.35—2026-11-11
Simply Spiked Variety 12pk 12oz Can
Simply Spiked · 144
doordash$26.99—2026-11-11
Barefoot California Sweet Red Blend Bottle (750 ml)
Barefoot · 750
doordash$10.99—2026-11-11
Barefoot Shatterproof California Moscato Bottles (187 ml x 4 ct)
748
doordash$12.99—2026-11-11
Buzzballz Chillers Peach Chiller Orange Texas Wine Based Cocktail, 187 ml
BuzzBallz · 1.0
doordash$5.10—2026-11-11
Modelo Chelada Limon y Sal Mexican Import Lager Can (24 fl oz)
Modelo Chelada · 24
doordash$4.60—2026-11-11
Sun Cruiser Iced Tea Variety 12 Pack
Sun Cruiser · 1.0
doordash$37.99—2026-11-11
Jose Cuervo Authentic Watermelon Margarita RTD Bottles (200 ml x 4 ct)
800
doordash$15.99—2026-11-11
Gautier VS Cognac (375 ml)
Gautier · 375
doordash$27.99—2026-11-11
Grand Marnier 80 Proof Cordon Rouge Orange Liqueur with Cognac Bottle (375 ml)
375
doordash$30.99—2026-11-11
Angry Orchard Gluten Free Thriller Mix Hard Cider Variety Pack Cans (12 fl oz x 12 ct)
144
doordash$26.99—2026-11-11
Cutwater Cocktails Gluten Free Lime Margarita Cocktail Cans (12 fl oz x 4 ct)
48
doordash$18.99—2026-11-11
Mike's Hard Lemonade Premium Malt Beverage Cans Variety Pack (12 fl oz x 12 ct)
Mike's Hard Lemonade · 144
doordash$26.99—2026-11-11
Mike's Hard Lemonade Classic Collection Malt Beverage Bottles Variety Pack (11.2 fl oz × 12 ct)
Mike's Hard Lemonade · 134.4
doordash$27.99—2026-11-11
Jack Daniel's Country Cocktails Watermelon Punch Malt Beverage (10 fl oz x 6 ct)
Jack Daniel Country Cocktails · 60
doordash$16.99—2026-11-11
White Claw Gluten Free Black Cherry Hard Seltzer Can Utah (19.2 fl oz)
White Claw · 19.2
doordash$4.60—2026-11-11
CAYMAN JACK ZERO SUGAR 6PK BTL 12OZ
Cayman Jack · 1.0
doordash$16.99—2026-11-11
White Claw Gluten-Free Blood Orange Surge Hard Seltzer Can (19.2 fl oz)
White Claw · 19.2
doordash$4.60—2026-11-11
Andre Pink Moscato Champagne Bottle California (750 ml)
Andre · 750
doordash$14.99—2026-11-11
Roscato Sparkling Sweet Rosso Dolce Red Wine Bottle Italy (750 ml)
Roscato · 750
doordash$24.99—2026-11-11
Cutwater Cocktails Gluten Free Mango Margarita Cans (12 fl oz x 4 ct)
Cutwater Spirits · 48
doordash$18.99—2026-11-11
Cayman Jack Premium Malt Beverage RTD Cans Variety Pack (12 fl oz x 12 ct)
Cayman Jack · 144
doordash$26.99—2026-11-11
Jack Daniel's Tennessee Whiskey & Coca-Cola RTD Cocktail Cans (355 ml × 4 ct)
1420
doordash$19.99—2026-11-11
BuzzBallz Chillers Lime 'Rita Chiller Agave Wine Cocktail (187 ml)
BuzzBallz · 187
doordash$5.10—2026-11-11
High Noon Gluten Free No Added Sugar Mango Vodka Seltzer Cans (12 fl oz x 4 ct)
48
doordash$17.99—2026-11-11
Jose Cuervo Authentic Cuervo Strawberry Lime Margarita RTD Bottle (375 ml)
CUERVO · 375
doordash$7.99—2026-11-11
Jose Cuervo Authentic Cuervo Pink Lemonade Margarita RTD Bottles (200 ml x 4 ct)
800
doordash$15.99—2026-11-11
Sutter Home Lemonade California Wine Cocktail Plastic Bottles (187 ml x 4 ct)
Sutter Home · 748
doordash$11.99—2026-11-11
Rémy Martin 1738 80 Proof Fine Champagne Cognac Bottle (50 ml)
Remy Martin · 50
doordash$7.95—2026-11-11
E & J Brandy 80 Proof VS Brandy Bottle (200 ml)
E&J Brandy · 200
doordash$5.99—2026-11-11
E & J Brandy 80 Proof Original Extra Smooth Brandy Bottle (50 ml)
50
doordash$1.80—2026-11-11
E & J Brandy Peach Flavored Brandy Bottle (50 ml)
50
doordash$1.80—2026-11-11
Cutwater Cocktails Gluten Free Lemon Drop Martini Cans (12 fl oz x 4 ct)
Cutwater Spirits · 48
doordash$18.99—2026-11-11
Cutwater Cocktails Pineapple Margarita Cans (12 fl oz x 4 ct)
Cutwater Spirits · 48
doordash$18.99—2026-11-11
Four Loko Sour Apple (23.5 oz)
Four Loko · 23.5
doordash$4.60—2026-11-11
Surfside Iced Tea Vodka RTD Cocktails Variety Pack (12 fl oz × 8 ct)
Surfside · 96
doordash$27.99—2026-11-11
Twisted Tea Half & Half Hard Iced Tea Flavored Malt Beverage Pack (12 oz x 12 ct)
144
doordash$27.99—2026-11-11
Four Loko Watermelon Malt Beverage Can (23.5 fl oz)
Four Loko · 23.5
doordash$4.60—2026-11-11
Cutwater Cocktails Strawberry Margarita Tequila Cocktail Cans (12 fl oz x 4 ct)
48
doordash$18.99—2026-11-11
Twisted Tea Hard Iced Tea Variety Pack (12 fl oz x 12 ct)
144
doordash$27.99—2026-11-11
Andre Strawberry Mimosa Sparkling Wine Cocktail Can (375 ml)
Andre · 375
doordash$4.99—2026-11-11
Clubtails Premium Sex on the Beach Cocktail (24 fl oz)
Clubtails · 24
doordash$4.30—2026-11-11
Arnold Palmer Spiked Half & Half Ice Tea Lemonade Flavored Malt Beverage, 12 Pack, 12 fl. oz. Cans, 5% ABV
Arnold Palmer Spiked · 1.0
doordash$27.99—2026-11-11
On The Rocks x Effen Vodka Cosmopolitan RTD Cocktail Bottle (375 ml)
375
doordash$18.99—2026-11-11
Cutwater Espresso Martini Cocktail Cans (12 fl oz x 4 ct)
Cutwater Spirits · 48
doordash$18.99—2026-11-11
Simply Spiked Straw Lemonade 24oz Can
Simply Spiked · 1.0
doordash$4.60—2026-11-11
Monaco Cocktails Watermelon Crush Premium Mixed Drink (12 fl oz)
Monaco Cocktail · 12
doordash$4.50—2026-11-11
Arnold Palmer Half & Half Lite 12pk / 12oz cans
Arnold Palmer Spiked · 1.0
doordash$27.99—2026-11-11
Sutter Home Moscato Plastic Bottles California (187 ml x 4 ct)
748
doordash$11.99—2026-11-11
Wray & Nephew 126 Proof Overproof White Rum Bottle (375 ml)
375
doordash$19.99—2026-11-11

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevCOLLEGE WINE SHOP
3154155
68 CHURCH ST, NEW HAVEN, CT, 0651041.30520, -72.926492026-11-112026-11-11
ct-dcpCOLLEGE WINE
legal name: CHURCH STREET LLC
CT|LIP.0015936
68 CHURCH ST, NEW HAVEN, CT, 0651041.30523, -72.926442026-11-032026-11-05
doordashcollege wines new haven
32122519
68 Church St, New Haven, CT, 0651041.30524, -72.926592026-10-082026-11-03
overtureCollege Wine
bd3c6123-3f34-4082-9530-ea68603d5bdb
68 Church St, New Haven, CT, 06510203777759741.30519, -72.926632026-11-062026-11-06
vtinfoCOLLEGE WINE SHOP
f831ef33e2be2b0a
68 CHURCH ST, NEW HAVEN, CT, 06510203777759741.30514, -72.926652026-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 COLLEGE WINE SHOPct-dcp COLLEGE WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev COLLEGE WINE SHOPoverture College Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev COLLEGE WINE SHOPvtinfo COLLEGE WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
ct-dcp COLLEGE WINEoverture College Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ct-dcp COLLEGE WINEvtinfo COLLEGE WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
overture College Winevtinfo COLLEGE WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: equal
ab-inbev COLLEGE WINE SHOPdoordash college wines new haven0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.65
ct-dcp COLLEGE WINEdoordash college wines new haven0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · name similarity 0.65
doordash college wines new havenoverture College Wine0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 7 m apart · name similarity 0.65
doordash college wines new havenvtinfo COLLEGE WINE SHOP0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 13 m apart · name similarity 0.65

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CHURCH STREET 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:17.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
250 within 1 mi · 548 within 3 mi
Off / on premise
28 / 120 within 1 mi · 116 / 249 within 3 mi
Selling alcohol
159 within 1 mi · 362 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (5,521 people per sq mi)
People within 3 mi
156,089 (110,959 adults 21+, 62,344 households) from 36 tract(s), tracts within 3 mi
Income
per capita $35,550 · median household ~$62,507 (weighted mean of tract medians)
Age and education
median age ~33.3 · bachelor's or higher 38%
Ethnicity
Hispanic 31% · White 34% · Black 30% · Asian 5%
Adults per alcohol outlet
306
Alcohol spend within 3 mi
$35,631,642 a year ($16,695,832 at home, $18,918,412 away) · $98,159 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 14:25insertdoordash 32122519 ↔ vtinfo f831ef33e2be2b0asame address and namemerged12
2026-11-12 14:25insertab-inbev 3154155 ↔ vtinfo f831ef33e2be2b0asame address and namemerged12
2026-11-12 14:25insertct-dcp CT|LIP.0015936 ↔ vtinfo f831ef33e2be2b0asame address and namemerged12
2026-11-12 14:25insertoverture bd3c6123-3f34-4082-9530-ea68603d5bdb ↔ vtinfo f831ef33e2be2b0asame address and namemerged12
2026-11-11 12:56insertab-inbev 3154155 ↔ doordash 32122519same address and namemerged12
2026-11-11 12:56insertab-inbev 3154155 ↔ ct-dcp CT|LIP.0015936same address and namemerged12
2026-11-11 12:56insertab-inbev 3154155 ↔ overture bd3c6123-3f34-4082-9530-ea68603d5bdbsame address and namemerged12
2026-11-06 18:13insertdoordash 32122519 ↔ overture bd3c6123-3f34-4082-9530-ea68603d5bdbsame address and namemerged11
2026-11-06 18:13insertct-dcp CT|LIP.0015936 ↔ overture bd3c6123-3f34-4082-9530-ea68603d5bdbsame address and namemerged11
2026-11-03 13:33backfillct-dcp CT|LIP.0015936 ↔ doordash 32122519same address and namemerged