Saved query 2318848e8dc4de51

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

36/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '39' 
  AND countyfp = '049'

484,982 matching parcels

Data Preview

statefp	countyfp	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	fldzone	elevmin	elevmax	elevavg	ownertype	parceltype	accesstype	iucnclass	placename	placetype	lrversion
39	049	OH	CITY GOVERNMENT	FRANKLIN	62974	PLAIN	007213	72.1300	1800.1994	—	301.6343	302.5732	301.8937	GOVERNMENT	GOVT LOCAL	OPEN	V	NEW ALBANY NATURE PRESERVE	LOCAL CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	81242	WASHINGTON	006241	62.4100	15539.5546	—	284.3017	287.6240	285.7041	GOVERNMENT	GOVT LOCAL	OPEN	V	BALLANTRAE OPEN SPACE "S"	LOCAL CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	81242	WASHINGTON	010502	105.0200	665.4893	—	269.8154	271.8184	270.5230	GOVERNMENT	GOVT LOCAL	OPEN	V	EMERALD PARKWAY OPEN SPACE	LOCAL CONSERVATION AREA	2026.2
39	049	OH	NON-GOVERNMENTAL ORGANIZATION	FRANKLIN	37772	JACKSON	009754	97.5400	663.5966	—	209.7227	216.6792	213.1659	PERSON	NGO	OPEN	V	SOUTHEAST CONSERVATION CLUB	PRIVATE CONSERVATION	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007202	72.0200	7709.3245	—	245.0139	260.4239	249.8890	GOVERNMENT	GOVT LOCAL	OPEN	V	STREAMSIDE FOREST ACQUISITION A…	LOCAL CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007302	73.0200	26632.0527	—	302.6217	313.3159	308.4487	GOVERNMENT	GOVT LOCAL	OPEN	V	DYSART RUN AND E BROAD PARKLAND	LOCAL CONSERVATION AREA	2026.2
39	049	OH	UNITED STATES NATURAL RESOURCES…	FRANKLIN	62974	PLAIN	007213	72.1300	21299.9605	—	339.4108	341.5731	340.5473	GOVERNMENT	GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	71787	SHARON	006710	67.1000	20782.9700	—	265.6163	269.2166	267.3050	PERSON	GOVT LOCAL	OPEN		VILLAGE GREEN	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	006821	68.2099	9675.6569	—	228.6723	236.1410	232.5233	PERSON	GOVT LOCAL	OPEN		DELAWANDA	LOCAL RECREATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	09442	BROWN	008002	80.0200	7183.1742	—	279.0911	280.3200	279.7560	PERSON	GOVT LOCAL	OPEN		PRAIRIE OAKS METROPARK	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	57344	NORWICH	007963	79.6300	117.7201	—	230.2037	230.6812	230.2938	GOVERNMENT	GOVT LOCAL	OPEN	V	HAYDEN FALLS	STATE CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007963	79.6300	18.3162	—	230.2037	231.9188	230.6557	GOVERNMENT	GOVT LOCAL	OPEN	V	HAYDEN FALLS	STATE CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	006921	69.2099	3674.5222	—	273.1781	277.9292	275.2603	PERSON	GOVT LOCAL	OPEN		WOODWARD PARK	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007963	79.6300	8.9328	—	230.2037	230.7411	230.4310	GOVERNMENT	GOVT LOCAL	OPEN	V	HAYDEN FALLS	STATE CONSERVATION AREA	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	001820	18.2000	727.9428	—	218.1846	224.7185	223.0561	PERSON	GOVT LOCAL	OPEN		PERRY PARK	LOCAL PARK	2026.2
39	049	OH	REGIONAL AGENCY	FRANKLIN	18000	COLUMBUS	009401	94.0100	16067.4662	—	222.0475	228.4555	222.7548	PERSON	GOVT SPECIAL DISTRICT	CLOSED		THREE CREEKS METROPARK	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	003000	30	275.9786	—	228.4351	228.9616	228.6136	PERSON	GOVT LOCAL	OPEN		SPRING & FOURTH DOG PARK	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	002510	25.1000	8578.1550	—	238.5248	245.8534	242.0220	PERSON	GOVT LOCAL	OPEN		MAJESTIC PAINT PARKLAND	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	004700	47	2425.6434	—	239.0460	239.8780	239.5038	PERSON	GOVT LOCAL	OPEN		BURGESS PARK	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	46410	MADISON	009495	94.9500	891.6854	—	224.7997	225.5169	225.1349	PERSON	GOVT LOCAL	OPEN		BLACKLICK CREEK TRAIL	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	46410	MADISON	009495	94.9500	448.3148	—	223.9574	224.7528	224.2002	PERSON	GOVT LOCAL	OPEN		BLACKLICK CREEK TRAIL	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007205	72.0500	40277.1227	—	299.9514	302.7857	301.8857	PERSON	GOVT LOCAL	OPEN		WALNUT STREET PARKLAND	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	18000	COLUMBUS	007215	72.1500	180448.6953	—	294.7455	302.1905	298.2952	PERSON	GOVT LOCAL	OPEN		ULRY-WARNER RD PARKLAND	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	37772	JACKSON	009600	96	330.8084	—	258.1134	258.6576	258.3420	PERSON	GOVT LOCAL	OPEN		TOWN CENTER PLAZA	LOCAL PARK	2026.2
39	049	OH	CITY GOVERNMENT	FRANKLIN	83342	WESTERVILLE	007010	70.1000	708.6777	—	247.0308	248.3171	247.6579	PERSON	GOVT LOCAL	OPEN		FIRST RESPONDERS PARK	LOCAL PARK	2026.2