Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

50/80

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

52,659 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
039-01-034-25342097PAROHRBACH WILLIAM S/WENDY ANORTHUMBERLAND61832POINT0805008051355.599412700230001500012012-08-07111146.7407151.6482150.34641000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2405-1382405-1382026.22024
040-02-044-13742097PAIP4U LLCNORTHUMBERLAND63328RALPHO0808008081444.01261381032400170501484702014-02-19111179.2535180.6659179.98571000 - RES. - 3 OR LESS LIVING …BUSINESSBOOK 2532-6402532-6402026.22024
039-00-034-04042097PAREED JEFFREY A/JESSEEJAE SNORTHUMBERLAND61832POINT0805008052190.04819890176001165012015-12-02112153.6763159.4545157.48221000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2662-4242662-4242026.22024
019-00-085-026420973188 UPPER RDPATHOMAS SEAN DNORTHUMBERLAND82680WEST CAMERON0818008182332.33925590159007180530002018-03-1221288.4429294.9340292.09081000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2838-342838-342026.22024
008-00-060-03642097PAZLOCKI JEFFREYNORTHUMBERLAND51504MOUNT CARMEL080900809503.79627403100105012000-06-06212423.8565425.0262424.51109000 - MISCELLANEOUSPERSONBOOK 1290-5371290-5372026.22024
014-01-006-08442097PALYNCH JASON JNORTHUMBERLAND69600SHAMOKIN081600816174.4517508032005400200001997-12-18111224.1675226.2400225.11151000 - RES. - 3 OR LESS LIVING …PERSONBOOK 1135-8771135-8772026.22024
040-00-058-11242097PADOMBROSKI MICHAEL JNORTHUMBERLAND63328RALPHO0808008081802.751083202080010400350002001-09-2521225.9564230.3354227.91041000 - RES. - 3 OR LESS LIVING …PERSONBOOK 1381-7131381-7132026.22024
050-02-005-072420971019 EDISON AVEPASTETTS TRACY LNORTHUMBERLAND75304SUNBURY082000820171.9457518042005600410002012-05-2111134.9835135.6650135.37161000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2385-3852385-3852026.22024
00I-03-00I-2614209711 EAGLE AVEPAJKV HOUSING LLCNORTHUMBERLAND14536COAL081300813137.6797562033005950230002016-12-2111235.1363236.1829235.62161000 - RES. - 3 OR LESS LIVING …BUSINESSBOOK 2743-1512743-1512026.22024
004-02-001-13742097PABRITO ALBERTONORTHUMBERLAND51496MOUNT CARMEL081100811637.2312112801320012600200002021-04-1511318.1199335.9529329.30151000 - RES. - 3 OR LESS LIVING …PERSONBOOK 3080-183080-182026.22024
005-01-002-14642097PATROYAN MARY LOUISENORTHUMBERLAND51496MOUNT CARMEL081000810242.6902488032005200170001995-07-07112335.4546336.4900336.12171000 - RES. - 3 OR LESS LIVING …PERSONBOOK 1009-3891009-3892026.22024
006-02-003-28342097PAVIVINO SUZANNENORTHUMBERLAND51496MOUNT CARMEL081000810109.89580210021053002009-10-22111325.3347326.7783325.90922000 - LOTS (LESS THAN 10 ACRES)PERSONBOOK 2184-9182184-9182026.22024
006-01-003-20342097PAFENTY CHVONNORTHUMBERLAND51496MOUNT CARMEL081000810177.0903278022003000210002022-12-16111345.2502346.8634346.09631000 - RES. - 3 OR LESS LIVING …PERSONBOOK 3229-9793229-9792026.22024
004-01-001-22842097PASOSNOSKI LEONARDNORTHUMBERLAND51496MOUNT CARMEL081100811371.205855405100605016002018-07-10112319.1577319.8044319.40501000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2862-6342862-6342026.22024
004-02-001-34342097PAALDERSON THOMAS G/LAURANORTHUMBERLAND51496MOUNT CARMEL081100811544.4162280401060029100775002020-07-2011327.2378328.9282327.89661000 - RES. - 3 OR LESS LIVING …PERSONBOOK 3011-5053011-5052026.22024
050-01-005-05242097PABARR IRENE MNORTHUMBERLAND75304SUNBURY082000820545.1022104101290011700750002005-01-31212135.0579135.5915135.31671000 - RES. - 3 OR LESS LIVING …PERSONBOOK 1732-4981732-4982026.22024
021-00-010-027-B42097PABONNELL NIKITA MNORTHUMBERLAND18696DELAWARE0802008021608.36522315020500252002620002022-10-2521161.9965165.1413163.94101000 - RES. - 3 OR LESS LIVING …PERSONBOOK 3219-3593219-3592026.22024
00A-07-068-01742097PACHINOCONSTRUCTION LLCNORTHUMBERLAND14536COAL081200812308.1066376074004500300002023-02-1711263.0209278.9781269.14721000 - RES. - 3 OR LESS LIVING …BUSINESSBOOK 3240-8613240-8612026.22024
032-02-002-148-A42097PAWARBURTON DAVID W/JOAN ANORTHUMBERLAND50016MILTON080301803.0100344.5709340080004200340002015-10-2911149.8108153.5016152.02821000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2656-1552656-1552026.22024
059-00-097-10042097PAYOUNG GERALD RNORTHUMBERLAND81304WASHINGTON08230082369690.7893249303620028550212235.6773343.3175278.63385000 - AGRICULTURAL (10+ ACRES …PERSONBOOK 567-393567-3932026.22024
00I-02-00I-18442097PACORONEL SANTIAGO ARCADIO BNORTHUMBERLAND14536COAL081300813196.330034403600380012011-08-2611254.0691261.5809257.57881000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2328-882328-882026.22024
005-03-002-23942097PATIMMINS MICHAEL W/ABBIE JNORTHUMBERLAND51496MOUNT CARMEL081000810151.8237383027004100140001990-10-0511323.7557324.0753323.92421000 - RES. - 3 OR LESS LIVING …PERSONBOOK 795-751795-7512026.22024
006-01-003-17242097PAGROSS JOHN V JR/THERESA MNORTHUMBERLAND51496MOUNT CARMEL081000810206.1763487038005250360002008-02-0411339.1232340.7033340.10071000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2035-5122035-5122026.22024
004-02-001-12742097PAMENAPACE JONAS JNORTHUMBERLAND51496MOUNT CARMEL081100811450.9860699076007750300002008-07-1711317.8284334.7542327.99431000 - RES. - 3 OR LESS LIVING …PERSONBOOK 2077-7432077-7432026.22024
004-02-001-24442097PAHARLEM NOTES LLCNORTHUMBERLAND51496MOUNT CARMEL081100811479.4579101803720013900330002022-08-2511334.6719334.9497334.86562000 - LOTS (LESS THAN 10 ACRES)BUSINESSBOOK 3206-2283206-2282026.22024