Pappy's Cafe

EAST HARTFORD, CT 06108 · O059956a47cca · 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
Pappy's Cafe 3 other
a source's own spelling of the licence name (record_title.py)
PAPPYS CAFE ab-inbevvtinfo ×2
PAPPYS ct-dcp
RANCOURT ENTERPRISES INC ct-dcp (legal name)
Street
37 BURNSIDE AVENUE 1 other
ct-dcp
37 BURNSIDE AVE ab-inbevoverturevtinfo ×3
City
EAST HARTFORD
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06108
ct-dcpno other value
Pin
41.77418, -72.63855 map
overtureno other value
Phone
8602892869
vtinfono other value
Licences
ct-dcp CT|LCA.0005708
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob9c5c8da21cc; O8e1f1c93dcc7; O31f8a25d7688

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-inbevPAPPYS CAFE
180374
37 BURNSIDE AVE, EAST HARTFORD, CT, 0610841.77424, -72.638662026-11-112026-11-11
ct-dcpPAPPYS
legal name: RANCOURT ENTERPRISES INC
CT|LCA.0005708
37 BURNSIDE AVENUE, EAST HARTFORD, CT, 0610841.77430, -72.638152026-11-032026-11-12
overturePappy's Cafe
1944707f-ecf5-40d2-9ca8-e9b9d3f37500
37 Burnside Ave, East Hartford, CT, 06108860289286941.77418, -72.638552026-11-132026-11-13
vtinfoPAPPYS CAFE
335d4fb2b9cc6777
37 BURNSIDE AVE, EAST HARTFORD, CT, 06108860289286941.77418, -72.638552026-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 PAPPYS CAFEoverture Pappy's Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev PAPPYS CAFEvtinfo PAPPYS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
overture Pappy's Cafevtinfo PAPPYS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal
ab-inbev PAPPYS CAFEct-dcp PAPPYS0.60same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.59 · same street + ZIP · pins 43 m apart · name similarity 0.60
ct-dcp PAPPYSoverture Pappy's Cafe0.60same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.59 · same street + ZIP · pins 35 m apart · name similarity 0.60
ct-dcp PAPPYSvtinfo PAPPYS CAFE0.60same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.59 · same street + city + state · pins 36 m apart · name similarity 0.60

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RANCOURT ENTERPRISES INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LCA
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
54 within 1 mi · 539 within 3 mi
Off / on premise
22 / 25 within 1 mi · 125 / 258 within 3 mi
Selling alcohol
34 within 1 mi · 321 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.08 mi
Setting
urban (3,338 people per sq mi)
People within 3 mi
94,385 (68,507 adults 21+, 39,897 households) from 34 tract(s), tracts within 3 mi
Income
per capita $27,946 · median household ~$50,149 (weighted mean of tract medians)
Age and education
median age ~35.2 · bachelor's or higher 17%
Ethnicity
Hispanic 43% · White 26% · Black 34% · Asian 3%
Adults per alcohol outlet
213
Alcohol spend within 3 mi
$19,108,134 a year ($9,313,668 at home, $9,782,636 away) · $59,342 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-13 14:10insertct-dcp CT|LCA.0005708 ↔ overture 1944707f-ecf5-40d2-9ca8-e9b9d3f37500same address and namemerged15
2026-11-13 14:10insertoverture 1944707f-ecf5-40d2-9ca8-e9b9d3f37500 ↔ vtinfo 335d4fb2b9cc6777same address and namemerged15
2026-11-13 14:10insertab-inbev 180374 ↔ overture 1944707f-ecf5-40d2-9ca8-e9b9d3f37500same address and namemerged15
2026-11-12 17:29insertct-dcp CT|LCA.0005708 ↔ vtinfo 335d4fb2b9cc6777same address and namemerged14
2026-11-12 17:29insertab-inbev 180374 ↔ ct-dcp CT|LCA.0005708same address and namemerged14
2026-11-11 12:56insertab-inbev 180374 ↔ vtinfo 335d4fb2b9cc6777same address and namemerged12