Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

81/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '09'

1,261,914 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
2a24c7eb-2301-4f8c-917b-87970e6…09110CTCAPITOL02060AVON4622024622.020091332.340549.2889100.799365.12157212HAZEN PARKPARK2026.22024
09110CTCITY GOVERNMENTCAPITOL71390SOUTH WINDSOR48730048734334.88088.761313.480310.4856GOVERNMENTGOVT LOCALOPENVCOMMUNITY HALL (FORMER)LOCAL CONSERVATION AREA2026.2
09110CTUNKNOWNCAPITOL31240GLASTONBURY5202025202.020010753.0236191.3103212.8330205.6913UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
09110CTCITY GOVERNMENTCAPITOL37070HARTFORD50390050395325.838116.293516.803416.5766PERSONGOVT LOCALOPENCRONIN PARKLOCAL PARK2026.2
09110CTCITY GOVERNMENTCAPITOL44700MANCHESTER5141015141.0100586.0659101.9073105.4561102.8681GOVERNMENTGOVT LOCALOPENVOPEN SPACELOCAL CONSERVATION AREA2026.2
09110CTUNKNOWNCAPITOL44700MANCHESTER5142005142280.275438.973543.681141.5058UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
09110CTUNKNOWNCAPITOL44700MANCHESTER5142005142300.579536.335042.938940.1842UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
09110CTUNKNOWNCAPITOL44700MANCHESTER5142005142119.278332.595337.024835.1452UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
09110CTUNKNOWNCAPITOL44700MANCHESTER5151015151.0100260.689054.910958.155556.0859UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
09110CTUNKNOWNCAPITOL27600FARMINGTON4602034602.030013.920347.699247.714747.7074UNDETERMINEDGOVT UNKNOWNUNKNOWNOTHERUNKNOWNLOCAL OTHER OR UNKNOWN2026.2
93cda9fc-0476-42f2-818d-48ddb5b…09110CTCAPITOL45820MARLBOROUGH524100524144720.2633105.9429149.4365121.69422026.22024
d158d184-43f3-449b-95c1-9df8cba…09110CTCAPITOL32640GRANBY4681024681.0200103407.688554.2643113.138380.89152026.22024
29fe1866-efd3-47c9-8a62-6ee76f7…09110CTCAPITOL31240GLASTONBURY5202025202.020020452.1594185.3233222.7974202.51252026.22024
09110CTSTATE OF CONNECTICUTCAPITOL17800COVENTRY8502008502499.8959164.8164166.3078165.6165GOVERNMENTGOVT STATEOPENTHORNTON BROOK PRESERVE (MALON …CONSERVATION EASEMENT2026.2
bd791815-1683-4db2-94ee-d3cdf8b…09110CTCAPITOL68940SIMSBURY4661014661.01003707.950985.405087.306386.54622026.22024
0f1e30ec-6cae-46c2-b35e-0c5397a…09110CTCAPITOL25990ENFIELD524300524389698.081054.467855.693054.47202026.22024
09110CTSTATE OF CONNECTICUTCAPITOL74540SUFFIELD4771034771.030043.646949.004550.608749.9503GOVERNMENTGOVT STATEUNKNOWNMACKINNON PARCELUNKNOWN EASEMENT2026.2
09110CTCITY GOVERNMENTCAPITOL37070HARTFORD503000503083.329017.793618.097917.9569PERSONGOVT LOCALOPENPARK PLAYGROUNDLOCAL PARK2026.2
09110CTCITY GOVERNMENTCAPITOL37070HARTFORD504200504233.795515.376215.577015.4449PERSONGOVT LOCALOPENSPORT FIELD 30LOCAL RECREATION AREA2026.2
09110CTPRIVATECAPITOL44910MANSFIELD8815008815364.3507138.4995145.1307141.2692PERSONPRIVATEUNKNOWNUNKNOWNPRIVATE OTHER OR UNKNOWN2026.2
09110CTCITY GOVERNMENTCAPITOL37070HARTFORD503900503977.156630.785831.097730.9903PERSONGOVT LOCALOPENSPORT FIELDLOCAL RECREATION AREA2026.2
09110CTSTATE OF CONNECTICUTCAPITOL25360ELLINGTON5351015351.010079.5154108.7063109.4000108.9713GOVERNMENTGOVT STATECLOSEDKAMINSKIUNKNOWN EASEMENT2026.2
09110CTSTATE OF CONNECTICUTCAPITOL25360ELLINGTON5351015351.01001482.6587102.5358108.9660103.7319GOVERNMENTGOVT STATECLOSEDKAMINSKIUNKNOWN EASEMENT2026.2
10040610040609110 CTCAPITOL32640GRANBY4681014681.01004563.4104120.8191171.2696149.03292026.2
2675267509110 CTCAPITOL32640GRANBY4681014681.01008604.3068126.3511135.7539131.18432026.2