ON THE ROCKS

SAINT CHARLES, MO 63303 · O9d54e8fcb1a2 · first seen 2026-11-03
4 sourcesunknownalcohol: 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
ON THE ROCKS 1 other
the most common name a source states
OTR LIQUOR LLC mo-atc (legal name)
Street
1976 S. OLD HWY 94
mo-atcno other value
City
SAINT CHARLES
mo-atcno other value
State
MO
mo-atcno other value
ZIP
63303
mo-atcno other value
Pin
38.76221, -90.52999 map 1 other
mo-atc
128 m away ab-inbev
Phone
6364931889 1 other
hemp
3204440918 mo-atc
Licences
mo-atc MO|271159
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obcf4abd4e1cb; Ob0a57e2394c6; Oa1e79ca03fdb

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-inbevON THE ROCKS
4394231
1976 S OLD HWY 94, SAINT CHARLES, MO, 6330338.76268, -90.528642026-11-112026-11-11
hempON THE ROCKS
2be9f4de2e1a6eed
1976 S OLD HWY 94, SAINT CHARLES, MO, 63303636493188938.76199, -90.529872026-11-032026-11-11
mo-atcON THE ROCKS
legal name: OTR LIQUOR LLC
MO|271159
1976 S. OLD HWY 94, SAINT CHARLES, MO, 63303320444091838.76221, -90.529992026-11-032026-11-11
vtinfoON THE ROCKS
944eebb3b1200794
1976 S OLD HWY 94, SAINT CHARLES, MO, 63303636493188938.76199, -90.529872026-11-112026-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 ON THE ROCKShemp ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 132 m apart · name similarity 1.00
ab-inbev ON THE ROCKSmo-atc ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 128 m apart · name similarity 1.00
ab-inbev ON THE ROCKSvtinfo ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 132 m apart · name similarity 1.00
hemp ON THE ROCKSmo-atc ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: differs
hemp ON THE ROCKSvtinfo ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 · phone: equal
mo-atc ON THE ROCKSvtinfo ON THE ROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
OTR LIQUOR LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MO Original Package Liquor
Rule version 7, computed 2026-11-16 17:19.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
36 within 1 mi · 417 within 3 mi
Off / on premise
10 / 13 within 1 mi · 93 / 206 within 3 mi
Selling alcohol
26 within 1 mi · 253 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.01 mi
Setting
suburban (2,867 people per sq mi)
People within 3 mi
81,059 (63,094 adults 21+, 34,880 households) from 19 tract(s), tracts within 3 mi
Income
per capita $50,170 · median household ~$89,174 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 44%
Ethnicity
Hispanic 6% · White 81% · Black 6% · Asian 4%
Adults per alcohol outlet
248
Alcohol spend within 3 mi
$25,214,774 a year ($11,448,115 at home, $13,756,904 away) · $99,271 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-11 12:56insertab-inbev 4394231 ↔ vtinfo 944eebb3b1200794same address and namemerged12
2026-11-11 12:56insertab-inbev 4394231 ↔ mo-atc MO|271159same address and namemerged12
2026-11-11 12:56insertmo-atc MO|271159 ↔ vtinfo 944eebb3b1200794same address and namemerged12
2026-11-11 12:56insertab-inbev 4394231 ↔ hemp 2be9f4de2e1a6eedsame address and namemerged12
2026-11-11 12:56inserthemp 2be9f4de2e1a6eed ↔ vtinfo 944eebb3b1200794same address and namemerged12
2026-11-03 13:33backfillhemp 2be9f4de2e1a6eed ↔ mo-atc MO|271159same address and namemerged