J and S Liquor

Detroit, MI 48228 · O18be7fa51c12 · first seen 2026-11-03
5 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
J and S Liquor 4 other
a source's own spelling of the licence name (record_title.py)
J & S LIQUOR ab-inbevvtinfo ×2
J & S LIQUOR STORE, INC. mi-lcc (legal name) ×2
J AND S PARTY STORE mi-lcc ×2
J&S Liquor Store snap
Street
18250 Joy Rd 1 other
mi-lcc
18244 JOY RD ab-inbevoverturesnapvtinfo ×4
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48228
mi-lccno other value
Pin
42.35803, -83.21859 map
overtureno other value
Phone
3138380683
vtinfono other value
Licences
mi-lcc L-000005121 · mi-lcc L-000016812
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odc4a49bae89f; O7a3fb64e0dc6; O38864e38d6c5; O2b308f8ca139; O934421b7925d

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-inbevJ & S LIQUOR
2549404
18244 JOY RD, DETROIT, MI, 4822842.35790, -83.218692026-11-112026-11-11
mi-lccJ AND S PARTY STORE
legal name: J & S LIQUOR STORE, INC.
L-000005121
18250 Joy Rd, Detroit, MI, 48228313838068342.35788, -83.218322026-11-032026-11-18
mi-lccJ AND S PARTY STORE
legal name: J & S LIQUOR STORE, INC.
L-000016812
18250 Joy Rd, Detroit, MI, 48228313838068342.35788, -83.218322026-11-032026-11-18
overtureJ and S Liquor
eb74969a-50f5-4696-ab08-4cd9c8c60438
18244 Joy Rd, Detroit, MI, 48228313838068342.35803, -83.218592026-11-132026-11-13
snapJ&S Liquor Store
snap|us|474877
18244 Joy Rd, Detroit, MI, 4822842.35811, -83.218712026-11-192026-11-19
vtinfoJ & S LIQUOR
ffa3cd8d6fe64d28
18244 JOY RD, DETROIT, MI, 48228313838068342.35809, -83.218722026-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 J & S LIQUORmi-lcc J AND S PARTY STORE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
J & S Liquor legal name, adjacent numbers, same street
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Record A's name 'J & S LIQUOR' matches Record B's legal entity 'J & S LIQUOR STORE, INC.' and the two sit 31 m apart on Joy Rd in the same ZIP, though the street numbers differ (18244 vs 18250) and the building is shared with another business.
pair db9cb0459785bf54ac51
ab-inbev J & S LIQUORmi-lcc J AND S PARTY STORE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
J&S Liquor legal name, adjacent numbers
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — The Michigan licence's legal entity 'J & S LIQUOR STORE, INC.' matches the AB InBev record's name 'J & S LIQUOR' on Joy Rd in Detroit 48228, and the coordinates are about 31 m apart; the house numbers differ (18244 vs 18250), so the address match is not exact.
pair 89005c029a2a89463530
ab-inbev J & S LIQUORoverture J and S Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev J & S LIQUORsnap J&S Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ab-inbev J & S LIQUORvtinfo J & S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
mi-lcc J AND S PARTY STOREmi-lcc J AND S PARTY STORE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc J AND S PARTY STOREvtinfo J & S LIQUOR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Same phone, matching J&S name, adjacent address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Phone numbers match exactly, the coordinates are about 41 m apart, and record B's name 'J & S LIQUOR' matches record A's legal entity 'J & S LIQUOR STORE, INC.' on Joy Rd in the same ZIP, though the street numbers (18250 vs 18244) differ slightly.
pair 4a1383b267639b32cac3
mi-lcc J AND S PARTY STOREvtinfo J & S LIQUOR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Same phone, J&S liquor name, adjacent address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records share the same phone number and sit about 41 m apart on Joy Rd, and record A's filed legal name 'J & S LIQUOR STORE, INC.' matches record B's name 'J & S LIQUOR', so they are one liquor store despite the 18250 vs 18244 house-number difference.
pair a4f4da5e12860717671e
overture J and S Liquorsnap J&S Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
overture J and S Liquorvtinfo J & S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00 · phone: equal
snap J&S Liquor Storevtinfo J & S LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
36 within 1 mi · 505 within 3 mi
Off / on premise
19 / 12 within 1 mi · 162 / 271 within 3 mi
Selling alcohol
23 within 1 mi · 211 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.02 mi
Setting
urban (5,135 people per sq mi)
People within 3 mi
145,182 (97,337 adults 21+, 52,554 households) from 50 tract(s), tracts within 3 mi
Income
per capita $21,995 · median household ~$42,522 (weighted mean of tract medians)
Age and education
median age ~32.9 · bachelor's or higher 18%
Ethnicity
Hispanic 4% · White 38% · Black 55% · Asian 1%
Adults per alcohol outlet
459
Alcohol spend within 3 mi
$22,920,386 a year ($11,318,875 at home, $11,586,852 away) · $108,115 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:37insertab-inbev 2549404 ↔ snap snap|us|474877same address and namemerged17
2026-11-19 20:37insertsnap snap|us|474877 ↔ vtinfo ffa3cd8d6fe64d28same address and namemerged17
2026-11-19 20:37insertoverture eb74969a-50f5-4696-ab08-4cd9c8c60438 ↔ snap snap|us|474877same address and namemerged17
2026-11-18 18:58insertab-inbev 2549404 ↔ mi-lcc L-000005121Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000016812 ↔ vtinfo ffa3cd8d6fe64d28Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 2549404 ↔ mi-lcc L-000016812Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000005121 ↔ vtinfo ffa3cd8d6fe64d28Claude judge: samemerged15
2026-11-13 14:10insertoverture eb74969a-50f5-4696-ab08-4cd9c8c60438 ↔ vtinfo ffa3cd8d6fe64d28same address and namemerged15
2026-11-13 14:10insertab-inbev 2549404 ↔ overture eb74969a-50f5-4696-ab08-4cd9c8c60438same address and namemerged15
2026-11-12 14:25insertab-inbev 2549404 ↔ vtinfo ffa3cd8d6fe64d28same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000005121 ↔ mi-lcc L-000016812one store listed twicemerged