Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

44/80

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

59,474 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
3400-03942039PACRAWFORD48360MEADVILLE111500111592233.8753120373.9663425.1281401.88721300RESIDENTIAL7212HILLCREST PARKPARK2026.22024
1103-04542039PACRAWFORD03408ATHENS1109001109405877.97462369.1300397.3594379.41058000FARMLAND2026.22024
6603-014-142039PACRAWFORD81736WAYNE11130011138860.6160111461.4560466.4305462.92832026.22024
5003-04142039PACRAWFORD72704SPARTANSBURG11010011012017.7618111445.6737446.7618446.34242026.22024
5006-02042039PACRAWFORD72704SPARTANSBURG11010011011615.1923211437.4328444.3632441.40602026.22024
4103-00442039PACRAWFORD64600RICHMOND1108001108481685.6558411361.7319394.1378369.65882026.22024
6603-03842039PACRAWFORD81736WAYNE1113001113387819.5864211392.9299450.8721412.45392026.22024
6605-029-542039PACRAWFORD81736WAYNE1113001113342998.2287212341.4294406.4111361.56302026.22024
1101-03242039PACRAWFORD03408ATHENS1109001109381387.9246359.8977386.0653366.87758000FARMLAND2026.22024
2019-02642039PACRAWFORD15760CONNEAUTVILLE1103001103686.19761111300RESIDENTIAL2026.22024
42039PAUNKNOWNCRAWFORD64600RICHMOND110800110891823.7871429.2121437.6941433.0075UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERSTATE GAME LAND #200STATE OTHER OR UNKNOWN2026.2
42039PANON-GOVERNMENTAL ORGANIZATIONCRAWFORD76904TITUSVILLE11110011112949.2428364.3073373.8898366.2971PERSONNGOOPENVWESTERN PENNSYLVANIA CONSERVANC…CONSERVATION EASEMENT2026.2
42039PANON-GOVERNMENTAL ORGANIZATIONCRAWFORD65440ROCKDALE1102021102.0200397.7730345.1978346.8362346.2074PERSONNGOOPENVWESTERN PENNSYLVANIA CONSERVANC…CONSERVATION EASEMENT2026.2
2209-02042039PACRAWFORD17848CUSSEWAGO1102011102.0100422128.93192332.3442345.9747338.21252026.22024
LITTLE SUGAR CREEK420395705 SHAFFER RDPACRAWFORD81736WAYNE1113001113204730.9750321.9725363.6898347.44332026.22024
6401-00542039PACRAWFORD79912VENANGO1102011102.01001161.32201346.7314347.6223347.16042026.22024
42039PAUNKNOWNCRAWFORD79912VENANGO1102011102.0100139.0330341.1883341.2684341.2364UNDETERMINEDGOVT UNKNOWNOPENVVENANGO RIFFLE NATURAL AREAPRIVATE CONSERVATION2026.2
4912-044-342039PACRAWFORD72688SPARTA1101001101191069.97705400.9021416.4451408.87372026.22024
42039PAUNITED STATES NATURAL RESOURCES…CRAWFORD10904CAMBRIDGE1102021102.02006.3486343.7371343.7376343.7374GOVERNMENTGOVT FEDERALOPENOTHERWESTERN PENNSYLVANIA CONSERVANC…CONSERVATION EASEMENT2026.2
1205-02942039PACRAWFORD04720BEAVER1103001103227451.18631112026.22024
3901-003-2342039PACRAWFORD60312PINE1104001104835.05012122026.22024
4403-007-542039PACRAWFORD67088SADSBURY1105021105.0200500.56901112026.22024
1909-03842039PACRAWFORD15728CONNEAUT11040011047425.67861112026.22024
1910-011-142039PACRAWFORD15728CONNEAUT110400110440252.04081112026.22024
3003-01142039PACRAWFORD43656LINESVILLE11040011041232.07022112026.22024