Ficklin Vineyards

MADERA, CA 93637 · O3c3fe8c6ac1a · first seen 2026-10-08
3 sourcesproducer · produceralcohol: licensed3 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
Ficklin Vineyards
a source's own spelling of the licence name (record_title.py)no other value
Street
30246 AVE 7-1/2 1 other
ca-abc
30246 Avenue 7 1/2 overturettb ×2
City
MADERA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93637
ca-abcno other value
Pin
36.85788, -119.99682 map 2 other
overture
287 m away ca-abc ×2
287 m away ttb
Phone
5596610075
overtureno other value
Licences
ca-abc 00028026|02|APP|0 · ca-abc 00028026|02|LIC|0 · ttb CA-W-844
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of866123f7eb9; Oddbb12f3554f; Ob1d6094105a7

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-abcFICKLIN VINEYARDS
00028026|02|APP|0
30246 AVE 7-1/2, MADERA, CA, 9363736.85857, -119.993712026-10-082026-11-06
ca-abcFICKLIN VINEYARDS
00028026|02|LIC|0
30246 AVE 7-1/2, MADERA, CA, 9363736.85857, -119.993712026-10-082026-11-06
overtureFicklin Vineyards
58fe08cd-10f4-4d21-a069-d1abfd346d3e
30246 Avenue 7 1/2, Madera, CA, 93637559661007536.85788, -119.996822026-11-062026-11-06
ttbFICKLIN VINEYARDS
CA-W-844
30246 AVENUE 7 1/2, MADERA, CA, 9363736.85857, -119.993712026-11-032026-11-06

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 FICKLIN VINEYARDSca-abc FICKLIN VINEYARDS1.00one licence filemergedfile: 00028026 · same_address
ca-abc FICKLIN VINEYARDSoverture Ficklin Vineyards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 287 m apart · name similarity 1.00
ca-abc FICKLIN VINEYARDSttb FICKLIN VINEYARDS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc FICKLIN VINEYARDSoverture Ficklin Vineyards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 287 m apart · name similarity 1.00
ca-abc FICKLIN VINEYARDSttb FICKLIN VINEYARDS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Ficklin Vineyardsttb FICKLIN VINEYARDS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 287 m apart · name similarity 1.00

Attributes

Channel
producer · producer — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none — CA 02
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "producer",
   "producer"
  ]
 ]
}

Trade area

Other outlets
2 within 1 mi · 22 within 3 mi
Off / on premise
2 / 0 within 1 mi · 7 / 8 within 3 mi
Selling alcohol
2 within 1 mi · 17 within 3 mi
Nearest
same channel 2.19 mi · licensed 0.92 mi
Setting
rural (none people per sq mi)
People within 3 mi
3,338 (2,058 adults 21+, 880 households) from 1 tract(s), the nearest tract
Income
per capita $26,394 · median household ~$63,864 (weighted mean of tract medians)
Age and education
median age ~34.5 · bachelor's or higher 14%
Ethnicity
Hispanic 73% · White 29% · Black 1% · Asian 2%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$561,784 a year ($262,834 at home, $298,698 away) · none 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 58fe08cd-10f4-4d21-a069-d1abfd346d3e ↔ ttb CA-W-844same address and namemerged11
2026-11-06 18:13insertca-abc 00028026|02|LIC|0 ↔ overture 58fe08cd-10f4-4d21-a069-d1abfd346d3esame address and namemerged11
2026-11-06 18:13insertca-abc 00028026|02|APP|0 ↔ overture 58fe08cd-10f4-4d21-a069-d1abfd346d3esame address and namemerged11
2026-11-03 13:33backfillca-abc 00028026|02|LIC|0 ↔ ttb CA-W-844same address and namemerged
2026-11-03 13:33backfillca-abc 00028026|02|APP|0 ↔ ttb CA-W-844same address and namemerged
2026-10-09 13:59backfillca-abc 00028026|02|APP|0 ↔ ca-abc 00028026|02|LIC|0one licence filemerged