Whipsmart Wine Company

SANTA ROSA, CA 95403 · O7c05e589e7bd · first seen 2026-10-08
3 sourcesproducer · produceralcohol: 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
Whipsmart Wine Company 2 other
the most common name a source states
DUBE PHILLIP EMERY ca-abc (legal name)
PHILLIP EMERY DUBE ttb (legal name)
Street
1160 HOPPER AVE
ca-abcno other value
City
SANTA ROSA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95403
ca-abcno other value
Pin
38.47873, -122.74087 map 2 other
overture
103 m away ca-abc
103 m away ttb
Phone
7077039271
overtureno other value
Licences
ca-abc 00559599|02|LIC|0 · ttb CA-W-22130
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7d2497873e1b; Oeb9d0f1aeac3

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
ca-abcWHIPSMART WINE COMPANY
legal name: DUBE PHILLIP EMERY
00559599|02|LIC|0
1160 HOPPER AVE, SANTA ROSA, CA, 9540338.47965, -122.740982026-10-082026-11-05
overtureWhipsmart Wine Company
970c004e-9ae7-40dd-9cbd-e6c1032e6a17
1160 Hopper Ave, Santa Rosa, CA, 95403707703927138.47873, -122.740872026-11-062026-11-06
ttbWhipsmart Wine Company
legal name: PHILLIP EMERY DUBE
CA-W-22130
1160 HOPPER AVE, SANTA ROSA, CA, 9540338.47965, -122.740982026-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
ca-abc WHIPSMART WINE COMPANYoverture Whipsmart Wine Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00
ca-abc WHIPSMART WINE COMPANYttb Whipsmart Wine Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Whipsmart Wine Companyttb Whipsmart Wine Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 103 m apart · name similarity 1.00

Attributes

Channel
producer · producer — ca-licence conflicting evidence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none — CA 02
Rule version 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "producer",
   "producer"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
226 within 1 mi · 625 within 3 mi
Off / on premise
81 / 42 within 1 mi · 215 / 218 within 3 mi
Selling alcohol
195 within 1 mi · 471 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,547 people per sq mi)
People within 3 mi
72,019 (55,938 adults 21+, 28,605 households) from 16 tract(s), tracts within 3 mi
Income
per capita $52,935 · median household ~$106,362 (weighted mean of tract medians)
Age and education
median age ~42.9 · bachelor's or higher 33%
Ethnicity
Hispanic 38% · White 52% · Black 2% · Asian 5%
Adults per alcohol outlet
119
Alcohol spend within 3 mi
$22,388,215 a year ($9,983,667 at home, $12,394,536 away) · $47,433 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 970c004e-9ae7-40dd-9cbd-e6c1032e6a17 ↔ ttb CA-W-22130same address and namemerged11
2026-11-06 18:13insertca-abc 00559599|02|LIC|0 ↔ overture 970c004e-9ae7-40dd-9cbd-e6c1032e6a17same address and namemerged11
2026-11-03 13:33backfillca-abc 00559599|02|LIC|0 ↔ ttb CA-W-22130same address and namemerged