Mission Food and Liquor

UNION CITY, CA 94587 · O3680fd57ffe8 · first seen 2026-10-08
6 sourcesoff premise · liquor_storealcohol: 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
Mission Food and Liquor 3 other
a source's own spelling of the licence name (record_title.py)
MISSION FOOD & LIQUOR ab-inbevca-abcvtinfo ×3
mission food and liquor union city doordash
SANDHU BROTHERS LIQUOR INC ca-abc (legal name)
Street
101 DECOTO RD 1 other
ca-abc
101 Decoto Road doordashubereats ×2
City
UNION CITY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94587
ca-abcno other value
Pin
37.60261, -122.01639 map 2 other
ubereats
109 m away ab-inbev
77 m away ca-abc
Phone
5104418800
vtinfono other value
Licences
ca-abc 00464629|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7ad5e36b71c7; O9ff6252d3d72; Oc09775d7f888; O6a4679987d29; O582a92738910

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-inbevMISSION FOOD & LIQUOR
1884661
101 DECOTO RD, UNION CITY, CA, 9458737.60164, -122.016622026-11-112026-11-13
ca-abcMISSION FOOD & LIQUOR
legal name: SANDHU BROTHERS LIQUOR INC
00464629|21|LIC|0
101 DECOTO RD, UNION CITY, CA, 9458737.60193, -122.016212026-10-082026-11-13
doordashmission food and liquor union city
319075
101 Decoto Road, Union City, CA, 9458737.60263, -122.016442026-10-082026-11-13
overtureMission Food and Liquor
adc58b9c-b077-4af6-8cbe-2e8b37bfbe8b
101 Decoto Rd, Union City, CA, 94587510441880037.60260, -122.016312026-11-062026-11-13
ubereatsMission Food and Liquor
esJqEwsPQ0eHqnIqoYPy0g
101 Decoto Road, Union City, CA, 9458737.60261, -122.016392026-10-082026-11-13
vtinfoMISSION FOOD & LIQUOR
a6e902ce5ad6a594
101 DECOTO RD, UNION CITY, CA, 94587510441880037.60229, -122.016262026-11-132026-11-13

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 MISSION FOOD & LIQUORca-abc MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ab-inbev MISSION FOOD & LIQUORdoordash mission food and liquor union city1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 111 m apart · name similarity 1.00
ab-inbev MISSION FOOD & LIQUORoverture Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 110 m apart · name similarity 1.00
ab-inbev MISSION FOOD & LIQUORubereats Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 109 m apart · name similarity 1.00
ab-inbev MISSION FOOD & LIQUORvtinfo MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 79 m apart · name similarity 1.00
ca-abc MISSION FOOD & LIQUORdoordash mission food and liquor union city1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc MISSION FOOD & LIQUORoverture Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
ca-abc MISSION FOOD & LIQUORubereats Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name similarity 1.00
ca-abc MISSION FOOD & LIQUORvtinfo MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
doordash mission food and liquor union cityoverture Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
doordash mission food and liquor union cityubereats Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
doordash mission food and liquor union cityvtinfo MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
overture Mission Food and Liquorubereats Mission Food and Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
overture Mission Food and Liquorvtinfo MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00 · phone: equal
ubereats Mission Food and Liquorvtinfo MISSION FOOD & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SANDHU BROTHERS LIQUOR INC — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
40 within 1 mi · 341 within 3 mi
Off / on premise
6 / 27 within 1 mi · 81 / 219 within 3 mi
Selling alcohol
14 within 1 mi · 175 within 3 mi
Nearest
same channel 0.15 mi · licensed 0.15 mi
Setting
urban (4,028 people per sq mi)
People within 3 mi
113,880 (89,569 adults 21+, 36,745 households) from 22 tract(s), tracts within 3 mi
Income
per capita $63,283 · median household ~$154,016 (weighted mean of tract medians)
Age and education
median age ~41.6 · bachelor's or higher 48%
Ethnicity
Hispanic 23% · White 20% · Black 4% · Asian 51%
Adults per alcohol outlet
509
Alcohol spend within 3 mi
$37,386,139 a year ($15,875,657 at home, $21,498,961 away) · $212,421 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-13 14:10insertoverture adc58b9c-b077-4af6-8cbe-2e8b37bfbe8b ↔ vtinfo a6e902ce5ad6a594same address and namemerged15
2026-11-13 14:10insertab-inbev 1884661 ↔ vtinfo a6e902ce5ad6a594same address and namemerged15
2026-11-13 14:10insertdoordash 319075 ↔ vtinfo a6e902ce5ad6a594same address and namemerged15
2026-11-13 14:10insertubereats esJqEwsPQ0eHqnIqoYPy0g ↔ vtinfo a6e902ce5ad6a594same address and namemerged15
2026-11-13 14:10insertca-abc 00464629|21|LIC|0 ↔ vtinfo a6e902ce5ad6a594same address and namemerged15
2026-11-11 12:56insertab-inbev 1884661 ↔ overture adc58b9c-b077-4af6-8cbe-2e8b37bfbe8bsame address and namemerged12
2026-11-11 12:56insertab-inbev 1884661 ↔ ca-abc 00464629|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 1884661 ↔ doordash 319075same address and namemerged12
2026-11-11 12:56insertab-inbev 1884661 ↔ ubereats esJqEwsPQ0eHqnIqoYPy0gsame address and namemerged12
2026-11-06 18:13insertca-abc 00464629|21|LIC|0 ↔ overture adc58b9c-b077-4af6-8cbe-2e8b37bfbe8bsame address and namemerged11
2026-11-06 18:13insertdoordash 319075 ↔ overture adc58b9c-b077-4af6-8cbe-2e8b37bfbe8bsame address and namemerged11
2026-11-06 18:13insertoverture adc58b9c-b077-4af6-8cbe-2e8b37bfbe8b ↔ ubereats esJqEwsPQ0eHqnIqoYPy0gsame address and namemerged11
2026-10-09 13:59backfillca-abc 00464629|21|LIC|0 ↔ doordash 319075same address and namemerged
2026-10-09 13:59backfilldoordash 319075 ↔ ubereats esJqEwsPQ0eHqnIqoYPy0gsame address and namemerged
2026-10-08 21:18backfillca-abc 00464629|21|LIC|0 ↔ ubereats esJqEwsPQ0eHqnIqoYPy0gsame address and namemerged