Casa Guadalupe

SAN FRANCISCO, CA 94110 · O109dc886fa74 · first seen 2026-10-08
3 sourcesoff premisealcohol: licensed1 licence

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
Casa Guadalupe 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Casa Guadalupe Supermarket 2 snapca-abc (legal name) ×2
CASA GUADALUPE SUPERMARKET ca-abc
Street
3400 CESAR CHAVEZ ST 1 other
ca-abc
3400 Cesar Chavez snap
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94110
ca-abcno other value
Pin
37.74847, -122.41870 map
snapno other value
Phone
4156559867
vtinfono other value
Licences
ca-abc 00667446|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oda1cf6d7efae; O43fa5fc4e943

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-abcCASA GUADALUPE SUPERMARKET
legal name: CASA GUADALUPE SUPERMARKET 2
00667446|20|LIC|0
3400 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 9411037.74826, -122.418282026-10-082026-11-19
snapCasa Guadalupe Supermarket 2
snap|us|1607881
3400 Cesar Chavez, San Francisco, CA, 9411037.74847, -122.418702026-11-192026-11-19
vtinfoCASA GUADALUPE
3e98a09a1a6bef07
3400 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94110415655986737.74860, -122.418432026-11-122026-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
ca-abc CASA GUADALUPE SUPERMARKETsnap Casa Guadalupe Supermarket 21.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 44 m apart · name similarity 1.00 · street similarity 0.89
ca-abc CASA GUADALUPE SUPERMARKETvtinfo CASA GUADALUPE0.68same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supermarket · name Jaro-Winkler 0.91 · same street + city + state · pins 40 m apart · name similarity 0.68

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off — CA 20
Rule version 11, computed 2026-11-19 21:40.
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 00667446|20|LIC|0 ↔ snap snap|us|1607881street written two waysmerged17
2026-11-12 17:29insertca-abc 00667446|20|LIC|0 ↔ vtinfo 3e98a09a1a6bef07same address and namemerged14