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 = '073'

52,371 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
{CA536C00-0936-4C5E-A8D1-BEE525…42073PA16101PAVLICH ALBERT ROBERT MARYLawrence70080SHENANGO011100111107384.0150042073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD7240NATURE_RESERVEPERSON3366GOVT STATERESTRICTEDOTHERSTATE GAME LAND 336STATE RESOURCE MANAGEMENT AREA2024
{0AC5DB56-5E0E-41BF-84E7-18DE4B…42073PA16117COMMONWEALTH OF PENNSYLVANIALawrence81776WAYNE011500115815813.6254042073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD7240NATURE_RESERVEGOVERNMENT4871GOVT STATERESTRICTEDOTHERSTATE GAME LAND 148STATE RESOURCE MANAGEMENT AREA2024
{1702DD91-69AB-4B7A-9251-C7A9CF…42073499 CARMEN BEATRICE BLVDELLWOOD CITYPA16117ELLWOOD CITY BORO PUBLIC SCHOOLLawrence23304ELLWOOD CITY0116001169988.1702442073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDGOVERNMENT61111GOVT LOCALRESTRICTEDEAST LINE AVENUE ATHLETIC COMPL…LOCAL RECREATION AREA2024
{3A6AFC16-6EED-4992-B64E-BDD9C2…420731300 W STATE STOAKWOODPA16101PALERMO F DOM ETALLawrence78368UNION010700107723.184711142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON44133API AUTOBODY PRODUCTSVEHICLE_PARTS_STORE2024
{5BBCFFD5-B695-4610-A8EB-BC6D1D…42073194 SHINGLE HOLLOW RDPAPA16037ROCCON ROBERTA M RAYMOND JLawrence59488PERRY01150011572876.495221142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD319.3724387.6321341.7485PERSON2024
{9EC1ED1D-7E86-47C5-AC75-02325C…42073530 KATHRYN STNEW WILMINGTONPA16142TOTO LEONARD J IILawrence54352NEW WILMINGTON010300103966.950711242073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD1300RESIDENTIALPERSON2024
{64BBE0D8-CD8C-41E2-9C8F-6AC0FA…42073302 BOSTON AVEOAKWOODPA16101LAWRENCE CO HABITAT FOR HUMANITYLawrence78368UNION010700107830.425731142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDNONPROFIT11412024
{5E5A0D3A-D6A7-4843-BB82-F1E4E3…42073321 E HAZELCROFT AVENEW CASTLEPA161054 U S PROPERTY LLCLawrence53368NEW CASTLE00010011030.5366242073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD1300RESIDENTIALBUSINESS5313122024
{DC0421AE-F52D-47A0-8455-AE99DC…42073338 E MOODY AVENEW CASTLEPA16105NEW FALLS CORPLawrence53368NEW CASTLE0003003816.234121142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDBUSINESS33252024
{BCDA5812-16F2-4A3C-A894-070FF7…42073412 JENNIE LANEUNIONPA16101PA AMERICAN WATER COLawrence78368UNION01060010611527.123511442073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDBUSINESS221312024
{01BA8085-4FC5-4ACB-A740-11027B…420731908 HIGHLAND AVENEW CASTLEPA16105R C B HOMES LLCLawrence53368NEW CASTLE00010011107.7471142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARD1300RESIDENTIALBUSINESS23612024
{35ED3A32-BB03-48BF-B41B-D7EDDE…42073807 HARBOR STNEW CASTLEPA16101CITY RESCUE MISSIONLawrence53368NEW CASTLE000400412751.927621142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDNONPROFIT48512024
{4BAAFBEE-9599-48FF-803D-63117F…42073207 BOSTON AVEOAKWOODPA16101COOK JANETTE F GREGORY FLawrence78368UNION010700107951.289411142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{E977F1A8-B302-4BA6-87EC-852B6F…420731150 EASTBROOKSCOTTPA16101RECKARD JEFFREY L NICOLA JLawrence68408SCOTT01010010142708.334821142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{76943841-104B-43BB-A4A0-35A067…420731138 BROOKSHIRE DRSHENANGOPA16101GRANT GARY M RITA MLawrence70080SHENANGO0110001103733.750611142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{A6C343DA-AD84-431F-AFE6-939B53…42073222 SETON DRPAPA16105AMUDI ABDULKADER S BETSY ALawrence53064NESHANNOCK010201102.01002828.530711142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{9D0036A1-2D7B-4B0A-9E81-EF554B…42073721 HARTZELL RDHICKORYPA16156TELESZ GREGORY T JILL RLawrence34248HICKORY010202102.020037625.235711142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{7D2821A0-8DA8-4EEC-9CE7-5B3A50…420731651 SHAW RDWASHINGTONPA16156HARRIS RICHARD CAROLINE SLawrence81272WASHINGTON0101001014680.371011142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{9FD15FEE-D6C9-47E9-8798-1681CB…42073112 E LAUREL AVENEW CASTLEPA16101PIRKKALA OLIVERLawrence53368NEW CASTLE0003003270.859311242073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{4CE6C54A-C3A5-4E6B-B13A-268161…42073929 TEMPLE AVENEW CASTLEPA16101TRUSHEL RUSSELL WLawrence53368NEW CASTLE0008008409.551221142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{451789A0-D633-4FA0-9AC8-1DA527…42073318 ZOCCOLI RDMAHONINGPA16116SIEGEL PAULLawrence46648MAHONING0105001054283.222821142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{3C91E9DA-F50D-4EBF-9ED1-12FCEF…420731723 E WASHINGTON STNEW CASTLEPA16101MCKAY JAMES LINDALawrence53368NEW CASTLE0008008439.355321142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{15A50CF3-D969-4E5A-9A62-34F6EF…42073637 JOHN STNEW CASTLEPA16101ANNARUMO LAWRENCE PAUL SHIRLEY DLawrence53368NEW CASTLE00020021344.197011142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{EB406245-159E-46CC-BCE0-4E201D…42073228 4TH STELLWOOD CITYPA16117FRANZE ROBERT A LOREEKAYLawrence23304ELLWOOD CITY011800118412.760711242073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024
{2C01EECE-E0A9-4917-9BDE-5B7169…42073302 WOOD STELLWOOD CITYPA16117MARSANO GARY L SYLVIA ALawrence23304ELLWOOD CITY011600116500.354811142073C2025-12-21XAREA OF MINIMAL FLOOD HAZARDPERSON2024