Saved query 2aa440e773aa3a37

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 = '101'

36,134 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parcelcity	parcelstate	countyname	cousubfp	cousubname	tractce	tractname	calcarea	yearbuilt	firmid	firmdate	fldzone	zonesubty	usecode	usedesc	zoningcode	zoningdesc	taxacres	legaldesc	book	page	lrversion	taxyear
017-120-063-000		06	101		CA	SUTTER	91970	MERIDIAN-ROBBINS	050900	509	163165.1540	0	06011C	2026-01-20	AE		AW	AG - WASTE	R-F	RIVER FRONTAGE	66.1000	66.11 AC T15N R1E & W			2026.2	2025
34-240-021	034-240-021-000	06	101	UNINCORPORATED	CA	SUTTER	91970	MERIDIAN-ROBBINS	050900	509	469362.6173		060394	2026-01-20	X	AREA WITH REDUCED FLOOD RISK DU…					115.9668		34	240	2026.2
23-030-106	023-030-106-000	06	101	UNINCORPORATED	CA	SUTTER	93820	YUBA CITY	050504	505.0400	9194.8390		060394	2026-01-20	A						2.2716		23	030	2026.2
25-010-024	025-010-024-000	06	101	UNINCORPORATED	CA	SUTTER	93825	YUBA CITY SOUTHWEST	051000	510	153125.6234		060394	2026-01-20	A						37.8316		25	010	2026.2
35-040-027	035-040-027-000	06	101	UNINCORPORATED	CA	SUTTER	93180	SOUTH SUTTER	051100	511	19377.4363		060394	2026-01-20	AE						4.7877		35	040	2026.2
35-170-083	035-170-083-000	06	101	UNINCORPORATED	CA	SUTTER	93180	SOUTH SUTTER	051100	511	6164.1740		060394	2026-01-20	AE						1.5228		35	170	2026.2
54-140-001	054-140-001-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050401	504.0100	770.0732		060394	2026-01-20	AREA NOT INCLUDED						0.1902		54	140	2026.2
022-130-010-000		06	101		CA	SUTTER	91970	MERIDIAN-ROBBINS	050900	509	87140.1958	0			—		GW	GOV. - WASTE	R-F	RIVER FRONTAGE	0.5000	.50 AC YOLO LAND CO SUB NO 1 LO…			2026.2	2025
62-420-038	062-420-038-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050601	506.0100	714.8448				—						0.1766	19S249	62	420	2026.2
53-490-014	053-490-014-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050302	503.0200	387.1825				—						0.0956		53	490	2026.2
53-153-012	053-153-012-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050302	503.0200	668.6517				—						0.1651		53	153	2026.2
06-750-014	006-750-014-000	06	101	LIVE OAK	CA	SUTTER	91650	LIVE OAK	050702	507.0200	675.8311				—						0.1669		06	750	2026.2
06-040-100	006-040-100-000	06	101	LIVE OAK	CA	SUTTER	91650	LIVE OAK	050701	507.0100	585.4701				—						0.1446		06	040	2026.2
06-680-054	006-680-054-000	06	101	LIVE OAK	CA	SUTTER	91650	LIVE OAK	050702	507.0200	594.6952				—						0.1469		06	680	2026.2
13-280-162	013-280-162-000	06	101	UNINCORPORATED	CA	SUTTER	93825	YUBA CITY SOUTHWEST	051000	510	10607.9656				—						2.6206		13	280	2026.2
51-434-017	051-434-017-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050102	501.0200	1259.8881				—						0.3112		51	434	2026.2
53-162-024	053-162-024-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050302	503.0200	699.0454				—						0.1727		53	162	2026.2
59-520-006	059-520-006-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050603	506.0300	853.2759				—						0.2107		59	520	2026.2
51-620-009	051-620-009-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050101	501.0100	681.1062				—						0.1682		51	620	2026.2
17-264-005	017-264-005-000	06	101	UNINCORPORATED	CA	SUTTER	93820	YUBA CITY	050603	506.0300	984.9939				—						0.2433		17	264	2026.2
06-173-012	006-173-012-000	06	101	LIVE OAK	CA	SUTTER	91650	LIVE OAK	050702	507.0200	858.6038				—						0.2121		06	173	2026.2
08-240-034	008-240-034-000	06	101	UNINCORPORATED	CA	SUTTER	91650	LIVE OAK	050702	507.0200	152115.7275				—						37.5819		08	240	2026.2
13-160-042	013-160-042-000	06	101	UNINCORPORATED	CA	SUTTER	91970	MERIDIAN-ROBBINS	050900	509	3075.9431				—						0.7599		13	160	2026.2
59-650-022	059-650-022-000	06	101		CA	SUTTER	93820	YUBA CITY	050604	506.0400	516.6899				—						0.1276	21S041	59	650	2026.2
52-361-002	052-361-002-000	06	101	YUBA CITY	CA	SUTTER	93820	YUBA CITY	050201	502.0100	520.1610				—						0.1284		52	361	2026.2