Blue Shamrock

Saint Louis, MI 48880 · O21a36e5f1a9e · first seen 2026-11-03
4 sourceson premise · baralcohol: 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
Blue Shamrock 3 other
a licence name in capitals, cleaned (derived; record_title.py)
1 FAT DOG, LLC mi-lcc (legal name) ×2
THE BLUE SHAMROCK PUB inspectionsoverture ×2
BLUE SHAMROCK BAR ab-inbev
Street
225 N Mill St 1 other
mi-lcc
223 N MILL ST ab-inbevinspectionsoverture ×3
City
Saint Louis 1 other
mi-lcc
St Louis overture
State
MI
mi-lccno other value
ZIP
48880
mi-lccno other value
Pin
43.41002, -84.60888 map 1 other
overture
51 m away mi-lcc ×2
Phone
9896814160
overtureno other value
Licences
mi-lcc L-000420382 · mi-lcc L-000420383
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of1af8d984342; Of76008490ff9; Od46df1fb5cb1; Oae919392272b

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-inbevBLUE SHAMROCK BAR
3310184
223 N MILL ST, SAINT LOUIS, MI, 4888043.40990, -84.608812026-11-112026-11-13
inspectionsTHE BLUE SHAMROCK PUB
inspections|mi|SFE-1629-237325
223 N MILL ST, Saint Louis, MI, 4888043.40988, -84.608872026-11-202026-11-20
mi-lccBLUE SHAMROCK
legal name: 1 FAT DOG, LLC
L-000420382
225 N Mill St, Saint Louis, MI, 48880989681416043.40956, -84.608822026-11-032026-11-13
mi-lccBLUE SHAMROCK
legal name: 1 FAT DOG, LLC
L-000420383
225 N Mill St, Saint Louis, MI, 48880989681416043.40956, -84.608822026-11-032026-11-13
overtureThe Blue Shamrock Pub
12b3649b-395e-4075-ae31-b651b9e7bb3c
223 N Mill St, St Louis, MI, 48880989681416043.41002, -84.608882026-11-132026-11-13

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
inspections THE BLUE SHAMROCK PUBoverture The Blue Shamrock Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
mi-lcc BLUE SHAMROCKmi-lcc BLUE SHAMROCK1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev BLUE SHAMROCK BARmi-lcc BLUE SHAMROCK0.77Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Same distinctive name, adjacent street numbers, same town.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are the Blue Shamrock bar on North Mill Street in Saint Louis, MI, with coordinates about 38 m apart and only one business name at the address; the 223 vs 225 house-number gap is a minor discrepancy for one building.
pair 0b76af2c621c8f9db3fb
ab-inbev BLUE SHAMROCK BARinspections THE BLUE SHAMROCK PUB0.63same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, pub · name Jaro-Winkler 0.88 · same street + ZIP · pins 5 m apart · name similarity 0.63
ab-inbev BLUE SHAMROCK BARoverture The Blue Shamrock Pub0.63same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, pub · name Jaro-Winkler 0.88 · same street + ZIP · pins 14 m apart · name similarity 0.63

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
1 FAT DOG, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
14 within 1 mi · 40 within 3 mi
Off / on premise
4 / 4 within 1 mi · 16 / 8 within 3 mi
Selling alcohol
11 within 1 mi · 30 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
suburban (666 people per sq mi)
People within 3 mi
18,821 (14,765 adults 21+, 5,901 households) from 4 tract(s), tracts within 3 mi
Income
per capita $26,698 · median household ~$63,585 (weighted mean of tract medians)
Age and education
median age ~37.5 · bachelor's or higher 19%
Ethnicity
Hispanic 7% · White 81% · Black 12% · Asian 1%
Adults per alcohol outlet
476
Alcohol spend within 3 mi
$3,315,066 a year ($1,590,355 at home, $1,723,276 away) · $106,938 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-20 22:08insertab-inbev 3310184 ↔ inspections inspections|mi|SFE-1629-237325same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1629-237325 ↔ overture 12b3649b-395e-4075-ae31-b651b9e7bb3csame address and namemerged17
2026-11-13 14:10insertab-inbev 3310184 ↔ overture 12b3649b-395e-4075-ae31-b651b9e7bb3csame address and namemerged15
2026-11-12 17:29insertab-inbev 3310184 ↔ mi-lcc L-000420382Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000420382 ↔ mi-lcc L-000420383one store listed twicemerged