Saved query da519ef8a3b5479c

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

45/80

Live SQL

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

586,184 matching parcels

Data Preview

parcelid	statefp	countyfp	parcelstate	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	taxacres	naicscode	legaldesc	placename	placetype	lrversion
1572P00075000000	42	003	PA	ALLEGHENY	23000	ELIZABETH	496102	4961.0200	4420161.6151	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	1080.2900	7212		ROUND HILL COUNTY REGIONAL PARK	PARK	2026.2
1999K00009000000	42	003	PA	ALLEGHENY	47696	MARSHALL	411002	4110.0200	18830.4909	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD		7212		PINE HAVEN PARK	PARK	2026.2
0821N00085000000	42	003	PA	ALLEGHENY	56392	OHIO	437000	4370	63098.6004	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	15.8800			SEWICKLEY HILLS CONDO ASSOCIATI…	HISTORIC_SITE	2026.2
0458C00200000000	42	003	PA	ALLEGHENY	55488	NORTH VERSAILLES	504100	5041	38833.2725	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	10.8200					2026.2
0770C00104000000	42	003	PA	ALLEGHENY	72400	SOUTH PARK	490003	4900.0300	2402.4633	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.5900					2026.2
0702H00177000000	42	003	PA	ALLEGHENY	17048	CRESCENT	449000	4490	396.9045	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.1000					2026.2
0734K00301000000	42	003	PA	ALLEGHENY	61536	PLUM	526101	5261.0100	940.6118	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.2300					2026.2
0094C00003000000	42	003	PA	ALLEGHENY	61000	PITTSBURGH	290400	2904	456.5009	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.1100					2026.2
0166S00236000000	42	003	PA	ALLEGHENY	24160	ETNA	425000	4250	244.7615	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.0600					2026.2
COMMON GROUND	42	003	PA	ALLEGHENY	26592	FOREST HILLS	563900	5639	24660.8019	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	6.0900					2026.2
0563G00345000000	42	003	PA	ALLEGHENY	61328	PLEASANT HILLS	489002	4890.0200	86539.1763	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	21.5100					2026.2
0288P00010000000	42	003	PA	ALLEGHENY	27120	FOX CHAPEL	422000	4220	184037.5417	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	45.4600					2026.2
0171M00155000000	42	003	PA	ALLEGHENY	56384	O'HARA	421100	4211	362.2647	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.1000					2026.2
0178P00005000000	42	003	PA	ALLEGHENY	75816	SWISSVALE	515300	5153	4213.1749	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	1.0400					2026.2
0254R00080000000	42	003	PA	ALLEGHENY	79274	UPPER ST. CLAIR	474101	4741.0100	4365.2135	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	1.0800					2026.2
1469S00004000000	42	003	PA	ALLEGHENY	25904	FINDLAY	452000	4520	882.6143	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD			15-P-474			2026.2
0230N00004000000	42	003	PA	ALLEGHENY	59040	PENN HILLS	523100	5231	929.6901	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.2300					2026.2
0738M00076000000	42	003	PA	ALLEGHENY	61536	PLUM	526201	5262.0100	577.2104	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.1400					2026.2
0061G00143000000	42	003	PA	ALLEGHENY	61000	PITTSBURGH	191700	1917	1981.9628	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.4900					2026.2
0250J00218000000	42	003	PA	ALLEGHENY	11680	CASTLE SHANNON	476100	4761	979.7387	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.2400					2026.2
0174M00190000000	42	003	PA	ALLEGHENY	61000	PITTSBURGH	130700	1307	139.3381	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.0300					2026.2
0567H00112000000	42	003	PA	ALLEGHENY	06064	BETHEL PARK	475301	4753.0100	431.7794	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.1100					2026.2
0545P00058000000	42	003	PA	ALLEGHENY	85496	WILMERDING	508000	5080	109.4329	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.0300					2026.2
0948L00316000000	42	003	PA	ALLEGHENY	32328	HAMPTON	414102	4141.0200	90130.9225	42003C	2025-12-21	AE		22.2900					2026.2
0235P00061000000	42	003	PA	ALLEGHENY	75816	SWISSVALE	515100	5151	363.6522	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	0.0900					2026.2