Archive
111 attribute fields, profiled from the June 2024 vintage.
Columns in York County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| key | OFTString | 50.0k | 0030000006, 0050000001, 0070000003 | |
| o_parcel_i | OFTString | 50.0k | 0030000006, 0050000001, 0070000003 | |
| pid | OFTString | 50.0k | 0030000006, 0050000001, 0070000003 | |
| account | OFTString | 50.0k | 65414, 65463, 65477 | |
| map_no | OFTString | 50.0k | 0030000006, 0050000001, 0070000003 | |
| owner | OFTString | 50.0k | WHISNANT SHOALS FARM LLC, WHISNANT SHOALS FARM LLC, HAMRICK JOE | |
| mail_addr1 | OFTString | 50.0k | 527 JOSLIN POINT LANE, 527 JOSLIN POINTE LN, 13217 SMITH FORD RD | |
| mail_addr3 | OFTString | 4.0k | ROCK HILL SC 29732, ROCK HILL SC 29732, HICKORY GROVE SC 29717 | |
| legal | OFTString | 50.0k | HWY 816 (Note: Not to be used on legal documents.), 16 AC (Note: Not to be used on legal documents.), 2 AC (Note: Not to be used on legal documents.) | |
| acres | OFTString | 4.0k | 65.0, 147.62, 229.24 | |
| tax_dist | OFTString | 44 | YORK COUNTY DISTRICT 1 - HICKORY GROV FIRE, YORK COUNTY DISTRICT 1 - HICKORY GROV FIRE, YORK COUNTY DISTRICT 1 - HICKORY GROV FIRE | |
| nbhd | OFTString | 851 | NBC01, NBC01, NBC01 | |
| yearbuilt | OFTString | 86 | 2020, 0, 0 | |
| totval | OFTString | 50.0k | *411,552, 11,957, *62,675 | |
| mktlnd | OFTString | 11.1k | 1,031,590, 533,020, 818,690 | |
| mktimpv | OFTString | 50.0k | 393,774, 0, 0 | |
| mkttot | OFTString | 50.0k | 1,471,864, 533,020, 873,190 | |
| assdval | OFTString | 26.0k | 24,130, 478, 743 | |
| mh_accesso | OFTString | 16.3k | ||
| situs | OFTString | 50.0k | 13679 SMITH FORD RD, 13307 SMITH FORD RD, 13530 SMITH FORD RD | |
| saledate | OFTString | 10.1k | 5/20/2011, 12/10/2014, 4/14/2022 | |
| saleprice | OFTString | 18.0k | 1,200,000, 387,500, 0 | |
| salebook | OFTString | 19.8k | 11989, 14551, 20118 | |
| mail_addr2 | OFTString | 4.6k | 680 NW 35TH CT, 8702 RED OAK BLVD STE C, PO BOX 37996 | |
| style | OFTString | 95 | Residential / RES, Residential / RES, Attached Manufactured Home / MH_A | |
| stories | OFTString | 9 | 2, 1, 1 | |
| parcel_id | OFTString | 50.0k | 0030000006, 0050000001, 0070000003 | |
| Acres2 | OFTString | — | ||
| ParcelNumb | OFTString | 50.0k | 003-00-00-006, 005-00-00-001, 007-00-00-003 | |
| NumLots | OFTString | 2 | 0, 0, 0 | |
| NumBuildin | OFTString | 33 | 3, 0, 0 | |
| Pen3Date | OFTString | 1 | 2024-01-17T00:00:00, 2024-01-17T00:00:00, 2024-01-17T00:00:00 | |
| Pen10Date | OFTString | 1 | 2024-02-02T00:00:00, 2024-02-02T00:00:00, 2024-02-02T00:00:00 | |
| Pen15Date | OFTString | 1 | 2024-03-19T00:00:00, 2024-03-19T00:00:00, 2024-03-19T00:00:00 | |
| RealProper | OFTString | 1 | true, true, true | |
| FormattedR | OFTString | 50.0k | 116955-23-3, 116956-23-3, 045432-23-3 | |
| Delinquent | OFTString | 2 | false, false, false | |
| DeleteNoti | OFTString | 1 | false, false, false | |
| OwnerName1 | OFTString | 50.0k | WHISNANT SHOALS FARM LLC, WHISNANT SHOALS FARM LLC, HAMRICK JOE D TRUSTEE ETAL | |
| Descriptio | OFTString | 50.0k | BROAD RIVER & RIVER RD(289.40), SMITH FORD RD (BIRNBAUM TRACT), TR# A (229.24AC)SMITHFORD RD | |
| District | OFTString | 38 | 1HG, 1HG, 1HG | |
| TownCode | OFTString | 10 | SM, SM, SM | |
| PostmarkDa | OFTString | 188 | 2023-10-18T00:00:00, 2023-10-18T00:00:00, 2023-11-09T00:00:00 | |
| Delinque_1 | OFTString | 1 | false, false, false | |
| IDHash | OFTString | 50.0k | A22E71B28EE7095B440F7D87AD126075, 54871F223C0F74F8A91C1A7F78142E06, 837B56CD7E3D721971F74EAE859B42CF | |
| Hash | OFTString | 50.0k | ||
| Version | OFTString | 12 | 2, 2, 2 | |
| BillingID | OFTString | 50.0k | 003-00-00-006, 005-00-00-001, 007-00-00-003 | |
| LastUpdate | OFTString | 25.3k | 2023-10-19T08:36:59.5842217Z, 2023-10-19T08:36:59.5842217Z, 2023-11-10T08:33:31.9616233Z | |
| BillDate | OFTString | 162 | 2023-09-23T00:00:00Z, 2023-09-23T00:00:00Z, 2023-09-23T00:00:00Z | |
| DueDate | OFTString | 2 | 2024-01-15T00:00:00, 2024-01-15T00:00:00, 2024-01-15T00:00:00 | |
| PaymentCat | OFTString | 1 | 1, 1, 1 | |
| Year | OFTString | 1 | 2023, 2023, 2023 | |
| Name | OFTString | 50.0k | WHISNANT SHOALS FARM LLC, WHISNANT SHOALS FARM LLC, HAMRICK JOE D TRUSTEE ETAL | |
| RecordType | OFTString | 3 | Property, Property, Property | |
| CartPaymen | OFTString | 4.8k | 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 | 38.6k | STEPHENS DUSTIN KEITH, MOORE NELLIE MAE ROBERSON, WIGGINS KARI S | |
| OwnerLine2 | OFTString | 50.0k | 527 JOSLIN POINT LANE, 527 JOSLIN POINTE LN, 13217 SMITH FORD RD | |
| OwnerCity | OFTString | 1.7k | ROCK HILL SC, ROCK HILL SC, HICKORY GROVE SC | |
| OwnerZip | OFTString | 3.5k | 29732, 29732, 29717 | |
| SitusLine1 | OFTString | 50.0k | BROAD RIVER & RIVER RD(289.40), SMITH FORD RD (BIRNBAUM TRACT), TR# A (229.24AC)SMITHFORD RD | |
| CityGrossT | OFTString | 25.0k | 0.0, 0.0, 0.0 | |
| CityHomest | OFTString | 399 | 0.0, 0.0, 0.0 | |
| CityLocalO | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CityLoca_1 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CityManufa | OFTString | 3 | 0.0, 0.0, 0.0 | |
| CityMills | OFTString | 9 | 0.0, 0.0, 0.0 | |
| CountyGros | OFTString | 50.0k | 10224.3, 202.53, 314.81 | |
| CountyHome | OFTString | 1.4k | 0.0, 0.0, 0.0 | |
| CountyLoca | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CountyLo_1 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CountyManu | OFTString | 9 | 0.0, 0.0, 0.0 | |
| CountyLega | OFTString | 36.3k | 0.0, 0.0, 0.0 | |
| CountyMill | OFTString | 29 | 423.7, 423.7, 423.7 | |
| Costs | OFTString | 3 | 0.0, 0.0, 0.0 | |
| Fee1 | OFTString | 191 | 0.0, 0.0, 0.0 | |
| Fee2 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Fee3 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Fee4 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Fee5 | OFTString | 1 | 0.0, 0.0, 0.0 | |
| VehicleRen | OFTString | 1 | 0.0, 0.0, 0.0 | |
| CreditCard | OFTString | 1 | 0.0, 0.0, 0.0 | |
| DecalFee | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Net_3PctPe | OFTString | 50.0k | 10531.03, 208.61, 324.25 | |
| Net_10PctP | OFTString | 50.0k | 11246.73, 222.78, 346.29 | |
| Net_15PctP | OFTString | 50.0k | 11757.95, 232.91, 362.03 | |
| LotAssessm | OFTString | 2 | 0, 0, 0 | |
| AcreAssess | OFTString | 8.1k | 1433, 478, 743 | |
| BuildingAs | OFTString | 22.9k | 22698, 0, 0 | |
| BuildingAp | OFTString | 50.0k | 0, 0, 0 | |
| Building_1 | OFTString | 15.7k | 378295, 0, 0 | |
| Building_2 | OFTString | 68 | 0, 0, 0 | |
| LandApprai | OFTString | 31.0k | 28102, 11957, 18568 | |
| LandAppr_1 | OFTString | 9.8k | 5155, 0, 0 | |
| LandAppr_2 | OFTString | 63 | 0, 0, 0 | |
| BaseTax | OFTString | 50.0k | 10224.3, 202.53, 314.81 | |
| Penalty | OFTString | 7.2k | 0.0, 0.0, 0.0 | |
| Interest | OFTString | 1 | 0.0, 0.0, 0.0 | |
| Assessed | OFTString | 26.0k | 24131, 478, 743 | |
| Appraised | OFTString | 50.0k | 411552, 11957, 18568 | |
| OriginalAm | OFTString | 50.0k | 10224.3, 202.53, 314.81 | |
| AmountDue | OFTString | 4.8k | 0.0, 0.0, 0.0 | |
| Descript_1 | OFTString | 11.9k | H 28X72, HERN ENERGY 32X6, 13965 SMITH FORD RD | |
| HomesteadC | OFTString | 2 | H, H, H | |
| LenderCode | OFTString | 1 | IN, IN, IN | |
| ReplacedBy | OFTString | 391 | 072887235, 072417235, 072300235 | |
| DORNumber | OFTString | 85 | 6-2200081, 6-1297926, 6-2092563 |
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.