Jolly Pumpkin Brewery and Cafe

Detroit, MI 48201 · O6aabad823a05 · first seen 2026-11-03
2 sourcesoff premise · liquor_storealcohol: licensed2 licences

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
Jolly Pumpkin Brewery and Cafe 2 other
a licence name in capitals, cleaned (derived; record_title.py)
JP AVALON DETROIT, LLC mi-lcc (legal name) ×2
Jolly Pumpkin Pizzeria & Brewery overture
Street
441 W Canfield St 1 other
mi-lcc
441 W Canfield St Ste 9 overture
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48201
mi-lccno other value
Pin
42.35077, -83.06529 map 1 other
overture
100 m away mi-lcc ×2
Phone
3132626115
overtureno other value
Licences
mi-lcc L-000467081 · mi-lcc L-000467088
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obaca9e72836f; Oc3f917b4a199

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
mi-lccJOLLY PUMPKIN BREWERY AND CAFE
legal name: JP AVALON DETROIT, LLC
L-000467081
441 W Canfield St, Detroit, MI, 48201313262611542.35156, -83.064712026-11-032026-11-05
mi-lccJOLLY PUMPKIN BREWERY AND CAFE
legal name: JP AVALON DETROIT, LLC
L-000467088
441 W Canfield St, Detroit, MI, 48201313262611542.35156, -83.064712026-11-032026-11-05
overtureJolly Pumpkin Pizzeria & Brewery
85db9a5c-ebbc-424b-a12b-ee3e70fb4665
441 W Canfield St Ste 9, Detroit, MI, 48201313262611542.35077, -83.065292026-11-132026-11-13

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
mi-lcc JOLLY PUMPKIN BREWERY AND CAFEmi-lcc JOLLY PUMPKIN BREWERY AND CAFE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc JOLLY PUMPKIN BREWERY AND CAFEoverture Jolly Pumpkin Pizzeria & Brewery0.68same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe, pizzeria · name Jaro-Winkler 0.88 · same street + ZIP · pins 100 m apart · name similarity 0.68 · phone: equal
mi-lcc JOLLY PUMPKIN BREWERY AND CAFEoverture Jolly Pumpkin Pizzeria & Brewery0.68same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe, pizzeria · name Jaro-Winkler 0.88 · same street + ZIP · pins 100 m apart · name similarity 0.68 · phone: equal

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
JP AVALON DETROIT, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
242 within 1 mi · 1,036 within 3 mi
Off / on premise
33 / 128 within 1 mi · 150 / 509 within 3 mi
Selling alcohol
146 within 1 mi · 704 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.04 mi
Setting
urban (3,673 people per sq mi)
People within 3 mi
103,839 (80,432 adults 21+, 49,609 households) from 58 tract(s), tracts within 3 mi
Income
per capita $34,739 · median household ~$47,192 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 33%
Ethnicity
Hispanic 10% · White 26% · Black 56% · Asian 4%
Adults per alcohol outlet
114
Alcohol spend within 3 mi
$23,763,102 a year ($11,448,644 at home, $12,298,586 away) · $33,707 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:10insertmi-lcc L-000467081 ↔ overture 85db9a5c-ebbc-424b-a12b-ee3e70fb4665same address and namemerged15
2026-11-13 14:10insertmi-lcc L-000467088 ↔ overture 85db9a5c-ebbc-424b-a12b-ee3e70fb4665same address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000467081 ↔ mi-lcc L-000467088one store listed twicemerged