CVS Pharmacy

Sterling Heights, MI 48314 · O0e2bb8eadc93 · first seen 2026-10-08
7 sourcesoff premise · pharmacychain: CVS Pharmacyalcohol: licensed2 licences

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
CVS Pharmacy 4 other
the most common name a source states
CVS/PHARMACY #8191 mi-lcc ×2
WOODWARD DETROIT CVS, L.L.C. mi-lcc (legal name) ×2
CVS ubereats
cvs sterling heights doordash
Street
4025 18 Mile Rd 3 other
cvs
4025 EIGHTEEN MILE RD ab-inbevvtinfo ×2
4025 18 Mile Road doordash
4025 EIGHTEEN MILE ROAD ubereats
City
Sterling Heights
cvsno other value
State
MI
cvsno other value
ZIP
48314 1 other
cvs
48160 ubereats
Pin
42.59367, -83.07052 map 5 other
cvs
71 m away ab-inbev
62 m away doordash
72 m away overture
53 m away ubereats
78 m away vtinfo
Phone
5868036271 1 other
vtinfo
8007467287 overture
Licences
mi-lcc L-000178579 · mi-lcc L-000178898
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob8a9a9268857; O34d3e1cda621; Od012d2065c9c; O57b7794aab88; Oc48c5a20b8df; O6db7e3770db7; Oc507d59f38b0

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-inbevCVS PHARMACY
2387638
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 4831442.59419, -83.070022026-11-112026-11-12
cvsCVS Pharmacy
8191
4025 18 Mile Rd, Sterling Heights, MI, 4831442.59367, -83.070522026-11-122026-11-12
doordashcvs sterling heights
1233378
4025 18 Mile Road, Sterling Heights, MI, 4831442.59415, -83.070142026-10-082026-11-12
mi-lccCVS/PHARMACY #8191
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000178579
4025 18 Mile Rd, Sterling Heights, MI, 48314586803627142.59367, -83.070522026-11-032026-11-05
mi-lccCVS/PHARMACY #8191
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000178898
4025 18 Mile Rd, Sterling Heights, MI, 48314586803627142.59367, -83.070522026-11-032026-11-05
overtureCVS Pharmacy
c0fff38b-cb6c-42d7-8926-3a04b5e43bd3
4025 18 Mile Rd, Sterling Heights, MI, 48314800746728742.59419, -83.070012026-11-132026-11-13
ubereatsCVS
73l6mfBbUVG6Ni-UBouMhw
4025 EIGHTEEN MILE ROAD, STERLING HEIGHTS, MI, 4816042.59409, -83.070212026-10-212026-11-12
vtinfoCVS PHARMACY
6735c69ec16d8ef2
4025 EIGHTEEN MILE RD, STERLING HEIGHTS, MI, 48314586803627142.59429, -83.070072026-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 CVS PHARMACYvtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
cvs CVS Pharmacyoverture CVS Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
doordash cvs sterling heightsubereats CVS1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are the CVS at 4025 18 (Eighteen) Mile Road in Sterling Heights, 9 m apart, and it is the only business our data holds at that address; the differing ZIP on the Uber Eats record looks lik
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Same CVS address; ZIP typo on one side
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are CVS at the same street address (4025 Eighteen Mile Road, Sterling Heights) with coordinates 9 m apart, the only business at that address; the DoorDash and Uber Eats listings are one store's storefronts, and Michigan's rule treats a chain store's alcohol listing as its own department, so this is the same outlet despite the differing ZIP codes.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records are CVS at 4025 Eighteen Mile Road, Sterling Heights, with coordinates about 9 m apart, one business at the address, and no separate suite or competing business; the ZIP differs (48314 vs 48160), which is a minor discrepancy, and Michigan's rule treats CVS's alcohol listing as the store's own department.
  • Claude Haiku 5.5, prompt v4: same, 93% confident — Both records give the same street address (4025 Eighteen Mile Road, Sterling Heights, MI) with coordinates about 9 m apart, the only business at that address in our data, and both are named CVS, so they are one CVS store listed on two delivery apps; the ZIP differs (48314 vs 48160), which is a minor discrepancy against the strong address and name match.
