Saved query aca2f7312c354903

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '01' 
  AND countyfp = '001'

32,444 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parcelstate	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	taxacres	placename	placetype	lrversion
21020400000020230	161504	01	001	AL	AUTAUGA	92628	PRATTVILLE	020801	208.0100	11018.2360	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	78.2133	83.3548	80.5649	500	2.7228	SOUTHERN POWER PLANT HARRIS	PUBLIC_UTILITY	2026.2
19021020060010000	171610	01	001	AL	AUTAUGA	92628	PRATTVILLE	020300	203	4134.3983	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	95.4248	107.8563	105.7408	500	1.0217	CORNER PACKAGE STORE \| LIQUOR S…	FOOD_AND_BEVERAGE_STORE	2026.2
10072500000120110	181625	01	001	AL	AUTAUGA	92628	PRATTVILLE	020805	208.0500	29783.6041	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	144.1743	148.9732	146.3016	500	7.3234	WELLSPRING COMMUNITY CHURCH	CHRISTIAN_PLACE_OF_WORSHIP	2026.2
10073500000040030	181635	01	001	AL	AUTAUGA	92628	PRATTVILLE	020804	208.0400	254564.8753	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	130.6593	163.1663	149.7429	500	62.9090	EAST MEMORIAL BAPTIST CHURCH	FAMILY_SERVICE	2026.2
10041700000080000		01	001	AL	AUTAUGA	92628	PRATTVILLE	020803	208.0300	162740.2066	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	107.5369	144.4705	125.2836	500	40.2173	ESA MEDICAL RESOURCES	SURGERY	2026.2
10020400000200000	181604	01	001	AL	AUTAUGA	92628	PRATTVILLE	020805	208.0500	4992.9768	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	164.3548	172.7848	168.4751	500	0.0599			2026.2
19061410120020000	171614	01	001	AL	AUTAUGA	92628	PRATTVILLE	020501	205.0100	1204.2684	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	93.2189	94.6552	94.0988	500	0.2976			2026.2
10073600000060140	181636	01	001	AL	AUTAUGA	92628	PRATTVILLE	020804	208.0400	3108.5888	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	134.9980	137.0733	136.0875	500	0.7683			2026.2
19030520040060000	171605	01	001	AL	AUTAUGA	92628	PRATTVILLE	020100	201	1738.3754	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	112.1420	117.5756	114.5034	500	0.4295			2026.2
10073600000061430	181636	01	001	AL	AUTAUGA	92628	PRATTVILLE	020804	208.0400	1315.5509	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	128.3055	129.3003	129.0059	500	0.3250			2026.2
21020400000020100	161504	01	001	AL	AUTAUGA	92628	PRATTVILLE	020801	208.0100	8047.2954	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	76.4113	85.6272	81.8603	500	1.9885			2026.2
12061300000040140	181413	01	001	AL	AUTAUGA	92628	PRATTVILLE	020803	208.0300	68399.0033	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	131.7651	151.3219	142.6893	500	16.9022			2026.2
19051520130330010	171615	01	001	AL	AUTAUGA	92628	PRATTVILLE	020400	204	1614.3593	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	85.7508	95.5535	93.7692	500	0.3989			2026.2
10041700000100100	181617	01	001	AL	AUTAUGA	92628	PRATTVILLE	020803	208.0300	4045.2069	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	135.0168	149.3815	143.6233	500	0.9995			2026.2
02041900000020040	201519	01	001	AL	AUTAUGA	92106	MARBURY	020902	209.0200	5077.2743	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	182.2897	187.0673	185.2962	500	1.2553			2026.2
10052100000160050	181621	01	001	AL	AUTAUGA	92628	PRATTVILLE	020804	208.0400	39999.6305	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	167.2783	195.7399	181.7932	500	10.1830			2026.2
10041900000070530	181619	01	001	AL	AUTAUGA	92628	PRATTVILLE	020803	208.0300	3747.9254	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	131.5363	139.3957	135.5499	500	0.9261			2026.2
14030500000070000	181205	01	001	AL	AUTAUGA	90315	BILLINGSLEY	021000	210	78297.4355	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	58.2300	65.8043	61.6191	500	50.9699			2026.2
19051520120020000	171615	01	001	AL	AUTAUGA	92628	PRATTVILLE	020400	204	1098.1899	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	97.0862	97.3995	97.2400	500	0.2713			2026.2
06030800000040000	191308	01	001	AL	AUTAUGA	90315	BILLINGSLEY	021000	210	245367.0683	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	97.8878	134.3836	106.9011	500	60.6293			2026.2
09061400000110150	191614	01	001	AL	AUTAUGA	92106	MARBURY	020901	209.0100	2057.9610	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	107.5324	112.2788	109.6357	500	0.5086			2026.2
10072500000130570	181625	01	001	AL	AUTAUGA	92628	PRATTVILLE	020805	208.0500	519.3816	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	146.4196	147.7037	147.1636	500	0.1283			2026.2
10030500000130650	181605	01	001	AL	AUTAUGA	92628	PRATTVILLE	020803	208.0300	1677.0839	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	171.4638	174.7128	173.1527	500	0.4146			2026.2
18011100000030000	171511	01	001	AL	AUTAUGA	92628	PRATTVILLE	020801	208.0100	69712.9270	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	94.1901	130.4158	115.5242	500	17.2277			2026.2
19020340010020090	171603	01	001	AL	AUTAUGA	92628	PRATTVILLE	020400	204	1766.9868	01001C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	105.5089	110.6834	109.2944	500	0.4366			2026.2