Three Kings Public House

COTTLEVILLE, MO 63304 · O2e2b6e07724e · first seen 2026-11-03
3 sourceson premise · predictedalcohol: 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
Three Kings Public House 1 other
a licence name in capitals, cleaned (derived; record_title.py)
THREE KINGS-COTTLEVILLE LLC mo-atc (legal name)
Street
5045 STATE HIGHWAY N 1 other
mo-atc
5045 STATE RTE N ab-inbevvtinfo ×2
City
COTTLEVILLE
mo-atcno other value
State
MO
mo-atcno other value
ZIP
63304
mo-atcno other value
Pin
38.74438, -90.64215 map 2 other
mo-atc
207 m away ab-inbev
207 m away vtinfo
Phone
6364776086 1 other
vtinfo
3144949409 mo-atc
Licences
mo-atc MO|314399
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc3bfa0168fe3; O608ccf802b97

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-inbevTHREE KINGS PUBLIC HOUSE
4902709
5045 STATE RTE N, COTTLEVILLE, MO, 6330438.74473, -90.639802026-11-112026-11-11
mo-atcTHREE KINGS PUBLIC HOUSE
legal name: THREE KINGS-COTTLEVILLE LLC
MO|314399
5045 STATE HIGHWAY N, COTTLEVILLE, MO, 63304314494940938.74438, -90.642152026-11-032026-11-18
vtinfoTHREE KINGS PUBLIC HOUSE
1d557e46e2b97c84
5045 STATE RTE N, COTTLEVILLE, MO, 63304636477608638.74448, -90.639762026-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 THREE KINGS PUBLIC HOUSEmo-atc THREE KINGS PUBLIC HOUSE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “near” pair)
Same name, same address (Rte N = Hwy N).
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records carry the identical name THREE KINGS PUBLIC HOUSE at the same street address (STATE RTE N / STATE HIGHWAY N) and ZIP in Cottleville, MO, with coordinates 0.2 km apart and only one business at the address, so this is one bar/restaurant outlet.
pair f59743ce798adb488983
ab-inbev THREE KINGS PUBLIC HOUSEvtinfo THREE KINGS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
mo-atc THREE KINGS PUBLIC HOUSEvtinfo THREE KINGS PUBLIC HOUSE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Identical distinctive name at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records carry the identical trade name THREE KINGS PUBLIC HOUSE at the same street address (5045 State Rte/Highway N) and city and ZIP in Cottleville, MO, with coordinates about 0.2 km apart and it is the only business at that address; the differing phone numbers are a weak counter-signal against an otherwise strong match.
pair 3e2da6ee44729b18d129

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THREE KINGS-COTTLEVILLE LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MO Retail by Drink
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
87 within 1 mi · 217 within 3 mi
Off / on premise
19 / 37 within 1 mi · 49 / 95 within 3 mi
Selling alcohol
56 within 1 mi · 132 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
suburban (2,825 people per sq mi)
People within 3 mi
79,889 (58,153 adults 21+, 29,863 households) from 15 tract(s), tracts within 3 mi
Income
per capita $51,434 · median household ~$114,051 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 46%
Ethnicity
Hispanic 4% · White 86% · Black 5% · Asian 2%
Adults per alcohol outlet
437
Alcohol spend within 3 mi
$24,842,279 a year ($11,041,129 at home, $13,790,387 away) · $186,784 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 4902709 ↔ mo-atc MO|314399Claude judge: samemerged15
2026-11-18 18:58insertmo-atc MO|314399 ↔ vtinfo 1d557e46e2b97c84Claude judge: samemerged15
2026-11-13 14:10insertab-inbev 4902709 ↔ vtinfo 1d557e46e2b97c84same address and namemerged15