Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

35/80

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

8,734 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
007058270301900500020013210 W 1ST STKSHINKLE JASON DBROWN74875WALNUT48060048062258.1540111372.4349374.0503373.38631300RESIDENTIALPERSON72252S2715ES27 T2S R15EHACKS STEAK SHACKRESTAURANT2026.22024
007159320201400200020013723 W 10TH STKSKICKAPOO (KS) RESERVATIONBROWN33200HORTON4808004808697.473911308.8666309.6684309.22178000ABORIGINAL_LANDNONPROFIT4S3217ES32 T4S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
007159320200700200020013902 W 12TH STKSKICKAPOO (KS) RESERVATIONBROWN33200HORTON48080048084183.025211310.7234313.6375311.30258000ABORIGINAL_LANDNONPROFIT4S3217ES32 T4S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071092900000004010200131753 US 73RD HWYKSKICKAPOO (KS) RESERVATIONBROWN47200MISSION48080048086782.7411111341.5888345.3285343.4559NONPROFIT3S2917ES29 T3S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071593202012003000200130 7TH AVE WKSKICKAPOO (KS) RESERVATIONBROWN33200HORTON48080048082089.4918309.4867311.2869309.90178000ABORIGINAL_LANDNONPROFIT4S3217ES32 T4S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
007074200400501300020013901 N 6TH STKSNIGUS BRYCE P. & ALAYNA N.BROWN31675HIAWATHA48070048072063.6108211341.2589342.1532341.72011300RESIDENTIALPERSON2S2017ES20 T2S R17E2026.22024
007079290200301500020013306 N 8TH STKSHARTTER ELIJAHBROWN31675HIAWATHA4807004807278.7442111343.1367344.0262343.71841300RESIDENTIALPERSON2S2917ES29 T2S R17E2026.22024
007058340201401500020013415 S HIGH STKSBAUERLE HELEN R.BROWN74875WALNUT48060048062302.5967213373.1865374.1929373.67061300RESIDENTIALPERSON2S3415ES34 T2S R15E2026.22024
007149300000000300020013KSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN48060048061569194.5078302.2868339.3712316.37938000ABORIGINAL_LANDNONPROFIT4S3016ES30 T4S R16EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071151600000002000200131991 HAZELNUT RDKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN48060048065033.14373350.9685354.0065352.6935NONPROFIT3S1616ES16 T3S R16EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071093200000002000200131680 KINGFISHER RDKSKICKAPOO (KS) RESERVATIONBROWN47200MISSION4808004808634551.51943336.5975358.0726350.4601NONPROFIT3S3217ES32 T3S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
007169290101000400020013224 MAIN STKSSELF TIM R. & GAYLA J.BROWN75525WASHINGTON4808004808809.1866111348.6806350.0232349.5908PERSON4S2918ES29 T4S R18E2026.22024
007169290101300400020013409 MAIN STKSJ & M HOLDING COMPANY LLCBROWN75525WASHINGTON48080048081688.1837111351.4144351.7806351.6111BUSINESS4S2918ES29 T4S R18E2026.22024
007169290101100100020013317 CHESTNUT STKSBRUNING MADELYNBROWN75525WASHINGTON48080048081619.1574111350.1303351.7185350.9257PERSON4S2918ES29 T4S R18E2026.22024
007115160000000100020013200TH ST HAZELNUT RDKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN4806004806307878.3099344.7398359.4958351.7979NONPROFIT3S1616ES16 T3S R16EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071261300000004000200130 190TH STKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN4806004806326332.7542347.2573363.2000357.5121NONPROFIT3S1315ES13 T3S R15EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071141800000004000200130 FALCON RDKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN4806004806153654.3946348.1131359.6088354.7485NONPROFIT3S1816ES18 T3S R16EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0070610100000002020200131269 275TH STKSEUCHRE CREEK FARMS INC.BROWN29725HAMLIN4806004806635692.4548285.1963310.6424297.8953BUSINESS111112S116ES1 T2S R16EEUCHRE CREEK FARMSFARM2026.22024
0071261300000006000200130 FALCON RDKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN4806004806208939.5756345.7837359.5903354.2954NONPROFIT3S1315ES13 T3S R15EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
007114200000000300020013190TH ST FOXTAIL RDKSKICKAPOO (KS) RESERVATIONBROWN57375POWHATTAN4806004806635099.9091346.3764364.4556356.4194NONPROFIT3S2016ES20 T3S R16EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071521002017003000200130 VINE STKSKICKAPOO (KS) RESERVATIONBROWN47200MISSION48080048083194.6621345.9147348.0953347.0249NONPROFIT4S1017ES10 T4S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071041900000006000200130 KINGFISHER RDKSKICKAPOO (KS) RESERVATIONBROWN47200MISSION4808004808297749.3704326.8911349.9275343.0295NONPROFIT3S1917ES19 T3S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
007058340200900600020013210 W MAPLE STKSLOZANO JESUS A.BROWN74875WALNUT48060048061428.56203373.3757374.5987374.02781300RESIDENTIALPERSON2S3415ES34 T2S R15E2026.22024
0071092900000004020200130 170TH STKSKICKAPOO (KS) RESERVATIONBROWN47200MISSION480800480819271.5237344.6842350.7375348.4272NONPROFIT3S2917ES29 T3S R17EGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024
0071593201016005000200131201 3RD AVE WKSKICKAPOO (KS) RESERVATIONBROWN33200HORTON48080048082088.5346111322.8771327.1377325.5556NONPROFITGOVT TRIBALUNKNOWNNATIVE AMERICAN LAND AREA2026.22024