Missing Link Wine

BERLIN, CT 06037 · O032259cf2872 · first seen 2026-11-03
2 sourcesoff premise · liquor_storealcohol: licensed3 licences

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
Missing Link Wine 2 other
a licence name in capitals, cleaned (derived; record_title.py)
A MISSING LINK LLC ct-dcp (legal name)ttb (legal name) ×3
MISSING LINK WINE COMPANY ct-dcpttb ×3
Street
496 FOUR ROD RD UNIT 2
ct-dcpno other value
City
BERLIN
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06037
ct-dcpno other value
Pin
41.61883, -72.76600 map
ct-dcpno other value
Phone
none
no other value
Licences
ct-dcp CT|LCL.0000610 · ct-dcp CT|LIW.0000659 · ttb CT-P-15119
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O980e80168ffd; O81c3b3f25882

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-dcpMISSING LINK WINE COMPANY
legal name: A MISSING LINK LLC
CT|LCL.0000610
496 FOUR ROD RD UNIT 2, BERLIN, CT, 0603741.61883, -72.766002026-11-032026-11-05
ct-dcpMISSING LINK WINE COMPANY
legal name: A MISSING LINK LLC
CT|LIW.0000659
496 FOUR ROD RD UNIT 2, BERLIN, CT, 0603741.61883, -72.766002026-11-032026-11-05
ttbMISSING LINK WINE COMPANY
legal name: A MISSING LINK, LLC
CT-P-15119
496 FOUR ROD RD UNIT 2, BERLIN, CT, 0603741.61883, -72.766002026-11-032026-11-05

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 MISSING LINK WINE COMPANYct-dcp MISSING LINK WINE COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ct-dcp MISSING LINK WINE COMPANYttb MISSING LINK WINE COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ct-dcp MISSING LINK WINE COMPANYttb MISSING LINK WINE COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
A MISSING LINK LLC — 1 outlets in the master under this operator
Licence privileges
none — CT LCL; CT LIW
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
25 within 1 mi · 170 within 3 mi
Off / on premise
8 / 12 within 1 mi · 46 / 80 within 3 mi
Selling alcohol
14 within 1 mi · 91 within 3 mi
Nearest
same channel 0.85 mi · licensed 0.01 mi
Setting
suburban (1,288 people per sq mi)
People within 3 mi
36,419 (27,782 adults 21+, 14,833 households) from 8 tract(s), tracts within 3 mi
Income
per capita $46,699 · median household ~$96,633 (weighted mean of tract medians)
Age and education
median age ~41.7 · bachelor's or higher 33%
Ethnicity
Hispanic 24% · White 68% · Black 7% · Asian 2%
Adults per alcohol outlet
302
Alcohol spend within 3 mi
$10,669,921 a year ($4,824,581 at home, $5,841,288 away) · $115,977 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-03 13:33backfillct-dcp CT|LIW.0000659 ↔ ttb CT-P-15119same address and namemerged
2026-11-03 13:33backfillct-dcp CT|LCL.0000610 ↔ ttb CT-P-15119same address and namemerged
2026-11-03 13:33backfillct-dcp CT|LCL.0000610 ↔ ct-dcp CT|LIW.0000659one store listed twicemerged