Saved query 9db141eb1c184a07

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 = '165'

12,749 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxdistrict
83-06-06-140-031 000-006	18	165	209 S EUGENE AVE	CAYUGA	IN	47928	Vermillion	21556	Eugene	020100	201	1338.5146	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	165.8978	166.8424	166.2713	510	83006
83-12-16-110-064 000-001	18	165	15113 MAIN ST	BLANFORD	IN	47831	Vermillion	13798	Clinton	020400	204	1950.8721	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	179.3451	180.8681	180.2494	510	83001
83-13-15-345-006 000-002	18	165	721 S 4TH	CLINTON	IN	47842	Vermillion	13798	Clinton	020500	205	630.9018	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	147.9432	148.9992	148.4981	510	83002
83-10-16-400-004 000-007	18	165	9731 S 275 E	HILLSDALE	IN	47854	Vermillion	32962	Helt	020200	202	3989.7720	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	186.0973	188.1331	187.0631	511	83007
83-12-13-320-010 000-001	18	165	762 W MONROE ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020400	204	2520.6071	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	179.7770	181.8049	180.7318	510	83001
83-08-26-130-053 000-008	18	165	130 MAPLE ST	DANA	IN	47847	Vermillion	32962	Helt	020200	202	602.9865	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	196.1741	196.6056	196.4111	429	83008
83-12-16-110-027 000-001	18	165	3032 W BLANFORD ST	BLANFORD	IN	47831	Vermillion	13798	Clinton	020400	204	650.6346	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	176.0975	177.1371	176.5709	510	83001
83-10-07-100-003 000-007	18	165	8142 S 75 E	HILLSDALE	IN	47854	Vermillion	32962	Helt	020200	202	107078.8738	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	184.7684	196.8911	194.3148	100	83007
83-13-16-111-046 000-002	18	165	328 N 9TH ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020500	205	3889.2883	1	18165C	2025-12-14	AE	FLOODWAY	147.2898	150.0125	149.0225	510	83002
83-13-08-420-010 002-001	18	165	1953 E PINSON ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020400	204	39585.4101	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	163.1940	178.7654	170.7179	590	83001
83-13-09-120-046 000-003	18	165	552 S GILBERT ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020300	203	2122.8368	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	151.1082	151.5379	151.2670	500	83003
83-11-34-330-002 000-007	18	165	12778 STATE RD 71	CLINTON	IN	47842	Vermillion	32962	Helt	020300	203	1394.1965	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	175.5006	176.5353	176.0191	510	83007
83-14-10-330-017 000-001	18	165	2931 SHIRLY ST	BLANFORD	IN	47831	Vermillion	13798	Clinton	020300	203	1748.3735	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	168.2176	174.0811	172.7430	510	83001
83-09-34-100-086 000-007	18	165	6140 S 360 E	HILLSDALE	IN	47854	Vermillion	32962	Helt	020200	202	1137.3124	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	179.1962	185.6389	183.9827	511	83007
83-08-26-240-008 000-008	18	165	246 HAWTHORNE ST	DANA	IN	47847	Vermillion	32962	Helt	020200	202	1202.0046	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	193.7703	194.3439	193.9099	510	83008
83-13-33-430-007 000-001	18	165	18829 S RHODES CIRCL	CLINTON	IN	47842	Vermillion	13798	Clinton	020400	204	1188.1864	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	150.1137	154.7615	153.9184	510	83001
83-13-15-310-043 000-002	18	165	406 S 4TH ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020500	205	1012.3226	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	152.1139	152.4540	152.2644	510	83002
83-02-05-430-005 000-009	18	165	2331 W US 136	COVINGTON	IN	47932	Vermillion	33520	Highland	020100	201	3710.0786	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	194.0461	195.0239	194.6831	510	83009
83-04-30-111-001 000-005	18	165	5685 N MAIN ST	CAYUGA	IN	47928	Vermillion	21556	Eugene	020100	201	2215.9871	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	154.2605	155.4019	154.6610	510	83005
83-13-09-410-016 000-002	18	165	1140 PIKE ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020500	205	750.7039	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	152.6212	153.6945	153.1865	510	83002
83-13-04-440-037 000-003	18	165	352 S TOWNE ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020300	203	3258.8043	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	152.0017	155.1570	153.1062	540	83003
83-12-13-130-003 000-001	18	165	15272 S PALMER ST	CLINTON	IN	47842	Vermillion	13798	Clinton	020300	203	1445.8818	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	185.8283	186.8059	186.3722	510	83001
83-10-03-300-004 002-007	18	165	7700 S OLD ST RD 63	HILLSDALE	IN	47854	Vermillion	32962	Helt	020200	202	4092.2483	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	175.7480	185.4477	183.3917	511	83007
83-08-26-240-090 000-008	18	165	101 SYCAMORE ST	DANA	IN	47847	Vermillion	32962	Helt	020200	202	901.6255	2	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	193.8627	194.3401	194.0930	590	83008
83-01-33-100-002 000-009	18	165	590 W DEPOT ST	PERRYSVILLE	IN	47974	Vermillion	33520	Highland	020100	201	4493.6418	1	18165C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	164.0990	166.1314	165.1334	511	83009