Saved query 74e58b2dd57e9f49

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

0/80

Live SQL

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

592,745 matching parcels

Data Preview

parcelid	taxacctnum	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	usedesc	taxacres	naicscode	legaldesc	parceltype	accesstype	placename	placetype	taxdistrict
0047C00120000000		42	003	1400 ROMANHOFF STREET	PITTSBURGH	PA	15212	Allegheny	61000	Pittsburgh	262000	2620	618.9099	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	324.6195	333.7222	329.5888		0.1500	7212		GOVT LOCAL	OPEN	SPRING HILL PLAYGROUND	LOCAL RECREATION AREA	126
0115E00040000000		42	003	1124 HARVARD CIRCLE	PITTSBURGH	PA	15212	Allegheny	61000	Pittsburgh	270800	2708	124310.9609	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	264.6919	327.6375	301.1891		30.7200	7112		GOVT LOCAL	OPEN	JACK STACK FIELD	SPORT_FIELD	127
0881H00070000000		42	003	1701 STATE ROUTE 51	JEFFERSON HILLS	PA	15025	Allegheny	37955	Jefferson Hills	491200	4912	11506.2872	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	234.5909	279.0312	241.9865		2.8300	6216				STEPHEN D SLATER FUNERAL HOME	FAMILY_SERVICE	878
0126L00170000000		42	003	STERRETT CLASSICAL ACADEMY	PITTSBURGH	PA	15208	Allegheny	61000	Pittsburgh	141200	1412	9769.1692	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	295.3549	301.6342	298.1062		2.4100	712190				STERRETT MIDDLE SCHOOL	PARK	114
0312J00024000000		42	003	ALLEGHENY HEALTH NETWORK WEST M…	WEST MIFFLIN	PA	15122	Allegheny	83512	West Mifflin	488500	4885	7279.4811	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	363.8590	370.4355	366.6369	18-P-448	1.2900	621493	13-P-203			AHN ORTHOPEDIC SURGERY - CENTUR…	SPECIALIZED_HEALTH_CARE	870
0240C00050000000		42	003	1221 DUQUESNE PLACE DRIVE	DUQUESNE	PA	15110	Allegheny	83512	West Mifflin	488300	4883	220269.6113	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	281.6528	341.3053	324.1817	14-T-043	54.2200	522130				COINSTAR KIOSK	FINANCIAL_SERVICE	870
1656P00015000000	9923X84592000000	42	003	104 QUAIL HOLLOW LANE	WEXFORD	PA	15090	Allegheny	47696	Marshall	411002	4110.0200	2998.2769	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	368.0854	379.8152	374.3345		0.7400							923
0401L00010000000	9946X01452000000	42	003	745 MILLERS RUN ROAD	MCDONALD	PA	15057	Allegheny	72160	South Fayette	456003	4560.0300	594.4904	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	293.6598	296.9150	295.3737		0.1500							946
0481P00035000000	9946X82485000000	42	003	503 MEETING HOUSE ROAD	BRIDGEVILLE	PA	15017	Allegheny	72160	South Fayette	456004	4560.0400	3630.5834	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	316.2458	320.6718	319.9227		0.9000							946
0180R00026000000		42	003	229 MIFFLIN STREET	MUNHALL	PA	15120	Allegheny	84440	Whitaker	485000	4850	730.3689	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	315.4349	319.4132	318.1707		0							865
0165C00041000000		42	003	102 CANBY DRIVE	PITTSBURGH	PA	15209	Allegheny	69584	Shaler	427200	4272	1039.5907	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	284.8660	290.7940	288.2633		0.2600							944
0543S00168000000		42	003	610 PENNSYLVANIA AVENUE	MONROEVILLE	PA	15146	Allegheny	50528	Monroeville	521200	5212	2482.0693	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	306.2762	318.5549	313.3577		0.6100							879
0368S00049000000		42	003	206 LONG ROAD	PENN HILLS	PA	15235	Allegheny	59040	Penn Hills	523400	5234	1729.6812	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	352.1003	364.8041	358.6060		0							934
1211N00003000000		42	003	2676 BLUEBERRY RIDGE DRIVE	GIBSONIA	PA	15044	Allegheny	32328	Hampton	414102	4141.0200	1508.1626	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	361.5016	364.3643	363.5624		0.3700							914
0391L00165000000		42	003	LICK RUN	BETHEL PARK	PA	15102	Allegheny	06064	Bethel Park	475401	4754.0100	18040.5607	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	320.1734	337.2239	327.1964		4.4600							876
0375H00175000000		42	003	805 WOOD STREET	EAST PITTSBURGH	PA	15112	Allegheny	21712	East Pittsburgh	510000	5100	2539.2495	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	231.7252	235.4811	233.5797		0.6300							822
0364L00173000000		42	003	715 1ST STREET	VERONA	PA	15147	Allegheny	80032	Verona	524000	5240	381.1576	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	263.5249	268.0619	266.5563		0							859
0610S00059000000		42	003	113 POINT VUE DRIVE	PITTSBURGH	PA	15237	Allegheny	66264	Ross	429300	4293	891.0718	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	344.9006	349.3934	347.7447		0.2200							940
0194E00194000000		42	003	11 JAYCEE DRIVE	PITTSBURGH	PA	15243	Allegheny	68388	Scott	470300	4703	1111.5284	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	327.7220	336.0061	331.9307		0.2900							941
0374K00040000000		42	003	201 NORTH AVENUE	EAST PITTSBURGH	PA	15112	Allegheny	12496	Chalfant	563900	5639	262.5135	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	257.7077	263.1462	259.7286		0.0600							814
0388L00076000000		42	003	191 SUNRISE DRIVE	PITTSBURGH	PA	15236	Allegheny	61328	Pleasant Hills	489001	4890.0100	577.2793	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	317.5605	321.6763	319.3277		0.1400							873
0368D00242000000		42	003	10924 HIGHPOINT DRIVE	PENN HILLS	PA	15235	Allegheny	59040	Penn Hills	523300	5233	706.9830	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	346.5639	351.5502	349.5012		0							934
0393F00031000000		42	003	2750 BETHEL CHURCH ROAD	BETHEL PARK	PA	15102	Allegheny	06064	Bethel Park	475101	4751.0100	1080.2341	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	367.1031	375.9334	372.5041		0.2700							876
0559R00133000000		42	003	139 COAL VALLEY ROAD	JEFFERSON HILLS	PA	15025	Allegheny	37955	Jefferson Hills	491200	4912	2791.5355	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	230.8075	283.4023	260.1764		0							878
0013H00140000000		42	003	2825 PATTERSON STREET	PITTSBURGH	PA	15203	Allegheny	61000	Pittsburgh	160800	1608	778.7231	42003C	2025-12-21	X	AREA OF MINIMAL FLOOD HAZARD	318.0080	329.5715	324.0838		0.1900							116