Saved query e74b4ada91c212dd

Data Explorer

Query the US Nationwide Parcel Dataset

$1.75 / 1,000 records$100 minimum

38/80

Live SQL

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

51,129 matching parcels

Data Preview

parcelid	statefp	countyfp	parceladdr	parcelcity	parcelstate	parcelzip	countyname	cousubfp	cousubname	tractce	tractname	calcarea	firmid	firmdate	fldzone	zonesubty	elevmin	elevmax	elevavg	parceltype	accesstype	iucnclass	placename	placetype	lrversion
010-013-1	23	019		BRADLEY	ME	19040	PENOBSCOT	06680	BRADLEY	008001	80.0100	36602992.4395	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD				GOVT STATE	CLOSED	OTHER	BRADLEY	LOCAL OTHER OR UNKNOWN	2026.2
001-008	23	019		ORRINGTON	ME	19500	PENOBSCOT	55680	ORRINGTON	003000	30	149510.0455	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	98.4883	135.9169	116.2836				SUE'S CAKES AND BAKES	CASUAL_EATERY	2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	825619.7427	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD				GOVT UNKNOWN	UNKNOWN		BLACK CAP MOUNTAIN	PRIVATE CONSERVATION	2026.2
002-010	23	019	COUNTY RD	MILFORD	ME	19430	PENOBSCOT	45670	MILFORD	008001	80.0100	13472091.1345	23019C	2025-06-03	A					NGO	UNKNOWN	V	BRADLEY-SUNKHAZE PRESERVE	PRIVATE CONSERVATION	2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	8725.0901	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	95.1178	105.7502	100.2204						2026.2
003-030-000	23	019		CLIFTON	ME	19110	PENOBSCOT	13365	CLIFTON	009000	90	59286.4249	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	121.1129	155.2766	137.9501						2026.2
004-053	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	51478.8499	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	36.2080	86.9392	52.8377						2026.2
007-036-001	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	23705.3240	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	89.8916	116.7025	103.3205						2026.2
004-050-00B	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	370461.8521	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	43.5271	84.4680	55.6586						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	188768.2313	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	114.4999	168.6564	145.4169						2026.2
	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	335332.4659	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	66.8585	147.3515	104.6667				TOTAL CARE SOLUTION	SENIOR_LIVING_FACILITY	2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	255389.2498	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	146.1399	245.8646	211.8479						2026.2
unknown	23	019		CLIFTON	ME	19110	PENOBSCOT	13365	CLIFTON	009000	90	26408.1917	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	112.1900	117.4059	113.9900						2026.2
003-002-000	23	019		CLIFTON	ME	19110	PENOBSCOT	13365	CLIFTON	009000	90	323008.2321	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	108.4449	160.2717	136.1144						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	266047.5059	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	133.5299	203.1777	149.2034						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	147658.3837	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	193.5047	243.4092	224.1831						2026.2
007-047-004	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	64824.9715	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	55.6117	77.5482	62.6985						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	135954.1789	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	89.7035	159.8226	115.0124						2026.2
007-038	23	019		HOLDEN	ME	19300	PENOBSCOT	33490	HOLDEN	009000	90	231648.6247	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	56.5590	118.3993	78.9602						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	37020.7744	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	133.6900	172.6247	154.7765						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	161855.3703	23019C	2025-06-03	X	AREA OF MINIMAL FLOOD HAZARD	142.0916	270.4888	215.5447						2026.2
0	23	019		EDDINGTON	ME	19180	PENOBSCOT	22535	EDDINGTON	009000	90	25453.4143	23019C	2025-06-03	X	1 PCT DRAINAGE AREA LESS THAN 1…	133.6900	143.2224	135.4016						2026.2
R12-10-C	23	019		PATTEN	ME	19520	PENOBSCOT	57150	PATTEN	029000	290	184235.3171	23019C	2025-06-03	AREA NOT INCLUDED		182.7422	217.4046	199.0133						2026.2
U4-23	23	019		PATTEN	ME	19520	PENOBSCOT	57150	PATTEN	029000	290	13211.7829	23019C	2025-06-03	AREA NOT INCLUDED		152.5444	157.9577	155.1067						2026.2
R12-16-B	23	019		PATTEN	ME	19520	PENOBSCOT	57150	PATTEN	029000	290	78646.2849	23019C	2025-06-03	AREA NOT INCLUDED		193.1054	259.7561	219.3213						2026.2