AJS FINE FOODS

SCOTTSDALE, AZ 85255 · O03b9d77f1108 · 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
18271 N Pima Rd 1 other
doordash
18271 North Pima Road doordash
City
Scottsdale
doordashno other value
State
AZ
doordashno other value
ZIP
85255
doordashno other value
Pin
33.65311, -111.88579 map 1 other
doordash
128 m away ab-inbev
Phone
4809476333 1 other
vtinfo
4805383080 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc4d0c30d346f; Oc4711575a5ab; O594c75162cb7; O081f0edec801

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
2977633
18271 N PIMA RD, SCOTTSDALE, AZ, 8525533.65305, -111.887172026-11-132026-11-14
doordashajs fine foods scottsdale
23612650
18271 N Pima Rd, Scottsdale, AZ, 8525533.65311, -111.885792026-10-082026-11-14
doordashaj's fine foods deli scottsdale
24654494
18271 North Pima Road, Scottsdale, AZ, 8525533.65311, -111.885802026-10-082026-11-14
overtureAJ's Fine Foods
0027a213-3320-4af4-b8ce-114a28ea8fae
18271 N Pima Rd, Scottsdale, AZ, 85255480538308033.65305, -111.885762026-11-062026-11-14
vtinfoAJS FINE FOODS
5ed97194af356636
18271 N PIMA RD, SCOTTSDALE, AZ, 85255480947633333.65305, -111.885792026-11-112026-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
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 1368 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 1374 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 1371 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 8 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 7 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 3 m apart · name similarity 1.00 · phone: differs
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 127 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 8 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 7 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:20.
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
10 within 1 mi · 422 within 3 mi
Off / on premise
0 / 7 within 1 mi · 72 / 233 within 3 mi
Selling alcohol
6 within 1 mi · 215 within 3 mi
Nearest
same channel 1.03 mi · licensed 1.34 mi
Setting
suburban (1,775 people per sq mi)
People within 3 mi
50,181 (40,694 adults 21+, 23,982 households) from 12 tract(s), tracts within 3 mi
Income
per capita $77,383 · median household ~$114,739 (weighted mean of tract medians)
Age and education
median age ~45.9 · bachelor's or higher 63%
Ethnicity
Hispanic 10% · White 81% · Black 2% · Asian 6%
Adults per alcohol outlet
188
Alcohol spend within 3 mi
$20,065,121 a year ($8,779,998 at home, $11,278,830 away) · $92,894 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 24654494 ↔ vtinfo 5ed97194af356636same address and namemerged15
2026-11-14 20:23updatedoordash 24654494 ↔ overture 0027a213-3320-4af4-b8ce-114a28ea8faesame address and namemerged15
2026-11-14 20:23updateab-inbev 2977633 ↔ doordash 24654494same address and namemerged15
2026-11-13 17:47insertdoordash 24654494 ↔ vtinfo 5ed97194af356636same address and nameheld: same-source-conflict15
2026-11-13 17:47insertdoordash 24654494 ↔ overture 0027a213-3320-4af4-b8ce-114a28ea8faesame address and nameheld: same-source-conflict15
2026-11-13 17:47insertab-inbev 2977633 ↔ doordash 24654494same address and nameheld: same-source-conflict15
2026-11-13 17:47insertab-inbev 2977633 ↔ vtinfo 5ed97194af356636same address and namemerged15
2026-11-13 17:47insertab-inbev 2977633 ↔ doordash 23612650same address and namemerged15
2026-11-13 17:47insertab-inbev 2977633 ↔ overture 0027a213-3320-4af4-b8ce-114a28ea8faesame address and namemerged15
2026-11-11 12:56insertoverture 0027a213-3320-4af4-b8ce-114a28ea8fae ↔ vtinfo 5ed97194af356636same address and namemerged12
2026-11-11 12:56insertdoordash 23612650 ↔ vtinfo 5ed97194af356636same address and namemerged12
2026-11-06 18:13insertdoordash 23612650 ↔ overture 0027a213-3320-4af4-b8ce-114a28ea8faesame address and namemerged11