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 = '42' 
  AND countyfp = '119'

20,675 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
010-027-194.0000042119PAUNION49288MIFFLINBURG090300903892.6097211177.8338179.3608178.44671300RESIDENTIAL2026.22024
010-027-103.0000042119PAUNION49288MIFFLINBURG090300903639.1866111172.4766173.0937172.74681300RESIDENTIAL2026.22024
010-030-054.0000042119PAUNION49288MIFFLINBURG090300903714.8853111172.1501173.7568172.86181300RESIDENTIAL2026.22024
010-030-223.0000042119PAUNION49288MIFFLINBURG090300903717.0009311179.1574180.9191179.98721300RESIDENTIAL2026.22024
010-030-050.0000042119PAUNION49288MIFFLINBURG090300903460.6377212173.0294174.3715173.95471300RESIDENTIAL2026.22024
010-025-026.3000042119PAUNION49288MIFFLINBURG0903009032929.2631211190.6398216.6159200.29841300RESIDENTIAL2026.22024
010-030-199.0000042119PAUNION49288MIFFLINBURG090300903307.3605211177.6429179.0173178.27061300RESIDENTIAL2026.22024
007-100-195.0000042119PAUNION42960LEWIS090202902.020050105.2782311190.9404267.6049216.45442026.22024
011-020-092.1000042119PAUNION53200NEW BERLIN090400904685.9782111156.8503157.6692157.21992026.22024
011-021-002.0000042119PAUNION53200NEW BERLIN0904009041663.6550111167.0358169.0476167.83352026.22024
002-044-070.1300042119PAUNION20888EAST BUFFALO0906009061755.8479211150.7728159.4078156.85792026.22024
006-047-107.0000042119PAUNION39136KELLY090502905.02003275.2578411162.6577167.6476165.32862026.22024
011-020-031.0000042119PAUNION53200NEW BERLIN0904009041025.1964111164.9957167.2549165.47812026.22024
011-020-030.0000042119PAUNION53200NEW BERLIN090400904922.5417211165.1469167.3912166.19352026.22024
011-022-007.B000042119PAUNION53200NEW BERLIN0904009041482.3392111180.5415185.9360182.91412026.22024
002-034-172.0000042119PAUNION20888EAST BUFFALO090600906295.4381143.4910144.9499143.95711300RESIDENTIAL2026.22024
010-028-038.A000042119PAUNION49288MIFFLINBURG090300903583.3245170.0036170.5596170.30881300RESIDENTIAL2026.22024
010-029-042.C000042119PAUNION49288MIFFLINBURG090300903691.1182240.6151244.2368242.88921300RESIDENTIAL2026.22024
010-031-019.A000042119PAUNION49288MIFFLINBURG090300903925.9712172.7071173.5877173.32113100INDUSTRIAL2026.22024
010-028-118.0000042119PAUNION49288MIFFLINBURG0903009031208.2732178.6888180.0861179.20041300RESIDENTIAL2026.22024
42119PAUNION COUNTY GOVERNMENTUNION31480GREGG090102901.02001548.5311143.9932147.8468145.8066PERSONGOVT LOCALCLOSED446AGRICULTURAL EASEMENT2026.2
42119PAUNION COUNTY GOVERNMENTUNION43368LIMESTONE0904009042014.7860145.0908160.2541146.9544PERSONGOVT LOCALCLOSED359AGRICULTURAL EASEMENT2026.2
42119PAUNION COUNTY GOVERNMENTUNION43368LIMESTONE090400904189.8704159.3342160.6207159.8123PERSONGOVT LOCALCLOSED359AGRICULTURAL EASEMENT2026.2
42119PAUNION COUNTY GOVERNMENTUNION43368LIMESTONE090400904964.1883144.9404147.6977145.6296PERSONGOVT LOCALCLOSED359AGRICULTURAL EASEMENT2026.2
42119PAUNION COUNTY GOVERNMENTUNION10016BUFFALO090502905.02003291.5251170.4976179.9997175.5684PERSONGOVT LOCALCLOSED4623AGRICULTURAL EASEMENT2026.2