Pigs Eye Pub

HARTFORD, CT 06103 · O7e2d1155f711 · first seen 2026-11-03
4 sourceson premise · baralcohol: 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
Pigs Eye Pub 1 other
a source's own spelling of the licence name (record_title.py)
PIG'S EYE PUB ct-dcp
Street
356 ASYLUM STREET 1 other
ct-dcp
356 ASYLUM ST ab-inbevoverturevtinfo ×3
City
HARTFORD
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06103
ct-dcpno other value
Pin
41.76771, -72.67955 map
overtureno other value
Phone
8602784747
vtinfono other value
Licences
ct-dcp CT|LCA.0005995
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaff19c3fac97; Oc2a348b34658; Oe84445139361

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-inbevPIGS EYE PUB
180415
356 ASYLUM ST, HARTFORD, CT, 0610341.76760, -72.679012026-11-112026-11-11
ct-dcpPIG'S EYE PUB
CT|LCA.0005995
356 ASYLUM STREET, HARTFORD, CT, 0610341.76762, -72.679352026-11-032026-11-04
overturePigs Eye Pub
44939dc6-58bb-48a6-a50f-b3c7daef478d
356 Asylum St, Hartford, CT, 06103860278474741.76771, -72.679552026-11-062026-11-06
vtinfoPIGS EYE PUB
906db79f4d8fb5b1
356 ASYLUM ST, HARTFORD, CT, 06103860278474741.76769, -72.679632026-11-112026-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 PIGS EYE PUBct-dcp PIG'S EYE PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
ab-inbev PIGS EYE PUBoverture Pigs Eye Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00
ab-inbev PIGS EYE PUBvtinfo PIGS EYE PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ct-dcp PIG'S EYE PUBoverture Pigs Eye Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ct-dcp PIG'S EYE PUBvtinfo PIGS EYE PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
overture Pigs Eye Pubvtinfo PIGS EYE PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LCA
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
240 within 1 mi · 803 within 3 mi
Off / on premise
34 / 124 within 1 mi · 176 / 418 within 3 mi
Selling alcohol
140 within 1 mi · 467 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (5,641 people per sq mi)
People within 3 mi
159,482 (115,263 adults 21+, 65,897 households) from 51 tract(s), tracts within 3 mi
Income
per capita $33,732 · median household ~$58,127 (weighted mean of tract medians)
Age and education
median age ~35.3 · bachelor's or higher 26%
Ethnicity
Hispanic 40% · White 31% · Black 32% · Asian 3%
Adults per alcohol outlet
246
Alcohol spend within 3 mi
$35,174,329 a year ($16,719,313 at home, $18,436,913 away) · $75,159 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:56insertab-inbev 180415 ↔ vtinfo 906db79f4d8fb5b1same address and namemerged12
2026-11-11 12:56insertct-dcp CT|LCA.0005995 ↔ vtinfo 906db79f4d8fb5b1same address and namemerged12
2026-11-11 12:56insertoverture 44939dc6-58bb-48a6-a50f-b3c7daef478d ↔ vtinfo 906db79f4d8fb5b1same address and namemerged12
2026-11-11 12:56insertab-inbev 180415 ↔ ct-dcp CT|LCA.0005995same address and namemerged12
2026-11-11 12:56insertab-inbev 180415 ↔ overture 44939dc6-58bb-48a6-a50f-b3c7daef478dsame address and namemerged12
2026-11-06 18:13insertct-dcp CT|LCA.0005995 ↔ overture 44939dc6-58bb-48a6-a50f-b3c7daef478dsame address and namemerged11