CVS Pharmacy

Royal Oak, MI 48073 · O309d59a84902 · first seen 2026-10-08
7 sourcesoff premise · pharmacychain: CVS Pharmacyalcohol: 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
CVS Pharmacy 5 other
a source's own spelling of the licence name (record_title.py)
CVS ubereats
CVS 8127 snap
cvs royal oak doordash
CVS/PHARMACY #8127 mi-lcc
WOODWARD DETROIT CVS, L.L.C. mi-lcc (legal name)
Street
209 E 12 Mile Rd 1 other
cvs
209 EAST 12 MILE ROAD ubereats
City
Royal Oak
cvsno other value
State
MI
cvsno other value
ZIP
48073
cvsno other value
Pin
42.50444, -83.14287 map 5 other
cvs
130 m away ab-inbev
58 m away doordash
90 m away snap
56 m away ubereats
53 m away vtinfo
Phone
2485486180 1 other
vtinfo
4017651500 mi-lcc
Licences
mi-lcc L-000178550
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc936bc56a06d; Of07d72de5f40; Oaf33dca7fc2e; O4ef2146fd888; Oc0a27fe69fed; Od2136253c48a

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
2387566
209 E 12 MILE RD, ROYAL OAK, MI, 4807342.50451, -83.141282026-11-112026-11-11
cvsCVS Pharmacy
8127
209 E 12 Mile Rd, Royal Oak, MI, 4807342.50444, -83.142872026-11-122026-11-12
doordashcvs royal oak
29301574
209 E 12 Mile Rd, Royal Oak, MI, 4807342.50481, -83.142362026-10-082026-11-12
mi-lccCVS/PHARMACY #8127
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000178550
209 E 12 Mile Rd, Royal Oak, MI, 48073401765150042.50444, -83.142872026-11-032026-11-12
snapCVS 8127
snap|us|570727
209 E 12 Mile Rd, Royal Oak, MI, 4807342.50445, -83.141772026-11-192026-11-19
ubereatsCVS
F-aS91NVWseNThEK0CdudQ
209 EAST 12 MILE ROAD, ROYAL OAK, MI, 4807342.50476, -83.142352026-10-102026-11-12
vtinfoCVS PHARMACY
5195ce6848c599b6
209 E 12 MILE RD, ROYAL OAK, MI, 48073248548618042.50485, -83.142552026-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 · pins 130 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 111 m apart · name similarity 1.00
cvs CVS Pharmacymi-lcc CVS/PHARMACY #81271.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 Pharmacyvtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 53 m apart · name similarity 1.00
doordash cvs royal oakubereats CVS1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
mi-lcc CVS/PHARMACY #8127vtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 53 m apart · name similarity 1.00 · phone: differs
ab-inbev CVS PHARMACYmi-lcc CVS/PHARMACY #81270.75Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
CVS same address, name match.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records are the CVS pharmacy at 209 E 12 Mile Rd, Royal Oak, MI 48073, with matching phone-free but coincident coordinates (0.13 km), the same chain and pharmacy department, and only one business at that address, so the Michigan licence holder is the store's own operation.
pair 124a4f5fe019858697c4
mi-lcc CVS/PHARMACY #8127snap CVS 81270.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 90 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 94 m apart · name similarity 0.45
ab-inbev CVS PHARMACYubereats CVS0.45Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (96% confident; asked as a “near” pair)
The same CVS store is at the same street address (209 E 12 Mile Rd, Royal Oak 48073), the coordinates are 92 m apart, and it is the only business at that address; 'CVS Pharmacy' is simply the store's
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Same CVS address
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same CVS address; pharmacy label is store name.
  • Claude Opus 5.5, prompt v11: same, 93% confident — CVS at same address, pharmacy listing of one store
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are CVS at 209 E 12 Mile Rd, Royal Oak, MI, one business with no differing suite and only one business at the address; A is the pharmacy listing and B is the Uber Eats store listing, and Michigan's rule makes the in-store alcohol listing the store's own department, so they are one outlet.
pair 04b2e17aa15441f9966f
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 · pins 58 m apart · name similarity 0.45
cvs 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 + ZIP · pins 56 m apart · name similarity 0.45
doordash cvs royal oakmi-lcc CVS/PHARMACY #81270.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 58 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 17 m apart · name similarity 0.45
mi-lcc CVS/PHARMACY #8127ubereats 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 + ZIP · pins 56 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 + ZIP · pins 20 m apart · name similarity 0.45

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 — MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-19 21:41.
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
  ]
 ]
}

Trade area

Other outlets
39 within 1 mi · 808 within 3 mi
Off / on premise
12 / 13 within 1 mi · 205 / 454 within 3 mi
Selling alcohol
26 within 1 mi · 419 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (4,865 people per sq mi)
People within 3 mi
137,555 (112,408 adults 21+, 66,151 households) from 43 tract(s), tracts within 3 mi
Income
per capita $59,547 · median household ~$99,637 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 56%
Ethnicity
Hispanic 4% · White 81% · Black 7% · Asian 4%
Adults per alcohol outlet
268
Alcohol spend within 3 mi
$49,699,955 a year ($22,326,435 at home, $27,351,667 away) · $118,333 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-000178550 ↔ snap snap|us|570727same address and namemerged17
2026-11-18 18:58insertdoordash 29301574 ↔ mi-lcc L-000178550same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178550 ↔ ubereats F-aS91NVWseNThEK0CdudQsame address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178550 ↔ vtinfo 5195ce6848c599b6same address and namemerged15
2026-11-18 18:58insertcvs 8127 ↔ mi-lcc L-000178550same address and namemerged15
2026-11-12 17:29insertab-inbev 2387566 ↔ mi-lcc L-000178550Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2387566 ↔ doordash 29301574same address and namemerged14
2026-11-12 17:29insertdoordash 29301574 ↔ vtinfo 5195ce6848c599b6same address and namemerged14
2026-11-12 17:29insertubereats F-aS91NVWseNThEK0CdudQ ↔ vtinfo 5195ce6848c599b6same address and namemerged14
2026-11-12 17:29insertcvs 8127 ↔ doordash 29301574same address and namemerged14
2026-11-12 17:29insertcvs 8127 ↔ ubereats F-aS91NVWseNThEK0CdudQsame address and namemerged14
2026-11-12 14:25insertab-inbev 2387566 ↔ ubereats F-aS91NVWseNThEK0CdudQClaude judge: samemerged12
2026-11-12 14:25insertab-inbev 2387566 ↔ cvs 8127same address and namemerged12
2026-11-12 14:25insertcvs 8127 ↔ vtinfo 5195ce6848c599b6same address and namemerged12
2026-11-11 12:56insertab-inbev 2387566 ↔ vtinfo 5195ce6848c599b6same address and namemerged12
2026-10-13 17:02backfilldoordash 29301574 ↔ ubereats F-aS91NVWseNThEK0CdudQsame address and namemerged