Saved query c4c2a47f43f07871

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

22,328 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	naicscode	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
74-17-09-400-025 000-017	18	147	Cr 400 S	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	78191.2381		18147C	2025-12-14	AE	FLOODWAY	113.7353	117.7063	115.4485	100	9241	GOVT FEDERAL	CLOSED	V	EMERGENCY WATERSHED PROTECTION …	CONSERVATION EASEMENT	74017
74-15-22-401-040 001-018	18	147	815 Sycamore St	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	2201.5636	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	121.9891	122.6891	122.3290	420	45611				SHELDON'S EXPRESS PHARMACY	PHARMACY_AND_DRUG_STORE	74018
74-02-14-404-001 001-001	18	147	Cr 687 E	Dale	IN	47523	Spencer	10576	Carter	952702	9527.0200	13921.7733	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	158.7304	164.4438	160.9560	680	712190				MARIAH HILL PARK	PARK	74001
74-15-18-403-024 000-017	18	147	3434 W Sr 66	Rockport	IN	47635	Spencer	56160	Ohio	953000	9530	5706.6093	2	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	139.9401	142.6212	141.9914	442	6214				DEACONESS CLINIC - REO	PRIMARY_CARE_OR_GENERAL_CLINIC	74017
74-15-01-400-013 001-017	18	147	NEW BETHEL CHURCH	HAMMOND	IN	47635	Spencer	56160	Ohio	952800	9528	1332.3548		18147C	2025-12-14	AE		118.3495	119.5309	118.8629		4911	PRIVATE	RESTRICTED		AMERICAN ELECTRIC POWER - ROCKP…	PRIVATE OTHER OR UNKNOWN	74017
74-12-35-303-048 000-019	18	147	4065 N Sr 161	Richland	IN	47634	Spencer	45216	Luce	952900	9529	654.5454	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	119.0175	119.8378	119.3935	510							74019
74-15-29-400-030 001-017	18	147	2472 Cr 100 S	Rockport	IN	47635	Spencer	56160	Ohio	953000	9530	3922.0959	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	135.6137	137.9685	136.8601	541							74017
74-07-07-500-022 000-011	18	147	14606 N Huffman Mill Rd	Troy	IN	47588	Spencer	31990	Harrison	952701	9527.0100	6471.8784	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	123.2477	129.8375	127.2997	511							74011
74-05-01-203-002 000-005	18	147	30 Mistletoe Dr	Santa Claus	IN	47579	Spencer	13240	Clay	952701	9527.0100	2404.8875	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	135.2324	140.4254	137.3766	510							74005
74-05-01-402-007 000-005	18	147	326 E Madonna Dr	Santa Claus	IN	47579	Spencer	13240	Clay	952701	9527.0100	1415.5603	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	139.7971	144.1476	141.7424	510							74005
74-15-27-104-022 001-018	18	147	122 S Eighth St	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	1776.9622	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	122.3453	123.7491	123.1623	510							74018
74-01-13-203-029 000-011	18	147	13103 E Sr 62	Saint Meinrad	IN	47577	Spencer	31990	Harrison	952701	9527.0100	491.9951	2	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	127.3673	130.3788	129.0160	510							74011
74-11-12-203-112 000-007	18	147	32 Kennedy St	Chrisney	IN	47611	Spencer	28944	Grass	952900	9529	1918.5756	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	138.0933	141.7410	139.9466	510							74007
74-15-23-302-074 000-018	18	147	719 Vine St	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	682.9870	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	121.1978	121.8276	121.5297	510							74018
74-02-36-102-074 000-003	18	147	344 E Ashburn Rd	Santa Claus	IN	47579	Spencer	10576	Carter	952702	9527.0200	1485.8989	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	135.7292	139.0383	136.7613	510							74003
74-14-35-100-012 000-016	18	147	1210 S Cr 500 W	Rockport	IN	47635	Spencer	45216	Luce	953000	9530	27949.4511	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	127.0665	142.6927	133.5344	511							74016
74-02-17-402-024 000-002	18	147	217 E Medcalf St	Dale	IN	47523	Spencer	10576	Carter	952702	9527.0200	2150.8572	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	139.8349	140.7920	140.2471	541							74002
74-16-05-403-013 000-010	18	147	709 W Fourth St	Grandview	IN	47615	Spencer	31018	Hammond	952800	9528	1631.1038	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	120.7377	121.3620	121.0675	510							74010
74-11-11-404-007 000-007	18	147	917 Main St	Chrisney	IN	47611	Spencer	28944	Grass	952900	9529	8794.3935	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	142.2165	150.4306	147.4791	511							74007
74-04-01-200-010 000-015	18	147	15836 Sr 62	Gentryville	IN	47537	Spencer	37422	Jackson	952900	9529	34292.9745	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	124.8542	138.2107	130.3567	101							74015
74-15-27-401-041 000-018	18	147	346 S Lincoln St	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	1564.7546	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	128.6917	134.3465	132.8033	510							74018
74-16-05-402-004 000-010	18	147	635 W Eighth St	Grandview	IN	47615	Spencer	31018	Hammond	952800	9528	3709.6789	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	120.0315	120.6912	120.4886	510							74010
74-05-12-203-032 000-005	18	147	1104 S Melody Ln	Santa Claus	IN	47579	Spencer	13240	Clay	952701	9527.0100	1740.0010	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	156.3627	159.5754	158.9133	510							74005
74-15-22-401-027 000-018	18	147	814 Lincoln St	Rockport	IN	47635	Spencer	56160	Ohio	953100	9531	2684.5545	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	120.0890	122.3055	121.6776	511							74018
74-11-12-202-040 000-007	18	147	230 E Locust St	Chrisney	IN	47611	Spencer	28944	Grass	952900	9529	609.6391	1	18147C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	135.7103	140.7166	138.6889	510							74007