PJ's Tavern

Kirkwood, MO 63122 · O0b4a485c98a2 · first seen 2026-10-08
5 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
PJ's Tavern 2 other
a source's own spelling of the licence name (record_title.py)
PJS TAVERN ab-inbevmo-atcvtinfo ×3
CLAY ADAMS PJ'S LLC mo-atc (legal name)
Street
123 W. JEFFERSON AVE. 1 other
mo-atc
123 West Jefferson Avenue ubereats
City
KIRKWOOD 1 other
mo-atc
SAINT LOUIS ab-inbevvtinfo ×2
State
MO
mo-atcno other value
ZIP
63122
mo-atcno other value
Pin
38.58244, -90.40756 map 2 other
ubereats
58 m away ab-inbev
59 m away mo-atc
Phone
3149662001 1 other
vtinfo
3144761833 mo-atc
Licences
mo-atc MO|282769
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe6c45d787b68; Oa087bbed7e9a; O1a26bc96094c; Ofa5d08f70ab6

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-inbevPJS TAVERN
2507085
123 W JEFFERSON AVE, SAINT LOUIS, MO, 6312238.58249, -90.408222026-11-112026-11-11
mo-atcPJS TAVERN
legal name: CLAY ADAMS PJ'S LLC
MO|282769
123 W. JEFFERSON AVE., KIRKWOOD, MO, 63122314476183338.58234, -90.406892026-11-032026-11-11
overturePJ's Tavern
139c38e8-c6d8-46a3-b9ea-09ba93f928ab
123 W Jefferson Ave, Kirkwood, MO, 63122314966200138.58244, -90.407552026-11-062026-11-11
ubereatsPJ's Tavern
63OshvoBXwyBAnm-Z-nWfw
123 West Jefferson Avenue, Kirkwood, MO, 6312238.58244, -90.407562026-10-082026-11-11
vtinfoPJS TAVERN
aee9b59018cde801
123 W JEFFERSON AVE, SAINT LOUIS, MO, 63122314966200138.58258, -90.407672026-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 PJS TAVERNmo-atc PJS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 117 m apart · name similarity 1.00
ab-inbev PJS TAVERNoverture PJ's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 59 m apart · name similarity 1.00
ab-inbev PJS TAVERNubereats PJ's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ab-inbev PJS TAVERNvtinfo PJS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 48 m apart · name similarity 1.00
mo-atc PJS TAVERNoverture PJ's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00 · phone: differs
mo-atc PJS TAVERNubereats PJ's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mo-atc PJS TAVERNvtinfo PJS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 73 m apart · name similarity 1.00 · phone: differs
overture PJ's Tavernubereats PJ's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
overture PJ's Tavernvtinfo PJS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00 · phone: equal
ubereats PJ's Tavernvtinfo PJS TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CLAY ADAMS PJ'S 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:34.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
62 within 1 mi · 404 within 3 mi
Off / on premise
8 / 43 within 1 mi · 123 / 203 within 3 mi
Selling alcohol
36 within 1 mi · 217 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
suburban (2,808 people per sq mi)
People within 3 mi
79,402 (57,565 adults 21+, 31,062 households) from 19 tract(s), tracts within 3 mi
Income
per capita $76,849 · median household ~$142,712 (weighted mean of tract medians)
Age and education
median age ~42.9 · bachelor's or higher 71%
Ethnicity
Hispanic 2% · White 86% · Black 3% · Asian 2%
Adults per alcohol outlet
264
Alcohol spend within 3 mi
$29,959,073 a year ($12,843,156 at home, $17,106,686 away) · $137,427 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:23insertmo-atc MO|282769 ↔ vtinfo aee9b59018cde801same address and namemerged15
2026-11-14 20:23insertubereats 63OshvoBXwyBAnm-Z-nWfw ↔ vtinfo aee9b59018cde801same address and namemerged15
2026-11-14 20:23insertoverture 139c38e8-c6d8-46a3-b9ea-09ba93f928ab ↔ vtinfo aee9b59018cde801same address and namemerged15
2026-11-12 14:25insertab-inbev 2507085 ↔ vtinfo aee9b59018cde801same address and namemerged12
2026-11-11 12:56insertab-inbev 2507085 ↔ mo-atc MO|282769same address and namemerged12
2026-11-11 12:56insertab-inbev 2507085 ↔ ubereats 63OshvoBXwyBAnm-Z-nWfwsame address and namemerged12
2026-11-11 12:56insertab-inbev 2507085 ↔ overture 139c38e8-c6d8-46a3-b9ea-09ba93f928absame address and namemerged12
2026-11-06 18:13insertmo-atc MO|282769 ↔ overture 139c38e8-c6d8-46a3-b9ea-09ba93f928absame address and namemerged11
2026-11-06 18:13insertoverture 139c38e8-c6d8-46a3-b9ea-09ba93f928ab ↔ ubereats 63OshvoBXwyBAnm-Z-nWfwsame address and namemerged11
2026-11-03 13:33backfillmo-atc MO|282769 ↔ ubereats 63OshvoBXwyBAnm-Z-nWfwsame address and namemerged