General Hardware Liquor

SEDGWICK, KS 67135 · O33bfb8bff507 · first seen 2026-11-03
2 sourcesoff premise · liquor_storealcohol: 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
General Hardware Liquor 2 other
a licence name in capitals, cleaned (derived; record_title.py)
GENERAL HARDWARE LIQUOR LLC ttb (legal name)
THE HARDWARE STORE ttb
Street
410 N COMMERCIAL AVE 1 other
ttb
410 N COMMERCIAL ab-inbev
City
SEDGWICK
ttbno other value
State
KS
ttbno other value
ZIP
67135
ttbno other value
Pin
37.91680, -97.42436 map 1 other
ab-inbev
95 m away ttb
Phone
none
no other value
Licences
ttb KS-P-21466
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O39a72b24a5dd

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-inbevGENERAL HARDWARE LIQUOR
4974472
410 N COMMERCIAL, SEDGWICK, KS, 6713537.91680, -97.424362026-11-182026-11-18
ttbTHE HARDWARE STORE
legal name: GENERAL HARDWARE LIQUOR LLC
KS-P-21466
410 N COMMERCIAL AVE, SEDGWICK, KS, 6713537.91595, -97.424442026-11-032026-11-05

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 GENERAL HARDWARE LIQUORttb THE HARDWARE STORE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 95 m apart · name similarity 1.00 · street similarity 0.86

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GENERAL HARDWARE LIQUOR LLC — 1 outlets in the master under this operator
Licence privileges
none
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
4 within 1 mi · 4 within 3 mi
Off / on premise
2 / 0 within 1 mi · 2 / 0 within 3 mi
Selling alcohol
1 within 1 mi · 1 within 3 mi
Nearest
same channel none within 3 mi · licensed none within 3 mi
Setting
rural (none people per sq mi)
People within 3 mi
4,434 (3,224 adults 21+, 1,690 households) from 1 tract(s), the nearest tract
Income
per capita $44,563 · median household ~$85,227 (weighted mean of tract medians)
Age and education
median age ~45.8 · bachelor's or higher 38%
Ethnicity
Hispanic 8% · White 91% · Black 1% · Asian 1%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$1,167,744 a year ($537,496 at home, $629,794 away) · none 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:58insertab-inbev 4974472 ↔ ttb KS-P-21466street written two waysmerged15