Walgreens

TROY, NY 12180 · O0c812bf88545 · first seen 2026-10-08
6 sourcesoff premise · pharmacychain: Walgreensalcohol: 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
Walgreens 3 other
a source's own spelling of the licence name (record_title.py)
WALGREEN EASTERN CO., INC. ny-sla (legal name)
Walgreens Pharmacy overture
walgreens troy doordash
Street
549 HOOSICK ST 2 other
walgreens
459 HOOSICK ST ny-sla
549 Hoosick Street doordash
City
Troy
walgreensno other value
State
NY
walgreensno other value
ZIP
12180
walgreensno other value
Pin
42.73989, -73.65845 map 1 other
walgreens
113 m away ny-sla
Phone
5182745080
walgreensno other value
Licences
ny-sla 0082-22-202113
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa7c73d7b437a; O918354c76f01; Oeae990162247; Oc4d1797df0f4; Oce51377e6a77

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-inbevWALGREENS
3188401
549 HOOSICK ST, TROY, NY, 1218042.73949, -73.658702026-11-112026-11-11
doordashwalgreens troy
1115543
549 Hoosick Street, Troy, NY, 1218042.73987, -73.658582026-10-082026-10-14
ny-slaWALGREENS
legal name: WALGREEN EASTERN CO., INC.
0082-22-202113
459 HOOSICK ST, TROY, NY, 1218042.73912, -73.659362026-11-022026-11-18
overtureWalgreens Pharmacy
3b89b586-5ed3-4526-84dc-9841ccde9261
549 Hoosick St, Troy, NY, 12180518274508042.73989, -73.658452026-11-132026-11-13
vtinfoWALGREENS
6489a1dbae193e19
549 HOOSICK ST, TROY, NY, 12180518274508042.73969, -73.658452026-11-122026-11-14
walgreensWalgreens
/locator/walgreens-549+hoosick+st-troy-ny-12180/id=10548
549 HOOSICK ST, Troy, NY, 12180518274508042.73989, -73.658452026-11-072026-11-08

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 WALGREENSdoordash walgreens troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 43 m apart · name similarity 1.00
ab-inbev WALGREENSvtinfo WALGREENS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
ab-inbev WALGREENSwalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 49 m apart · name similarity 1.00
doordash walgreens troyny-sla WALGREENS1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
549 vs 459 likely transposition; 105 m apart, same chain.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records are Walgreens in Troy on Hoosick Street, but the street numbers differ (549 vs 459) and the coordinates are about 105 m apart, so the records do not settle whether this is one store with a mistyped address or two Walgreens locations.
pair 72e6327a2356aaaa42aa
doordash walgreens troyvtinfo WALGREENS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
doordash walgreens troywalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
vtinfo WALGREENSwalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00 · phone: equal
ab-inbev WALGREENSoverture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + ZIP · pins 49 m apart · name similarity 0.58
doordash walgreens troyoverture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.77 · same street + ZIP · pins 11 m apart · name similarity 0.58
overture Walgreens Pharmacyvtinfo WALGREENS0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + city + state · pins 22 m apart · name similarity 0.58 · phone: equal
overture Walgreens Pharmacywalgreens Walgreens0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.50 · same street + ZIP · pins 0 m apart · name similarity 0.58 · phone: equal

Attributes

Channel
off_premise · pharmacy — chain-locator
Chain
Walgreens — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
WALGREEN EASTERN CO., INC. — 328 outlets in the master under this operator
Licence privileges
beer_off — NY 0082
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "pharmacy"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
73 within 1 mi · 376 within 3 mi
Off / on premise
18 / 38 within 1 mi · 79 / 168 within 3 mi
Selling alcohol
38 within 1 mi · 252 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.05 mi
Setting
suburban (2,595 people per sq mi)
People within 3 mi
73,374 (54,141 adults 21+, 32,818 households) from 22 tract(s), tracts within 3 mi
Income
per capita $38,946 · median household ~$66,080 (weighted mean of tract medians)
Age and education
median age ~35.8 · bachelor's or higher 35%
Ethnicity
Hispanic 9% · White 70% · Black 12% · Asian 4%
Adults per alcohol outlet
214
Alcohol spend within 3 mi
$18,936,923 a year ($8,922,042 at home, $10,005,720 away) · $74,849 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-18 18:58insertdoordash 1115543 ↔ ny-sla 0082-22-202113Claude judge: samemerged15
2026-11-13 14:10insertoverture 3b89b586-5ed3-4526-84dc-9841ccde9261 ↔ vtinfo 6489a1dbae193e19same address and namemerged15
2026-11-13 14:10insertdoordash 1115543 ↔ overture 3b89b586-5ed3-4526-84dc-9841ccde9261same address and namemerged15
2026-11-13 14:10insertab-inbev 3188401 ↔ overture 3b89b586-5ed3-4526-84dc-9841ccde9261same address and namemerged15
2026-11-13 14:10insertoverture 3b89b586-5ed3-4526-84dc-9841ccde9261 ↔ walgreens /locator/walgreens-549+hoosick+st-troy-ny-12180/id=10548same address and namemerged15
2026-11-12 14:25insertdoordash 1115543 ↔ vtinfo 6489a1dbae193e19same address and namemerged12
2026-11-12 14:25insertab-inbev 3188401 ↔ vtinfo 6489a1dbae193e19same address and namemerged12
2026-11-12 14:25insertvtinfo 6489a1dbae193e19 ↔ walgreens /locator/walgreens-549+hoosick+st-troy-ny-12180/id=10548same address and namemerged12
2026-11-11 12:56insertab-inbev 3188401 ↔ doordash 1115543same address and namemerged12
2026-11-11 12:56insertab-inbev 3188401 ↔ walgreens /locator/walgreens-549+hoosick+st-troy-ny-12180/id=10548same address and namemerged12
2026-11-08 00:04insertdoordash 1115543 ↔ walgreens /locator/walgreens-549+hoosick+st-troy-ny-12180/id=10548same address and namemerged11