Data Explorer

Query the US Nationwide Parcel Dataset

Request Sample Download

$1.75 / 1,000 records$100 minimum

0/80

Live SQL
SELECT * 
FROM "parcel_layer" 
WHERE statefp = '42' 
  AND countyfp = '031'

26,243 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
taxyear
taxdistrict
50135904203163 N JEFFERSON PLCLARIONPA16214UNITED STATES FOREST SERVICECLARION PA 16214CLARION13800CLARION1606001606494.34061910013100204102014-07-11111446.1047448.1580447.1810GOVERNMENTBOOK 2014 PAGE 239920142399GOVT FEDERALRESTRICTEDVCLARION, PENNSYLVANIA WILD AND …WILD AND SCENIC RIVER2024
1233000242031474 PENNY LNPA16214UNITED STATES FOREST SERVICESHIPPENVILLE PA 16254CLARION34456HIGHLAND1602021602.0200175566.06494242030960455162013-11-1111332.5508435.0051402.8248GOVERNMENTBOOK 2013 PAGE 486620134866GOVT FEDERALRESTRICTEDVCLARION, PENNSYLVANIA WILD AND …WILD AND SCENIC RIVER2024
16002600420311460 MCCLUNE RD BUILDINGPA16242RITZERT MATTHEW P & JULIE DEMLENTON PA 16373CLARION43344LIMESTONE1609001609456870.82051678165560233372009-06-2621404.5970475.5061430.9681PERSONBOOK 789 PAGE 383789383RITZERT MINE2024
200538042031CLARION RIVER NEAR PINEYPINEYPA16254UNITED STATES FOREST SERVICESYRACUSE NY 13202CLARION57536PAINT1603001603106985.7750085008502013-08-22306.6704408.7825361.0309GOVERNMENTBOOK 0 PAGE 000GOVT FEDERALRESTRICTEDVCLARION, PENNSYLVANIA WILD AND …WILD AND SCENIC RIVER2024
500375042031823 MERLE RDCLARIONPA16214BILAL AHMADCLARION PA 16214CLARION13800CLARION1606001606403.650150402230072702022-07-15111449.8673451.0559450.4555PERSONBOOK 2022 PAGE 2531202225312024
2700285042031374 ACME STMADISONPA16248SLEASE N DEAN & WENDY MCKAYRIMERSBURG PA 16248CLARION64904RIMERSBURG1607021607.02001018.4548897017600107301994-11-23111464.9742465.3331465.1171PERSONBOOK 430 PAGE 115643011562024
2700404042031887 MAIN STTOBYPA16248HORNBERGER MCKENNA RRIMERSBURG PA 16248CLARION64904RIMERSBURG1607021607.0200878.11624610860054702021-12-01111432.2615441.5852438.6098PERSONBOOK 2021 PAGE 5415202154152024
509700042031266 GREENVILLE AVECLARIONPA16214SHINGLEDECKER MARK A & PATRICIA…CLARION PA 16214CLARION13800CLARION16060016065016.02263298316740346572016-10-17211423.1688429.6878426.3487PERSONBOOK 2016 PAGE 3863201638632024
11001020420313943 MAPLE STHAWTHORNPA16230CORNMAN JOHN D JRHAWTHORN PA 16230CLARION33216HAWTHORN16090016092246.9408106808600115402024-08-07111337.8304340.6287339.1925PERSONBOOK 2024 PAGE 2310202423102024
1200056042031 MIOLA ROAD PA16214MAXWELL RICHARD LCLARION PA 16214CLARION34456HIGHLAND1602021602.02001061010.53300135000135002000-02-19334.6968479.1488443.2928PERSONBOOK 529 PAGE 582529582DEANNA AND ROBERT SINTOBIN2024
1304007042031512 MAPLE STKNOXPA16232RENFREW JOHN L ET UXKNOX PA 16232CLARION40272KNOX1604001604492.13251051010600115701978-12-29111413.6617416.3704415.1977PERSONBOOK 260 PAGE 9502609502024
3000295042031427 COLERAIN STSLIGOPA16255KRIEBEL JENNIFER & BRIANSLIGO PA 16255CLARION71176SLIGO16050016051171.771185701350099202018-08-16111355.6466361.5516358.3971PERSONBOOK 2018 PAGE 2781201827812024
1008702142031PA16233LEWIS EUGENELEEPER PA 16233CLARION25272FARMINGTON1601011601.01003980.9035070007002014-11-18111466.0130470.9586468.0636PERSONBOOK 2014 PAGE 443620144436COYOTE LODGELODGING2024
1006005442031PA16233STATE OF PENNSYLVANIAALLISON PARK PA 15101CLARION25272FARMINGTON1601011601.01007761.531401010010102022-10-05428.4622463.5371442.1217GOVERNMENTBOOK 2023 PAGE 7892023789GOVT STATERESTRICTEDOTHERCOOK FOREST STATE PARKSTATE PARK2024
5002070420311227 E MAIN STCLARIONPA16214CLARIT REALTYBRADENTON FL 34202CLARION13800CLARION16060016061429.663147730249000726302002-12-06111441.2629443.2322442.4238BUSINESSBOOK 597 PAGE 8205978202024
3000183042031402 COLERAIN STSLIGOPA16255WILE MICHAEL L & JUDY ASLIGO PA 16255CLARION71176SLIGO16050016051201.0151975013100110602002-04-08211352.0491354.3553353.2377PERSONBOOK 577 PAGE 8465778462024
3000040042031337 MADISON STSLIGOPA16255LAWRENCE DONALD R ET UXSLIGO PA 16255CLARION71176SLIGO16050016051221.0605930950018801980-08-01211359.3525361.1690360.2955PERSONBOOK 270 PAGE 9562709562024
3300743042031 PA16049FRY THOMAS F & PATRICIA EBUTLER PA 16001CLARION76928TOBY1607021607.02005260.26523201180015002024-08-21212253.6608273.6831265.7987PERSONBOOK 2024 PAGE 2616202426162024
190840054203162 APPLEWOOD VALLEY DRPA16214CONTICELLI JOSEPH C & ASHLEY KCLARION PA 16214CLARION50464MONROE16080016081800.16393754013700389102013-06-06111427.9840435.2539432.0416PERSONBOOK 2013 PAGE 2218201322182024
30002810420311635 BALD EAGLE STSLIGOPA16255SLIGO CHAPELSLIGO PA 16255CLARION71176SLIGO16050016051274.82304346012700447301998-02-0111356.3935358.5906357.7505NONPROFITBOOK 485 PAGE 8194858192024
13002230420311027 W RAILROAD STKNOXPA16232KIMES KARLENE A ET ALKNOX PA 16232CLARION40272KNOX16040016041610.54041802024400204602023-01-1611452.1416458.7600454.8743PERSONBOOK 2023 PAGE 69520236952024
1609400442031503 KAHLE RDPA15864BERRYHILL MCKAYLA MARIE ET ALSUMMERVILLE PA 15864CLARION43344LIMESTONE16090016097747.63342444417060261502020-08-28211463.4917474.4091467.7792PERSONBOOK 2020 PAGE 2985202029852024
24000390420314540 RTE 861PA16248CORLE DEBBIE A & RICKY ERIMERSBURG PA 16248CLARION62144PORTER16080016086918.93961179417000134942000-07-21211442.9150450.7887448.0288PERSONBOOK 538 PAGE 9035389032024
340035504203118164 RTE 208PA16334JANNAZZO RUDOLPH PMARBLE PA 16334CLARION81208WASHINGTON1602011602.01001531.75591425012800155301999-03-19211471.8966475.9163474.1725PERSONBOOK 509 PAGE 5145095142024
25002040420319797 RTE 28PA15864DADIC DEBRA ANN ET ALBELLEVILLE NJ 07109CLARION63728REDBANK16090016098340.61861518015000166801997-05-04111384.0733388.0289385.5551PERSONBOOK 471 PAGE 45471452024