pair 3f04c1568aa746f58474
mi-lcc CVS/PHARMACY #8191mi-lcc CVS/PHARMACY #81911.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev CVS PHARMACYdoordash cvs sterling heights0.45Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
CVS same address; pharmacy is same store
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are CVS at the same street address in Sterling Heights, MI (4025 Eighteen Mile Rd, distance 0.011 km, one business at the address), and Michigan's rule makes a chain store's alcohol listing its own in-store department, so this is one outlet with a pharmacy listing and a DoorDash listing.
pair 43b58de958a1b9c2ccf0
ab-inbev CVS PHARMACYubereats CVS0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + city + state · pins 20 m apart · name similarity 0.45
cvs CVS Pharmacydoordash cvs sterling heights0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + ZIP · pins 62 m apart · name similarity 0.45
doordash cvs sterling heightsoverture CVS Pharmacy0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + ZIP · pins 11 m apart · name similarity 0.45
ubereats CVSvtinfo CVS PHARMACY0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + city + state · pins 25 m apart · name similarity 0.45
doordash cvs sterling heightsmi-lcc CVS/PHARMACY #81910.32Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Same CVS store address; pharmacy listing is same outlet.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are CVS at 4025 18 Mile Road, Sterling Heights, MI 48314 (coordinates within about 60 m), with the DoorDash listing matching the CVS pharmacy licensed premises, and Michigan's rule treats a chain store's alcohol listing at its address as the store's own department.
pair 0e3b80cb99f96724b8ca

Attributes

Channel
off_premise · pharmacy — chain-locator
Chain
CVS Pharmacy — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
WOODWARD DETROIT CVS, L.L.C. — 172 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "pharmacy"
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
20 within 1 mi · 244 within 3 mi
Off / on premise
11 / 4 within 1 mi · 73 / 85 within 3 mi
Selling alcohol
11 within 1 mi · 154 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.86 mi
Setting
urban (3,773 people per sq mi)
People within 3 mi
106,678 (82,231 adults 21+, 39,839 households) from 25 tract(s), tracts within 3 mi
Income
per capita $42,820 · median household ~$96,549 (weighted mean of tract medians)
Age and education
median age ~41.6 · bachelor's or higher 40%
Ethnicity
Hispanic 3% · White 73% · Black 5% · Asian 15%
Adults per alcohol outlet
531
Alcohol spend within 3 mi
$28,555,399 a year ($12,963,957 at home, $15,579,511 away) · $184,228 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:10insertdoordash 1233378 ↔ overture c0fff38b-cb6c-42d7-8926-3a04b5e43bd3same address and namemerged15
2026-11-13 14:10insertcvs 8191 ↔ overture c0fff38b-cb6c-42d7-8926-3a04b5e43bd3same address and namemerged15
2026-11-12 17:29insertdoordash 1233378 ↔ mi-lcc L-000178579Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2387638 ↔ doordash 1233378Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2387638 ↔ ubereats 73l6mfBbUVG6Ni-UBouMhwsame address and namemerged14
2026-11-12 17:29insertubereats 73l6mfBbUVG6Ni-UBouMhw ↔ vtinfo 6735c69ec16d8ef2same address and namemerged14
2026-11-12 17:29insertcvs 8191 ↔ doordash 1233378same address and namemerged14
2026-11-12 14:25insertab-inbev 2387638 ↔ vtinfo 6735c69ec16d8ef2same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000178579 ↔ mi-lcc L-000178898one store listed twicemerged
2026-11-02 23:02backfilldoordash 1233378 ↔ ubereats 73l6mfBbUVG6Ni-UBouMhwClaude judge: samemerged