Archive
92 attribute fields, profiled from the February 2024 vintage.
Columns in Hillsdale County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 33.3k | 7501, 7538, 7822 | |
| p_parcelui | OFTInteger | 33.3k | 47535, 47572, 47856 | |
| shape__are | OFTReal | 33.0k | 6982.24609375, 146443.734375, 294492.29296875 | |
| shape__len | OFTReal | 33.3k | 373.270447168845, 1624.18873928719, 2210.96983903163 | |
| parcel_id | OFTString | 33.3k | 47535, 47572, 47856 | |
| parcel_no | OFTString | 33.3k | 14 008 300 003 08 9 4, 14 005 300 010 05 9 4, 14 005 100 002 05 9 4 | |
| pnumreport | OFTString | 33.3k | 14_008_300_003_08_9_4, 14_005_300_010_05_9_4, 14_005_100_002_05_9_4 | |
| o_parcelui | OFTString | 33.3k | 47535, 47572, 47856 | |
| housenum | OFTString | 8.8k | 0, 9698, 14100 | |
| propaddr | OFTString | 26.2k | 9698 W TERRITORIAL RD, 14100 MEAD RD, 14260 MEAD RD | |
| propcsz | OFTString | 27 | MONTGOMERY, MI 49255, MONTGOMERY, MI 49255, MONTGOMERY, MI 49255 | |
| proppriuni | OFTString | 27 | CAMDEN TWP, CAMDEN TWP, CAMDEN TWP | |
| ownername1 | OFTString | 21.9k | SWANDER, DUSTIN S, GRABER, CHRIS M, GRABER, CHRISTY B & MARY G | |
| owneraddr | OFTString | 19.1k | 15600 MEAD RD, 14260 MEAD RD, 14260 MEAD RD | |
| ownercsz | OFTString | 2.2k | MONTGOMERY MI 49255, MONTGOMERY MI 49255, MONTGOMERY MI 49255 | |
| propclass | OFTString | 16 | 402, 401, 101 | |
| schooldist | OFTString | 14 | CAMDEN FRONTIER SCHOOLS, CAMDEN FRONTIER SCHOOLS, CAMDEN FRONTIER SCHOOLS | |
| prequalag | OFTString | 77 | 100, 72, 58 | |
| curyearsev | OFTString | 5.8k | 1,000, 252,500, 110,900 | |
| priyearsev | OFTString | 6.9k | 1,100, 202,900, 110,800 | |
| curyeartv | OFTString | 21.0k | 663, 167,146, 66,886 | |
| priyeartv | OFTString | 20.7k | 642, 161,807, 64,750 | |
| landval | OFTString | 19.9k | 2,000, 74,760, 132,755 | |
| landimpval | OFTString | 5.7k | 0, 0, 0 | |
| bldgval | OFTString | 20.7k | 0, 430,222, 89,008 | |
| trucashval | OFTString | 28.7k | 2,000, 504,982, 221,763 | |
| ecftable | OFTString | 167 | 4010 RES SECTION GROUND, 4010 RES SECTION GROUND, 4000 AG SECTION GROUND | |
| landtable | OFTString | 193 | RES SECTION GROUND, RES SECTION GROUND, AG SECTION GROUND | |
| acreage | OFTString | 4.0k | 0.50, 20.20, 40.00 | |
| poolarea | OFTString | 84 | 0, 0, 0 | |
| legal1 | OFTString | 33.2k | S 610 FT OF E 715 FT NW1/4 SEC 5 T9S R4W 10 A M/L, W 3/4 NW1/4 SEC 8 T9S R4W 120 A, E1/4 NW1/4 SEC 8 T9S R4W 40 A | |
| sumadvalor | OFTString | 22.4k | $ 7.19, $ 1,815.51, $ 726.50 | |
| sumspecass | OFTString | 49 | 0, 0, 0 | |
| sumadminfe | OFTString | 3.0k | $ 0.07, $ 18.15, $ 7.26 | |
| sumtaxbill | OFTString | 23.3k | $ 7.26, $ 1,833.66, $ 733.76 | |
| sumtotpay | OFTString | 19.8k | $ 7.26, $ 1,833.66, $ 733.76 | |
| sumintpen | OFTString | 2.5k | 0, 0, 0 | |
| sumlastpay | OFTString | 154 | 08/17/2022, 08/15/2022, 09/10/2022 | |
| sumtotbill | OFTString | 5.7k | 0, 0, 0 | |
| winadvalor | OFTString | 26.6k | $ 8.66, $ 3,039.32, $ 1,384.75 | |
| winspecass | OFTString | 4.0k | 0, 0, 0 | |
| winadminfe | OFTString | 3.5k | $ 0.08, $ 30.39, $ 13.84 | |
| wintaxbill | OFTString | 27.2k | $ 8.74, $ 3,069.71, $ 1,398.59 | |
| wintotpay | OFTString | 890 | 0, 0, 0 | |
| winintpen | OFTString | 1 | 0, 0, 0 | |
| winlastpay | OFTString | 13 | *, *, * | |
| wintotbill | OFTString | 26.5k | $ 8.74, $ 3,069.71, $ 1,398.59 | |
| viladvalor | OFTString | 1.2k | 0, 0, 0 | |
| vilspecass | OFTString | 27 | 0, 0, 0 | |
| viladminfe | OFTString | 412 | 0, 0, 0 | |
| viltaxbill | OFTString | 1.2k | 0, 0, 0 | |
| viltotpay | OFTString | 1 | 0, 0, 0 | |
| vilintpen | OFTString | 264 | 0, 0, 0 | |
| villastpay | OFTString | 1 | *, *, * | |
| viltotbill | OFTString | 1.2k | 0, 0, 0 | |
| delqtax | OFTString | 1.3k | $0.00, $0.00, $0.00 | |
| bldocctype | OFTString | 6 | Single Family, Single Family, Single Family | |
| bldyrblt | OFTString | 193 | 0, 2004, 0 | |
| bldclass | OFTString | 12 | CD, C, D | |
| bldphysdpr | OFTString | 65 | 0, 84, 50 | |
| bldheight0 | OFTString | 10 | 2 Story, 1 Story, 2 Story | |
| bldext0 | OFTString | 7 | Siding, Siding, Siding | |
| bldfound0 | OFTString | 13 | Basement, Mich Bsmnt., Basement | |
| bldheight1 | OFTString | 11 | 1 Story, 1 Story, 1 Story | |
| bldext1 | OFTString | 7 | Siding, Siding, Siding | |
| bldfound1 | OFTString | 12 | Basement, Crawl Space, Crawl Space | |
| bldheight2 | OFTString | 9 | 1 Story, 1 Story, 1 Story | |
| bldext2 | OFTString | 6 | Siding, Siding, Siding | |
| bldfound2 | OFTString | 10 | Basement, Crawl Space, Slab | |
| bldheight3 | OFTString | 6 | 1 Story, 1 Story, 1 Story | |
| bldext3 | OFTString | 6 | Siding, Siding, Siding | |
| bldfound3 | OFTString | 8 | Basement, Crawl Space, Crawl Space | |
| bldmhleng | OFTString | 55 | 0, 0, 0 | |
| bldmhwidth | OFTString | 24 | 0, 0, 0 | |
| bld3fxbath | OFTString | 9 | 0, 0, 1 | |
| bld2fxbath | OFTString | 6 | 0, 0, 1 | |
| bldtotflr | OFTString | 2.5k | 2,240 SqFt, 1,694 SqFt, 4,234 SqFt | |
| bldtotbsmt | OFTString | 1.9k | 1,472 SqFt, 486 SqFt, 1,557 SqFt | |
| bldtotgrnd | OFTString | 2.0k | 1,472 SqFt, 1,694 SqFt, 2,677 SqFt | |
| bldarea0 | OFTString | 1.9k | 768 SqFt, 486 SqFt, 1,557 SqFt | |
| bldarea1 | OFTString | 1.0k | 704 SqFt, 564 SqFt, 481 SqFt | |
| bldarea2 | OFTString | 583 | 0, 324 SqFt, 639 SqFt | |
| bldarea3 | OFTString | 311 | 0, 320 SqFt, 0 | |
| bldgarage | OFTString | 953 | 0, 420 SqFt, 0 | |
| bldcarport | OFTString | 158 | 0, 0, 0 | |
| liberpage1 | OFTString | 27.9k | 1288/14 - 1225/999 - 1225/988, 1727/516 - 1151/393 - 946/835, 1386/710 - 1102/483 - 1060/291 | |
| legal2 | OFTString | 6.3k | 05 9 4;, L SPLIT ON 01/08/2008 FROM 14 005 100 001 05 9 4;, 6 05 9 4, 14 005 300 007 05 9 4; | |
| ownername2 | OFTString | 3.2k | STEURY, ARLENE, CARMODY, PAMELA, STEURY, ARLENE | |
| legal3 | OFTString | 1.6k | ;, 000 FROM 18 004 400 014 04 9 3;, 831 SEC 4 T9S R3W 10.90 A M/L | |
| lot_no | OFTString | 2.3k | 19, 40, 20 | |
| platbkpage | OFTString | 560 | 1793/1263, 1460/0675, 0512/0318 | |
| fullstreet | OFTString | 39 | N EAST ST, S WEST ST, E WARREN AVE |
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.