Outlets /
CVS Pharmacy
Saint Clair Shores, MI 48081 · O0fff635ec8b7 · 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | CVS Pharmacy 4 other | the most common name a source states | CVS/PHARMACY #8040 mi-lcc ×2 WOODWARD DETROIT CVS, L.L.C. mi-lcc (legal name) ×2 CVS ubereats cvs st. clair shores doordash |
| Street | 27700 Harper 2 other | cvs | 27700 HARPER AVE ab-inbevmi-lccoverturevtinfo ×5 27700 Harper Avenue doordashubereats ×2 |
| City | Saint Clair Shores 1 other | cvs | St. Clair Shores doordashovertureubereats ×3 |
| State | MI | cvs | no other value |
| ZIP | 48081 | cvs | no other value |
| Pin | 42.49600, -82.89759 map 5 other | cvs | 95 m away ab-inbev 61 m away doordash 51 m away overture 55 m away ubereats 76 m away vtinfo |
| Phone | 5867730500 1 other | vtinfo | 4017651500 mi-lcc ×2 |
| Licences | mi-lcc L-000178868 · mi-lcc L-000178869 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Obff3acfa28f2; Oa56857844f2e; O766b51de89c3; Obb6107c0835d; O383d98b767ee; O612f7a13bef4; Od68df0871b0d
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | CVS PHARMACY 2387750 | 27700 HARPER AVE, SAINT CLAIR SHORES, MI, 48081 | 42.49686, -82.89760 | 2026-11-11 | 2026-11-11 | |
| cvs | CVS Pharmacy 8040 | 27700 Harper, Saint Clair Shores, MI, 48081 | 42.49600, -82.89759 | 2026-11-12 | 2026-11-13 | |
| doordash | cvs st. clair shores 1233259 | 27700 Harper Avenue, St. Clair Shores, MI, 48081 | 42.49636, -82.89701 | 2026-10-08 | 2026-11-12 | |
| mi-lcc | CVS/PHARMACY #8040 legal name: WOODWARD DETROIT CVS, L.L.C. L-000178868 | 27700 Harper Ave, Saint Clair Shores, MI, 48081 | 4017651500 | 42.49600, -82.89759 | 2026-11-03 | 2026-11-12 |
| mi-lcc | CVS/PHARMACY #8040 legal name: WOODWARD DETROIT CVS, L.L.C. L-000178869 | 27700 Harper Ave, Saint Clair Shores, MI, 48081 | 4017651500 | 42.49600, -82.89759 | 2026-11-03 | 2026-11-12 |
| overture | CVS Pharmacy c8453cdf-2708-47b2-a895-bb64174ae9c5 | 27700 Harper Ave, St Clair Shores, MI, 48081 | 5867730500 | 42.49621, -82.89703 | 2026-11-13 | 2026-11-13 |
| ubereats | CVS 95pGwdIMVf2OFVrnqTbFQw | 27700 HARPER AVENUE, ST CLAIR SHORES, MI, 48081 | 42.49631, -82.89706 | 2026-10-21 | 2026-11-12 | |
| vtinfo | CVS PHARMACY 8af1c3b78a01cbe4 | 27700 HARPER AVE, SAINT CLAIR SHORES, MI, 48081 | 5867730500 | 42.49641, -82.89683 | 2026-11-11 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev CVS PHARMACY | cvs CVS Pharmacy | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.75 |
| ab-inbev CVS PHARMACY | overture CVS Pharmacy | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 86 m apart · name similarity 1.00 |
| ab-inbev CVS PHARMACY | vtinfo CVS PHARMACY | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 81 m apart · name similarity 1.00 |
| cvs CVS Pharmacy | overture CVS Pharmacy | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · pins 51 m apart · name similarity 1.00 · street similarity 0.75 |
| cvs CVS Pharmacy | vtinfo CVS PHARMACY | 1.00 | street written two ways | merged | name Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.75 |
| doordash cvs st. clair shores | ubereats CVS | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| mi-lcc CVS/PHARMACY #8040 | mi-lcc CVS/PHARMACY #8040 | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| overture CVS Pharmacy | vtinfo CVS PHARMACY | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: equal |
| ab-inbev CVS PHARMACY | ubereats CVS | 0.45 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + ZIP · pins 76 m apart · name similarity 0.45 |
| doordash cvs st. clair shores | overture CVS Pharmacy | 0.45 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + ZIP · pins 16 m apart · name similarity 0.45 |
| overture CVS Pharmacy | ubereats CVS | 0.45 | same address and name | merged | address 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 CVS | vtinfo CVS PHARMACY | 0.45 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.82 · same street + ZIP · pins 21 m apart · name similarity 0.45 |
| ab-inbev CVS PHARMACY | doordash cvs st. clair shores | 0.39 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair) Same CVS at same address. Other Claude answers on this pair:
pair 367b52f13e853ce8a533 |
| doordash cvs st. clair shores | mi-lcc CVS/PHARMACY #8040 | 0.30 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “same-address” pair) CVS at identical address. Other Claude answers on this pair:
pair 3b916439cc6080e61e53 |
| doordash cvs st. clair shores | mi-lcc CVS/PHARMACY #8040 | 0.30 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “same-address” pair) Same CVS at same Harper Ave address. Other Claude answers on this pair:
pair 1c78166824211cd11e54 |
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"
]
]
}History
Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-13 14:10 | insert | overture c8453cdf-2708-47b2-a895-bb64174ae9c5 ↔ ubereats 95pGwdIMVf2OFVrnqTbFQw | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | doordash 1233259 ↔ overture c8453cdf-2708-47b2-a895-bb64174ae9c5 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | cvs 8040 ↔ overture c8453cdf-2708-47b2-a895-bb64174ae9c5 | street written two ways | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2387750 ↔ overture c8453cdf-2708-47b2-a895-bb64174ae9c5 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture c8453cdf-2708-47b2-a895-bb64174ae9c5 ↔ vtinfo 8af1c3b78a01cbe4 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | doordash 1233259 ↔ mi-lcc L-000178868 | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | doordash 1233259 ↔ mi-lcc L-000178869 | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 2387750 ↔ doordash 1233259 | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 2387750 ↔ ubereats 95pGwdIMVf2OFVrnqTbFQw | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ubereats 95pGwdIMVf2OFVrnqTbFQw ↔ vtinfo 8af1c3b78a01cbe4 | same address and name | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 2387750 ↔ cvs 8040 | street written two ways | merged | 12 |
| 2026-11-12 14:25 | insert | cvs 8040 ↔ vtinfo 8af1c3b78a01cbe4 | street written two ways | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2387750 ↔ vtinfo 8af1c3b78a01cbe4 | same address and name | merged | 12 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000178868 ↔ mi-lcc L-000178869 | one store listed twice | merged | |
| 2026-10-21 22:03 | backfill | doordash 1233259 ↔ ubereats 95pGwdIMVf2OFVrnqTbFQw | same address and name | merged |