Saved query da69abf405c09d3d

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

35/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '19' 
  AND countyfp = '103'

73,731 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	ownertype	township	section	qtrsection	range	plssdesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear
9900000001	19	103	9900000001 NO ADDRESS	IA	CITY GOVERNMENT	JOHNSON	92077	IOWA CITY	000100	1	489130.3322	—	194.6499	205.0386	195.9185	PERSON	79N	4	SE	6W	SE 1/4S4 T79N R6W	GOVT LOCAL	OPEN		PENINSULA PARK	LOCAL PARK	2026.2	2024
NA	19	103		IA		JOHNSON	90240	BIG GROVE	010100	101	4371.8392	—	221.0699	223.5570	222.5774		81N	24	NW	6W	NW 1/4S24 T81N R6W						2026.2	2024
	19	103		IA	CITY GOVERNMENT	JOHNSON	92077	IOWA CITY	000100	1	81307.6805	—	212.5399	241.0490	226.0391	GOVERNMENT						GOVT LOCAL	OPEN	V	IOWA CITY GREENSPACE	LOCAL CONSERVATION AREA	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	92766	MADISON	010306	103.0600	295.7086	—	218.8949	220.3595	219.8075	GOVERNMENT						GOVT FEDERAL	OPEN	V	HAWKEYE WMA	CONSERVATION AREA	2026.2
	19	103		IA	UNITED STATES NATURAL RESOURCES…	JOHNSON	91479	FREMONT	010502	105.0200	32256.4262	—	183.4400	187.3967	186.1782	GOVERNMENT						GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT	2026.2
	19	103		IA	NON-GOVERNMENTAL ORGANIZATION	JOHNSON	93093	NEWPORT	010100	101	121420.2081	—	202.3289	232.1749	216.1120	PERSON						NGO	OPEN	V	O'MARA - NEWPORT WOODS	PRIVATE CONSERVATION	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	93285	PENN	010308	103.0800	2824.0483	—	207.2083	213.1222	210.3923	GOVERNMENT						GOVT STATE	OPEN	V	OLD STATE QUARRY STATE PRESERVE	STATE CONSERVATION AREA	2026.2
	19	103		IA	JOHNSON COUNTY GOVERNMENT	JOHNSON	90543	CEDAR	010100	101	8173.0354	—	205.2691	219.0227	207.9501	GOVERNMENT						GOVT LOCAL	OPEN	V	CEDAR RIVER CROSSING	LOCAL CONSERVATION AREA	2026.2
	19	103		IA	JOHNSON COUNTY GOVERNMENT	JOHNSON	90543	CEDAR	010100	101	390.1854	—	205.7048	209.4011	207.8671	GOVERNMENT						GOVT LOCAL	OPEN	V	SUTLIFF BRIDGE WILDLIFE MANAGEM…	LOCAL CONSERVATION AREA	2026.2
	19	103		IA	CITY GOVERNMENT	JOHNSON	92077	IOWA CITY	001500	15	2615.6735	—	201.4727	205.8554	202.5993	GOVERNMENT						GOVT LOCAL	OPEN	V	RALSTON CREEK	LOCAL CONSERVATION AREA	2026.2
	19	103		IA	CITY GOVERNMENT	JOHNSON	92077	IOWA CITY	001500	15	1393.6881	—	202.2938	206.3364	203.6282	GOVERNMENT						GOVT LOCAL	OPEN	V	RALSTON CREEK	LOCAL CONSERVATION AREA	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	92077	IOWA CITY	002300	23	23965.2928	—	199.0270	218.3135	210.2326	GOVERNMENT						GOVT STATE	OPEN	V	QUAD RAVINE	PRIVATE CONSERVATION	2026.2
	19	103		IA	NON-GOVERNMENTAL ORGANIZATION	JOHNSON	91599	GRAHAM	010100	101	23002.2918	—	238.8187	244.7698	242.1105	PERSON						NGO	OPEN		HOOVER NATURE TRAIL	STATE RECREATION AREA	2026.2
	19	103		IA	NON-GOVERNMENTAL ORGANIZATION	JOHNSON	91599	GRAHAM	010100	101	22855.6135	—	228.0304	237.8958	232.1863	PERSON						NGO	OPEN		HOOVER NATURE TRAIL	STATE RECREATION AREA	2026.2
	19	103		IA	CITY GOVERNMENT	JOHNSON	90240	BIG GROVE	010100	101	13091.0677	—	218.3876	220.1127	219.1618	PERSON						GOVT LOCAL	OPEN		RANDALL PARK	LOCAL PARK	2026.2
	19	103		IA	NON-GOVERNMENTAL ORGANIZATION	JOHNSON	90240	BIG GROVE	010100	101	15823.7541	—	218.3711	225.9315	222.0329	PERSON						NGO	OPEN		HOOVER NATURE TRAIL	STATE RECREATION AREA	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	93093	NEWPORT	010100	101	19923.9114	—	214.7632	233.4136	222.6495	GOVERNMENT						GOVT FEDERAL	OPEN		CORALVILLE RECREATION AREA	RECREATION MANAGEMENT AREA	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	90240	BIG GROVE	010100	101	1576.0600	—	207.9899	211.6578	209.2366	GOVERNMENT						GOVT FEDERAL	OPEN		CORALVILLE LAKE	RECREATION MANAGEMENT AREA	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	90240	BIG GROVE	010100	101	226.9576	—	220.6722	223.7232	222.7515	GOVERNMENT						GOVT STATE	OPEN		LAKE MACBRIDE STATE PARK	STATE PARK	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	90240	BIG GROVE	010100	101	602.3371	—	218.1452	221.2394	219.4991	GOVERNMENT						GOVT STATE	OPEN		LAKE MACBRIDE STATE PARK	STATE PARK	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	90240	BIG GROVE	010100	101	436.0247	—	217.8052	219.0703	218.3851	GOVERNMENT						GOVT STATE	OPEN		LAKE MACBRIDE STATE PARK	STATE PARK	2026.2
	19	103		IA	STATE OF IOWA	JOHNSON	90240	BIG GROVE	010100	101	818.8431	—	240.4536	242.0269	241.0201	GOVERNMENT						GOVT STATE	OPEN		LAKE MACBRIDE STATE PARK	STATE PARK	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	90240	BIG GROVE	010100	101	1285.6660	—	218.0701	220.5185	219.0388	GOVERNMENT						GOVT FEDERAL	OPEN		CORALVILLE LAKE	RECREATION MANAGEMENT AREA	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	90240	BIG GROVE	010100	101	1189.8165	—	216.9095	220.1563	219.1695	GOVERNMENT						GOVT FEDERAL	OPEN		CORALVILLE RECREATION AREA	RECREATION MANAGEMENT AREA	2026.2
	19	103		IA	UNITED STATES ARMY CORPS OF ENG…	JOHNSON	93093	NEWPORT	010100	101	173.3974	—	207.4029	207.7374	207.6141	GOVERNMENT						GOVT FEDERAL	OPEN		CORALVILLE LAKE	RECREATION MANAGEMENT AREA	2026.2