Aged
141 attribute fields, profiled from the October 2022 vintage.
Columns in Payette County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| PIN | OFTString | 12.9k | 05N04W022580, 05N04W010011, 05N04W020000 | |
| Alternatie | OFTString | 12.9k | 4-1, 1, 4 | |
| Parcels_Sh | OFTString | 1.6k | 2580, 0011, 0000 | |
| Parcels_GI | OFTString | 13.2k | 7.55500441124e+00, 6.43178620046e+01, 1.90555765961e+02 | |
| GIS_SQFFT | OFTString | 13.2k | 3.29094675771e+05, 2.80167486219e+06, 8.30057596284e+06 | |
| Parcels__2 | OFTString | 13.2k | 2.74363834068e+03, 6.96510700252e+03, 1.24472224047e+04 | |
| Parcels__3 | OFTString | 13.2k | 3.29094675771e+05, 2.80167486219e+06, 8.30057604761e+06 | |
| Parcels_LR | OFTString | 12.9k | 10010, 16918, 10009 | |
| PIN_OID | OFTString | 12.9k | 1214, 1202, 1213 | |
| PIN_PIN | OFTString | 12.9k | 05N04W022580, 05N04W010011, 05N04W020000 | |
| PIN_Ngrhd | OFTString | 77 | 63060, 61030, 61060 | |
| Owner1 | OFTString | 9.2k | BLESSINGER HAZEL FAMILY TRUST, MCCOLLOUGH ALVIN R, BLESSINGER TRUST HAZEL FAMILY | |
| Owner2 | OFTString | 3.9k | MCCOLLOUGH DON E, MILLER CALLEE R, BROWNLEE ELIZABETH A | |
| PIN_OwnerS | OFTString | 8.3k | 2053 COVE RD, 29881 FARMWAY RD, 2053 COVE RD | |
| PIN_OwnerC | OFTString | 322 | WEISER, CALDWELL, WEISER | |
| PIN_Owne_1 | OFTString | 37 | ID, ID, ID | |
| PIN_OwnerZ | OFTString | 387 | 83672, 83607, 83672 | |
| PropStr | OFTString | 9.7k | 5155 OASIS RD, 415 MARKET RD, 5185 OASIS RD | |
| PropCity | OFTString | 15 | Caldwell, CALDWELL, Caldwell | |
| PropSt | OFTString | 2 | ID, ID, ID | |
| PIN_PropZi | OFTString | 7 | 83607, 83660, 83607 | |
| PIN_PropCl | OFTString | — | ||
| PIN_TaxCdA | OFTString | 26 | 015-0000, 015-0000, 015-0000 | |
| PIN_LastSe | OFTString | 214 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| PIN_Last_1 | OFTString | 4.2k | 20011129, 20220414, 20011129 | |
| PIN_LastAs | OFTString | 11.7k | 2.77691000000e+05, 2.60807000000e+05, 2.60346000000e+05 | |
| PIN_FirstP | OFTString | 11.0k | 7.08860000000e+02, 1.04636000000e+03, 7.92620000000e+02 | |
| PIN_Second | OFTString | 10.8k | 4.82740000000e+02, 8.84560000000e+02, 6.18500000000e+02 | |
| PIN_ThirdP | OFTString | 10.8k | 5.03040000000e+02, 1.03706000000e+03, 7.56840000000e+02 | |
| PIN_Fourth | OFTString | 10.6k | 5.15040000000e+02, 9.41180000000e+02, 7.71080000000e+02 | |
| PIN_FifthP | OFTString | 10.5k | 5.55040000000e+02, 1.03965000000e+03, 8.40480000000e+02 | |
| PIN_PrevTx | OFTString | 12.0k | 1.28326000000e+04, 2.19769900000e+04, 3.32138900000e+04 | |
| PIN_Prev_1 | OFTString | 1 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| PIN_Prev_2 | OFTString | 12.0k | -1.28326000000e+04, -2.21692200000e+04, -3.32138900000e+04 | |
| PIN_PrvTxO | OFTString | 12.0k | 2.56652000000e+04, 4.41462100000e+04, 6.64277800000e+04 | |
| PIN_CurTxB | OFTString | 12.6k | 34641426, 34646299, 34641425 | |
| PIN_CurT_1 | OFTString | 1 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| PIN_CurTxO | OFTString | 262 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| PIN_TotTxO | OFTString | 12.0k | 2.56652000000e+04, 4.41462100000e+04, 6.64277800000e+04 | |
| PIN_CurPTR | OFTString | 1 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| PIN_HOExem | OFTString | 1.3k | 0, 0, 0 | |
| PIN_TotBas | OFTString | 2.4k | 924, 698, 0 | |
| PIN_TotFin | OFTString | 2.3k | 924, 698, 0 | |
| PIN_BsmtFi | OFTString | 611 | 0, 0, 0 | |
| PIN_MainFi | OFTString | 2.0k | 924, 698, 0 | |
| PIN_UpperF | OFTString | 424 | 0, 0, 0 | |
| PIN_AtticB | OFTString | 8 | 0, 0, 0 | |
| PIN_AtticF | OFTString | 3 | 0, 0, 0 | |
| PIN_GarBas | OFTString | 657 | 0, 0, 0 | |
| PIN_CPBase | OFTString | 31 | 0, 0, 0 | |
| PIN_LglAcr | OFTString | 3.4k | 6.00000000000e+00, 6.43179000000e+01, 1.90650000000e+02 | |
| PIN_LglAdd | OFTString | 12.9k | W 330 FT OF LOT 3 N OF D LINE CANAL SEC 2-5-4, SEC 1-5-4 GOVT LTS 1 & 2 EX TAX 742 & DEEDED R/W, SEC 1-5-4 S1/2NE LESS TAX 1 93 MARLETTE MH | |
| PIN_Deed1 | OFTString | 8.6k | 444931, 418361, 425090 | |
| PIN_Deed2 | OFTString | 1.4k | 444929, 447779, 444269 | |
| PIN_Deed3 | OFTString | 1.2k | 444931, 359281, 427752 | |
| PIN_Deed4 | OFTString | 265 | 444929, 430936, 445926 | |
| PIN_Deed5 | OFTString | 233 | 265207, 430931, 445928 | |
| PIN_LRSN | OFTString | 12.9k | 10010, 16918, 10009 | |
| PIN_HouseN | OFTString | 3.8k | 2053, 29881, 2053 | |
| PIN_PreDir | OFTString | 8 | S, SE, SE | |
| PIN_Street | OFTString | 1.1k | COVE, FARMWAY, COVE | |
| PIN_Stre_1 | OFTString | 20 | RD, RD, RD | |
| PIN_PostDi | OFTString | 8 | E, E, NE | |
| PIN_City | OFTString | 322 | WEISER, CALDWELL, WEISER | |
| PIN_Countr | OFTString | 2 | Sweden, Canada, Canada | |
| PIN_Owner3 | OFTString | 195 | MCCOLLOUGH J J, CONNER PHILIP O, VISSER HELEN A | |
| PIN_Owner4 | OFTString | 49 | FISH MARIETTA, HOLIDAY SHANNA M, VISSER FRED J | |
| PIN_Owner5 | OFTString | 13 | MCCOLLOUGH BONNIE L, RICHARDS ANNA CONNER, LEGG MERLYNN | |
| PIN_Owner6 | OFTString | 9 | MCCOLLOUGH EARL, SOUTHWELL ALTA HELEN CONNER, LEGG STANLEY R JR | |
| PIN_Owne_2 | OFTString | — | ||
| PIN_PPValu | OFTString | 2 | 0, 0, 0 | |
| PIN_HouseT | OFTString | 31 | 89 MOBILE HOME ON REAL, 11 All Ages Less Than 800 SqFt, 89 MOBILE HOME ON REAL | |
| PIN_ESRI_O | OFTString | 1 | 0, 0, 0 | |
| IMPV_OID | OFTString | 9.3k | 9108, 20981, 9104 | |
| IMPV_PIN | OFTString | 9.3k | 05N04W022580, 05N04W010011, 05N04W020000 | |
| IMPV_Ext | OFTString | 8 | R01, R01, R01 | |
| IMPV_group | OFTString | 24 | 48H, 31H, 32 | |
| IMPV_ImpID | OFTString | 24 | M, 01, 01 | |
| IMPV_Ngrhd | OFTString | 76 | 63060, 61030, 61060 | |
| IMPV_Flrs | OFTString | 6 | 0, 0, 0 | |
| IMPV_ImpTy | OFTString | 107 | MHOME, SHED, SHED | |
| IMPV_Grade | OFTString | 15 | Low, Avg, Avg | |
| IMPV_Cond | OFTString | 7 | AV, VP, F | |
| IMPV_YrBlt | OFTString | 133 | 1979, 1950, 1950 | |
| IMPV_EffYr | OFTString | 132 | 1979, 1950, 1950 | |
| IMPV_Value | OFTString | 6.3k | 37346, 200, 340 | |
| IMPV_BaseA | OFTString | 2.3k | 924, 168, 81 | |
| IMPV_FinAr | OFTString | 1.6k | 0, 0, 0 | |
| IMPV_OccpD | OFTString | 10 | Single family, 1 family-owner, 1 family-tenant | |
| IMPV_ImpHg | OFTString | 26 | 0.00000e+00, 5.00000e+00, 6.00000e+00 | |
| IMPV_ImpWi | OFTString | 72 | 1.40000e+01, 1.20000e+01, 9.00000e+00 | |
| IMPV_ImpLg | OFTString | 114 | 6.60000000000e+01, 1.40000000000e+01, 9.00000000000e+00 | |
| IMPV_ImpCa | OFTString | 12 | 0, 0, 0 | |
| IMPV_SVRea | OFTString | 4 | 0, 0, 0 | |
| IMPV_LstRv | OFTString | 6 | 2019, 2019, 2019 | |
| IMPV_PropC | OFTString | 30 | 548 MH Real Property Own Land, 131 Res Impr on Cat 10, 131 Res Impr on Cat 10 | |
| IMPV_Floor | OFTString | — | ||
| IMPV_KitRm | OFTString | 6 | 0, 0, 0 | |
| IMPV_LivRm | OFTString | 6 | 0, 0, 0 | |
| IMPV_GrtRm | OFTString | 4 | 0, 0, 0 | |
| IMPV_DinRm | OFTString | 3 | 0, 0, 0 | |
| IMPV_BedRm | OFTString | 10 | 0, 0, 0 | |
| IMPV_OthRm | OFTString | 8 | 0, 0, 0 | |
| IMPV_BathR | OFTString | 8 | 0, 0, 0 | |
| IMPV_ExtFi | OFTString | 5 | 0, 0, 0 | |
| IMPV_MHMak | OFTString | 24 | FLEETWOOD, FLEETWOOD, KIT | |
| IMPV_MHMod | OFTString | 10 | BARRINGTON, SEQUOIA, PARAMOUNT | |
| IMPV_MHPar | OFTString | 1 | NOT IN PARK, NOT IN PARK, NOT IN PARK | |
| IMPV_MHSer | OFTString | 459 | IDFLN04A15438SR, IDFLV04A20427-BF13, CGHRR79C4CKFRS6412 | |
| IMPV_Decal | OFTString | 1 | 0, 0, 0 | |
| IMPV_Dec_1 | OFTString | 1 | 0, 0, 0 | |
| IMPV_FndFo | OFTString | 3 | Normal for class, Normal for class, Normal for class | |
| IMPV_FndWa | OFTString | 5 | Formed conc, Concrete or block, Concrete or block | |
| IMPV_RoofC | OFTString | 23 | Metal, Comp sh to 235#, Enamel steel | |
| IMPV_RoofT | OFTString | 8 | Flat or Shed, 0, 0 | |
| IMPV_Heati | OFTString | 29 | Forced hot air-elec, Forced hot air-gas, Forced hot air-elec | |
| IMPV_Centr | OFTString | 4 | Central air, Central air, Central air | |
| IMPV_Firpl | OFTString | 2 | N, N, N | |
| IMPV_lrsn | OFTString | 9.3k | 10010, 16918, 10009 | |
| IMPV_House | OFTString | 31 | 89 MOBILE HOME ON REAL, 11 All Ages Less Than 800 SqFt, 89 MOBILE HOME ON REAL | |
| IMPV_ESRI_ | OFTString | 1 | 0, 0, 0 | |
| LAND_OID | OFTString | 12.9k | 68, 1205, 2942 | |
| LAND_PIN | OFTString | 12.9k | 05N04W022580, 05N04W010011, 05N04W020000 | |
| LAND_Line_ | OFTString | 1 | 0, 0, 0 | |
| LAND_Ngrhd | OFTString | 77 | 63060, 61030, 61060 | |
| LAND_TypeD | OFTString | 19 | Residential Excess Acreag, Irrigated Cropland - Type, Grazing Land / Rangeland | |
| LAND_Metho | OFTString | 10 | 49 User Definable Land F, 33 Per Acre (by site rat, 33 Per Acre (by site rat | |
| LAND_Acres | OFTString | 4.7k | 5.96500000000e+00, 5.60920000000e+00, 7.58300000000e+01 | |
| LAND_SqrFt | OFTString | 5.3k | 2.59835000000e+05, 2.44337000000e+05, 0.00000000000e+00 | |
| LAND_ActFr | OFTString | 700 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| LAND_EffFr | OFTString | 400 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| LAND_EffDp | OFTString | 473 | 0.00000000000e+00, 0.00000000000e+00, 0.00000000000e+00 | |
| LAND_Cat | OFTString | 23 | 12, 01, 05 | |
| LAND_Value | OFTString | 4.4k | 1.26200000000e+05, 5.45100000000e+03, 3.56400000000e+03 | |
| LAND_ValMe | OFTString | 1 | Cost, Cost, Cost | |
| LAND_SoilI | OFTString | — | ||
| LAND_SiteR | OFTString | 27 | 2F, GC, GB | |
| LAND_LandU | OFTString | 1 | AC, AC, AC | |
| LAND_Syste | OFTString | 1 | PV, PV, PV | |
| LAND_lrsn | OFTString | 12.9k | 10010, 16918, 10009 | |
| LAND_ESRI_ | OFTString | 1 | 0, 0, 0 |
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.