Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '51' 
  AND countyfp = '740'

36,685 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
123300100001051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.01002846.93712020-04-01111980117234035155292026-01-08X0.2 PCT ANNUAL CHANCE FLOOD HAZ…1.63964.74732.552710100.73401 CHESAPEAKE EST SEC A B1013115080Forced Hot AirUNDETERMINEDFullBRICK WALLVINYL2026.2CHESAPEAKE ESTATES/LAKE FOREST
255401800025051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01002645.73812015-03-05112014231826035100342026-01-08AE8-0.31714.26432.270110100.654025 BRICKHOUSE FARMS948312361Forced Hot AirUNDETERMINEDFullCONCRETE SLABFACE BRICK2026.2BRICKHOUSE FARMS
195401800019051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01001749.24792012-09-19112012228094125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD0.35104.84604.353610100.432019 BRICKHOUSE FARMS88215061Forced Hot AirUNDETERMINEDFullCONCRETE SLABFACE BRICK2026.2BRICKHOUSE FARMS
5423300100054051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100900.93812019-10-31111980114823025155292026-01-08XAREA OF MINIMAL FLOOD HAZARD3.88615.09194.789710100.231054 CHESAPEAKE EST SEC A B10074420Forced Hot AirUNDETERMINEDFullBRICK WALLVINYL2026.2CHESAPEAKE ESTATES/LAKE FOREST
245401800024051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01002576.32222022-09-29112011228094125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.01614.46352.385710100.637024 BRICKHOUSE FARMS106052581Forced Hot AirUNDETERMINEDFullCONCRETE SLABFACE BRICK2026.2BRICKHOUSE FARMS
205401800020051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01005502.24162014-09-30112014224814125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.02634.79562.378610101.359020 BRICKHOUSE FARMS94355131Forced Hot AirUNDETERMINEDFullCONCRETE SLABSTONE2026.2BRICKHOUSE FARMS
215401800021051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01004335.25182019-12-26112013224814125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.15015.41792.897379181.072021 BRICKHOUSE FARMS100956151Forced Hot AirUNDETERMINEDFullCONCRETE SLABSTONE2026.2BRICKHOUSE FARMS
785400100078051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01002597.60412019-03-29111964118884025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.58634.19402.476610100.642078 SILVERWOOD SEC 199987061Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2SILVERWOOD, FARMVIEW AMENDED
5523300100055051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100961.62312011-08-05111980117233025155292026-01-08XAREA OF MINIMAL FLOOD HAZARD3.75525.00424.701710100.231055 CHESAPEAKE EST SEC A B84566451Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST
795400100079051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01003008.64782023-09-28111989117054025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.50074.32811.630010100.5430PT 79 SILVERWOOD SEC 110698481Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2SILVERWOOD, FARMVIEW AMENDED
805400100080051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01004094.02692021-05-17111968119644025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.42354.46872.066579181.006980 SILVERWOOD SEC 1103729381Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2SILVERWOOD, FARMVIEW AMENDED
4816300500048051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2128022128.020014034.1513111969220434125155292026-01-08AE9-0.89994.06850.242510103.460048 AHOY ACRES SEC 424744781Forced Hot AirUNDETERMINEDFullCINDER BLOCKVINYL2026.2AHOY ACRES, AHOY ACRES SOUTH
4823300100048051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.01001925.21512014-11-24111987126263225155292026-01-08XAREA OF MINIMAL FLOOD HAZARD4.35995.02424.745010100.492048 CHESAPEAKE EST SEC A B945112442Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST
5323300100053051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100917.39662024-11-26111980111703015155292026-01-08XAREA OF MINIMAL FLOOD HAZARD4.03805.06954.776410100.231053 CHESAPEAKE EST SEC A B1080710311Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST
815400100081051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01003173.15352013-06-18111963119554025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.37664.81002.183310100.778081 SILVERWOOD SEC 1W1644301Forced Hot AirUNDETERMINEDNoneBRICK WALL2026.2SILVERWOOD, FARMVIEW AMENDED
225401800022051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01005272.85292013-11-25112013231825035100342026-01-08AE8-0.50374.62312.619610101.303022 BRICKHOUSE FARMS92711471Forced Hot AirUNDETERMINEDFullCONCRETE SLAB2026.2BRICKHOUSE FARMS
235401800023051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01003768.49232014-07-31112014225164125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.35064.47981.997910100.931023 BRICKHOUSE FARMS94166681Forced Hot AirUNDETERMINEDFullCONCRETE SLAB2026.2BRICKHOUSE FARMS
825400100082051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01002809.17822024-06-12111967119923025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.34344.66472.279810100.688982 SILVERWOOD SEC 11075715471Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2SILVERWOOD, FARMVIEW AMENDED
5123300100051051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100903.89852025-01-03111980113923115155292026-01-08XAREA OF MINIMAL FLOOD HAZARD4.13425.00734.759710100.231051 CHESAPEAKE EST SEC A B2491120Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST
6123201200061051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.01006669.25472021-11-22112010234865035155292026-01-08XAREA OF MINIMAL FLOOD HAZARD1.63965.35933.202879181.648061 NASSAU104841061Forced Hot AirUNDETERMINEDFullCONCRETE SLAB2026.2NASSAU/CRYSTAL LAKE SOUTH
25500200002051740 1 VA23321PORTSMOUTH95123PORTSMOUTH2131012131.01001288.57402025-10-16111957115403025100342026-01-08XAREA OF MINIMAL FLOOD HAZARD5.09246.16265.487520100.32703 BLK A LAUREL PARK1090515551Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2POPLAR HILL FARM,CHURCHLAND PAR…
935400200093051740 1 VA23321PORTSMOUTH95123PORTSMOUTH3375.44702018-11-27111963119213125100342026-01-08XAREA OF MINIMAL FLOOD HAZARD-0.61234.38822.281010100.834093 SILVERWOOD SEC 29970681Forced Hot AirUNDETERMINEDFullBRICK WALLVINYL2026.2SILVERWOOD, FARMVIEW AMENDED
5223300100052051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100955.4724111980221604115155292026-01-08XAREA OF MINIMAL FLOOD HAZARD4.06974.96064.744510100.231052 CHESAPEAKE EST SEC A B19122790Forced Hot AirUNDETERMINEDFullCONCRETE2026.2CHESAPEAKE ESTATES/LAKE FOREST
5023300100050051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.01001010.4679111986119183025155292026-01-08XAREA OF MINIMAL FLOOD HAZARD4.24135.25534.864310100.231050 CHESAPEAKE EST SEC A B22234271Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST
5623300100056051740 1 VA23323PORTSMOUTH95123PORTSMOUTH2127012127.0100958.2757111980115663115155292026-01-08XAREA OF MINIMAL FLOOD HAZARD3.83485.01054.631110100.255056 CHESAPEAKE EST SEC A B3121920Forced Hot AirUNDETERMINEDFullBRICK WALL2026.2CHESAPEAKE ESTATES/LAKE FOREST