Mr. Pickles Sandwich Shop - Union City

Union City, CA 94587 · O3c72c8f21738 · first seen 2026-10-08
3 sourceson premise · restaurantchain: Mr Pickles Sandwich Shopalcohol: unknown

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
Mr. Pickles Sandwich Shop - Union City 2 other
the most common name a source states
Mr. Pickle's Sandwich Shop - Union City, CA overture
mr. pickle's sandwich shop union city doordash
Street
33354 Alvarado Niles Rd 1 other
ubereats
33354 Alvarado-Niles Road doordashoverture ×2
City
Union City
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94587
ubereatsno other value
Pin
37.59246, -122.03848 map
ubereatsno other value
Phone
5104313488
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofe533ecc6cef; O558753a0ce30

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
doordashmr. pickle's sandwich shop union city
27818073
33354 Alvarado-Niles Road, Union City, CA, 9458737.59250, -122.038482026-10-082026-11-06
overtureMr. Pickle's Sandwich Shop - Union City, CA
4c4cbcef-c20a-499f-9c83-0b744cabba5e
33354 Alvarado-Niles Road, Union City, CA, 94587510431348837.59251, -122.038452026-11-062026-11-06
ubereatsMr. Pickles Sandwich Shop - Union City
VY3alV0VSYSSuYIF8yF7fw
33354 Alvarado Niles Rd, Union City, CA, 9458737.59246, -122.038482026-10-152026-11-06

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
doordash mr. pickle's sandwich shop union cityoverture Mr. Pickle's Sandwich Shop - Union City, CA0.89same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.86 · same street + ZIP · pins 3 m apart · name similarity 0.89
overture Mr. Pickle's Sandwich Shop - Union City, CAubereats Mr. Pickles Sandwich Shop - Union City0.89same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.86 · same street + ZIP · pins 5 m apart · name similarity 0.89
doordash mr. pickle's sandwich shop union cityubereats Mr. Pickles Sandwich Shop - Union City0.78Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair)
Same chain name (Mr. Pickle's Sandwich Shop Union City) at the identical street address and ZIP, 4 m apart, with only one business known at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records name Mr. Pickles Sandwich Shop in Union City at the same street address and ZIP (33354 Alvarado-Niles Rd) with coordinates 4 m apart, and no other business is held at that address, so they are one storefront listed on two delivery apps.
pair ef13594288de785d70ca

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Mr Pickles Sandwich Shop — ubereats-parent
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
49 within 1 mi · 456 within 3 mi
Off / on premise
13 / 26 within 1 mi · 105 / 299 within 3 mi
Selling alcohol
29 within 1 mi · 231 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.04 mi
Setting
urban (5,560 people per sq mi)
People within 3 mi
157,201 (123,090 adults 21+, 50,626 households) from 32 tract(s), tracts within 3 mi
Income
per capita $65,235 · median household ~$157,534 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 51%
Ethnicity
Hispanic 18% · White 18% · Black 4% · Asian 56%
Adults per alcohol outlet
533
Alcohol spend within 3 mi
$52,170,165 a year ($22,071,373 at home, $30,083,052 away) · $225,845 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-06 18:13insertoverture 4c4cbcef-c20a-499f-9c83-0b744cabba5e ↔ ubereats VY3alV0VSYSSuYIF8yF7fwsame address and namemerged11
2026-11-06 18:13insertdoordash 27818073 ↔ overture 4c4cbcef-c20a-499f-9c83-0b744cabba5esame address and namemerged11
2026-11-02 23:02backfilldoordash 27818073 ↔ ubereats VY3alV0VSYSSuYIF8yF7fwClaude judge: samemerged