Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

39/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '18' 
  AND countyfp = '057'

147,476 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
290611000005000008180570 MORSE RESERVOIRINCICEROHAMILTON37044JACKSON1102021102.0200922372.36018246.6397258.3095246.7756870PERSON19N114ES11 T19N R4E2026.22024
291031103004000018180570 E 126TH STINHAMILTON13060CLAY1110071110.0700121.5880259.5872259.9373259.7466500CLAY TOWNSHIPPRIVATEOPENMOHAWK GOLF CLUBPRIVATE PARK2026.2
180572710 E 171ST STINCITY GOVERNMENTHAMILTON82714WESTFIELD WASHINGTON1105161105.160023529.9231261.0173274.1664265.9830PERSONGOVT LOCALOPENSIMON MOON PARK PHASE 1LOCAL PARK2026.2
1805721105 MACGREGOR PARK RDINSTATE OF INDIANAHAMILTON82714WESTFIELD WASHINGTON1105161105.1600126261.6345264.0975279.7729271.9591GOVERNMENTGOVT STATEUNKNOWNMACGREGOR PARK WETLAND MITIGATI…CONSERVATION EASEMENT2026.2
291307301006000018291307301006000018180574800 W 96TH STINHAMILTON13060CLAY1111031111.030011131.0086270.0692276.5578270.91564996216CLAY TOWNSHIPKRUSE CARPET RECYCLINGHOME_SERVICE2026.2
291307301002000018291307301002000018180574708 W 96TH STINHAMILTON13060CLAY1111031111.030014168.8876270.4342277.3527272.3139399CLAY TOWNSHIPIMI CONCRETEHARDWARE_HOME_AND_GARDEN_STORE2026.2
291307010001002018291307010001002018180574501 W 99TH STINHAMILTON13060CLAY1111031111.030024834.1539270.0756272.3440271.1869499CLAY TOWNSHIPDREYER & REINBOLD RACINGSPORT_TEAM2026.2
291307013003000018291307013003000018180579770 MAYFLOWER PARK DRINHAMILTON13060CLAY1111031111.030023648.1916269.7080272.7883271.0817480CLAY TOWNSHIPSOUTHEASTERN ALUMINUM PRODUCTS …SUPPLIER_OR_DISTRIBUTOR2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03004482.2294226.7196229.0999228.0637GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03003139.9443232.1772234.4365233.2151GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INCITY GOVERNMENTHAMILTON17488DELAWARE1108101108.1000110171.4811241.0574246.7331244.5257GOVERNMENTGOVT LOCALOPENVCHEENEY CREEK NATURAL AREALOCAL CONSERVATION AREA2026.2
18057INJOINTHAMILTON37044JACKSON1102011102.010011909.6403249.7942262.7070253.5549PERSONGOVT MULTIPLEOPENVBISHOP PARK CONSERVATION EASEME…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03004295.5522226.5837231.1948228.3835GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03005880.1878228.4674231.6980229.9334GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON54198NOBLESVILLE1105051105.0500108.8197231.7062240.1103234.7198GOVERNMENTGOVT STATEOPENVWHITE RIVER RESTORATIONSTATE CONSERVATION AREA2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03004087.7676226.9353229.6933228.1890GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03009251.2113231.1421234.2406232.8035GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.0300576.9114232.3152234.5977233.9210GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03008043.4823229.8030237.3751232.1715GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.0300611.5218229.8948230.6383230.1943GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03007252.2946232.8730235.4684233.9520GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
18057INSTATE OF INDIANAHAMILTON13060CLAY1110031110.03001667.2165232.2753234.0815233.6995GOVERNMENTGOVT STATEOPENVWATERSHED-BROOKSHIRE GOLF CONSE…CONSERVATION EASEMENT2026.2
291607000008401007180570 FLORIDA RDINHAMILTON22612FALL CREEK1108131108.13001357.1994250.3360259.2314256.6543501FALL CREEK TOWNSHIP2026.2
29102040705200001818057816 ARROWWOOD DRINHAMILTON13060CLAY1109041109.04001530.7553252.2683255.4574254.5183510CLAY TOWNSHIP2026.2
291020407020000018180571816 SPRUCE DRINHAMILTON13060CLAY1109041109.04001452.6655250.1726252.2844251.5404510CLAY TOWNSHIP2026.2