Ace Hardware

Madison, SD 57042 · O0f1b73baa10b · first seen 2026-10-08
3 sourcesoff premise · retail_otherchain: 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
Ace Hardware 2 other
the most common name a source states
ace hardware madison doordash
Madison Ace Hardware overture
Street
800 Washington Ave South 2 other
ubereats
800 S Washington Ave doordash
800 Washington Ave S overture
City
Madison
ubereatsno other value
State
SD
ubereatsno other value
ZIP
57042
ubereatsno other value
Pin
43.99672, -97.10805 map
ubereatsno other value
Phone
6052563981
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odb6e1023b45d; Ofea4005db10c

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 madison
30935330
800 S Washington Ave, Madison, SD, 5704243.99667, -97.107952026-10-082026-11-03
overtureMadison Ace Hardware
f3e2d331-1403-4eae-a563-7cfcbc665d44
800 Washington Ave S, Madison, SD, 57042605256398143.99663, -97.107852026-11-062026-11-06
ubereatsAce Hardware
TpPlwuzTV6OAq2B0LhxEUw
800 Washington Ave South, Madison, SD, 5704243.99672, -97.108052026-11-032026-11-03

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 madisonoverture Madison Ace Hardware1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 9 m apart · name similarity 1.00 · street similarity 0.93
doordash ace hardware madisonubereats Ace Hardware1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 10 m apart · name similarity 1.00 · street similarity 0.93
overture Madison Ace Hardwareubereats Ace Hardware0.71same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 19 m apart · name similarity 0.71

Attributes

Channel
off_premise · retail_other — ubereats-type
Chain
Ace Hardware — ubereats-parent
Alcohol
no_alcohol_retail — Ace Hardware: licensed at 5 of 1338 outlets in licence states
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "retail_other"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
10 within 1 mi · 13 within 3 mi
Off / on premise
4 / 6 within 1 mi · 5 / 8 within 3 mi
Selling alcohol
2 within 1 mi · 3 within 3 mi
Nearest
same channel 0.19 mi · licensed none within 3 mi
Setting
rural (219 people per sq mi)
People within 3 mi
6,178 (4,406 adults 21+, 2,604 households) from 2 tract(s), tracts within 3 mi
Income
per capita $36,913 · median household ~$63,367 (weighted mean of tract medians)
Age and education
median age ~42.5 · bachelor's or higher 34%
Ethnicity
Hispanic 4% · White 95% · Black 1% · Asian 1%
Adults per alcohol outlet
1,469
Alcohol spend within 3 mi
$1,429,769 a year ($684,908 at home, $744,310 away) · $476,590 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:13insertoverture f3e2d331-1403-4eae-a563-7cfcbc665d44 ↔ ubereats TpPlwuzTV6OAq2B0LhxEUwsame address and namemerged11
2026-11-06 18:13insertdoordash 30935330 ↔ overture f3e2d331-1403-4eae-a563-7cfcbc665d44street written two waysmerged11
2026-11-03 14:30backfilldoordash 30935330 ↔ ubereats TpPlwuzTV6OAq2B0LhxEUwstreet written two waysmerged