Rocky's Ace Hardware

North Andover, MA 01845 · O3e387d7917cb · first seen 2026-10-08
2 sourcesoff premisechain: Ace Hardwarealcohol: no alcohol retail

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
Rocky's Ace Hardware 1 other
the most common name a source states
ace hardware north andover doordash
Street
50 Peters St
doordashno other value
City
North Andover
doordashno other value
State
MA
doordashno other value
ZIP
01845
doordashno other value
Pin
42.67549, -71.12674 map
doordashno other value
Phone
9787948571
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odff1326af9c6

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
doordashace hardware north andover
30935832
50 Peters St, North Andover, MA, 0184542.67549, -71.126742026-10-082026-11-01
overtureRocky's Ace Hardware
fba6fef1-a33f-4da4-a47a-889fffc2aa52
50 Peters St, North Andover, MA, 01845978794857142.67580, -71.126892026-11-062026-11-06

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
doordash ace hardware north andoveroverture Rocky's Ace Hardware0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 36 m apart · name similarity 0.72

Attributes

Channel
off_premise — doordash-url
Chain
Ace Hardware — name-prefix
Alcohol
no_alcohol_retail — Ace Hardware: licensed at 5 of 1338 outlets in licence states
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
54 within 1 mi · 359 within 3 mi
Off / on premise
7 / 36 within 1 mi · 59 / 224 within 3 mi
Selling alcohol
16 within 1 mi · 157 within 3 mi
Nearest
same channel 0.01 mi · licensed 1.60 mi
Setting
urban (3,040 people per sq mi)
People within 3 mi
85,960 (60,603 adults 21+, 32,090 households) from 16 tract(s), tracts within 3 mi
Income
per capita $44,385 · median household ~$91,278 (weighted mean of tract medians)
Age and education
median age ~35.6 · bachelor's or higher 39%
Ethnicity
Hispanic 50% · White 47% · Black 3% · Asian 5%
Adults per alcohol outlet
386
Alcohol spend within 3 mi
$22,611,253 a year ($10,219,397 at home, $12,382,184 away) · $144,021 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-06 18:13insertdoordash 30935832 ↔ overture fba6fef1-a33f-4da4-a47a-889fffc2aa52same address and namemerged11