158 attribute fields, profiled from the April 2022 vintage.
Columns in Scioto County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 26153, 26297, 24848 | |
| layer | OFTString | 1 | PAR_CNTRO, PAR_CNTRO, PAR_CNTRO | |
| compnum | OFTString | 41.8k | 061039000, 060859000, ROW | |
| discode | OFTString | — | ||
| row | OFTString | 3 | N, N, Y | |
| schdist | OFTString | 8 | WASHINGTON-NILE SCHOOL DIST, WASHINGTON-NILE SCHOOL DIST, WASHINGTON-NILE SCHOOL DIST | |
| district | OFTString | 33 | 06, 06, 06 | |
| parcel | OFTString | 11.1k | 1039000, 0859000, ROW | |
| pinanno | OFTString | 50.0k | 06-1039.000, 06-0859.000, -ROW | |
| pin | OFTString | 50.0k | 061039000, 060859000, ROW | |
| propertynu | OFTString | 50.0k | 06-1039.000, 06-0859.000, 06-0724.000 | |
| mapnumber | OFTString | 1 | 26002 | |
| cardcount | OFTReal | 21 | 0.0, 0.0, 1.0 | |
| neighborho | OFTInteger | 61 | 600, 600, 601 | |
| legaldescr | OFTString | 50.0k | 2AC FRENCH GRANT LOT 4 GILRUTH DIV MAP 7^BACK RD PARCEL E, GERVAIS TRACT .32AC MAP 6B 1091 GALLIA PIKE, .2314 ACRES VMS 15228 MAP 04^US HIGHWAY 52 | |
| locstrdir | OFTString | 4 | E, E, E | |
| locstrno | OFTString | 8.2k | 2676, 0, 1496 | |
| locstrno2 | OFTString | 12 | A, B, D | |
| locstrname | OFTString | 1.9k | GALLIA PIKE, US 52, BACK RD | |
| locstrsuff | OFTString | 8 | RD, RD, RD | |
| locstrsu_1 | OFTString | — | ||
| secondarya | OFTString | 6 | 422 CENTER ST, UNIT B, 5644 | |
| loccity | OFTString | 9 | STOUT, WEST PORTSMOUTH, US 52 | |
| locstate | OFTString | 1 | OH, OH, OH | |
| loczipcode | OFTString | 12 | 45684, 45663, DELI) | |
| locdescrip | OFTString | 5.1k | GALLIA PIKE^^, US 52^BETWEEN HIGHWAY + RIVER^, BACK RD^^ | |
| classifica | OFTInteger | 104 | 100, 110, 101 | |
| acres | OFTReal | 9.3k | 136.93, 61.83, 19.42 | |
| frontfoota | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| pardeleted | OFTString | 2 | N, N, N | |
| deededowne | OFTString | 30.1k | VIRGINIA HOLDING CORP, SCHILLING JEFFREY S, MILLER MARK A | |
| lot | OFTString | — | ||
| sublot | OFTString | — | ||
| ownername | OFTString | 30.1k | VIRGINIA HOLDING CORP, SCHILLING JEFFREY S, MILLER MARK A | |
| ownerfirst | OFTString | 6.9k | SCHILLING, MILLER, ROGER D. | |
| ownermiddl | OFTString | 36 | J, M, L | |
| ownerlastn | OFTString | 4.0k | VIRGINIA HOLDING CORP, S, A | |
| ownernames | OFTString | 3 | Jr., III, III | |
| ownerbusin | OFTInteger | 2 | 1, 0, 0 | |
| ownerstree | OFTString | 5.6k | COMMERCIAL, TWP RD 1117, BACK | |
| ownerstr_1 | OFTString | 7.3k | THREE, 185, 1496 B | |
| ownerstr_2 | OFTString | 8 | S, S, S | |
| ownerstr_3 | OFTString | 19 | PL, RD, RD | |
| ownersufdi | OFTString | 8 | NW, NW, W | |
| ownersecon | OFTString | 304 | BOX 209, SUITE 600, SUITE 4800 | |
| ownercity | OFTString | 895 | NORFOLK, IRONTON, FRANKLIN FURNACE | |
| ownerstate | OFTString | 51 | VA, OH, OH | |
| ownerzipco | OFTString | 1.1k | 23510, 45638, 45629 | |
| ownercount | OFTString | 1 | USA, USA, USA | |
| owneratten | OFTString | 3.9k | NORFOLK SOUTHERN /TAX DEPT, FYFFE J/S, TOWANA S REVOCABLE TRUST | |
| taxpayerna | OFTString | 30.1k | VIRGINIA HOLDING CORP, SCHILLING JEFFREY S, MILLER MARK A | |
| taxpayerfi | OFTString | 6.9k | VIRGINIA, SCHILLING, MILLER | |
| taxpayermi | OFTString | 38 | H, J, M | |
| taxpayerla | OFTString | 3.9k | CORP, S, A | |
| taxpayer_1 | OFTString | 4 | Jr., III, III | |
| taxpayerbu | OFTInteger | 2 | 0, 0, 0 | |
| taxpayerst | OFTString | 5.7k | PEACHTREE, TWP RD 1117, BACK | |
| taxpayer_2 | OFTString | 7.2k | 650, 185, 1496 B | |
| taxpayer_3 | OFTString | 8 | W, S, S | |
| taxpayer_4 | OFTString | 20 | ST, RD, RD | |
| taxpayer_5 | OFTString | 8 | NW, NW, NW | |
| taxpayerse | OFTString | 301 | SUITE 600, SUITE 4800, SUITE 4800 | |
| taxpayerci | OFTString | 921 | ATLANTA, IRONTON, FRANKLIN FURNACE | |
| taxpayer_6 | OFTString | 51 | GA, OH, OH | |
| taxpayerzi | OFTString | 1.1k | 30308, 45638, 45629 | |
| taxpayerco | OFTString | 1 | USA, USA, USA | |
| taxpayerat | OFTString | 3.9k | NORFOLK SOUTHERN /TAX DEPT, FYFFE J/S, TOWANA S REVOCABLE TRUST | |
| specflag | OFTString | 2 | N, N, Y | |
| stateschoo | OFTInteger | 12 | 7303, 7303, 7303 | |
| valuedby | OFTString | 26 | mml, CJD, CJD | |
| mktlandval | OFTInteger | 7.3k | 805580, 116210, 25030 | |
| mktimprval | OFTInteger | 14.0k | 0, 0, 121960 | |
| cauvvalue | OFTInteger | 3.3k | 0, 90480, 0 | |
| mkttotalva | OFTInteger | 16.2k | 805580, 90480, 146990 | |
| mkttottota | OFTInteger | 16.6k | 805580, 116210, 146990 | |
| saledate | OFTString | 6.4k | 2003-12-15, 2018-09-17, 2020-10-16 | |
| validsale | OFTString | 2 | N, N, Y | |
| saleamount | OFTInteger | 2.2k | 0, 0, 235000 | |
| numberofpr | OFTInteger | 51 | 1, 9, 1 | |
| instumentt | OFTInteger | 29 | 117, 6297, 119 | |
| instumentd | OFTString | 6.4k | 2003-12-15, 2018-09-17, 2020-10-16 | |
| conveyance | OFTString | 4.6k | 01603, 1270, 0 | |
| deednumber | OFTInteger | 22.7k | 39449, 46359, 34599 | |
| hmstdflag | OFTString | 2 | N, N, N | |
| foreclosed | OFTString | 1 | N, N, N | |
| newconstru | OFTString | 2 | N, N, N | |
| reduction2 | OFTString | 2 | N, N, Y | |
| borflag | OFTString | 1 | N, N, N | |
| dividedpro | OFTString | 2 | N, N, N | |
| landval | OFTInteger | 3.9k | 281950, 40670, 8760 | |
| improveval | OFTInteger | 7.4k | 0, 0, 42690 | |
| specassess | OFTInteger | 6 | 0, 0, 1 | |
| annualtax | OFTReal | 33.4k | 13471.62, 1513.18, 2435.92 | |
| taxespaid | OFTReal | 30.3k | 6735.81, 756.59, 1225.96 | |
| delinquent | OFTReal | 4.2k | 0.0, 0.0, 0.0 | |
| routingnum | OFTString | 50.0k | 06-00800-030000, 06-00600-002000, 06-00500-008000 | |
| zoning | OFTString | — | ||
| parceltype | OFTInteger | 1 | 0, 0, 0 | |
| foreclosur | OFTString | — | ||
| trescode | OFTString | 7.0k | O-031504-ALJ, M-031595-DKC, TU0122 | |
| bc | OFTString | 3 | Chapter 13, Chapter 13, Chapter 13 | |
| activeyear | OFTInteger | 18 | 1980, 1980, 1980 | |
| lenderid | OFTInteger | 33 | 73, 0, 27 | |
| taxliensta | OFTString | 1 | P, P, P | |
| ownotherin | OFTString | 15 | BRIANA BALES CALLED, JOE LESTER, MR WEBB NO LONGER WANTS THIS BILL | |
| forcmessag | OFTInteger | 10 | 0, 0, 0 | |
| subdivisio | OFTInteger | 2 | 0, 0, 0 | |
| streetnumb | OFTReal | 7.4k | 2676.0, 0.0, 1496.0 | |
| camaid | OFTString | 50.0k | 061039000, 060859000, 060724000 | |
| streetaddr | OFTString | 34.2k | 2676 GALLIA PIKE, 0 US 52, 1496 BACK RD | |
| taxsetcode | OFTString | 35 | 06, 06, 06 | |
| cardnumber | OFTInteger | 12 | 1, 1, 1 | |
| mainbuildi | OFTString | 1 | D, D, D | |
| condition | OFTString | 7 | AV AV, AV AV, AV AV | |
| basearea | OFTReal | 2.0k | 1620.0, 1500.0, 1175.0 | |
| atticarea | OFTReal | 450 | 0.0, 0.0, 687.0 | |
| basementar | OFTReal | 1.9k | 810.0, 1500.0, 1175.0 | |
| yearbuilt | OFTReal | 177 | 1977.0, 1966.0, 1995.0 | |
| roomcount | OFTReal | 21 | 6.0, 5.0, 4.0 | |
| bedroomcou | OFTReal | 12 | 3.0, 3.0, 2.0 | |
| familyroom | OFTReal | 5 | 1.0, 0.0, 0.0 | |
| fullbathco | OFTReal | 8 | 1.0, 1.0, 2.0 | |
| halfbathco | OFTReal | 7 | 1.0, 1.0, 0.0 | |
| styleofhom | OFTInteger | 17 | 1, 1, 1 | |
| grade | OFTString | 34 | C+10, C-5, C+10 | |
| exteriorwa | OFTString | 27 | Br, FrAl, FrAl | |
| basementco | OFTInteger | 6 | 4, 6, 6 | |
| heatingcod | OFTInteger | 17 | 2, 2, 2 | |
| centralair | OFTInteger | 3 | 1, 1, 1 | |
| storyheigh | OFTReal | 13 | 1.0, 1.0, 1.0 | |
| fireplaceo | OFTReal | 7 | 1.0, 0.0, 0.0 | |
| fireplaces | OFTReal | 6 | 1.0, 0.0, 0.0 | |
| basementga | OFTReal | 6 | 0.0, 0.0, 0.0 | |
| finishedli | OFTReal | 2.2k | 1620.0, 1500.0, 1862.0 | |
| totalfirst | OFTReal | 2.0k | 1620.0, 1500.0, 1175.0 | |
| totalupper | OFTReal | 832 | 0.0, 0.0, 0.0 | |
| totalhalff | OFTReal | 461 | 0.0, 0.0, 0.0 | |
| basementfi | OFTReal | 471 | 0.0, 0.0, 0.0 | |
| usecode | OFTString | 1 | 499 | |
| yearremode | OFTReal | 81 | 0.0, 1995.0, 0.0 | |
| gradeadjus | OFTReal | 32 | 1.1, 0.95, 1.1 | |
| crawltypec | OFTInteger | 3 | 4, 0, 0 | |
| diningroom | OFTInteger | 4 | 0, 0, 0 | |
| atticcode | OFTInteger | 6 | 0, 0, 4 | |
| totalfir_1 | OFTReal | 2.0k | 1620.0, 1500.0, 1175.0 | |
| totalupp_1 | OFTReal | 832 | 0.0, 0.0, 0.0 | |
| firetype | OFTString | 2 | Y, Y, Y | |
| unfinished | OFTReal | 206 | 0.0, 0.0, 0.0 | |
| otherplumb | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| styleofh_1 | OFTString | 17 | 01, 01, 01 | |
| occtabtype | OFTString | 17 | 01, 01, 01 | |
| occtabdesc | OFTString | 17 | Single Family, Single Family, Single Family | |
| distabtype | OFTString | 35 | 06, 06, 06 | |
| distabdesc | OFTString | 35 | GREEN TWP-GREEN LSD, GREEN TWP-GREEN LSD, GREEN TWP-GREEN LSD | |
| shape_leng | OFTReal | 50.0k | 12663.898352, 6771.438763, 43122.4635 | |
| shape_area | OFTReal | 50.0k | 6849206.410083, 2777373.996418, 5157080.623204 | |
| deedvolume | OFTString | 126 | 738, 778, 737 | |
| deedpage | OFTInteger | 887 | 830, 151, 112 |
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.