Archive
90 attribute fields, profiled from the February 2024 vintage.
Columns in Richland County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| p_gid | OFTString | 50.0k | 3, 30, 97 | |
| geomtype | OFTString | 1 | google_poly, google_poly, google_poly | |
| tms | OFTString | 50.0k | R09307-01-11, R16414-03-15, R11315-11-07 | |
| taxparcel | OFTString | 2 | 1, 1, 1 | |
| last_edite | OFTString | 1.6k | 2017-11-26, 2019-01-31, 2017-11-26 | |
| keynum | OFTString | 50.0k | 01088227, 00630534, 00283669 | |
| address_nu | OFTString | 8.9k | 1411, 1401, 2720 | |
| address_na | OFTString | 9.8k | PEEPLES, ELMTREE, WHEAT | |
| zoning_pri | OFTString | 91 | RS-LD, RD, RS-MD | |
| taxdistric | OFTString | 22 | 1UR, 1CC, 1CC | |
| apprs | OFTString | 15 | MILTON ADAMS, DREW RICHARD, STEWART LIVINGSTON | |
| taxable_va | OFTString | 8.7k | 5300, 875000, 44700 | |
| market_val | OFTString | 8.7k | 5300, 875000, 44700 | |
| building_v | OFTString | 7.8k | 0, 835000, 51500 | |
| land_value | OFTString | 4.9k | 0, 0, 0 | |
| assessedpc | OFTString | 3 | No, No, No | |
| assessedyr | OFTString | 1 | 2023, 2023, 2023 | |
| acreage | OFTString | 3.2k | 0, 0, 0 | |
| owner_name | OFTString | 50.0k | BLANKS DAVID C, COSMETICS 4 LESS INC, ROBIN C ZIGLAR TRUST | |
| bldg1_beds | OFTString | 58 | 0, 0, 1 | |
| bldg1_bath | OFTString | 60 | 0, 0, 1 | |
| bldg1_stor | OFTString | 23 | 0, 0, 2 | |
| heated_sqf | OFTString | 6.8k | 0, 0, 766 | |
| total_sqft | OFTString | 5.0k | 0, 8960, 0 | |
| last_sale_ | OFTString | 12.4k | 19850701, 20220201, 19990506 | |
| last_sale1 | OFTString | 20.4k | 0, 875000, 25000 | |
| last_sal_1 | OFTString | 24 | Q, Q, Q | |
| last_sal_2 | OFTString | 2 | V, I, I | |
| last_sal_3 | OFTString | 7.0k | D750, R2711, R0304 | |
| last_sal_4 | OFTString | 5.3k | 0553, 0193, 1312 | |
| legal_desc | OFTString | 50.0k | PT LOT 2 #SU #PR X-1557, PT LOT 5 56X46X56X46X #SU #PR RB304-1323, PARCEL C 72.8X296.1X72.8X294.7 #SU #PR | |
| legal_de_1 | OFTString | — | ||
| legal_de_2 | OFTString | — | ||
| legal_de_3 | OFTString | — | ||
| optedout | OFTString | 2 | 0, 0, 0 | |
| sch_dist | OFTString | 3 | Richland School District 1, Richland School District 1, Richland School District 1 | |
| garbday | OFTString | 6 | Monday, No Pickup, No Pickup | |
| recycday | OFTString | 11 | Friday EOW-A, No Pickup, No Pickup | |
| popden90 | OFTString | 2.3k | 672, 7077, 5480 | |
| medinc90 | OFTString | 242 | 25927, 22773, 32045 | |
| medval90 | OFTString | 218 | 48100, 70400, 95000 | |
| popden00 | OFTString | 3.6k | 727, 11790, 5553 | |
| medinc00 | OFTString | 225 | 40000, 30000, 44076 | |
| medval00 | OFTString | 203 | 60300, 92900, 161400 | |
| popden10 | OFTString | 6.0k | 603.100878, 12842.915702, 5568.64881 | |
| medinc10 | OFTString | 234 | 33405, 28545, 36087 | |
| medval10 | OFTString | 211 | 82700, 148900, 311900 | |
| cncldist | OFTString | 12 | 4, 11, 5 | |
| cnclrep | OFTString | 11 | Paul Livingston, Chakisse Newton, Allison Terracio | |
| sntedist | OFTString | 9 | 19, 21, 20 | |
| snterep | OFTString | 5 | John L. Scott, Jr., Darrell Jackson, John E. Courson | |
| hsedist | OFTString | 16 | 73, 70, 72 | |
| hserep | OFTString | 15 | Christopher R. Hart, Jermaine L. Johnson, Sr., Seth Rose | |
| magjudge | OFTString | 11 | JUDGE TOMOTHY EDMOND, JUDGE BARBARA WOFFORD-KANWAT, JUDGE HAROLD CUFF | |
| cngrdist | OFTString | 4 | 6, 2, 6 | |
| cngrrep | OFTString | 4 | James Clyburn, Joe Wilson, James Clyburn | |
| elev | OFTString | 481 | 165, 268, 284 | |
| yardwday | OFTString | 6 | Thursday, No Pickup, No Pickup | |
| voteprec | OFTString | 149 | Dennyside, Brandon 1, Ward 12 | |
| voteloc | OFTString | 139 | Denny Terrace Gym, Annie Burnside Elementary, Hand Middle School | |
| magdist | OFTString | 11 | UPPER TOWNSHIP, LYKESLAND, OLYMPIA | |
| muniname | OFTString | 7 | Columbia, Columbia, Columbia | |
| shrfreg | OFTString | 7 | 3, 1, 1 | |
| parcel_cen | OFTString | 50.0k | -81.057329518718, -80.939102068109, -81.004861099378 | |
| parcel_c_1 | OFTString | 50.0k | 34.060034720427, 33.9745441689, 33.994884963134 | |
| streetview | OFTString | 50.0k | -81.057077143233, -80.939150724902, -81.004824175801 | |
| streetvi_1 | OFTString | 50.0k | 34.059691842145, 33.974221781572, 33.99541357862 | |
| streetvi_2 | OFTString | 50.0k | 323.64508158451, 8.5826752272619, 183.99559721722 | |
| nbhd_area | OFTString | 980 | 040.00, 021.00, 111.26 | |
| bldg1_yrbu | OFTString | 165 | 1940, 2006, 1989 | |
| address_di | OFTString | 6 | S, E, S | |
| zoning_sec | OFTString | 1 | RM-MD | |
| acres | OFTString | 3.2k | 0, 0, 0 | |
| mkt_val | OFTString | 8.7k | 5,300, 875,000, 44,700 | |
| last_sale | OFTString | 12.3k | July 1, 1985, February 1, 2022, May 6, 1999 | |
| parcel_id | OFTString | 50.0k | R09307-01-11, R16414-03-15, R11315-11-07 | |
| o_gid | OFTString | 50.0k | 6771, 127964, 144985 | |
| pid | OFTString | 50.0k | R09307-01-11, R16414-03-15, R11315-11-07 | |
| owner | OFTString | 50.0k | BLANKS DAVID C, COSMETICS 4 LESS INC, ROBIN C ZIGLAR TRUST | |
| mail_addr1 | OFTString | 50.0k | 1322 WINYAH DR, 25 CHATHAM ST, 709 WOODROW ST PMB 317 | |
| mail_addr2 | OFTString | 1.8k | OPTED OUT, PO BOX 147, OPTED OUT | |
| mail_city | OFTString | 1.9k | COLUMBIA, SAVANNAH, COLUMBIA | |
| mail_st | OFTString | 60 | SC, GA, SC | |
| mail_zip | OFTString | 27.5k | 292032922, 314065879, 292050000 | |
| legal1 | OFTString | 50.0k | PT LOT 2 #SU #PR X-1557, PT LOT 5 56X46X56X46X #SU #PR RB304-1323, PARCEL C 72.8X296.1X72.8X294.7 #SU #PR | |
| legal2 | OFTString | — | ||
| legal3 | OFTString | — | ||
| legal4 | OFTString | — | ||
| situs | OFTString | 50.0k | 1411 PEEPLES, 1401 ELMTREE, 2720 WHEAT | |
| zone | OFTString | 91 | RS-LD, RD, RS-MD |
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.