Magic Five Pie

NORWALK, CT 06855 · O1067532ef7d8 · 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
Magic Five Pie 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Magic 5 Pie Co overture
magic 5 pie co. norwalk doordash
THE MAGIC 5 PIE CO ct-dcp
Street
230 EAST AVE STE 105 2 other
ct-dcp
230 EAST AVE ab-inbevoverturevtinfo ×3
230 East Avenue doordash
City
NORWALK
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06855
ct-dcpno other value
Pin
41.10288, -73.40599 map 2 other
doordash
155 m away ct-dcp
87 m away vtinfo
Phone
2033543109
vtinfono other value
Licences
ct-dcp CT|LIR.0020630
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obe98995d855e; O4e55b0df5c45; Of2aa93aa1679; Oa1edd42ec755

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-inbevMAGIC FIVE PIE
4490203
230 EAST AVE, NORWALK, CT, 0685541.10322, -73.405732026-11-112026-11-12
ct-dcpTHE MAGIC 5 PIE CO
CT|LIR.0020630
230 EAST AVE STE 105, NORWALK, CT, 0685541.10346, -73.404302026-11-032026-11-06
doordashmagic 5 pie co. norwalk
25075540
230 East Avenue, Norwalk, CT, 0685541.10288, -73.405992026-10-082026-11-11
overtureMagic 5 Pie Co
e7fdf547-3498-46e0-9966-11acf73191c5
230 East Ave, Norwalk, CT, 06855203354310941.10263, -73.406052026-11-062026-11-06
vtinfoMAGIC FIVE PIE
daf56884eed7e706
230 EAST AVE, NORWALK, CT, 06855203354310941.10326, -73.405092026-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 MAGIC FIVE PIEvtinfo MAGIC FIVE PIE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 54 m apart · name similarity 1.00
ct-dcp THE MAGIC 5 PIE COdoordash magic 5 pie co. norwalk1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 155 m apart · name similarity 1.00
ct-dcp THE MAGIC 5 PIE COoverture Magic 5 Pie Co1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 173 m apart · name similarity 1.00
doordash magic 5 pie co. norwalkoverture Magic 5 Pie Co1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
ab-inbev MAGIC FIVE PIEct-dcp THE MAGIC 5 PIE CO0.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Magic Five Pie name match, same building
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records name the same pizzeria (MAGIC FIVE PIE / THE MAGIC 5 PIE CO) at 230 East Ave, Norwalk CT, with only one business at that address and coordinates 0.12 km apart; the suite appears on only one record, but the name match is strong.
pair 0bf9b550ce62f1d5a6a0
ct-dcp THE MAGIC 5 PIE COvtinfo MAGIC FIVE PIE0.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Magic 5/Five Pie same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — The names are the same business written two ways (THE MAGIC 5 PIE CO and MAGIC FIVE PIE), at the same street address in Norwalk, CT, with coordinates about 69 m apart and no other business recorded at that address; the suite number is on only one record, so the match rests on name and address.
pair 2b70b4c138883c216bb5
doordash magic 5 pie co. norwalkvtinfo MAGIC FIVE PIE0.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Magic 5 Pie same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 230 East Ave, Norwalk CT 06855 with coordinates about 87 m apart, and the names 'magic 5 pie co. norwalk' and 'MAGIC FIVE PIE' match, with no other business at that address.
pair 2a40ec79a4e2d725e329

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THE MAGIC 5 PIE CO — 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-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
189 within 1 mi · 577 within 3 mi
Off / on premise
36 / 90 within 1 mi · 127 / 287 within 3 mi
Selling alcohol
134 within 1 mi · 370 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.08 mi
Setting
urban (3,037 people per sq mi)
People within 3 mi
85,878 (66,976 adults 21+, 32,964 households) from 20 tract(s), tracts within 3 mi
Income
per capita $63,476 · median household ~$114,981 (weighted mean of tract medians)
Age and education
median age ~40.6 · bachelor's or higher 44%
Ethnicity
Hispanic 32% · White 46% · Black 18% · Asian 4%
Adults per alcohol outlet
181
Alcohol spend within 3 mi
$27,563,070 a year ($12,127,779 at home, $15,424,619 away) · $74,294 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-19 20:37insertct-dcp CT|LIR.0020630 ↔ vtinfo daf56884eed7e706Claude judge: samemerged17
2026-11-19 20:37insertdoordash 25075540 ↔ vtinfo daf56884eed7e706Claude judge: samemerged17
2026-11-12 17:29insertab-inbev 4490203 ↔ ct-dcp CT|LIR.0020630Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4490203 ↔ vtinfo daf56884eed7e706same address and namemerged12
2026-11-10 17:05insertdoordash 25075540 ↔ overture e7fdf547-3498-46e0-9966-11acf73191c5same address and namemerged12
2026-11-10 17:05insertct-dcp CT|LIR.0020630 ↔ doordash 25075540same address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIR.0020630 ↔ overture e7fdf547-3498-46e0-9966-11acf73191c5same address and namemerged11