AJS FINE FOODS

SCOTTSDALE, AZ 85255 · Oa912471b15fe · first seen 2026-10-08
4 sourcesoff premisealcohol: alcohol

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
AJS FINE FOODS 3 other
the most common name a source states
AJ's Fine Foods overture
aj's fine foods deli scottsdale doordash
ajs fine foods scottsdale doordash
Street
23251 North Pima Road 1 other
doordash
23251 N PIMA RD ab-inbevoverturevtinfo ×3
City
Scottsdale
doordashno other value
State
AZ
doordashno other value
ZIP
85255
doordashno other value
Pin
33.69692, -111.88861 map
doordashno other value
Phone
4805635070
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofc3745262f04; Oabf152eee351; Oaba8277aa942; Odb2b1f1b9350

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-inbevAJS FINE FOODS
101633
23251 N PIMA RD, SCOTTSDALE, AZ, 8525533.69684, -111.888862026-11-132026-11-13
doordashajs fine foods scottsdale
23612715
23251 North Pima Road, Scottsdale, AZ, 8525533.69692, -111.888612026-10-082026-11-06
doordashaj's fine foods deli scottsdale
24654313
23251 North Pima Road, Scottsdale, AZ, 8525533.69692, -111.888612026-10-082026-11-14
overtureAJ's Fine Foods
13ceb7b5-b0bf-4dba-85d0-e7491f050ba2
23251 N Pima Rd, Scottsdale, AZ, 85255480563507033.69683, -111.888762026-11-062026-11-06
vtinfoAJS FINE FOODS
0040388a6a27235c
23251 N PIMA RD, SCOTTSDALE, AZ, 85255480563507033.69684, -111.888512026-11-112026-11-11

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 AJS FINE FOODSdoordash ajs fine foods scottsdale1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ab-inbev AJS FINE FOODSoverture AJ's Fine Foods1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev AJS FINE FOODSvtinfo AJS FINE FOODS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
doordash ajs fine foods scottsdaleoverture AJ's Fine Foods1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
doordash ajs fine foods scottsdalevtinfo AJS FINE FOODS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
overture AJ's Fine Foodsvtinfo AJS FINE FOODS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00 · phone: equal
ab-inbev AJS FINE FOODSdoordash aj's fine foods deli scottsdale0.80same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, fine, foods · name Jaro-Winkler 0.89 · same street + ZIP · pins 25 m apart · name similarity 0.80
doordash aj's fine foods deli scottsdaleoverture AJ's Fine Foods0.80same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, fine, foods · name Jaro-Winkler 0.89 · same street + ZIP · pins 18 m apart · name similarity 0.80
doordash aj's fine foods deli scottsdalevtinfo AJS FINE FOODS0.80same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, fine, foods · name Jaro-Winkler 0.89 · same street + ZIP · pins 13 m apart · name similarity 0.80

Attributes

Channel
off_premise — doordash-url conflicting evidence
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Bell's Brewery, Boston Beer +11 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
20 within 1 mi · 120 within 3 mi
Off / on premise
4 / 12 within 1 mi · 23 / 64 within 3 mi
Selling alcohol
15 within 1 mi · 75 within 3 mi
Nearest
same channel 0.11 mi · licensed 1.63 mi
Setting
suburban (752 people per sq mi)
People within 3 mi
21,273 (16,854 adults 21+, 9,409 households) from 5 tract(s), tracts within 3 mi
Income
per capita $86,959 · median household ~$136,726 (weighted mean of tract medians)
Age and education
median age ~50.7 · bachelor's or higher 65%
Ethnicity
Hispanic 9% · White 85% · Black 1% · Asian 5%
Adults per alcohol outlet
222
Alcohol spend within 3 mi
$8,910,042 a year ($3,813,263 at home, $5,093,824 away) · $117,237 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-14 20:23updatedoordash 24654313 ↔ overture 13ceb7b5-b0bf-4dba-85d0-e7491f050ba2same address and namemerged15
2026-11-14 20:23updatedoordash 24654313 ↔ vtinfo 0040388a6a27235csame address and namemerged15
2026-11-14 20:23updateab-inbev 101633 ↔ doordash 24654313same address and namemerged15
2026-11-13 19:03insertdoordash 24654313 ↔ overture 13ceb7b5-b0bf-4dba-85d0-e7491f050ba2same address and nameheld: same-source-conflict15
2026-11-13 19:03insertdoordash 24654313 ↔ vtinfo 0040388a6a27235csame address and nameheld: same-source-conflict15
2026-11-13 19:03insertab-inbev 101633 ↔ doordash 24654313same address and nameheld: same-source-conflict15
2026-11-13 17:47insertab-inbev 101633 ↔ doordash 23612715same address and namemerged15
2026-11-13 17:47insertab-inbev 101633 ↔ overture 13ceb7b5-b0bf-4dba-85d0-e7491f050ba2same address and namemerged15
2026-11-13 17:47insertab-inbev 101633 ↔ vtinfo 0040388a6a27235csame address and namemerged15
2026-11-11 12:56insertdoordash 23612715 ↔ vtinfo 0040388a6a27235csame address and namemerged12
2026-11-11 12:56insertoverture 13ceb7b5-b0bf-4dba-85d0-e7491f050ba2 ↔ vtinfo 0040388a6a27235csame address and namemerged12
2026-11-06 18:13insertdoordash 23612715 ↔ overture 13ceb7b5-b0bf-4dba-85d0-e7491f050ba2same address and namemerged11