Sam's Club

YUBA CITY, CA 95993 · O026eb8c33dd8 · first seen 2026-10-08
4 sourcesoff premisealcohol: 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
Sam's Club 4 other
a licence name in capitals, cleaned (derived; record_title.py)
SAMS CLUB ab-inbevvtinfo ×2
SAMS CLUB 6405 ca-abc ×2
SAMS WEST INC ca-abc (legal name) ×2
Sam's Club 6405 snap
Street
900 WALTON AVE 1 other
ca-abc
900 N Walton Ave snap
City
YUBA CITY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95993
ca-abcno other value
Pin
39.13966, -121.64550 map 2 other
snap
151 m away ab-inbev
2.9 km away vtinfo
Phone
5307511244
vtinfono other value
Licences
ca-abc 00328427|21|LIC|0 · ca-abc 00328427|86|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od1456a6c7a94; O887479cd92fb; O832ab309cd3a; O08ce0a77ce47

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-inbevSAMS CLUB
187155
900 WALTON AVE, YUBA CITY, CA, 9599339.14008, -121.643842026-11-112026-11-19
ca-abcSAMS CLUB 6405
legal name: SAMS WEST INC
00328427|21|LIC|0
900 WALTON AVE, YUBA CITY, CA, 959932026-10-082026-11-19
ca-abcSAMS CLUB 6405
legal name: SAMS WEST INC
00328427|86|LIC|0
900 WALTON AVE, YUBA CITY, CA, 959932026-10-082026-11-19
snapSam's Club 6405
snap|us|879096
900 N Walton Ave, Yuba City, CA, 9599339.13966, -121.645502026-11-192026-11-19
vtinfoSAMS CLUB
a879500fa22d6307
900 WALTON AVE, YUBA CITY, CA, 95993530751124439.11381, -121.643712026-11-162026-11-19

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 SAMS CLUBvtinfo SAMS CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2922 m apart · name similarity 1.00
ca-abc SAMS CLUB 6405ca-abc SAMS CLUB 64051.00one licence filemergedfile: 00328427 · same_address
ca-abc SAMS CLUB 6405snap Sam's Club 64051.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ca-abc SAMS CLUB 6405snap Sam's Club 64051.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ab-inbev SAMS CLUBca-abc SAMS CLUB 64050.72one name contains the other, same addressmergedjudge: None · pair_id: 8134802fad26ec2a746d · person: None · rule: names contained at one address · stratum: near
ab-inbev SAMS CLUBca-abc SAMS CLUB 64050.72one name contains the other, same addressmergedjudge: None · pair_id: 554a13ed0e54ddf7a063 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SAMS WEST INC — 31 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CA 21; CA 86
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "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-19 20:37insertca-abc 00328427|21|LIC|0 ↔ snap snap|us|879096street written two waysmerged17
2026-11-19 20:37insertca-abc 00328427|86|LIC|0 ↔ snap snap|us|879096street written two waysmerged17
2026-11-16 14:56insertab-inbev 187155 ↔ ca-abc 00328427|86|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 187155 ↔ ca-abc 00328427|21|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 187155 ↔ vtinfo a879500fa22d6307same address and namemerged15
2026-10-09 13:59backfillca-abc 00328427|21|LIC|0 ↔ ca-abc 00328427|86|LIC|0one licence filemerged