Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL
SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '19' 
  AND countyfp = '079'

19,279 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
{3EC0A790-025E-49AB-8877-3CC7EE…19079IAO'CONNOR LARRY2111 250TH STHAMILTON91812HAMILTON9605009605152529.88291339.0996343.8778340.8038AGRICULTURALPERSON87N4SW25WSW 1/4S4 T87N R25W2026.22024
{E0EEB293-0527-4512-BBD8-44927F…19079IARISETTER RAE JEAN13886 260TH STHAMILTON92739LYON9602009602160502.2336316.7565331.6291320.2914AGRICULTURALPERSON87N24SE24WSE 1/4S24 T87N R24W2026.22024
{F0FC279A-E6C7-40FB-B2F6-462702…19079IASCHWANDT KEITH P & LISA A1831 UBBEN AVEHAMILTON93696ROSE GROVE9602009602158401.0543360.5348363.6765362.1402AGRICULTURALPERSON88N8NE23WNE 1/4S8 T88N R23W2026.22024
{15ED2712-1FFD-422B-95C9-6FCCA1…19079IAEVANS RICHARD ANDREW REVOCABLE…812 NOB HILL DR WESTHAMILTON93696ROSE GROVE9602009602159816.9395361.5194365.0379363.5497AGRICULTURALTRUST88N5SW23WSW 1/4S5 T88N R23W2026.22024
{6B1980BB-D3C5-4E26-92C7-427059…19079IASWENSON ROBERT L TRUST1413 PRAIRIE DRHAMILTON93696ROSE GROVE9602009602117869.0529355.5360363.4328359.4516AGRICULTURALTRUST88N19NW23WNW 1/4S19 T88N R23W2026.22024
{ADAB60C9-2730-4AF6-87C3-E2FC97…19079IALUHMAN MICHAEL D & LISA J JT R…22756 HIGHWAY S21HAMILTON93696ROSE GROVE9602009602151740.9676350.5730354.5839352.5444AGRICULTURALTRUST88N25SW23WSW 1/4S25 T88N R23W2026.22024
{D90F5F17-AF28-4F78-9406-A4ECEE…19079IAHP FAMILY FARMS HAMILTON LC510 S 17TH ST STE 104HAMILTON92739LYON960200960238362.7011316.9205326.1643321.4388AGRICULTURALBUSINESS87N34SE24WSE 1/4S34 T87N R24W2026.22024
{755CFEF6-059F-4B42-96DC-C5047A…19079IAHANSON DONALD E10581 620TH AVEHAMILTON93783SCOTT9602009602160828.6623341.3003348.5311345.7107AGRICULTURALPERSON86N36NE23WNE 1/4S36 T86N R23W2026.22024
{A490C927-CED9-44DB-B66C-C3D65F…19079IALARSON BRENT A & JODY IPO BOX 243HAMILTON93783SCOTT9602009602156648.4766306.7013317.0977308.7488AGRICULTURALPERSON86N29SW23WSW 1/4S29 T86N R23W2026.22024
{29F5848A-AC84-48F1-9DB1-03AF55…19079IALANE WOOD FARMS INC3165 360TH STHAMILTON93783SCOTT9602009602162799.7266330.9068341.1232337.2667AGRICULTURALBUSINESS86N9SE23WSE 1/4S9 T86N R23W2026.22024
{727F9B92-AB02-430A-B819-F6B426…19079IADOYLE DEAN A REVOCABLE TRUST450 SW 7TH ST UNIT 209HAMILTON92739LYON9602009602158326.3751322.1403328.6061325.8672AGRICULTURALTRUST87N26NE24WNE 1/4S26 T87N R24W2026.22024
{773709CD-A0BA-47C8-B70B-21D0F2…19079IABRS AG LLC2066 290TH STHAMILTON91812HAMILTON960500960582930.8902341.4057345.0066343.4586AGRICULTURALBUSINESS87N4SE25WSE 1/4S4 T87N R25W2026.22024
{5AC6088D-6D88-4F59-B551-A53C70…19079IAISVIK HOWARD C & LORI A2674 BRIGGS WOOD RDHAMILTON91812HAMILTON96020096023338.8996323.4487327.8545326.5494AGRICULTURALPERSON87N12NW25WNW 1/4S12 T87N R25W2026.22024
{D322FE00-EF6B-4DC5-89A4-CCA0EC…19079IAFURMAN FAMILY FARMS LLC2607 NORTHRIDGE PARKWAYHAMILTON91812HAMILTON9605009605151969.8531325.5375331.0722328.0371AGRICULTURALBUSINESS87N14NW25WNW 1/4S14 T87N R25W2026.22024
{7EBD603C-274B-4884-B41D-FBB736…19079IAVANDIEST FAMILY LLCPO BOX 610HAMILTON91812HAMILTON960500960581567.6589336.8151339.6771338.1864AGRICULTURALBUSINESS87N18SW25WSW 1/4S18 T87N R25W2026.22024
{78E6D9DB-8FF2-4284-835A-0F76A4…19079IAMERRILL HENKE FARMS LP40 RUE GRAND BLVDHAMILTON93696ROSE GROVE9602009602161230.5551350.7697354.2065352.3125AGRICULTURALBUSINESS88N34SE23WSE 1/4S34 T88N R23W2026.22024
{C4C362D2-2DEB-440D-A0C9-1924E8…19079IAPATTERSON ERIC C2550 230TH STHAMILTON92454LIBERTY9602009602158827.4807358.6669363.3386360.2657AGRICULTURALPERSON88N1SW24WSW 1/4S1 T88N R24W2026.22024
{071D8FD7-4955-4293-908D-40AA26…19079IACANFIELD RONNY LEE & FRANCINE …403 WHITE FOX DRHAMILTON91812HAMILTON9602009602150882.1095324.6982330.2264326.7991AGRICULTURALPERSON87N14SE25WSE 1/4S14 T87N R25W2026.22024
{C2F0E1F0-8839-4FAC-A420-87C0E9…19079IASCHWARZ FARM CORP8810 W CLARKE STHAMILTON91812HAMILTON960200960289735.6249321.1672324.8682322.0422AGRICULTURALBUSINESS87N13SE25WSE 1/4S13 T87N R25W2026.22024
{C6B2656A-54DB-4457-B379-15284A…19079IASHARER LARRY & DONNA2373 320TH STHAMILTON91812HAMILTON9605009605145921.8481329.1385334.7953331.1495AGRICULTURALPERSON87N23NW25WNW 1/4S23 T87N R25W2026.22024
{46B34979-2105-49DC-AB0F-134B02…19079IALONGNECKER LINDA L516 PARK STHAMILTON91812HAMILTON960200960288122.4274320.1464325.6561323.6384AGRICULTURALPERSON87N13NW25WNW 1/4S13 T87N R25W2026.22024
{6E99752A-B1D9-4EAF-BDC4-B56E9C…19079IAGROVES WILFRED A III & MARJORI…2995 NEELY AVENUEHAMILTON91812HAMILTON960500960512846.0916322.5873326.3530325.3970AGRICULTURALTRUST87N11SW25WSW 1/4S11 T87N R25W2026.22024
{802E7427-2918-447C-A4F4-A849AE…19079IAFONKEN BRIAN N & CYNTHIA C2840 NORTHWESTERN AVEHAMILTON91812HAMILTON960500960538069.8625336.8877341.0943338.0988AGRICULTURALPERSON87N8SE25WSE 1/4S8 T87N R25W2026.22024
{B1C3D572-C241-4E19-A667-97E103…19079IALONGNECKER LINDA L516 PARK STHAMILTON91812HAMILTON960200960216173.5580322.5724327.7644325.7612AGRICULTURALPERSON87N13SE25WSE 1/4S13 T87N R25W2026.22024
{73B53708-8DED-4EE6-9C7E-76C45F…19079IAFONKEN BRIAN N & CYNTHIA C2840 NORTHWESTERN AVEHAMILTON91812HAMILTON9605009605151212.8786337.3253343.9228340.1506AGRICULTURALPERSON87N8SE25WSE 1/4S8 T87N R25W2026.22024