80 attribute fields, profiled from the November 2022 vintage.
Columns in Knox County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 71211, 71769, 71876 | |
| base_parce | OFTString | 381 | 118HE015, 118HE015, 118HE015 | |
| parcelid | OFTString | 50.0k | 137DA014, 137 215, 124ME033 | |
| parcel_sub | OFTInteger | 2 | 1, 1, 1 | |
| parcel_typ | OFTString | 13 | NORMAL, NORMAL, NORMAL | |
| pbaid | OFTInteger | 5.4k | 241892, 237430, 241010 | |
| base_par_1 | OFTString | 390 | 118HE015, 118HE015, 118HE015 | |
| parcelid_1 | OFTString | 50.0k | 137DA014, 137 215, 124ME033 | |
| cltmap | OFTString | 165 | 137, 137, 124 | |
| parcel_ins | OFTString | 16 | D, M, D | |
| parcel_gro | OFTString | 24 | A, E, A | |
| parcel | OFTReal | 5.0k | 14.0, 215.0, 33.0 | |
| condo_lett | OFTString | 26 | D, N, M | |
| parcel_sta | OFTString | 1 | Y, Y, Y | |
| parcel_t_1 | OFTString | 13 | NORMAL, NORMAL, NORMAL | |
| property_d | OFTString | 50.0k | 110 X 160, 136.81 X 291.41 X IRR, 96 X 120 | |
| subdivisio | OFTString | 46.1k | WOODFIELD PARK UNIT 1, CLARA EDITH CRUZE S/D, THE VILLAGE OF JOHN SEVIER | |
| tax_distri | OFTString | 52 | D9, D9, D9 | |
| landuse | OFTString | 131 | 101: 1-FAMILY, 101: 1-FAMILY, 101: 1-FAMILY | |
| tax_class | OFTString | 7 | R, R, R | |
| prev_parce | OFTString | 12.3k | 124 20001, 124 200, 137 331 | |
| next_parce | OFTString | 637 | 124MA009 & 00901, 137 225 & 22506, 137 23513 & 23525 | |
| loc_house_ | OFTReal | 10.7k | 408.0, 7621.0, 417.0 | |
| loc_hous_1 | OFTString | — | ||
| loc_street | OFTString | 8.9k | KARLA DR, MICHAELS LN, CONTENTMENT LN | |
| loc_unit | OFTString | 1.3k | A, WM, PS | |
| loc_stre_1 | OFTString | 5 | W, E, E | |
| loc_stre_2 | OFTString | — | ||
| loc_stre_3 | OFTString | 24 | DR, LN, LN | |
| loc_stre_4 | OFTString | 8.3k | KARLA, MICHAELS, CONTENTMENT | |
| recorded_a | OFTReal | 2.5k | 0.0, 0.0, 0.0 | |
| calculated | OFTReal | 2.5k | 0.0, 0.0, 0.0 | |
| loc_unit_t | OFTString | 6 | Suite, Apt, Utility | |
| sys_calc_a | OFTReal | 50.0k | 0.421152, 0.777387, 0.264393 | |
| square_fee | OFTReal | 50.0k | 18345.0, 33863.0, 11517.0 | |
| owner | OFTString | 50.0k | CASTRO JUNE & VICTOR ALVAREZ, CROCE FRANK & CROCE CHRISTINE, HAWN MARY B | |
| own_status | OFTString | 1 | ACTIVE, ACTIVE, ACTIVE | |
| own_type | OFTString | 1 | NORMAL, NORMAL, NORMAL | |
| date_purch | OFTString | — | ||
| purchase_p | OFTInteger | 18.0k | 259000, 93000, 288000 | |
| validity_f | OFTString | 2 | Z, Z, Z | |
| mail_house | OFTString | 11.0k | 408, 7621, 417 | |
| mail_unit | OFTString | 1.0k | STE 220, STE 100, STE 100 | |
| mail_stree | OFTString | 27.1k | KARLA DR, MICHAELS RD, CONTENTMENT LN | |
| mail_str_1 | OFTString | 4.2k | PO BOX 255, PO BOX 20031, PO BOX 23038 | |
| mail_city | OFTString | 2.0k | KNOXVILLE, KNOXVILLE, KNOXVILLE | |
| mail_state | OFTString | 57 | TN, TN, TN | |
| mail_zip_c | OFTString | 3.2k | 37920, 37920, 37920 | |
| mail_zip_1 | OFTInteger | 1.3k | 6023, 69, 9456 | |
| mail_count | OFTString | 7 | Czech Republic, Canada, United Kingdom | |
| odoc_page | OFTString | 50.0k | 0022640, 0000303, 0053686 | |
| recorded_d | OFTString | 16.1k | 2021-09-16, 1991-07-03, 2015-04-06 | |
| odoc_type | OFTString | 27 | WD:Special Warr, Deed:Deed, Deed:Deed | |
| odoc_book | OFTString | 8.8k | 20210916, 00002045, 20150406 | |
| sale_date | OFTString | 17.6k | 2021-09-13, 1991-07-03, 2015-03-31 | |
| odoc_statu | OFTString | 1 | ACTIVE, ACTIVE, ACTIVE | |
| deed_book | OFTString | 8.1k | 41S, M-70, 20071001 | |
| deed_page | OFTString | 11.3k | 10, -B, 0027860 | |
| pd_recorde | OFTString | 6.9k | 1776-08-01, 1776-08-01, 2007-10-01 | |
| status | OFTString | 1 | ACTIVE, ACTIVE, ACTIVE | |
| pdoc_type | OFTString | 2 | PLAT, PLAT, PLAT | |
| low_lot | OFTString | 3.6k | 5, 2, 33 | |
| high_lot | OFTString | 1.2k | 1, 1, 2R2 | |
| low_block | OFTString | 300 | C, C, 0000 | |
| high_block | OFTString | 66 | 1, 1, 1 | |
| appraised_ | OFTReal | 7.0k | 20000.0, 18000.0, 24000.0 | |
| appraise_1 | OFTReal | 12.3k | 228600.0, 39400.0, 254700.0 | |
| appraise_2 | OFTReal | 14.5k | 248600.0, 57400.0, 278700.0 | |
| assessed_t | OFTReal | 19.3k | 62150.0, 14350.0, 69675.0 | |
| mail_atten | OFTString | 1.5k | % MIKE RUTHERFORD VP SUBDIVISIONS, % MIKE RUTHERFORD VP SUBDIVISIONS, %CVS PHARMACY INC #3743 | |
| mail_deliv | OFTString | 50.0k | 408 KARLA DR, 7621 MICHAELS RD, 417 CONTENTMENT LN | |
| mail_addl_ | OFTString | 312 | BLDG D TAX DEPT 3178, BERRY HIGHLAND SOUTH 9625/9627, KNOXVILLE | |
| mail_del_1 | OFTString | 6.5k | KNOXVILLE, TN 37920, KNOXVILLE TN 37920, KNOXVILLE TN 37920 | |
| system_of_ | OFTString | 2 | IAS_WORLD, IAS_WORLD, IAS_WORLD | |
| full_addre | OFTString | 50.0k | 408 KARLA DR, 7621 MICHAELS LN, 417 CONTENTMENT LN | |
| full_mail_ | OFTString | 50.0k | 408 KARLA DR, 7621 MICHAELS RD, 417 CONTENTMENT LN | |
| full_mai_1 | OFTString | 312 | BLDG D TAX DEPT 3178, BERRY HIGHLAND SOUTH 9625/9627, KNOXVILLE | |
| full_mai_2 | OFTString | 6.5k | KNOXVILLE, TN 37920, KNOXVILLE TN 37920, KNOXVILLE TN 37920 | |
| area | OFTReal | 50.0k | 18345.323149322, 33862.8826186775, 11516.9232325276 | |
| len | OFTReal | 50.0k | 548.868886754695, 798.425017366227, 431.939206490049 |
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.