Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

46/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '42' 
  AND countyfp = '033'

69,999 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
00721612942033PALUCKY HAWK LLCPO BOX 229CLEARFIELD20136DUBOIS3303003303691.5728215004500026000350002019-03-073118902434.5385438.3091436.5078BUSINESS2 H G L0002026.22024
0061H102780003942033PAMCCLURE STEVEN316 RIDGE AVECLEARFIELD17840CURWENSVILLE3314023314.0200912.5993137003250016950450002023-01-031118801361.2236363.2418362.1240PERSONH G L 1380032026.22024
0044K082200001342033PAENGLE THOMAS G411 E CHERRY STCLEARFIELD14064CLEARFIELD3311003311518.8764141003500017600425002017-10-101119001345.1683348.5777346.6182PERSONH G L 202312749082026.22024
0110H163500001942033PASPADE IONA MPO BOX 83CLEARFIELD37192IRVONA3318003318646.2385185022500410012009-03-131101417.6089418.5028418.0340PERSONG L 1380022026.22024
0180A063060002742033PAPIERCE TIMOTHY M119 MAIN STCLEARFIELD77568TROUTVILLE3305003305670.9232136001700015300685002017-04-121119421462.5870465.4809463.8918PERSONH L 14 1/4 L 150012026.22024
0044K082480010042033PAKOUGHER CRYSTAL L1101 DOREY STCLEARFIELD14064CLEARFIELD3311003311734.41321480040500188501099002018-09-061119281347.7923350.0083349.1963PERSONH PART 2 L 11-12092026.22024
13009653142033PAJACOBSON ROUL DEAN & GERALDINE J89 6TH STCLEARFIELD86440WOODWARD33170033174669.336420000320002320011997-12-182119961479.4114484.7639482.7167PERSONH G 2 A 89 6TH ST0112026.22024
12309058342033PASMEAL TIM LARRY2204 GEORGE RDCLEARFIELD41952LAWRENCE33130033132606.7845-6850-33700-40550405502350002016-05-091119581373.2981377.1550375.3573PERSONH SHED L 20042026.22024
00721642242033PALOVE LYNN202 E PARK AVECLEARFIELD20136DUBOIS3303003303657.2051194504500023950730001995-01-112119001434.1948441.9070437.5760PERSON2 H L 60 202 E PARK AVE0002026.22024
00740839642033PAKIMBERLING NATHAN J320 OLIVE AVECLEARFIELD20136DUBOIS3303003303724.8773152003800019000686002005-02-171119001453.5488457.7865456.0008PERSONH L 106 320 OLIVE AVE0002026.22024
1240Q100000007642033PASHIMEL LYNN B1522 EMPIRE RDCLEARFIELD51056MORRIS33080033082420.204997502600012350150001986-12-04211920436.0981442.3420438.6725PERSONH G 0.59 A0042026.22024
1300M14384007.142033PAMOYER WILLIAM H & PAMELA J1299 DON STCLEARFIELD86440WOODWARD3317003317812.26416270032000659001100002005-09-02111999494.0919498.0747495.1933PERSONH 2.286 A 1299 DON ST0092026.22024
11209633842033PAMITCHELL JEFFREY R211 PHILIPS STCLEARFIELD18456DECATUR33090033092865.19525745039500614001000002002-01-07111967432.5630433.9103433.1821PERSONBLDGS 0.9021 A SURF0092026.22024
13007986942033PALUCAS DUSTIN168 JUNIATA AVECLEARFIELD86440WOODWARD33170033172153.6872133001500014800880002024-05-05110491.1799494.9356493.1033PERSONTRAILER BLDG SHED 0.5 A0112026.22024
0062I092960001442033PAHULLIHEN JAMES A401 BLOOMINGTON AVECLEARFIELD17840CURWENSVILLE3314023314.0200513.4871153503200018550480002011-09-16111910344.6471362.1677357.8993PERSONH 2 L 401 BLOOMINGTON AVE0082026.22024
12807649242033PAVAN TASSEL ROAD LLC67 HOOVER AVECLEARFIELD67792SANDY33010033013260.38808975025000011475015000002021-05-17112023448.4577451.8365450.6850BUSINESSH BLDG 73.24 A0272026.22024
12503790242033PALEE DOUGLAS E8472 MAHAFFEY GRAMPIAN HWYCLEARFIELD31376GREENWOOD33150033152396.374325800520003100050001999-07-01111980487.9918490.7287489.5525PERSONSAWMILL 4.944 A SURF0022026.22024
12208631442033PASNYDER JOSEPH M407 E 11TH STCLEARFIELD40296KNOX3316003316598.509145008000530030002024-12-05111900453.6843463.4950457.0538PERSONPAGE 006 BLOCK 473 LOT 000010062026.22024
12308589942033PACOUDRIET BETHANY R215 SMITH STCLEARFIELD41952LAWRENCE3313003313913.4505103502750013100440002009-07-16111900343.0830343.9787343.5269PERSONH L 13 215 SMITH ST0352026.22024
1230K082410002342033PAHEPBURN GARY L & DEBRA S206 SPRING STCLEARFIELD41952LAWRENCE33060033061823.858720350655002690012021-11-19111986412.5355417.4210415.2752PERSONH 1.248 A0362026.22024
11201968142033PADIXON DANIEL R & KAREN L478 OLD FORT RDCLEARFIELD18456DECATUR33090033098265.91335550250058006501989-08-25111999528.2031539.6047532.5533PERSONCAMP 2 A SURF 244 WINTERS RD0022026.22024
12208629842033PABYERS GARRY J1327 CLARK RDCLEARFIELD40296KNOX33160033162123.17121930025000218001025002007-07-01111960512.0104515.7844514.4700PERSONH 3.094 A 2020159072026.22024
0220A026640002842033PACLEARFIELD25136FALLS CREEK33010033012231.7155000001101439.4125441.6694440.41131300RESIDENTIALPAGE 022 BLOCK 664 LOT 000280222026.22024
1100S095330001942033PABASS ROBINPO BOX 248CLEARFIELD16040COOPER330800330822.62777500485001235012001-07-26111904424.0874424.5972424.4436PERSONH SHED 4 L 267-269-271-273 PART…0152026.22024
1120N130000007942033PAST LOUIS JOSHUA M601 MARTINS RDCLEARFIELD18456DECATUR33090033092272.53340500501050002018-05-160502.0704505.5954503.38551401PERSONPAGE 006 BLOCK 000 LOT 000790062026.22024