CVS Pharmacy

Royal Oak, MI 48067 · O2d7ccc8daba6 · 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 #8068 mi-lcc ×2
WOODWARD DETROIT CVS, L.L.C. mi-lcc (legal name) ×2
CVS 8068 snap
cvs royal oak doordash
Street
525 East 4th Street 1 other
cvs
525 E 4TH ST ab-inbevmi-lccoverturesnapvtinfo ×6
City
Royal Oak
cvsno other value
State
MI
cvsno other value
ZIP
48067
cvsno other value
Pin
42.48749, -83.13919 map
cvsno other value
Phone
2485475057 2 other
vtinfo
4017651500 mi-lcc ×2
2485485057 overture
Licences
mi-lcc L-000178549 · mi-lcc L-000478406
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofb02d3b9f8f1; Oe176d2a1557b; O5464c179ffe6; O6f674794ac3c; Ob7d2d1cd2f7d; Od4cb0b79bbbc; O318769d184d3

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
2387576
525 E 4TH ST, ROYAL OAK, MI, 4806742.48752, -83.138702026-11-112026-11-12
cvsCVS Pharmacy
8068
525 East 4th Street, Royal Oak, MI, 4806742.48749, -83.139192026-11-122026-11-13
doordashcvs royal oak
1233282
525 East 4th Street, Royal Oak, MI, 4806742.48777, -83.138812026-10-082026-11-12
mi-lccCVS/PHARMACY #8068
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000178549
525 E 4th St, Royal Oak, MI, 48067401765150042.48749, -83.139192026-11-032026-11-12
mi-lccCVS/PHARMACY #8068
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000478406
525 E 4th St, Royal Oak, MI, 48067401765150042.48749, -83.139192026-11-032026-11-12
overtureCVS Pharmacy
10911690-37f9-498b-9663-a9506597d3be
525 E 4th St, Royal Oak, MI, 48067248548505742.48763, -83.138922026-11-132026-11-13
snapCVS 8068
snap|us|458324
525 E 4th St, Royal Oak, MI, 4806742.48784, -83.139222026-11-192026-11-19
vtinfoCVS PHARMACY
afe7180a685d7080
525 E 4TH ST, ROYAL OAK, MI, 48067248547505742.48778, -83.138902026-11-112026-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 PHARMACYcvs CVS Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev CVS PHARMACYmi-lcc CVS/PHARMACY #80681.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
ab-inbev CVS PHARMACYmi-lcc CVS/PHARMACY #80681.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
ab-inbev CVS PHARMACYoverture CVS Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev CVS PHARMACYvtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
cvs CVS Pharmacymi-lcc CVS/PHARMACY #80681.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
cvs CVS Pharmacymi-lcc CVS/PHARMACY #80681.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 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 27 m apart · name similarity 1.00
cvs CVS Pharmacyvtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc CVS/PHARMACY #8068mi-lcc CVS/PHARMACY #80681.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CVS/PHARMACY #8068overture CVS Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS/PHARMACY #8068vtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS/PHARMACY #8068overture CVS Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS/PHARMACY #8068vtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00 · phone: differs
overture CVS Pharmacyvtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS/PHARMACY #8068snap CVS 80680.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.89 · same street + ZIP · pins 39 m apart · name similarity 0.65
mi-lcc CVS/PHARMACY #8068snap CVS 80680.65same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.89 · same street + ZIP · pins 39 m apart · name similarity 0.65
ab-inbev CVS PHARMACYdoordash cvs royal oak0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.83 · same street + ZIP · pins 30 m apart · name similarity 0.45
cvs CVS Pharmacydoordash cvs royal oak0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.83 · same street + ZIP · name similarity 0.45
doordash cvs royal oakmi-lcc CVS/PHARMACY #80680.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 44 m apart · name similarity 0.45
doordash cvs royal oakoverture CVS Pharmacy0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.83 · same street + ZIP · pins 18 m apart · name similarity 0.45
doordash cvs royal oakvtinfo CVS PHARMACY0.45same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.83 · same street + ZIP · pins 8 m apart · name similarity 0.45
doordash cvs royal oakmi-lcc CVS/PHARMACY #80680.33Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
CVS at same Royal Oak address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are CVS at 525 E 4th St, Royal Oak MI 48067, with coordinates about 44 m apart and a sole business at the address; the doordash listing is the CVS store's own alcohol/pharmacy department, and Michigan's rule treats a chain store's alcohol listing as the store's own department.
pair 0e06e6b9719085331beb

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 11, computed 2026-11-19 21:41.
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
146 within 1 mi · 791 within 3 mi
Off / on premise
18 / 83 within 1 mi · 194 / 426 within 3 mi
Selling alcohol
86 within 1 mi · 434 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (5,024 people per sq mi)
People within 3 mi
142,060 (116,399 adults 21+, 66,973 households) from 44 tract(s), tracts within 3 mi
Income
per capita $57,635 · median household ~$98,801 (weighted mean of tract medians)
Age and education
median age ~39.1 · bachelor's or higher 53%
Ethnicity
Hispanic 4% · White 78% · Black 10% · Asian 3%
Adults per alcohol outlet
268
Alcohol spend within 3 mi
$49,879,631 a year ($22,443,924 at home, $27,413,327 away) · $114,666 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-19 20:37insertmi-lcc L-000478406 ↔ snap snap|us|458324same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000178549 ↔ snap snap|us|458324same address and namemerged17
2026-11-18 18:58insertdoordash 1233282 ↔ mi-lcc L-000478406same address and namemerged15
2026-11-18 18:58insertcvs 8068 ↔ mi-lcc L-000478406same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000478406 ↔ overture 10911690-37f9-498b-9663-a9506597d3besame address and namemerged15
2026-11-18 18:58insertmi-lcc L-000478406 ↔ vtinfo afe7180a685d7080same address and namemerged15
2026-11-18 18:58insertcvs 8068 ↔ mi-lcc L-000178549same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178549 ↔ overture 10911690-37f9-498b-9663-a9506597d3besame address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178549 ↔ vtinfo afe7180a685d7080same address and namemerged15
2026-11-18 18:58insertab-inbev 2387576 ↔ mi-lcc L-000478406same address and namemerged15
2026-11-18 18:58insertab-inbev 2387576 ↔ mi-lcc L-000178549same address and namemerged15
2026-11-13 14:10insertdoordash 1233282 ↔ overture 10911690-37f9-498b-9663-a9506597d3besame address and namemerged15
2026-11-13 14:10insertcvs 8068 ↔ overture 10911690-37f9-498b-9663-a9506597d3besame address and namemerged15
2026-11-13 14:10insertab-inbev 2387576 ↔ overture 10911690-37f9-498b-9663-a9506597d3besame address and namemerged15
2026-11-13 14:10insertoverture 10911690-37f9-498b-9663-a9506597d3be ↔ vtinfo afe7180a685d7080same address and namemerged15
2026-11-12 17:29insertdoordash 1233282 ↔ mi-lcc L-000178549Claude judge: samemerged14
2026-11-12 17:29insertcvs 8068 ↔ doordash 1233282same address and namemerged14
2026-11-12 17:29insertab-inbev 2387576 ↔ doordash 1233282same address and namemerged14
2026-11-12 17:29insertdoordash 1233282 ↔ vtinfo afe7180a685d7080same address and namemerged14
2026-11-12 14:25insertab-inbev 2387576 ↔ cvs 8068same address and namemerged12
2026-11-12 14:25insertcvs 8068 ↔ vtinfo afe7180a685d7080same address and namemerged12
2026-11-11 12:56insertab-inbev 2387576 ↔ vtinfo afe7180a685d7080same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000178549 ↔ mi-lcc L-000478406one store listed twicemerged