Archive
165 attribute fields, profiled from the June 2024 vintage.
Columns in Dorchester County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 1, 2, 3 | |
| tms13 | OFTString | 50.0k | 0030000037000, 0030000039000, 0030000042000 | |
| tms_dec | OFTString | 50.0k | 0030000037.000, 0030000039.000, 0030000042.000 | |
| tms | OFTString | 50.0k | 003-00-00-037, 003-00-00-039, 003-00-00-042 | |
| tmssub | OFTString | 54 | .000, .000, .000 | |
| e_date | OFTString | 2.6k | 1999-08-13, 1999-08-13, 1999-08-13 | |
| gis_acreag | OFTReal | 50.0k | 2.43512688, 0.74443475, 0.69515122 | |
| x_cord | OFTReal | 50.0k | 2130192.45782275, 2131009.15241932, 2130798.39516896 | |
| y_cord | OFTReal | 50.0k | 531945.0189203, 531277.05712164, 531644.37833816 | |
| full_tms | OFTString | 50.0k | 003-00-00-037.000, 003-00-00-039.000, 003-00-00-042.000 | |
| last_edite | OFTString | 791 | 2016-02-09, 2016-02-09, 2016-02-09 | |
| accountno | OFTString | 50.0k | R0063078, R0063080, R0063087 | |
| full_parce | OFTString | 50.0k | 003-00-00-037.000, 003-00-00-039.000, 003-00-00-042.000 | |
| parcelno | OFTString | 50.0k | 0030000037000, 0030000039000, 0030000042000 | |
| jurisdicti | OFTString | 9 | 1, 1, 1 | |
| tax_distri | OFTString | 14 | 400, 400, 400 | |
| owner | OFTString | 50.0k | JOHNSON WILLIE CLIFFORD & EVELYN, ELLIS LAVERNE, MOSLEY AVON & BETTY RAY | |
| care_of | OFTString | 4.2k | C/O BETTY MOSLEY, C/O WILLIE GREEN JR, ADAM SMITH | |
| mailing_ad | OFTString | 50.0k | 246 JOHNSON HORN RD, 198 JOHNSON HORN RD, 4305 12TH ST NE | |
| city_state | OFTString | 14.1k | BOWMAN SC 290189462, BOWMAN SC 290189461, WASHINGTON DC 200173820 | |
| property_l | OFTString | 50.0k | 244 JOHNSON HORN RD, 198 JOHNSON HORN RD, 214 JOHNSON HORN RD | |
| taxed_acre | OFTReal | 3.5k | 2.37, 0.0, 0.7 | |
| plat | OFTString | 7.1k | F_377, G_131, G_181 | |
| grantor | OFTString | 49.1k | JOHNSON WILLIE CLIFFORD, GLEN HUGHE WEATHERS, GLEN H WEATHERS | |
| grantee | OFTString | 50.0k | JOHNSON WILLIE CLIFFORD & EVELYN, ELLIS LAVERNE, MOSLEY AVON & BETTY RAY | |
| deed | OFTString | 50.0k | 007687-289, 000620-417, 000625-158 | |
| recording_ | OFTString | 10.4k | 2010-11-02, 1988-10-25, 1989-01-06 | |
| sale_date | OFTString | 11.0k | 2010-10-29, 1988-10-25, 1989-01-06 | |
| sale_price | OFTReal | 11.7k | 5.0, 2000.0, 2000.0 | |
| zoningcode | OFTString | 87 | AR_DC, AR_DC, AR_DC | |
| assignedto | OFTString | 8 | ASTKSP, ASTKSP, ASTKSP | |
| esri_oid | OFTInteger | 50.0k | 42, 44, 47 | |
| e_code | OFTString | 24 | cogoLDG, cogoLDG, cogoLDG | |
| plat_date | OFTString | 3.6k | 2021-05-26, 2022-10-25, 2019-01-11 | |
| parent_par | OFTString | 4.7k | 003-00-00-035.000, 003-00-00-036.000, 003-00-00-036.000 | |
| other | OFTString | 2.2k | TRACT B & C and ALSO J-176, TRACT A-5, TRACT A1 | |
| lot | OFTString | 548 | 037, 042, 064 | |
| created_da | OFTString | 612 | 2015-11-25, 2015-11-25, 2015-11-25 | |
| subdivisio | OFTString | 461 | SUMMERVILLE ESTATES 089, PINE HILL ACRES 071, PINE HILL ACRES 071 | |
| sub_info | OFTString | 948 | PH 0 BLK G, PH 0 BLK G, PH 0 BLK B | |
| parcel_id | OFTString | 50.0k | 0030000037000, 0030000042000, 0070000064000 | |
| Acres | OFTString | 2.4k | 2.37, 0.7, 1.0 | |
| ParcelNumb | OFTString | 50.0k | 003-00-00-037-000-C, 003-00-00-042-000-C, 007-00-00-064-000-C | |
| OwnerName1 | OFTString | 47.7k | JOHNSON WILLIE CLIFFORD & EVELYN, MOSLEY AVON & BETTY RAY, WEATHERS STEPHEN H JR | |
| OwnerName2 | OFTString | 47.7k | JOHNSON WILLIE CLIFFORD & EVELYN, MOSLEY AVON & BETTY RAY, WEATHERS STEPHEN H JR | |
| Descriptio | OFTString | 50.0k | JOHNSON HORN RD 244, JOHNSON HORN RD 214, CHARLESTON HWY | |
| District | OFTString | 17 | 400, 400, 400 | |
| IDHash | OFTString | 50.0k | AB8E52E78B4D8AA7ED94C4AB95479E76, EA89F5000B415D0073CDB8C353E3342B, A4246E954FA43B3CF534E35B8DFA3F16 | |
| Hash | OFTString | 50.0k | ||
| Version | OFTString | 13 | 5, 5, 5 | |
| BillingID | OFTString | 50.0k | TMS 003-00-00-037-000C, TMS 003-00-00-042-000C, TMS 007-00-00-064-000C | |
| LastUpdate | OFTString | 23.1k | 2024-01-17T08:39:11.0051221Z, 2024-01-09T11:31:15.5721533Z, 2024-01-09T11:35:18.1817408Z | |
| BillDate | OFTString | 9 | 2023-09-19T00:00:00, 2023-09-19T00:00:00, 2023-09-19T00:00:00 | |
| PaymentCat | OFTString | 1 | 1, 1, 1 | |
| Year | OFTString | 1 | 2023, 2023, 2023 | |
| Name | OFTString | 47.7k | JOHNSON WILLIE CLIFFORD & EVELYN, MOSLEY AVON & BETTY RAY, WEATHERS STEPHEN H JR | |
| RecordType | OFTString | 1 | Real, Real, Real | |
| CartPaymen | OFTString | 19 | 0.0, 0.0, 0.0 | |
| RequiresAu | OFTString | 1 | false, false, false | |
| Locked | OFTString | 1 | false, false, false | |
| RequiresGe | OFTString | 1 | true, true, true | |
| isDelinque | OFTString | 1 | false, false, false | |
| OwnerLine1 | OFTString | 3.5k | C/O BETTY MOSLEY, C/O WILLIE GREEN JR, & REGGIE SPELL | |
| OwnerLine2 | OFTString | 45.3k | 246 JOHNSON HORN RD, 4305 12TH ST NE, 100 HERRICK CT | |
| OwnerCity | OFTString | 1.2k | BOWMAN, WASHINGTON, LEXINGTON | |
| OwnerState | OFTString | 53 | SC, DC, SC | |
| OwnerZip | OFTString | 10.9k | 29018-9462, 20017-3820, 29072-8260 | |
| BaseTax | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Penalty | OFTString | 1.6k | 0.0, 0.0, 0.0 | |
| Interest | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Assessed | OFTString | 3.6k | 2500, 6860, 600 | |
| Appraised | OFTString | 39.7k | 62422, 114310, 10000 | |
| OriginalAm | OFTString | 1 | 0.0, 0.0, 0.0 | |
| AmountDue | OFTString | 19 | 0.0, 0.0, 0.0 | |
| Lots | OFTString | 5 | 0.0, 0.0, 0.0 | |
| ItemCode | OFTString | 2 | 2, 2, 2 | |
| DelqSw | OFTString | 1 | false, false, false | |
| SearchPara | OFTString | 50.0k | TMS 003-00-00-037-000C, TMS 003-00-00-042-000C, TMS 007-00-00-064-000C | |
| Ser | OFTString | 189 | 003, 003, 007 | |
| Map | OFTString | 18 | 00, 00, 00 | |
| Blk | OFTString | 49 | 00, 00, 00 | |
| Lot2 | OFTString | — | ||
| Sub | OFTString | 54 | 000, 000, 000 | |
| CF | OFTString | 1 | C, C, C | |
| MapNumber | OFTString | 50.0k | 003-00-00-037-000-C, 003-00-00-042-000-C, 007-00-00-064-000-C | |
| MapSearch | OFTString | 50.0k | 0030000037000C, 0030000042000C, 0070000064000C | |
| CountyBusi | OFTString | 1 | 0, 0, 0 | |
| StateFileN | OFTString | 1 | 0, 0, 0 | |
| AppealPerc | OFTString | 1 | 0, 0, 0 | |
| SubDivis_1 | OFTString | — | ||
| MortageCo | OFTString | 8 | 0, 0, 0 | |
| Jurisdic_1 | OFTString | — | ||
| BuildingCo | OFTString | 14 | 2, 1, 0 | |
| StormWater | OFTString | 171 | .00, .00, .00 | |
| BalanceNoP | OFTString | 1 | Jan 16, 2024, Jan 16, 2024, Jan 16, 2024 | |
| BalPen3Dat | OFTString | 1 | Jan 17 - Feb 1,2024, Jan 17 - Feb 1,2024, Jan 17 - Feb 1,2024 | |
| BalPen10Da | OFTString | 1 | Feb 2 - Mar 18,2024, Feb 2 - Mar 18,2024, Feb 2 - Mar 18,2024 | |
| BalPen15Da | OFTString | 1 | Mar 19, Mar 19, Mar 19 | |
| FourRatio | OFTString | 1 | 4%, 4%, 4% | |
| DueDate2 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| SchoolMill | OFTString | 1 | 0.0, 0.0, 0.0 | |
| SchoolTax | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CountyMill | OFTString | 9 | 375.5, 375.5, 375.5 | |
| CountyTax | OFTString | 1 | 0.0, 0.0, 0.0 | |
| WCDisplayY | OFTString | 1 | 0, 0, 0 | |
| Receipt | OFTString | 50.0k | 63078, 63087, 70076 | |
| RecNo | OFTString | 1 | 0, 0, 0 | |
| Barcode | OFTString | 50.0k | R20230006307800, R20230006308700, R20230007007600 | |
| PlanPymt | OFTString | 1 | false, false, false | |
| Bankruptcy | OFTString | 1 | false, false, false | |
| LevyYear | OFTString | 5 | 2023, 2023, 2023 | |
| AddDate | OFTString | 9 | 2023-09-19T00:00:00, 2023-09-19T00:00:00, 2023-09-19T00:00:00 | |
| BatchNumbe | OFTString | 1.4k | 77586, 76306, 76462 | |
| BatchOper | OFTString | 14 | 400, 320, 320 | |
| BatchDate | OFTString | 175 | 2024-01-16T00:00:00, 2023-10-16T00:00:00, 2023-10-25T00:00:00 | |
| TransNo | OFTString | 21.7k | 546571, 478341, 485640 | |
| UseShortNo | OFTString | 1 | false, false, false | |
| NoticeNumb | OFTString | 50.0k | R-2023-00063078-00, R-2023-00063087-00, R-2023-00070076-00 | |
| HomesteadM | OFTString | 4 | 156.3, 156.3, 156.3 | |
| LandAssm | OFTString | 1.8k | 580.0, 580.0, 600.0 | |
| BuildingAs | OFTString | 2.9k | 1920.0, 6280.0, 0.0 | |
| LegalPropA | OFTString | 1 | 0.0, 0.0, 0.0 | |
| LegalAssmV | OFTString | 2.6k | 2500.0, 0.0, 0.0 | |
| OtherAssmV | OFTString | 3.2k | 0.0, 6860.0, 600.0 | |
| ResExpAssm | OFTString | 2.6k | -2500.0, 0.0, 0.0 | |
| HomesteadP | OFTString | 69 | 100, 0, 0 | |
| HSApprValu | OFTString | 325 | 50000.0, 0.0, 0.0 | |
| HSAssmValu | OFTString | 164 | -2000.0, 0.0, 0.0 | |
| TotalAssmV | OFTString | 3.6k | 2500.0, 6860.0, 600.0 | |
| TotalApprV | OFTString | 39.7k | 62422.0, 114310.0, 10000.0 | |
| PersonalAp | OFTString | 1 | 0.0, 0.0, 0.0 | |
| PersonalAs | OFTString | 1 | 0.0, 0.0, 0.0 | |
| PenaltyAss | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CalCountyT | OFTString | 7.1k | 938.75, 2575.93, 225.3 | |
| HomesteadC | OFTString | 263 | -312.6, 0.0, 0.0 | |
| Residentia | OFTString | 3.5k | -548.0, 0.0, 0.0 | |
| StormWat_1 | OFTString | 123 | 60.0, 60.0, 0.0 | |
| SWUF | OFTString | 174 | 85.0, 85.0, 0.0 | |
| SWUFUnit | OFTString | 56 | 1, 1, 0 | |
| CountyCred | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Fees | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CityTax | OFTString | 4.9k | 0.0, 0.0, 0.0 | |
| CityHStdCr | OFTString | 50 | 0.0, 0.0, 0.0 | |
| CityPenalt | OFTString | 453 | 0.0, 0.0, 0.0 | |
| SWCF | OFTString | 10 | 0.0, 0.0, 0.0 | |
| TotalCalTa | OFTString | 18.4k | 223.15, 2720.93, 225.3 | |
| BalanceN_1 | OFTString | 17.3k | 223.15, 2720.93, 225.3 | |
| BalPen3 | OFTString | 17.3k | 229.84, 2802.56, 232.06 | |
| BalPen10 | OFTString | 17.3k | 245.46, 2993.03, 247.83 | |
| BalPen15 | OFTString | 17.3k | 256.62, 3129.08, 259.1 | |
| NetTax | OFTString | 13.6k | 78.15, 2575.93, 225.3 | |
| PriorYearT | OFTString | 14.9k | 222.05, 2705.84, 223.98 | |
| Millage | OFTString | 15 | 0.3755, 0.3755, 0.3755 | |
| TaxesPreAd | OFTString | 9.0k | 938.75, 2575.93, 225.3 | |
| TotalHomes | OFTString | 263 | -312.6, 0.0, 0.0 | |
| FeeTotal | OFTString | 1.2k | 145.0, 145.0, 0.0 | |
| CityMill | OFTString | 7 | 0.0, 0.0, 0.0 | |
| TotalAmoun | OFTString | 18.4k | 223.15, 2720.93, 225.3 | |
| CityAssess | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CheckNo | OFTString | 8.6k | 9282, 987, 2674 | |
| Where | OFTString | 10 | CN, ML, ML | |
| SixRatio | OFTString | 1 | 6%, 6%, 6% | |
| HomesteadI | OFTString | 1 | H, H, H | |
| DueDate | OFTString | 44 | 2024-02-02T00:00:00, 2024-01-22T00:00:00, 2024-02-20T00:00:00 | |
| AcctBlock | OFTString | 1 | D, D, D |
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.