MAGPIES

SAINT CHARLES, MO 63301 · O24953b15e82c · 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
MAGPIES 2 other
the most common name a source states
MAGPIE'S CAFE mo-atcoverture ×2
BJP ENTERPRISES LLC mo-atc (legal name)
Street
903 S MAIN ST
mo-atcno other value
City
SAINT CHARLES 1 other
mo-atc
St Charles overture
State
MO
mo-atcno other value
ZIP
63301
mo-atcno other value
Pin
38.77480, -90.48476 map
overtureno other value
Phone
6369473883 1 other
vtinfo
3145503225 mo-atc
Licences
mo-atc MO|299450
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O26d0e0edeb5d; O3fcfbc880a1f; O3e3007ab271e

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-inbevMAGPIES
2523783
903 S MAIN ST, SAINT CHARLES, MO, 6330138.77459, -90.484862026-11-112026-11-12
mo-atcMAGPIE'S CAFE
legal name: BJP ENTERPRISES LLC
MO|299450
903 S MAIN ST, SAINT CHARLES, MO, 63301314550322538.77492, -90.484692026-11-032026-11-05
overtureMagpie's Cafe
a5c0e489-d960-4514-9fcb-e01361853841
903 S Main St, St Charles, MO, 63301636947388338.77480, -90.484762026-11-062026-11-06
vtinfoMAGPIES
21affd9ef381b51e
903 S MAIN ST, SAINT CHARLES, MO, 63301636947388338.77490, -90.484902026-11-132026-11-13

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 MAGPIESvtinfo MAGPIES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
mo-atc MAGPIE'S CAFEoverture Magpie's Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00 · phone: differs
ab-inbev MAGPIESmo-atc MAGPIE'S CAFE0.62same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.72 · same street + ZIP · pins 39 m apart · name similarity 0.62
ab-inbev MAGPIESoverture Magpie's Cafe0.62same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.72 · same street + ZIP · pins 25 m apart · name similarity 0.62
mo-atc MAGPIE'S CAFEvtinfo MAGPIES0.62same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.72 · same street + ZIP · pins 18 m apart · name similarity 0.62 · phone: differs
overture Magpie's Cafevtinfo MAGPIES0.62same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.72 · same street + ZIP · pins 16 m apart · name similarity 0.62 · phone: equal

Attributes

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

Trade area

Other outlets
130 within 1 mi · 396 within 3 mi
Off / on premise
18 / 79 within 1 mi · 83 / 188 within 3 mi
Selling alcohol
88 within 1 mi · 258 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (2,019 people per sq mi)
People within 3 mi
57,093 (44,445 adults 21+, 24,620 households) from 16 tract(s), tracts within 3 mi
Income
per capita $43,504 · median household ~$78,952 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 39%
Ethnicity
Hispanic 6% · White 80% · Black 7% · Asian 4%
Adults per alcohol outlet
172
Alcohol spend within 3 mi
$16,134,097 a year ($7,481,883 at home, $8,645,689 away) · $62,294 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-13 14:10insertoverture a5c0e489-d960-4514-9fcb-e01361853841 ↔ vtinfo 21affd9ef381b51esame address and namemerged15
2026-11-13 14:10insertmo-atc MO|299450 ↔ vtinfo 21affd9ef381b51esame address and namemerged15
2026-11-13 14:10insertab-inbev 2523783 ↔ vtinfo 21affd9ef381b51esame address and namemerged15
2026-11-12 17:29insertab-inbev 2523783 ↔ overture a5c0e489-d960-4514-9fcb-e01361853841same address and namemerged14
2026-11-12 17:29insertab-inbev 2523783 ↔ mo-atc MO|299450same address and namemerged14
2026-11-06 18:13insertmo-atc MO|299450 ↔ overture a5c0e489-d960-4514-9fcb-e01361853841same address and namemerged11