Outlets /
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.
| Field | Master value | Taken from | What 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-dcp | no other value |
| State | CT | ct-dcp | no other value |
| ZIP | 06855 | ct-dcp | no other value |
| Pin | 41.10288, -73.40599 map 2 other | doordash | 155 m away ct-dcp 87 m away vtinfo |
| Phone | 2033543109 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | MAGIC FIVE PIE 4490203 | 230 EAST AVE, NORWALK, CT, 06855 | 41.10322, -73.40573 | 2026-11-11 | 2026-11-12 | |
| ct-dcp | THE MAGIC 5 PIE CO CT|LIR.0020630 | 230 EAST AVE STE 105, NORWALK, CT, 06855 | 41.10346, -73.40430 | 2026-11-03 | 2026-11-06 | |
| doordash | magic 5 pie co. norwalk 25075540 | 230 East Avenue, Norwalk, CT, 06855 | 41.10288, -73.40599 | 2026-10-08 | 2026-11-11 | |
| overture | Magic 5 Pie Co e7fdf547-3498-46e0-9966-11acf73191c5 | 230 East Ave, Norwalk, CT, 06855 | 2033543109 | 41.10263, -73.40605 | 2026-11-06 | 2026-11-06 |
| vtinfo | MAGIC FIVE PIE daf56884eed7e706 | 230 EAST AVE, NORWALK, CT, 06855 | 2033543109 | 41.10326, -73.40509 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev MAGIC FIVE PIE | vtinfo MAGIC FIVE PIE | 1.00 | same address and name | merged | address 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 CO | doordash magic 5 pie co. norwalk | 1.00 | same address and name | merged | address 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 CO | overture Magic 5 Pie Co | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 173 m apart · name similarity 1.00 |
| doordash magic 5 pie co. norwalk | overture Magic 5 Pie Co | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00 |
| ab-inbev MAGIC FIVE PIE | ct-dcp THE MAGIC 5 PIE CO | 0.65 | Claude judge: same | merged | 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:
pair 0bf9b550ce62f1d5a6a0 |
| ct-dcp THE MAGIC 5 PIE CO | vtinfo MAGIC FIVE PIE | 0.65 | Claude judge: same | merged | 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:
pair 2b70b4c138883c216bb5 |
| doordash magic 5 pie co. norwalk | vtinfo MAGIC FIVE PIE | 0.65 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | ct-dcp CT|LIR.0020630 ↔ vtinfo daf56884eed7e706 | Claude judge: same | merged | 17 |
| 2026-11-19 20:37 | insert | doordash 25075540 ↔ vtinfo daf56884eed7e706 | Claude judge: same | merged | 17 |
| 2026-11-12 17:29 | insert | ab-inbev 4490203 ↔ ct-dcp CT|LIR.0020630 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 4490203 ↔ vtinfo daf56884eed7e706 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | doordash 25075540 ↔ overture e7fdf547-3498-46e0-9966-11acf73191c5 | same address and name | merged | 12 |
| 2026-11-10 17:05 | insert | ct-dcp CT|LIR.0020630 ↔ doordash 25075540 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ct-dcp CT|LIR.0020630 ↔ overture e7fdf547-3498-46e0-9966-11acf73191c5 | same address and name | merged | 11 |