CVS Pharmacy

Farmington Hills, MI 48334 · O09aba9477b56 · first seen 2026-10-08
6 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 3 other
a source's own spelling of the licence name (record_title.py)
CVS PHARMACY #8044 mi-lcc ×2
WOODWARD DETROIT CVS, L.L.C. mi-lcc (legal name) ×2
cvs farmington hills doordash
Street
29425 Orchard Lake Rd 1 other
cvs
29425 Orchard Lake Road doordash
City
Farmington Hills 1 other
cvs
FARMINGTON ab-inbevvtinfo ×2
State
MI
cvsno other value
ZIP
48334
cvsno other value
Pin
42.51320, -83.35942 map 3 other
cvs
50 m away doordash
61 m away overture
60 m away vtinfo
Phone
2489940634 1 other
vtinfo
2485390600 mi-lcc ×2
Licences
mi-lcc L-000178857 · mi-lcc L-000483926
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O35aacfadb109; O96b3f15eaa31; O8edae4d77b17; O849d896af144; O1d8a6a2afe59; Oc1e85dd94dd9

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
3097640
29425 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.51351, -83.359432026-11-112026-11-12
cvsCVS Pharmacy
8044
29425 Orchard Lake Rd, Farmington Hills, MI, 4833442.51320, -83.359422026-11-122026-11-12
doordashcvs farmington hills
1233269
29425 Orchard Lake Road, Farmington Hills, MI, 4833442.51329, -83.360022026-10-082026-11-12
mi-lccCVS PHARMACY #8044
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000178857
29425 Orchard Lake Rd, Farmington Hills, MI, 48334248539060042.51320, -83.359422026-11-032026-11-12
mi-lccCVS PHARMACY #8044
legal name: WOODWARD DETROIT CVS, L.L.C.
L-000483926
29425 Orchard Lake Rd, Farmington Hills, MI, 48334248539060042.51320, -83.359422026-11-032026-11-12
overtureCvs Pharmacy
27049b39-56f2-4ada-b8a6-a5cd6de7a5c0
29425 Orchard Lake Rd, Farmington Hills, MI, 48334248994063442.51329, -83.360162026-11-132026-11-13
vtinfoCVS PHARMACY
6d50607076fed912
29425 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248994063442.51325, -83.360162026-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 PHARMACYcvs 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
ab-inbev CVS PHARMACYmi-lcc CVS PHARMACY #80441.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 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 65 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 + city + state · pins 66 m apart · name similarity 1.00
cvs CVS Pharmacymi-lcc CVS PHARMACY #80441.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 #80441.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 61 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 60 m apart · name similarity 1.00
mi-lcc CVS PHARMACY #8044mi-lcc CVS PHARMACY #80441.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CVS PHARMACY #8044overture Cvs Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS PHARMACY #8044vtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS PHARMACY #8044overture Cvs Pharmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00 · phone: differs
mi-lcc CVS PHARMACY #8044vtinfo CVS PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 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 4 m apart · name similarity 1.00 · phone: equal
ab-inbev CVS PHARMACYmi-lcc CVS PHARMACY #80440.75Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
CVS same address and ZIP
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are the CVS pharmacy at 29425 Orchard Lake Rd (ZIP 48334) with coordinates about 34 m apart, the only business at that address, and the mi-lcc record's CVS PHARMACY #8044 is the store's own licensed department under the chain's banner, so this is one outlet despite the differing city name (Farmington vs Farmington Hills).
pair 0a6599aee7e044277c3e
cvs CVS Pharmacydoordash cvs farmington hills0.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 50 m apart · name similarity 0.45
doordash cvs farmington hillsmi-lcc CVS PHARMACY #80440.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 50 m apart · name similarity 0.45
doordash cvs farmington hillsmi-lcc CVS PHARMACY #80440.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 50 m apart · name similarity 0.45
doordash cvs farmington hillsoverture 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 12 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, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 9, computed 2026-11-17 18:20.
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
84 within 1 mi · 285 within 3 mi
Off / on premise
27 / 49 within 1 mi · 67 / 174 within 3 mi
Selling alcohol
29 within 1 mi · 124 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,375 people per sq mi)
People within 3 mi
67,162 (51,989 adults 21+, 26,588 households) from 21 tract(s), tracts within 3 mi
Income
per capita $58,107 · median household ~$121,765 (weighted mean of tract medians)
Age and education
median age ~45.5 · bachelor's or higher 61%
Ethnicity
Hispanic 3% · White 60% · Black 22% · Asian 11%
Adults per alcohol outlet
416
Alcohol spend within 3 mi
$22,998,820 a year ($10,091,277 at home, $12,898,457 away) · $183,991 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 1233269 ↔ mi-lcc L-000178857same address and namemerged15
2026-11-18 18:58insertdoordash 1233269 ↔ mi-lcc L-000483926same address and namemerged15
2026-11-18 18:58insertcvs 8044 ↔ mi-lcc L-000178857same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178857 ↔ overture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0same address and namemerged15
2026-11-18 18:58insertcvs 8044 ↔ mi-lcc L-000483926same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000483926 ↔ overture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000178857 ↔ vtinfo 6d50607076fed912same address and namemerged15
2026-11-18 18:58insertmi-lcc L-000483926 ↔ vtinfo 6d50607076fed912same address and namemerged15
2026-11-18 18:58insertab-inbev 3097640 ↔ mi-lcc L-000483926same address and namemerged15
2026-11-14 20:23insertcvs 8044 ↔ vtinfo 6d50607076fed912same address and namemerged15
2026-11-14 20:23insertoverture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0 ↔ vtinfo 6d50607076fed912same address and namemerged15
2026-11-13 14:10insertdoordash 1233269 ↔ overture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0same address and namemerged15
2026-11-13 14:10insertcvs 8044 ↔ overture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0same address and namemerged15
2026-11-13 14:10insertab-inbev 3097640 ↔ overture 27049b39-56f2-4ada-b8a6-a5cd6de7a5c0same address and namemerged15
2026-11-12 17:29insertab-inbev 3097640 ↔ mi-lcc L-000178857Claude judge: samemerged14
2026-11-12 17:29insertcvs 8044 ↔ doordash 1233269same address and namemerged14
2026-11-12 14:25insertab-inbev 3097640 ↔ vtinfo 6d50607076fed912same address and namemerged12
2026-11-12 14:25insertab-inbev 3097640 ↔ cvs 8044same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000178857 ↔ mi-lcc L-000483926one store listed twicemerged