Saved query 235fad8cd8b009bc

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 = '45' 
  AND countyfp = '009'

11,729 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	taxacres	ownertype	naicscode	book	page	parceltype	accesstype	iucnclass	placename	placetype	taxdistrict
0038-00-00-003	00179286	45	009	9.91 S-5-399		SC	29042	CITY GOVERNMENT	BAMBERG	90871	DENMARK	960102	9601.0200	36432.3758	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	69.2097	74.9904	71.3006	9.9100	PERSON		0081	0126	GOVT LOCAL	RESTRICTED	OTHER	CITY OF DENMARK CITY FOREST 4	LOCAL RESOURCE MANAGEMENT AREA	21-20
0028-04-15-001	00124286	45	009	00 LOTS 1-4 BLK 14	OLAR	SC	29843	CDP OLAR LLC	BAMBERG	92483	OLAR	960300	9603	7866.8634	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	60.8470	62.8364	61.7706	1.9600	BUSINESS	45911	0438	0035				DOLLAR GENERAL	DISCOUNT_STORE	08-21
0086-04-06-003	00666386	45	009	00	BAMBERG	SC	29003	GLENN WILLIAM D. IV M.D.	BAMBERG	90130	BAMBERG	960201	9602.0100	864.6008	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	51.3447	51.9768	51.7613	0	PERSON		0113	0084				DR. KELENNE TUITT DO	OUTPATIENT_CARE_FACILITY	14-11
0096-02-02-004	00855786	45	009		EHRHARDT	SC	29081	LOW COUNTRY ASSIST LIVING LLC	BAMBERG	91014	EHRHARDT	960400	9604	3614.1072	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.9428	44.1292	43.4257	0	BUSINESS		0226	0244				LOW COUNTRY ASST LIVING	SENIOR_LIVING_FACILITY	22-11
0038-09-01-027	00010388	45	009	HWY 78	DENMARK	SC	29042	GLOVER BOBBY FRANK	BAMBERG	90871	DENMARK	960102	9601.0200	2742.2398	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	71.5800	72.6388	72.2297	0	PERSON		0115	0077						21-21
0028-04-10-012	00119186	45	009	LOT B 00	OLAR	SC	29843	DELOACH CLEMOUTH	BAMBERG	92483	OLAR	960300	9603	1937.0335	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	58.5757	60.0948	59.1751	0	PERSON		0049	0063						08-21
0097-01-02-013	00903386	45	009		EHRHARDT	SC	29081	BROWN MAMIE HEIRS	BAMBERG	91014	EHRHARDT	960400	9604	4258.1224	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.2617	44.3608	43.9279	1	ESTATE		0053	0174						22-11
0086-04-04-006	00663986	45	009	00	BAMBERG	SC	29003	KILGUS BETTY S TRUSTEE	BAMBERG	90130	BAMBERG	960201	9602.0100	1151.7858	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	48.9847	49.7700	49.3801	0	TRUST		0367	0248						14-11
0087-01-14-015	00714986	45	009	00 LOTS 4 & 5 BLK A	BAMBERG	SC	29003	BOZARD BERNICE	BAMBERG	90130	BAMBERG	960201	9602.0100	1377.3597	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	49.5117	50.2361	49.7889	0	PERSON		0115	0160						14-11
0072-06-03-028	00005754	45	009		BAMBERG	SC	29003	WALKER JAMES	BAMBERG	90130	BAMBERG	960202	9602.0200	1006.9283	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.3986	47.3465	46.6826	0.2500	PERSON		0293	0151						14-11
0028-04-11-007	00120186	45	009	00 W 1/2 LOTS 1 & 2 BLK 25	OLAR	SC	29843	PROFFITT RONNIE DWAINE	BAMBERG	92483	OLAR	960300	9603	1956.4775	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	61.7994	62.7640	62.3768	0.4700	PERSON		0271	0045						08-21
0086-04-04-019	00665286	45	009		BAMBERG	SC	29003	BRAXTON HOPE H.	BAMBERG	90130	BAMBERG	960201	9602.0100	690.1613	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	49.7402	50.2188	49.9895	0	PERSON		0302	0116						14-11
0072-06-05-011	00526086	45	009	00	BAMBERG	SC	29003	VERNER LAKEVIS F	BAMBERG	90130	BAMBERG	960202	9602.0200	1288.5717	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.9297	47.7408	47.3495	0	PERSON		0407	0122						14-11
0072-07-08-004	00562286	45	009		BAMBERG	SC	29003	BRANT HAROLD	BAMBERG	90130	BAMBERG	960202	9602.0200	1268.7765	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.1543	47.4813	46.5764	0	PERSON		0105	0145						14-11
0072-07-07-012	00561186	45	009	00	BAMBERG	SC	29003	MIDDLETON EARTHA MAE	BAMBERG	90130	BAMBERG	960202	9602.0200	2984.4041	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.9643	49.1063	47.7358	0	PERSON		0118	0030						14-11
0096-03-07-002	00866786	45	009	00 BLK 15	EHRHARDT	SC	29081	SMITH ROGER DALE	BAMBERG	91014	EHRHARDT	960400	9604	2077.2749	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.6315	43.3918	42.9555	0	PERSON		0089	0199						22-11
0028-04-15-006	00124886	45	009	00 LOT 11 & 12 BLK 14 SURVIOR	OLAR	SC	29843	CHURCH FRIST BAPTIST OF OLAR	BAMBERG	92483	OLAR	960300	9603	1014.4898	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	61.3102	62.0615	61.5157	0.2600	NONPROFIT		0432	0144						08-21
0072-07-08-001	00561986	45	009	00 W 1/2 LOT 10	BAMBERG	SC	29003	FINLEY MARY ANN ETAL	BAMBERG	90130	BAMBERG	960202	9602.0200	921.1650	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.1207	47.0982	46.7906	0	PERSON		0044	0055						14-11
0038-09-05-005	00300686	45	009	00 LOT 37	DENMARK	SC	29042	JONES KENNETH O.	BAMBERG	90871	DENMARK	960101	9601.0100	2837.6565	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	72.4941	74.6601	73.4652	0	PERSON		0144	0013						21-21
0038-10-07-001	00317686	45	009	00	DENMARK	SC	29042	CHURCH PROGRESSIVE CHURCH	BAMBERG	90871	DENMARK	960102	9601.0200	1712.0442	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	71.8120	72.7947	72.2744	0	NONPROFIT		0053	0037						21-21
0097-01-02-007	00902786	45	009		EHRHARDT	SC	29081	BROWN COREY ET AL	BAMBERG	91014	EHRHARDT	960400	9604	1180.9847	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.6827	44.1471	43.6282	0	PERSON		0129	0091						22-11
0075-00-00-020	00588186	45	009	2.00 HWY S-5-41		SC	29003	KINARD JASIE MAE	BAMBERG	90130	BAMBERG	960202	9602.0200	9389.9809	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	49.5534	51.3600	50.3093	2	PERSON		0020	0088						14-10
0097-00-00-041	00898586	45	009	5.00 OFF S-5-388		SC	29082	AYER RONALD ETAL	BAMBERG	91014	EHRHARDT	960400	9604	17880.5915	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	41.3636	44.4164	43.3808	5	PERSON		0045	0045						22-10
0086-08-03-003	00682786	45	009			SC	29003	WALLEN NICHOLAS	BAMBERG	90130	BAMBERG	960201	9602.0100	3277.9606	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	48.6928	49.5081	48.9537	0	PERSON		0312	0291						14-11
0063-00-00-014	00471686	45	009	HWY 64 150.00		SC	29081	WALLING LULA BELLE	BAMBERG	92483	OLAR	960300	9603	499224.0934	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.8971	49.3819	47.4789	132.2300	PERSON		0123	0111						08-20