Saved query dca54c10f374a3b8

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

2,988 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	numbldgs	numunits	numfloors	bldgsqft	firmid	firmdate	fldzone	zonesubty	staticbfe	elevmin	elevmax	elevavg	taxacres	naicscode	placename	placetype	taxyear
005651004	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1473.2012	1	1	2	4913	06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2221.8481	2235.6186	2229.2063					2024
006133011000	06	003	325 LARKSPUR DR	CA	CA	ALPINE	91890	MARKLEEVILLE	010000	100	3912.2174					06003C	2026-01-20	D		-9999	2372.9477	2399.4880	2385.4667	0.9666
002330010000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	26068.9628					06003C	2026-01-20	D		-9999	1664.2163	1688.7757	1670.6380	6.4409	72121	MARKLEEVILLE CAMPGROUND	CAMPGROUND
001080078000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	4918.6010					06003C	2026-01-20	D		-9999	1731.8818	1735.9586	1733.4373	1.2153		ALPINE COUNTY HEALTH DEPARTMENT	MEDICAL_SERVICE
003050003000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	82668.3497					06003C	2026-01-20	D		-9999	2197.3513	2306.4902	2250.0564	20.4247		LEVIATHAN MINE	HISTORIC_SITE
006010109000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	13565.0193					06003C	2026-01-20	D		-9999	2358.5031	2364.5463	2361.1152	4.8834		KIRKWOOD FIRE DEPARTMENT	FIRE_STATION
110020001000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	13328.1665					06003C	2026-01-20	D		-9999	2377.4047	2384.0388	2381.1896	3.2928		CAPLES LAKE RESORT	LODGING
006160003000	06	003	1377 KIRKWOOD MDWS DR	CA	CA	ALPINE	91890	MARKLEEVILLE	010000	100	11.1182					06003C	2026-01-20	D		-9999	2382.6723	2383.3432	2382.9908
001080030000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	35339.8082					06003C	2026-01-20	D		-9999	1724.0435	1733.1469	1729.6267	5.7005		ALPINE COUNTY TRANSPORTATION CO…	GOVERNMENT_OFFICE
003020004000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	2543315.6063					06003C	2026-01-20	D		-9999	2455.0393	2596.2785	2527.5309	628.3888		MONITOR PASS	HISTORIC_SITE
002280021000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	10543.6580					06003C	2026-01-20	D		-9999	1674.8883	1699.6636	1684.8036	0.9353		ALPINE COUNTY SHERIFF'S DEPARTM…	POLICE_STATION
005462009000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1421.9999					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2253.0642	2270.6855	2260.4603	0.3513
005200001000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	34161.3782					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2227.3330	2248.1977	2235.4033	8.4409
111051004000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1773.0372					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2273.0395	2279.2995	2276.4904	0.4380
005421010000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	510.4344					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2226.6074	2233.9890	2230.9083	0.1261
005401007000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1956.4624					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2245.6047	2263.9599	2254.7858	0.4834
001160014000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	3191.3713					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	1559.7812	1564.4498	1562.7069	0.7884
005462011000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1927.1746					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2245.7717	2255.8195	2251.5228	0.4760
111051051000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	785.3344					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2255.5639	2260.3886	2258.5057	0.1940
005421011000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	358.6408					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2226.4240	2236.1005	2230.2339	0.0885
005392013000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	8114.4082					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2221.1318	2248.6335	2230.0381	2.0048
111051045000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1003.1431					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2253.5720	2264.0715	2257.8368	0.2479
001080028000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	292998.3438					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	1593.1612	1717.2194	1630.3650	72.3908
005451008000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	1068.1736					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2291.4143	2308.0612	2300.2490	0.2640
111051014000	06	003		CA		ALPINE	91890	MARKLEEVILLE	010000	100	763.3337					06003C	2026-01-20	X	AREA OF MINIMAL FLOOD HAZARD	-9999	2243.6149	2252.4382	2248.4542	0.1886