Saved query 3b4db8f5261b8e2b

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

40/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '06' 
  AND countyfp = '047'

92,035 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parcelstate	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	taxacres	book	page	placename	placetype	lrversion
428101019	428101019000	06	047	CA	MERCED	91760	LOS BANOS	002306	23.0600	622.0313	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	31.7162	32.5193	32.1845	0.1537	428	10			2026.2
031152004	031152004000	06	047	CA	MERCED	91960	MERCED	001302	13.0200	348.3790	06047C	2026-01-20	AO		-9999	51.8188	52.1862	52.0500	0.0860	031	15	BELLA LUNA BISTRO	PIZZARIA	2026.2
428370002	428370002000	06	047	CA	MERCED	91760	LOS BANOS	002306	23.0600	557.4510	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	32.2655	33.9332	32.9232	0.1377	428	37			2026.2
012106012	012106012000	06	047	CA	MERCED	90720	DOS PALOS	002404	24.0400	690.9816	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	34.0811	34.3394	34.1915	0.1708	012	10			2026.2
021071009	021071009000	06	047	CA	MERCED	91210	GUSTINE	002002	20.0200	649.6183	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	31.0093	32.1809	31.4485	0.1605	021	07			2026.2
027151002	027151002000	06	047	CA	MERCED	91760	LOS BANOS	002201	22.0100	727.0206	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	36.1957	36.4951	36.3733	0.1796	027	15			2026.2
083640004	083640004000	06	047	CA	MERCED	91760	LOS BANOS	002303	23.0300	436.7237	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	35.5106	36.0312	35.8283	0.1079	083	64			2026.2
231114002	231114002000	06	047	CA	MERCED	91960	MERCED	001801	18.0100	554.4930	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	55.3761	56.1779	55.7517	0.1369	231	11			2026.2
011041007	011041007000	06	047	CA	MERCED	91670	LIVINGSTON-DELHI	000201	2.0099	693.7854	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	36.9598	37.5661	37.2706	0.1714	011	04			2026.2
428021014	428021014000	06	047	CA	MERCED	91760	LOS BANOS	002305	23.0500	557.1748	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	33.1339	33.7975	33.6183	0.1376	428	02			2026.2
024282003	024282003000	06	047	CA	MERCED	91670	LIVINGSTON-DELHI	000305	3.0500	903.1212	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	38.3908	38.8542	38.6107	0.2231	024	28			2026.2
012320026	012320026000	06	047	CA	MERCED	90720	DOS PALOS	002404	24.0400	634.7875	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	33.8712	34.3699	34.1578	0.1568	012	32			2026.2
082273021	082273021000	06	047	CA	MERCED	91760	LOS BANOS	002204	22.0400	610.2527	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	31.9612	32.3942	32.1650	0.1507	082	27			2026.2
041130080	041130080000	06	047	CA	MERCED	91670	LIVINGSTON-DELHI	000201	2.0099	79338.0261	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	40.3710	41.3599	40.7255	19.6022	041	13			2026.2
021024020	021024020000	06	047	CA	MERCED	91210	GUSTINE	002002	20.0200	682.7626	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	32.9848	33.7098	33.2893	0.1687	021	02			2026.2
003063006	003063006000	06	047	CA	MERCED	90150	ATWATER	000701	7.0100	473.8535	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	45.9482	46.3106	46.0701	0.1170	003	06			2026.2
017080015	017080015000	06	047	CA	MERCED	91290	HILMAR-IRWIN	000404	4.0400	697.0632	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	29.1796	29.6075	29.3953	0.1721	017	08			2026.2
424200018	424200018000	06	047	CA	MERCED	91760	LOS BANOS	002304	23.0400	557.4816	06047C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	30.3392	30.9782	30.8938	0.1377	424	20			2026.2
373031014	373031014000	06	047	CA	MERCED	91760	LOS BANOS	002100	21	696.7302	06047C	2026-01-20	D		-9999	49.8777	50.5620	50.3567	0.1721	373	03			2026.2
031213007	031213007000	06	047	CA	MERCED	91960	MERCED	001301	13.0100	696.6797	06047C	2026-01-20	AO		-9999	50.3194	50.8046	50.6070	0.1721	031	21			2026.2
074090032	074090032000	06	047	CA	MERCED	91960	MERCED	000901	9.0100	306884.5243	06047C	2026-01-20	A		-9999	34.0646	36.7730	35.9222	75.8295	074	09			2026.2
033081011	033081011000	06	047	CA	MERCED	91960	MERCED	001402	14.0200	808.2804	06047C	2026-01-20	AO		-9999	54.2154	54.9658	54.5356	0.1997	033	08			2026.2
034211009	034211009000	06	047	CA	MERCED	91960	MERCED	001401	14.0100	594.7019	06047C	2026-01-20	AO		-9999	52.4530	52.6740	52.5790	0.1469	034	21			2026.2
059623010	059623010000	06	047	CA	MERCED	91960	MERCED	001603	16.0300	464.4507	06047C	2026-01-20	AO		-9999	48.4862	49.3281	49.1120	0.1147	059	62			2026.2
032054008	032054008000	06	047	CA	MERCED	91960	MERCED	001502	15.0200	695.6862	06047C	2026-01-20	AO		-9999	49.7553	50.1106	49.9756	0.1719	032	05			2026.2