Guys Deli & Pub

KANSAS CITY, MO 64153 · O5e02a7801038 · 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
Guys Deli & Pub 2 other
a licence name in capitals, cleaned (derived; record_title.py)
GUY'S DELI mo-atc
MILLER MARKETING AND DISTRIBUTION LLC mo-atc (legal name)
Street
1 KANSAS CITY BLVD BN2-030 1 other
mo-atc
1 KANSAS CITY BLVD STE BN2-030 ab-inbevvtinfo ×2
City
KANSAS CITY
mo-atcno other value
State
MO
mo-atcno other value
ZIP
64153
mo-atcno other value
Pin
39.29824, -94.71852 map 1 other
ab-inbev
3.0 km away vtinfo
Phone
9999999999 1 other
vtinfo
7033409873 mo-atc
Licences
mo-atc MO|304086
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe8f34a34e3de; O670c1d495436

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-inbevGUYS DELI & PUB
4621105
1 KANSAS CITY BLVD STE BN2-030, KANSAS CITY, MO, 6415339.29824, -94.718522026-11-132026-11-14
mo-atcGUY'S DELI
legal name: MILLER MARKETING AND DISTRIBUTION LLC
MO|304086
1 KANSAS CITY BLVD BN2-030, KANSAS CITY, MO, 6415370334098732026-11-032026-11-14
vtinfoGUYS DELI & PUB
bc9664f19eb77ab7
1 KANSAS CITY BLVD STE BN2-030, KANSAS CITY, MO, 64153999999999939.27760, -94.696202026-11-142026-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 GUYS DELI & PUBvtinfo GUYS DELI & PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2993 m apart · name similarity 1.00
ab-inbev GUYS DELI & PUBmo-atc GUY'S DELI0.74street written two waysmergedname Jaro-Winkler 0.94 · matched on zip · name similarity 0.74 · street similarity 0.80
mo-atc GUY'S DELIvtinfo GUYS DELI & PUB0.74street written two waysmergedname Jaro-Winkler 0.94 · matched on city · name similarity 0.74 · street similarity 0.80

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MILLER MARKETING AND DISTRIBUTION LLC — 2 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": []
}

Trade area

Other outlets
6 within 1 mi · 39 within 3 mi
Off / on premise
2 / 0 within 1 mi · 7 / 2 within 3 mi
Selling alcohol
5 within 1 mi · 33 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.49 mi
Setting
rural (219 people per sq mi)
People within 3 mi
6,201 (4,565 adults 21+, 2,685 households) from 2 tract(s), tracts within 3 mi
Income
per capita $40,204 · median household ~$75,368 (weighted mean of tract medians)
Age and education
median age ~36.7 · bachelor's or higher 46%
Ethnicity
Hispanic 14% · White 64% · Black 13% · Asian 4%
Adults per alcohol outlet
134
Alcohol spend within 3 mi
$1,727,807 a year ($816,704 at home, $910,236 away) · $50,818 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|304086 ↔ vtinfo bc9664f19eb77ab7street written two waysmerged15
2026-11-14 20:23insertab-inbev 4621105 ↔ vtinfo bc9664f19eb77ab7same address and namemerged15
2026-11-13 17:47insertab-inbev 4621105 ↔ mo-atc MO|304086street written two waysmerged15