Shamrock Inn

SAINT JOSEPH, MO 64505 · O05dd1973d6f9 · first seen 2026-11-03
4 sourceson premise · baralcohol: licensed1 licence

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
Shamrock Inn 3 other
a licence name in capitals, cleaned (derived; record_title.py)
PETERMAN LLC mo-atc (legal name)
Peterman's Shamrock Bar overture
PETERMANS SHAMROCK mo-atc
Street
1805 ST JOSEPH AVE 1 other
mo-atc
1805 SAINT JOSEPH AVE ab-inbevvtinfo ×2
City
SAINT JOSEPH 1 other
mo-atc
St Joseph overture
State
MO
mo-atcno other value
ZIP
64505
mo-atcno other value
Pin
39.77997, -94.85307 map
overtureno other value
Phone
8162324907 1 other
vtinfo
8163649590 mo-atc
Licences
mo-atc MO|188617
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc23165cf7e43; O52181be561d4; O2235ea02bfb8

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-inbevSHAMROCK INN
3026654
1805 SAINT JOSEPH AVE, SAINT JOSEPH, MO, 6450539.78013, -94.853072026-11-112026-11-11
mo-atcPETERMANS SHAMROCK
legal name: PETERMAN LLC
MO|188617
1805 ST JOSEPH AVE, SAINT JOSEPH, MO, 64505816364959039.77981, -94.853312026-11-032026-11-18
overturePeterman's Shamrock Bar
85b19143-9599-47f8-a133-8b01f3949a14
1805 St Joseph Ave, St Joseph, MO, 6450539.77997, -94.853072026-11-132026-11-18
vtinfoSHAMROCK INN
e863b271b4b724f7
1805 SAINT JOSEPH AVE, SAINT JOSEPH, MO, 64505816232490739.77981, -94.852942026-11-182026-11-19

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 SHAMROCK INNvtinfo SHAMROCK INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 37 m apart · name similarity 1.00
mo-atc PETERMANS SHAMROCKoverture Peterman's Shamrock Bar0.78same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.80 · same street + ZIP · pins 27 m apart · name similarity 0.78
ab-inbev SHAMROCK INNmo-atc PETERMANS SHAMROCK0.50Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Shamrock name shared at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 68% confident — Both records sit at the same Saint Joseph, MO address (1805 Saint Joseph Ave, 41 m apart) and share the distinctive 'Shamrock' name, with the Missouri licence's trade name 'Petermans Shamrock' plausibly being the operator of the 'Shamrock Inn'; the only other business counted at that address appears to be this same pair, though the names are not identical, so confidence is moderate.
pair ef23c569aa7a235163f9

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PETERMAN LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MO Retail by Drink
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
65 within 1 mi · 241 within 3 mi
Off / on premise
14 / 29 within 1 mi · 67 / 109 within 3 mi
Selling alcohol
49 within 1 mi · 149 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.01 mi
Setting
suburban (1,431 people per sq mi)
People within 3 mi
40,447 (29,658 adults 21+, 15,737 households) from 13 tract(s), tracts within 3 mi
Income
per capita $28,280 · median household ~$54,667 (weighted mean of tract medians)
Age and education
median age ~37.0 · bachelor's or higher 21%
Ethnicity
Hispanic 10% · White 74% · Black 8% · Asian 2%
Adults per alcohol outlet
198
Alcohol spend within 3 mi
$7,717,339 a year ($3,758,491 at home, $3,955,717 away) · $51,449 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 3026654 ↔ mo-atc MO|188617Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 3026654 ↔ vtinfo e863b271b4b724f7same address and namemerged15
2026-11-13 14:10insertmo-atc MO|188617 ↔ overture 85b19143-9599-47f8-a133-8b01f3949a14same address and namemerged15