62 attribute fields, profiled from the February 2024 vintage.
Columns in Shelby County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 31.6k | 18760, 18761, 18961 | |
| pin | OFTString | 31.2k | 262425300002, 262425400001, 282425400003 | |
| extractid | OFTReal | 1 | 4605.0, 4605.0, 4605.0 | |
| parcelnumb | OFTString | 31.2k | 26-2425300.002, 26-2425400.001, 28-2425400.003 | |
| pindash | OFTString | 31.2k | 26-24-25-300-002, 26-24-25-400-001, 28-24-25-400-003 | |
| parcelnu_1 | OFTString | 31.2k | 262425300002, 262425400001, 282425400003 | |
| taxyear | OFTReal | 1 | 2023.0, 2023.0, 2023.0 | |
| districtco | OFTReal | 65 | 26.0, 26.0, 28.0 | |
| districtna | OFTString | 58 | LORAMIE TWP HHSD HAD RFD, LORAMIE TWP HHSD HAD RFD, LORAMIE TWP HHSD HAD RFD | |
| district | OFTString | 65 | 26-LORAMIE TWP HHSD HAD RFD, 26-LORAMIE TWP HHSD HAD RFD, 28-LORAMIE TWP HHSD HAD RFD | |
| landusecod | OFTReal | 74 | 111.0, 111.0, 110.0 | |
| landusenam | OFTString | 74 | SINGLE FAMILY DWELLING, SINGLE FAMILY DWELLING, SINGLE FAMILY DWELLING | |
| landuse | OFTString | 74 | 510-SINGLE FAMILY DWELLING, 510-SINGLE FAMILY DWELLING, 510-SINGLE FAMILY DWELLING | |
| class | OFTString | 5 | Agriculture, Agriculture, Agriculture | |
| schooldist | OFTString | 15 | HARDIN-HOUSTON LSD, HARDIN-HOUSTON LSD, HARDIN-HOUSTON LSD | |
| p_acres | OFTReal | 7.4k | 78.5, 78.5, 5.005 | |
| listedname | OFTString | 18.1k | MEYER ROGER H, MEYER ROGER H, POHLMAN MARILYN R SUCC TRUSTEE & MARILYN R TRUSTEE | |
| deedvolume | OFTString | 1.7k | 1959, 1959, 2271 | |
| deedpage | OFTString | 3.4k | 74, 74, 253 | |
| considerat | OFTReal | 2.6k | 0.0, 0.0, 0.0 | |
| validsale | OFTString | 2 | False, False, False | |
| appraisedl | OFTReal | 10.6k | 614150.0, 637190.0, 38660.0 | |
| appraisedi | OFTReal | 14.7k | 168610.0, 140750.0, 0.0 | |
| appraisedt | OFTReal | 20.1k | 782760.0, 777940.0, 38660.0 | |
| taxablelan | OFTReal | 9.3k | 242820.0, 235570.0, 14480.0 | |
| taxableimp | OFTReal | 14.7k | 168610.0, 140750.0, 0.0 | |
| taxabletot | OFTReal | 19.0k | 411430.0, 376320.0, 14480.0 | |
| hascauv | OFTString | 2 | YES, YES, YES | |
| hasexempti | OFTString | 2 | NO, NO, NO | |
| hasabateme | OFTString | 2 | NO, NO, NO | |
| currenttax | OFTReal | 27.0k | 5931.94, 4835.0, 222.8 | |
| priortax | OFTReal | 340 | 0.0, 0.0, 0.0 | |
| paid | OFTReal | 18.9k | 2965.98, 2417.51, 111.41 | |
| hascontrac | OFTString | 2 | NO, NO, NO | |
| legaldescr | OFTString | 31.2k | R04 T10 S25 E 1/2 SW QR 185-24-25-300-002, R04 T10 S25 W 1/2 SE QR 185-24-25-400-001, R05 T09 S29 SW QR EX 3A 180-25-29-300-001 | |
| locationad | OFTString | 20.6k | 2377 MIAMI SHELBY RD, 2727 MIAMI SHELBY RD, MIAMI SHELBY RD | |
| townshipde | OFTString | 14 | LORAMIE, LORAMIE, LORAMIE | |
| dateconvey | OFTString | 6.6k | 2014-07-10, 2014-07-10, 2021-02-18 | |
| dateastext | OFTString | 6.6k | 07/10/2014, 07/10/2014, 02/18/2021 | |
| propertyid | OFTString | 31.2k | 21299, 21300, 21503 | |
| photofilen | OFTString | 8.8k | 262425300002-1.jpg, 262425400001-1.jpg, 282425400005-1.jpg | |
| photourl | OFTString | 8.8k | ||
| plat | OFTString | 7.8k | PLAT V26 P51, PLAT V26 P51, PLAT V26 P51 | |
| locationci | OFTString | 16 | HOUSTON OH 45333, HOUSTON OH 45333, HOUSTON OH 45333 | |
| cityvillag | OFTString | 9 | LOCKINGTON, LOCKINGTON, LOCKINGTON | |
| parcel_id | OFTString | 31.2k | 21299, 21300, 21503 | |
| pid | OFTString | 31.2k | 26-2425300.002, 26-2425400.001, 28-2425400.003 | |
| legal | OFTString | 31.2k | R04 T10 S25 E 1/2 SW QR 185-24-25-300-002, R04 T10 S25 W 1/2 SE QR 185-24-25-400-001, R05 T09 S29 SW QR EX 3A 180-25-29-300-001 | |
| o_acres | OFTString | 7.4k | 78.5000, 78.5000, 5.0050 | |
| land_use | OFTString | 74 | 510-SINGLE FAMILY DWELLING, 510-SINGLE FAMILY DWELLING, 510-SINGLE FAMILY DWELLING | |
| sale_date | OFTString | 6.6k | 07/10/2014, 07/10/2014, 02/18/2021 | |
| sale_amt | OFTString | 2.6k | 0.00, 0.00, 0.00 | |
| volpage | OFTString | 21.3k | 1959 / 74, 1959 / 74, 2271 / 253 | |
| tax_dist | OFTString | 65 | 26-LORAMIE TWP HHSD HAD RFD, 26-LORAMIE TWP HHSD HAD RFD, 28-LORAMIE TWP HHSD HAD RFD | |
| owner | OFTString | 18.1k | MEYER ROGER H, MEYER ROGER H, POHLMAN MARILYN R SUCC TRUSTEE & MARILYN R TRUSTEE | |
| OFTString | 18.1k | MEYER ROGER H 2727 W MIAMI SHELBY RD RUSSIA OH 45363, MEYER ROGER H 2727 W MIAMI SHELBY RD RUSSIA OH 45363, WEHNEMAN ALAN L 4231 W MIAMI SHELBY RD HOUSTON OH 45333 | ||
| lnd_appr | OFTString | 10.6k | 614,150, 637,190, 38,660 | |
| lnd_assd | OFTString | 7.1k | 214,950, 223,020, 13,530 | |
| imp_appr | OFTString | 14.7k | 168,610, 140,750, 0 | |
| imp_assd | OFTString | 9.8k | 59,010, 49,260, 0 | |
| tot_appr | OFTString | 20.1k | 782,760, 777,940, 38,660 | |
| tot_assd | OFTString | 13.4k | 273,960, 272,280, 13,530 |
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.