Aged
93 attribute fields, profiled from the August 2020 vintage.
Columns in Nicholas County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| cleanparce | OFTString | 24.1k | 34010003000200000000, 34010003000300000000, 34010003000400000000 | |
| pid | OFTString | 23.8k | 34010003000200000000, 34010003000300000000, 34010003000400000000 | |
| countyname | OFTString | 1 | Nicholas, Nicholas, Nicholas | |
| parcelid | OFTString | 23.8k | 01 3000200000000, 01 3000300000000, 01 3000400000000 | |
| districtco | OFTString | 9 | 1, 1, 1 | |
| districtna | OFTString | 9 | Beaver District, Beaver District, Beaver District | |
| map | OFTString | 147 | 0003, 0003, 0003 | |
| parcelnumb | OFTString | 428 | 0002, 0003, 0004 | |
| suffix | OFTString | 49 | 0000, 0000, 0000 | |
| legaldescr | OFTString | 21.9k | 3.2 ACS SUR BIG BEAVER, 3 SUR & R/W BIG BEAVER, 41.5 & R/W SUR BEAVER | |
| legaldes_1 | OFTString | 3.6k | 69.5 SUR BIG BEAVER, BEAVER CK, .15 AC SUR NR TIOGA | |
| legaldes_2 | OFTString | 1 | 102 ACS FARM | |
| fulllegald | OFTString | 22.5k | 3.2 ACS SUR BIG BEAVER, 3 SUR & R/W BIG BEAVER 69.5 SUR BIG BEAVER, 41.5 & R/W SUR BEAVER | |
| deededacre | OFTString | 6.6k | 3.2, 72.5, 41.5 | |
| calculated | OFTString | 23.6k | 3.354299, 69.196321, 40.277238 | |
| taxyear | OFTString | 1 | 2019, 2019, 2019 | |
| taxdistric | OFTString | 9 | 01, 01, 01 | |
| taxclass | OFTString | 3 | 3, 2, 2 | |
| deedbook | OFTString | 531 | 432, 319, 494 | |
| deedpage | OFTString | 880 | 223, 201, 501 | |
| propertycl | OFTString | 6 | R, F, F | |
| property_1 | OFTString | 6 | Residential, Farm, Farm | |
| owner1 | OFTString | 14.8k | CHAPMAN DAVID CRAIG, FARLEY HARRY C, MULLINS ELMER LEON & DELSIE | |
| owner2 | OFTString | 2.0k | SWEARINGEN, HUGHART LESA ROSE LIFE, HUGHART LESA ROSE LIFE | |
| fullownern | OFTString | 14.9k | CHAPMAN DAVID CRAIG, FARLEY HARRY C, MULLINS ELMER LEON & DELSIE SWEARINGEN | |
| owneraddre | OFTString | 1.2k | C/O ARCH LAND CO, C/O ARCH LAND CO, C/O NANCY THOMAS | |
| owneradd_1 | OFTString | 11.3k | P O BOX 854, 5691 TIOGA RD, 5539 TIOGA RD | |
| owneradd_2 | OFTString | 9.1k | SUMMERSVILLE WV 26651 0854, TIOGA WV 26691 4007, TIOGA, WV 26691 4008 | |
| ownercity | OFTString | 1.1k | SUMMERSVILLE, TIOGA, TIOGA, | |
| ownerstate | OFTString | 48 | WV, WV, WV | |
| ownerzipco | OFTString | 1.4k | 26651, 26691, 26691 | |
| careof | OFTString | — | ||
| fullownera | OFTString | 12.8k | P O BOX 854, SUMMERSVILLE, WV 26651, 5691 TIOGA RD, TIOGA, WV 26691, 5539 TIOGA RD, TIOGA,, WV 26691 | |
| newowner | OFTString | 390 | SHAFFER WALTER S JR, ROGERS JASON & MISTY, ROGERS JASON & MISTY | |
| newownerad | OFTString | 10 | TONY FRAME, C/O BRENDA HIBNER, C/O STEPHANIE JONES | |
| newowner_1 | OFTString | — | ||
| newowner_2 | OFTString | 180 | CLINTON OH 44216 9721, CALVIN WV 26660, CALVIN WV 26660 | |
| fullnewown | OFTString | 182 | CLINTON OH 44216 9721, CALVIN WV 26660, CALVIN WV 26660 | |
| newbook | OFTString | 11 | 521, 522, 522 | |
| newpage | OFTString | 326 | 108, 443, 441 | |
| physicalnu | OFTString | 706 | 260, 333, 3 | |
| physicaldi | OFTString | 6 | N, N, N | |
| physicalst | OFTString | 2.7k | ROUTE 3, ROUTE 3, RT.3 | |
| physicalsu | OFTString | 63 | ST, RD, RD | |
| physical_1 | OFTString | 4 | #, #, # | |
| physicalci | OFTString | 2 | CRAIGSVILLE, MT NEBO, MT NEBO | |
| physicalzi | OFTString | 1 | 26205 | |
| physical_2 | OFTString | — | ||
| fullphysic | OFTString | 4.5k | ROUTE 3, ROUTE 3, RT.3 | |
| occupancyd | OFTString | 81 | Residential Vacant, Active Farm, Active Farm | |
| hazardoccu | OFTString | 27 | UNK, AGR1, AGR1 | |
| landuse | OFTString | 82 | 100 - Residential Vacant, 112 - Active Farm, 112 - Active Farm | |
| landusecod | OFTString | 85 | 100, 112, 112 | |
| yearbuilt | OFTString | 155 | 1910, 1970, 1976 | |
| grade | OFTString | 22 | D, E, D- | |
| stylecode | OFTString | 12 | 01, 02, 02 | |
| styledescr | OFTString | 10 | Conventional, Ranch, Ranch | |
| commercial | OFTString | 5 | 1, 1, 2 | |
| stories | OFTString | 2 | 1, 1, 1 | |
| commerci_1 | OFTString | 1 | First Basement, First Basement, First Basement | |
| basementty | OFTString | 3 | Part, Full, Full | |
| exteriorwa | OFTString | 9 | Frame, Frame, Aluminum | |
| exterior_1 | OFTString | 11 | Concrete Block, Concrete Block, Metal, Sandwich | |
| constructi | OFTString | 4 | Wood frame/Joist/Beam, Wood frame/Joist/Beam, Wood frame/Joist/Beam | |
| totalrooms | OFTString | 21 | 0, 7, 4 | |
| usetype | OFTString | 174 | 47-Auto Parts or Service, 82-Multi-Use - Office, 43-Manufacturing, 82-Multi-Use - Office, 86-Support Area, 31-Restaurant | |
| businessli | OFTString | 524 | 1368, 6201, 87875 | |
| structurea | OFTString | 1.9k | 0, 1440, 640 | |
| cubicfeet | OFTString | 597 | 18144, 64818, 1677750 | |
| units | OFTString | 32 | 1, 1, 1 | |
| commerci_2 | OFTString | 2 | 1, 1, 1 | |
| camacard | OFTString | 3 | 0, 0, 0 | |
| cards | OFTString | 16 | 1, 1, 1 | |
| dwellingva | OFTString | 1.8k | 0, 26300, 8000 | |
| commerci_3 | OFTString | 570 | 0, 0, 0 | |
| otherbuild | OFTString | 2.3k | 0, 7930, 510 | |
| landapprai | OFTString | 1.1k | 2600, 23400, 42600 | |
| buildingap | OFTString | 2.1k | 0, 34200, 8500 | |
| totalappra | OFTString | 2.4k | 2600, 57600, 51100 | |
| samsaddres | OFTString | 11.3k | 5691 TIOGA RD, 5539 TIOGA RD, 638 ROCKHOUSE RD | |
| samscity | OFTString | 34 | TIOGA, TIOGA, TIOGA | |
| samsstate | OFTString | 4 | WV, WV, WV | |
| samszip | OFTString | 32 | 26691, 26691, 26691 | |
| preaddrnum | OFTString | 20 | 24, 165, 138 | |
| addrnum | OFTString | 3.4k | 5691, 5539, 638 | |
| addrnumsuf | OFTString | — | ||
| fullname | OFTString | 1.5k | TIOGA RD, TIOGA RD, ROCKHOUSE RD | |
| unittype | OFTString | 6 | TRLR, TRLR, TRLR | |
| unitid | OFTString | — | ||
| altunittyp | OFTString | 4 | BLDG, Utility, Landmark | |
| altunitid | OFTString | — | ||
| floodrisks | OFTString | 3 | High, High, Low | |
| obycount | OFTString | 25 | 0, 5, 1 |
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.