Saved query 8151ac6ca1d8348c

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

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

20,490 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelcity	parcelstate	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usecode	usedesc	zoningcode	taxacres	naicscode	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxdistrict
009180006000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	50691.8790	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2597.4995	2686.9003	2647.1035	RM	LAND PARCEL	NA	12.5300		GOVT FEDERAL	RESTRICTED	OTHER	BISHOP FIELD OFFICE	NATIONAL PUBLIC LANDS	2026.2	4
040040040000	06	051		CA	MONO	91865	MAMMOTH LAKES	000202	2.0200	59169.1153	06051C	2026-01-20	X	0.2 PCT ANNUAL CHANCE FLOOD HAZ…	2399.6291	2411.2866	2405.0440	R		R	14.6200	712190	GOVT STATE	CLOSED		SNOWCREEK MEADOW PRESERVE	NATURE_RESERVE	2026.2	5
040370001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	18075.0421	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2401.5854	2405.4438	2403.0864	870	SUBDIVISION	NA	4.4700		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	5
040450001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	14308.7925	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2401.6398	2406.7297	2402.7605	870	SUBDIVISION	NA	3.5300		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	5
040430001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	19042.8739	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2400.8190	2407.5314	2402.5986	870	SUBDIVISION	NA	4.7100		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	5
040390001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	10826.5243	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2402.2663	2404.6711	2403.5507	870	SUBDIVISION	NA	2.6700		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	5
860000040000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	301.9339	06051C	2026-01-20	A		1999.7593	2001.2404	2000.6610	NA		NA	0.0700		GOVT FEDERAL	RESTRICTED	OTHER	TOIYABE NATIONAL FOREST	NATIONAL FOREST	2026.2	4
860000250000	06	051		CA	MONO	91865	MAMMOTH LAKES	000102	1.0200	226.3010	06051C	2026-01-20	D		2192.2919	2192.6159	2192.4610	NA		NA	0.0600		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	3
024090013000	06	051	UNASSIGNED	CA	MONO	91865	MAMMOTH LAKES	000101	1.0100	161359.4951	06051C	2026-01-20	AE		1648.0424	1653.0872	1650.3246	AG	LAND PARCEL	NA	39.8700							2026.2	2
019080002000	06	051	UNASSIGNED	CA	MONO	92195	NORTH MONO	000102	1.0200	776.3861	06051C	2026-01-20	D		2986.9282	2999.3801	2991.9138	SFR 1-2	LAND PARCEL	NA	0.1900							2026.2	4
860000015000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	153.7757	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2001.6049	2001.9213	2001.7859	NA		NA	0.0400		GOVT FEDERAL	RESTRICTED	OTHER	TOIYABE NATIONAL FOREST	NATIONAL FOREST	2026.2	4
006130030000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	263128.2664	06051C	2026-01-20	D		2137.9101	2227.0642	2172.5256	NA		NA	65.0200		GOVT FEDERAL	RESTRICTED	OTHER	TOIYABE NATIONAL FOREST	NATIONAL FOREST	2026.2	4
024110012000	06	051	UNASSIGNED	CA	MONO	91865	MAMMOTH LAKES	000101	1.0100	19038.3328	06051C	2026-01-20	AE		1634.0725	1636.1639	1635.1555	RR	LAND PARCEL	NA	4.7000							2026.2	2
860003154000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	133.7397	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	1998.0583	1998.2745	1998.1562	NA		NA	0.0300		GOVT FEDERAL	RESTRICTED	OTHER	TOIYABE NATIONAL FOREST	NATIONAL FOREST	2026.2	4
033022020000	06	051		CA	MONO	91865	MAMMOTH LAKES	000202	2.0200	536.4672	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2453.5805	2458.3261	2455.2562	NA		NVSP	0.1300	711130				MAMMOTH VILLAGEFEST	MUSIC_VENUE	2026.2	3
040480001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	205375.7905	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2400.6687	2425.9174	2407.7109	310	SUBDIVISION	NA	50.7500	721				SNOWCREEK, MAMMOTH LAKES, CALIF…	HOTEL	2026.2	5
033022040000	06	051		CA	MONO	91865	MAMMOTH LAKES	000202	2.0200	353.0001	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2454.1394	2456.2939	2454.8917	NA		NVSP	0.0900	7225				YAMA RAMEN	RESTAURANT	2026.2	3
040340001000	06	051		CA	MONO	91865	MAMMOTH LAKES	000201	2.0099	24712.4730	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2400.3815	2404.2150	2402.1759	870	SUBDIVISION	NA	6.1000	5313				JODI MELTON	REAL_ESTATE_SERVICE	2026.2	5
860000782000	06	051		CA	MONO	91865	MAMMOTH LAKES	000102	1.0200	80426.1691	06051C	2026-01-20	D		2069.8720	2147.5112	2090.7343	NA		NA	19.8700	611110	GOVT LOCAL	OPEN		LEE VINING ELEMENTARY SCHOOL	ELEMENTARY_SCHOOL	2026.2	3
033370024000	06	051		CA	MONO	91865	MAMMOTH LAKES	000202	2.0200	12510.4452	06051C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	2413.2258	2426.9841	2418.8580	195	LAND PARCEL	R	3.0900	721				TALLUS RESORT AT MAMMOTH	RESORT	2026.2	3
860003112000	06	051		CA	MONO	91865	MAMMOTH LAKES	000102	1.0200	99.6651	06051C	2026-01-20	D		2187.2751	2188.2641	2187.5985	NA		NA	0.0200		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	3
863100038000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	250833.0322	06051C	2026-01-20	D		1819.1405	2102.3322	1960.5580	NA		NA	61.9800		GOVT FEDERAL	RESTRICTED	OTHER	ICEBERG - MILL CREEK ROADLESS A…	INVENTORIED ROADLESS AREA	2026.2	4
863100025000	06	051		CA	MONO	92195	NORTH MONO	000102	1.0200	80921.8130	06051C	2026-01-20	D		2185.9306	2238.4650	2206.9288	NA		NA	20		GOVT FEDERAL	RESTRICTED	OTHER	BISHOP FIELD OFFICE	NATIONAL PUBLIC LANDS	2026.2	4
015091011000	06	051	UNASSIGNED	CA	MONO	91865	MAMMOTH LAKES	000101	1.0100	418.1469	06051C	2026-01-20	D		2395.3049	2413.1875	2404.1434	SFR	LAND PARCEL	NA	0.1000							2026.2	3
860000574000	06	051		CA	MONO	91865	MAMMOTH LAKES	000102	1.0200	53.6741	06051C	2026-01-20	D		2191.1501	2191.5700	2191.4127	NA		NA	0.0100		GOVT FEDERAL	RESTRICTED	OTHER	INYO NATIONAL FOREST	NATIONAL FOREST	2026.2	3