Select Wine Shop

Ferndale, MI 48220 · O514a1064903b · first seen 2026-11-03
4 sourcesoff premise · liquor_storealcohol: 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
Select Wine Shop 1 other
a source's own spelling of the licence name (record_title.py)
KOLLIN LIQUOR, INC. mi-lcc (legal name) ×2
Street
1320 W 9 Mile Rd 1 other
mi-lcc
1318 W 9 MILE RD ab-inbevoverturevtinfo ×3
City
Ferndale
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48220
mi-lccno other value
Pin
42.46022, -83.15186 map
overtureno other value
Phone
2485438797
vtinfono other value
Licences
mi-lcc L-000262169 · mi-lcc L-000262170
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O594a2e05581d; O5c9832f66f7a; Od55cf20ba6af; O591396ad14cc

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-inbevSELECT WINE SHOP
3998859
1318 W 9 MILE RD, FERNDALE, MI, 4822042.46037, -83.152312026-11-112026-11-18
mi-lccSELECT WINE SHOP
legal name: KOLLIN LIQUOR, INC.
L-000262169
1320 W 9 Mile Rd, Ferndale, MI, 48220248543879742.46022, -83.151692026-11-032026-11-05
mi-lccSELECT WINE SHOP
legal name: KOLLIN LIQUOR, INC.
L-000262170
1320 W 9 Mile Rd, Ferndale, MI, 48220248543879742.46022, -83.151692026-11-032026-11-05
overtureSelect Wine Shop
5bfa4b29-5f20-4b00-aa37-07b9674a55c9
1318 W 9 Mile Rd, Ferndale, MI, 48220248543879742.46022, -83.151862026-11-132026-11-18
vtinfoSELECT WINE SHOP
8056989e57ebea99
1318 W 9 MILE RD, FERNDALE, MI, 48220248543879742.46042, -83.151782026-11-112026-11-18

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 SELECT WINE SHOPmi-lcc SELECT WINE SHOP1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Same name, adjacent address numbers.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the identical name SELECT WINE SHOP in Ferndale, MI, 48220, with coordinates about 53 m apart and the same phone-free single-business address count; the 1318 vs 1320 house-number gap is most likely a data-entry or geocoding variance for one store.
pair d35265f0bbf98d24ca37
ab-inbev SELECT WINE SHOPmi-lcc SELECT WINE SHOP1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Same name, adjacent street numbers, same city.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the identical name SELECT WINE SHOP in Ferndale, MI 48220, and their coordinates are about 53 m apart; the street numbers differ by only two (1318 vs 1320), which is most likely a numbering or geocoding variance for one storefront, with no other business listed at the address.
pair a6bf3b5213d9a6d9a2e5
ab-inbev SELECT WINE SHOPoverture Select Wine Shop1.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 SELECT WINE SHOPvtinfo SELECT WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
mi-lcc SELECT WINE SHOPmi-lcc SELECT WINE SHOP1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SELECT WINE SHOPvtinfo SELECT WINE SHOP1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% 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, 87% confident — Both records are named SELECT WINE SHOP in Ferndale, MI 48220 with the identical phone number and coordinates about 23 m apart, and no other business is held at the address, so the 1320 vs 1318 house-number gap looks like a minor address variant of one store.
pair 3656fc78c4ada0fdbe14
mi-lcc SELECT WINE SHOPvtinfo SELECT WINE SHOP1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name and phone, adjacent street numbers
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records carry the name SELECT WINE SHOP, the same phone number (248-543-8797), and coordinates about 23 m apart in Ferndale, MI, with street numbers 1318 and 1320 W 9 Mile Rd that likely fall in one building; only one business is held at that address, so this is most likely one store.
pair c845f5ac932f0d5e9c05
overture Select Wine Shopvtinfo SELECT WINE SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
KOLLIN LIQUOR, INC. — 1 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 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
141 within 1 mi · 755 within 3 mi
Off / on premise
17 / 79 within 1 mi · 181 / 414 within 3 mi
Selling alcohol
81 within 1 mi · 389 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.16 mi
Setting
urban (5,498 people per sq mi)
People within 3 mi
155,450 (123,428 adults 21+, 70,537 households) from 52 tract(s), tracts within 3 mi
Income
per capita $47,471 · median household ~$82,608 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 43%
Ethnicity
Hispanic 3% · White 46% · Black 45% · Asian 2%
Adults per alcohol outlet
316
Alcohol spend within 3 mi
$45,831,828 a year ($21,077,350 at home, $24,733,803 away) · $117,518 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:58insertab-inbev 3998859 ↔ mi-lcc L-000262169Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000262170 ↔ vtinfo 8056989e57ebea99Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3998859 ↔ mi-lcc L-000262170Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000262169 ↔ vtinfo 8056989e57ebea99Claude judge: samemerged15
2026-11-13 14:10insertoverture 5bfa4b29-5f20-4b00-aa37-07b9674a55c9 ↔ vtinfo 8056989e57ebea99same address and namemerged15
2026-11-13 14:10insertab-inbev 3998859 ↔ overture 5bfa4b29-5f20-4b00-aa37-07b9674a55c9same address and namemerged15
2026-11-11 12:56insertab-inbev 3998859 ↔ vtinfo 8056989e57ebea99same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000262169 ↔ mi-lcc L-000262170one store listed twicemerged