SMART & FINAL 327

SUNNYVALE, CA 94087 · O22216d6619c1 · first seen 2026-10-08
5 sourcesoff premise · grocerychain: Smart&finalalcohol: 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
SMART & FINAL 327 4 other
the most common name a source states
SMART & FINAL EXTRA ab-inbevvtinfo ×2
SMART & FINAL STORES LLC ca-abc (legal name) ×2
Smart & Final ubereats
Smart and Final overture
Street
1265 S MARY AVE 1 other
ca-abc
1265 S. Mary Avenue overtureubereats ×2
City
SUNNYVALE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94087
ca-abcno other value
Pin
37.35345, -122.05122 map 2 other
ubereats
61 m away ca-abc ×2
123 m away ab-inbev
Phone
4082454423
vtinfono other value
Licences
ca-abc 00456461|21|APP|0 · ca-abc 00456461|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O96ab54b25fe1; Oa2ce117a98b1; Oe8db047849e3; Ofd23078de2d1; O91032bf1ed7a

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-inbevSMART & FINAL EXTRA
2743791
1265 S MARY AVE, SUNNYVALE, CA, 9408737.35451, -122.050822026-11-112026-11-12
ca-abcSMART & FINAL 327
legal name: SMART & FINAL STORES LLC
00456461|21|APP|0
1265 S MARY AVE, SUNNYVALE, CA, 9408737.35318, -122.050622026-10-082026-11-05
ca-abcSMART & FINAL 327
legal name: SMART & FINAL STORES LLC
00456461|21|LIC|0
1265 S MARY AVE, SUNNYVALE, CA, 9408737.35318, -122.050622026-10-082026-11-05
overtureSmart and Final
faaf3f4e-761f-4904-ab8c-94ae23fa53d2
1265 S. Mary Avenue, Sunnyvale, CA, 94087408245442337.35345, -122.051352026-11-062026-11-06
ubereatsSmart & Final
mGj5VaJjUqy_h38AXQryPg
1265 S. Mary Avenue, Sunnyvale, CA, 9408737.35345, -122.051222026-11-122026-11-12
vtinfoSMART & FINAL EXTRA
61586ea105ac15ac
1265 S MARY AVE, SUNNYVALE, CA, 94087408245442337.35340, -122.051212026-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 SMART & FINAL EXTRAvtinfo SMART & FINAL EXTRA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 128 m apart · name similarity 1.00
ca-abc SMART & FINAL 327ca-abc SMART & FINAL 3271.00one licence filemergedfile: 00456461 · same_address
ca-abc SMART & FINAL 327overture Smart and Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
ca-abc SMART & FINAL 327ubereats Smart & Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
ca-abc SMART & FINAL 327overture Smart and Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
ca-abc SMART & FINAL 327ubereats Smart & Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
overture Smart and Finalubereats Smart & Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev SMART & FINAL EXTRAca-abc SMART & FINAL 3270.73Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Smart & Final at same Sunnyvale address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are the same Smart & Final chain store at 1265 S Mary Ave, Sunnyvale (same street address, ZIP, and coordinates about 0.15 km apart), with the ca-abc record's legal entity SMART & FINAL STORES LLC matching the chain's name and the single business at that address.
pair 37a57fb64af50a0b9ce1
ab-inbev SMART & FINAL EXTRAca-abc SMART & FINAL 3270.73Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Smart & Final at same address, off-sale licence
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records sit at 1265 S Mary Ave, Sunnyvale (about 0.15 km apart, single business at the address), and both are the Smart & Final chain; the ca-abc legal entity SMART & FINAL STORES LLC and store 327 match the chain's banner, and the ab-inbev 'Smart & Final Extra' is the same store's alcohol department under the chain name.
pair 210655c39c0867be3e8c

Attributes

Channel
off_premise · grocery — ca-licence
Chain
Smart&final — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
SMART & FINAL STORES LLC — 337 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "grocery"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
20 within 1 mi · 925 within 3 mi
Off / on premise
7 / 8 within 1 mi · 152 / 596 within 3 mi
Selling alcohol
10 within 1 mi · 429 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.02 mi
Setting
urban (7,132 people per sq mi)
People within 3 mi
201,656 (152,316 adults 21+, 76,988 households) from 45 tract(s), tracts within 3 mi
Income
per capita $108,082 · median household ~$201,989 (weighted mean of tract medians)
Age and education
median age ~38.0 · bachelor's or higher 76%
Ethnicity
Hispanic 12% · White 32% · Black 2% · Asian 50%
Adults per alcohol outlet
354
Alcohol spend within 3 mi
$87,668,609 a year ($36,424,546 at home, $51,223,881 away) · $203,880 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-12 17:29insertab-inbev 2743791 ↔ ca-abc 00456461|21|APP|0Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2743791 ↔ ca-abc 00456461|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2743791 ↔ vtinfo 61586ea105ac15acsame address and namemerged12
2026-11-12 14:25insertoverture faaf3f4e-761f-4904-ab8c-94ae23fa53d2 ↔ ubereats mGj5VaJjUqy_h38AXQryPgsame address and namemerged12
2026-11-12 14:25insertca-abc 00456461|21|APP|0 ↔ ubereats mGj5VaJjUqy_h38AXQryPgsame address and namemerged12
2026-11-12 14:25insertca-abc 00456461|21|LIC|0 ↔ ubereats mGj5VaJjUqy_h38AXQryPgsame address and namemerged12
2026-11-06 18:13insertca-abc 00456461|21|APP|0 ↔ overture faaf3f4e-761f-4904-ab8c-94ae23fa53d2same address and namemerged11
2026-11-06 18:13insertca-abc 00456461|21|LIC|0 ↔ overture faaf3f4e-761f-4904-ab8c-94ae23fa53d2same address and namemerged11
2026-10-09 13:59backfillca-abc 00456461|21|APP|0 ↔ ca-abc 00456461|21|LIC|0one licence filemerged