TOTAL WINE & MORE

FREMONT, CA 94538 · O2b100a7be67c · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Total Wine & Morealcohol: 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
TOTAL WINE & MORE 1 other
the most common name a source states
CALIFORNIA FINE WINE & SPIRITS LLC ca-abc (legal name) ×3
Street
43484 Boscell Rd 1 other
totalwine
43484 Boscell Road ubereats
City
Fremont
totalwineno other value
State
CA
totalwineno other value
ZIP
94538
totalwineno other value
Pin
37.50315, -121.97490 map 2 other
totalwine
65 m away ca-abc ×3
97 m away ab-inbev
Phone
5104030126
totalwineno other value
Licences
ca-abc 00560399|21|LIC|0 · ca-abc 00560399|42|LIC|0 · ca-abc 00560399|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of3037fc20691; O7650e5edce02; Ob6f751251eb6; O76c04636ab43; O5011bbdedca7; O3cd1a9a8cb15; O6a778bbe9d7b

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
ab-inbevTOTAL WINE & MORE
3947884
43484 BOSCELL RD, FREMONT, CA, 9453837.50228, -121.974772026-11-112026-11-11
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00560399|21|LIC|0
43484 BOSCELL RD, FREMONT, CA, 9453837.50258, -121.975102026-10-082026-11-11
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00560399|42|LIC|0
43484 BOSCELL RD, FREMONT, CA, 9453837.50258, -121.975102026-10-082026-11-11
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00560399|86|LIC|0
43484 BOSCELL RD, FREMONT, CA, 9453837.50258, -121.975102026-10-082026-11-11
overtureTotal Wine & More
a54feeac-2b7c-4495-8655-8e924d621bc4
43484 Boscell Rd, Fremont, CA, 94538510403012637.50315, -121.974902026-11-062026-11-11
totalwineTotal Wine & More
43484|94538
43484 Boscell Rd, Fremont, CA, 94538510403012637.50315, -121.974902026-11-102026-11-11
ubereatsTotal Wine & More
8oWoX_JNXD-WE2zdBzVdqA
43484 Boscell Road, Fremont, CA, 9453837.50318, -121.974762026-11-092026-11-11
vtinfoTOTAL WINE & MORE
472055385ab203ed
43484 BOSCELL RD, FREMONT, CA, 94538510403012637.50310, -121.975082026-11-122026-11-14

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
ab-inbev TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREoverture Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 97 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREtotalwine Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 97 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 101 m apart · name similarity 1.00
ab-inbev TOTAL WINE & MOREvtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 96 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00one licence filemergedfile: 00560399 · same_address
ca-abc TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00one licence filemergedfile: 00560399 · same_address
ca-abc TOTAL WINE & MOREoverture Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREtotalwine Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREvtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREoverture Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREtotalwine Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREvtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREoverture Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREtotalwine Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREvtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
overture Total Wine & Moretotalwine Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal
overture Total Wine & Moreubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
overture Total Wine & Morevtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 · phone: equal
totalwine Total Wine & Moreubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
totalwine Total Wine & Morevtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 · phone: equal
ubereats Total Wine & Morevtinfo TOTAL WINE & MORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Total Wine & More — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
CALIFORNIA FINE WINE & SPIRITS LLC — 49 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 42; CA 86
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "liquor_store"
  ],
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

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-12 14:25insertca-abc 00560399|21|LIC|0 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25insertca-abc 00560399|42|LIC|0 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25insertab-inbev 3947884 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25insertubereats 8oWoX_JNXD-WE2zdBzVdqA ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25inserttotalwine 43484|94538 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25insertoverture a54feeac-2b7c-4495-8655-8e924d621bc4 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-12 14:25insertca-abc 00560399|86|LIC|0 ↔ vtinfo 472055385ab203edsame address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ overture a54feeac-2b7c-4495-8655-8e924d621bc4same address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ totalwine 43484|94538same address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ ca-abc 00560399|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ ca-abc 00560399|86|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ ca-abc 00560399|42|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 3947884 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged12
2026-11-10 17:05insertoverture a54feeac-2b7c-4495-8655-8e924d621bc4 ↔ totalwine 43484|94538same address and namemerged12
2026-11-10 17:05insertca-abc 00560399|21|LIC|0 ↔ totalwine 43484|94538same address and namemerged12
2026-11-10 17:05insertca-abc 00560399|86|LIC|0 ↔ totalwine 43484|94538same address and namemerged12
2026-11-10 17:05insertca-abc 00560399|42|LIC|0 ↔ totalwine 43484|94538same address and namemerged12
2026-11-10 17:05inserttotalwine 43484|94538 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged12
2026-11-09 14:23insertoverture a54feeac-2b7c-4495-8655-8e924d621bc4 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged11
2026-11-09 14:23insertca-abc 00560399|21|LIC|0 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged11
2026-11-09 14:23insertca-abc 00560399|86|LIC|0 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged11
2026-11-09 14:23insertca-abc 00560399|42|LIC|0 ↔ ubereats 8oWoX_JNXD-WE2zdBzVdqAsame address and namemerged11
2026-11-06 18:13insertca-abc 00560399|21|LIC|0 ↔ overture a54feeac-2b7c-4495-8655-8e924d621bc4same address and namemerged11
2026-11-06 18:13insertca-abc 00560399|86|LIC|0 ↔ overture a54feeac-2b7c-4495-8655-8e924d621bc4same address and namemerged11
2026-11-06 18:13insertca-abc 00560399|42|LIC|0 ↔ overture a54feeac-2b7c-4495-8655-8e924d621bc4same address and namemerged11
2026-10-09 13:59backfillca-abc 00560399|21|LIC|0 ↔ ca-abc 00560399|86|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00560399|21|LIC|0 ↔ ca-abc 00560399|42|LIC|0one licence filemerged