BOBBYS WINE & LIQUOR

HARTFORD, CT 06106 · O1870b3c207f4 · first seen 2026-11-03
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
BOBBYS WINE & LIQUOR 3 other
the most common name a source states
BOBBY'S WINE & LIQUOR ct-dcp
Bobby's Wine and Liquor overture
J & G SATNAM LLC ct-dcp (legal name)
Street
33 NEW BRITAIN AVE
ct-dcpno other value
City
HARTFORD
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06106 1 other
ct-dcp
06114 vtinfo
Pin
41.74660, -72.68435 map
overtureno other value
Phone
8602162975
vtinfono other value
Licences
ct-dcp CT|LIP.0015581
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odd2505c018ed; Oe00d8bd5ee78; O8ba4f9589d5f

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-inbevBOBBYS WINE & LIQUOR
4786937
33 NEW BRITAIN AVE, HARTFORD, CT, 0610641.74685, -72.684092026-11-112026-11-11
ct-dcpBOBBY'S WINE & LIQUOR
legal name: J & G SATNAM LLC
CT|LIP.0015581
33 NEW BRITAIN AVE, HARTFORD, CT, 0610641.74672, -72.684292026-11-032026-11-11
overtureBobby's Wine and Liquor
57f71da7-1cb9-4ef6-aa69-d2383c0fb3c5
33 New Britain Ave, Hartford, CT, 06106860216297541.74660, -72.684352026-11-062026-11-11
vtinfoBOBBYS WINE & LIQUOR
7f950e62e7f97401
33 NEW BRITAIN AVE, HARTFORD, CT, 06114860216297541.74660, -72.684302026-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 BOBBYS WINE & LIQUORct-dcp BOBBY'S WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev BOBBYS WINE & LIQUORoverture Bobby's Wine and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ab-inbev BOBBYS WINE & LIQUORvtinfo BOBBYS WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
ct-dcp BOBBY'S WINE & LIQUORoverture Bobby's Wine and 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 BOBBY'S WINE & LIQUORvtinfo BOBBYS WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00
overture Bobby's Wine and Liquorvtinfo BOBBYS WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00 · phone: equal

Attributes

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

Trade area

Other outlets
184 within 1 mi · 828 within 3 mi
Off / on premise
41 / 99 within 1 mi · 187 / 431 within 3 mi
Selling alcohol
108 within 1 mi · 486 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.06 mi
Setting
urban (5,086 people per sq mi)
People within 3 mi
143,807 (105,701 adults 21+, 61,786 households) from 45 tract(s), tracts within 3 mi
Income
per capita $35,457 · median household ~$61,356 (weighted mean of tract medians)
Age and education
median age ~35.7 · bachelor's or higher 30%
Ethnicity
Hispanic 41% · White 37% · Black 24% · Asian 4%
Adults per alcohol outlet
217
Alcohol spend within 3 mi
$34,200,505 a year ($16,176,229 at home, $18,006,227 away) · $70,227 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-11 12:56insertoverture 57f71da7-1cb9-4ef6-aa69-d2383c0fb3c5 ↔ vtinfo 7f950e62e7f97401same address and namemerged12
2026-11-11 12:56insertab-inbev 4786937 ↔ vtinfo 7f950e62e7f97401same address and namemerged12
2026-11-11 12:56insertct-dcp CT|LIP.0015581 ↔ vtinfo 7f950e62e7f97401same address and namemerged12
2026-11-11 12:56insertab-inbev 4786937 ↔ overture 57f71da7-1cb9-4ef6-aa69-d2383c0fb3c5same address and namemerged12
2026-11-11 12:56insertab-inbev 4786937 ↔ ct-dcp CT|LIP.0015581same address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIP.0015581 ↔ overture 57f71da7-1cb9-4ef6-aa69-d2383c0fb3c5same address and namemerged11