Piggy's Cafe

HARTFORD, CT 06105 · O3fcc62729b22 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Piggy's Cafe 3 other
a source's own spelling of the licence name (record_title.py)
PIGGYS CAFE ab-inbevvtinfo ×2
FREEMAN HOSPITALITY GROUP LIMITED LIABILITY COMPANY ct-dcp (legal name)
piggys cafe hartford doordash
Street
69 HAWTHORN STREET 1 other
ct-dcp
69 HAWTHORN ST ab-inbevdoordashoverturevtinfo ×4
City
HARTFORD
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06105
ct-dcpno other value
Pin
41.76395, -72.69678 map
doordashno other value
Phone
8607289912
vtinfono other value
Licences
ct-dcp CT|LIR.0021922
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc626205f3e73; Obd8e9eebf554; Oe898f157b50b; O7203919603f8

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-inbevPIGGYS CAFE
2473507
69 HAWTHORN ST, HARTFORD, CT, 0610541.76420, -72.696282026-11-112026-11-12
ct-dcpPIGGY'S CAFE
legal name: FREEMAN HOSPITALITY GROUP LIMITED LIABILITY COMPANY
CT|LIR.0021922
69 HAWTHORN STREET, HARTFORD, CT, 0610541.76411, -72.696432026-11-032026-11-12
doordashpiggys cafe hartford
45624604
69 Hawthorn St, Hartford, CT, 0610541.76395, -72.696782026-10-082026-11-13
overturePiggy's Cafe
652a257e-bcab-49ee-bee3-1f145183c106
69 Hawthorn St, Hartford, CT, 06105860728991241.76397, -72.696822026-11-062026-11-12
vtinfoPIGGYS CAFE
15ee197d94853421
69 HAWTHORN ST, HARTFORD, CT, 06105860728991241.76396, -72.696792026-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 PIGGYS CAFEct-dcp PIGGY'S CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev PIGGYS CAFEdoordash piggys cafe hartford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ab-inbev PIGGYS CAFEoverture Piggy's Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 52 m apart · name similarity 1.00
ab-inbev PIGGYS CAFEvtinfo PIGGYS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 50 m apart · name similarity 1.00
ct-dcp PIGGY'S CAFEdoordash piggys cafe hartford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
ct-dcp PIGGY'S CAFEoverture Piggy's Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ct-dcp PIGGY'S CAFEvtinfo PIGGYS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
doordash piggys cafe hartfordoverture Piggy's Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash piggys cafe hartfordvtinfo PIGGYS 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
overture Piggy's Cafevtinfo PIGGYS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FREEMAN HOSPITALITY GROUP LIMITED LIABILITY COMPANY — 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 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
191 within 1 mi · 902 within 3 mi
Off / on premise
32 / 108 within 1 mi · 184 / 493 within 3 mi
Selling alcohol
102 within 1 mi · 522 within 3 mi
Nearest
same channel 0.24 mi · licensed 0.26 mi
Setting
urban (5,787 people per sq mi)
People within 3 mi
163,631 (117,758 adults 21+, 67,032 households) from 53 tract(s), tracts within 3 mi
Income
per capita $37,673 · median household ~$66,176 (weighted mean of tract medians)
Age and education
median age ~35.8 · bachelor's or higher 31%
Ethnicity
Hispanic 37% · White 35% · Black 29% · Asian 3%
Adults per alcohol outlet
225
Alcohol spend within 3 mi
$38,638,026 a year ($18,073,367 at home, $20,546,024 away) · $73,878 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-12 14:25insertoverture 652a257e-bcab-49ee-bee3-1f145183c106 ↔ vtinfo 15ee197d94853421same address and namemerged12
2026-11-12 14:25insertab-inbev 2473507 ↔ vtinfo 15ee197d94853421same address and namemerged12
2026-11-12 14:25insertdoordash 45624604 ↔ overture 652a257e-bcab-49ee-bee3-1f145183c106same address and namemerged12
2026-11-12 14:25insertab-inbev 2473507 ↔ doordash 45624604same address and namemerged12
2026-11-12 14:25insertdoordash 45624604 ↔ vtinfo 15ee197d94853421same address and namemerged12
2026-11-12 14:25insertct-dcp CT|LIR.0021922 ↔ vtinfo 15ee197d94853421same address and namemerged12
2026-11-12 14:25insertct-dcp CT|LIR.0021922 ↔ doordash 45624604same address and namemerged12
2026-11-11 12:56insertab-inbev 2473507 ↔ overture 652a257e-bcab-49ee-bee3-1f145183c106same address and namemerged12
2026-11-11 12:56insertab-inbev 2473507 ↔ ct-dcp CT|LIR.0021922same address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIR.0021922 ↔ overture 652a257e-bcab-49ee-bee3-1f145183c106same address and namemerged11