Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

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

14,914 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
20059100 E CENTRAL AVEKSKANSAS DEPT OF WILDLIFE & PARKSFRANKLIN59700RICHMOND95450095455952.9063112309.8325312.2607311.02651300RESIDENTIALGOVERNMENT19S1319ES13 T19S R19E2026.22024
030118280200800200020059310 E 3RD STKSKINGMAN OIL LLCFRANKLIN16900CUTLER95450095451349.4212272.7159273.7786273.1933BUSINESS17S2821ES28 T17S R21E2026.22024
030087250401200400020059535 N BIRCHKSBRUCE LLCFRANKLIN53550OTTAWA9542009542618.7600111276.7679279.8229278.2509BUSINESS2026.22024
20059200 PRINCE STKSKANSAS DEPT OF WILDLIFE & PARKSFRANKLIN52350OHIO954500954518307.6461291.6581296.6281294.90337240STATE_PARKGOVERNMENT18S1419ES14 T18S R19EPRAIRIE SPIRIT RAIL TRAIL - PRI…2026.22024
200591627 CALIFORNIA RDKSSTRANGE JOSEPH L & JOYCE MFRANKLIN79325WILLIAMSBURG9541019541.0100485933.2524211344.9339352.0950349.2116PERSON18S718ES7 T18S R18E2026.22024
20059469 OLD US 50TH HWYKSSHORT DEE D & VICKIE LOUFRANKLIN79325WILLIAMSBURG954500954580995.8876211310.1948334.9630318.6657PERSON18S1317ES13 T18S R17E2026.22024
200591404 COLORADO RDKSREEKIE CHRIS C & LILA JFRANKLIN79325WILLIAMSBURG9545009545645024.0373311334.9002354.5179349.4008PERSON18S1818ES18 T18S R18E2026.22024
200591981 STAFFORD RDKSNELSON GLEN W & PEGGY E TRUSTSFRANKLIN12475CENTROPOLIS9541019541.0100269957.0144311290.1628310.1262302.2644TRUST15S2919ES29 T15S R19E2026.22024
200594591 COLORADO RDKSWRAY BEN W & LEAH RFRANKLIN02075APPANOOSE9541019541.0100629714.23254303.0254324.9030318.53448000FARMLANDPERSON15S2918ES29 T15S R18E2026.22024
200592090 VIRGINIA RDKSSTEVENSON KENDALL AFRANKLIN16900CUTLER9545009545151985.8149111264.4192276.5143269.8824PERSON17S3321ES33 T17S R21E2026.22024
0301951500000003030200591487 OHIO RDKSFRANKLIN16900CUTLER954500954515080.9658298.1456304.2535301.441818S1520ES15 T18S R20E2026.22024
200592224 OSBORNE TERKSSUNDSTROM FARMSFRANKLIN53575OTTAWA9542009542279071.6788266.2352273.4498272.03768000FARMLANDPERSON16S3319ES33 T16S R19E2026.22024
200593730 SHAWNEE RDKSHUBBEL RHONDA DAY & URBAN DIA…FRANKLIN24375FRANKLIN9541029541.0200150129.5093282.1604289.7392287.04268000FARMLANDPERSON16S220ES2 T16S R20E2026.22024
200592890 FLORIDA RDKSGARROW NANCY LFRANKLIN28750GREENWOOD9541019541.0100452109.2692272.0471280.1920278.66738000FARMLANDPERSON17S918ES9 T17S R18E2026.22024
20059307 LABETTE RDKSSUNDSTROM HARRY P & LYLE W & R…FRANKLIN28750GREENWOOD9541019541.010039101.6733273.3114282.8748280.49508000FARMLANDTRUST17S1217ES12 T17S R17E2026.22024
200593555 NEVADA RDKSRUMFORD RAYMOND GENE & LINDA L…FRANKLIN53575OTTAWA9541029541.020050457.4296271.9362274.6856273.54648000FARMLANDTRUST16S2120ES21 T16S R20E2026.22024
200592855 SHAWNEE RDKSSEYLER EDWARD DEAN & MERNA LFRANKLIN30925HAYES9541029541.0200227907.0167279.7545287.0508283.31248000FARMLANDPERSON15S3619ES36 T15S R19E2026.22024
200594564 JOHN BROWN DRKSROBERTS JAMES VFRANKLIN16900CUTLER9545009545152849.445511275.8925297.0069282.1737PERSON18S1621ES16 T18S R21E2026.22024
200594339 HAMILTON TERKSSAVAGE JUDITH A TRUSTFRANKLIN16900CUTLER9545009545322717.34542312.0602327.6514321.3580TRUST18S521ES5 T18S R21E2026.22024
200592407 OSBORNE TERKSD & G AVIATION LCFRANKLIN53575OTTAWA954200954237233.20224270.9394277.2128273.6437BUSINESS16S2719ES27 T16S R19E2026.22024
030151110000000500020059KSFRANKLIN28750GREENWOOD9541019541.01001598.3607276.0243284.5721280.587417S1117ES11 T17S R17E2026.22024
20059194 OHIO TERKSKRATZBERG CARL J & CHERYL LFRANKLIN59700RICHMOND9545009545508543.83661285.9348324.7037314.5282PERSON19S1520ES15 T19S R20E2026.22024
030199300000000403020059949 US-59 HWYKSMOYER RODNEY & KIRSTENFRANKLIN52350OHIO954500954550111.66422298.3241303.0356300.7518PERSON2026.22024
200593180 SAND CREEK RDKSRUMFORD RAYMOND GENE & LINDA L…FRANKLIN53575OTTAWA9541029541.02001075355.67801268.4018285.1783276.7552TRUST16S2020ES20 T16S R20E2026.22024
20059993 HAMILTON RDKSRANSOM MARY V TRUSTFRANKLIN33000HOMEWOOD9545009545570039.92358337.8300350.7857346.5917TRUST18S418ES4 T18S R18E2026.22024