Saved query f7d38ffd7efa5976

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

23,048 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	placename	placetype
55-17-03-06-4-003-005 000	01	109	249 PIKE COUNTY LAKE ROAD	TROY	AL	36079	Pike	93195	Troy	189003	1890.0300	22260.4515	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	153.8556	159.4958	157.1846	5.4700	6216	CONECUH BRIDGE & ENGINEERING	HOME_SERVICE
55-10-09-29-3-005-003 000	01	109	200 ACADEMY STREET	TROY	AL	36081	Pike	93195	Troy	188900	1889	733.3099	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	164.6041	165.8678	165.3033	0.1800	8121	THE STACHE AND STYLE SHOP	PERSONAL_OR_BEAUTY_SERVICE
55-22-05-21-0-000-010 005	01	109	2561 AL HWY 167	BRUNDIDGE	AL	36010	Pike	91620	Henderson-Spring Hill	189200	1892	8369.6102	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	119.5638	127.8803	123.9748	2.0800	8133	REACHING INTO DARKNESS	SOCIAL_OR_COMMUNITY_SERVICE
55-10-09-29-3-304-047 000	01	109	103 NORTH MARKET STREET	TROY	AL	36081	Pike	93195	Troy	188900	1889	508.9115	4	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	167.7303	170.3354	169.1000	0.1200	4552	HEMPHINITY	WAREHOUSE_CLUB_STORE
55-06-07-35-0-000-017 001	01	109	500 COUNTY RD 1179	TROY	AL	36079	Pike	92340	Needmore	188700	1887	3817.2978	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	131.7527	137.3233	134.6905	0.9300
55-04-04-18-0-000-002 003	01	109	4385 COUNTY ROAD 7735	TROY	AL	36081	Pike	92340	Needmore	188700	1887	263655.0196	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	118.0731	151.7297	135.5587	65.1500
55-10-09-32-3-008-007 000	01	109	708 SOUTH THREE NOTCH STREET	TROY	AL	36081	Pike	93195	Troy	189003	1890.0300	15269.3701	15	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	130.5883	143.4405	135.5288	3.7900
55-17-03-05-4-009-003 000	01	109	303 JANE ROAD	TROY	AL	36079	Pike	93195	Troy	189002	1890.0200	1378.1532	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	152.6798	154.3163	153.5147	0.3400
55-16-06-13-0-000-020 016	01	109	1204 COUNTY RD 4408	BRUNDIDGE	AL	36010	Pike	90432	Brundidge	189300	1893	1441.1052	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	132.4178	136.3147	134.8754	0.3600
55-16-02-03-0-000-003 000	01	109	393 COUNTY RD 5515	TROY	AL	36081	Pike	90198	Banks-Josie	188600	1886	37857.5459	3	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	147.7639	159.0603	154.4795	9.3200
55-10-09-29-3-008-007 000	01	109	321 WEST WALNUT STREET	TROY	AL	36081	Pike	93195	Troy	189001	1890.0100	667.5835	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	160.6381	163.4996	162.0906	0.1700
55-17-04-17-0-000-023 006	01	109	145 PROSPECT RIDGE ROAD	TROY	AL	36079	Pike	93195	Troy	189003	1890.0300	2509.4764	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	115.4386	123.7603	120.0546	0.6300
55-17-03-08-1-002-002 002	01	109	409 COUNTRY CLUB ROAD	TROY	AL	36079	Pike	93195	Troy	189003	1890.0300	1940.9785	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	150.8836	153.6978	152.8226	0.4800
55-22-09-31-0-000-002 001	01	109	155 COUNTY RD 2271	TROY	AL	36079	Pike	91620	Henderson-Spring Hill	189200	1892	4724.6075	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	134.7278	141.5076	139.8815	1.1600
55-10-09-31-1-006-014 000	01	109	619 WALNUT STREET	TROY	AL	36081	Pike	93195	Troy	189001	1890.0100	2004.9098	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	160.6213	163.0667	162.1508	0.4900
55-17-03-08-0-000-032 106	01	109	135 WHITE TAIL WAY	TROY	AL	36079	Pike	93195	Troy	189003	1890.0300	2650.7635	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	116.3795	123.5098	119.9171	0.6700
55-02-07-26-0-000-001 012	01	109	565 COUNTY RD 7711	TROY	AL	36081	Pike	92340	Needmore	188700	1887	20641.0478	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	136.5216	143.1643	140.5831	5.0800
55-10-09-30-1-003-007 000	01	109	506 WEST FAIRVIEW STREET	TROY	AL	36081	Pike	93195	Troy	189001	1890.0100	1180.8833	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	154.1338	158.1090	156.1462	0.2900
55-02-07-26-0-000-001 003	01	109	567 COUNTY RD 7711	TROY	AL	36081	Pike	92340	Needmore	188700	1887	116769.2535	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	131.3910	143.5091	138.0194	28.9500
55-15-01-01-0-000-009 001	01	109	7128 AL HWY 130	BANKS	AL	36005	Pike	90198	Banks-Josie	188600	1886	10284.9622	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	129.2211	137.1352	134.3567	2.5299
55-17-07-26-0-000-001 011	01	109	3383 COUNTY RD 3304	TROY	AL	36079	Pike	93195	Troy	189102	1891.0200	1980.2826	2	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	142.6207	147.5456	145.5166	0.4900
55-18-01-01-0-000-007 001	01	109	634 COUNTY RD 2210	TROY	AL	36079	Pike	93195	Troy	189001	1890.0100	8663.4882	4	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	147.5900	151.5129	149.9647	2.1400
55-09-07-25-0-000-010 001	01	109	306 COUNTY RD 1101	TROY	AL	36079	Pike	93195	Troy	189001	1890.0100	9861.8026	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	153.1088	156.4637	155.2116	2.4400
55-23-05-22-0-000-005 000	01	109	2007 COUNTY RD 3323	BRUNDIDGE	AL	36010	Pike	90432	Brundidge	189300	1893	223551.8845	2	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	130.9832	151.3177	142.1364	55.1800
55-16-06-13-0-000-014 004	01	109	1139 COUNTY RD 4408	BRUNDIDGE	AL	36010	Pike	90198	Banks-Josie	188600	1886	6226.8911	1	01109C	2026-01-23	X	AREA OF MINIMAL FLOOD HAZARD	133.9762	138.5870	137.1457	1.5200