20 attribute fields, profiled from the July 2020 vintage.
Columns in Campbell County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| id | OFTReal | 22.5k | 286045.0, 286046.0, 286047.0 | |
| taxyear | OFTString | 1 | 2020, 2020, 2020 | |
| parcelnb | OFTString | 20.0k | 50721430700100, 50721441700300, 50721441700200 | |
| accountno | OFTString | 18.1k | R0000143, R0000144, R0000148 | |
| jurisdicti | OFTString | 1 | CAMPBELL, CAMPBELL, CAMPBELL | |
| ownername1 | OFTString | 15.0k | GERDES VALERIE, BARBOUR SETH T & ROSEY M, BAKER JOHN H & VIVIAN FAMILY TRUST | |
| ownername2 | OFTString | 1.2k | CALDWELL GAYLE ATTN CALDWELL GAYLE, HUTCHINSON WENDY, ATTN BERNADETTE L BARLOW TRUSTEE | |
| mailaddres | OFTString | 13.1k | 3211 ALBERTA DR, 6023 JAMESTOWN CT APT B, 1207 WAGONHAMMER LN | |
| mailcity | OFTString | 623 | GILLETTE, EVANSVILLE, GILLETTE | |
| mailstate | OFTString | 49 | WY, IN, WY | |
| mailzipcod | OFTString | 6.6k | 827186218, 477153459, 827164767 | |
| locationad | OFTString | 17.0k | 3211 ALBERTA DR, 4 SAGE CT, 1207 WAGONHAMMER LN | |
| legal | OFTString | 17.8k | SUTHERLAND EST PH II, LOT 19 BLOCK 11, SIERRA GLEN ADD, LOT 10, SAUNDERS SUB 1ST EXT, LOT 32 | |
| actualvalu | OFTReal | 16.7k | 0.0, 0.0, 0.0 | |
| assessedva | OFTReal | 13.5k | 0.0, 0.0, 0.0 | |
| landgrossa | OFTReal | 8.1k | 0.0, 0.0, 0.0 | |
| landgrosss | OFTReal | 10.3k | 0.0, 0.0, 0.0 | |
| defaulttax | OFTString | 57 | 0150, 0150, 0150 | |
| shape__are | OFTReal | 19.3k | 2500.808594, 2920.527344, 1801.269531 | |
| shape__len | OFTReal | 20.2k | 203.075153, 343.080181, 220.337574 |
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.