Johnny Joe's

KRUM, TX 76249 · O018a9181509d · first seen 2026-11-02
3 sourcesoff premise · conveniencechain: Phillips 66alcohol: 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
Johnny Joe's 3 other
a licence name in capitals, cleaned (derived; record_title.py)
JOHNNY JOES ab-inbevoverture ×2
JOHNNY JOES NO 4 tx-tabc
KRUM AND CO. HILLS LLC tx-tabc (legal name)
Street
100 S 1ST ST 1 other
tx-tabc
100 S FIRST ST overture
City
Krum
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
76249
tx-tabcno other value
Pin
33.26135, -97.23864 map
overtureno other value
Phone
none
no other value
Licences
tx-tabc 107091991
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odeedaa6090c9; Of964423273f2

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-inbevJOHNNY JOES
2878167
100 S 1ST ST, KRUM, TX, 7624933.26095, -97.238572026-11-132026-11-13
overtureJOHNNY JOES
2538364a-080e-420f-afc1-f51d8e2062ee
100 S FIRST ST, KRUM, TX, 7624933.26135, -97.238642026-11-132026-11-13
tx-tabcJOHNNY JOES NO 4
legal name: KRUM AND CO. HILLS LLC
107091991
100 S 1ST ST, Krum, TX, 7624933.26154, -97.238262026-11-022026-11-16

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 JOHNNY JOESoverture JOHNNY JOES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
overture JOHNNY JOEStx-tabc JOHNNY JOES NO 41.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ab-inbev JOHNNY JOEStx-tabc JOHNNY JOES NO 40.79one name contains the other, same addressmergedjudge: None · pair_id: 519d232799cbebc02047 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise · convenience — overture-category
Chain
Phillips 66 — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
KRUM AND CO. HILLS LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — TX Retail/BQ
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
12 within 1 mi · 22 within 3 mi
Off / on premise
3 / 5 within 1 mi · 4 / 7 within 3 mi
Selling alcohol
8 within 1 mi · 16 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
rural (190 people per sq mi)
People within 3 mi
5,361 (3,807 adults 21+, 1,604 households) from 1 tract(s), tracts within 3 mi
Income
per capita $47,020 · median household ~$130,417 (weighted mean of tract medians)
Age and education
median age ~34.9 · bachelor's or higher 35%
Ethnicity
Hispanic 21% · White 84% · Black 0% · Asian 2%
Adults per alcohol outlet
224
Alcohol spend within 3 mi
$1,382,180 a year ($613,449 at home, $768,121 away) · $81,305 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:58insertoverture 2538364a-080e-420f-afc1-f51d8e2062ee ↔ tx-tabc 107091991same address and namemerged15
2026-11-16 14:56insertab-inbev 2878167 ↔ tx-tabc 107091991one name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 2878167 ↔ overture 2538364a-080e-420f-afc1-f51d8e2062eesame address and namemerged15