Soni's Market & Liquor

Upland, CA 91786 · O29f0b4711843 · first seen 2026-10-08
6 sourcesoff premise · conveniencealcohol: 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
Soni's Market & Liquor 4 other
a source's own spelling of the licence name (record_title.py)
SONIS MARKET & LIQUOR ab-inbevca-abcvtinfo ×3
Soni's Liquor & Market ubereats
Soni's Liquor and Market overture
SONIS H&S INC ca-abc (legal name)
Street
197 S 2ND AVE
ca-abcno other value
City
UPLAND
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91786
ca-abcno other value
Pin
34.09274, -117.64855 map 1 other
ubereats
95 m away ab-inbev
Phone
9099822328 1 other
vtinfo
9099816000 overture
Licences
ca-abc 00651847|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4d6107ce82a1; O7b641bd2425b; O397fe97f1d8c; O34404d860932; O3f1fe1db5124

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-inbevSONIS MARKET & LIQUOR
4152762
197 S 2ND AVE, UPLAND, CA, 9178634.09359, -117.648672026-11-112026-11-12
ca-abcSONIS MARKET & LIQUOR
legal name: SONIS H&S INC
00651847|21|LIC|0
197 S 2ND AVE, UPLAND, CA, 9178634.09257, -117.648622026-10-082026-11-12
overtureSoni's Liquor and Market
f790512b-7a36-4df2-baf5-3306038e9c8b
197 S 2nd Ave, Upland, CA, 91786909981600034.09255, -117.648692026-11-062026-11-12
snapSoni's Market & Liquor
snap|us|1065708
197 S 2nd Ave, Upland, CA, 9178634.09259, -117.648602026-11-192026-11-19
ubereatsSoni's Liquor & Market
arXxgIT3Raij_Wck1tFxlQ
197 S 2nd Ave, Upland, CA, 9178634.09274, -117.648552026-10-082026-11-12
vtinfoSONIS MARKET & LIQUOR
ff0ab0a20c320e9d
197 S 2ND AVE, UPLAND, CA, 91786909982232834.09297, -117.648722026-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
ca-abc SONIS MARKET & LIQUORoverture 6a985d9e-466f-4080-9032-c4099a490b181.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
overture 6a985d9e-466f-4080-9032-c4099a490b18ubereats Soni's Liquor & Market1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev SONIS MARKET & LIQUORca-abc SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 114 m apart · name similarity 1.00
ab-inbev SONIS MARKET & LIQUORoverture Soni's Liquor and Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 116 m apart · name similarity 1.00
ab-inbev SONIS MARKET & LIQUORsnap Soni's Market & Liquor1.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 SONIS MARKET & LIQUORubereats Soni's Liquor & Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · name similarity 1.00
ab-inbev SONIS MARKET & LIQUORvtinfo SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 69 m apart · name similarity 1.00
ca-abc SONIS MARKET & LIQUORoverture Soni's Liquor and Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ca-abc SONIS MARKET & LIQUORsnap Soni's Market & Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ca-abc SONIS MARKET & LIQUORvtinfo SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 46 m apart · name similarity 1.00
overture Soni's Liquor and Marketsnap Soni's Market & Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
overture Soni's Liquor and Marketubereats Soni's Liquor & Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
overture Soni's Liquor and Marketvtinfo SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00 · phone: differs
snap Soni's Market & Liquorubereats Soni's Liquor & Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
snap Soni's Market & Liquorvtinfo SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ubereats Soni's Liquor & Marketvtinfo SONIS MARKET & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
ca-abc SONIS MARKET & LIQUORubereats Soni's Liquor & Market0.66Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The names agree once punctuation and word order are set aside ('Sonis Market & Liquor' vs 'Soni's Liquor & Market'), and both records give the identical street address and ZIP, so the names match desp
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records sit at 197 S 2nd Ave, Upland 91786, and the names are near-identical ('SONIS MARKET & LIQUOR' vs 'Soni's Liquor & Market'), with the ABC off-sale licence matching a liquor store/market, so the name agreement outweighs the shared building (3 businesses at the address).
pair 944566dfde4a5daf825c

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SONIS H&S INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
58 within 1 mi · 935 within 3 mi
Off / on premise
16 / 28 within 1 mi · 252 / 534 within 3 mi
Selling alcohol
45 within 1 mi · 508 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (6,905 people per sq mi)
People within 3 mi
195,221 (141,650 adults 21+, 62,183 households) from 41 tract(s), tracts within 3 mi
Income
per capita $35,595 · median household ~$90,870 (weighted mean of tract medians)
Age and education
median age ~35.3 · bachelor's or higher 26%
Ethnicity
Hispanic 61% · White 29% · Black 7% · Asian 8%
Adults per alcohol outlet
278
Alcohol spend within 3 mi
$44,119,606 a year ($20,049,766 at home, $24,048,382 away) · $86,679 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-19 20:37insertsnap snap|us|1065708 ↔ vtinfo ff0ab0a20c320e9dsame address and namemerged17
2026-11-19 20:37insertca-abc 00651847|21|LIC|0 ↔ snap snap|us|1065708same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1065708 ↔ ubereats arXxgIT3Raij_Wck1tFxlQsame address and namemerged17
2026-11-19 20:37insertoverture f790512b-7a36-4df2-baf5-3306038e9c8b ↔ snap snap|us|1065708same address and namemerged17
2026-11-19 20:37insertab-inbev 4152762 ↔ snap snap|us|1065708same address and namemerged17
2026-11-12 14:25insertca-abc 00651847|21|LIC|0 ↔ vtinfo ff0ab0a20c320e9dsame address and namemerged12
2026-11-12 14:25insertubereats arXxgIT3Raij_Wck1tFxlQ ↔ vtinfo ff0ab0a20c320e9dsame address and namemerged12
2026-11-12 14:25insertoverture f790512b-7a36-4df2-baf5-3306038e9c8b ↔ vtinfo ff0ab0a20c320e9dsame address and namemerged12
2026-11-12 14:25insertab-inbev 4152762 ↔ vtinfo ff0ab0a20c320e9dsame address and namemerged12
2026-11-11 12:56insertab-inbev 4152762 ↔ overture f790512b-7a36-4df2-baf5-3306038e9c8bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4152762 ↔ ca-abc 00651847|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4152762 ↔ ubereats arXxgIT3Raij_Wck1tFxlQsame address and namemerged12
2026-11-06 18:13insertca-abc 00651847|21|LIC|0 ↔ overture 6a985d9e-466f-4080-9032-c4099a490b18same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00651847|21|LIC|0 ↔ overture f790512b-7a36-4df2-baf5-3306038e9c8bsame address and namemerged11
2026-11-06 18:13insertoverture 6a985d9e-466f-4080-9032-c4099a490b18 ↔ ubereats arXxgIT3Raij_Wck1tFxlQsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture f790512b-7a36-4df2-baf5-3306038e9c8b ↔ ubereats arXxgIT3Raij_Wck1tFxlQsame address and namemerged11
2026-11-02 23:02backfillca-abc 00651847|21|LIC|0 ↔ ubereats arXxgIT3Raij_Wck1tFxlQClaude judge: samemerged