58 attribute fields, profiled from the June 2024 vintage.
Columns in Randolph County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| MapNumber | OFTString | 25.6k | 07-04-101-006, 01-04-363-011, 04-13-148-022 | |
| ParcelNumb | OFTString | 25.0k | 1314401700, 1306402100, 1600501600 | |
| parcel_num | OFTString | 25.3k | 1314401700, 1306402100, 1600501600 | |
| alternate_ | OFTString | 25.0k | 07-04-101-006, 01-04-363-011, 04-13-148-022 | |
| township | OFTString | 21 | 14, 13, 01 | |
| township_n | OFTString | 21 | T5S R8W, T4S R8W, T4S R5W | |
| tax_code | OFTString | 87 | 052, 053, 043 | |
| site_addre | OFTString | 13.0k | 57 W MILL, 4601 BLACKJACK RD, 408 W SOUTH ST | |
| site_csz | OFTString | 76 | RUMA IL 62278, RED BUD IL 62278, STEELEVILLE IL 62288 | |
| gross_acre | OFTReal | 4.5k | 0.0, 0.0, 0.0 | |
| homesite_a | OFTReal | 546 | 0.0, 0.0, 0.0 | |
| farm_acres | OFTReal | 4.6k | 0.0, 0.0, 0.0 | |
| class | OFTString | 25 | 0090, 0090, 0090 | |
| tax_status | OFTString | 3 | E, E, E | |
| lot_dimens | OFTString | 1.5k | 30x87 rectangular, 2x25 rec, 89SF | |
| owner1_id | OFTReal | 13.6k | 51427.0, 51427.0, 1745.0 | |
| document_n | OFTString | 6.2k | 2019R00344, 2020R01517, 2023R00388 | |
| owner1_nam | OFTString | 12.9k | STATE OF ILLINOIS DEPT OF TRANSPORTATION, STATE OF ILLINOIS DEPT OF TRANSPORTATION, STATE OF ILLINOIS DEPT OF TRANSPORTATION | |
| owner1_add | OFTString | 11.1k | 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR, ATTN: LAND AQUISITION | |
| owner1_a_1 | OFTString | 771 | 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR | |
| owner1_csz | OFTString | 990 | COLLINSVILLE IL 62234, COLLINSVILLE IL 62234, COLLINSVILLE IL 622340000 | |
| owner2_id | OFTReal | 1.2k | 0.0, 0.0, 0.0 | |
| document_1 | OFTString | 941 | 2023R02960, 2019R03295, 2019R03427 | |
| owner2_nam | OFTString | 1.2k | JACKSON KAITLYN, ELLNER WILLIAM J CO TRUSTEE, DONJON JEREMY M | |
| owner2_add | OFTString | 1.1k | 57 W MILL ST, 315 MARKET ST, 8161 PRESTON RD | |
| owner2_a_1 | OFTString | 39 | PO BOX 192, 310 E CHESTNUT ST, SUITE 4800 | |
| owner2_csz | OFTString | 179 | RED BUD IL 62278, PRAIRIE DU ROCHER IL 62277, RED BUD IL 62278 | |
| legal | OFTString | 25.1k | 238/684 91-79-94 PT LOT 2 10'X10' CLAIM 292 SURVEY 539 T7 R7, 227/939 (90-79-12) PT W SIDE FRL NW SEC 24 T5 R8, 365/77 92-79-142 PT LOT 3 .005 AC HART LANE SUB DIV | |
| date_of_sa | OFTString | 1.2k | 2003/12/30 19:00:00.000, 2003/12/25 19:00:00.000, 2005/08/16 20:00:00.000 | |
| mailto_nam | OFTReal | 11.2k | 51427.0, 51427.0, 1745.0 | |
| mailto_n_1 | OFTString | 10.5k | STATE OF ILLINOIS DEPT OF TRANSPORTATION, STATE OF ILLINOIS DEPT OF TRANSPORTATION, STATE OF ILLINOIS DEPT OF TRANSPORTATION | |
| mailto_add | OFTString | 9.2k | 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR, ATTN: LAND AQUISITION | |
| mailto_a_1 | OFTString | 718 | 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR, 1102 EASTPORT PLAZA DR | |
| mailto_csz | OFTString | 950 | COLLINSVILLE IL 62234, COLLINSVILLE IL 62234, COLLINSVILLE IL 622340000 | |
| hel_flag | OFTString | 1 | Y, Y, Y | |
| his_flag | OFTString | — | ||
| hie_flag | OFTString | 1 | Y, Y, Y | |
| hes_flag | OFTString | 1 | Y, Y, Y | |
| hep_flag | OFTString | 1 | Y, Y, Y | |
| faf_flag | OFTString | 1 | Y, Y, Y | |
| vez_flag | OFTString | — | ||
| vet_flag | OFTString | — | ||
| xmpt_flag | OFTString | 1 | Y, Y, Y | |
| saf_flag | OFTString | 1 | Y, Y, Y | |
| drn_flag | OFTString | — | ||
| assessed_l | OFTString | 15 | 2024/04/23 20:00:00.000, 2024/04/23 20:00:00.000, 2024/04/23 20:00:00.000 | |
| farm_land | OFTReal | 3.7k | 0.0, 0.0, 0.0 | |
| farm_build | OFTReal | 1.3k | 0.0, 0.0, 0.0 | |
| non_farm_l | OFTReal | 2.7k | 0.0, 0.0, 0.0 | |
| non_farm_b | OFTReal | 8.5k | 0.0, 0.0, 0.0 | |
| tax_billed | OFTReal | 18.3k | 0.0, 0.0, 0.0 | |
| py_be_farm | OFTReal | 3.7k | 0.0, 0.0, 0.0 | |
| lastname | OFTString | 4.7k | ILLINOIS DEPT OF TRANSPORTATION, ILLINOIS DEPT OF TRANSPORTATION, STATE OF ILLINOIS DEPT OF TRANSPORTATION | |
| firstname | OFTString | 9.4k | ATTN: BUREAU OF LAND ACQUISITION, ATTN: BUREAU OF LAND ACQUISITION, ATTN: BUREAU OF LAND ACQUISITION | |
| middle_ini | OFTString | 26 | A, L, E | |
| Shape__Are | OFTReal | 25.7k | 3.0050048828125, 2.4752197265625, 9.9998779296875 | |
| Shape__Len | OFTReal | 25.7k | 13.020031551020153, 14.70578977197897, 22.189929387281524 | |
| GlobalID | OFTString | 26.0k | e570aa62-2f98-4b11-a05d-5d579651d2a6, 5e7f4665-5bf6-4adb-915b-b1cb47166a0b, d4d72c0b-c8c4-4644-8c2a-a6f78521b3fb |
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.