Three Kings Public House

SAINT LOUIS, MO 63126 · O34379c5d3eb2 · first seen 2026-10-08
5 sourceson premise · restaurantchain: Three Kings Public Housealcohol: 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 3 other
a source's own spelling of the licence name (record_title.py)
THREE KING'S PUBLIC HOUSE mo-atc
THREE KINGS HOLDING COMPANY LLC mo-atc (legal name)
three kings public house st. louis doordash
Street
3940 RONNIE'S PLAZA 2 other
mo-atc
40 Ronnie's Plaza doordashoverture ×2
40 RONNIES PLAZA ab-inbevvtinfo ×2
City
SAINT LOUIS 1 other
mo-atc
St. Louis doordashoverture ×2
State
MO
mo-atcno other value
ZIP
63126
mo-atcno other value
Pin
38.52876, -90.36336 map 1 other
doordash
84 m away ab-inbev
Phone
3142933614 2 other
vtinfo
3142703323 mo-atc
3146350724 overture
Licences
mo-atc MO|247579
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob32c02bdc53e; O9e9861edf4b8; O38c5db34dffe; O8ac71bcfb5bd

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
4041920
40 RONNIES PLAZA, SAINT LOUIS, MO, 6312638.52805, -90.363022026-11-112026-11-12
doordashthree kings public house st. louis
167489
40 Ronnie's Plaza, St. Louis, MO, 6312638.52876, -90.363362026-10-082026-11-12
mo-atcTHREE KING'S PUBLIC HOUSE
legal name: THREE KINGS HOLDING COMPANY LLC
MO|247579
3940 RONNIE'S PLAZA, SAINT LOUIS, MO, 6312631427033232026-11-032026-11-18
overtureThree Kings Public House
82bf197a-04d9-475a-a856-369f0493d1d4
40 Ronnie's Plaza, St Louis, MO, 63126314635072438.52870, -90.363412026-11-092026-11-12
vtinfoTHREE KINGS PUBLIC HOUSE
5c4cd6637cf44ad0
40 RONNIES PLAZA, SAINT LOUIS, MO, 63126314293361438.52880, -90.363332026-11-122026-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 KING'S PUBLIC HOUSE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same name, ZIP; address 40 vs 3940 likely truncation.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 82% confident — The names are essentially identical (THREE KINGS PUBLIC HOUSE vs THREE KING'S PUBLIC HOUSE), the street names match (Ronnies/Ronnie's Plaza), and the city and ZIP agree, with only one business at the address; the house number differs (40 vs 3940), which likely reflects a truncated or differently formatted address for the same plaza.
pair b99852f1c3f400ff115d
ab-inbev THREE KINGS PUBLIC HOUSEoverture Three Kings Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
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 88 m apart · name similarity 1.00
doordash three kings public house st. louisoverture Three Kings Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
mo-atc THREE KING'S PUBLIC HOUSEvtinfo THREE KINGS PUBLIC HOUSE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
Distinctive name, same plaza; address number likely typo.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are Three King's Public House on Ronnie's Plaza in Saint Louis 63126, with near-identical names and the only business counted at the address; the street number differs (3940 vs 40) and the phones differ, but the name and plaza match is strong.
pair b6af40ee90cbcec39206
overture Three Kings Public Housevtinfo THREE KINGS PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 · phone: differs
ab-inbev THREE KINGS PUBLIC HOUSEdoordash three kings public house st. louis0.87same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 84 m apart · name similarity 0.87
doordash three kings public house st. louismo-atc THREE KING'S PUBLIC HOUSE0.87Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Distinctive name; address 40 likely truncated 3940 Ronnie's Plaza.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name the same pub (Three Kings / Three King's Public House) on Ronnie's Plaza in St. Louis, MO 63126, and the only business counted at that address is this one; the street numbers differ (40 vs 3940), which is most likely a truncated DoorDash address rather than a different premises.
pair d2fb36367ecc7a66b9ee
doordash three kings public house st. louisvtinfo THREE KINGS PUBLIC HOUSE0.87same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 5 m apart · name similarity 0.87

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Three Kings Public House — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
THREE KINGS HOLDING COMPANY 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:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
49 within 1 mi · 386 within 3 mi
Off / on premise
10 / 28 within 1 mi · 124 / 181 within 3 mi
Selling alcohol
34 within 1 mi · 197 within 3 mi
Nearest
same channel 0.11 mi · licensed 0.17 mi
Setting
suburban (2,692 people per sq mi)
People within 3 mi
76,119 (59,643 adults 21+, 32,699 households) from 18 tract(s), tracts within 3 mi
Income
per capita $49,778 · median household ~$86,837 (weighted mean of tract medians)
Age and education
median age ~44.1 · bachelor's or higher 43%
Ethnicity
Hispanic 3% · White 88% · Black 3% · Asian 2%
Adults per alcohol outlet
301
Alcohol spend within 3 mi
$23,304,919 a year ($10,600,405 at home, $12,696,243 away) · $117,702 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:58insertdoordash 167489 ↔ mo-atc MO|247579Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4041920 ↔ mo-atc MO|247579Claude judge: samemerged15
2026-11-18 18:58insertmo-atc MO|247579 ↔ vtinfo 5c4cd6637cf44ad0Claude judge: samemerged15
2026-11-14 20:23insertdoordash 167489 ↔ vtinfo 5c4cd6637cf44ad0same address and namemerged15
2026-11-14 20:23insertoverture 82bf197a-04d9-475a-a856-369f0493d1d4 ↔ vtinfo 5c4cd6637cf44ad0same address and namemerged15
2026-11-12 14:25insertab-inbev 4041920 ↔ vtinfo 5c4cd6637cf44ad0same address and namemerged12
2026-11-11 12:56insertab-inbev 4041920 ↔ doordash 167489same address and namemerged12
2026-11-11 12:56insertab-inbev 4041920 ↔ overture 82bf197a-04d9-475a-a856-369f0493d1d4same address and namemerged12
2026-11-09 15:32insertdoordash 167489 ↔ overture 82bf197a-04d9-475a-a856-369f0493d1d4same address and namemerged11