SHAMROCKS PUB & GRILL

SAINT PETERS, MO 63376 · O6d4d4e4c5353 · first seen 2026-11-03
4 sourceson premise · restaurantalcohol: 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
SHAMROCKS PUB & GRILL 2 other
the most common name a source states
SHAMROCKS PUB N GRILL mo-atcoverture ×2
DURST & DENT INC. mo-atc (legal name)
Street
7337 MEXICO RD
mo-atcno other value
City
SAINT PETERS 1 other
mo-atc
St Peters overture
State
MO
mo-atcno other value
ZIP
63376
mo-atcno other value
Pin
38.78870, -90.63211 map 2 other
overture
130 m away ab-inbev
107 m away mo-atc
Phone
6369392000 1 other
vtinfo
6364433291 mo-atc
Licences
mo-atc MO|202030
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe27a28593764; Oe7d64ea51ead; O999aa1debb0b

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-inbevSHAMROCKS PUB & GRILL
4484928
7337 MEXICO RD, SAINT PETERS, MO, 6337638.78934, -90.633372026-11-112026-11-11
mo-atcSHAMROCKS PUB N GRILL
legal name: DURST & DENT INC.
MO|202030
7337 MEXICO RD, SAINT PETERS, MO, 63376636443329138.78888, -90.630892026-11-032026-11-05
overtureShamrocks Pub n Grill
ff11bcdf-9a7d-4547-bee6-5563a21ddde2
7337 Mexico Rd, St Peters, MO, 63376636939200038.78870, -90.632112026-11-062026-11-06
vtinfoSHAMROCKS PUB & GRILL
2342a925cc956912
7337 MEXICO RD, SAINT PETERS, MO, 63376636939200038.78884, -90.632632026-11-132026-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 SHAMROCKS PUB & GRILLvtinfo SHAMROCKS PUB & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 85 m apart · name similarity 1.00
mo-atc SHAMROCKS PUB N GRILLoverture Shamrocks Pub n Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 107 m apart · name similarity 1.00 · phone: differs
ab-inbev SHAMROCKS PUB & GRILLmo-atc SHAMROCKS PUB N GRILL0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 221 m apart · name similarity 0.85
ab-inbev SHAMROCKS PUB & GRILLoverture Shamrocks Pub n Grill0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 130 m apart · name similarity 0.85
mo-atc SHAMROCKS PUB N GRILLvtinfo SHAMROCKS PUB & GRILL0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + city + state · pins 151 m apart · name similarity 0.85 · phone: differs
overture Shamrocks Pub n Grillvtinfo SHAMROCKS PUB & GRILL0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 48 m apart · name similarity 0.85 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DURST & DENT INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MO Retail by Drink
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
114 within 1 mi · 307 within 3 mi
Off / on premise
36 / 60 within 1 mi · 87 / 139 within 3 mi
Selling alcohol
51 within 1 mi · 162 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.10 mi
Setting
suburban (2,364 people per sq mi)
People within 3 mi
66,853 (49,930 adults 21+, 26,067 households) from 13 tract(s), tracts within 3 mi
Income
per capita $44,811 · median household ~$96,809 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 37%
Ethnicity
Hispanic 3% · White 85% · Black 5% · Asian 2%
Adults per alcohol outlet
306
Alcohol spend within 3 mi
$19,164,081 a year ($8,718,917 at home, $10,436,435 away) · $117,571 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-14 20:23insertoverture ff11bcdf-9a7d-4547-bee6-5563a21ddde2 ↔ vtinfo 2342a925cc956912same address and namemerged15
2026-11-13 14:10insertmo-atc MO|202030 ↔ vtinfo 2342a925cc956912same address and namemerged15
2026-11-13 14:10insertab-inbev 4484928 ↔ vtinfo 2342a925cc956912same address and namemerged15
2026-11-11 12:56insertab-inbev 4484928 ↔ overture ff11bcdf-9a7d-4547-bee6-5563a21ddde2same address and namemerged12
2026-11-11 12:56insertab-inbev 4484928 ↔ mo-atc MO|202030same address and namemerged12
2026-11-06 18:13insertmo-atc MO|202030 ↔ overture ff11bcdf-9a7d-4547-bee6-5563a21ddde2same address and namemerged11