Saved query cf2dbd25e664db74

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

16,281 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
1604174018012001	01	065	NICK'S	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040401	404.0100	1222.4527	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	79.6853	81.1868	80.6750	0.3020	7225				NICKS	RESTAURANT
1604201000001000	01	065	THE CITIZEN'S BANK	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040401	404.0100	2382.9906	3	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	69.7076	74.5269	72.9681	0.5887					TOVASSO OUTLET	FOOD_AND_BEVERAGE_STORE
0305220000018000	01	065	MILLIANS CREEK		AL	35474	HALE	92259	MOUNDVILLE	040000	400	291079.9533		01065C	2026-01-23	A		35.2916	41.2717	38.5604	71.9182		GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT
1605163013001000	01	065	SOUTHERN ACADEMY	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040401	404.0100	18890.5369	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	83.1128	84.3352	83.7565	4.6673					SOUTHERN ACADEMY	PLACE_OF_LEARNING
2203080000002000	01	065			AL	36742	HALE	92345	NEWBERN	040500	405	43582.4154		01065C	2026-01-23	A		22.7149	28.9147	25.6100	10.7678		GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT
2203080000009000	01	065			AL	36742	HALE	92345	NEWBERN	040500	405	305558.1224		01065C	2026-01-23	A		22.9614	38.5147	28.6687	75.4951		GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT
0308270000035027	01	065	251 SERENITY VALLEY RD	MOUNDVILLE	AL	35474	HALE	93015	STEWART-AKRON	040100	401	20060.9685	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	56.9190	76.1272	65.5177	4.9563
0903070000002000	01	065	1965 COUNTY ROAD 86	GREENSBORO	AL	36744	HALE	91414	GREENSBORO NORTHEAST	040200	402	59790.8415	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	92.2229	116.2086	104.0925	14.7723
0301013005005000	01	065	MOUNDVILLE POST OFFICE	MOUNDVILLE	AL	35474	HALE	92259	MOUNDVILLE	040000	400	2613.9349	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	49.6911	50.3793	49.8911	0.6457
0506242006001000	01	065	AKRON PUBLIC SCHOOL	AKRON	AL	35441	HALE	93015	STEWART-AKRON	040100	401	673.4488	3	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	39.6362	40.2850	39.9337	0.1664
1009320000013014	01	065	BETHEL CHURCH	GREENSBORO	AL	36744	HALE	91414	GREENSBORO NORTHEAST	040200	402	4636.9140	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	95.3805	113.0116	108.7868	1.1457
1904200000009000	01	065	599 EATON QUARTERS RD	GREENSBORO	AL	36744	HALE	91415	GREENSBORO SOUTH	040401	404.0100	95574.7994	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	29.4863	32.5444	30.5205	23.6138
1206230000062000	01	065	19300 STATE HIGHWAY 14	SAWYERVILLE	AL	36776	HALE	92853	SAWYERVILLE	040300	403	7862.2925	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	57.1459	65.4230	61.0159	1.9424
1606230000012002	01	065	127 PERSIMMON RD	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040401	404.0100	12356.8497	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	82.7443	89.9041	88.5213	3.0529
1606140000007000	01	065	85 ORCHID RD	GREENSBORO	AL	36744	HALE	91414	GREENSBORO NORTHEAST	040200	402	15986.4780	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	86.8893	107.5443	100.5298	3.9495
1908330000028000	01	065	399 CASSIMORE RD	GREENSBORO	AL	36744	HALE	92345	NEWBERN	040500	405	8276.3947	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	41.4703	42.7545	42.3267	2.0448
1604173007008000	01	065	GREENWOOD	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040401	404.0100	1379.1762	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	77.6059	80.2795	78.9161	0.3407
1601110000004000	01	065	1388 UNION GROVE RD	GREENSBORO	AL	36744	HALE	91414	GREENSBORO NORTHEAST	040200	402	80894.4094	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	77.9210	103.9243	92.2055	19.9871
1601010000011000	01	065	7182 COUNTY ROAD 7	GREENSBORO	AL	36744	HALE	91414	GREENSBORO NORTHEAST	040200	402	114708.7784	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	62.9487	104.0378	84.0681	28.3415
1602090000034000	01	065	19962 STATE HIGHWAY 69	GREENSBORO	AL	36744	HALE	91413	GREENSBORO	040402	404.0200	2521.0640	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	72.2294	77.7500	75.5182	0.6229
1401010000008002	01	065	241 THRASHER RD	SAWYERVILLE	AL	36776	HALE	92853	SAWYERVILLE	040300	403	13900.2947	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	59.1039	64.5683	62.4325	3.4345
0203050000011001	01	065	264 COUNTY ROAD 67	MOUNDVILLE	AL	35474	HALE	92259	MOUNDVILLE	040000	400	4818.1131	1	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	74.1458	80.1462	77.0227	1.1905
0308340000002009	01	065	533 DAIRY FARM RD	MOUNDVILLE	AL	35474	HALE	93015	STEWART-AKRON	040100	401	10616.6349	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	56.9660	63.5708	59.5750	2.6232
0301011008005000	01	065	279 MARKET STREET	MOUNDVILLE	AL	35474-4043	HALE	92259	MOUNDVILLE	040000	400	1092.5143	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	50.3511	51.0224	50.6244	0.2699
1503050000005002	01	065	15195 STATE HIGHWAY 14	SAWYERVILLE	AL	36776	HALE	92853	SAWYERVILLE	040300	403	4043.8036	2	01065C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	68.4978	70.9579	69.4633	0.9991