Saved query 8a044ab29f56378f

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 = '21' 
  AND countyfp = '151'

39,099 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	zoningcode	taxacres	naicscode	placename	placetype	taxdistrict
R011-0004-0001	21	151	PURDY'S COFFEE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010302	103.0200	2279.4759	2	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	286.2368	287.1879	286.8451	B-3	0.5632	31192	PURDY'S COFFEE	COFFEE_SHOP	02-RICHMOND ANNEX
0068-0018-0012	21	151	241 OXFORD CIRCLE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010303	103.0300	669.1709	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	252.6257	253.3839	252.9306	PUD	0.1653	6216	ROSAS BROTHERS TREE SERVICE	HOME_SERVICE	02-RICHMOND ANNEX
X	21	151	5 DIXIE PLAZA	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010902	109.0200	454.0668	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	285.6625	286.3834	286.0869	B-3	0.1122		DIXIE PLAZA MOBIL HOME PARK	HOUSING_OR_PROPERTY_SERVICE	02-RICHMOND ANNEX
0072-0024-0055	21	151	206 SUPREME COURT	BEREA	KY	40403	MADISON	90224	BEREA	011202	112.0200	5108.3406	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	279.4694	284.0489	281.2037	R-1	1.2622		WALKER BRANCH	LODGING	05-CITY OF BEREA
054B-0007-0011	21	151	505 SOUTH KEENELAND DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010701	107.0100	4774.0031	3	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	276.7582	282.4837	278.6654	I-2	1.1796		WEIGH BETTER WEIGHT LOSS	WELLNESS_SERVICE	02-RICHMOND ANNEX
054C-0005-0004	21	151	206 KEYSTONE DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010701	107.0100	1410.1782	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	275.2532	284.0847	279.2477	B-3	0.3484				02-RICHMOND ANNEX
B002-0001-0006	21	151	100 BARBERRY LANE	BEREA	KY	40403	MADISON	90224	BEREA	011401	114.0100	5961.3172	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	314.5922	321.7775	320.2893	R-1	1.4728				03-BEREA ANNEX
0049-0000-0015-A	21	151	1085 SOUTH DOGWOOD DRIVE	BEREA	KY	40403	MADISON	90224	BEREA	011401	114.0100	26172.6480	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	355.4169	403.7422	390.5309	UC-7	6.4667				01-COUNTY
0100-0000-0053-E	21	151	2328 BIG HILL ROAD	BEREA	KY	40403	MADISON	90224	BEREA	011102	111.0200	5497.8488	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	257.0603	266.4799	261.9458	R-7	1.3584				01-COUNTY
0074-0004-0063	21	151	115 JASON CIRCLE	BEREA	KY	40403	MADISON	90224	BEREA	011303	113.0300	1602.5524	2	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	291.4210	292.7310	291.8638	R-3	0.3959				05-CITY OF BEREA
B003-0002-0002-A	21	151	329 HAITI ROAD EAST	BEREA	KY	40403	MADISON	90224	BEREA	011301	113.0100	3308.6020	2	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	302.6145	304.7761	304.1016	UC-1	0.8175				01-COUNTY
R007-0017-0029	21	151	339 5TH STREET	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010602	106.0200	579.8874	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	289.8480	293.6741	291.5443	R-1C	0.1432				02-RICHMOND ANNEX
0041-0011-0070	21	151	302 WILDWOOD DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010701	107.0100	4078.5029	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	276.6806	290.6994	284.8559	UC-1	1.0078				01-COUNTY
R010-0013-0007	21	151	113 VESCIO STREET	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010303	103.0300	1294.1137	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	282.5921	284.3601	283.9183	R-1C	0.3197				02-RICHMOND ANNEX
054B-0001-0010-A	21	151	1643 FOXHAVEN DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010202	102.0200	1145.7041	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	285.4323	290.3781	288.5003	B-3	0.2830				02-RICHMOND ANNEX
0122-0000-0021-1	21	151	450 NEEDMORE ROAD	WACO	KY	40385	MADISON	90224	BEREA	011103	111.0300	4559.6405	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	277.5181	281.9787	280.7516	R-7	1.1266				01-COUNTY
073C-0000-0175	21	151	902 KENWAY STREET	BEREA	KY	40403	MADISON	90224	BEREA	011202	112.0200	744.7925	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	284.6561	287.2256	285.7110	R-1	0.1840				05-CITY OF BEREA
R007-0007-0003	21	151	214 WINTON DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010201	102.0100	1643.4475	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	271.7233	275.2005	273.6828	UC-1	0.4060				01-COUNTY
0060-0000-0031-16	21	151	360 PAULINE DRIVE	BEREA	KY	40403	MADISON	90224	BEREA	011402	114.0200	6111.5722	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	276.1586	285.7469	283.3516	B-4	1.5099				05-CITY OF BEREA
0069-0012-0035	21	151	1124 SOUTHERN HILLS DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010902	109.0200	1062.9788	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	282.0480	285.6374	284.0975	B-3	0.2626				02-RICHMOND ANNEX
119B-0000-0004	21	151	5221 FIKE ROAD	WACO	KY	40385	MADISON	93578	WACO-BYBEE	011002	110.0200	3804.8194	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	269.0158	273.7351	271.1764	R-7	0.9400				01-COUNTY
R009-0007-0011	21	151	344 EAST IRVINE STREET	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010400	104	1566.7473	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	289.4700	292.1642	291.2885	B-2	0.3871				02-RICHMOND ANNEX
0070-0008-0033	21	151	7041 ARBOR RIDGE DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010902	109.0200	1454.2610	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	298.7151	305.8808	303.0802	PUD	0.3593				02-RICHMOND ANNEX
0113-0000-0005-F	21	151	418 WOLF GAP ROAD	BEREA	KY	40403	MADISON	90224	BEREA	011103	111.0300	27505.0696	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	269.1237	300.1448	282.4013	R-7	6.7959				01-COUNTY
R001-0002-0012	21	151	106 BUCKWOOD DRIVE	RICHMOND	KY	40475	MADISON	92912	RICHMOND	010601	106.0100	1140.8522	1	21151C	2025-12-23	X	AREA OF MINIMAL FLOOD HAZARD	-9999	298.8209	301.0864	300.1204	R-1A	0.2819				02-RICHMOND ANNEX