Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

41/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '55' 
  AND countyfp = '021'

44,154 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
{BD487FAD-A06E-4885-825E-B8DB11…55021WICOLUMBIA19375DEKORRA97070097074702.544821155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999236.8468243.6968238.93531300RESIDENTIAL2026.22024
{F0341885-A0B9-4F34-80DC-B7FA5A…55021WICOLUMBIA57025NEWPORT97030097033691.592911155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999304.9309306.8507305.70111300RESIDENTIAL2026.22024
{A47B92E4-D3F2-4216-947D-3A309C…55021WICOLUMBIA19375DEKORRA97090097091337.397511155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999250.2882253.0897251.86651300RESIDENTIAL2026.22024
{A25AC701-9BC7-4281-8087-3272B7…55021WICOLUMBIA57025NEWPORT97030097036107.807021155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999256.7935272.9480262.28731300RESIDENTIAL2026.22024
{C1DFF86D-67EF-451A-A813-8B9316…55021WICOLUMBIA02800ARLINGTON97090097092234.879211155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999318.4064319.7482319.18583100INDUSTRIAL2026.22024
{9BC76108-A09B-4609-8AF8-CCD83B…55021WICOLUMBIA64100PORTAGE9704019704.01004196.523911155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999240.6979249.5246245.84451300RESIDENTIAL2026.22024
{BF7A3A6B-6D9A-471A-9F3F-D8F9C4…55021W 6884 DRAKE RDWICOLUMBIA46050LOWVILLE9710009710162209.367621155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999266.5790278.0779269.88512026.22024
{28212374-7C71-4CFE-9A8E-916598…55021WICOLUMBIA43775LEWISTON9704019704.01003025.451111155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999242.3789244.2643243.49632026.22024
{229A94CB-836D-4DB4-BA27-E82028…55021WICOLUMBIA26725FORT WINNEBAGO970300970335048.868031155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999257.3465260.5825259.06832026.22024
{E8279F80-E251-40B2-A1D7-0BF6C7…55021WICOLUMBIA26875FOUNTAIN PRAIRIE9701009701162976.552231155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999273.4758297.4939282.56962026.22024
{4E2AA272-FC26-427D-9393-E7F763…55021WICOLUMBIA89325WYOCENA971000971049918.281131155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999263.5831267.0765264.66762026.22024
{AA7E136B-761A-4C83-B5E0-FF88D5…55021WICOLUMBIA32375HAMPDEN9711009711158058.448011255021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999275.7968287.2942279.46882026.22024
{4B400C26-9286-4E71-8EC7-D72DD6…55021WICOLUMBIA17325COURTLAND9701009701469.9447055021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999264.7832266.6481265.58093100INDUSTRIAL2026.22024
{BB395E8C-4F0E-4D65-9347-198B98…55021WICOLUMBIA89325WYOCENA9702009702150226.758521155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999242.9169258.6931247.14842026.22024
{E222B2BD-81BF-4334-A53C-28A037…55021WICOLUMBIA72250SCOTT97010097019407.915321255021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999271.1759279.9252277.38202026.22024
{D37F946D-888C-4B10-85B6-FA728E…55021WICOLUMBIA43775LEWISTON970300970318217.962611255021C2025-11-11X0.2 PCT ANNUAL CHANCE FLOOD HAZ…-9999240.2846243.3333241.94822026.22024
{CDE19625-24FE-44BE-8BF5-19B858…55021WICOLUMBIA32375HAMPDEN97110097117638.334721155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999296.9294300.7214299.47662026.22024
{3A157AAE-B939-4458-BDFF-2C2087…55021WICOLUMBIA11900CALEDONIA9706009706148668.538031155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999302.1260365.8514337.18722026.22024
{4777BA5D-3AFB-44B8-8AE5-EDF035…55021WICOLUMBIA49150MARCELLON970200970286036.757541155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999279.4214286.0871283.53372026.22024
{34B72FE5-32DF-45FD-95B7-30FFE5…55021WICOLUMBIA89325WYOCENA9702009702933.1516055021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999246.1869252.6531249.95151300RESIDENTIAL2026.22024
{40D51CDF-08E4-4AB9-AA1C-BB2488…55021WICOLUMBIA26875FOUNTAIN PRAIRIE971100971114009.567871155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999277.5180282.9590279.93882026.22024
{614B6F7A-F3ED-442F-BF9A-D0D07E…55021WICOLUMBIA02825ARLINGTON9709009709176577.1016055021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999303.9685324.7855308.04157240NATURE_RESERVE2026.22024
{E1F5F66B-FDBF-421B-905F-C0466F…55021WICOLUMBIA45375LODI9708009708980.6175055021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999248.1520249.1466248.39401300RESIDENTIAL2026.22024
{D326D1F7-0D3D-4655-BD34-34D268…55021WICOLUMBIA49150MARCELLON970200970220150.326021155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999278.1296296.6609283.79562026.22024
{60909C20-BCD4-4E07-8025-9A512F…55021WICOLUMBIA89325WYOCENA970200970219694.090911155021C2025-11-11XAREA OF MINIMAL FLOOD HAZARD-9999262.7722269.0115265.26532026.22024