Jolly Pumpkin

Traverse City, MI 49686 · O361fc5ff7f90 · first seen 2026-11-03
2 sourcesoff premise · liquor_storealcohol: 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
Jolly Pumpkin 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Northern United Brewing overture
NORTHERN UNITED BREWING COMPANY, LLC ttb (legal name)
Street
13512 PENINSULA DR UNIT 2 1 other
ttb
13512 Peninsula Dr overture
City
TRAVERSE CITY
ttbno other value
State
MI
ttbno other value
ZIP
49686
ttbno other value
Pin
44.88616, -85.52866 map 1 other
overture
51 m away ttb
Phone
2312238700
overtureno other value
Licences
ttb MI-S-15018
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odbcc7c75f1b0

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
overtureNorthern United Brewing
db3c3faf-2654-4f51-8549-3fa6e9236215
13512 Peninsula Dr, Traverse City, MI, 49686231223870044.88616, -85.528662026-11-062026-11-06
ttbJOLLY PUMPKIN
legal name: NORTHERN UNITED BREWING COMPANY, LLC
MI-S-15018
13512 PENINSULA DR UNIT 2, TRAVERSE CITY, MI, 4968644.88598, -85.529262026-11-032026-11-05

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
overture Northern United Brewingttb JOLLY PUMPKIN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · matched through the licence's legal name: NORTHERN UNITED BREWING COMPANY, LLC · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
NORTHERN UNITED BREWING COMPANY, LLC — 8 outlets in the master under this operator
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
7 within 1 mi · 21 within 3 mi
Off / on premise
2 / 1 within 1 mi · 8 / 2 within 3 mi
Selling alcohol
7 within 1 mi · 21 within 3 mi
Nearest
same channel 0.72 mi · licensed 0.03 mi
Setting
rural (180 people per sq mi)
People within 3 mi
5,081 (4,299 adults 21+, 2,338 households) from 1 tract(s), tracts within 3 mi
Income
per capita $86,691 · median household ~$134,911 (weighted mean of tract medians)
Age and education
median age ~57.7 · bachelor's or higher 72%
Ethnicity
Hispanic 5% · White 94% · Black 0% · Asian 0%
Adults per alcohol outlet
195
Alcohol spend within 3 mi
$2,278,235 a year ($972,910 at home, $1,304,615 away) · $103,556 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-06 18:13insertoverture db3c3faf-2654-4f51-8549-3fa6e9236215 ↔ ttb MI-S-15018same address and namemerged11