Saved query ec20bdb56628e01c

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '45' 
  AND countyfp = '009'

11,729 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	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	lrversion	taxdistrict
0029-00-00-052	00131486	45	009	1.14 HWY 301		SC	STATE OF SOUTH CAROLINA	BAMBERG	92483	OLAR	960300	9603	134902.0164	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	52.4554	55.6998	53.0838	31.5700	GOVERNMENT		0061	0122	GOVT STATE	RESTRICTED	III	CATHEDRAL BAY HERITAGE PRESERVE	STATE HISTORIC OR CULTURAL AREA	2026.2	08-20
0029-00-00-055	00022987	45	009	HWY 64		SC	STATE OF SOUTH CAROLINA	BAMBERG	92483	OLAR	960300	9603	114712.5379	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	52.4447	55.0201	52.8774	26.2700	GOVERNMENT		0061	0122	GOVT STATE	RESTRICTED	III	CATHEDRAL BAY HERITAGE PRESERVE	STATE HISTORIC OR CULTURAL AREA	2026.2	08-20
0096-05-12-001	00882786	45	009			SC	CITY GOVERNMENT	BAMBERG	91014	EHRHARDT	960400	9604	13446.3953	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.1198	44.9272	44.1683	3.2200	PERSON		0149	0014	GOVT LOCAL	RESTRICTED		COPELAND BALL PARK	LOCAL RECREATION AREA	2026.2	22-11
0096-06-08-003	00889486	45	009			SC	CITY GOVERNMENT	BAMBERG	91014	EHRHARDT	960400	9604	1968.5261	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.2102	43.6991	43.4074	0	PERSON				GOVT LOCAL	RESTRICTED		PALMETTO PARK	LOCAL RECREATION AREA	2026.2	22-11
0038-05-05-001	00233786	45	009	00 LOTS 1-5 BLK 55		SC	MORRIS JOHN KEVIN	BAMBERG	90871	DENMARK	960102	9601.0200	1143.6737	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	74.1096	74.7815	74.4039	0	PERSON	457	0104	0059				TEXACO	GAS_STATION	2026.2	21-21
0096-06-08-001	00889286	45	009	LOT 1 BLK 12 PEARL ST		SC	CITY GOVERNMENT	BAMBERG	91014	EHRHARDT	960400	9604	2208.4032	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.0426	43.6245	43.3080	0	PERSON				GOVT LOCAL	RESTRICTED		PALMETTO PARK	LOCAL RECREATION AREA	2026.2	22-11
0137-00-00-001	01035886	45	009			SC	STATE OF SOUTH CAROLINA	BAMBERG	90130	BAMBERG	960202	9602.0200	17101.2109	45009C	2026-01-08	A		-9999	27.8410	30.4397	29.3925	4.1000	GOVERNMENT				GOVT STATE	RESTRICTED		ZIG ZAG BOAT RAMP	STATE RECREATION AREA	2026.2	14-10
0096-02-05-002	00857986	45	009			SC	BRABHAM OIL CO INC	BAMBERG	91014	EHRHARDT	960400	9604	1941.2300	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.6285	44.6039	44.1720	0	BUSINESS	45711						EHRHARDT SPEED STOP	CONVENIENCE_STORE	2026.2	22-11
0079-00-00-027	00611786	45	009	S-5-58 1107.10		SC	PREH FOREST GMBTT	BAMBERG	91014	EHRHARDT	960400	9604	4166044.7233	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	33.9130	48.5755	43.8774	1107.1000	PERSON		0100	0196						2026.2	22-10
0109-00-00-018	00963986	45	009			SC	POTTS BETTY	BAMBERG	91014	EHRHARDT	960400	9604	3919.5148	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	41.9277	43.0244	42.4132	1	PERSON		0072	0169						2026.2	22-10
0096-00-00-056	00849586	45	009			SC	TWIN CREEK ENTERPRISES LLC	BAMBERG	91014	EHRHARDT	960400	9604	4033.3735	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.5188	43.8737	43.4040	1	BUSINESS		0280	0086						2026.2	22-10
0038-09-06-003	00301786	45	009	00 OFF CHERRY ST		SC	JAMES HELEN M.	BAMBERG	90871	DENMARK	960102	9601.0200	397.8190	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	72.8032	73.4394	72.9859	0	PERSON		0109	0044						2026.2	21-21
0087-01-11-009	00710086	45	009			SC	HALMON JUDY	BAMBERG	90130	BAMBERG	960201	9602.0100	674.3841	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	49.3778	50.1908	49.8136	0	PERSON		0340	0294						2026.2	14-11
0087-04-03-041	00117393	45	009			SC	REED NORMA	BAMBERG	90130	BAMBERG	960202	9602.0200	769.0082	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.3566	47.3642	46.9063	0	PERSON		0074	0079						2026.2	14-11
0072-08-07-004	00567886	45	009			SC	HUTTO CHARLIE	BAMBERG	90130	BAMBERG	960202	9602.0200	447.6830	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	43.6456	44.3165	43.8844	0.1200	PERSON		0068	0002						2026.2	14-10
0087-02-20-004	00739586	45	009			SC	CHAVIS ROBIN C	BAMBERG	90130	BAMBERG	960202	9602.0200	1685.9320	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	50.8411	51.7852	51.1747	0	PERSON		0421	083						2026.2	14-11
0087-11-01-012	00004275	45	009			SC	MILLER ANNA	BAMBERG	90130	BAMBERG	960202	9602.0200	2062.3633	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	47.2941	48.9400	48.1418	0.5000	PERSON		0128	0120						2026.2	14-10
0086-10-01-001	00689186	45	009			SC	TUCK JOHN C	BAMBERG	90130	BAMBERG	960201	9602.0100	5194.2586	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	48.2184	49.3846	48.9421	0	PERSON		0364	0244						2026.2	14-11
0028-04-12-005	00120886	45	009			SC	STILL TOMMY L.	BAMBERG	92483	OLAR	960300	9603	917.1925	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	62.4118	63.5991	62.8280	0	PERSON		0131	0129						2026.2	08-21
0145-00-00-083	00204296	45	009		RIVER	SC	KINARD CLYDE B.	BAMBERG	90130	BAMBERG	960202	9602.0200	1149.7507	45009C	2026-01-08	A		-9999	28.1740	28.8809	28.5268	0	PERSON		0097	0041						2026.2	14-10
0036-00-00-064	00158686	45	009	OFF HWY 321		SC	KENNEDY ARIELEAN S.	BAMBERG	90871	DENMARK	960101	9601.0100	21105.1496	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	60.7448	67.3415	62.8244	4.1400	PERSON		B002	PO12						2026.2	21-20
0102-01-00-010	00938586	45	009	44 HWY S-5-86		SC	RICE HAROLD O.	BAMBERG	90130	BAMBERG	960202	9602.0200	1851.3956	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	46.6338	48.2011	47.6826	0.4400	PERSON		0024	0094						2026.2	14-10
0097-01-02-008	00902886	45	009			SC	THOMPSON KATHY	BAMBERG	91014	EHRHARDT	960400	9604	982.8823	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	42.8044	44.1239	43.7932	0	PERSON		0129	0090						2026.2	22-11
0072-05-02-009	00509386	45	009	00 LOT 6		SC	BOWERS LINDA A	BAMBERG	90130	BAMBERG	960201	9602.0100	2264.7853	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	48.3117	48.9335	48.6205	0	PERSON		0445	0226						2026.2	14-11
0028-04-14-016	00123486	45	009	00 4TH & WEED		SC	PROFITT JIM	BAMBERG	92483	OLAR	960300	9603	605.4821	45009C	2026-01-08	X	AREA OF MINIMAL FLOOD HAZARD	-9999	62.7705	63.0237	62.9169	0	PERSON		0149	0051						2026.2	08-21