HANNAFORD

Troy, NY 12180 · O10612affd37a · first seen 2026-10-08
6 sourcesoff premise · grocerychain: Hannafordalcohol: licensed1 licence

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
HANNAFORD 4 other
the most common name a source states
HANNAFORD FOOD & PHARMACY#8450 ny-sla
Hannaford Supermarket overture
hannaford troy doordash
MARTIN'S FOODS OF SOUTH BURLINGTON LLC ny-sla (legal name)
Street
9 Lord Avenue 1 other
hannaford
9 LORD AVE ab-inbevny-slaoverturevtinfo ×4
City
Troy 1 other
hannaford
BRUNSWICK ny-sla
State
NY
hannafordno other value
ZIP
12180
hannafordno other value
Pin
42.74389, -73.65202 map 4 other
hannaford
317 m away ab-inbev
163 m away ny-sla
135 m away overture
68 m away vtinfo
Phone
5182713832
vtinfono other value
Licences
ny-sla 0081-23-206820
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of611db13a3d5; O2fb6600be3a3; O4da2051b97f0; O18de82d2efba; O50d09fe83f0d

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-inbevHANNAFORD
4573095
9 LORD AVE, TROY, NY, 1218042.74595, -73.649342026-11-112026-11-12
doordashhannaford troy
27551438
9 Lord Avenue, Troy, NY, 1218042.74380, -73.651952026-10-082026-11-12
hannafordHannaford
/ny/troy/8450
9 Lord Avenue, Troy, NY, 1218042.74389, -73.652022026-11-062026-11-12
ny-slaHANNAFORD FOOD & PHARMACY#8450
legal name: MARTIN'S FOODS OF SOUTH BURLINGTON LLC
0081-23-206820
9 LORD AVE, BRUNSWICK, NY, 12180
ZIP lookup: Troy, NY
42.74443, -73.650162026-11-022026-11-05
overtureHannaford Supermarket
8bb92d5a-064c-48de-b6a6-2662a083ccf0
9 Lord Ave, Troy, NY, 12180518271383242.74382, -73.650372026-11-132026-11-13
vtinfoHANNAFORD
940c880ca6fb7a89
9 LORD AVE, TROY, NY, 12180518271383242.74334, -73.651642026-11-122026-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 HANNAFORDdoordash hannaford troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 320 m apart · name similarity 1.00
ab-inbev HANNAFORDhannaford Hannaford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 317 m apart · name similarity 1.00
ab-inbev HANNAFORDvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 345 m apart · name similarity 1.00
doordash hannaford troyhannaford Hannaford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
doordash hannaford troyvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 57 m apart · name similarity 1.00
hannaford Hannafordvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 68 m apart · name similarity 1.00
ab-inbev HANNAFORDoverture Hannaford Supermarket0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supermarket · name Jaro-Winkler 0.89 · same street + ZIP · pins 251 m apart · name similarity 0.55
doordash hannaford troyoverture Hannaford Supermarket0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supermarket · name Jaro-Winkler 0.89 · same street + ZIP · pins 129 m apart · name similarity 0.55
hannaford Hannafordoverture Hannaford Supermarket0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supermarket · name Jaro-Winkler 0.89 · same street + ZIP · pins 135 m apart · name similarity 0.55
overture Hannaford Supermarketvtinfo HANNAFORD0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supermarket · name Jaro-Winkler 0.89 · same street + city + state · pins 116 m apart · name similarity 0.55 · phone: equal
ab-inbev HANNAFORDny-sla HANNAFORD FOOD & PHARMACY#84500.37Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
Hannaford same address, ZIP
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 9 Lord Ave, ZIP 12180, with coordinates about 0.18 km apart, and the NY-SLA record's trade name 'HANNAFORD FOOD & PHARMACY#8450' matches the chain store named Hannaford in the ab-inbev record; the Troy/Brunswick city difference is a postal-versus-municipal naming quirk for the same address, and it is the only building listed under that address.
pair 451a78f740df5210c3af

Attributes

Channel
off_premise · grocery — chain-locator
Chain
Hannaford — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
MARTIN'S FOODS OF SOUTH BURLINGTON LLC — 52 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 248 within 3 mi
Off / on premise
11 / 10 within 1 mi · 58 / 73 within 3 mi
Selling alcohol
19 within 1 mi · 193 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.14 mi
Setting
suburban (2,232 people per sq mi)
People within 3 mi
63,120 (46,065 adults 21+, 27,663 households) from 19 tract(s), tracts within 3 mi
Income
per capita $38,597 · median household ~$65,798 (weighted mean of tract medians)
Age and education
median age ~34.7 · bachelor's or higher 36%
Ethnicity
Hispanic 9% · White 69% · Black 12% · Asian 4%
Adults per alcohol outlet
237
Alcohol spend within 3 mi
$16,039,474 a year ($7,535,684 at home, $8,496,270 away) · $82,678 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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-13 14:10insertoverture 8bb92d5a-064c-48de-b6a6-2662a083ccf0 ↔ vtinfo 940c880ca6fb7a89same address and namemerged15
2026-11-13 14:10insertdoordash 27551438 ↔ overture 8bb92d5a-064c-48de-b6a6-2662a083ccf0same address and namemerged15
2026-11-13 14:10insertab-inbev 4573095 ↔ overture 8bb92d5a-064c-48de-b6a6-2662a083ccf0same address and namemerged15
2026-11-13 14:10inserthannaford /ny/troy/8450 ↔ overture 8bb92d5a-064c-48de-b6a6-2662a083ccf0same address and namemerged15
2026-11-12 17:29insertab-inbev 4573095 ↔ ny-sla 0081-23-206820Claude judge: samemerged14
2026-11-12 14:25insertdoordash 27551438 ↔ vtinfo 940c880ca6fb7a89same address and namemerged12
2026-11-12 14:25insertab-inbev 4573095 ↔ vtinfo 940c880ca6fb7a89same address and namemerged12
2026-11-12 14:25inserthannaford /ny/troy/8450 ↔ vtinfo 940c880ca6fb7a89same address and namemerged12
2026-11-11 12:56insertab-inbev 4573095 ↔ hannaford /ny/troy/8450same address and namemerged12
2026-11-11 12:56insertab-inbev 4573095 ↔ doordash 27551438same address and namemerged12
2026-11-06 17:13insertdoordash 27551438 ↔ hannaford /ny/troy/8450same address and namemerged11