Saved query be4cd790758f2a20

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

28,757 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	ownername	owneraddr	ownercity	ownerstate	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	bldgsqft	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	usecode	usedesc	taxacres	ownertype	naicscode	parceltype	accesstype	iucnclass	placename	placetype
6N5W3000 500	25510	41	009	10358 HWY 202	BIRKENFELD	OR	97016	ALLEN JESSE & KATIE	10358 HIGHWAY 202	BIRKENFELD	OR	97016	COLUMBIA	93332	VERNONIA	971100	9711	87424.9700	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD		156.8283	185.7428	171.1526	012	FARM POTENTIAL ADDITIONAL TAX L…	95.1000	PERSON		GOVT FEDERAL	RESTRICTED	OTHER	NEHALEM RIVER	WILD AND SCENIC RIVER
4N4W 400 707	22567	41	009	1001 E BRIDGE ST	VERNONIA	OR	97064	CITY OF VERNONIA	1001 BRIDGE ST	VERNONIA	OR	97064	COLUMBIA	93332	VERNONIA	971100	9711	264032.5203	4	1	0	41009C	2025-12-17	AE		617						65.2400	GOVERNMENT		GOVT FEDERAL	RESTRICTED	OTHER	OLD VERNONIA MILL	HISTORIC_SITE
4N5W1300 600	24322	41	009	57942 TIMBER RD	VERNONIA	OR	97064	RYDER JAMES & KELSEY	57942 TIMBER RD	VERNONIA	OR	97064	COLUMBIA	93332	VERNONIA	971100	9711	8927.1938	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					099	FIRE PATROL	2.0900	PERSON		GOVT FEDERAL	RESTRICTED	OTHER	NEHALEM RIVER	WILD AND SCENIC RIVER
4N4W 4CB 1800	23040	41	009	735 JEFFERSON AVE	VERNONIA	OR	97064	N SCHNICK LLC	735 JEFFERSON AVE	VERNONIA	OR	97064	COLUMBIA	93332	VERNONIA	971100	9711	2011.3216	1	1	21625	41009C	2025-12-17	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…							0	BUSINESS		GOVT FEDERAL	RESTRICTED	OTHER	R&S MARKET	FOOD_AND_BEVERAGE_STORE
7N2W16CB 2410	18031	41	009	30012 MAPLE DR	RAINIER	OR	97048	PATCHING STATE FAM TRT & PATCHI…	30012 MAPLE DR	RAINIER	OR	97048	COLUMBIA	92601	RAINIER	970300	9703	1522.4395	1	1	14840	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD		70.4172	79.6388	75.1824			0	PERSON
7N2W16BC 1500	17881	41	009	917 W A LOOP	RAINIER	OR	97048	NELSON GARY R	PO BOX 581	RAINIER	OR	97048	COLUMBIA	92601	RAINIER	970300	9703	464.5350	1	1	5000	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD		25.6944	28.4955	27.5556			0	PERSON
5N1W33DB 300	13376	41	009	970 OREGON ST	ST HELENS	OR	97051	K&B VENTURES LLC	300 SPINNAKER WAY	COLUMBIA CITY	OR	97018	COLUMBIA	92703	ST. HELENS	970500	9705	2381.4946	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0.6000	BUSINESS	531130				K AND B STORAGE	SELF-STORAGE FACILITY
6N5W13CC 2801	25370	41	009			OR	97016	BLOOMER MARVIN & CINDY	69076 HIGHWAY 47	MIST	OR	97016	COLUMBIA	90544	CLATSKANIE	970201	9702.0100	46.4431	1	1	500	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON		GOVT FEDERAL	RESTRICTED	OTHER	NEHALEM RIVER	WILD AND SCENIC RIVER
4N5W1300 2700	24347	41	009			OR	97064	WEYERHAEUSER TIMBER HOLDINGS INC	220 OCCIDENTAL AVE S	SEATTLE	WA	98104	COLUMBIA	93332	VERNONIA	971100	9711	333255.2711		1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					014	FOREST POTENTIAL ADDITIONAL TAX…	80	BUSINESS		GOVT FEDERAL	RESTRICTED	OTHER	NEHALEM RIVER	WILD AND SCENIC RIVER
7N2W 7D0 2200	22197	41	009	28952 DIKE RD	RAINIER	OR	97048	COLUMBIA RIVER PUD	PO BOX 1193	ST HELENS	OR	97051	COLUMBIA	92601	RAINIER	970300	9703	7929.1120	1	1	72310	41009C	2025-12-17	X	AREA WITH REDUCED FLOOD RISK DU…		5.1154	5.6959	5.2485			0	PERSON
7N2W16DB 8201	22162	41	009		RAINIER	OR	97048	MSB PROPERTIES LLC	PO BOX 175	RAINIER	OR	97048	COLUMBIA	92601	RAINIER	970300	9703	579.2179		1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD		7.7111	8.4705	8.1114	1020	TRANSFER ON DEATH DEED RECORDED	0.1400	BUSINESS
7N2W16BB 3102	429077	41	009	815 KING DR	RAINIER	OR	97048	WEST REVOCABLE LIVING TRUST	815 KING DR	RAINIER	OR	97048	COLUMBIA	92601	RAINIER	970300	9703	335.5938	1	1	3614	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD		2.1140	8.4824	7.3847			0	TRUST
7N2W36BC 2400	18687	41	009	72562 IVY LN	RAINIER	OR	97048	CARTER DANIEL D	72549 IVY LN	RAINIER	OR	97048	COLUMBIA	92601	RAINIER	970300	9703	3239.8025	1	1	0	41009C	2025-12-17	AE			1.8700	21.8871	6.2873			0.7500	PERSON
4N1W2700 500	7463	41	009			OR	97056	ELLIS LOREN JR & SONS	33250 FILBERT LN	WARREN	OR	97053	COLUMBIA	92805	SCAPPOOSE	970900	9709	196380.6529		1	0	41009C	2025-12-17	X	AREA WITH REDUCED FLOOD RISK DU…		3.9111	7.7344	5.1755	012	FARM POTENTIAL ADDITIONAL TAX L…	48.5300	PERSON
6N2W2800 2101	21545	41	009	67094 NICOLAI RD	RAINIER	OR	97048	MASTERSON BONNIE LEA REVOCABLE …	67094 NICOLAI RD	RAINIER	OR	97048	COLUMBIA	91190	GOBLE	970400	9704	168551.6066	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					012	FARM POTENTIAL ADDITIONAL TAX L…	41.9000	TRUST
3N2W13CD 6500	436522	41	009	33350 SW ROTTERDAM ST	SCAPPOOSE	OR	97056	BLOSFIELD JONATHAN S & AMBER L	33350 SW ROTTERDAM ST	SCAPPOOSE	OR	97056	COLUMBIA	92805	SCAPPOOSE	971000	9710	567.9718	1	1	6114	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON
4N4W 4AB 1211	440711	41	009	188 E G ST	VERNONIA	OR	97064	KLINGENBERG KEIR & ESMERALDA	188 E G ST	VERNONIA	OR	97064	COLUMBIA	93332	VERNONIA	971100	9711	465.2532	1	1	5000	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON
3N2W12CB 300	3787	41	009	52379 SW 4TH ST	SCAPPOOSE	OR	97056	LANGNER KRISTAL A	52379 SW 4TH ST	SCAPPOOSE	OR	97056	COLUMBIA	92805	SCAPPOOSE	971000	9710	2047.2521	1	1	23090	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON
3N2W12CC 1103	3863	41	009	33012 SW KEYS RD	SCAPPOOSE	OR	97056	KENOYER HEATHER	33012 SW KEYS RD	SCAPPOOSE	OR	97056	COLUMBIA	92805	SCAPPOOSE	971000	9710	3183.8381	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0.7900	PERSON
3N2W12DB 2502	4072	41	009	33678 SE OLIVE ST	SCAPPOOSE	OR	97056	BECK KATHRINE L	33678 SE OLIVE ST	SCAPPOOSE	OR	97056	COLUMBIA	92805	SCAPPOOSE	970900	9709	651.4817	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0.1600	PERSON
8N3W2800 700	20934	41	009	79110 ALSTON MAYGER RD	RAINIER	OR	97048	POSCH WALTER G & MIRIAM & JACKS…	358 CARROLL RD	KELSO	WA	98626	COLUMBIA	92601	RAINIER	970300	9703	35119.1157	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					014	FOREST POTENTIAL ADDITIONAL TAX…	8.6800	PERSON
7N4W2400 101	26658	41	009	74782 PALM CREEK RD	CLATSKANIE	OR	97016	CRAPE KEVIN T	74782 PALM CREEK RD	CLATSKANIE	OR	97016	COLUMBIA	90544	CLATSKANIE	970201	9702.0100	18907.8979	1	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					014	FOREST POTENTIAL ADDITIONAL TAX…	4.6800	PERSON
4N1W 5CC 710	28947	41	009	59144 WHITETAIL AVE	ST HELENS	OR	97051	POW TRAVIS & WALKER CLAIRE	10520 NE SISKIYOU ST	PORTLAND	OR	97220	COLUMBIA	92703	ST. HELENS	970600	9706	689.3774	1	1	7410	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON
4N1W 5DC 5200	12597	41	009	725 CEDAROAK ST	ST HELENS	OR	97051	BRIGHT LOGAN & BROOKLYN	725 CEDAROAK ST	ST HELENS	OR	97051	COLUMBIA	92703	ST. HELENS	970800	9708	869.8782	1	1	9376	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD							0	PERSON
4N2W 3D0 1100	15274	41	009	59400 LYTLE DR	ST HELENS	OR	97051	BACKLUND DAVID RICHARD	59400 LYTLE DR	ST HELENS	OR	97051	COLUMBIA	92703	ST. HELENS	970500	9705	28104.6775	2	1	0	41009C	2025-12-17	X	AREA OF MINIMAL FLOOD HAZARD					014	FOREST POTENTIAL ADDITIONAL TAX…	6.6200	PERSON