Saved query 2c0d3dc528d20cb0

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

34,885 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	placename	placetype	taxdistrict
19-10-29-200-008 001-013	18	037	EXHIBIT BUILDING 1	JACKSON	IN	47542	Dubois	36954	Jackson	953500	9535	8196.5953		18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	164.8881	177.3371	171.1048	620	7212	GOVT LOCAL	OPEN	DUBOIS COUNTY PARK	LOCAL PARK	19013
19-06-35-103-513 000-002	18	037	281 NEWTON STREET	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	2823.5717	2	18037C	2025-12-14	AE		138.8984	139.7812	139.4580	499	6216			KREMPP CONSTRUCTION	HOME_SERVICE	19002
19-08-35-102-111 000-009	18	037	860 N LAKEVIEW DR	CELESTINE	IN	47521	Dubois	30456	Hall	953600	9536	11070.3877	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	175.5059	196.5080	184.5523	510						19009
19-13-23-102-119 000-005	18	037	904 W MAIN ST	HOLLAND	IN	47541	Dubois	10684	Cass	953701	9537.0100	556.3305	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	153.4730	156.2430	155.0180	510						19005
19-13-14-400-143 000-004	18	037	HOLLAND OLD WATER SUPPLY DAM NU…	CASS	IN	47541	Dubois	10684	Cass	953701	9537.0100	3300.5380	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	150.0529	161.3588	157.5927	511						19004
19-06-20-200-015 010-016	18	037	ST. MARY'S PLAYGROUND	MADISON	IN	47546	Dubois	45954	Madison	953200	9532	8867.5628	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	137.5020	144.8790	141.4484	511						19016
19-06-15-101-203 000-002	18	037	4533 BADEN STRASSE	JASPER	IN	47546	Dubois	03124	Bainbridge	953301	9533.0100	950.6997	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	149.1498	150.2257	149.7996	510						19002
19-01-14-300-014 001-006	18	037	10349 E STATE ROAD 56	DUBOIS	IN	47527	Dubois	14608	Columbia	953600	9536	20588.3169	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	188.0988	213.8042	200.5906	101						19006
19-09-06-400-028 001-009	18	037	714 S CELESTINE RD S	CELESTINE	IN	47521	Dubois	30456	Hall	953600	9536	42450.4735	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	146.4637	183.5166	160.3567	512						19009
19-09-27-104-204 000-014	18	037	9930 E STATE ROAD 64	BIRDSEYE	IN	47513	Dubois	37926	Jefferson	953600	9536	670.1787	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	221.9109	225.5902	223.4756	510						19014
19-06-36-400-029 016-002	18	037	410 RUMBACH AVE	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	1410.0061	2	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	147.5939	149.6538	149.0032	520						19002
19-06-34-303-116 000-002	18	037	1574 W FIFTH AVE	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	1996.8033	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	147.8193	148.9536	148.3959	510						19002
19-06-23-302-616 000-002	18	037	BUEHLER PARK	JASPER	IN	47546	Dubois	03124	Bainbridge	953302	9533.0200	1059.5588	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	159.1826	161.1410	160.4056	510						19002
19-11-34-204-214 000-020	18	037	712 NORTH MAIN STREET	HUNTINGBURG	IN	47542	Dubois	58302	Patoka	953800	9538	700.0735	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	154.0291	155.4043	154.9103	510						19020
19-07-12-302-113 000-018	18	037	5234 E MAIN ST	DUBOIS	IN	47527	Dubois	46890	Marion	953500	9535	1535.9040	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	153.1617	155.4152	154.7080	511						19018
19-11-01-301-309 000-002	18	037	934 TERRACE AVE	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	894.3883	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	147.6446	150.4119	149.2015	510						19002
19-11-34-103-620 000-020	18	037	MAIN'S BAKERY	HUNTINGBURG	IN	47542	Dubois	58302	Patoka	953800	9538	374.2405	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	146.5290	148.7787	147.6320	640						19020
19-06-27-403-203 000-002	18	037	1285 W THIRTEENTH ST	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	19462.6464	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	152.1362	163.3026	156.0214	511						19002
19-14-28-300-026 000-004	18	037	10871 S UNITED STATES HWY UNIT …	HUNTINGBURG	IN	47542	Dubois	10684	Cass	953701	9537.0100	42819.7988	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	151.0344	166.2804	156.0666	512						19004
19-13-23-103-204 000-005	18	037	805 W JACKSON ST	HOLLAND	IN	47541	Dubois	10684	Cass	953701	9537.0100	1371.8052	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	153.2736	159.2718	156.2151	510						19005
19-10-29-100-058 000-013	18	037	1710 E COUNTY ROAD 420 S	HUNTINGBURG	IN	47542	Dubois	36954	Jackson	953500	9535	3668.6373	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	172.6501	178.4554	175.2307	511						19013
19-06-26-104-116 000-002	18	037	JASPER DOG PARK	JASPER	IN	47546	Dubois	03124	Bainbridge	953301	9533.0100	988.3367	2	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	162.3505	164.1035	163.2271	510						19002
19-06-27-403-205 000-002	18	037	1202 ST CHARLES ST	JASPER	IN	47546	Dubois	03124	Bainbridge	953400	9534	1391.0911	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	157.7958	161.8516	160.7652	511						19002
19-06-26-401-415 000-002	18	037	1300 DEWEY STREET	JASPER	IN	47546	Dubois	03124	Bainbridge	953302	9533.0200	433.4795	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	148.3480	149.4350	149.0779	510						19002
19-09-21-300-006 001-014	18	037	8070 E COUNTY ROAD 400 S	BIRDSEYE	IN	47513	Dubois	37926	Jefferson	953600	9536	41846.9703	1	18037C	2025-12-14	X	AREA OF MINIMAL FLOOD HAZARD	200.1597	223.0786	211.6584	101						19014