Archive
83 attribute fields, profiled from the May 2024 vintage.
Columns in Union County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| ppid | OFTString | 17.8k | 169-00-00-004 000, 173-00-00-001 000, 174-00-00-001 000 | |
| o_parcel_i | OFTString | 17.8k | 169-00-00-004+000, 171-00-00-005+000, 171-00-00-021+000 | |
| pid | OFTString | 17.8k | 169-00-00-004 000, 171-00-00-005 000, 171-00-00-021 000 | |
| map_no | OFTString | 17.8k | 169-00-00-004 000, 171-00-00-005 000, 171-00-00-021 000 | |
| owner | OFTString | 13.9k | FRAZIER JOHN RHETT JR SUSAN FRAZIER NEWTON, GRAY WILLIE MAE C RONALD E CLARK ETAL, HARRIS GERALDINE | |
| mail_addr1 | OFTString | 10.7k | PO BOX 401, 340 HUNTER ROAD, 351 HUNTER ROAD | |
| mail_addr2 | OFTString | 741 | NEWBERRY SC, WHITMIRE SC, WHITMIRE SC | |
| mail_addr3 | OFTString | 929 | 29108, 29178, 29178 | |
| situs | OFTString | 13.2k | 422 HUNTER ROAD, 351 HUNTER ROAD, 110 CLEARVIEW DRIVE | |
| rcdtyp | OFTString | 11 | Agricultural, Residential Agricultural, Residential Agricultural | |
| legal | OFTString | 14.8k | TUCKERTOWN ROAD, 422 HUNTER ROAD, 351 HUNTER ROAD S44-400 | |
| use_code | OFTString | 186 | MV-Agricultural LQ-Agricultural, RN-Residential MV-Agricultural LQ-Agricultural, RQ-Residential LQ-Agricultural MV-Agricultural | |
| acres | OFTString | 353 | 763.00, 97.00, 238.00 | |
| tax_dist | OFTString | 15 | County (District 24), County (District 24), County (District 24) | |
| totval | OFTString | 4.1k | 87,760, 68,650, 26,100 | |
| mktlnd | OFTString | 1.4k | 1,144,500, 52,000, 32,800 | |
| mktimpv | OFTString | 1.9k | 0, 61,500, 19,500 | |
| mkttot | OFTString | 2.6k | 1,144,500, 113,500, 52,300 | |
| assdval | OFTString | 1.2k | 3,510, 4,090, 1,050 | |
| saledate | OFTString | 8.3k | 8/11/2016, 10/1/1993, 2/17/2005 | |
| saleprice | OFTString | 1.6k | 10, 5, 75,000 | |
| salebook | OFTString | 15.8k | 0267 0536, 0209 0969, 0230 0132 | |
| salepage | OFTString | 7.1k | 0000 0000, 0024 0215, 0021 0076 | |
| baths | OFTString | 16 | 1.00, 1.00, 2.00 | |
| stories | OFTString | 5 | 1.00, 1.00, 1.00 | |
| t_parcel_i | OFTString | 17.8k | 169-00-00-004 000, 173-00-00-001 000, 174-00-00-001 000 | |
| ReceiptNo | OFTString | 17.2k | 005749233, 013106233, 016746233 | |
| imgIsPaid | OFTString | 3 | Paid, Paid, Paid | |
| NoticeIssu | OFTString | 1 | Issue Date:, Issue Date:, Issue Date: | |
| NoticeIs_1 | OFTString | 91 | 09/29/23, 09/29/23, 09/29/23 | |
| Name | OFTString | 12.8k | FRAZIER JOHN RHETT JR, OLD PINES LLC, SOUTHEAST FOREST PRODUCTS INC | |
| TaxYr | OFTString | 1 | 2023, 2023, 2023 | |
| District | OFTString | 23 | 24 / 385.3, 24 / 385.3, 24 / 385.3 | |
| City | OFTString | 4 | / 0, / 0, / 0 | |
| MarketVal | OFTString | 4.1k | 87,760, 8,850, 23,760 | |
| Assmt | OFTString | 1.1k | 3,510, 350, 1,430 | |
| Land4 | OFTString | 1.4k | 87,760, 8,850, 1,550 | |
| Building4 | OFTString | 1.8k | 0, 0, 0 | |
| RecordType | OFTString | 1 | Real Estate, Real Estate, Real Estate | |
| TaxInfo1 | OFTString | 1 | Map Number:, Map Number:, Map Number: | |
| MapNo | OFTString | 17.2k | 169-00-00-004 000, 173-00-00-001 000, 174-00-00-001 000 | |
| Acres2 | OFTString | — | ||
| CountyTax | OFTString | 5.2k | $1,352.40, $134.86, $550.98 | |
| CityTax | OFTString | 1 | $0.00, $0.00, $0.00 | |
| Fees | OFTString | 1 | $0.00, $0.00, $0.00 | |
| TaxDue1 | OFTString | 1 | Residential Exemption:, Residential Exemption:, Residential Exemption: | |
| Residentia | OFTString | 990 | $0.00, $0.00, $0.00 | |
| TaxDue2 | OFTString | 1 | Homestead Exemption:, Homestead Exemption:, Homestead Exemption: | |
| Homestead | OFTString | 836 | $0.00, $0.00, $0.00 | |
| TaxDue3 | OFTString | 1 | Other Exemptions:, Other Exemptions:, Other Exemptions: | |
| Other | OFTString | 1 | $0.00, $0.00, $0.00 | |
| TaxDue4 | OFTString | 1 | Local Option Credit:, Local Option Credit:, Local Option Credit: | |
| LocalOpts | OFTString | 3.9k | $226.42, $22.83, $61.30 | |
| TotalTaxes | OFTString | 10.6k | $1,125.98, $112.03, $489.68 | |
| DtPaid | OFTString | 1 | Date Paid:, Date Paid:, Date Paid: | |
| DatePd | OFTString | 230 | 12/14/23, 12/07/23, 12/28/23 | |
| StatusDesc | OFTString | 2 | Total Paid:, Total Paid:, Total Paid: | |
| Amount | OFTString | 10.6k | $1,125.98, $112.03, $489.68 | |
| LblLotsDes | OFTString | 1 | Lots:, Lots:, Lots: | |
| Lots | OFTString | 12 | 1, 1, 1 | |
| TaxInfo4 | OFTString | 1 | Description:, Description:, Description: | |
| Desc | OFTString | 14.5k | TUCKERTOWN ROAD, TR 1290, OFF HUNTER ROAD | |
| Desc2 | OFTString | 1.6k | CARLISLE, LORICK L, WHITMIRE | |
| SavePdfLin | OFTString | 1 | Save PDF, Save PDF, Save PDF | |
| PropAddres | OFTString | 1 | Property Address, Property Address, Property Address | |
| PropAddr_1 | OFTString | 12.8k | 422 HUNTER ROAD, 351 HUNTER ROAD, 110 CLEARVIEW DRIVE | |
| Building6 | OFTString | 1.2k | 0, 61,500, 0 | |
| Land6 | OFTString | 649 | 23,760, 5,600, 6,400 | |
| BuildingNu | OFTString | 1 | Buildings:, Buildings:, Buildings: | |
| Building_1 | OFTString | 15 | 3, 4, 1 | |
| TaxPenalty | OFTString | 1 | Penalty:, Penalty:, Penalty: | |
| Penalty | OFTString | 2.1k | $41.96, $0.99, $61.64 | |
| TaxCost | OFTString | 1 | Cost:, Cost:, Cost: | |
| Cost | OFTString | 2 | $25.00, $25.00, $25.00 | |
| Error | OFTString | 2 | ||
| TaxSaleIte | OFTString | 113 | 23451, 23140, 23229 | |
| TaxSaleDat | OFTString | 1 | 11/06/23, 11/06/23, 11/06/23 | |
| TaxSaleSta | OFTString | 1 | Redeemed, Redeemed, Redeemed | |
| TaxSaleS_1 | OFTString | 28 | 00/00/00, 00/00/00, 00/00/00 | |
| TaxSaleBid | OFTString | 37 | CLARK RONALD, WHITMORE ZAVIER DEANGELO, WILSON CHARLES W JR | |
| TaxSaleRed | OFTString | 37 | VIOD, NETRA ZIMMERMAN, JACQUELINE HARDY 864-301-0565 | |
| DorNo | OFTString | 9 | 6-1382619, 6-1636692, 6-4166441 | |
| TaxInfo2 | OFTString | 1 | DOR#:, DOR#:, DOR#: |
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.