Murphy's Pub & Sports Bar

CROMWELL, CT 06416 · O47a1d841032a · first seen 2026-11-03
3 sourceson premise · predictedalcohol: 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
Murphy's Pub & Sports Bar 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MURPHYS PUB & SPORTS BAR ab-inbevvtinfo ×2
MURPHY'S PUB 2, LLC ct-dcp (legal name)
MURPHY'S PUB AND SPORTS BAR ct-dcp
Street
51-14 SHUNPIKE ROAD 1 other
ct-dcp
51 SHUNPIKE RD STE 14 ab-inbevvtinfo ×2
City
CROMWELL
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06416
ct-dcpno other value
Pin
41.60004, -72.67663 map 2 other
ct-dcp
620 m away ab-inbev
409 m away vtinfo
Phone
8606351860
vtinfono other value
Licences
ct-dcp CT|LIR.0021494
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of4471e38b4ed; Ob40509ae9fe7; Od58d7278a41f

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-inbevMURPHYS PUB & SPORTS BAR
4768127
51 SHUNPIKE RD STE 14, CROMWELL, CT, 0641641.60549, -72.678212026-11-112026-11-12
ct-dcpMURPHY'S PUB AND SPORTS BAR
legal name: MURPHY'S PUB 2, LLC
CT|LIR.0021494
51-14 SHUNPIKE ROAD, CROMWELL, CT, 0641641.60004, -72.676632026-11-032026-11-18
vtinfoMURPHYS PUB & SPORTS BAR
5c0996e6305154b4
51 SHUNPIKE RD STE 14, CROMWELL, CT, 06416860635186041.60370, -72.676152026-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 MURPHYS PUB & SPORTS BARct-dcp MURPHY'S PUB AND SPORTS BAR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Same pub name, suite 14 matches 51-14
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name the same pub (Murphy's Pub and Sports Bar) at 51 Shunpike Road in Cromwell, CT, and B's '51-14' address encodes the same suite 14 as A's 'STE 14', so the names and suite agree despite the building being shared by 8 businesses.
pair c86279ac217bfca11d3b
ab-inbev MURPHYS PUB & SPORTS BARvtinfo MURPHYS PUB & SPORTS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 263 m apart · name similarity 1.00
ct-dcp MURPHY'S PUB AND SPORTS BARoverture Murphy's Pub & Sports Bar1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 641 m apart · name similarity 1.00
ct-dcp MURPHY'S PUB AND SPORTS BARvtinfo MURPHYS PUB & SPORTS BAR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Same pub name; 51-14 equals 51 Ste 14
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 88% confident — Both records name the same pub and sports bar at 51 Shunpike Rd Cromwell CT, and the '51-14' address on the ct-dcp record matches the 'Ste 14' on the vtinfo record, so the suite lines up; the names agree (Murphy's Pub and Sports Bar, with the legal entity 'Murphy's Pub 2, LLC') despite the 8 businesses sharing the building.
pair 63872f8d604281fd5788

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MURPHY'S PUB 2, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LIR
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
41 within 1 mi · 145 within 3 mi
Off / on premise
13 / 20 within 1 mi · 38 / 73 within 3 mi
Selling alcohol
21 within 1 mi · 88 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.04 mi
Setting
suburban (1,247 people per sq mi)
People within 3 mi
35,252 (28,492 adults 21+, 16,252 households) from 9 tract(s), tracts within 3 mi
Income
per capita $54,469 · median household ~$95,980 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 47%
Ethnicity
Hispanic 10% · White 69% · Black 10% · Asian 8%
Adults per alcohol outlet
320
Alcohol spend within 3 mi
$11,807,004 a year ($5,358,519 at home, $6,442,533 away) · $132,663 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-18 18:58insertab-inbev 4768127 ↔ ct-dcp CT|LIR.0021494Claude judge: samemerged15
2026-11-18 18:58insertct-dcp CT|LIR.0021494 ↔ vtinfo 5c0996e6305154b4Claude judge: samemerged15
2026-11-12 14:25insertab-inbev 4768127 ↔ vtinfo 5c0996e6305154b4same address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIR.0021494 ↔ overture 1b2532fb-e2b2-4236-94b6-29cbe1a5688csame address and namemerged11