Hannaford

Niskayuna, NY 12304 · O19c8f0817827 · 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 3 other
the most common name a source states
hannaford schenectady doordash
HANNAFORD SUPERMARKET & PHARMACY #8396 ny-sla
MARTIN'S FOODS OF SOUTH BURLINGTON LLC ny-sla (legal name)
Street
3333 Consaul Rd 1 other
hannaford
3333 Consaul Road doordashny-sla ×2
City
Niskayuna 1 other
hannaford
SCHENECTADY ab-inbevdoordashvtinfo ×3
State
NY
hannafordno other value
ZIP
12304 1 other
hannaford
12309 ny-sla
Pin
42.78338, -73.89100 map
hannafordno other value
Phone
5183959497
vtinfono other value
Licences
ny-sla 0081-23-212481
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ode18a9c4b6e1; O9abe65402669; O4d2bce5803bd; O7c437239352f; Od91939ae3e1d

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
182507
3333 CONSAUL RD, SCHENECTADY, NY, 1230442.78312, -73.891322026-11-112026-11-11
doordashhannaford schenectady
27551293
3333 Consaul Road, Schenectady, NY, 1230442.78323, -73.891462026-10-082026-11-06
hannafordHannaford
/ny/niskayuna/8396
3333 Consaul Rd, Niskayuna, NY, 12304
ZIP lookup: Schenectady, NY
42.78338, -73.891002026-11-062026-11-11
ny-slaHANNAFORD SUPERMARKET & PHARMACY #8396
legal name: MARTIN'S FOODS OF SOUTH BURLINGTON LLC
0081-23-212481
3333 CONSAUL ROAD, NISKAYUNA, NY, 1230942.78306, -73.891362026-11-022026-11-12
overtureHannaford
1abc5e1a-0424-4b9d-9615-2c340048e18d
3333 Consaul Rd, Niskayuna, NY, 12304
ZIP lookup: Schenectady, NY
518395949742.78313, -73.891072026-11-062026-11-11
vtinfoHANNAFORD
2997bdc5f5fbdcec
3333 CONSAUL RD, SCHENECTADY, NY, 12304518395949742.78332, -73.891122026-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 schenectady1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 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 39 m apart · name similarity 1.00
ab-inbev HANNAFORDoverture Hannaford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 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 27 m apart · name similarity 1.00
doordash hannaford schenectadyvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
hannaford Hannafordoverture Hannaford1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
hannaford Hannafordvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
overture Hannafordvtinfo HANNAFORD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00 · phone: equal
ab-inbev HANNAFORDny-sla HANNAFORD SUPERMARKET & PHARMACY #83960.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Hannaford same street address, Martin's Foods entity
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are the Hannaford store at 3333 Consaul Road, with coordinates 7 m apart and the same chain name (B's trade name is 'Hannaford Supermarket & Pharmacy #8396', a store listing under the chain's banner); the differing city and ZIP (Schenectady vs Niskayuna) are the usual postal-address variation for this location, though the shared building with another business leaves some residual doubt.
pair 49894f63c65e83f36a43

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:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
38 within 1 mi · 216 within 3 mi
Off / on premise
18 / 13 within 1 mi · 83 / 64 within 3 mi
Selling alcohol
23 within 1 mi · 156 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
suburban (2,755 people per sq mi)
People within 3 mi
77,886 (56,629 adults 21+, 30,954 households) from 20 tract(s), tracts within 3 mi
Income
per capita $42,422 · median household ~$87,302 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 37%
Ethnicity
Hispanic 9% · White 60% · Black 13% · Asian 8%
Adults per alcohol outlet
363
Alcohol spend within 3 mi
$21,026,786 a year ($9,595,749 at home, $11,420,637 away) · $134,787 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-14 20:23insertoverture 1abc5e1a-0424-4b9d-9615-2c340048e18d ↔ vtinfo 2997bdc5f5fbdcecsame address and namemerged15
2026-11-14 20:23inserthannaford /ny/niskayuna/8396 ↔ vtinfo 2997bdc5f5fbdcecsame address and namemerged15
2026-11-12 17:29insertab-inbev 182507 ↔ ny-sla 0081-23-212481Claude judge: samemerged14
2026-11-12 14:25insertdoordash 27551293 ↔ vtinfo 2997bdc5f5fbdcecsame address and namemerged12
2026-11-12 14:25insertab-inbev 182507 ↔ vtinfo 2997bdc5f5fbdcecsame address and namemerged12
2026-11-11 12:56insertab-inbev 182507 ↔ hannaford /ny/niskayuna/8396same address and namemerged12
2026-11-11 12:56insertab-inbev 182507 ↔ doordash 27551293same address and namemerged12
2026-11-11 12:56insertab-inbev 182507 ↔ overture 1abc5e1a-0424-4b9d-9615-2c340048e18dsame address and namemerged12
2026-11-06 18:13inserthannaford /ny/niskayuna/8396 ↔ overture 1abc5e1a-0424-4b9d-9615-2c340048e18dsame address and namemerged11