Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
37/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '31' AND countyfp = '017'
5,047 matching parcels
Data Preview
parcelid | taxacctnum | statefp | countyfp | parceladdr | parcelcity | parcelstate | parcelzip | ownername | owneraddr | ownercity | ownerstate | ownerzip | countyname | cousubfp | cousubname | tractce | tractname | calcarea | imprvalue | landvalue | agvalue | totalvalue | saleamt | saledate | numbldgs | numunits | yearbuilt | numfloors | bldgsqft | bedrooms | halfbaths | fullbaths | firmid | firmdate | fldzone | zonesubty | staticbfe | elevmin | elevmax | elevavg | usecode | usedesc | zoningcode | zoningdesc | taxacres | ownertype | naicscode | legaldesc | township | section | qtrsection | range | plssdesc | book | page | parceltype | accesstype | iucnclass | placename | placetype | fireplaces | heating | heatfuel | cooling | foundation | roofcover | siding | lrversion | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17_090088126 | 31 | 017 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 8148.8974 | 0 | 201600 | 0 | 201600 | 0 | 0 | — | 808.7200 | 830.2423 | 821.5699 | 05 | 221118 | 29N | 28 | 22W | S28 T29N R22W | NPPD AINSWORTH WIND FACILITY | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 17_090054210 | 31 | 017 | 87794 429TH AVE | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 24921.9813 | 3082490 | 21210 | 0 | 3103700 | 3 | 1 | — | 771.6402 | 774.0042 | 773.1275 | 03 | 30N | 27 | 22W | S27 T30N R22W | MADISONS GREAT WESTERN | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||
| 17_090011899 | 31 | 017 | 804 E 3RD ST | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 1016.0928 | 39765 | 7300 | 0 | 47065 | 1 | 1 | — | 766.6268 | 767.5601 | 767.0859 | 01 | 30N | 25 | 22W | S25 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090066286 | 31 | 017 | 26 30 23 | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 1311864.5373 | 299910 | 630380 | 0 | 930290 | 3 | 1 | — | 786.1421 | 791.1530 | 788.1747 | 05 | 30N | 26 | 23W | S26 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090021886 | 31 | 017 | 15 30 22 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 736273.9700 | 58420 | 607385 | 0 | 665805 | 1 | 1 | — | 765.9571 | 771.9393 | 769.7639 | 05 | 30N | 15 | 22W | S15 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090088965 | 31 | 017 | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 1278.5811 | 0 | 4470 | 0 | 4470 | 0 | 0 | — | 765.2675 | 766.0197 | 765.4787 | 01 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 17_090007174 | 31 | 017 | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 520.5270 | 17485 | 6440 | 0 | 23925 | 1 | 1 | — | 767.6165 | 767.8040 | 767.6915 | 03 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 17_090046390 | 31 | 017 | 29 30 23 | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 16182.5345 | 0 | 0 | 0 | 0 | 0 | 0 | — | 793.7380 | 803.4787 | 797.6542 | 05 | 30N | 29 | 23W | S29 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090035712 | 31 | 017 | 87896 MEADVILLE AVE | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 7866.1405 | 91670 | 18030 | 0 | 109700 | 1 | 1 | — | 753.5770 | 758.7518 | 756.4475 | 01 | 30N | 24 | 22W | S24 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090021916 | 31 | 017 | 42943 879TH RD | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 23293.9580 | 54685 | 30640 | 0 | 85325 | 1 | 1 | — | 770.7587 | 772.9158 | 771.2855 | 01 | 30N | 15 | 22W | S15 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090031172 | 31 | 017 | 19 30 21 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 7746.5972 | 0 | 7020 | 0 | 7020 | 0 | 0 | — | 765.0209 | 766.2108 | 765.5738 | 05 | 30N | 19 | 21W | S19 T30N R21W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090004566 | 31 | 017 | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 1549.6032 | 53225 | 27595 | 0 | 80820 | 1 | 1 | — | 768.6066 | 768.9335 | 768.7622 | 03 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 17_090088942 | 31 | 017 | 13575 LYNAM DR | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 197.7334 | 0 | 745 | 0 | 745 | 0 | 0 | — | 765.9539 | 768.8862 | 768.1795 | 01 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090079957 | 31 | 017 | 31 29 22 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 400676.6212 | 0 | 65615 | 0 | 65615 | 0 | 0 | — | 810.0592 | 836.3623 | 821.4068 | 05 | 29N | 31 | 22W | S31 T29N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090022238 | 31 | 017 | 42783 878TH RD | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 191833.0085 | 165435 | 110880 | 0 | 276315 | 2 | 1 | — | 777.1257 | 785.5882 | 781.2136 | 01 | 30N | 20 | 22W | S20 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090000757 | 31 | 017 | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 1818.2287 | 15090 | 32345 | 0 | 47435 | 1 | 1 | — | 766.2606 | 767.4735 | 767.0165 | 03 | 30N | 23 | 22W | S23 T30N R22W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 17_090003675 | 31 | 017 | 388 N WOODWARD ST | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 1128.0851 | 40015 | 7695 | 0 | 47710 | 2 | 1 | — | 768.6280 | 769.2420 | 768.9103 | 01 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090046285 | 31 | 017 | 18 30 23 | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 104871.9419 | 0 | 72300 | 0 | 72300 | 0 | 0 | — | 787.3436 | 801.0314 | 792.0303 | 01 | 30N | 18 | 23W | S18 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090018524 | 31 | 017 | 105 N CHURCH ST | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 3366.0977 | 40510 | 1485 | 0 | 41995 | 2 | 2 | — | 792.3927 | 793.2044 | 792.7150 | 01 | 30N | 18 | 23W | S18 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090048423 | 31 | 017 | 5 32 23 | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 121185.2281 | 0 | 17095 | 0 | 17095 | 0 | 0 | — | 711.2850 | 725.9376 | 719.4296 | 05 | 32N | 5 | 23W | S5 T32N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090047192 | 31 | 017 | 33 30 23 | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 162895.0596 | 0 | 28250 | 0 | 28250 | 0 | 0 | — | 792.7022 | 794.5188 | 793.4291 | 05 | 30N | 33 | 23W | S33 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090018605 | 31 | 017 | 103 N MAIN ST | NE | BROWN | 91555 | JOHNSTOWN | 975000 | 9750 | 936.7732 | 12395 | 1110 | 0 | 13505 | 1 | 1 | — | 792.7865 | 793.2716 | 792.9947 | 03 | 30N | 18 | 23W | S18 T30N R23W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090007387 | 31 | 017 | 342 N CEDAR ST | NE | BROWN | 90007 | AINSWORTH | 975000 | 9750 | 756.2029 | 170135 | 5635 | 0 | 175770 | 1 | 1 | — | 766.9980 | 767.9483 | 767.4346 | 01 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | ||||||||||||||||||||||||||||||||||||||||||||
| 17_090014499 | 31 | 017 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 601.2587 | 0 | 2625 | 0 | 2625 | 0 | 0 | — | 768.1780 | 768.7719 | 768.5061 | 01 | 30N | 26 | 22W | S26 T30N R22W | 2026.2 | 2024 | |||||||||||||||||||||||||||||||||||||||||||||
| 17_090023358 | 31 | 017 | 30 31 21 | NE | BROWN | 90010 | AINSWORTH | 975000 | 9750 | 627087.2753 | 0 | 442730 | 0 | 442730 | 0 | 0 | — | 733.8322 | 754.4810 | 748.3541 | 05 | 31N | 30 | 21W | S30 T31N R21W | 2026.2 | 2024 |