Saved query 698cf26a0e8bc454

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

37/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '17' 
  AND countyfp = '009'

5,608 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parcelstate	ownername	owneraddr	ownercity	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	numbldgs	numunits	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
07-05-000-400	1107276009	17	009	IL	SISTI NICHOLAS	3308 E CARPENTER ST	SPRINGFIELD IL 62702	BROWN	77733	VERSAILLES	970400	9704	1782.8126	19026	1036		1	1	17009C	2026-01-22	AE		132.3814	136.3527	134.0377	0040	0.4700	PERSON						2026.2	VERSAILLES
06-02-000-400	0417200002	17	009	IL	NEWTON FAMILY 1959 LLC	%NEWTON JUDITH	MOUNT STERLING IL 62353	BROWN	42561	LEE	970400	9704	328935.3623			25460			17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	215.1566	228.0137	223.2812	0021	80	BUSINESS						2026.2	LEE
	0732200002	17	009	IL				BROWN	16262	COOPERSTOWN	970400	9704	153448.0486						17009C	2026-01-22	AE		130.5326	141.7051	132.9019				GOVT SPECIAL DISTRICT	CLOSED	V	CREP 19990037	CONSERVATION EASEMENT	2026.2
	0819300004	17	009	IL				BROWN	09291	BUCKHORN	970400	9704	215161.9767						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	181.1260	219.8124	200.2427				GOVT STATE	RESTRICTED		SILOAM SPRINGS STATE PARK	STATE PARK	2026.2
	0517234024	17	009	IL				BROWN	51167	MOUNT STERLING	970500	9705	4056.9555						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	217.4004	218.6403	218.0702							BLUE RHINO PROPANE EXCHANGE	B2B_SUPPLIER_DISTRIBUTOR	2026.2
	0517203025	17	009	IL				BROWN	51167	MOUNT STERLING	970500	9705	254.1202						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	225.7144	226.3285	225.9553							JUST BREATHE	FITNESS_STUDIO	2026.2
	0913300002	17	009	IL				BROWN	23308	ELKHORN	970400	9704	160751.1792						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	150.5793	190.9684	170.7688									2026.2
	0508476007	17	009	IL				BROWN	51167	MOUNT STERLING	970500	9705	1157.0942						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	217.3301	220.1190	218.9519									2026.2
	0110200011	17	009	IL				BROWN	58330	PEA RIDGE	970400	9704	54861.9505						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	211.1050	216.1229	213.8451									2026.2
	1018400002	17	009	IL				BROWN	77733	VERSAILLES	970400	9704	7028.0216						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	177.4616	180.9376	179.6459									2026.2
	0404100001	17	009	IL				BROWN	42561	LEE	970400	9704	288015.1908						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	221.9178	229.8423	228.0206									2026.2
	1029300005	17	009	IL				BROWN	77733	VERSAILLES	970400	9704	10001.8910						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	178.8421	183.9041	182.7199									2026.2
	0530400003	17	009	IL				BROWN	51167	MOUNT STERLING	970400	9704	59631.8313						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	188.7316	212.5599	207.1464									2026.2
	0333330003	17	009	IL				BROWN	64187	RIPLEY	970400	9704	11094.8370						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	154.3048	174.2646	167.6147									2026.2
	0730200006	17	009	IL				BROWN	16262	COOPERSTOWN	970400	9704	97654.7785						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	163.1723	205.4285	184.6259									2026.2
	0909400015	17	009	IL				BROWN	23308	ELKHORN	970400	9704	172753.6172						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	160.7092	202.5166	180.3711									2026.2
	0108300004	17	009	IL				BROWN	58330	PEA RIDGE	970400	9704	174798.6835						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	191.5554	216.9760	208.9890									2026.2
	0517261002	17	009	IL				BROWN	51167	MOUNT STERLING	970500	9705	1281.5858						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	217.9988	219.3963	218.6167									2026.2
	0622426008	17	009	IL				BROWN	16262	COOPERSTOWN	970400	9704	1179.9066						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	193.8508	194.9225	194.3995									2026.2
	0517209009	17	009	IL				BROWN	51167	MOUNT STERLING	970500	9705	666.9465						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	220.9563	222.0389	221.5871									2026.2
	0511300004	17	009	IL				BROWN	51167	MOUNT STERLING	970400	9704	326067.0209						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	186.1924	204.3371	199.9157									2026.2
	0422200006	17	009	IL				BROWN	42561	LEE	970400	9704	166287.8550						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	216.4484	223.0515	221.2926									2026.2
	0128400012	17	009	IL				BROWN	58330	PEA RIDGE	970400	9704	37439.4040						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	220.6878	224.3995	223.6936									2026.2
	0632200005	17	009	IL				BROWN	16262	COOPERSTOWN	970400	9704	50602.4563						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	187.3863	201.0463	193.8521									2026.2
	0411100005	17	009	IL				BROWN	42561	LEE	970400	9704	11723.6219						17009C	2026-01-22	X	AREA OF MINIMAL FLOOD HAZARD	216.7534	224.4507	222.1463									2026.2