Saved query 572ebcd5a99bdc02

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

42/80

Live SQL

SELECT * 
FROM "lr_parcel_us" 
WHERE statefp = '42' 
  AND countyfp = '019'

96,531 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelstate	ownername	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	saledate	numbldgs	numunits	numfloors	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	taxacres	ownertype	legaldesc	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear
130 S18 A19-0000	42	019	PA	IQBAL ASIF	BUTLER	16920	CRANBERRY	912102	9121.0200	760.7957	16060	1880	0	17940	300000	2022-10-17	1	1	1			—		317.9525	319.5523	318.6558		PERSON	0.19 AC LOT 19 HSE						2026.2	2024
250 S2 A20-0000	42	019	PA	WEIL RICHARD E & LINDA M	BUTLER	55992	OAKLAND	910700	9107	3856.4585	9110	900	0	10010	0	2000-01-01	1	1	1			—		381.7477	396.9215	388.7367		PERSON	LOT HSE						2026.2	2024
270 S3 37-0000	42	019	PA	BARNETT ZACHARY R	BUTLER	58792	PENN	911600	9116	922.9203	0	1080	0	1080	120000	2019-12-11						—		368.9541	372.1285	370.3024		PERSON	0.28 AC						2026.2	2024
010 4F35 9/501-0000	42	019	PA		BUTLER	00300	ADAMS	912403	9124.0300	1274.3803	0	0	0	0	0							—		302.1561	315.6983	310.8992									2026.2	2024
010 4F35 9/729-0000	42	019	PA		BUTLER	00300	ADAMS	912403	9124.0300	822.5839	0	0	0	0	0							—		366.2458	371.4906	370.2600									2026.2	2024
400 S2-QUESTION-0000	42	019	PA		BUTLER	24248	EVANS CITY	911700	9117	164.8256	0	0	0	0	0							—		309.3042	316.0567	312.2030									2026.2	2024
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	10472	BUTLER	902900	9029	494.5548												—		315.9936	320.9402	318.0466		PERSON		NGO	OPEN	V	UNNAMED	PRIVATE CONSERVATION	2026.2
	42	019	PA	UNKNOWN	BUTLER	10000	BUFFALO	912702	9127.0200	16478.0136												—		309.8214	320.4046	316.4459		UNDETERMINED		GOVT UNKNOWN	OPEN	V	TODD NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	019	PA	UNKNOWN	BUTLER	10000	BUFFALO	912702	9127.0200	4585.6527												—		269.0054	296.7959	282.3975		UNDETERMINED		GOVT UNKNOWN	OPEN	V	TODD NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	26904	FORWARD	911700	9117	49488.3534												—		286.6115	327.2381	302.3858		PERSON		NGO	OPEN	V	UNNAMED	PRIVATE CONSERVATION	2026.2
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	10000	BUFFALO	912702	9127.0200	17309.7001												—		317.9322	336.3314	328.1421		PERSON		NGO	OPEN	V	TODD NATURE RESERVE 2	PRIVATE CONSERVATION	2026.2
	42	019	PA	STATE OF PENNSYLVANIA	BUTLER	49056	MIDDLESEX	912800	9128	9299.9168												—		341.0987	344.1468	342.6220		GOVERNMENT		GOVT STATE	UNKNOWN	OTHER	GLADE RUN LAKE FLOWAGE EASEMENT	CONSERVATION EASEMENT	2026.2
	42	019	PA	OTHER OR UNKNOWN LOCAL GOVERNME…	BUTLER	49056	MIDDLESEX	912800	9128	20281.8200												—		353.6122	360.5537	358.1584		PERSON		GOVT LOCAL	OPEN	OTHER	MIDDLESEX TWP COMMUNITY PARK	LOCAL PARK	2026.2
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	26904	FORWARD	911700	9117	6237.8466												—		289.7203	292.5044	290.6531		PERSON		NGO	OPEN	V	CREEK ROAD NA	PRIVATE CONSERVATION	2026.2
	42	019	PA	OTHER OR UNKNOWN LOCAL GOVERNME…	BUTLER	85784	WINFIELD	911400	9114	6468.5478												—		401.6068	405.7187	404.1892		PERSON		GOVT LOCAL	OPEN	OTHER	WINFIELD TOWNSHIP COMMUNITY PARK	LOCAL PARK	2026.2
	42	019	PA	UNITED STATES NATURAL RESOURCES…	BUTLER	15480	CONCORD	910600	9106	4483.9763												—		367.4316	368.9821	368.2473		GOVERNMENT		GOVT FEDERAL	CLOSED	V	WETLANDS RESERVE PROGRAM (WRP),…	CONSERVATION EASEMENT	2026.2
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	10000	BUFFALO	912702	9127.0200	931.0938												—		251.1175	254.3081	252.0652		PERSON		NGO	OPEN	V	BUFFALO CREEK NATURE PARK	CONSERVATION EASEMENT	2026.2
	42	019	PA	NON-GOVERNMENTAL ORGANIZATION	BUTLER	10000	BUFFALO	912701	9127.0100	170819.9119												—		241.2750	344.2490	287.0633		PERSON		NGO	CLOSED	V	VANTINE TRACT	CONSERVATION EASEMENT	2026.2
2393P00315000000	42	019	PA		BUTLER	10000	BUFFALO	912701	9127.0100	265893.3291										42019C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				65.7000								2026.2
2369F00006000000	42	019	PA		BUTLER	16920	CRANBERRY	912200	9122	25742.4186										42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				6.4000								2026.2
2387M00214000000	42	019	PA		BUTLER	14320	CLINTON	911502	9115.0200	270017.7942										42019C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				66.7200								2026.2
2391K00288000000	42	019	PA		BUTLER	10000	BUFFALO	912702	9127.0200	220284.0641										42019C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				53.7800								2026.2
2369E00002000000	42	019	PA		BUTLER	16920	CRANBERRY	912200	9122	26923.6292										42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				6.5400								2026.2
2369F00008000000	42	019	PA		BUTLER	16920	CRANBERRY	912200	9122	25555.9002										42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				6.4200								2026.2
2369F00007000000	42	019	PA		BUTLER	16920	CRANBERRY	912200	9122	25570.5652										42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD				6.3600								2026.2