Pie Guys

Waterbury, CT 06705 · Oad557d9c19a8 · first seen 2026-10-08
2 sourceson premise · restaurantalcohol: unknown

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
Pie Guys 1 other
the most common name a source states
pie guys waterbury doordash
Street
514 Frost Road 1 other
doordash
514 Frost Rd overture
City
Waterbury
doordashno other value
State
CT
doordashno other value
ZIP
06705
doordashno other value
Pin
41.55322, -73.00016 map
doordashno other value
Phone
2037218020
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oef6b766b1a69

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
doordashpie guys waterbury
304306
514 Frost Road, Waterbury, CT, 0670541.55322, -73.000162026-10-082026-11-15
overturePie Guys
de3a9db2-d2a5-466b-afdd-13f9a6d9fa50
514 Frost Rd, Waterbury, CT, 06705203721802041.55318, -73.000252026-11-152026-11-15

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
doordash pie guys waterburyoverture Pie Guys1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
102 within 1 mi · 455 within 3 mi
Off / on premise
27 / 60 within 1 mi · 128 / 219 within 3 mi
Selling alcohol
44 within 1 mi · 265 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.04 mi
Setting
urban (3,180 people per sq mi)
People within 3 mi
89,926 (65,188 adults 21+, 35,359 households) from 21 tract(s), tracts within 3 mi
Income
per capita $29,827 · median household ~$53,699 (weighted mean of tract medians)
Age and education
median age ~37.7 · bachelor's or higher 17%
Ethnicity
Hispanic 37% · White 36% · Black 27% · Asian 3%
Adults per alcohol outlet
246
Alcohol spend within 3 mi
$17,880,719 a year ($8,603,047 at home, $9,267,549 away) · $67,474 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-15 17:57insertdoordash 304306 ↔ overture de3a9db2-d2a5-466b-afdd-13f9a6d9fa50same address and namemerged15