Aged
212 attribute fields, profiled from the April 2023 vintage.
Columns in Alamance County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid_1 | OFTInteger | 50.0k | 1, 2, 3 | |
| objectid | OFTInteger | 50.0k | 52300, 52018, 67351 | |
| gpin | OFTString | 50.0k | 8736927627, 8736935462, 8736945013 | |
| akpar_ | OFTString | 50.0k | 100395, 100396, 100397 | |
| pid | OFTString | 50.0k | 1-13-49, 1-13-1, 1-13-57 | |
| acres | OFTReal | 50.0k | 19.14830214, 3.3140094, 10.5423598 | |
| pin | OFTString | 50.0k | 100395, 100396, 100397 | |
| apprasialm | OFTReal | 529 | 873602.0, 873602.0, 873602.0 | |
| maint_date | OFTString | 2.0k | 2013-05-20, 2007-11-13, 2015-10-14 | |
| akrout | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| akowid | OFTString | 50.0k | 0668339, 0637235, 493074 | |
| akcoid | OFTString | 50.0k | 0720075, 0637235, 493074 | |
| ownam1 | OFTString | 50.0k | RAMSEUR CATTLE FARM LLC, SMITH GEORGE FRANKLIN SR HEIRS, SMITH GEORGE FRANKLIN JR | |
| ownam2 | OFTString | 21.9k | CHEEK LAUREN, FBO ELIZABETH T THORNBURG, NANCY T CHEEK | |
| owadr1 | OFTString | 50.0k | C/O HOLLY HICKS, ......, 3520 STALEY STORE ROAD | |
| owcity | OFTString | 1.3k | CINCINNATI, LIBERTY, LIBERTY | |
| owsta | OFTString | 70 | OH, NC, NC | |
| owzipa | OFTString | 7.7k | 45255, 27298, 27298 | |
| akpst_ | OFTReal | 7.3k | 0.0, 3557.0, 3573.0 | |
| akpssx | OFTString | 224 | K, B, B | |
| akpstn | OFTString | 3.0k | SILK HOPE LIBERTY, SILK HOPE LIBERTY, SILK HOPE LIBERTY | |
| akpdir | OFTString | 10 | S, S, S | |
| akpstp | OFTString | 27 | RD, RD, RD | |
| akpdsx | OFTString | 7 | EX, SW, SW | |
| akpun_ | OFTString | 382 | A, HK, 2 | |
| akacrd | OFTReal | 6.0k | 16.99, 0.0, 10.27 | |
| akacrm | OFTReal | 11.5k | 15.62, 3.31, 10.616 | |
| akdscd | OFTReal | 27 | 44.0, 44.0, 44.0 | |
| aktwcd | OFTReal | 14 | 101.0, 101.0, 101.0 | |
| xxddc1 | OFTString | 151 | VACANT LAND 10-19 ACRES, SINGLE FAMILY, VACANT LAND 10-19 ACRES | |
| akncls | OFTString | — | ||
| aknecd | OFTString | 984 | 01001, 01001, 01001 | |
| akexcd | OFTString | 28 | ****, ****, **** | |
| aklcfm | OFTReal | 33.9k | 48231.0, 46684.0, 87164.0 | |
| amdpge | OFTString | 2.1k | 0069, 0154, 993 | |
| amdbok | OFTString | 5.2k | 3680, 2303, 1392 | |
| jmtctm | OFTReal | 50.0k | 48231.0, 228809.0, 87164.0 | |
| akicfm | OFTReal | 50.0k | 0.0, 182125.0, 0.0 | |
| aklcpr | OFTReal | 33.5k | 48231.0, 46684.0, 87164.0 | |
| cakpsad | OFTString | 50.0k | SILK HOPE LIBERTY RD, 3557 SILK HOPE LIBERTY RD, 3573 SILK HOPE LIBERTY RD | |
| aktscf | OFTString | — | ||
| akgpar | OFTString | 50.0k | 8736927627, 8736935462, 8736945013 | |
| ckflag | OFTString | 1 | X, X, X | |
| aklad4 | OFTString | 405 | 57444, 57444, 57444 | |
| aklad3 | OFTString | 50.0k | 1-13-49, 1-13-1, 1-13-57 | |
| aklad2 | OFTString | 5.4k | LOTS 2 & 3, LT 5, LT 2 | |
| aklad1 | OFTString | 37.7k | SILK HOPE LIBERTY RD, SILK HOPE LIBERTY RD, SILK HOPE LIBERTY RD | |
| amqfcd | OFTString | 33 | E, E, P | |
| amdtsl | OFTReal | 8.8k | 20170719.0, 20111225.0, 20000525.0 | |
| akppge | OFTString | 647 | 0186, 0108, 0400 | |
| akpbok | OFTString | 207 | 049, 069, 064 | |
| akyrde | OFTInteger | 114 | 2017, 2011, 2000 | |
| xxqcds | OFTString | 25 | RELATIVES/RELATED PARTIES, RELATIVES/RELATED PARTIES, FORCED SALE OR AUCTION | |
| xxgnm2 | OFTString | 10.0k | BRISTOW SARAH, ROBINSON RONDA W, MOORE DIANNE C IRREVOC TRUST | |
| xxgnm1 | OFTString | 31.5k | MANNING JUDITH K, SMITH GEORGE F SR, UNKNOWN OWNER | |
| amidgr | OFTString | 34.3k | 44799, 443240, 0650453 | |
| cftxow | OFTReal | 50.0k | 378.61, 1796.15, 684.24 | |
| xxtxvl | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| xxtcas | OFTReal | 50.0k | 48231.0, 228809.0, 87164.0 | |
| akicas | OFTReal | 50.0k | 0.0, 182125.0, 0.0 | |
| aklcas | OFTReal | 33.3k | 48231.0, 46684.0, 87164.0 | |
| xxneds | OFTString | 926 | PATTERSON TOWNSHIP, PATTERSON TOWNSHIP, PATTERSON TOWNSHIP | |
| xxncds | OFTString | — | ||
| xxtwds | OFTString | 13 | PATTERSON, PATTERSON, PATTERSON | |
| xxdsds | OFTString | 26 | SNOW CAMP, SNOW CAMP, SNOW CAMP | |
| xxcuds | OFTString | — | ||
| amlcuc | OFTString | — | ||
| aencls | OFTString | — | ||
| xxlrds | OFTString | 4 | ACRES, ACRES, ACRES | |
| aelruf | OFTString | 48 | B, B, B | |
| aelrtp | OFTString | 4 | AC, AC, AC | |
| akfrt2 | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| akfrt1 | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| amvicd | OFTString | 2 | I, I, I | |
| xxgyn | OFTString | 2 | N, N, N | |
| xxbmyn | OFTString | 2 | N, N, N | |
| xxdpyn | OFTString | 2 | N, Y, N | |
| ahbed_ | OFTInteger | 11 | 0, 2, 0 | |
| ahbth_ | OFTString | 14 | 0.0, 2.0, 0.0 | |
| xxhads | OFTString | 16 | CENTRAL HEAT & COOL, CENTRAL HEAT ONLY, CENTRAL HEAT & COOL | |
| ahfnar | OFTReal | 6.2k | 0.0, 1616.0, 0.0 | |
| xxqgds | OFTString | 20 | AVERAGE QUALITY (C), AVERAGE QUALITY (C), FAIR QUALITY (D+) | |
| ahqgcd | OFTString | 20 | C, C, D+ | |
| xhhbth | OFTReal | 6 | 0.0, 0.0, 0.0 | |
| xgstpr | OFTReal | 367 | 0.0, 1.0, 0.0 | |
| amslam | OFTReal | 1.5k | 33000.0, 0.0, 0.0 | |
| akyear | OFTInteger | 1 | 2023, 2023, 2023 | |
| akrdc2 | OFTString | 79 | LUAUD, LUAUD, LUAUD | |
| xxddc2 | OFTString | 75 | LAND USE AUDIT, LAND USE AUDIT, LAND USE AUDIT | |
| akparp | OFTString | 1.5k | 100442, 171149, 100513 | |
| akmap_ | OFTString | 143 | 8736, 8736, 8736 | |
| aksmap | OFTString | 1 | 33, 33 | |
| akbloc | OFTString | 102 | 92, 93, 94 | |
| akparc | OFTString | 10.0k | 7627, 5462, 5013 | |
| akspar | OFTString | — | ||
| akplc_ | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| akcycd | OFTString | 28 | CNTY, CNTY, CNTY | |
| ownam3 | OFTString | 111 | C/O FLORENCE THOMPSON, DESAREE LUMPKIN, C/O PHIL EDWARDS | |
| owadr2 | OFTString | 3.3k | 533 HAMBLIN DRIVE, 810 WEST DAVIS STREET, 533 HAMBLIN DRIVE | |
| owadr3 | OFTString | 2 | SUITE 102, I | |
| owadr4 | OFTString | 38 | DIS/ELDERLY EXEMPT 50%, DIS/ELDERLY EXEMPTION, DISABLE VETERANS | |
| akrdc3 | OFTString | 6 | AGRI, MIX, WOOD | |
| xxddc3 | OFTString | 6 | AG CLASSIFICATION, MIXED USE CLASSIFICATION, FORESTRY CLASSIFICATION | |
| akrdc1 | OFTString | 158 | 502, 010, 502 | |
| aklrfm | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| aklrpr | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| akirfm | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| jmtrtm | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| akdbpr | OFTString | 27 | 1310, 440, 2264 | |
| akdppr | OFTString | 27 | 833, 277, 0523 | |
| amsali | OFTString | 100 | DD, DP, RE | |
| xxddc4 | OFTString | 402 | CLASS 57444, CLASS 57444, CLASS 57444 | |
| xxcyds | OFTString | 14 | ALAMANCE COUNTY, ALAMANCE COUNTY, ALAMANCE COUNTY | |
| aksccd | OFTInteger | 7 | 13, 13, 13 | |
| xxscds | OFTString | 6 | SOUTHERN, SOUTHERN, SOUTHERN | |
| akarcd | OFTInteger | 1 | 0, 0, 0 | |
| xxards | OFTString | — | ||
| xxsids | OFTString | 99 | WARRANTY DEED, DECEASED PERSON, REMAINDER | |
| aeqty1 | OFTReal | 6.8k | 1.0, 1.0, 1.0 | |
| xxluyn | OFTString | 2 | N, N, N | |
| ammltl | OFTString | 1 | MLT, MLT, MLT | |
| ahacyr | OFTInteger | 179 | 0, 1958, 0 | |
| ahcdbu | OFTString | — | ||
| xxbuds | OFTString | — | ||
| ahcdcu | OFTString | — | ||
| ahrdc1 | OFTString | 98 | 401, 04, 18 | |
| ahdesc | OFTString | 4.2k | RANCH, CONVENTIONAL, CONVENTIONAL | |
| agcpcd | OFTString | 212 | SB, SB, SB | |
| xxccds | OFTString | 73 | SITE BUILT, SITE BUILT, SITE BUILT | |
| ahdptb | OFTString | 65 | 6A, 6A, 6F | |
| xxhacd | OFTString | 13 | HC, CH, HC | |
| xxhaun | OFTReal | 5.2k | 0.0, 1616.0, 0.0 | |
| xxcomp | OFTInteger | 19 | 0, 100, 0 | |
| xxfmat | OFTString | 1 | FP, FP, FP | |
| xxbcpt | OFTString | — | ||
| xxgcpt | OFTString | 1 | AC, AC, AC | |
| ahacy2 | OFTInteger | 127 | 0, 0, 0 | |
| ahcdb2 | OFTString | — | ||
| xxbud2 | OFTString | — | ||
| ahcdc2 | OFTString | — | ||
| xxcud2 | OFTString | — | ||
| ah2rdc | OFTString | 58 | 353, 620, 17 | |
| ahdes2 | OFTString | 150 | CONVENTIONAL, OFFICE BLDG L/R 1-4S, MH - DOUBLE WIDE - REAL | |
| agcpc2 | OFTString | 100 | SB, 3531F, DW | |
| xxccd2 | OFTString | 49 | SITE BUILT, OFFICE BLDG L/R 1-4S, DOUBLE/MULTI-WIDE | |
| ahqgc2 | OFTString | 14 | D, C, C | |
| xxqgd2 | OFTString | 14 | FAIR QUALITY (D), AVERAGE QUALITY (C), AVERAGE QUALITY (C) | |
| ahdpt2 | OFTString | 38 | 6A, CAW, 3A | |
| ahfna2 | OFTReal | 928 | 0.0, 0.0, 0.0 | |
| xxhac2 | OFTString | 10 | HC, 01, HC | |
| xxhad2 | OFTString | 12 | CENTRAL HEAT & COOL, AC CENTRAL AIR, CENTRAL HEAT & COOL | |
| xxhau2 | OFTReal | 847 | 0.0, 0.0, 0.0 | |
| ahbth2 | OFTString | 7 | 0.0, 0.0, 0.0 | |
| ahbed2 | OFTInteger | 9 | 0, 0, 0 | |
| xxcom2 | OFTInteger | 10 | 0, 0, 0 | |
| xxfma2 | OFTString | 1 | FP, FP, FP | |
| xxfpy2 | OFTString | 2 | N, N, N | |
| xxbcp2 | OFTString | — | ||
| cxxbmy2 | OFTString | 2 | N, N, N | |
| xxgcp2 | OFTString | 1 | AC, AC, AC | |
| xxgyn2 | OFTString | 2 | N, N, N | |
| ahacy3 | OFTInteger | 102 | 0, 0, 0 | |
| ahcdb3 | OFTString | — | ||
| xxbud3 | OFTString | — | ||
| ahcdc3 | OFTString | — | ||
| xxcud3 | OFTString | — | ||
| ah3rdc | OFTString | 38 | 20, 336, 17 | |
| ahdes3 | OFTString | 80 | COLONIAL, CONTEMPORARY, RANCH | |
| agcpc3 | OFTString | 64 | SB, SB, SB | |
| xxccd3 | OFTString | 37 | SITE BUILT, SITE BUILT, SITE BUILT | |
| ahqgc3 | OFTString | 14 | D, E, C+ | |
| xxqgd3 | OFTString | 14 | FAIR QUALITY (D), POOR QUALITY (E), AVERAGE QUALITY (C+) | |
| ahdpt3 | OFTString | 28 | 6P, 6P, 6A | |
| ahfna3 | OFTReal | 379 | 0.0, 0.0, 0.0 | |
| xxhac3 | OFTString | 9 | UH, NO, HC | |
| xxhad3 | OFTString | 10 | UNIT HEAT ONLY, NO HEAT OR COOL, CENTRAL HEAT & COOL | |
| xxhau3 | OFTReal | 361 | 0.0, 0.0, 0.0 | |
| ahbth3 | OFTString | 6 | 0.0, 0.0, 0.0 | |
| ahbed3 | OFTInteger | 7 | 0, 0, 0 | |
| xxcom3 | OFTInteger | 9 | 0, 0, 0 | |
| xxfma3 | OFTString | 1 | FP, FP, FP | |
| xxfpy3 | OFTString | 2 | Y, N, N | |
| xxbcp3 | OFTString | — | ||
| xxbmy3 | OFTString | 2 | N, N, N | |
| xxgcp3 | OFTString | 1 | AC, AC, AC | |
| xxgyn3 | OFTString | 2 | N, N, Y | |
| ammlti | OFTString | 31 | 000, 001, 000 | |
| xxkey | OFTString | — | ||
| xxact | OFTString | — | ||
| xxacod | OFTString | — | ||
| xxacty | OFTString | — | ||
| xxpath | OFTString | — | ||
| xhhbt2 | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| xgstp2 | OFTReal | 32 | 0.0, 0.0, 0.0 | |
| xhhbt3 | OFTInteger | 4 | 0, 0, 0 | |
| xgstp3 | OFTReal | 15 | 0.0, 0.0, 0.0 | |
| xxlati | OFTString | — | ||
| xxlong | OFTString | — | ||
| xxtmfc | OFTReal | 50.0k | 0.0, 176247.0, 0.0 | |
| xxtifc | OFTReal | 10.9k | 0.0, 5878.0, 0.0 | |
| xxtmfr | OFTReal | 41.1k | 0.0, 78128.0, 0.0 | |
| xxtifr | OFTReal | 6.9k | 0.0, 0.0, 0.0 | |
| xxtmac | OFTReal | 50.0k | 0.0, 176247.0, 0.0 | |
| xxtiac | OFTReal | 10.9k | 0.0, 5878.0, 0.0 | |
| datesold | OFTString | 8.8k | 2017-07-19, 2011-12-25, 2000-05-25 | |
| datesoldte | OFTString | 8.8k | 20170719, 20111225, 20000525 | |
| akdtvs | OFTString | 2.2k | 20150601, 20150601, 20150601 | |
| akapin | OFTString | 83 | WJG, WJG, WJG | |
| yearvisite | OFTInteger | 40 | 2015, 2015, 2015 | |
| akrdc5 | OFTString | 6 | R, R, R | |
| starea() | OFTReal | 50.0k | 834096.70462714, 144357.671981811, 459223.356107074 | |
| stlength() | OFTReal | 50.0k | 4318.12145496581, 1587.79387683408, 3052.27107146868 |
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.