Rosa Fierro Cellars

LIVERMORE, CA 94550 · O170e37bd8e17 · 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
Rosa Fierro Cellars 1 other
the most common name a source states
ROSA FIERRO WINE COMPANY LLC ca-abc (legal name)ttb (legal name) ×2
Street
2245 S VASCO RD 2 other
ca-abc
2245 S Vasco Rd A overture
2245 S VASCO RD STE A ttb
City
LIVERMORE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94550 1 other
ca-abc
94551 ttb
Pin
37.67640, -121.71920 map
overtureno other value
Phone
9259631406
overtureno other value
Licences
ca-abc 00617269|02|LIC|0 · ttb CA-W-21856
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od9b7c73ecf04; O2ff3d64af375

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-abcROSA FIERRO CELLARS
legal name: ROSA FIERRO WINE COMPANY LLC
00617269|02|LIC|0
2245 S VASCO RD, LIVERMORE, CA, 9455037.67618, -121.719022026-10-082026-11-12
overtureRosa Fierro Cellars
935b1c40-34cf-43a9-bf17-75cb7e2378b1
2245 S Vasco Rd A, Livermore, CA, 94550925963140637.67640, -121.719202026-11-182026-11-18
ttbRosa Fierro Cellars
legal name: ROSA FIERRO WINE COMPANY, LLC
CA-W-21856
2245 S VASCO RD STE A, LIVERMORE, CA, 9455137.67618, -121.719022026-11-032026-11-12

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
ttb Sidewinder Spiritsttb Rosa Fierro Cellars1.00one store listed twiceheld withdrawnfacility: producer · same street + city + state
ca-abc ROSA FIERRO CELLARSoverture Rosa Fierro Cellars1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 29 m apart · name similarity 1.00 · street similarity 0.91
ca-abc ROSA FIERRO CELLARSttb Rosa Fierro Cellars1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
overture Rosa Fierro Cellarsttb Rosa Fierro Cellars1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 29 m apart · name similarity 1.00 · street similarity 0.91

Attributes

Channel
producer · producer — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROSA FIERRO WINE COMPANY LLC — 1 outlets in the master under this operator
Licence privileges
none — CA 02
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "producer",
   "producer"
  ]
 ]
}

Trade area

Other outlets
40 within 1 mi · 370 within 3 mi
Off / on premise
14 / 0 within 1 mi · 88 / 181 within 3 mi
Selling alcohol
40 within 1 mi · 274 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
suburban (1,337 people per sq mi)
People within 3 mi
37,802 (28,144 adults 21+, 13,802 households) from 9 tract(s), tracts within 3 mi
Income
per capita $75,436 · median household ~$164,064 (weighted mean of tract medians)
Age and education
median age ~42.5 · bachelor's or higher 51%
Ethnicity
Hispanic 23% · White 58% · Black 2% · Asian 15%
Adults per alcohol outlet
102
Alcohol spend within 3 mi
$14,017,889 a year ($5,956,638 at home, $8,056,845 away) · $50,974 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-18 18:58insertoverture 935b1c40-34cf-43a9-bf17-75cb7e2378b1 ↔ ttb CA-W-21856street written two waysmerged15
2026-11-18 18:58insertca-abc 00617269|02|LIC|0 ↔ overture 935b1c40-34cf-43a9-bf17-75cb7e2378b1street written two waysmerged15
2026-11-12 14:11updatettb CA-S-20150 ↔ ttb CA-W-21856one store listed twiceheld: withdrawn12
2026-11-05 18:28backfillttb CA-S-20150 ↔ ttb CA-W-21856one store listed twicemerged
2026-11-03 13:33backfillca-abc 00617269|02|LIC|0 ↔ ttb CA-W-21856same address and namemerged