43 attribute fields, profiled from the February 2023 vintage.
Columns in King County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| PARCEL_ID | OFTString | 50.0k | 1421059017, 3410600485, 3410600480 | |
| SITUS | OFTString | 50.0k | 33003 EAST LAKE HOLM DR SE, 33010 EAST LAKE HOLM DR SE, 33014 EAST LAKE HOLM DR SE | |
| ADDR_NUMBE | OFTString | 26.6k | 33003, 33010, 33014 | |
| STREET_PRE | OFTString | 24 | E, E, E | |
| STREET_NAM | OFTString | 1.5k | LAKE HOLM, LAKE HOLM, LAKE HOLM | |
| STREET_SUF | OFTString | 8 | SE, SE, SE | |
| STREET_TYP | OFTString | 20 | Dr, Dr, Dr | |
| SITUS_CITY | OFTString | 28 | AUBURN, AUBURN, AUBURN | |
| SITUS_ZIP | OFTString | 77 | 98092, 98092, 98092 | |
| ADDR_SEC_U | OFTString | 5 | 209, E, N | |
| OWNER | OFTString | 50.0k | BEJARNO MICHAEL G+ELIZABETH, MARCHUK ALEKSANDR+NADEZHDA, MIKESELL SCOTT W+TAMELA L | |
| LAND_USE_C | OFTString | 115 | 2 Single Family(Res Use/Zone), 2 Single Family(Res Use/Zone), 2 Single Family(Res Use/Zone) | |
| LAND_US_01 | OFTString | 5 | Residential, Residential, Residential | |
| LAND_COVER | OFTString | 50.0k | {"21": 27, "43": 167}, {"21": 20, "41": 2, "43": 324}, {"21": 63, "43": 242} | |
| CROP_COVER | OFTString | 50.0k | {"141": 0.03, "142": 0.36, "143": 0.32, "190": 0.08}, {"142": 0.04, "143": 0.59, "190": 0.15}, {"121": 0.15, "122": 0.3, "143": 0.0, "190": 0.1} | |
| MUNI_ID | OFTInteger64 | 4 | 1939504, 1939504, 1939504 | |
| SCHOOL_DIS | OFTInteger64 | 22 | 5300300, 5300300, 5300300 | |
| ACREAGE_AD | OFTReal | 50.0k | 31.8059316372612, 0.783977897465025, 0.780414309577883 | |
| MKT_VAL_LA | OFTReal | 10.3k | 588000.0, 151000.0, 151000.0 | |
| MKT_VAL_BL | OFTReal | 8.9k | 657000.0, 501000.0, 332000.0 | |
| ZIP_CODE | OFTString | 68 | 98092, 98092, 98092 | |
| BUILDINGS | OFTInteger64 | 59 | 0, 1, 1 | |
| PLSS_SECTI | OFTString | 36 | 14, 14, 14 | |
| PLSS_TOWNS | OFTString | 8 | 21N, 21N, 21N | |
| PLSS_RANGE | OFTString | 10 | 5E, 5E, 5E | |
| MAIL_ADDRE | OFTString | 50.0k | PO BOX 2137, 33010 E LAKE HOLM DR SE, 33014 E LAKEHOLM DR SE | |
| MAIL_AD_01 | OFTString | 5.1k | AUBURN WA 98071, AUBURN WA 98092, AUBURN WA 98092 | |
| MAIL_NAME | OFTString | 4.2k | EASTER CORINNE+JOHN DILLON, CHRISTIAN-WILLIAMS SANDRA, WILLIAM A & SHIRLEY A TRSTEE | |
| OWNER_OCCU | OFTString | 3 | F, T, F | |
| USPS_RESID | OFTString | 3 | T, T, T | |
| CENSUS_TRA | OFTInteger64 | 258 | 31204, 31204, 31204 | |
| CENSUS_BLK | OFTInteger | 8 | 2, 2, 2 | |
| CENSUS_BLO | OFTInteger | 629 | 2005, 2005, 2005 | |
| AREA_METER | OFTReal | 50.0k | 128711.633026835, 3172.58669201985, 3158.16563302935 | |
| FLD_ZONE | OFTString | 1 | {D}, {D} | |
| PLACE_GNIS | OFTInteger64 | 43 | 2584994, 2584994, 2584994 | |
| ELEVATION | OFTString | 50.0k | {"max": 0.0, "min": 0.0, "mean": 0.0}, {"max": 0.0, "min": 0.0, "mean": 0.0}, {"max": 0.0, "min": 0.0, "mean": 0.0} | |
| ROBUST_ID | OFTString | 50.0k | AADPKR4xqa-s205X, AADPKVPm3VJK6kjL, AADPKX6bM7Jwg8Tc | |
| CALC_ACREA | OFTReal | 50.0k | 31.8059316372612, 0.783977897465025, 0.780414309577883 | |
| COUNTY_NAM | OFTString | 1 | King, King, King | |
| COUNTY_FIP | OFTInteger64 | 1 | 53033, 53033, 53033 | |
| STATE_ABBR | OFTString | 1 | WA, WA, WA | |
| CTY_ROW_ID | OFTInteger64 | 50.0k | 99292, 99807, 99167 |
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.