Outlets /
Niles Liquors Mini Mart
UNION CITY, CA 94587 · O62ae0a052da5 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Niles Liquorsalcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Niles Liquors Mini Mart 4 other | a licence name in capitals, cleaned (derived; record_title.py) | Niles Liquors overtureubereats ×2 NILES LIQUOR ca-abc niles liquors union city doordash SBC LIQUORS INC ca-abc (legal name) |
| Street | 34359 ALVARADO NILES RD 1 other | ca-abc | 34359 Alvarado-Niles Road doordashubereats ×2 |
| City | UNION CITY | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94587 | ca-abc | no other value |
| Pin | 37.58722, -122.02288 map | ubereats | no other value |
| Phone | 5104411163 | vtinfo | no other value |
| Licences | ca-abc 00528448|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oa9eb40f5fca0; Oba493a0d5fbc; O9ba628424dba; O9081c4091bf7; O8ec25a895632
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | NILES LIQUORS MINI MART 2907397 | 34359 ALVARADO NILES RD, UNION CITY, CA, 94587 | 37.58740, -122.02260 | 2026-11-11 | 2026-11-16 | |
| ca-abc | NILES LIQUOR legal name: SBC LIQUORS INC 00528448|21|LIC|0 | 34359 ALVARADO NILES RD, UNION CITY, CA, 94587 | 37.58750, -122.02289 | 2026-10-08 | 2026-11-06 | |
| doordash | niles liquors union city 93135 | 34359 Alvarado-Niles Road, Union City, CA, 94587 | 37.58722, -122.02294 | 2026-10-08 | 2026-11-06 | |
| overture | Niles Liquors dbfabc78-6c79-42ba-8940-cb16dcad3b52 | 34359 Alvarado Niles Rd, Union City, CA, 94587 | 5104411163 | 37.58727, -122.02294 | 2026-11-06 | 2026-11-06 |
| ubereats | Niles Liquors _CXr_a1oSqiwOsWmMXM8ow | 34359 Alvarado-Niles Road, Union City, CA, 94587 | 37.58722, -122.02288 | 2026-10-14 | 2026-11-06 | |
| vtinfo | NILES LIQUORS MINI MART d747ad2853a01e91 | 34359 ALVARADO NILES RD, UNION CITY, CA, 94587 | 5104411163 | 37.58738, -122.02275 | 2026-11-13 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev NILES LIQUORS MINI MART | vtinfo NILES LIQUORS MINI MART | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00 |
| doordash niles liquors union city | overture Niles Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 |
| doordash niles liquors union city | ubereats Niles Liquors | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 |
| overture Niles Liquors | ubereats Niles Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 |
| ca-abc NILES LIQUOR | doordash niles liquors union city | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair) The names agree: 'Niles Liquor' and the slug 'niles liquors union city' both name a liquor store, and both records give the same street address and ZIP in Union City, so the shared building does not u Other Claude answers on this pair:
pair 38fc14d53db2ad144927 |
| ca-abc NILES LIQUOR | overture Niles Liquors | 0.65 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 25 m apart · name similarity 0.65 |
| ca-abc NILES LIQUOR | ubereats Niles Liquors | 0.65 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The names Niles Liquor and Niles Liquors agree apart from the plural, both records give the same street address and ZIP, and the off-sale licence fits a liquor store, so the shared building does not u Other Claude answers on this pair:
pair 8f63879ebe3046e87c80 |
| ab-inbev NILES LIQUORS MINI MART | doordash niles liquors union city | 0.61 | one name contains the other, same address | merged | judge: None · pair_id: 7fc330e2b00c8738b578 · person: None · rule: names contained at one address · stratum: near |
| ab-inbev NILES LIQUORS MINI MART | ubereats Niles Liquors | 0.61 | one name contains the other, same address | merged | judge: None · pair_id: 5cb08b7d8877fae7c547 · person: None · rule: names contained at one address · stratum: near |
| doordash niles liquors union city | vtinfo NILES LIQUORS MINI MART | 0.61 | one name contains the other, same address | merged | judge: None · pair_id: 14b220b17b9ec97e2956 · person: None · rule: names contained at one address · stratum: near |
| ubereats Niles Liquors | vtinfo NILES LIQUORS MINI MART | 0.61 | one name contains the other, same address | merged | judge: None · pair_id: 2792ca86e263ca00ad3b · person: None · rule: names contained at one address · stratum: near |
| ab-inbev NILES LIQUORS MINI MART | ca-abc NILES LIQUOR | 0.44 | one name contains the other, same address | merged | judge: None · pair_id: ff477fba3ebe8b96c516 · person: None · rule: names contained at one address · stratum: same-address |
| ca-abc NILES LIQUOR | vtinfo NILES LIQUORS MINI MART | 0.44 | one name contains the other, same address | merged | judge: None · pair_id: d4b073ad547695b319d5 · person: None · rule: names contained at one address · stratum: same-address |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- Niles Liquors — ubereats-parent
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- SBC LIQUORS INC — 4 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
],
[
"ubereats-type",
"off_premise",
"liquor_store"
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 74 within 1 mi · 456 within 3 mi
- Off / on premise
- 13 / 51 within 1 mi · 110 / 301 within 3 mi
- Selling alcohol
- 37 within 1 mi · 230 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.02 mi
- Setting
- urban (5,383 people per sq mi)
- People within 3 mi
- 152,205 (117,834 adults 21+, 49,496 households) from 30 tract(s), tracts within 3 mi
- Income
- per capita $65,866 · median household ~$159,760 (weighted mean of tract medians)
- Age and education
- median age ~41.2 · bachelor's or higher 51%
- Ethnicity
- Hispanic 19% · White 20% · Black 4% · Asian 54%
- Adults per alcohol outlet
- 510
- Alcohol spend within 3 mi
- $51,401,852 a year ($21,735,893 at home, $29,650,738 away) · $222,519 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-16 14:56 | insert | ca-abc 00528448|21|LIC|0 ↔ vtinfo d747ad2853a01e91 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 2907397 ↔ ca-abc 00528448|21|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | doordash 93135 ↔ vtinfo d747ad2853a01e91 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ubereats _CXr_a1oSqiwOsWmMXM8ow ↔ vtinfo d747ad2853a01e91 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 2907397 ↔ doordash 93135 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 2907397 ↔ ubereats _CXr_a1oSqiwOsWmMXM8ow | one name contains the other, same address | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2907397 ↔ vtinfo d747ad2853a01e91 | same address and name | merged | 15 |
| 2026-11-06 18:13 | insert | ca-abc 00528448|21|LIC|0 ↔ overture dbfabc78-6c79-42ba-8940-cb16dcad3b52 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture dbfabc78-6c79-42ba-8940-cb16dcad3b52 ↔ ubereats _CXr_a1oSqiwOsWmMXM8ow | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 93135 ↔ overture dbfabc78-6c79-42ba-8940-cb16dcad3b52 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00528448|21|LIC|0 ↔ ubereats _CXr_a1oSqiwOsWmMXM8ow | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00528448|21|LIC|0 ↔ doordash 93135 | Claude judge: same | merged | |
| 2026-10-14 18:03 | backfill | doordash 93135 ↔ ubereats _CXr_a1oSqiwOsWmMXM8ow | same address and name | merged |