Walgreen's #10288

Hillsdale, MI 49242 · O418d9cff7a2f · first seen 2026-10-08
5 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
Walgreen's #10288 4 other
a licence name in capitals, cleaned (derived; record_title.py)
WALGREENS ab-inbevwalgreens ×2
WALGREEN CO. (AN ILLINOIS PUBLIC CORPORATION) mi-lcc (legal name)
walgreens hillsdale doordash
Walgreens Pharmacy overture
Street
196 W CARLETON RD 1 other
walgreens
196 West Carleton Road doordash
City
Hillsdale
walgreensno other value
State
MI
walgreensno other value
ZIP
49242
walgreensno other value
Pin
41.92874, -84.64206 map 2 other
walgreens
94 m away ab-inbev
62 m away mi-lcc
Phone
5174394255
walgreensno other value
Licences
mi-lcc L-000186670
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdd06a7bab88; O60683534c887; Odabbf8f0c659; O932a9e2a04aa

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
3184980
196 W CARLETON RD, HILLSDALE, MI, 4924241.92800, -84.641522026-11-122026-11-12
doordashwalgreens hillsdale
1972959
196 West Carleton Road, Hillsdale, MI, 4924241.92880, -84.641942026-10-082026-11-06
mi-lccWALGREEN'S #10288
legal name: WALGREEN CO. (AN ILLINOIS PUBLIC CORPORATION)
L-000186670
196 W Carleton Rd, Hillsdale, MI, 49242517439425541.92909, -84.641472026-11-032026-11-12
overtureWalgreens Pharmacy
85e88c89-f029-4021-9e19-4b7e5fd5afb8
196 W Carleton Rd, Hillsdale, MI, 49242517439425541.92874, -84.642072026-11-132026-11-13
walgreensWalgreens
/locator/walgreens-196+w+carleton+rd-hillsdale-mi-49242/id=10288
196 W CARLETON RD, Hillsdale, MI, 49242517439425541.92874, -84.642062026-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
ab-inbev WALGREENSdoordash walgreens hillsdale1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 96 m apart · name similarity 1.00
ab-inbev WALGREENSmi-lcc WALGREEN'S #102881.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 121 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 94 m apart · name similarity 1.00
doordash walgreens hillsdalewalgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
mi-lcc WALGREEN'S #10288walgreens Walgreens1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00 · phone: equal
doordash walgreens hillsdalemi-lcc WALGREEN'S #102880.62Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Walgreens same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at the same address (196 W Carleton Rd, Hillsdale MI 49242, about 50 m apart), and the DoorDash 'walgreens hillsdale' listing is the Walgreens store's own alcohol/delivery listing for the licensed Walgreen Co. premises; Michigan has no separate-premises rule here and no other business shares the address.
pair 437a0dd492f75262f514
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 94 m apart · name similarity 0.58
doordash walgreens hillsdaleoverture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.67 · same street + ZIP · pins 12 m apart · name similarity 0.58
mi-lcc WALGREEN'S #10288overture Walgreens Pharmacy0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.64 · same street + ZIP · pins 63 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 CO. (AN ILLINOIS PUBLIC CORPORATION) — 189 outlets in the master under this operator
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:36.
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
38 within 1 mi · 61 within 3 mi
Off / on premise
9 / 18 within 1 mi · 18 / 26 within 3 mi
Selling alcohol
24 within 1 mi · 37 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.14 mi
Setting
rural (260 people per sq mi)
People within 3 mi
7,353 (5,091 adults 21+, 2,534 households) from 2 tract(s), tracts within 3 mi
Income
per capita $25,232 · median household ~$53,878 (weighted mean of tract medians)
Age and education
median age ~32.1 · bachelor's or higher 26%
Ethnicity
Hispanic 4% · White 90% · Black 2% · Asian 0%
Adults per alcohol outlet
134
Alcohol spend within 3 mi
$1,197,460 a year ($592,429 at home, $604,645 away) · $31,512 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:58insertmi-lcc L-000186670 ↔ overture 85e88c89-f029-4021-9e19-4b7e5fd5afb8same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000186670 ↔ walgreens /locator/walgreens-196+w+carleton+rd-hillsdale-mi-49242/id=10288same address and namemerged15
2026-11-18 18:58insertab-inbev 3184980 ↔ mi-lcc L-000186670same address and namemerged15
2026-11-13 14:10insertdoordash 1972959 ↔ overture 85e88c89-f029-4021-9e19-4b7e5fd5afb8same address and namemerged15
2026-11-13 14:10insertoverture 85e88c89-f029-4021-9e19-4b7e5fd5afb8 ↔ walgreens /locator/walgreens-196+w+carleton+rd-hillsdale-mi-49242/id=10288same address and namemerged15
2026-11-13 14:10insertab-inbev 3184980 ↔ overture 85e88c89-f029-4021-9e19-4b7e5fd5afb8same address and namemerged15
2026-11-12 17:29insertdoordash 1972959 ↔ mi-lcc L-000186670Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 3184980 ↔ doordash 1972959same address and namemerged12
2026-11-12 14:25insertab-inbev 3184980 ↔ walgreens /locator/walgreens-196+w+carleton+rd-hillsdale-mi-49242/id=10288same address and namemerged12
2026-11-06 17:13insertdoordash 1972959 ↔ walgreens /locator/walgreens-196+w+carleton+rd-hillsdale-mi-49242/id=10288same address and namemerged11