Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

34/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '20' 
  AND countyfp = '027'

7,777 matching parcels

Data Preview

parcelid
taxacctnum
statefp
countyfp
parceladdr
parcelcity
parcelstate
parcelzip
ownername
owneraddr
ownercity
ownerstate
ownerzip
countyname
cousubfp
cousubname
tractce
tractname
calcarea
imprvalue
landvalue
agvalue
totalvalue
saleamt
saledate
numbldgs
numunits
yearbuilt
numfloors
bldgsqft
bedrooms
halfbaths
fullbaths
firmid
firmdate
fldzone
zonesubty
staticbfe
elevmin
elevmax
elevavg
usecode
usedesc
zoningcode
zoningdesc
taxacres
ownertype
naicscode
legaldesc
township
section
qtrsection
range
plssdesc
book
page
parceltype
accesstype
iucnclass
placename
placetype
fireplaces
heating
heatfuel
cooling
foundation
roofcover
siding
lrversion
taxyear
taxdistrict
014103080300200900020027320 6TH STKSGT MFG INCCLAY13625CLAY CENTER458200458238436.68034363.8055365.9569364.74763100INDUSTRIALBUSINESS3331118S83ES8 T8S R3EG T MFG.2026.22024
014203080000000400020027537 CHEROKEE RDKSWARE GREGORY W & MICHELLE LCLAY12525CHAPMAN4581004581630943.4454211377.4274412.6972396.0618PERSON42451010S81ES8 T10S R1EMID KANSAS CO-OP - LONGFORD2026.22024
014203050000000200020027229 6TH RDKSKOPFER KELLAN F TRUSTKOPFER M…CLAY12525CHAPMAN45810045811205390.6166211380.9817413.7879399.3992TRUST10S51ES5 T10S R1EKOPFER FARMS, INC.2026.22024
0140842000000002010200272021 21ST RDKSANDERSON FARM LLCCLAY31825HIGHLAND458100458172022.4808811409.5617418.5718413.6436BUSINESS424917S204ES20 T7S R4EGYPSYHENFARMERS_MARKET2026.22024
0140783400000002000200271660 20TH RDKSANDERSON VERNON & SUSANCLAY30875HAYES4582004582289747.73802377.7443392.8256384.6181PERSON517311 5171107S343ES34 T7S R3ECENTURYLINK - CLAY CENTER AMP2026.22024
014085210200700300020027 KSMAYS LINDA D & ROLAND DCLAY31825HIGHLAND45810045811676.3519112423.0218424.4613423.69131300RESIDENTIALPERSON7S214ES21 T7S R4E2026.22024
014062040400600700020027205 ALLEN AVEKSPARRY CRAIG N TRUSTCLAY64850SHERMAN4581004581834.8925111375.5234375.7771375.67201300RESIDENTIALTRUST7S42ES4 T7S R2E2026.22024
014103070000000100020027610 C STKSCLAY CENTER CITY - PUBLIC UTILI…CLAY13625CLAY CENTER4582004582161754.08312359.1127368.2606364.8671UNDETERMINED8S73ES7 T8S R3ECLAY CENTER WATER TREATMENT PLA…2026.22024
014103080301500700020027507 BRIDGE STKSHOLLADAY MICHAEL & DEBORAHCLAY13625CLAY CENTER45820045821823.2025311364.6173364.9581364.78711300RESIDENTIALPERSON8S83ES8 T8S R3E2026.22024
014126130100800400020027207 VINCENTKSJESSE BOBBY & RONDACLAY23475FIVE CREEKS4581004581739.9580111387.0216388.0403387.55071300RESIDENTIALPERSON8S131ES13 T8S R1E2026.22024
0141030701003009000200270 CLARKE KSWILDER AUTO BODY INCCLAY13625CLAY CENTER458200458216806.1171362.3370366.8540365.1652BUSINESS8S73ES7 T8S R3EVALLEY FERTILIZER2026.22024
0140820300000009000200270 24TH RDKSSCHURLE BRYAN W & BRENDA C TRU…CLAY31825HIGHLAND4581004581642602.0261376.4441408.8366394.6404TRUST7S34ES3 T7S R4EFRIEDRICH REPAIR SHOP2026.22024
014194180000000201020027720 5TH RDKSHEIGELE ALAN P & SANDRA KCLAY02950ATHELSTANE45810045817970.5148311369.7631370.8829370.3013PERSON10S182ES18 T10S R2E2026.22024
0141852100000001020200270 PRAIRIE RDKSCASE VERNON & DELORES TRUSTCLAY26250GILL45810045811052860.5406395.8938412.8952406.6114TRUST8131110S213ES21 T10S R3EWESTERN WAY COWBOY CHURCHRELIGIOUS_ORGANIZATION2026.22024
014194180000000300020027723 4TH RDKSLILLEY CHARLES EUGENE & VIRGIN…CLAY02950ATHELSTANE4581004581927397.3679411362.7898381.6275372.9676TRUST10S182ES18 T10S R2E2026.22024
014173060100800203020027704 JUNIPER STKSTOBIN SCOTT ECLAY59025REPUBLICAN45810045811057.0624111384.4781385.5258385.2461PERSON10S64ES6 T10S R4E2026.22024
0141162300000001000200270 16TH RDKSKEEOTT FARMS INCCOTT RICHARDCLAY07050BLAINE45810045811626365.1228360.8418383.6481374.3006PERSON8S232ES23 T8S R2ETIMBER CREEK 32026.22024
014051120000000100020027669 23RD RDKST & S PETERSON FAMILY TRUSTCLAY07325BLOOM45810045812580419.7690388.9161420.0232403.5071TRUST7S121ES12 T7S R1ECLAY CO RWD 12026.22024
0140993100000006000200271953 13TH RDKSNANCE KIM N & PATRICIA ACLAY27500GRANT458100458147519.6032311366.4846381.1399373.5911PERSON8S314ES31 T8S R4E2026.22024
014103070100200100020027232 CLARKE STKSCRAIG LAUREN RCLAY13625CLAY CENTER45820045821137.77712366.0156366.7542366.35101300RESIDENTIALPERSON8S73ES7 T8S R3E2026.22024
014103080300700800020027639 MCBRATHNEYKSHARTLEY ELDON G JR & GLORIACLAY13625CLAY CENTER4582004582929.0047364.3202364.7962364.47191300RESIDENTIALPERSON8S83ES8 T8S R3E2026.22024
0140851600000006000200270 VALLEYVIEW RDKSLIPPERT JAMES M TRUSTLIPPERT …CLAY31825HIGHLAND4581004581318371.1179405.1286425.6635418.02858000FARMLANDTRUST7S164ES16 T7S R4E2026.22024
014062030300100400020027510 MAINKSHEDBERG DAVIDCLAY64850SHERMAN45810045811199.0180375.7969376.3016375.96341300RESIDENTIALPERSON7S32ES3 T7S R2E2026.22024
0141030504001006010200271305 HUNTRESS ST VACANTLOKSMANN BRAD A & KELLY RCLAY13650CLAY CENTER458200458214697.9352384.5523391.2645388.43161300RESIDENTIALPERSON8S53ES5 T8S R3E2026.22024
0141911100000002000200270 KIOWA RDKSMUGLER WALTER F & EVELYN J TRUSTCLAY02950ATHELSTANE4581004581631362.6009388.8092406.1708397.49338000FARMLANDTRUST10S112ES11 T10S R2E2026.22024