Saved query 7ffd0dd6b7b171b1

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 = '01' 
  AND countyfp = '037'

16,242 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	taxacres	naicscode	parceltype	accesstype	iucnclass	placename	placetype
99999999999999RD	01	037			AL	35046	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	25112.0488	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	102.2324	172.2612	151.4591	6.2056	712190	GOVT STATE	RESTRICTED	V	COOSA WILDLIFE MANAGEMENT AREA	STATE CONSERVATION AREA
99999999999999RD	01	037			AL	35136	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	30049.9921	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	145.4703	210.0363	184.5989	7.4250	712190	GOVT STATE	RESTRICTED	V	COOSA WILDLIFE MANAGEMENT AREA	STATE CONSERVATION AREA
1403080000001000	01	037			AL	35136	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	2541931.6648	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD				628.1161	8141	GOVT STATE	RESTRICTED	V	COOSA WILDLIFE MANAGEMENT AREA	PRIVATE CONSERVATION
1309300000013000	01	037	214 COUNTY ROAD 25	ROCKFORD	AL	35136	Coosa	92763	ROCKFORD	961200	9612	11740.4126	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	123.0726	138.5711	131.8183	2.9011
1701010000010000	01	037	5113 COUNTY ROAD 29	ROCKFORD	AL	35136	Coosa	92763	ROCKFORD	961200	9612	88641.5238	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	154.4137	173.6645	162.8627	21.9033
1601020000003004	01	037	517 DAYBREAK CURV	ROCKFORD	AL	35136	Coosa	92763	ROCKFORD	961200	9612	5779.7431	2	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	93.7898	111.1282	99.5940	1.4281
0102094002003000	01	037	GOODWATER ACADEMY	GOODWATER	AL	35072	Coosa	91350	GOODWATER-KELLYTON	961000	9610	17617.2103	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	230.6681	253.0968	240.1841	4.3529
0502040000003003	01	037	2483 LAKE ROAD	SYLACAUGA	AL	35151	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	3765.8358	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	119.5099	130.3912	124.9058	0.9305
1109310000016004	01	037	6594 STATE HIGHWAY 9	EQUALITY	AL	36026	Coosa	92763	ROCKFORD	961200	9612	5148.9135	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	217.8271	222.7603	220.3759	1.2722
1206230000001001	01	037	8300 STATE HIGHWAY 22	KELLYTON	AL	35089	Coosa	92763	ROCKFORD	961200	9612	878.9291	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	227.6024	231.1418	228.6318	0.2172
1309300000013001	01	037	19530 STATE HIGHWAY 22	ROCKFORD	AL	35136	Coosa	92763	ROCKFORD	961200	9612	78059.4640	3	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	116.3869	158.9489	134.0535	19.2881
1207360000017003	01	037	J D THOMPSON HIGH SCHOOL	HISSOP	AL	35089	Coosa	92763	ROCKFORD	961200	9612	2909.8136	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	219.4434	224.1682	222.3983	0.7190
0506130000011000	01	037	2 ACORN DR	SYLACAUGA	AL	35151	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	8296.3113	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	153.4283	165.6363	159.3506	2.0501
0302100000017000	01	037	97 HARDY LN	SYLACAUGA	AL	35151	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	4022.2026	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	215.2587	220.4417	218.4829	0.9938
1907360000003006	01	037	1398 COUNTY ROAD 98	EQUALITY	AL	36026	Coosa	92763	ROCKFORD	961200	9612	10144.8569	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	196.7281	203.3691	200.7085	2.5066
2104190000010000	01	037	158 MAPLE RIDGE DR	ALEXANDER CITY	AL	35010	Coosa	92763	ROCKFORD	961200	9612	2003.3232	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	146.5133	163.5074	156.2321	0.4949
1005150000027012	01	037	1840 COUNTY ROAD 50	KELLYTON	AL	35089	Coosa	91350	GOODWATER-KELLYTON	961000	9610	12219.8309	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	215.4423	220.7448	217.5428	3.0192
0302030000006002	01	037	445 WHITE ROCK ROAD	SYLACAUGA	AL	35151	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	5689.0717	2	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	216.6663	227.4913	223.0194	1.4056
0105154004002000	01	037	22395 STATE HIGHWAY 9	GOODWATER	AL	35072	Coosa	91350	GOODWATER-KELLYTON	961000	9610	4678.4335	2	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	247.7078	253.9910	250.7963	1.1558
1306134003012000	01	037	COOSA COUNTY HIGH SCHOOL	ROCKFORD	AL	35136	Coosa	92763	ROCKFORD	961200	9612	29046.0490	4	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	210.4211	221.2523	215.6771	7.1769
1006240000028001	01	037	163 COUNTY ROAD 126	KELLYTON	AL	35089	Coosa	91350	GOODWATER-KELLYTON	961000	9610	2845.7866	2	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	239.7807	244.5965	242.8586	0.7031
0603083002010000	01	037	315 STEEP LN	SYLACAUGA	AL	35151	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	4511.8060	1	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	119.4591	152.6232	133.2982	1.1149
0701010000003000	01	037	6746 COUNTY ROAD 56	WEOGUFKA	AL	35183	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	51694.6003	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	200.1784	213.8478	205.7003	12.7738
0304200000004001	01	037	1089 COUNTY ROAD 183	WEOGUFKA	AL	35183	Coosa	93429	WEOGUFKA-MARBLE VALLEY	961100	9611	71133.2241	2	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	191.9851	208.0682	198.0327	17.5768
1106140000042001	01	037	1503 STATE HIGHWAY 22	ALEXANDER CITY	AL	35010	Coosa	92763	ROCKFORD	961200	9612	3728.3055	0	01037C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	216.0242	224.7392	220.6817	0.9212