Anderson Pharmacy

Bay City, MI 48706 · O02a628c117b5 · first seen 2026-11-03
4 sourcesoff premise · 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
Anderson Pharmacy
a source's own spelling of the licence name (record_title.py)no other value
Street
1108 Marquette St 2 other
mi-lcc
1100 MARQUETTE ST ab-inbevvtinfo ×2
1108 Marquette Ave overture
City
Bay City
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48706
mi-lccno other value
Pin
43.61450, -83.87965 map
overtureno other value
Phone
9896848905
vtinfono other value
Licences
mi-lcc L-000010269 · mi-lcc L-000011100
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odd3ecf13f47b; Oeecf1bde92db; Oed965ee04b17; Oca4419a158a4

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-inbevANDERSON PHARMACY
2525346
1100 MARQUETTE ST, BAY CITY, MI, 4870643.61464, -83.879662026-11-112026-11-12
mi-lccANDERSON PHARMACY
L-000010269
1108 Marquette St, Bay City, MI, 48706989684890543.61460, -83.880192026-11-032026-11-04
mi-lccANDERSON PHARMACY
L-000011100
1108 Marquette St, Bay City, MI, 48706989684890543.61460, -83.880192026-11-032026-11-04
overtureAnderson Pharmacy
f5c8b96e-ab15-4656-81de-23b097189172
1108 Marquette Ave, Bay City, MI, 48706989684890543.61450, -83.879652026-11-182026-11-18
vtinfoANDERSON PHARMACY
8a2733dd3862af97
1100 MARQUETTE ST, BAY CITY, MI, 48706989684890543.61449, -83.880052026-11-152026-11-15

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 ANDERSON PHARMACYmi-lcc ANDERSON PHARMACY1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “proximity” pair)
Same name, adjacent numbers on same street
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records carry the identical name ANDERSON PHARMACY in Bay City, MI 48706 at essentially the same address (1100 vs 1108 Marquette St, 0.04 km apart), and no other business is listed at that address, so this is one pharmacy outlet.
pair 232548febcd323daba28
ab-inbev ANDERSON PHARMACYvtinfo ANDERSON PHARMACY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
mi-lcc ANDERSON PHARMACYmi-lcc ANDERSON PHARMACY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ANDERSON PHARMACYoverture Anderson Pharmacy1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 45 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc ANDERSON PHARMACYvtinfo ANDERSON PHARMACY1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Same name and phone, adjacent street number.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Identical names, matching phone numbers, the same ZIP and city, and coordinates about 16 m apart, with only one business at the address; the small street-number difference (1108 vs 1100) is consistent with geocoding variation.
pair 1747d6ed0ea6d68282bc
mi-lcc ANDERSON PHARMACYoverture Anderson Pharmacy1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 45 m apart · name similarity 1.00 · street similarity 0.80

Attributes

Channel
off_premise · pharmacy — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
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:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
27 within 1 mi · 295 within 3 mi
Off / on premise
8 / 14 within 1 mi · 83 / 130 within 3 mi
Selling alcohol
11 within 1 mi · 193 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.59 mi
Setting
suburban (1,548 people per sq mi)
People within 3 mi
43,772 (33,618 adults 21+, 19,843 households) from 13 tract(s), tracts within 3 mi
Income
per capita $31,287 · median household ~$52,993 (weighted mean of tract medians)
Age and education
median age ~41.3 · bachelor's or higher 20%
Ethnicity
Hispanic 8% · White 87% · Black 2% · Asian 1%
Adults per alcohol outlet
173
Alcohol spend within 3 mi
$9,509,261 a year ($4,668,271 at home, $4,836,684 away) · $49,017 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-000010269 ↔ vtinfo 8a2733dd3862af97Claude judge: samemerged17
2026-11-18 18:58insertmi-lcc L-000010269 ↔ overture f5c8b96e-ab15-4656-81de-23b097189172street written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000011100 ↔ overture f5c8b96e-ab15-4656-81de-23b097189172street written two waysmerged15
2026-11-15 16:24insertab-inbev 2525346 ↔ vtinfo 8a2733dd3862af97same address and namemerged15
2026-11-12 17:29insertab-inbev 2525346 ↔ mi-lcc L-000011100Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000010269 ↔ mi-lcc L-000011100one store listed twicemerged