Archive
209 attribute fields, profiled from the April 2024 vintage.
Columns in Payne County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 34.7k | 26299, 26277, 26283 | |
| propertyid | OFTInteger | 34.7k | 600082399, 600082386, 600057387 | |
| yearid | OFTInteger | 1 | 2024, 2024, 2024 | |
| parcelid | OFTString | 34.7k | 17N01E-15-1-00000-000-0001.002, 17N01E-10-2-00000-000-0251.001, 17N01E-10-3-00000-000-0501.001 | |
| useraccoun | OFTString | 34.7k | 00000-17N01E-15A001, 00000-17N01E-10B251, 00000-17N01E-10C501 | |
| landusecod | OFTString | 29 | PPMH - Personal Property MH, PPMHSTG - Personal Property Mobile Home - Storage, PPMH - Personal Property MH | |
| compositel | OFTString | 29 | PPMH - Personal Property MH, PPMHSTG - Personal Property Mobile Home - Storage, PPMH - Personal Property MH | |
| neighborho | OFTString | 20 | 609000 - Manufactured Homes, 609000 - Manufactured Homes, 609000 - Manufactured Homes | |
| neighbor_1 | OFTString | 26 | CushComm - Cushing Commercial, CushComm - Cushing Commercial, CushComm - Cushing Commercial | |
| improvedst | OFTString | 3 | Improved - Improved, Improved - Improved, Improved - Improved | |
| totalarea | OFTReal | 3.8k | 0.0, 0.0, 0.0 | |
| totalareau | OFTString | 4 | Acres - Acres, Acres - Acres, Acres - Acres | |
| parcelgrou | OFTString | 1 | HullReese - Hull - Reese Office Bldg | |
| inactiveye | OFTInteger | 11 | 2017, 2017, 2017 | |
| propertycr | OFTString | 163 | 2017-05-11, 2017-05-11, 2017-05-11 | |
| property_1 | OFTInteger | 11 | 2017, 2017, 2017 | |
| districtgr | OFTString | 23 | 326 - Coyle (L14R), 326 - Coyle (L14R), 326 - Coyle (L14R) | |
| accounttyp | OFTString | 4 | 935 - Manufactured Home, 935 - Manufactured Home, 935 - Manufactured Home | |
| marketarea | OFTString | 9 | Trio - Trio Ranch, Trio - Trio Ranch, Trio - Trio Ranch | |
| appraisala | OFTString | 16 | 2200 - Team 2, 2200 - Team 2, 2200 - Team 2 | |
| totalfront | OFTReal | — | ||
| primaryjur | OFTString | 12 | Coyle - Coyle, Stillwater - Stillwater, Coyle - Coyle | |
| geoneighbo | OFTString | — | ||
| deedsize | OFTReal | — | ||
| gissize | OFTReal | — | ||
| streetcond | OFTString | 1 | ABC - AppraisalEst, ABC - AppraisalEst, ABC - AppraisalEst | |
| topography | OFTString | — | ||
| traffic | OFTString | 2 | SHELTER - Storm Shelter, SHELTER - Storm Shelter, SHELTER - Storm Shelter | |
| highestand | OFTString | 3 | 3 - District 3, 3 - District 3, 3 - District 3 | |
| assessorma | OFTString | 13 | Coyle, Coyle, Coyle | |
| censustrac | OFTString | 2 | 2020, 2020, 2024 | |
| zcoordinat | OFTString | 1 | 36.094263 | |
| ycoordinat | OFTString | 29.3k | 35.955597, 35.9565899, 35.9566 | |
| xcoordinat | OFTString | 31.3k | -97.182787, -97.1803344, -97.1915 | |
| district_1 | OFTString | 1 | 1900-01-01, 1900-01-01, 1900-01-01 | |
| previousow | OFTInteger | — | ||
| previous_1 | OFTString | — | ||
| mapbook | OFTString | — | ||
| block | OFTString | 88 | 0000, 0015, 0023 | |
| subdivisio | OFTString | 796 | CN610 - North Add, 9V325 - Vinco/Main/Stanton, 9V325 - Vinco/Main/Stanton | |
| lot | OFTString | 344 | 0009, 0010, 0013 | |
| section | OFTString | 45 | 15, 10, 10 | |
| township | OFTString | 5 | 17N, 17N, 17N | |
| floodplain | OFTString | 4 | 0-24 - % Flood, 0-24 - % Flood, 0-24 - % Flood | |
| range | OFTString | 8 | 01E, 01E, 01E | |
| saleprice | OFTReal | 1.5k | 0.0, 0.0, 0.0 | |
| saledate | OFTString | 7.6k | 2013-10-30, 2013-03-08, 2002-01-16 | |
| salelandus | OFTString | 29 | RA - Rural Agricultural, RA - Rural Agricultural, RA - Rural Agricultural | |
| grantor | OFTString | 22.1k | CUNDIFF, ALAN D, WHITMORE, LEO L & ARLETA M, CUNDIFF, LEROY C & PAULETTE | |
| grantee | OFTString | 22.9k | CUNDIFF, ALAN D TTEE, WHITMORE, LEO, WHITMORE, WAYNE & CONNIE | |
| baths | OFTReal | 60 | 2.0, 1.0, 2.0 | |
| beds | OFTString | 33 | 3, 2, 3 | |
| yearbuilt | OFTInteger | 132 | 1995, 1971, 1995 | |
| buildingty | OFTString | 167 | Manufactured Housing, Manufactured Housing, Manufactured Housing | |
| ownernamef | OFTString | 24.4k | Hatter, Sam &/or Debra A, Downey, Richard Jr, Whitmore, Leo | |
| streetname | OFTString | 1.3k | 140th St, 140th St, 140th St | |
| streetnumb | OFTString | 4.3k | 9017, 9020, 9624 | |
| alternates | OFTString | 2 | 1/2, 1/2, 1/2 | |
| locationci | OFTString | 12 | Coyle, Coyle, Coyle | |
| condocompl | OFTString | 38 | Hefner, Arcadia, Hefner | |
| owner1 | OFTString | 24.4k | Hatter, Sam &/or Debra A, Downey, Richard Jr, Whitmore, Leo | |
| owner2 | OFTString | 659 | C/O Kim Smalley, C/O Charles Wall, C/O Herndon F Donnelley III | |
| owner3 | OFTString | 10 | C/O Stephanie Domingez, C/O Ryan, LLC, C/O Janey Danforth | |
| zone1 | OFTString | 1 | RTM | |
| totallandv | OFTReal | 7.4k | 0.0, 0.0, 0.0 | |
| totalyardi | OFTReal | 5.6k | 0.0, 0.0, 0.0 | |
| totallanda | OFTReal | 4.6k | 0.0, 0.0, 0.0 | |
| totalfinis | OFTReal | 6.0k | 1216.0, 672.0, 1280.0 | |
| totalvalue | OFTReal | 22.5k | 12250.0, 500.0, 9900.0 | |
| totalbuild | OFTReal | 19.1k | 12250.0, 500.0, 9900.0 | |
| legalrefer | OFTString | 27.7k | 2140-0773, 2081-0264, 1342-0138 | |
| formattedl | OFTString | 31.4k | 9017 W 140th St, 9020 W 140th St, 9624 W 140th St | |
| business | OFTString | — | ||
| businessna | OFTString | — | ||
| propertyst | OFTString | 7 | A - Active, A - Active, A - Active | |
| locationzi | OFTString | 13 | 73027, 73027, 73027 | |
| totalasses | OFTReal | 22.3k | 1397.0, 57.0, 1129.0 | |
| nalcode | OFTString | 2 | No, No, No | |
| soldasvaca | OFTString | 2 | 0, 0, 0 | |
| parcelid1 | OFTString | 24 | 17N01E, 17N01E, 17N01E | |
| parcelid2 | OFTString | 145 | 15-1, 10-2, 10-3 | |
| parcelid3 | OFTString | 799 | 00000, 00000, 00000 | |
| parcelid4 | OFTString | 119 | 000, 000, 000 | |
| parcelid5 | OFTString | 578 | 0001, 0251, 0501 | |
| parcelid6 | OFTString | 29 | 002, 001, 001 | |
| parcelid7 | OFTString | 1 | 000001, 000001 | |
| mailingadd | OFTString | 2 | Dept 124, 1213 S Mehan Rd | |
| mailingapa | OFTString | 304 | Ste 1000W, # 196, Ste 1000W | |
| mailingcit | OFTString | 1.0k | Coyle, Coyle, Stillwater | |
| mailingsta | OFTString | 49 | OK, OK, OK | |
| mailingzip | OFTString | 12.9k | 73027-3304, 73027-3304, 74074-2039 | |
| mailingcou | OFTString | 6 | UNITED STATES, UNITED STATES, UNITED STATES | |
| mastergisp | OFTInteger | 34.7k | 600010112, 600010178, 600010171 | |
| buildingid | OFTInteger | 31.8k | 38015, 38007, 32018 | |
| sectionid | OFTInteger | 1 | 0, 0, 0 | |
| userbuildi | OFTString | 80 | 1, 1, 1 | |
| usersectio | OFTString | 12 | 0, 0, 0 | |
| buildingse | OFTInteger | 1 | 1, 1, 1 | |
| valuationo | OFTString | 4 | 6 - Override, 6 - Override, 6 - Override | |
| building_1 | OFTString | 167 | 6 - Manufactured Housing, 6 - Manufactured Housing, 6 - Manufactured Housing | |
| averagehei | OFTInteger | 18 | 8, 8, 8 | |
| exteriorwa | OFTString | 86 | 190 - Vinyl Lap, 185 - Hardboard Sheet, 181 - Aluminum Sheet | |
| exterior_1 | OFTString | 70 | 108 - Frame, Siding, Wood, 107 - Frame, Siding, Vinyl, 134 - Veneer, Stone | |
| secondarye | OFTInteger | 63 | 0, 0, 0 | |
| partition | OFTString | — | ||
| floorcover | OFTString | — | ||
| floorcov_1 | OFTString | — | ||
| secondaryf | OFTInteger | 1 | 0, 0, 0 | |
| basementfl | OFTString | — | ||
| basementga | OFTInteger | 1 | 0, 0, 0 | |
| parking | OFTString | — | ||
| electric | OFTString | 1 | RMA - Complete Rem | |
| insulation | OFTString | — | ||
| plumbing | OFTString | — | ||
| heatfuel | OFTString | — | ||
| heat | OFTString | 29 | 351 - Warmed & Cooled Air, 309 - Forced Air Furnace, 351 - Warmed & Cooled Air | |
| heat2 | OFTString | 17 | 383 - Window-type Refrig. Cooler (#), 382 - Wall Air Conditioners, 383 - Window-type Refrig. Cooler (#) | |
| numberofhe | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| percenthea | OFTString | 3 | 100.0, 100.0, 100.0 | |
| secondaryp | OFTString | 33 | 0.0, 0.0, 0.0 | |
| percentair | OFTString | 2 | 0.0, 0.0, 0.0 | |
| intvsext | OFTString | — | ||
| storyheigh | OFTString | 18 | 8 - 8 Feet, 8 - 8 Feet, 8 - 8 Feet | |
| foundation | OFTString | 9 | 622 - Raised Subfloor - Crawl, 622 - Raised Subfloor - Crawl, 622 - Raised Subfloor - Crawl | |
| subfloor | OFTString | — | ||
| commercial | OFTInteger | 40 | 1, 1, 1 | |
| commerci_1 | OFTString | 4 | APT - Apartment Unit, APT - Apartment Unit, APT - Apartment Unit | |
| residentia | OFTInteger | 7 | 1, 1, 1 | |
| frame | OFTString | 6 | D - Wood or steel framed exterior walls, D - Wood or steel framed exterior walls, D - Wood or steel framed exterior walls | |
| interiorwa | OFTString | — | ||
| interior_1 | OFTString | — | ||
| secondaryi | OFTInteger | 1 | 0, 0, 0 | |
| roofstruct | OFTString | 11 | Gable - Gable, Gable - Gable, Gable - Gable | |
| roofcover | OFTString | 30 | 208 - Composition Shingle, 208 - Composition Shingle, 223 - Metal, Corrugated or Ribbed | |
| color | OFTString | — | ||
| viewcode | OFTString | — | ||
| quality | OFTString | 21 | MH_2, MH_2, MH_2 | |
| qualitydes | OFTString | 21 | MH_2 - MH Fair, MH_2 - MH Fair, MH_2 - MH Fair | |
| effectivey | OFTInteger | 157 | 1997, 1957, 1995 | |
| condolocat | OFTString | 1 | Oakcreek - Oakcreek Community | |
| condofloor | OFTString | 1 | 1 -, 1 - | |
| condoflo_1 | OFTInteger | 2 | 0, 0, 0 | |
| condoperce | OFTString | 3 | 0.0, 0.0, 0.0 | |
| complex | OFTString | 14 | HullReese - Hull-Reese, Berry - Berry Creek Office Compex, Miller - Miller Phillips Condo | |
| altlanduse | OFTString | 2 | UC - Urban Commercial, CO - Charitable | |
| jurisdicti | OFTString | 1 | Yale - Yale | |
| fullbath | OFTInteger | 48 | 2, 1, 2 | |
| fullbathra | OFTString | 1 | Avg - | |
| additional | OFTInteger | 1 | 0, 0, 0 | |
| addtlfullb | OFTString | — | ||
| threequart | OFTInteger | 2 | 0, 0, 0 | |
| threequa_1 | OFTString | — | ||
| addition_1 | OFTInteger | 3 | 0, 0, 0 | |
| addtlthree | OFTString | — | ||
| halfbath | OFTInteger | 8 | 0, 0, 0 | |
| halfbathra | OFTString | 1 | Good - | |
| addition_2 | OFTInteger | 3 | 0, 0, 0 | |
| addtlhalfb | OFTString | — | ||
| otherfixtu | OFTInteger | 23 | 2, 2, 2 | |
| otherfix_1 | OFTString | 2 | A -, G - | |
| kitchen | OFTInteger | 30 | 1, 1, 1 | |
| kitchenrat | OFTString | 2 | A -, G - | |
| addition_3 | OFTInteger | 11 | 0, 0, 0 | |
| addtlkitch | OFTString | — | ||
| fireplaces | OFTInteger | 6 | 0, 0, 0 | |
| fireplacer | OFTString | — | ||
| wsflues | OFTInteger | 53 | 3, 2, 3 | |
| wsfluesrat | OFTString | — | ||
| solarhotwa | OFTString | 8 | 0.0, 0.0, 0.0 | |
| centralvac | OFTString | 9 | 0.0, 1.0, 0.0 | |
| percentcom | OFTInteger | 5 | 0, 0, 0 | |
| percentspr | OFTInteger | 8 | 0, 0, 0 | |
| buildingsh | OFTString | 19 | 13 - Singlewide, 13 - Singlewide, 13 - Singlewide | |
| mobilehome | OFTReal | 109 | 76.0, 56.0, 80.0 | |
| mobileho_1 | OFTReal | 70 | 16.0, 12.0, 16.0 | |
| perimeter | OFTReal | 17 | 111.0, 166.0, 168.0 | |
| netfactor | OFTReal | — | ||
| developer | OFTString | — | ||
| buildingna | OFTString | 38 | Hefner, Arcadia, Hefner | |
| linerefere | OFTInteger | 1 | 1, 1, 1 | |
| landtype | OFTString | 5 | AC - Acres, AC - Acres, AC - Acres | |
| area | OFTReal | 2.6k | 0.92, 2.32, 3.05 | |
| landunit | OFTString | 297 | 1662 - Coyle & Mulhall, 1721 - Perk-Rural, 1662 - Coyle & Mulhall | |
| areaforsiz | OFTReal | 1 | 1.0 | |
| alternaten | OFTString | — | ||
| altneighbo | OFTInteger | — | ||
| alternat_1 | OFTString | — | ||
| altlandu_1 | OFTInteger | 5 | 0, 0, 0 | |
| alternatel | OFTString | 4 | UC - Urban Commercial, CO - Charitable, FR - Fraternal Property | |
| alternatej | OFTString | — | ||
| alternat_2 | OFTString | — | ||
| altlandu_2 | OFTInteger | — | ||
| influence1 | OFTString | 12 | Access - Access, VIEW - View, 25-49 - % Flood | |
| influence2 | OFTString | 1 | Corner - Corner Location | |
| influence3 | OFTString | — | ||
| influencep | OFTInteger | 29 | 33, -25, -50 | |
| influenc_1 | OFTInteger | 1 | 50 | |
| influenc_2 | OFTInteger | — | ||
| frontage | OFTReal | 4.3k | 100.0, 100.0, 100.0 | |
| depth | OFTReal | 4.7k | 140.0, 140.0, 75.0 | |
| lumpsumrea | OFTString | — | ||
| lumpsumamo | OFTReal | 1 | 37770.0 | |
| overrideun | OFTReal | — | ||
| overrideva | OFTReal | 3 | 1446.0, 6793.0, 6793.0 | |
| speciallan | OFTString | 3 | BV2025 - Builder Value 2025, BV2026 - Builder Value 2026, BV2025 - Builder Value 2025 | |
| speciall_1 | OFTReal | — | ||
| polygonid | OFTInteger | — | ||
| isuseflag | OFTInteger | 2 | 0, 0, 0 | |
| adjustedun | OFTReal | 4.9k | 10000.0, 13418.1, 9911.48 |
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.