Aged
117 attribute fields, profiled from the February 2022 vintage.
Columns in Amherst County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 26.0k | 16587, 17921, 17922 | |
| map | OFTString | 157 | 160, 160, 160 | |
| ins | OFTString | 25 | A3, A3, A3 | |
| dc | OFTString | 24 | A, A, A | |
| blk | OFTString | 16 | D, D, D | |
| lot | OFTString | 326 | 161, 140, 141 | |
| sublot | OFTString | 29 | A, A, A | |
| gpin | OFTString | 1 | 3702-88-1662, 3702-88-1662, 3702-88-1662 | |
| map_no | OFTString | 19.7k | 160A3 A 161, 160A3 A 140, 160A3 A 141 | |
| mtota | OFTInteger | 2.6k | 0, 880, 0 | |
| mrecno | OFTInteger | 19.6k | 20016, 12972, 12030 | |
| mdwell | OFTInteger | 40 | 1, 1, 1 | |
| mlnam | OFTString | 14.7k | WHITMORE KELLY, MEADOWS REBECCA LYNNE, OSMENT MICHAEL | |
| mfnam | OFTString | 1.8k | C/O VALERIA CHAMBERS, C/O RICHARD & JOANNE WARRICK, C/O LOVIE PETERS | |
| mage | OFTInteger | 207 | 0, 71, 0 | |
| m_dunt | OFTInteger | 15 | 0, 0, 0 | |
| m_room | OFTInteger | 32 | 0, 4, 0 | |
| m_br | OFTInteger | 24 | 0, 2, 0 | |
| m_fbth | OFTInteger | 22 | 0, 1, 0 | |
| m_hbth | OFTInteger | 14 | 0, 0, 0 | |
| mac | OFTString | 3 | Y, Y, Y | |
| mekit | OFTInteger | 6 | 0, 0, 0 | |
| mpbfin | OFTString | 93 | 0, 0, 0 | |
| mbrate | OFTString | 28 | 0, 0, 0 | |
| mgar_c | OFTInteger | 8 | 0, 0, 0 | |
| mcar_c | OFTInteger | 4 | 0, 0, 0 | |
| mbi_c | OFTInteger | 6 | 0, 0, 0 | |
| mgas | OFTString | 2 | N, N, N | |
| melec | OFTString | 2 | N, Y, N | |
| motdes | OFTString | 163 | VIEW, BACK LAND, SOME RIVER FRONT | |
| mimprv | OFTInteger | 3.4k | 0, 19100, 0 | |
| mtotld | OFTInteger | 2.4k | 65000, 10000, 6000 | |
| mtotpr | OFTInteger | 4.3k | 65000, 29100, 6000 | |
| m1frnt | OFTString | 19 | 0, 0, 0 | |
| m1dpth | OFTString | 26 | 0, 0, 0 | |
| m1area | OFTInteger | 331 | 0, 0, 0 | |
| mmcode | OFTInteger | 23 | 1, 1, 1 | |
| m1um | OFTString | 2 | S, S, S | |
| m2frnt | OFTString | 1 | 0, 0, 0 | |
| m2dpth | OFTString | 1 | 0, 0, 0 | |
| m2area | OFTInteger | 7 | 0, 0, 0 | |
| m2um | OFTString | 2 | S, S, S | |
| m1dfac | OFTString | 1 | 0, 0, 0 | |
| mdesc1 | OFTString | 14.8k | ON LAYNE ST RT 1006, ON SECOND STREET, 101 MAIN ST 66 X 105 FT | |
| mdesc2 | OFTString | 5.8k | SEE PLAT CAB 2-317, SEE DB 256-241, 75 X 130 X 73 | |
| mdesc3 | OFTString | 1.4k | 98' X 151' SEE DB 87-360, 1089-735, 1.70001618170003E+17 | |
| mdesc4 | OFTString | 19.6k | 160A3 A 161, 160A3 A 140, 160A3 A 141 | |
| msellp | OFTInteger | 2.1k | 0, 26000, 3195 | |
| m2dfac | OFTString | 1 | 0, 0, 0 | |
| mtbv | OFTInteger | 5.4k | 0, 68754, 0 | |
| mtbas | OFTInteger | 2.6k | 0, 11520, 0 | |
| mtfbas | OFTInteger | 1.5k | 0, 0, 0 | |
| mtplum | OFTInteger | 24 | 0, -2000, 0 | |
| mtheat | OFTInteger | 515 | 0, 0, 0 | |
| mtac | OFTInteger | 2.8k | 0, 2200, 0 | |
| mtfp | OFTInteger | 20 | 0, 0, 0 | |
| mtfl | OFTInteger | 12 | 0, 0, 0 | |
| mtbi | OFTInteger | 6 | 0, 0, 0 | |
| mttadd | OFTInteger | 5.9k | 0, 7140, 0 | |
| mpsf | OFTString | 2.0k | 0, 78.13, 0 | |
| myrblt | OFTInteger | 207 | 0, 1949, 0 | |
| masslu | OFTInteger | 903 | 0, 0, 0 | |
| m1adj | OFTString | 26 | 0, 0, 0 | |
| m2adj | OFTString | 2 | 0, 0, 0 | |
| m1rate | OFTString | 22 | 0, 0, 0 | |
| m2rate | OFTString | 6 | 0, 0, 0 | |
| macre_ | OFTString | 7.0k | 0.7, 0.462, 0 | |
| mtbimp | OFTInteger | 2 | 0, 0, 0 | |
| mfp_ | OFTInteger | 9 | 0, 0, 0 | |
| msfp_ | OFTInteger | 5 | 0, 0, 0 | |
| mfl_ | OFTInteger | 5 | 0, 0, 0 | |
| msfl_ | OFTInteger | 3 | 0, 0, 0 | |
| mmfl_ | OFTInteger | 3 | 0, 0, 0 | |
| miofp_ | OFTInteger | 7 | 0, 0, 0 | |
| mstor_ | OFTString | 61 | 0, 1, 0 | |
| mbasement | OFTString | 1.7k | 0, 768, 0 | |
| mfinshbmnt | OFTString | 1.2k | 0, 0, 0 | |
| mzone | OFTString | 8 | Residential - General, Residential - General, Residential - General | |
| mcond | OFTString | 4 | Poor, Good, Average | |
| mclass | OFTString | 6 | Below average, Average, Below average | |
| mfound | OFTString | 11 | Cinderblock, Cinderblock, Cinderblock | |
| mexwll | OFTString | 19 | Vinyl, Vinyl, Asbestos | |
| mrooft | OFTString | 5 | Gable, Gable, Gable | |
| mroofg | OFTString | 13 | Comp. Shingle, Comp. Shingle, Metal | |
| mheat | OFTString | 10 | Heat Pump, Heat Pump, Heat Pump | |
| mfuel | OFTString | 6 | Electric, Electric, Electric | |
| mgart | OFTString | 12 | Vinyl, Detached, Detached | |
| mcarpt | OFTString | 2 | Open, Open, Open | |
| mrow | OFTString | 2 | PUBLIC, PUBLIC, PUBLIC | |
| mease | OFTString | 3 | PAVED, PAVED, PAVED | |
| mwater | OFTString | 6 | Public, Public, Public | |
| msewer | OFTString | 4 | Septic, Public, Public | |
| mterrn | OFTString | 3 | ON, ON, ON | |
| mchar | OFTString | 8 | ROLLING/SLOPING, ROLLING/SLOPING, ROLLING/SLOPING | |
| mmagcd | OFTString | 20 | SA, SA, SA | |
| minwll | OFTString | 27 | Paneled, Drywall, Plaster | |
| mfloor | OFTString | 34 | Wood, Carpet, Carpet, Vinyl, Wood | |
| moccup | OFTString | 14 | Vacant Residential, Dwelling, Vacant Residential | |
| mbastp | OFTString | 8 | Crawl Space, Cellar, Cellar | |
| mluse | OFTString | 13 | Single Family Residential - Suburban, Single Family Residential - Suburban, Single Family Residential - Suburban | |
| gnogas | OFTReal | 4 | 1.0, 1.0, 1.0 | |
| parceladdr | OFTString | 14.0k | 144 SECOND ST, 111 STUMPS HILL RD, 121 STUMPS HILL RD | |
| parcelad_1 | OFTString | 85 | MADISON HEIGHTS, VA 24572, MADISON HEIGHTS, VA 24572, MADISON HEIGHTS, VA 24572 | |
| depreciate | OFTReal | 12.0k | 0.0, -68996.0, 0.0 | |
| owneraddre | OFTString | 12.2k | 117 LAYNE ST, P O BOX 11612, 439 MAIN ST | |
| owneradd_1 | OFTString | 977 | MADISON HEIGHTS, VA 24572, LYNCHBURG, VA 24506, MADISON HEIGHTS, VA 24572 | |
| uniqueid | OFTString | 26.0k | ID16587, ID17921, ID17922 | |
| deedbookpa | OFTString | 12.6k | 0, 0, 0 | |
| willbookpa | OFTString | 318 | 0, 0, 0 | |
| platbookpa | OFTString | 5.8k | 0, 703 401, 0 | |
| totalminer | OFTString | 3 | 0 0, 0 0, 0 0 | |
| assessedye | OFTString | 322 | 1/1/2020, 1/1/2020, 1/1/2020 | |
| recordedda | OFTString | 6.2k | 2018-04-13, 2017-08-17, 2020-03-03 | |
| kitchenval | OFTInteger | 6 | 0, 0, 0 | |
| imagename | OFTString | 20.0k | 20016_1.jpg, 12972_1.jpg, 12030_1.jpg | |
| instrument | OFTString | 4.0k | 180000989, DE 170002432, DE 200000713 | |
| gis_accoun | OFTString | 25.2k | 160A3 A 161, 160A3 A 140, 160A3 A 141 |
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.