Aged
96 attribute fields, profiled from the January 2022 vintage.
Columns in McDowell County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| pid | OFTString | 30.0k | 27010001000100000000, 27010001000200000000, 27010001000300000000 | |
| id | OFTString | 30.0k | 317364, 316413, 285970 | |
| cleanparce | OFTString | 30.0k | 27010001000100000000, 27010001000200000000, 27010001000300000000 | |
| countycode | OFTString | 1 | 27, 27, 27 | |
| countyname | OFTString | 1 | McDowell, McDowell, McDowell | |
| parcelid | OFTString | 30.0k | 01 1000100000000, 01 1000200000000, 01 1000300000000 | |
| districtco | OFTString | 16 | 1, 1, 1 | |
| districtna | OFTString | 16 | Adkin District, Adkin District, Adkin District | |
| map | OFTString | 262 | 0001, 0001, 0001 | |
| parcelnumb | OFTString | 606 | 0001, 0002, 0003 | |
| suffix | OFTString | 26 | 0000, 0000, 0000 | |
| legaldescr | OFTString | 29.1k | FEE TR 15 LECKIE TRUCK FARMS, FEE TR 16 LECKIE TRUCK FARMS, LOT 17 LECKIE TRUCK FARMS | |
| legaldes_1 | OFTString | 3.2k | STORAGE, FARMS, FARMS | |
| legaldes_2 | OFTString | 238 | STORAGE, (INC L10 TO 19 & 29 TO 68), (INC L10 TO 19 & 29 TO 68) | |
| fulllegald | OFTString | 29.4k | FEE TR 15 LECKIE TRUCK FARMS, FEE TR 16 LECKIE TRUCK FARMS, LOT 17 LECKIE TRUCK FARMS | |
| deededacre | OFTString | 5.3k | 3.21, 2.1, 1.27 | |
| calculated | OFTString | 29.6k | 3.05293039, 2.0586448, 1.233297 | |
| taxyear | OFTString | 1 | 2021, 2021, 2021 | |
| taxdistric | OFTString | 20 | 01, 01, 01 | |
| taxclass | OFTString | 3 | 3, 3, 2 | |
| deedbook | OFTString | 1.0k | 0462, 0462, 530 | |
| deedpage | OFTString | 1.8k | 0279, 0279, 608 | |
| propertycl | OFTString | 7 | R, R, R | |
| property_1 | OFTString | 7 | Residential, Residential, Residential | |
| owner1 | OFTString | 13.9k | BAILEY ERIN, BAILEY ERIN, BAILEY JAMES SR & | |
| owner2 | OFTString | 2.1k | JAMES JR, JAMES JR, JAMES JR | |
| fullownern | OFTString | 14.1k | BAILEY ERIN, BAILEY ERIN, BAILEY JAMES SR & JAMES JR | |
| owneraddre | OFTString | 2.0k | HAROLD & MOZELLE WARD, HAROLD & MOZELLE WARD, HASS KRISTINA | |
| owneradd_1 | OFTString | 6.9k | HC 71 BOX 400, HC 71 BOX 400, 167 PUNCHEON CAMP RD | |
| owneradd_2 | OFTString | 7.8k | LECKIE WV 24856 7732, LECKIE WV 24856 7732, ANAWALT WV 24808 8549 | |
| ownercity | OFTString | 1.2k | LECKIE, LECKIE, ANAWALT | |
| ownerstate | OFTString | 50 | WV, WV, WV | |
| ownerzipco | OFTString | 1.5k | 24856, 24856, 24808 | |
| careof | OFTString | — | ||
| fullownera | OFTString | 11.2k | HC 71 BOX 400, LECKIE, WV 24856, HC 71 BOX 400, LECKIE, WV 24856, 167 PUNCHEON CAMP RD, ANAWALT, WV 24808 | |
| newowner | OFTString | 111 | LESTER WILLIAM CASEY &, LESTER WILLIAM CASEY &, LESTER WILLIAM CASEY & | |
| newownerad | OFTString | 107 | 12276 SKYGUSTY HWY, 12276 SKYGUSTY HWY, 12276 SKYGUSTY HWY | |
| newowner_1 | OFTString | — | ||
| newowner_2 | OFTString | 102 | WELCH WV 24801 6239, WELCH WV 24801 6239, WELCH WV 24801 6239 | |
| fullnewown | OFTString | 108 | 12276 SKYGUSTY HWY, WELCH WV 24801 6239, 12276 SKYGUSTY HWY, WELCH WV 24801 6239, 12276 SKYGUSTY HWY, WELCH WV 24801 6239 | |
| newbook | OFTString | 28 | 0624, 0624, 0624 | |
| newpage | OFTString | 123 | 0403 , 0403 , 0403 | |
| physicalnu | OFTString | 740 | 33, 91, 0 | |
| physicaldi | OFTString | 9 | E, S, S | |
| physicalst | OFTString | 1.7k | LECKIE FARMS, LECKIE FARM, LECKIE TRUCK FARMS | |
| physicalsu | OFTString | 47 | TRAK, TRAK, TRAK | |
| physical_1 | OFTString | 5 | #, LOT, # | |
| physicalci | OFTString | 35 | ANAWALT, V RAE LIVES ON 1-334-15, V RAE LIVES HERE | |
| physicalzi | OFTString | 17 | 24701, 24808, 24808 | |
| physical_2 | OFTString | — | ||
| fullphysic | OFTString | 3.6k | LECKIE FARMS TRAK, LECKIE FARM TRAK, LECKIE TRUCK FARMS | |
| occupancyd | OFTString | 86 | Residential Vacant, Residential Vacant, Residential Vacant | |
| hazardoccu | OFTString | 28 | UNK, UNK, UNK | |
| landuse | OFTString | 86 | 100 - Residential Vacant, 100 - Residential Vacant, 100 - Residential Vacant | |
| landusecod | OFTString | 90 | 100, 100, 100 | |
| yearbuilt | OFTString | 130 | 1950, 1951, 1934 | |
| grade | OFTString | 17 | D, D, E- | |
| stylecode | OFTString | 10 | 01, 01, 01 | |
| styledescr | OFTString | 10 | Conventional, Conventional, Conventional | |
| commercial | OFTString | 8 | 2, 1, 1 | |
| stories | OFTString | 3 | 1, 1, 1 | |
| commerci_1 | OFTString | 1 | First Basement, First Basement, First Basement | |
| basementty | OFTString | 3 | Crawl, Full, Part | |
| exteriorwa | OFTString | 9 | Frame, Asbestos, Frame | |
| exterior_1 | OFTString | 12 | Frame, Frame, Brick or Stone | |
| constructi | OFTString | 4 | Wood frame/Joist/Beam, Wood frame/Joist/Beam, Wood frame/Joist/Beam | |
| totalrooms | OFTString | 18 | 0, 0, 0 | |
| usetype | OFTString | 141 | 34-Retail Store, 34-Retail Store, 53-Office Building | |
| businessli | OFTString | 494 | 1680, 576, 702 | |
| structurea | OFTString | 1.5k | 0, 0, 0 | |
| cubicfeet | OFTString | 532 | 16800, 4608, 5616 | |
| units | OFTString | 17 | 0, 0, 0 | |
| commerci_2 | OFTString | 5 | 1, 1, 1 | |
| camacard | OFTString | — | ||
| cards | OFTString | 16 | 1, 1, 1 | |
| dwellingva | OFTString | 653 | 0, 0, 0 | |
| commerci_3 | OFTString | 402 | 0, 0, 0 | |
| otherbuild | OFTString | 1.9k | 0, 0, 0 | |
| landapprai | OFTString | 457 | 500, 300, 200 | |
| buildingap | OFTString | 899 | 0, 0, 0 | |
| totalappra | OFTString | 1.0k | 500, 300, 200 | |
| samsaddres | OFTString | 12.0k | 65 PUNCHEON CAMP BRANCH RD, 77 PUNCHEON CAMP BRANCH RD, 109 PUNCHEON CAMP BRANCH RD | |
| samscity | OFTString | 16 | Welch, Welch, Welch | |
| samsstate | OFTString | 1 | WV, WV, WV | |
| samszip | OFTString | 15 | 24801, 24801, 24801 | |
| preaddrnum | OFTString | — | ||
| addrnum | OFTString | 4.1k | 65, 77, 109 | |
| addrnumsuf | OFTString | — | ||
| fullname | OFTString | 1.5k | PUNCHEON CAMP BRANCH RD, PUNCHEON CAMP BRANCH RD, PUNCHEON CAMP BRANCH RD | |
| unittype | OFTString | 1 | TRLR, TRLR, TRLR | |
| unitid | OFTString | 2 | 2, STE 100 | |
| altunittyp | OFTString | 1 | NoUnit, NoUnit, NoUnit | |
| altunitid | OFTString | — | ||
| floodrisks | OFTString | 3 | Low, Low, Low | |
| obycount | OFTString | 17 | 0, 0, 0 | |
| ppid | OFTString | 30.0k | 27010001000100000000, 27010001000200000000, 27010001000300000000 |
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.