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

117,514 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
63-070-10442043230 SUE DRSWATARAPA17111DAUPHIN75672SWATARA022702227.0200286.395742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999129.6779132.0102131.23080.06006115MARIA WILSON MUSICSPECIALTY_SCHOOL
44-009-021420432923 RTE 25MIFFLINPA17061DAUPHIN49264MIFFLIN0251002514100.402142043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999197.7146202.0174199.54451.0200B&B AUTOMOTIVE SERVICESVEHICLE_SERVICE
26-013-0314204373 N MARKET STELIZABETHVILLEPA17023DAUPHIN23024ELIZABETHVILLE0252002521564.424842043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999196.7485197.7853197.18110.4000
29-001-014420431719 N RIVER RDHALIFAXPA17032DAUPHIN32040HALIFAX024802248.02004713.820742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999119.6960127.4173124.32271.1953
08-029-03642043109 ROYAL TERCITY OF HARRISBURGPA17103DAUPHIN32800HARRISBURG021200212329.047942043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999113.9008115.0104114.62210.0700
35-075-06142043998 PEIFFERS LNLOWER PAXTONPA17109DAUPHIN45056LOWER PAXTON022606226.06002306.028042043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999152.6048156.4232155.27580.5200
32-006-079420431305 TOURIST PARK RDJACKSONPA17032DAUPHIN37368JACKSON024801248.010038761.449842043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999204.9391211.0120208.779910.1370
34-035-00342043 LONDONDERRYPA17057DAUPHIN44464LONDONDERRY024001240.0100653.727042043C2025-12-21AEFLOODWAY-999984.871987.877586.33066
35-019-056420436814 BLUE RIDGE AVELOWER PAXTONPA17112DAUPHIN45056LOWER PAXTON022502225.02003392.890142043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999138.7849142.8002141.24840.8400
63-010-00142043430 N 45TH STSWATARAPA17111DAUPHIN75672SWATARA022701227.01001011.187942043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999146.9395151.0348149.09950.1600
43-009-19142043400 HOLLY DRMIDDLE PAXTONPA17018DAUPHIN49040MIDDLE PAXTON02470024722930.867842043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999117.0081147.3282131.90305.4600
35-063-17642043207 EASTWOOD DRLOWER PAXTONPA17109DAUPHIN45056LOWER PAXTON022601226.01001070.429342043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999141.4420152.7414150.47800.2600
35-003-031420432310 WILLIAMS VIEW DRLOWER PAXTONPA17112DAUPHIN45056LOWER PAXTON022501225.01004189.848142043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999230.8659242.3453236.36480.9900
54-004-0684204341 PAVERS COVE CTROYALTONPA17057DAUPHIN66560ROYALTON024001240.0100917.668942043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999105.6276112.4293109.59740.2300
37-007-00742043 MAIN ST LYKENS BOROPA17048DAUPHIN45592LYKENS025000250901.500542043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999212.6085216.9045214.97490.3200
63-074-037420438040 EVELYN STSWATARAPA17036DAUPHIN75672SWATARA022702227.02001813.859942043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999127.2391137.8266133.45360.4400
22-006-022420434192 ROUNDTOP RDCONEWAGOPA17022DAUPHIN15640CONEWAGO024002240.02002423.606542043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999194.4136200.7330198.51150.6200
55-007-01042043266 REINERS SCHOOL RDRUSHPA17980DAUPHIN66744RUSH0247002473151.538142043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999241.7000247.7368243.94140.7100
21-001-02742043 N PINE ST L3 BERRYSBURGPA17023DAUPHIN49264MIFFLIN02510025113700.193742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999205.3097210.5650207.36813.5100
34-012-003420433083 E HARRISBURG PIKELONDONDERRYPA17057DAUPHIN44464LONDONDERRY024001240.01001682.216742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999156.7747158.7778157.75870.3200
29-032-077420433544 PETERS MOUNTAIN RDHALIFAXPA17032DAUPHIN32040HALIFAX024802248.02001386.915142043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999192.1749193.7170193.05720.3400
29-021-0244204310 MATAMORAS RDHALIFAXPA17032DAUPHIN32040HALIFAX024802248.02004064.471542043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999172.7588181.1083176.21811.0700
25-024-02642043605 E CANAL RDEAST HANOVERPA17033DAUPHIN21208EAST HANOVER024502245.020052893.001742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999100.4270120.8859112.611413.2700
51-022-007420432615 HOFFER STPENBROOKPA17103DAUPHIN58712PENBROOK022200222821.539742043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999148.7811151.5693150.50750.1700
36-009-29742043560 CONSTITUTION DRLOWER SWATARAPA17057DAUPHIN45120LOWER SWATARA023602236.0200906.347542043C2025-12-21XAREA OF MINIMAL FLOOD HAZARD-9999129.1781131.8509130.71000.2300