Ace Hardware

Piqua, OH 45356 · O19dd157decbe · 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 piqua doordash
Piqua Ace Hardware overture
Street
1942 Covington Ave
ubereatsno other value
City
Piqua
ubereatsno other value
State
OH
ubereatsno other value
ZIP
45356
ubereatsno other value
Pin
40.14012, -84.27589 map
ubereatsno other value
Phone
9377731612
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of62507919083; Ocfcf3b0c7c12

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 piqua
30936160
1942 Covington Ave, Piqua, OH, 4535640.14006, -84.275912026-10-082026-10-26
overturePiqua Ace Hardware
63a63425-858b-4214-a8b7-51c694d1b617
1942 Covington Ave, Piqua, OH, 45356937773161240.14005, -84.275922026-11-062026-11-06
ubereatsAce Hardware
jN5yg0XcWZ6vbVckiU3E2g
1942 Covington Ave, Piqua, OH, 4535640.14012, -84.275892026-11-092026-11-09

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 piquaoverture 1eca0f65-93b8-468b-ba75-3d14c0ba81f11.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 842 m apart · name similarity 1.00
doordash ace hardware piquaoverture bc4fa8ca-82f1-4b6c-8709-08c8f71e8d0d1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
overture 1eca0f65-93b8-468b-ba75-3d14c0ba81f1ubereats Ace Hardware0.73same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 839 m apart · name similarity 0.73
overture bc4fa8ca-82f1-4b6c-8709-08c8f71e8d0dubereats Ace Hardware0.73same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 3 m apart · name similarity 0.73
doordash ace hardware piquaoverture Piqua Ace Hardware1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
doordash ace hardware piquaubereats Ace Hardware1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
overture Piqua Ace Hardwareubereats Ace Hardware0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 8 m apart · name similarity 0.73

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
26 within 1 mi · 82 within 3 mi
Off / on premise
6 / 17 within 1 mi · 18 / 45 within 3 mi
Selling alcohol
13 within 1 mi · 56 within 3 mi
Nearest
same channel 0.17 mi · licensed 1.37 mi
Setting
suburban (692 people per sq mi)
People within 3 mi
19,567 (14,735 adults 21+, 8,311 households) from 4 tract(s), tracts within 3 mi
Income
per capita $32,523 · median household ~$68,131 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 16%
Ethnicity
Hispanic 1% · White 92% · Black 2% · Asian 0%
Adults per alcohol outlet
263
Alcohol spend within 3 mi
$4,411,162 a year ($2,132,506 at home, $2,276,436 away) · $78,771 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-09 14:23insertoverture bc4fa8ca-82f1-4b6c-8709-08c8f71e8d0d ↔ ubereats jN5yg0XcWZ6vbVckiU3E2gsame address and nameheld: same-source-conflict11
2026-11-09 14:23insertoverture 1eca0f65-93b8-468b-ba75-3d14c0ba81f1 ↔ ubereats jN5yg0XcWZ6vbVckiU3E2gsame address and nameheld: same-source-conflict11
2026-11-09 14:23insertoverture 63a63425-858b-4214-a8b7-51c694d1b617 ↔ ubereats jN5yg0XcWZ6vbVckiU3E2gsame address and namemerged11
2026-11-09 14:23insertdoordash 30936160 ↔ ubereats jN5yg0XcWZ6vbVckiU3E2gsame address and namemerged11
2026-11-06 18:13insertdoordash 30936160 ↔ overture bc4fa8ca-82f1-4b6c-8709-08c8f71e8d0dsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 30936160 ↔ overture 1eca0f65-93b8-468b-ba75-3d14c0ba81f1same address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 30936160 ↔ overture 63a63425-858b-4214-a8b7-51c694d1b617same address and namemerged11