TOTAL WINE & MORE

SAN FRANCISCO, CA 94103 · O2109079e6b95 · 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
1750 Harrison St 1 other
totalwine
1750 Harrison Street ubereats
City
San Francisco
totalwineno other value
State
CA
totalwineno other value
ZIP
94103
totalwineno other value
Pin
37.76900, -122.41418 map 1 other
totalwine
61 m away ca-abc ×3
Phone
6288678200
totalwineno other value
Licences
ca-abc 00643675|21|LIC|0 · ca-abc 00643675|42|LIC|0 · ca-abc 00643675|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8e8f55e29406; Oeb98f119b942; O80ed7d242f6f; Oa4035bdfd9f7; O64ac10d5865f; Ofd40833b1356; O32b2554532b2

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
4666032
1750 HARRISON ST, SAN FRANCISCO, CA, 9410337.76900, -122.414212026-11-132026-11-13
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00643675|21|LIC|0
1750 HARRISON ST, SAN FRANCISCO, CA, 9410337.76906, -122.413502026-10-082026-11-13
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00643675|42|LIC|0
1750 HARRISON ST, SAN FRANCISCO, CA, 9410337.76906, -122.413502026-10-082026-11-13
ca-abcTOTAL WINE & MORE
legal name: CALIFORNIA FINE WINE & SPIRITS LLC
00643675|86|LIC|0
1750 HARRISON ST, SAN FRANCISCO, CA, 9410337.76906, -122.413502026-10-082026-11-13
overtureTotal Wine & More
4209b46a-0c11-44d7-8a53-01dd68d6976b
1750 Harrison St, San Francisco, CA, 94103628867820037.76900, -122.414182026-11-062026-11-13
totalwineTotal Wine & More
1750|94103
1750 Harrison St, San Francisco, CA, 94103628867820037.76900, -122.414182026-11-102026-11-13
ubereatsTotal Wine & More
uyJeXtOcVKyOPMZaShFUew
1750 Harrison Street, San Francisco, CA, 9410337.76920, -122.414002026-10-082026-11-13
vtinfoTOTAL WINE & MORE
abec8d84fc29f221
1750 HARRISON ST, SAN FRANCISCO, CA, 94103628867820037.76899, -122.414212026-11-112026-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 63 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 63 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 63 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 2 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 2 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 29 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 1 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00one licence filemergedfile: 00643675 · same_address
ca-abc TOTAL WINE & MOREca-abc TOTAL WINE & MORE1.00one licence filemergedfile: 00643675 · 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 61 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 61 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · 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 63 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 61 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 61 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · 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 63 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 61 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 61 m apart · name similarity 1.00
ca-abc TOTAL WINE & MOREubereats Total Wine & More1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · 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 63 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 28 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 2 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 28 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 2 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-13 17:47insertab-inbev 4666032 ↔ vtinfo abec8d84fc29f221same address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ ca-abc 00643675|21|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ ca-abc 00643675|86|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ ca-abc 00643675|42|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ overture 4209b46a-0c11-44d7-8a53-01dd68d6976bsame address and namemerged15
2026-11-13 17:47insertab-inbev 4666032 ↔ totalwine 1750|94103same address and namemerged15
2026-11-11 12:56insertoverture 4209b46a-0c11-44d7-8a53-01dd68d6976b ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-11 12:56insertca-abc 00643675|86|LIC|0 ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-11 12:56insertca-abc 00643675|42|LIC|0 ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-11 12:56inserttotalwine 1750|94103 ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-11 12:56insertca-abc 00643675|21|LIC|0 ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-11 12:56insertubereats uyJeXtOcVKyOPMZaShFUew ↔ vtinfo abec8d84fc29f221same address and namemerged12
2026-11-10 17:05insertoverture 4209b46a-0c11-44d7-8a53-01dd68d6976b ↔ totalwine 1750|94103same address and namemerged12
2026-11-10 17:05insertca-abc 00643675|86|LIC|0 ↔ totalwine 1750|94103same address and namemerged12
2026-11-10 17:05insertca-abc 00643675|42|LIC|0 ↔ totalwine 1750|94103same address and namemerged12
2026-11-10 17:05insertca-abc 00643675|21|LIC|0 ↔ totalwine 1750|94103same address and namemerged12
2026-11-10 17:05inserttotalwine 1750|94103 ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged12
2026-11-06 18:13insertca-abc 00643675|86|LIC|0 ↔ overture 4209b46a-0c11-44d7-8a53-01dd68d6976bsame address and namemerged11
2026-11-06 18:13insertca-abc 00643675|42|LIC|0 ↔ overture 4209b46a-0c11-44d7-8a53-01dd68d6976bsame address and namemerged11
2026-11-06 18:13insertca-abc 00643675|21|LIC|0 ↔ overture 4209b46a-0c11-44d7-8a53-01dd68d6976bsame address and namemerged11
2026-11-06 18:13insertoverture 4209b46a-0c11-44d7-8a53-01dd68d6976b ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged11
2026-10-09 13:59backfillca-abc 00643675|21|LIC|0 ↔ ca-abc 00643675|86|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00643675|21|LIC|0 ↔ ca-abc 00643675|42|LIC|0one licence filemerged
2026-10-08 21:18backfillca-abc 00643675|86|LIC|0 ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged
2026-10-08 21:18backfillca-abc 00643675|42|LIC|0 ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged
2026-10-08 21:18backfillca-abc 00643675|21|LIC|0 ↔ ubereats uyJeXtOcVKyOPMZaShFUewsame address and namemerged