STOP N SHOP

FRESNO, CA 93726 · O249d809fc4b5 · first seen 2026-10-08
3 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
STOP N SHOP 2 other
the most common name a source states
SHOP N STOP LIQUOR 2 ca-abc
SINGH KANWAL PREET ca-abc (legal name)
Street
4588 E SHIELDS AVE
ca-abcno other value
City
FRESNO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93726
ca-abcno other value
Pin
36.77949, -119.74566 map 1 other
ca-abc
174 m away ab-inbev
Phone
5592660845
vtinfono other value
Licences
ca-abc 00355706|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O902c251db812; O7c647d72b6f8

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-inbevSTOP N SHOP
2766875
4588 E SHIELDS AVE, FRESNO, CA, 9372636.77944, -119.747622026-11-112026-11-12
ca-abcSHOP N STOP LIQUOR 2
legal name: SINGH KANWAL PREET
00355706|21|LIC|0
4588 E SHIELDS AVE, FRESNO, CA, 9372636.77949, -119.745662026-10-082026-11-05
vtinfoSTOP N SHOP
a2030d73dc5ade04
4588 E SHIELDS AVE, FRESNO, CA, 93726559266084536.77919, -119.745852026-11-122026-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 STOP N SHOPvtinfo STOP N SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 160 m apart · name similarity 1.00
ab-inbev STOP N SHOPca-abc SHOP N STOP LIQUOR 20.54Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
Stop N Shop vs Shop N Stop, same address, store
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records sit at 4588 E Shields Ave, Fresno, and the names are close variants ('STOP N SHOP' and 'SHOP N STOP LIQUOR 2'), with the CA ABC record an active off-sale liquor store that fits an AB InBev beer account, though the shared building and the '2' suffix leave some doubt.
pair 4be4aca37c12ae9a4dad

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
52 within 1 mi · 745 within 3 mi
Off / on premise
15 / 29 within 1 mi · 261 / 398 within 3 mi
Selling alcohol
33 within 1 mi · 407 within 3 mi
Nearest
same channel 0.43 mi · licensed 0.43 mi
Setting
urban (5,906 people per sq mi)
People within 3 mi
166,997 (110,881 adults 21+, 54,309 households) from 37 tract(s), tracts within 3 mi
Income
per capita $23,432 · median household ~$55,649 (weighted mean of tract medians)
Age and education
median age ~31.4 · bachelor's or higher 14%
Ethnicity
Hispanic 60% · White 28% · Black 5% · Asian 13%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$26,981,428 a year ($13,123,189 at home, $13,844,532 away) · $66,131 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 2766875 ↔ ca-abc 00355706|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2766875 ↔ vtinfo a2030d73dc5ade04same address and namemerged12