Saved query 95678730718c4fe7

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

43/80

Live SQL

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

78,094 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelstate	ownername	owneraddr	ownerzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	imprvalue	landvalue	agvalue	totalvalue	saleamt	numbldgs	numunits	yearbuilt	fldzone	elevmin	elevmax	elevavg	taxacres	ownertype	legaldesc	book	parceltype	accesstype	iucnclass	placename	placetype	lrversion	taxyear
35-14-0049	42	051	PA	WESTMORELAND CO MUNICIPAL AUTH …	124 PARK & POOL RD	15672	FAYETTE	73064	SPRINGFIELD	260500	2605	481708.3049	0	0	-117880	235760	2500	1	1	0	—	294.8782	446.1972	373.3326	122.2500	BUSINESS	122.253 AC	DB1220-8						2026.2	2024
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	33896	HENRY CLAY	262702	2627.0200	1938.5006									—	589.6704	605.6942	595.9366		PERSON			NGO	OPEN	V	BEAVER CREEK NATURAL AREA	CONSERVATION EASEMENT	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	1090.3758									—	623.7652	630.4076	627.1601		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	319.9383									—	484.8286	487.7251	486.4537		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	2053.1774									—	489.8689	536.2720	524.8850		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	4930.9282									—	672.5554	733.1848	715.7423		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	74080	STEWART	262702	2627.0200	101685.0549									—	622.7819	705.0462	663.2552		PERSON			NGO	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	3204.1650									—	650.8277	684.0752	669.3116		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	3746.8578									—	645.6072	655.9607	649.5552		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	67640	SALTLICK	260500	2605	1696.2199									—	424.8031	431.3970	427.0739		PERSON			NGO	UNKNOWN	V	INDIAN CREEK VALLEU TRAIL	PRIVATE RECREATION OR EDUCATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	26353.9962									—	746.2832	848.6981	799.5521		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	67640	SALTLICK	260500	2605	3108.6512									—	436.2155	444.0498	440.5423		PERSON			NGO	UNKNOWN	V	INDIAN CREEK VALLEU TRAIL	PRIVATE RECREATION OR EDUCATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	485.3299									—	469.8942	474.3016	472.5585		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	2991.9063									—	509.8422	520.8503	515.4475		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	STATE OF PENNSYLVANIA			FAYETTE	84344	WHARTON	262701	2627.0100	188553.8922									—	490.2589	538.2515	514.9699		GOVERNMENT			GOVT STATE	OPEN	OTHER	FORBES STATE FOREST	STATE RESOURCE MANAGEMENT AREA	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	4326.5196									—	729.6152	766.7272	749.5777		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	998.5930									—	484.0519	532.6491	497.3360		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	19527.6481									—	700.1334	762.1055	726.1390		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	73064	SPRINGFIELD	260500	2605	73120.2886									—	372.4551	464.1682	415.9739		PERSON			NGO	OPEN	V	WESTERN PENNSYLVANIA CONSERVANC…	CONSERVATION EASEMENT	2026.2
	42	051	PA	UNKNOWN			FAYETTE	10152	BULLSKIN	260401	2604.0100	22876.6182									—	322.9687	327.1815	324.6557		UNDETERMINED			GOVT UNKNOWN	UNKNOWN	OTHER	BRIDGEPORT DAM	LOCAL OTHER OR UNKNOWN	2026.2
	42	051	PA	NON-GOVERNMENTAL ORGANIZATION			FAYETTE	74080	STEWART	262702	2627.0200	401086.6789									—	652.8436	785.3935	748.1256		PERSON			NGO	CLOSED	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	9952.1623									—	696.1970	727.4195	717.0855		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNKNOWN			FAYETTE	74080	STEWART	262702	2627.0200	3832.6210									—	721.9281	762.9940	751.7691		UNDETERMINED			GOVT UNKNOWN	OPEN	V	BEAR RUN NATURE RESERVE	PRIVATE CONSERVATION	2026.2
	42	051	PA	UNITED STATES NATIONAL PARK SER…			FAYETTE	73240	SPRINGHILL	263100	2631	209960.3564									—	237.1835	249.0778	242.6885		GOVERNMENT			GOVT FEDERAL	RESTRICTED	III	FRIENDSHIP HILL NATIONAL HISTOR…	HISTORIC OR CULTURAL AREA	2026.2
	42	051	PA	UNKNOWN			FAYETTE	73064	SPRINGFIELD	260500	2605	20618.0256									—	415.7386	433.3043	420.9459		UNDETERMINED			GOVT UNKNOWN	OPEN	V	INDIAN CREEK VALLEY TRAIL	PRIVATE CONSERVATION	2026.2