100 attribute fields, profiled from the March 2022 vintage.
Columns in Clinton County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 32.9k | 400340, 400342, 400351 | |
| distno | OFTInteger | 37 | 36, 36, 36 | |
| ctrlno | OFTReal | 21.9k | 18010.0, 18770.0, 18257.0 | |
| interests | OFTReal | 10 | 0.0, 0.0, 0.0 | |
| parcel_id | OFTString | 29.2k | 36-18010, 36-18770-14, 36-18257 | |
| lot | OFTString | 3.9k | 14, P/68, E | |
| digitized | OFTString | 2 | Y, Y, Y | |
| acreage | OFTReal | 9.0k | 0.264, 0.919, 0.53 | |
| address | OFTString | 15.6k | 531 E GUARDLOCK DR, 7 FETZER LN, 65 CIDER PRESS RD | |
| name | OFTString | 1.4k | GUARDLOCK, FETZER, CIDER PRESS | |
| snum | OFTReal | 3.1k | 0.0, 531.0, 7.0 | |
| edit_date | OFTString | 587 | 2010-05-21, 2016-05-18, 2010-09-29 | |
| plate | OFTString | 54 | 3, 1B, 4 | |
| block | OFTString | 93 | A, B, A | |
| lott | OFTString | 5.3k | S-4, 14, 44 | |
| mapnum | OFTString | 2 | 11/3/09, 11/3/09, 01-01-003-2 | |
| lrsn | OFTInteger | 21.9k | 18010, 18770, 18257 | |
| last_updat | OFTString | 2.9k | 2021-09-23, 2014-01-09, 2007-05-15 | |
| status | OFTString | 2 | A, A, A | |
| corporatio | OFTString | 11 | R, R, R | |
| neighborho | OFTInteger | 234 | 3605, 3602, 3604 | |
| property_c | OFTInteger | 55 | 110, 101, 101 | |
| propertyst | OFTString | 17.6k | MONSEY DR, 531 E GUARDLOCK DR, 7 FETZER LN | |
| propertyci | OFTString | 37 | WOODWARD TWP, WOODWARD TWP, WOODWARD TWP | |
| property_1 | OFTString | 1 | PA, PA, PA | |
| propertyzi | OFTString | 19 | 17745, 17745, 17745 | |
| ownername1 | OFTString | 16.2k | MASTERS DAVID L & SHARON L, CANDOR A CURTIN III ET AL, AUNGST ROBERT L JR | |
| ownername2 | OFTString | 1.3k | % RICK HOUSEKNECHT, JONES AMANDA, AVERY GAIL | |
| owneraddre | OFTString | 13.8k | 115 BEECH TREE LN, 531 E GUARDLOCK DR, 7 FETZER LN | |
| owneradd_1 | OFTString | 24 | PO BOX 343, PO BOX 142, PO BOX 486 | |
| ownercity | OFTString | 1.0k | LOCK HAVEN, LOCK HAVEN, LOCK HAVEN | |
| ownerstate | OFTString | 52 | PA, PA, PA | |
| ownerzip | OFTString | 1.4k | 17745, 17745, 17745 | |
| tax_bill_i | OFTString | 15.8k | 03-A -S -004, 1B-B -0013, 04-A -0044 | |
| platbook | OFTString | 1.4k | 1098, 2014, 0749 | |
| platpage | OFTString | 6.5k | 0096, 34, 0097 | |
| legal_acre | OFTReal | 6.4k | 0.2, 2.6, 0.581 | |
| land_asses | OFTInteger | 1.2k | 33900, 42100, 23500 | |
| imp_assess | OFTInteger | 2.9k | 0, 165000, 75500 | |
| total_asse | OFTInteger | 3.4k | 33900, 207100, 99000 | |
| total_mark | OFTInteger | 3.7k | 33900, 207100, 99000 | |
| zoning | OFTString | 44 | R-2, I, R-2 | |
| prefixdir | OFTString | 5 | E, N, E | |
| suff | OFTString | 40 | DR, LN, RD | |
| suffixdir | OFTString | 6 | REAR, REAR, REAR | |
| area | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| perimeter | OFTReal | 31.1k | 519.418, 1193.966, 649.995 | |
| globalid | OFTString | 32.9k | {9A53881C-062E-4B72-8AC2-F1BF79CF8534}, {D3A85910-CB5E-4B9F-81B4-5890DAA888F3}, {FFAB98A6-5F4D-4CD3-8065-36D3ED8D3347} | |
| shape_area | OFTReal | 32.8k | 11499.983998, 40018.91917, 23067.545817 | |
| shape_len | OFTReal | 32.7k | 519.418214, 1193.966532, 649.995718 | |
| parcel_i_1 | OFTString | 21.9k | 036 0018010, 036 0018770, 036 0018257 | |
| unformatte | OFTString | 21.9k | 036 0018010, 036 0018770, 036 0018257 | |
| parent_lrs | OFTInteger | 475 | 0, 0, 0 | |
| parent_par | OFTString | 481 | 036 0025387, 036 0018107, 036 0018135 | |
| county_num | OFTString | 1 | 01, 01, 01 | |
| township_n | OFTString | 1 | 001, 001, 001 | |
| district_n | OFTString | 4 | 18360, 18360, 18360 | |
| section_pl | OFTString | 24 | 20 & 21, 1, A | |
| routing_nu | OFTString | 654 | 45, 4, 35 | |
| tax_year | OFTInteger | 1 | 0, 0, 0 | |
| ownercount | OFTString | 1 | ex | |
| assoc_parc | OFTString | — | ||
| assemblage | OFTString | 23 | 036 0070015, 030 0070022, 024 0070054 | |
| reubasepar | OFTString | — | ||
| reval_neig | OFTInteger | 103 | 0, 0, 0 | |
| hmstd_code | OFTInteger | 2 | 0, 1, 1 | |
| assoc_name | OFTString | — | ||
| censustrac | OFTString | — | ||
| tax_legal_ | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| future_hms | OFTInteger | 2 | 0, 1, 1 | |
| last_inter | OFTInteger | 1 | 0, 0, 0 | |
| parcel_fla | OFTInteger | 3 | 16, 16, 16 | |
| eff_date | OFTInteger | 37 | 20081231, 20081231, 20081231 | |
| actual_lrs | OFTInteger | 1 | 0, 0, 0 | |
| par_base_f | OFTString | 2 | Y, Y, Y | |
| nei_rating | OFTString | 2 | F, F, AV | |
| contractow | OFTString | 64 | BURKETTS TRL PARK, CEMETERY, CEMETERY | |
| contract_1 | OFTString | — | ||
| contractad | OFTString | 2 | 515 CANAL ST, 5260 MAIN ST | |
| contract_2 | OFTString | — | ||
| contractci | OFTString | 1 | LOCK HAVEN | |
| contractst | OFTString | 1 | PA | |
| contractzi | OFTString | 1 | 17745 | |
| contractco | OFTString | — | ||
| value_allo | OFTString | — | ||
| nei_rati_1 | OFTString | — | ||
| tax_system | OFTInteger | 1 | 0, 0, 0 | |
| legal_sqft | OFTInteger64 | 6.7k | 8712, 0, 25308 | |
| reviewyear | OFTInteger | 2 | 1, 1, 1 | |
| parcel_i_2 | OFTString | 21.7k | 036 0018010, 036 0018770, 036 0018257 | |
| lrsn_1 | OFTInteger | 21.7k | 18010, 18770, 18257 | |
| update_use | OFTString | 7 | MANATRON, MANATRON, MANATRON | |
| land_marke | OFTInteger | 2.0k | 33900, 42100, 23500 | |
| imp_val | OFTInteger | 2.9k | 0, 165000, 75500 | |
| val_seq_no | OFTInteger | 3 | 0, 0, 0 | |
| eff_year | OFTInteger | 37 | 20081231, 20081231, 20081231 | |
| last_upd_1 | OFTString | 1.2k | 2008-06-25, 2008-06-25, 2008-06-25 | |
| change_rea | OFTString | 46 | 01, 01, 01 | |
| valuation_ | OFTString | 46 | Reassessment, Reassessment, Reassessment | |
| land_use_v | OFTInteger | 558 | 0, 0, 0 |
Why this differs from the next county over
There is no national parcel schema. Every assessor's office built its own, usually decades ago, usually inside whatever CAMA system it bought at the time. One county's owner column is OWNER_NAME, the next one's is own1, and a third splits it across four fields. Shapefile's ten-character DBF limit truncated a generation of them into things like TOTLNDVAL.
Nothing here is renamed or remapped. The columns above are exactly what is in the file, because a normalisation layer that quietly guesses wrong is worse than no normalisation at all — and every guess it makes is one you cannot audit.
The Filled column is the share of rows with a real value. Placeholder text such as n/a counts as empty; a column that is 100% present but 90% placeholder is a column that will disappoint you, and the profiler treats it accordingly.