Saved query 64bc0184082c49bd

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

SELECT * 
FROM "parcel_layer" 
WHERE statefp = '18' 
  AND countyfp = '087'

27,841 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
44-02-35-300-013 000-009	18	087	E 410 N	HOWE	IN	46746	LaGrange	29538	Greenfield	970100	9701	50896.8300	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		270.7932	279.2077	275.4719	610	92412	GOVT STATE	RESTRICTED	V	PIGEON RIVER FISH AND WILDLIFE …	STATE CONSERVATION AREA	44009
44-02-34-300-000 009-009	18	087	E 400 N	HOWE	IN	46746	LaGrange	29538	Greenfield	970100	9701	1019.9129	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		266.7688	269.9914	268.6195	610	92412	GOVT STATE	RESTRICTED	V	PIGEON RIVER FISH AND WILDLIFE …	STATE CONSERVATION AREA	44009
44-08-12-300-002 000-016	18	087	1100 E	HOWE	IN	46746	LaGrange	72152	Springfield	970100	9701	80943.2273	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		282.7051	285.4286	283.4399	610	92412	GOVT STATE	RESTRICTED	V	PIGEON RIVER FISH AND WILDLIFE …	STATE CONSERVATION AREA	44016
44-07-01-200-006 000-001	18	087	300 N REAR	HOWE	IN	46746	LaGrange	05752	Bloomfield	970100	9701	9669.9182	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		271.8673	275.1592	274.0821	610	92412	GOVT STATE	RESTRICTED	V	PIGEON RIVER FISH AND WILDLIFE …	STATE CONSERVATION AREA	44001
44-10-32-300-020 013-010	18	087	7595 S 140 E	WOLCOTTVILLE	IN	46795	LaGrange	38718	Johnson	970600	9706	914.6726	1	18087C	2025-12-14	AE		901	273.7252	274.5711	274.2718	510							44010
44-10-24-300-070 021-010	18	087	S 550 E	WOLCOTTVILLE	IN	46795	LaGrange	38718	Johnson	970600	9706	581.5570	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		291.4949	293.5440	292.0820	599							44010
44-06-04-400-003 000-003	18	087	350 N	LAGRANGE	IN	46761	LaGrange	13132	Clay	970302	9703.0200	285069.9631	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		259.7882	263.1450	261.6515	100							44003
44-09-22-100-033 000-013	18	087	9315 E 535 S	WOLCOTTVILLE	IN	46795	LaGrange	49338	Milford	970700	9707	2492.7262	2	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		291.2374	294.9416	293.1013	511							44013
44-05-10-100-047 000-014	18	087	8530 W COUNTY ROAD 260 N	SHIPSHEWANA	IN	46565	LaGrange	52686	Newbury	970302	9703.0200	2630.1280	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		270.2216	271.7264	271.0757	511							44014
44-09-26-300-000 009-013	18	087	10395 E 665 S	WOLCOTTVILLE	IN	46795	LaGrange	49338	Milford	970700	9707	2511.9582	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		291.2413	300.6788	293.3913	510							44013
44-05-23-200-010 013-014	18	087	N 740 W	SHIPSHEWANA	IN	46565	LaGrange	52686	Newbury	970401	9704.0100	1181.7269	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		272.5441	273.3995	273.0215	500							44014
44-12-02-300-012 000-007	18	087	SR 5	TOPEKA	IN	46571	LaGrange	20206	Eden	970401	9704.0100	20146.6917	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		267.0877	268.3651	267.6561	100							44007
44-05-14-300-000 068-015	18	087	1600 E BERKSHIRE DRIVE	SHIPSHEWANA	IN	46565	LaGrange	52686	Newbury	970302	9703.0200	3983.1913	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		273.9762	275.3776	274.7237	510							44015
44-09-20-400-001 000-013	18	087	E 600 S	WOLCOTTVILLE	IN	46795	LaGrange	49338	Milford	970700	9707	10118.1113	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		304.7391	309.2258	307.3118	100							44013
44-02-31-300-004 000-012	18	087	4205 N STATE ROAD 9	HOWE	IN	46746	LaGrange	43722	Lima	970100	9701	2305.4134	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		265.7441	267.0764	266.5048	511							44012
44-05-11-300-000 012-015	18	087	225 S MORTON ST	SHIPSHEWANA	IN	46565	LaGrange	52686	Newbury	970302	9703.0200	2148.6726	2	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		271.7403	274.0538	273.1057	510							44015
44-09-26-400-030 017-013	18	087	10660 E 670 S	WOLCOTTVILLE	IN	46795	LaGrange	49338	Milford	970700	9707	1857.9247	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		301.6465	305.8428	304.4469	510							44013
44-03-26-200-001 019-012	18	087	600 N	HOWE	IN	46746	LaGrange	43722	Lima	970100	9701	3530.0272	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		262.0480	263.8883	262.9922	500							44012
44-03-27-300-020 001-012	18	087	5265 N 290 W	HOWE	IN	46746	LaGrange	43722	Lima	970100	9701	806.9515	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		256.6777	260.0084	258.9487	510							44012
44-02-31-200-002 068-012	18	087	HORSEY DORSEY DR	HOWE	IN	46746	LaGrange	43722	Lima	970100	9701	232.2335	0	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		265.1323	265.7578	265.5882	599							44012
44-11-31-100-001 051-006	18	087	303 S HARRISTON ST	TOPEKA	IN	46571	LaGrange	13456	Clearspring	970402	9704.0200	748.1252	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		283.3897	283.8649	283.5711	510							44006
44-09-22-200-010 030-013	18	087	5474 S 980 E	WOLCOTTVILLE	IN	46795	LaGrange	49338	Milford	970700	9707	732.0632	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		291.5573	300.9189	295.6536	510							44013
44-04-19-300-010 002-017	18	087	6155 N 1200 W	MIDDLEBURY	IN	46540	LaGrange	78506	Van Buren	970301	9703.0100	19784.3543	2	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		261.3544	269.9216	265.5915	510							44017
44-10-02-200-000 007-010	18	087	2270 S 460 E	LAGRANGE	IN	46761	LaGrange	38718	Johnson	970500	9705	764.6873	1	18087C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD		285.7769	289.5288	287.5211	510							44010
44-11-24-300-040 001-005	18	087	5865 S 075 W	WOLCOTTVILLE	IN	46795	LaGrange	13456	Clearspring	970600	9706	2149.2390	2	18087C	2025-12-14	AE		901	273.5277	275.5824	274.7165	510							44005