Walnut Street Liquor Store

Lockport, NY 14094 · O1d15bc88192f · first seen 2026-10-08
4 sourcesoff premise · liquor_storealcohol: 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
Walnut Street Liquor Store 2 other
a source's own spelling of the licence name (record_title.py)
WALNUT STREET LIQUOR STORE INC lotteryny-sla ×2
walnut street liquor store lockport doordash
Street
251 WALNUT ST 1 other
ny-sla
251 Walnut Street doordash
City
LOCKPORT
ny-slano other value
State
NY
ny-slano other value
ZIP
14094
ny-slano other value
Pin
43.17039, -78.68667 map
doordashno other value
Phone
7164342949
overtureno other value
Licences
ny-sla 0100-22-317974
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ode7c5e6bd991; O9d2db806cfbf; O69ffe3c3c369

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
doordashwalnut street liquor store lockport
25053985
251 Walnut Street, Lockport, NY, 1409443.17039, -78.686672026-10-082026-11-06
lotteryWALNUT STREET LIQUOR STORE INC
lottery|ny|109244
251 WALNUT ST, Lockport, NY, 1409443.17020, -78.686412026-11-202026-11-20
ny-slaWALNUT STREET LIQUOR STORE INC
0100-22-317974
251 WALNUT ST, LOCKPORT, NY, 1409443.17027, -78.686602026-11-022026-11-06
overtureWalnut Street Liquor Store
17366e8f-352e-4b34-a02a-79560de4647b
251 Walnut St, Lockport, NY, 14094716434294943.17030, -78.686712026-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 walnut street liquor store lockportlottery WALNUT STREET LIQUOR STORE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
doordash walnut street liquor store lockportny-sla WALNUT STREET LIQUOR STORE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
doordash walnut street liquor store lockportoverture Walnut Street Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
lottery WALNUT STREET LIQUOR STORE INCny-sla WALNUT STREET LIQUOR STORE INC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
lottery WALNUT STREET LIQUOR STORE INCoverture Walnut Street Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ny-sla WALNUT STREET LIQUOR STORE INCoverture Walnut Street Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
WALNUT STREET LIQUOR STORE INC — 1 outlets in the master under this operator
Licence privileges
wine_off, spirits_off — NY 0100
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
58 within 1 mi · 160 within 3 mi
Off / on premise
11 / 21 within 1 mi · 37 / 81 within 3 mi
Selling alcohol
48 within 1 mi · 103 within 3 mi
Nearest
same channel 0.14 mi · licensed 0.02 mi
Setting
suburban (963 people per sq mi)
People within 3 mi
27,227 (20,817 adults 21+, 11,955 households) from 7 tract(s), tracts within 3 mi
Income
per capita $36,585 · median household ~$69,639 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 26%
Ethnicity
Hispanic 6% · White 80% · Black 9% · Asian 0%
Adults per alcohol outlet
200
Alcohol spend within 3 mi
$7,052,082 a year ($3,335,935 at home, $3,712,942 away) · $67,808 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-20 22:08insertdoordash 25053985 ↔ lottery lottery|ny|109244same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|109244 ↔ overture 17366e8f-352e-4b34-a02a-79560de4647bsame address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|109244 ↔ ny-sla 0100-22-317974same address and namemerged17
2026-11-06 18:13insertny-sla 0100-22-317974 ↔ overture 17366e8f-352e-4b34-a02a-79560de4647bsame address and namemerged11
2026-11-06 18:13insertdoordash 25053985 ↔ overture 17366e8f-352e-4b34-a02a-79560de4647bsame address and namemerged11
2026-11-03 13:33backfilldoordash 25053985 ↔ ny-sla 0100-22-317974same address and namemerged