OverviewResourcesFirst American › Assessor

Assessor — data dictionary

The property universe — parcels, physical attributes, owner, land use. · Classic Layout 227 · Lite Layout 160 · source FA Assessor Data Dictionary Layout v24 20260514 (v24 · 2026-05-14).

Tier A/B features: YearBuilt, building sqft, ROOF_COVER/ROOF_TYPE, OwnerOccupied, land-use, vesting. The snapshot every model scores.

Classic Layout

Classic Package · 227 fields

FieldTypeDisplayCode tableDescription
PROPERTY IDENTIFICATION INFORMATION
FIPSvarchar(5)Public DisplayFIPSFIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents.
PropertyIDBig Int(11)No DisplayThe First American Derived ID that uniquely identifies a property in the First American Database.
APNvarchar(45)No DisplayAssessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels.
APNSeqNbrvarchar(3)No DisplayInternal sequence number assigned to Assessor Parcel Number.
OldAPNvarchar(45)No DisplayOTHER APN (type is based on OldApnIndicator).
OldApnIndicatorvarchar(1)No DisplayType of APN in the OldAPN field (O = OldAPN, A = AlternateAPN,P = Parent, S = SubDiv/Split).
TaxAccountNumbervarchar(45)Restricted DisplayWhen provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes.
PROPERTY ADDRESS INFORMATION
SitusFullStreetAddressvarchar(116)Public DisplayStreet Address: 123 S MAIN ST # 4
SitusHouseNbrvarchar(30)Public DisplayHouse Number: 123 S MAIN ST # 4
SitusHouseNbrSuffixvarchar(10)Public DisplayAlpha characters found to the right of the house number: 123 W S MAIN ST # 4
SitusDirectionLeftvarchar(2)Public DisplayAlpha characters found to the left of the street name: 123 S MAIN ST # 4
SitusStreetvarchar(60)Public DisplayName or number of the street. 123 S MAIN ST # 4
SitusModevarchar(10)Public DisplaySuffix of the Street: 123 S MAIN ST # 4
SitusDirectionRightvarchar(2)Public DisplayRepresents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
SitusUnitTypevarchar(20)Public DisplayThe type used in the property address for the unit: 123 S Main St # 4
SitusUnitNbrvarchar(15)Public DisplayThe unit or suite number of the property address: 123 S Main St # 4
SitusCityvarchar(55)Public DisplayThe city for the property address.
SitusStatevarchar(2)Public DisplayTwo letter state abbreviation for the property.
SitusZIP5varchar(5)Public DisplayFive digit code assigned by the USPS: 90001-1000
SitusZIP4varchar(4)Public DisplayFour digit code assigned by the USPS: 90001-1000
SitusCarrierCodevarchar(4)Restricted DisplayFour digit code used by the local mail carrier to identify delivery path.
SitusLatitudefloat(12)Restricted DisplayFA standard latitude of the property.
SitusLongitudefloat(12)Restricted DisplayFA standard longitude of the property.
SitusGeoStatusCodevarchar(1)Restricted DisplayGEO_STATUSCode describing the accuracy of the lat/long.
PROPERTY INFORMATION
PropertyClassIDvarchar(3)Restricted DisplayPROP_CL_INDA First American general code used to easily recognize specific property types (e.g., Residential, Commercial, Office).
LandUseCodevarchar(10)Restricted DisplayLU_CODEA First American established Land Use code converted from various county Land Use codes. Land Use code standardized for all counties.
StateLandUseCodevarchar(10)Restricted DisplayLand Use as established by the State.
CountyLandUseCodevarchar(10)Restricted DisplayLand Use as established by the County.
Zoningvarchar(10)Restricted DisplayZoning as assigned by the assessor or local zoning/building department.
SitusCensusTractvarchar(10)Restricted DisplayCensus Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce Bureau Of The Census.
SitusCensusBlockvarchar(4)Restricted DisplayCensus Block. These numbers are established by the US Department of Commerce Bureau Of The Census.
MobileHomeIndvarchar(1)Restricted DisplayIndicates if a Mobile Home is present when populated with a "Y" or "T".
TimeshareCodevarchar(1)Restricted DisplayIndicates if property is a timeshare when populated with a "Y" or "T".
SchoolDistrictNamevarchar(80)Restricted DisplayA First American standardized school district name.
LOT / LAND INFORMATION
LotSizeFrontageFeetvarchar(12)Restricted DisplayLinear footage across the front of the lot.
LotSizeDepthFeetvarchar(12)Restricted DisplayLinear footage from the front to the back of the lot.
LotSizeAcresvarchar(10)Restricted DisplayArea of the parcel, measured in acres.
LotSizeSqFtint(11)Restricted DisplayArea of the parcel, measured in square feet.
OWNER INFORMATION
Owner1CorpIndvarchar(1)Restricted DisplayFirst Owner identified as a corporation.
Owner1LastNamevarchar(60)Restricted DisplayFirst Owner Last name.
Owner1FirstNamevarchar(30)Restricted DisplayFirst Owner First name.
Owner1MiddleNamevarchar(10)Restricted DisplayFirst Owner Middle name.
Owner1Suffixvarchar(5)Restricted DisplayFirst Owner Generation identifier.
Owner2CorpIndvarchar(1)Restricted DisplaySecond Owner identified as a corporation.
Owner2LastNamevarchar(60)Restricted DisplaySecond Owner Last name.
Owner2FirstNamevarchar(30)Restricted DisplaySecond Owner First name.
Owner2MiddleNamevarchar(10)Restricted DisplaySecond Owner Middle name.
Owner2Suffixvarchar(5)Restricted DisplaySecond Owner Generation identifier.
OwnerNAME1FULLvarchar(80)Restricted DisplayFirst Full Owner Name.
OwnerNAME2FULLvarchar(80)Restricted DisplaySecond Full Owner Name.
OwnerOccupiedvarchar(1)Restricted DisplayOWNER_OCCFlag if property is owner occupied.
Owner1OwnershipRightsvarchar(3)Restricted DisplayOWNER_VESTCode indicating the rights an owner has to the property.
MAIL ADDRESS INFORMATION
MailingFullStreetAddressvarchar(116)No DisplayStreet Address: 123 S MAIN ST # 4
MailingHouseNbrvarchar(30)No DisplayHouse Number: 123 S MAIN ST # 4
MailingHouseNbrSuffixvarchar(10)No DisplayAlpha characters found to the right of the house number: 123 W S MAIN ST # 4
MailingDirectionLeftvarchar(2)No DisplayAlpha characters found to the left of the street name: 123 S MAIN ST # 4
MailingStreetvarchar(60)No DisplayName or number of the street. 123 S MAIN ST # 4
MailingModevarchar(10)No DisplaySuffix of the Street: 123 S MAIN ST # 4
MailingDirectionRightvarchar(2)No DisplayRepresents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
MailingUnitTypevarchar(20)No DisplayThe type used in the mailing address for the unit: 123 S Main St # 4
MailingUnitNbrvarchar(15)No DisplayThe unit or suite number of the mailing address: 123 S Main St # 4
MailingCityvarchar(55)No DisplayThe city for the mailing address.
MailingStatevarchar(2)No DisplayTwo letter state abbreviation for the mailing address.
MailingZIP5varchar(9)No DisplayFive digit code assigned by the USPS: 90001-1000
MailingZIP4varchar(4)No DisplayFour digit code assigned by the USPS: 90001-1000
MailingCarrierCodevarchar(4)No DisplayFour digit code used by the local mail carrier to identify delivery path.
MailingOptOutvarchar(1)Restricted DisplayThe property owner has registered to be excluded from direct marketing solicitations.
MailingCONamevarchar(80)No DisplayMailing Care Of Name.
MailingForeignAddressIndvarchar(1)No DisplayIndicates the mailing address is a foreign address. C = Canadian, everything else = 'Y'
VALUES INFORMATION
AssdTotalValueint(11)Restricted DisplayTotal Assessed Value of the Parcel's Land & Improvement values.
AssdLandValueint(11)Restricted DisplayCurrent Assessed Value of the land only (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only.
AssdImprovementValueint(11)Restricted DisplayThe current assessed value of the improvements only (before exemptions, if any) as reported on the current county tax/assessment roll. Whenever separate fields are provided for additional improved values, this will be the total of all improvement values. Whole dollars only.
MarketTotalValueint(11)Restricted DisplayThe Total Market Value of the Parcel's Land & Improvement value
MarketValueLandint(11)Restricted DisplayWhen available from the county, the Market Land Value as determined by the Assessor.
MarketValueImprovementint(11)Restricted DisplayWhen available from the county, the Market Improvement Value as determined by the Assessor.
TaxAmtbigint(11)Restricted DisplayAmount of property taxes due for the property.
TaxYearvarchar(4)Restricted DisplayYear taxes are billed.
TaxDeliquentYearvarchar(4)Restricted DisplayThe initial tax year of delinquency..
MarketYearvarchar(4)Restricted DisplayYear of the Market values for the property.
AssdYearvarchar(4)Restricted DisplayYear of the Assessed values for the property.
TaxRateCodeAreavarchar(20)Restricted DisplayRepresents separate tax jurisdictions within the county as provided on the county tax/assessment roll.
SchoolTaxDistrict1Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
SchoolTaxDistrict2Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
SchoolTaxDistrict3Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
TAX EXEMPTION INFORMATION
HomesteadIndvarchar(1)No DisplayHomeowner Exemption Flag.
VeteranIndvarchar(1)No DisplayVeteran Exemption Flag.
DisabledIndvarchar(1)No DisplayDisabled Exemption Flag.
WidowIndvarchar(1)No DisplayWidow Exemption Flag.
SeniorIndvarchar(1)No DisplaySenior Citizen Exemption Flag.
SchoolCollegeIndvarchar(1)No DisplaySchool/College Exemption Flag.
ReligiousIndvarchar(1)No DisplayReligious Exemption Flag.
WelfareIndvarchar(1)No DisplayWelfare Exemption Flag.
PublicUtilityIndvarchar(1)No DisplayUtilities Exemption Flag.
CemeteryIndvarchar(1)No DisplayCemetery Exemption Flag.
HospitalIndvarchar(1)No DisplayHospital Exemption Flag.
LibraryIndvarchar(1)No DisplayLibrary Exemption Flag.
BUILDING SQUARE FOOTAGE INFORMATION
BuildingAreanumeric(9)Restricted DisplaySquare footage best to be used for assessments or comparable (e.g., Living, Adjusted, Gross).
BuildingAreaIndvarchar(1)Restricted DisplayBLDG_SQFT_INDCode indicating the source used to populate the BuildingArea field (e.g., Living, Adjusted, Gross).
SumBuildingSqFtnumeric(9)Restricted DisplaySquare footage most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.
SumLivingAreaSqFtint(7)Restricted DisplayBuilding are used for general living. The heated or air conditioned area, not including Garage, Porch or Basement areas.
SumGroundFloorSqFtint(7)Restricted DisplaySquare footage of the ground Floor.
SumGrossAreaSqFtint(7)Restricted DisplaySquare footage for the entire building. Typically this represents all square feet under the roof.
SumAdjAreaSqFtint(7)Restricted DisplaySquare footage used by the taxing / assessing authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.
AtticSqFtint(7)Restricted DisplaySquare footage of the attic - regardless if finished, unfinished or both.
AtticUnfinishedSqFtint(7)Restricted DisplaySquare footage of the attic - unfinished area.
AtticFinishedSqFtint(7)Restricted DisplaySquare footage of the attic - finished area.
SumBasementSqFtint(7)Restricted DisplayTotal square footage of all Basement portions - regardless if finished, unfinished or both.
BasementUnfinishedSqFtint(7)Restricted DisplaySquare footage of the basement - unfinished area.
BasementFinishedSqFtint(7)Restricted DisplaySquare footage of the basement - finished area.
SumGarageSqFtint(7)Restricted DisplayTotal square footage of the primary garage or parking areas (i.e. commercial) - regardless if finished, unfinished or both.
GarageUnFinishedSqFtint(7)Restricted DisplaySquare footage of the garage - unfinished area.
GarageFinishedSqFtint(7)Restricted DisplaySquare footage of the garage - finished area.
BUILDING INFORMATION
YearBuiltvarchar(4)Restricted DisplayConstruction year of the building.
EffectiveYearBuiltvarchar(4)Restricted DisplayThe year the latest significant construction occurred on the building.
Bedroomsnumeric(5)Restricted DisplayTotal number of bedroom contained in the primary building.
TotalRoomsnumeric(5)Restricted DisplayTotal number of rooms.
BathTotalCalcnumeric (5,2)(5)Restricted DisplayFirst American calculated number of bath rooms.
BathFullnumeric(5)Restricted DisplayNumber of full bathrooms.
BathsPartialNbrnumeric(5)Restricted DisplayNumber of partial baths.
BathFixturesNbrnumeric(5)Restricted DisplayNumber of bathroom plumbing fixtures.
Amenitiesvarchar(10)Restricted DisplayAMENITIESAmenities associated with the property (alarm system, fire sprinklers, club house, etc.). Field may contain up to five codes.
AirConditioningCodeint(3)Restricted DisplayACType of air conditioning.
BasementCodeint(3)Restricted DisplayBASEMNTType of basement.
BuildingClassCodeint(3)Restricted DisplayBLDG_CODEPrimary building type.
BuildingConditionCodeint(3)Restricted DisplayCONDITIONCondition of the building.
ConstructionTypeCodeint(3)Restricted DisplayCONST_TYPEConstruction type of the building.
DeckIndint(1)Restricted DisplayIndicates there is a deck.
ExteriorWallsCodeint(3)Restricted DisplayEXT_WALLType of exterior wall.
InteriorWallsCodeint(3)Restricted DisplayINT_WALLType of interior wall.
FireplaceCodeint(3)Restricted DisplayNumber of fireplaces.
FloorCoverCodeint(3)Restricted DisplayFLOOR_COVERType of floor cover.
Garageint(3)Restricted DisplayGARAGEType of garage or carport.
HeatCodeint(3)Restricted DisplayHEATType or method of heating.
HeatingFuelTypeCodeint(3)Restricted DisplayHEAT_FUELType of heating fuel.
SiteInfluenceCodevarchar(3)Restricted DisplayLOC_INFLNCEType of Location Influence.
GarageParkingNbrint(3)Restricted DisplayNumber of parking spaces.
DrivewayCodevarchar(3)Restricted DisplayDRIVEWAYType of driveway.
OtherRoomsvarchar(5)Restricted DisplayOTHER ROOMSOther rooms available (mud room, game room, sun room, home office, etc.).
PatioCodeint(3)Restricted DisplayPATIOType of patio.
PoolCodeint(3)Restricted DisplayPOOLType of pool.
PorchCodeint(3)Restricted DisplayPORCHType of porch.
BuildingQualityCodeint(3)Restricted DisplayQUALITYQuality of building / construction.
RoofCoverCodeint(3)Restricted DisplayROOF_COVERType of roof cover.
RoofTypeCodeint(3)Restricted DisplayROOF_TYPEShape of roof.
SewerCodeint(3)Restricted DisplaySEWERType of sewer system.
StoriesNbrCodeint(5)Restricted DisplaySTORIESCode indication the number or type of stories.
StyleCodeint(3)Restricted DisplaySTYLEBuilding style.
SumResidentialUnitsnumeric(5)Restricted DisplayNumber of residential, apartment units.
SumBuildingsNbrnumeric(5)Restricted DisplayNumber of buildings.
SumCommercialUnitsnumeric(5)Restricted DisplayNumber of business/commercial units.
TopographyCodevarchar(10)Restricted DisplayTOPOGRAPHYCode referring to forms and features of the land.
WaterCodeint(3)Restricted DisplayWATERType of water service.
LEGAL DESCRIPTION
LotCodevarchar(2)Restricted DisplayLOT_CODEIdentifies properties which include more than one lot or partial lots.
LotNbrvarchar(7)Restricted DisplayThe lot number or numbers if the lot is comprised of multiple lots. Population as allowed by the field length, separated with a comma (,) or ampersand (&). A hyphen (-) is used to indicate a range. Refer to Lot Code.
LandLotvarchar(10)Restricted DisplayA large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located.
Blockvarchar(7)Restricted DisplayThe block of the subdivision or city in which the property is located.
Sectionvarchar(7)Restricted DisplaySection of the city in which the property is located. Not related to Section / Township / Range.
Districtvarchar(12)Restricted DisplayThe district in which the property is located. Usually a numeric or text code corresponding to the City, Municipality, Township.
LegalUnitvarchar(6)Restricted DisplayThe subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the Property Unit Number.
Municipalityvarchar(30)Restricted DisplayThe jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the value provided in District. Not necessarily the same as the Property City.
SubdivisionNamevarchar(40)Restricted DisplayThe name of the subdivision, plat, or tract.
SubdivisionPhaseNbrvarchar(7)Restricted DisplayGenerally, the phase of a subdivision or tract development.
SubdivisionTractNbrvarchar(10)Restricted DisplayThe number of the tract in which the property is located. "POR" = portion when provided.
Meridianvarchar(30)Restricted DisplayContains the Section/Township/Range. Format: ZZ QTR SEC 99 TWN 99A RNG 99A QTR where provided. A = Directional (N/S for TWN and E/W for RNG).
AssessorsMapRefvarchar(15)Restricted DisplayStandardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Depending on the length of the Map Reference, spaces may be omitted.
LegalDescriptionvarchar(250)No DisplayLegal Description captured from Assessor / local authority.
LAST SALE INFORMATION
CurrentSaleTransactionIdbigint(11)No DisplayFirst American unique number assigned to each transaction.
CurrentSaleDocNbrvarchar(20)Restricted DisplayRecorder's Document Number.
CurrentSaleBookvarchar(10)Restricted DisplayRecorder's Book Number.
CurrentSalePagevarchar(10)Restricted DisplayRecorder's Page Number.
CurrentSaleRecordingDatevarchar(8)Restricted DisplayDate on which Deed / Instrument was publicly recorded with the county / local jurisdiction.
CurrentSaleContractDatevarchar(8)Restricted DisplayDate of execution of the document (typically, the signature date on the instrument).
CurrentSaleDocumentTypevarchar(2)Restricted DisplayDOC_TYPEInstrument type. i.e. Grant Deed / Warranty Deed / etc…
CurrentSalesPriceint(15)Restricted DisplaySale price as available from public records or calculated from same.
CurrentSalesPriceCodevarchar(5)Restricted DisplaySALE_PRICEType of Sales Price.
CurrentSaleBuyer1FullNamevarchar(60)Restricted DisplayBuyer 1 Full Name.
CurrentSaleBuyer2FullNamevarchar(60)Restricted DisplayBuyer 2 Full Name.
CurrentSaleSeller1FullNamevarchar(60)Restricted DisplaySeller 1 Full Name.
CurrentSaleSeller2FullNamevarchar(60)Restricted DisplaySeller 2 Full Name.
LAST SALE MORTGAGE 1
ConcurrentMtg1DocNbrvarchar(20)Restricted DisplayRecorder's Document Number.
ConcurrentMtg1Bookvarchar(10)Restricted DisplayRecorder's Book Number.
ConcurrentMtg1Pagevarchar(10)Restricted DisplayRecorder's Page Number.
ConcurrentMtg1RecordingDatevarchar(8)Restricted DisplayDate on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
ConcurrentMtg1LoanAmtint(15)Restricted DisplayThe amount of the mortgage on the recorded document.
ConcurrentMtg1Lendervarchar(30)Restricted DisplayThe name of the lender issuing the mortgage.
ConcurrentMtg1Termvarchar(3)Restricted DisplayMortgage term in months.
ConcurrentMtg1InterestRatevarchar(10)Restricted DisplayMortgage interest rate.
ConcurrentMtg1LoanDueDatevarchar(8)Restricted DisplayMaturity date or the final due date of the loan.
ConcurrentMtg1LoanTypevarchar(2)Restricted DisplayLOAN_TYPEDocument type used to issue the mortgage.
ConcurrentMtg1TypeFinancingvarchar(3)Restricted DisplayFIN_TYPEMortgage financing type.
LAST SALE MORTGAGE 2
ConcurrentMtg2DocNbrvarchar(20)Restricted DisplayRecorder's Document Number.
ConcurrentMtg2Bookvarchar(10)Restricted DisplayRecorder's Book Number.
ConcurrentMtg2Pagevarchar(10)Restricted DisplayRecorder's Page Number.
ConcurrentMtg2RecordingDatevarchar(8)Restricted DisplayDate on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
ConcurrentMtg2LoanAmtint(15)Restricted DisplayThe amount of the mortgage on the recorded document.
ConcurrentMtg2Lendervarchar(30)Restricted DisplayThe name of the lender issuing the mortgage.
ConcurrentMtg2Termvarchar(3)Restricted DisplayMortgage term in months.
ConcurrentMtg2InterestRatevarchar(10)Restricted DisplayMortgage interest rate.
ConcurrentMtg2LoanDueDatevarchar(8)Restricted DisplayMaturity date or the final due date of the loan.
ConcurrentMtg2LoanTypevarchar(2)Restricted DisplayLOAN_TYPEDocument type used to issue the mortgage.
ConcurrentMtg2Typefinancingvarchar(3)Restricted DisplayFIN_TYPEMortgage financing type.
PRIOR SALE INFORMATION
PrevSaleTransactionIdbigint(11)No DisplayFirst American unique number assigned to each transaction.
PrevSaleDocNbrvarchar(20)Restricted DisplayRecorder's Document Number.
PrevSaleBookvarchar(10)Restricted DisplayRecorder's Book Number.
PrevSalePagevarchar(10)Restricted DisplayRecorder's Page Number.
PrevSaleRecordingDatevarchar(8)Restricted DisplayDate on which Deed / Instrument was publicly recorded with the county / local jurisdiction.
PrevSaleContractDatevarchar(8)Restricted DisplayDate of execution of the document (typically, the signature date on the instrument.
PrevSaleDocumentTypevarchar(2)Restricted DisplayInstrument type. i.e. Grant Deed / Warranty Deed / etc…
PrevSalesPriceint(15)Restricted DisplaySale price as available from public records or calculated from same.
PrevSalesPriceCodevarchar(5)Restricted DisplaySALE_PRICEType of Sales Price.
PrevSaleBuyer1FullNamevarchar(60)Restricted DisplayBuyer 1 Full Name.
PrevSaleBuyer2FullNamevarchar(60)Restricted DisplayBuyer 2 Full Name.
PrevSaleSeller1FullNamevarchar(60)Restricted DisplaySeller 1 Full Name.
PrevSaleSeller2FullNamevarchar(60)Restricted DisplaySeller 2 Full Name.
PRIOR SALE MORTGAGE
PrevMtg1DocNbrvarchar(20)Restricted DisplayRecorder's Document Number.
PrevMtg1Bookvarchar(10)Restricted DisplayRecorder's Book Number.
PrevMtg1Pagevarchar(10)Restricted DisplayRecorder's Page Number.
PrevMtg1RecordingDatevarchar(8)Restricted DisplayDate on which Mortgage / Deed of Trust was publicly recorded with the county / local jurisdiction.
PrevMtg1LoanAmtint(15)Restricted DisplayThe amount of the mortgage on the recorded document.
PrevMtg1Lendervarchar(30)Restricted DisplayThe name of the lender issuing the mortgage.
PrevMtg1Termnumeric(3)Restricted DisplayMortgage term in months.
PrevMtg1InterestRatevarchar(10)Restricted DisplayMortgage interest rate.
PrevMtg1LoanDueDatevarchar(8)Restricted DisplayMaturity date or the final due date of the loan.
PrevMtg1LoanTypevarchar(2)Restricted DisplayLOAN_TYPEDocument type used to issue the mortgage.
PrevMtg1TypeFinancingvarchar(3)Restricted DisplayFIN_TYPEMortgage financing type.
ADDITIONAL FA PROCESSING INFORMATION
FATimeStampdatetime2(15)No DisplayTimestamp applied to transaction records when created, edited, or deleted. Format: 20150925.
FARecordTypevarchar(1)No DisplayI - Insert (new record). C & U - Change or Update to the record (treat the same). D = Record deleted.

Lite Layout

Lite Package · 160 fields

FieldTypeDisplayCode tableDescription
PROPERTY IDENTIFICATION INFORMATION
FIPSvarchar(5)Public DisplayFIPSFIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents.
PropertyIDBig Int(11)No DisplayThe First American Derived ID that uniquely identifies a property in the First American Database.
APNvarchar(45)No DisplayAssessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels.
APNSeqNbrvarchar(3)No DisplayInternal sequence number assigned to Assessor Parcel Number.
OldAPNvarchar(45)No DisplayOTHER APN (type is based on OldApnIndicator).
OldApnIndicatorvarchar(1)No DisplayType of APN in the OldAPN field (O = OldAPN, A = AlternateAPN,P = Parent, S = SubDiv/Split).
TaxAccountNumbervarchar(45)Restricted DisplayWhen provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes.
PROPERTY ADDRESS INFORMATION
SitusFullStreetAddressvarchar(116)Public DisplayStreet Address: 123 S MAIN ST # 4
SitusHouseNbrvarchar(30)Public DisplayHouse Number: 123 S MAIN ST # 4
SitusHouseNbrSuffixvarchar(10)Public DisplayAlpha characters found to the right of the house number: 123 W S MAIN ST # 4
SitusDirectionLeftvarchar(2)Public DisplayAlpha characters found to the left of the street name: 123 S MAIN ST # 4
SitusStreetvarchar(60)Public DisplayName or number of the street. 123 S MAIN ST # 4
SitusModevarchar(10)Public DisplaySuffix of the Street: 123 S MAIN ST # 4
SitusDirectionRightvarchar(2)Public DisplayRepresents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
SitusUnitTypevarchar(20)Public DisplayThe type used in the property address for the unit: 123 S Main St # 4
SitusUnitNbrvarchar(15)Public DisplayThe unit or suite number of the property address: 123 S Main St # 4
SitusCityvarchar(55)Public DisplayThe city for the property address.
SitusStatevarchar(2)Public DisplayTwo letter state abbreviation for the property.
SitusZIP5varchar(5)Public DisplayFive digit code assigned by the USPS: 90001-1000
SitusZIP4varchar(4)Public DisplayFour digit code assigned by the USPS: 90001-1000
SitusCarrierCodevarchar(4)Restricted DisplayFour digit code used by the local mail carrier to identify delivery path.
SitusLatitudefloat(12)Restricted DisplayFA standard latitude of the property.
SitusLongitudefloat(12)Restricted DisplayFA standard longitude of the property.
SitusGeoStatusCodevarchar(1)Restricted DisplayGEO_STATUSCode describing the accuracy of the lat/long.
PROPERTY INFORMATION
PropertyClassIDvarchar(3)Restricted DisplayPROP_CL_INDA First American general code used to easily recognize specific property types (e.g., Residential, Commercial, Office).
LandUseCodevarchar(10)Restricted DisplayLU_CODEA First American established Land Use code converted from various county Land Use codes. Land Use code standardized for all counties.
StateLandUseCodevarchar(10)Restricted DisplayLand Use as established by the State.
CountyLandUseCodevarchar(10)Restricted DisplayLand Use as established by the County.
Zoningvarchar(10)Restricted DisplayZoning as assigned by the assessor or local zoning/building department.
SitusCensusTractvarchar(10)Restricted DisplayCensus Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce Bureau Of The Census.
SitusCensusBlockvarchar(4)Restricted DisplayCensus Block. These numbers are established by the US Department of Commerce Bureau Of The Census.
MobileHomeIndvarchar(1)Restricted DisplayIndicates if a Mobile Home is present when populated with a "Y" or "T".
TimeshareCodevarchar(1)Restricted DisplayIndicates if property is a timeshare when populated with a "Y" or "T".
SchoolDistrictNamevarchar(80)Restricted DisplayA First American standardized school district name.
LOT / LAND INFORMATION
LotSizeFrontageFeetvarchar(12)Restricted DisplayLinear footage across the front of the lot.
LotSizeDepthFeetvarchar(12)Restricted DisplayLinear footage from the front to the back of the lot.
LotSizeAcresvarchar(10)Restricted DisplayArea of the parcel, measured in acres.
LotSizeSqFtint(11)Restricted DisplayArea of the parcel, measured in square feet.
OWNER INFORMATION
Owner1CorpIndvarchar(1)Restricted DisplayFirst Owner identified as a corporation.
Owner1LastNamevarchar(60)Restricted DisplayFirst Owner Last name.
Owner1FirstNamevarchar(30)Restricted DisplayFirst Owner First name.
Owner1MiddleNamevarchar(10)Restricted DisplayFirst Owner Middle name.
Owner1Suffixvarchar(5)Restricted DisplayFirst Owner Generation identifier.
Owner2CorpIndvarchar(1)Restricted DisplaySecond Owner identified as a corporation.
Owner2LastNamevarchar(60)Restricted DisplaySecond Owner Last name.
Owner2FirstNamevarchar(30)Restricted DisplaySecond Owner First name.
Owner2MiddleNamevarchar(10)Restricted DisplaySecond Owner Middle name.
Owner2Suffixvarchar(5)Restricted DisplaySecond Owner Generation identifier.
OwnerNAME1FULLvarchar(80)Restricted DisplayFirst Full Owner Name.
OwnerNAME2FULLvarchar(80)Restricted DisplaySecond Full Owner Name.
OwnerOccupiedvarchar(1)Restricted DisplayOWNER_OCCFlag if property is owner occupied.
Owner1OwnershipRightsvarchar(3)Restricted DisplayOWNER_VESTCode indicating the rights an owner has to the property.
MAIL ADDRESS INFORMATION
MailingFullStreetAddressvarchar(116)No DisplayStreet Address: 123 S MAIN ST # 4
MailingHouseNbrvarchar(30)No DisplayHouse Number: 123 S MAIN ST # 4
MailingHouseNbrSuffixvarchar(10)No DisplayAlpha characters found to the right of the house number: 123 W S MAIN ST # 4
MailingDirectionLeftvarchar(2)No DisplayAlpha characters found to the left of the street name: 123 S MAIN ST # 4
MailingStreetvarchar(60)No DisplayName or number of the street. 123 S MAIN ST # 4
MailingModevarchar(10)No DisplaySuffix of the Street: 123 S MAIN ST # 4
MailingDirectionRightvarchar(2)No DisplayRepresents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4
MailingUnitTypevarchar(20)No DisplayThe type used in the mailing address for the unit: 123 S Main St # 4
MailingUnitNbrvarchar(15)No DisplayThe unit or suite number of the mailing address: 123 S Main St # 4
MailingCityvarchar(55)No DisplayThe city for the mailing address.
MailingStatevarchar(2)No DisplayTwo letter state abbreviation for the mailing address.
MailingZIP5varchar(9)No DisplayFive digit code assigned by the USPS: 90001-1000
MailingZIP4varchar(4)No DisplayFour digit code assigned by the USPS: 90001-1000
MailingCarrierCodevarchar(4)No DisplayFour digit code used by the local mail carrier to identify delivery path.
MailingOptOutvarchar(1)Restricted DisplayThe property owner has registered to be excluded from direct marketing solicitations.
MailingCONamevarchar(80)No DisplayMailing Care Of Name.
MailingForeignAddressIndvarchar(1)No DisplayIndicates the mailing address is a foreign address. C = Canadian, everything else = 'Y'
VALUES INFORMATION
AssdTotalValueint(11)Restricted DisplayTotal Assessed Value of the Parcel's Land & Improvement values.
AssdLandValueint(11)Restricted DisplayCurrent Assessed Value of the land only (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only.
AssdImprovementValueint(11)Restricted DisplayThe current assessed value of the improvements only (before exemptions, if any) as reported on the current county tax/assessment roll. Whenever separate fields are provided for additional improved values, this will be the total of all improvement values. Whole dollars only.
MarketTotalValueint(11)Restricted DisplayThe Total Market Value of the Parcel's Land & Improvement value
MarketValueLandint(11)Restricted DisplayWhen available from the county, the Market Land Value as determined by the Assessor.
MarketValueImprovementint(11)Restricted DisplayWhen available from the county, the Market Improvement Value as determined by the Assessor.
TaxAmtbigint(11)Restricted DisplayAmount of property taxes due for the property
TaxYearvarchar(4)Restricted DisplayYear taxes are billed
TaxDeliquentYearvarchar(4)Restricted DisplayThe initial tax year of delinquency.
MarketYearvarchar(4)Restricted DisplayYear of the Market values for the property
AssdYearvarchar(4)Restricted DisplayYear of the Assessed values for the property
TaxRateCodeAreavarchar(20)Restricted DisplayRepresents separate tax jurisdictions within the county as provided on the county tax/assessment roll.
SchoolTaxDistrict1Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
SchoolTaxDistrict2Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
SchoolTaxDistrict3Codevarchar(15)Restricted DisplayAdditional School or Tax District code specifying for the property.
TAX EXEMPTION INFORMATION
HomesteadIndvarchar(1)No DisplayHomeowner Exemption Flag
VeteranIndvarchar(1)No DisplayVeteran Exemption Flag
DisabledIndvarchar(1)No DisplayDisabled Exemption Flag
WidowIndvarchar(1)No DisplayWidow Exemption Flag
SeniorIndvarchar(1)No DisplaySenior Citizen Exemption Flag
SchoolCollegeIndvarchar(1)No DisplaySchool/College Exemption Flag
ReligiousIndvarchar(1)No DisplayReligious Exemption Flag
WelfareIndvarchar(1)No DisplayWelfare Exemption Flag
PublicUtilityIndvarchar(1)No DisplayUtilities Exemption Flag
CemeteryIndvarchar(1)No DisplayCemetery Exemption Flag
HospitalIndvarchar(1)No DisplayHospital Exemption Flag
LibraryIndvarchar(1)No DisplayLibrary Exemption Flag
BUILDING SQUARE FOOTAGE INFORMATION
BuildingAreanumeric(9)Restricted DisplaySquare footage best to be used for assessments or comparable (e.g., Living, Adjusted, Gross).
BuildingAreaIndvarchar(1)Restricted DisplayBLDG_SQFT_INDCode indicating the source used to populate the BuildingArea field (e.g., Living, Adjusted, Gross).
SumBuildingSqFtnumeric(9)Restricted DisplaySquare footage most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas.
SumLivingAreaSqFtint(7)Restricted DisplayBuilding are used for general living. The heated or air conditioned area, not including Garage, Porch or Basement areas.
SumGrossAreaSqFtint(7)Restricted DisplaySquare footage for the entire building. Typically this represents all square feet under the roof.
SumAdjAreaSqFtint(7)Restricted DisplaySquare footage used by the taxing / assessing authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area.
SumBasementSqFtint(7)Restricted DisplayTotal square footage of all Basement portions - regardless if finished, unfinished or both.
SumGarageSqFtint(7)Restricted DisplayTotal square footage of the primary garage or parking areas (i.e. commercial) - regardless if finished, unfinished or both.
BUILDING INFORMATION
YearBuiltvarchar(4)Restricted DisplayConstruction year of the building.
EffectiveYearBuiltvarchar(4)Restricted DisplayThe year the latest significant construction occurred on the building.
Bedroomsnumeric(5)Restricted DisplayTotal number of bedroom contained in the primary building.
TotalRoomsnumeric(5)Restricted DisplayTotal number of rooms.
BathTotalCalcnumeric (5,2)(5)Restricted DisplayFirst American calculated number of bath rooms.
BathFullnumeric(5)Restricted DisplayNumber of full bathrooms.
BathsPartialNbrnumeric(5)Restricted DisplayNumber of partial baths.
BathFixturesNbrnumeric(5)Restricted DisplayNumber of bathroom plumbing fixtures.
Amenitiesvarchar(10)Restricted DisplayAMENITIESAmenities associated with the property (alarm system, fire sprinklers, club house, etc.). Field may contain up to five codes.
AirConditioningCodeint(3)Restricted DisplayACType of air conditioning.
BasementCodeint(3)Restricted DisplayBASEMNTType of basement.
BuildingClassCodeint(3)Restricted DisplayBLDG_CODEPrimary building type.
BuildingConditionCodeint(3)Restricted DisplayCONDITIONCondition of the building.
ConstructionTypeCodeint(3)Restricted DisplayCONST_TYPEConstruction type of the building.
DeckIndint(1)Restricted DisplayIndicates there is a deck.
ExteriorWallsCodeint(3)Restricted DisplayEXT_WALLType of exterior wall.
InteriorWallsCodeint(3)Restricted DisplayINT_WALLType of interior wall.
FireplaceCodeint(3)Restricted DisplayNumber of fireplaces.
FloorCoverCodeint(3)Restricted DisplayFLOOR_COVERType of floor cover.
Garageint(3)Restricted DisplayGARAGEType of garage or carport.
HeatCodeint(3)Restricted DisplayHEATType or method of heating.
HeatingFuelTypeCodeint(3)Restricted DisplayHEAT_FUELType of heating fuel.
SiteInfluenceCodevarchar(3)Restricted DisplayLOC_INFLNCEType of Location Influence.
GarageParkingNbrint(3)Restricted DisplayNumber of parking spaces.
DrivewayCodevarchar(3)Restricted DisplayDRIVEWAYType of driveway.
OtherRoomsvarchar(5)Restricted DisplayOTHER ROOMSOther rooms available (mud room, game room, sun room, home office, etc.). Field may contain up to five codes.
PatioCodeint(3)Restricted DisplayPATIOType of patio.
PoolCodeint(3)Restricted DisplayPOOLType of pool.
PorchCodeint(3)Restricted DisplayPORCHType of porch.
BuildingQualityCodeint(3)Restricted DisplayQUALITYQuality of building / construction.
RoofCoverCodeint(3)Restricted DisplayROOF_COVERType of roof cover.
RoofTypeCodeint(3)Restricted DisplayROOF_TYPEShape of roof.
SewerCodeint(3)Restricted DisplaySEWERType of sewer system.
StoriesNbrCodeint(5)Restricted DisplaySTORIESCode indication the number or type of stories.
StyleCodeint(3)Restricted DisplaySTYLEBuilding style.
SumResidentialUnitsnumeric(5)Restricted DisplayNumber of residential, apartment units.
SumBuildingsNbrnumeric(5)Restricted DisplayNumber of buildings.
SumCommercialUnitsnumeric(5)Restricted DisplayNumber of business/commercial units.
TopographyCodevarchar(10)Restricted DisplayTOPOGRAPHYCode referring to forms and features of the land.
WaterCodeint(3)Restricted DisplayWATERType of water service on the property
LEGAL DESCRIPTION
LotCodevarchar(2)Restricted DisplayLOT_CODEIdentifies properties which include more than one lot or partial lots.
LotNbrvarchar(7)Restricted DisplayThe lot number or numbers if the lot is comprised of multiple lots. Population as allowed by the field length, separated with a comma (,) or ampersand (&). A hyphen (-) is used to indicate a range. Refer to Lot Code.
LandLotvarchar(10)Restricted DisplayA large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located.
Blockvarchar(7)Restricted DisplayThe block of the subdivision or city in which the property is located.
Sectionvarchar(7)Restricted DisplaySection of the city in which the property is located. Not related to Section / Township / Range.
Districtvarchar(12)Restricted DisplayThe district in which the property is located. Usually a numeric or text code corresponding to the City, Municipality, Township.
LegalUnitvarchar(6)Restricted DisplayThe subdivision unit number. Common for condominiums, townhomes, etc. Not necessarily the same as the Property Unit Number.
Municipalityvarchar(30)Restricted DisplayThe jurisdiction in which the property is located. May be “Unincorporated”, if applicable. Often a description of the value provided in District. Not necessarily the same as the Property City.
SubdivisionNamevarchar(40)Restricted DisplayThe name of the subdivision, plat, or tract.
SubdivisionPhaseNbrvarchar(7)Restricted DisplayGenerally, the phase of a subdivision or tract development.
SubdivisionTractNbrvarchar(10)Restricted DisplayThe number of the tract in which the property is located. "POR" = portion when provided.
Meridianvarchar(30)Restricted DisplayContains the Section/Township/Range. Format: ZZ QTR SEC 99 TWN 99A RNG 99A QTR where provided. A = Directional (N/S for TWN and E/W for RNG).
AssessorsMapRefvarchar(15)Restricted DisplayStandardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Depending on the length of the Map Reference, spaces may be omitted.
LegalDescriptionvarchar(250)No DisplayLegal Description captured from Assessor / local authority.
ADDITIONAL FA PROCESSING INFORMATION
FATimeStampdatetime2(8)No DisplayTimestamp applied to transaction records when created, edited, or deleted. Format: 20150925.
FARecordTypevarchar(1)No DisplayI - Insert (new record. C & U - Change or Update to the record (treat the same). D = Record deleted.

Code tables · 37 tables, 1820 codes

Lookup values referenced by the fields above. Click a field’s code-table link to jump here.

AC14 codes
CODEDESCRIPTION
1Central
2Evaporative Cooler
3Office Only
4Packaged Unit
5Window\Unit
6None
7Other
8Partial
9Chilled Water
10Refrigeration
11Ventilation
12Wall
13Yes
14Geo-Thermal
AMENITIES30 codes
BKFSCodeCodeDesc
1ARBOR/PERGOLA
2MOBILE HOME HOOKUP
3SAUNA/STEAM ROOM
4Carriage House
AAlarm System
BBoat Dock / Ramp
CClub House
DWet Bar
EIntercom System
FSafe Room /Panic Room
GGolf Course/Green
HAudio Sound System
IFire Sprinkler
JBOAT LIFT/DAVITS
KOutdoor Kitchen/Fireplace
LStorm or Tornado Shelter/Cellar
MSmoke/Carbon Monoxide Detector
NWine Cellar
OBasketball/Sport Court
PTreehouse/Playhouse
QHANDICAP RAMP/ACCESSIBLE
RRV parking
SAutomatic Sprinkler System (lawn/irrigation)
TTennis Court
UOVERHEAD DOOR
VCentral Vacuum System
WWater Feature
XSTORM/SECURITY SHUTTERS
YKoi Pond
MultiCodeMultiCode field ex: DL = Cul-de-sac and Lake View
BASEMENT10 codes
CODEDESCRIPTION
1Daylight, Full
2Full Basement
3Improved Basement (Finished)
4Daylight, Partial
5No Basement
6Partial Basement
7Unfinished Basement
8Unspecified Basement
9Unspecified Basement
10Daylight / Walkout
BLDG_CODE5 codes
CODEDESCRIPTION
1Buildings having fireproofed structural steel frames carrying all wall, floor and roof loads. Wall, floor and roof structures are built of non-combustible materials.
2Buildings having fireproofed reinforced concrete frames carrying all wall, floor and roof loads which are all non-combustible.
3Exterior walls non-combustible material. Interior partitions and roof structure combustible materials. Floor concrete or wood frame.
4Buildings having wood or wood and steel frames.
5Specialized buildings that do not fit in any of the above categories.
BLDG_SQFT_IND15 codes
CODEDESCRIPTION
0Living Area - confirmed does not include Finished Basement
11st Floor
+Living Area - confirmed includes Finished Basement
AAttic
BBase Area
EHeated Area
GGarage
HChatahoochie (Porch)
IEffective Area
JAdjusted Area
KFinished Area
LLiving Area
MBuilding Perimeter
RGross Area
TTotal Area
CONDITION7 codes
CODEDESCRIPTION
1Excellent
2Fair
3Good
4Poor
5Unsound
6Average
7Very Good
CONST_TYPE19 codes
CODEDESCRIPTION
1Adobe
2Brick
3Concrete
4Concrete Block
5Dome
6Frame
7Heavy
8Light
9Log
10Manufactured
11Other
12Masonry
13Metal
14Steel
15Stone
16Tilt-up (pre-cast concrete)
17Wood
18Mixed
19Bamboo
DOC_TYPE122 codes
CODEDESCRIPTION
1Assignment of Sub Agreement of Sale (Hawaii)
2Assignment of Sub Lease (Hawaii)
3Assignment of Commercial Lease (Hawaii)
4Administrator’s Deed
5Affidavit
6Agreement of Sale
7Assignment of Agreement of Sale (Hawaii)
8Assignment Deed (or Condo Deed if Land Use = "CND")
9Affidavit of Trust or Trust Agreement (Los Angeles)
10Assignment of Sub Commercial Lease (Hawaii)
11Beneficiary Deed (Buyer ID = "BE")
12Bargain and Sale Deed
13Commissioners Assignment of Lease (Hawaii)
14Condominium Deed
15Cash Sale Deed
16Commercial Lease (Hawaii)
17Commissioner’s Deed - North Carolina in probate-related transfers. In Hawaii foreclosure-related transfers.
18Cancellation of Agreement of Sale (Hawaii)
19Conservator’s Deed
20Corporation Deed
21Correction Deed
22Contract of Sale
23Certificate of Transfer
24Deed of Distribution
25Declaration
26Transfer on Death Deed
27Deed
28Deed of Guardian
29Affidavit of Death of Joint Tenant
30Deed in Lieu of Foreclosure
31Distress Sale
32Exchange
33Executor’s Deed
34Foreclosure
35Fiduciary Deed
36Grant Deed
37Gift Deed
38Ground Lease
39Individual Deed
40Intrafamily Transfer & Dissolution
41Joint Tenancy Deed
42Legal Action/Court Order
43Leasehold Conv. With Agreement of Sale (Fee Purchase) (Hawaii)
44Land Contract
45Lease (Hawaii)
46Assignment of Lease (Leasehold Sale) (Hawaii)
47Leasehold Conv. with an Agreement of Sale (Hawaii)
48Land Court (Massachusetts)
49Limited Warranty Deed
50Special Master Deed
51Other
52Public Action - Common in Florida (Clerks Tax Deed or Tax Deeds or property sold for taxes.
53Partnership Deed
54Personal Representatives Deed
55Quit Claim Deed
56Satisfaction of Land Contract (WI) or Release/Satisfaction of Agreement of Sale (Fee Property) (HI)
57Receiver’s Deed
58Redemption Deed
59Referee’s Deed - transfer pursuant to a foreclosure sale (NY)
60Release/Satisfaction of Agreement of Sale (Leasehold) (Hawaii)
61Re-recorded Document
62Sub Agreement of Sale (Hawaii)
63Sub Commercial Lease (Hawaii)
64Sheriff’s Deed
65Sub Lease (Hawaii)
66Affidavit Death of Trustee/Successor Trustee (Los Angeles)
67Survivorship Deed
68Special Warranty Deed
69Trustee’s Deed (Certificate of Title)
70Vendor’s Lien
71Warranty Deed
72Transaction History Record
73Foreclosure Cancelled
74Certificate of Purchase/Certificate of Foreclosure Recorded
75Order Rescheduling Foreclosure Sale Date
76Foreclosure Judgment Entered
77Notice of Default
78PreForeclosure Newly Filed Complaint
79Notice of Lis Pendens
80Notice of Rescission
81Notice of Foreclosure Sale
82Notice of Trustee Sale
83Order of Dismissal/ Cancellation/ Release of Lis Pendens
84Re-recorded Notice of Default
85Re-recorded Final Judgment of Foreclosure
86Re-recorded Notice of Lis Pendens
87Re-Recorded Order of Dismissal
88Re-Recorded Notice of Rescission
89NF/NS updated with Sale Information (Rescheduled)
90Re-recorded Notice of Trustee's Sale
91PreForeclosure Sold
92Re-recorded Notice of Sale
93Stand Alone Mortgage
94Assignment of Mortgage
95Affidavit of Lost (or Missing) Assignment
96Correction Assignment
97Miscellaneous Assignment. Partial interest assignment
98Master Assignment. Single document for assignment of several mortgages
99Rerecorded Assignment
ASubstitution of Trustee and Assignment of Deed of Trust
BFull Release WITH a legal description
CMultiple Release. One document release several mortgages
DPartial Release WITH a legal description
EPartial Release with NO legal description
FFull Release with NO legal description
GSubstitution of Trustee and Full Reconveyance
HMortgage
KAssessor Sales History
LDivorce/Dissolution of Marriage Transfer
MAffidavit of Death of Life Tenant
NREO Sale (REO Out)
OQuit Claim Deed (arm's length)
POwelty Deed / Owelty Agreement
QRe-Recorded Partial Release of Lis Pendens
RMineral Rights Deed
SRe-Recorded Power of Attorney to Foreclose
UAssignment of Final Judgement of Foreclosure
VAffidavit- Notice of Sale (published or mailed)
WPower of Attorney to Foreclose Mortgage
XPartial Release of Lis Pendens
YDeed to Secure Debt/Security Deed
DTAffidavit of Death of Life Tenant
DRIVEWAY9 codes
CODEDESCRIPTION
1Driveway
2Driveway asphalt
3Driveway bomanite
4Driveway chat
5Driveway brick
6Driveway concrete
7Driveway paver
8Driveway gravel
9Driveway tile
EXT_WALL34 codes
CODEDESCRIPTION
1Asbestos shingle
2Brick
3Brick veneer
4Block
5Composition/Composite
6Concrete
7Concrete Block
8Glass
9Log
10Metal
11Rock, Stone
12Stucco
13Tile
14Tilt-up (pre-cast concrete)
15Other
16Wood Shingle
17Wood
18Wood Siding
19Siding (Alum/Vinyl)
20Adobe
21Shingle (Not Wood)
22Marble
23Combination
24Masonry
25Siding Not (aluminum, vinyl, etc.)
26EIFS / Synthetic Stucco
27Fiber cement siding (Hardi-board/Hardi-plank)
28Aluminum siding
29Vinyl siding
30Concrete tile
31Clay tile
32Ceramic tile
33Bamboo
34Masonite
FIN_TYPE8 codes
CODEDESCRIPTION
ADJAdjustable Rate
FIXFixed Rate
MULMultiple Loan Amounts
OTHOther
STPStep Interest Rate
UNKUnknown
VARVariable
AITDAll Inclusive DOT-Legacy
FLOOR_COVER27 codes
CODEDESCRIPTION
1Brick
2Concrete
3Covered
4Floating Floor/laminate
5Granite
6Linoleum
7Marble
8Stone
9Carpet
10Parquet
11Ceramic
12Slate
13Tile
14Vinyl
15Wood
16Combination
17Terrazzo
18Asbestos
19Dirt/Earth/Soil
20Cork
21Plywood
22Faux Wood Tile
23Softwood
24Hardwood
25Other
26Epoxy
27Torginol
GARAGE25 codes
CODEDESCRIPTION
1Attached Garage
2Built-in
3Carport
4Detached Garage
5Pole
6Offsite
7Garage
8Unimproved
9Parking Lot
10Mixed
11None
12Open
13Paved/Surfaced
14Ramp
15Parking Structure
16Tuckunder
17Underground/Basement
18Covered
19Yes - Unspecified
20Heated
21Unfinished - Attached
22Unfinished - Detached
23Finished - Attached
24Finished - Detached
25Finished
GEO_STATUS10 codes
CODEDESCRIPTION
5Record was coded to the 5-digit ZIP code centroid (U.S.) or the first 3-digit Postal Code Level (Canada)
7Record was coded to the ZIP + 2 centroid
9Record was coded to the ZIP + 4 centroid (U.S.) or the full 6-digit Postal Code Level (Canada)
ARecord was coded to interpolated rooftop level
BRecord was coded to the rooftop level
DThis object is in "Demonstration" mode and it detected the input of a Zip Code outside the allowable range.
EExpire
PParcel Centroid
RFA Roof Top
XRecord was not coded
HEAT25 codes
CODEDESCRIPTION
1Baseboard
2Electric
3Central
4Forced air unit
5Oil
6Floor/Wall
7Gravity
8Heat Pump
9Geo-thermal
10Hot Water
11Gas
12Partial
13Radiant
14None
15Other
16Steam
17Coal
18Space/Suspended
19Convection
20Solar
21Vent
22Wood Burning
23Propane
24Yes
25Zone
HEAT_FUEL10 codes
CODEDESCRIPTION
1Coal
2Electric
3Gas
4Geo-Thermal
5None
6Oil
7Propane
8Solar
9Wood
0Butane
INT_WALL22 codes
CODEDESCRIPTION
1Brick
2Concrete
3Gypsum Board/Drywall/Sheetrock/Wallboard
4Log
5Cement Board
6Plaster
7Stone
8Metal
9Unfinished
10Wood
11Block
12Glass
13Finished/Painted
14Decorative\Custom
15Masonry
16Composition
17Other
18Paneling
19Vinyl
20Plywood/Minimum
21Formica
22Celotex
LOAN_TYPE34 codes
CODEDESCRIPTION
1Stand Alone First
2Stand Alone Second
3ARM (Adjustable Rate Mortgage)
4Amount keyed is an Aggregate amount
5USDA
6Closed-end Mortgage
7Assumption
8Building or Construction Loan
9Cash
102nd Mortgage made to cover Down Payment
11Credit Line (Revolving)
12FHA
13Fannie Mae/Freddie Mac (Fannie Mae does not originate loans directly to borrowers or investors. Most "new conventional" loans meet their general underwriting guidelines.)
14Balloon
15Farmers Home Administration
16Negative Amortization
17Loan Amount $1-9 billion - first 9-digits Loan Amount x 10 = actual amount.
18Land Contract (Argmt. Of Sale)
19Mortgage Modification
20New Conventional
21Commercial
22Purchase Money Mortgage
23Undefined / Multiple Amounts
24Stand Alone Refi (Refinance of Original Loan)
25Seller take-back
26Loan Amount $10-99 billion - first 9-digits of Loan Amount x 100 = actual amount.
27Unknown (DEFAULT)
28VA
29Future Advance Clause / Open End Mortgage
30Trade
31State Veterans (code phased out August 17, 2020)
32Reverse Mortgage (Home Equity Conversion Mortgage)
33Non Purchase Money Mortgage
34SBA Participation Trust Deed
LOC_INFLUENCE263 codes
CODEDESCRIPTION
1Proximity - Freeway
2WATERFRONT-BEACH (Ocean, River or Lake)
3Contamination site
4Cul-de-sac
5CORNER
6View - Negative
7View - Average
8Historical
9Proximity - School
10Golf Course Adjacent
11View - None
12View - Lake
13View - Mountain
14WATERFRONT - CANAL
15View - Ocean
16Proximity - Airport
17GREEN BELT
18Proximity - Railroad
19Major street/thoroughfare
20High traffic area
21View - River
22View not specified
23Waterfront-Not Specified
24FLOOD PLAIN/FLOOD ZONE
25Alley
26View - Bay
27Canal
28City
29Creek
30Industrial
31Inferior
32Poor Access
33Suburban
34Woodland
35Water Front
36Creek Frontage
37Lake Frontage
38Flag Lot
39Small Lake or Pond
40Flood Plain
41Historical
42Wooded Lot
43Transition
44Perimeter
45Interior
46Rural Property
47Busy Street
48Exclusive
49Golf Course
50Highway Frontage
51BYPASS
52TYPE UNKNOWN
53ALLEY/CORNER
54AGRICULTURAL
55AIRPORT
57AVERAGE
58BAY ACCESS
59BEHIND BAY FRONT
60BEACH
61BAY FRONT
62BEHIND GULF FRONT
63BAY FRONT ISLAND
65BAY FRONT MAIN-LAND
66BEACH ROAD
67BUSINESS
68BAYOU
69BAY
71CANAL/WATERFRONT
73CANAL DRAINAGE
74CORNER/EXTRA FRONT
75CANAL FRONT
76CANAL FRONT ISLAND
77CREEK/RIVER
78CORNER/LANDLOCK
79CANAL MAIN-LAND
80CORNER/WOODLOT/WATERFRONT
81CORNER/WOODLOT
82CORNER
83CORNER/RESTRICTIONS
84CORNER/WATERFRONT
85CUL-DE-SAC
86CORNER/LANDLOCK/WOODLOT
88DEAD END
89DRAINAGE EASEMENT
90DOWNTOWN
91DRAINAGE
92DESIRABLE
93DUPLEX LOTS
94EXTRA FRONT
95EXPENSIVE LAND
96EXTRA FRONT/RESTRICTIONS
97EASEMENT
98FLOOD LINE
99FOUR PLEX LOT
100FLOOD PLAIN
101GOLF COURSE
102GREENBELT/GOLF COURSE
103GOLF/LAKE
104GOOD
105GREENBELT
106GULF
107GOLF/WATER
108HIGHWAY
109INSIDE CITY
110ISLAND GULF FRONT
111INDUSTRIAL
112IN-OUT CITY
113ISLAND
114INLAND WATERWAY
115ISLAND NO WATERFRONT
116LAGOON
117LANDLOCKED/WOODLOT/WATERFRONT
118LAKE FRONT
119LAKE
120LANDLOCKED
121LAKE/POND
122LANDLOCKED/WOODLOT
123LANDLOCKED/WATERFRONT
124MOBILE HOME
125MAIN LAND
126MOUNTAIN
127NON BUILDABLE
128INTRACOASTAL
129NEIGHBORHOOD
131INTERIOR
132OCEAN
133OPEN SPACE
134OUTSIDE CITY
135PARK LAND
136POOR ACCESS
137POND
138PERIMETER LOT
139PARK FRONT
140POOL
141PRESERVE
143PRIVATE ROAD
144RAVINE
145RECREATIONAL
146REAR
147RIVER
148IRREGULAR LOT
149ROAD
150RESTRICTIONS
151RURAL
152SOUND
153SUBMERGED LAND
154STREET
156TOWNHOUSE
157TRI PLEX LOT
158TRAFFIC
159URBAN
160VALLEY
161WATER ACCESS
162WATER/CUL-DE-SAC
163WETLAND
164WATERFRONT
166WATERFALLS
167WATER
168WOODLOT/WATERFRONT
169APT/CONDO COMPLEX
170BUSINESS CLUSTER
171CENTRAL BUSINESS
172COMMERCIAL/INDUSTRIAL
173INDUSTRIAL SIZE
174MAJOR STRIP
175NEIGHBORHOOD / SPOT
176PERM CENTRAL BUSINESS
177SECONDARY BUS STRIP
178ZERO LOT LINE
179TYPE UNKNOWN
180UNIT ABUTS ELEVATOR
181AVERAGE
182CONDOMINIMUM HI-RISE
183CONDOMINIMUM LO-RISE
184CONDO
185CORNER UNIT
186CONDOMINIMUM VILLAS
187DUPLEX
188END UNIT
189EXCELLENT
190FIRE DAMAGE
191FRONT UNIT
192GOOD
193INFERIOR
194INTERIOR UNIT
195OUTSIDE CITY
196PENTHOUSE
197RECREATIONAL
198RIVER
199REAR UNIT
200SPLIT PLAN/MASTER
201SUPERIOR
202TYPICAL
203EXTERIOR UNIT
204APARTMENT/CONDO
205APARTMENT
206BUILDABLE
207CITY
208COMMERCIAL
209SECONDARY
210FRONT
211HOMESITE
213INSTITUTIONAL
214MOBILE HOME
215NEIGHBORHOOD
216PRIMARY
217RESIDUAL
218REHABILITATION
219ROAD
220RESTAURANT
221REAR UNIT
222WAREHOUSE
223EXCESS
224TYPE UNKNOWN
225AIRPORT
226AVERAGE
227BAY
228BEST
229BLUFF
230BETTER
231CANAL
232CITY
233CREEK/LAKE
234CANYON
235MONSERVATION / PROTECTED AREA
236CANYON/VALLEY
237EXCELLENT
238FAIR
239GOLF COURSE
240GOOD
241GREENBELT/PARK
242GULF
243HILLS/MOUNTAINS
244HILL/VALLEY
245INFERIOR
246INTERSTATE
247INLAND WATERWAY
248INTERCOASTAL WATERWAY
249LAKE
250LAGOON
251LAKE/POND
252MOUNTAIN
253MOUNTAIN/OCEAN
254OBSTRUCTED
255OCEAN
256PARK
257POND
258PARKING
259PRIME
260POOL
261PREMIUM
262POOR
263RECREATIONAL
264ROAD
265RIVER
266STANDARD
267SUBURBAN
268SUPERIOR
269STREET
270TYPICAL
271WOODLAND
272WATER
273WATER VIEW
LOT_CODE4 codes
CODEDESCRIPTION
MMore than one lot
MPMultiple w/a portion of one or more lots
PPortion of a lot
1-99Single Lot number
LU_CODE368 codes
CODEDESCRIPTIONCLASS
0010Miscellaneous (General)
0011Pipeline or Right-of-Way
0012Rail (Right-of-way & track)
0013Road (Right-of-way)
0014Utilities (Right-of-way ONLY)
0015Sub-Surface Rights (mineral)
0016Surface Rights (Grazing, timber, coal,)
0017Leasehold Rights (misc.)
0018Possessory Interest (misc.)
0019Petroleum & Gas Wells (misc.)
0020Water Rights (misc.)
0021Right-of-Way (not rail, road or utility)
0022Easement (misc.)
0023Homestead (Misc.)
0024Common Area (misc.)
0025Royalty Interest
0026Working Interest
0027Parcels with improvements, Use Not SpecifiedR
0500Personal Property General
0510Vehicles General
0511Motor Vehicles (cars, trucks, etc.)
0512Recreational Vehicles / Travel Trailers
0513Watercraft (ships, boats, PWCs, etc.
0514Aircraft
0515Rolling stock (railroad)
0516SpaceCraft
0519Misc vehicles not otherwise classed (antiques, etc.)
0520Business Personal Property General
0521Enquipment / Supplies
0522Inventory
0523Goods in transit
0524Livestock (animals, fish, birds, etc.)
0525Crops (in ground)
0526Crops (harvested)
0529Misc Business Personal not classed
0530Structures (general)
0532Structures on leased land
0533Temporary Structures
0539Misc. structures not classed (billboards, etc.
0540Intangable personal property
0599Misc. Property not classed
0714Forest
0752Park
1000Residential (General) (Single)R
1001Single Family ResidentialR
1002Townhouse (Residential)R
1003Cluster home (Residential)R
1004Condominium Unit (Residential)R
1005Cooperative Unit (Residential)R
1006Mobile/Manufactured Home (regardless of Land ownership)R
1007Row house (Residential)R
1008Rural/Agricultural ResidenceR
1009Planned Unit Development (PUD Residential)R
1010Residential Common Area (Condo/PUD/etc.)R
1011Timeshare (Residential)R
1012Seasonal, Cabin, Vacation ResidenceR
1013Bungalow (Residential)R
1014Zero Lot Line (Residential)R
1015Misc Residential ImprovementR
1016Modular/Pre-Fabricated HomesR
1017Patio HomeR
1018Garden HomeR
1019LandominiumR
1020BarndominiumR
1021Tiny HouseR
1022Single Family Residential w/ADUR
1023Accessory Dwelling Unit (ADU)R
1024Single Family Residential - Two or more SFR on one parcelR
1025Horizontal Property RegimeR
1100Residential Income (General) (Multi-Family)R
1101Duplex (2 units, any combination)R
1102Triplex (3 units, any combination)R
1103Quadruplex (4 units, any combination)R
1104Apartment house (5+ units)R
1105Apartment house (100+ units)R
1106Garden Apt, Court Apt (5+ units)R
1107Highrise ApartmentsR
1108Boarding House, Rooming House, Apt Hotel, Transient Lodgings, HostelR
1109Mobile Home or Trailer ParkR
1110Multi-Family Dwellings (Generic, 2+)R
1111Fraternity or Sorority HouseR
1112Apartments (generic)R
1113Dormitory, Group Quarters (Residential)R
1114Residential Condominium Development (Association Assessment)R
1115Care Facility (rehab; retirement, rest, convalescent, or nursing home)R
1124Condominium Building (Residential)R
1125Cooperative Building (Residential)R
1126Apartment House (fewer than 5 units)R
1901Residential Parking GarageR
1902Residential Storage Space is mainly applied to storage spaces that are assessed separately from their correlated CondosR
1999Single Family Residential (Assumed)R
2000Commercial (General)C
2001Retail Stores (Personal Services, Photography, Travel)C
2002Store (multi-story)C
2003Store/Office (mixed use)C
2004Department Store (apparel, household goods, furniture)C
2005Department Store (multi-story)C
2006Grocery, SupermarketC
2007Regional Shopping Center or Mall with Anchor storeC
2008Community Shopping Plaza or Shopping Center, Mini-MallC
2009Neighborhood Shopping Center, Strip Center/Mall, Enterprise ZoneC
2010Shopping Center COMMON AREA parking, park etc.C
2011Veterinary or Animal HospitalC
2012RestaurantC
2013Fast Food Restaurant / Drive-thruC
2014Take-out RestaurantC
2015BakeryC
2016Bar, TavernC
2017Liquor StoreC
2018Convenience storeC
2019Convenience Store with fuelC
2020Service station (full service)C
2021Service station w/convenience store (food mart)C
2022Truck stop (fuel and diner)C
2023Vehicle Rentals, Vehicle SalesC
2024Auto repair, auto parts, GarageC
2025Car washC
2026Dry Cleaner, Laundry ServiceC
2027Service ShopC
2028Nursery, Greenhouse, FloristC
2029Wholesale Outlet, Discount StoreC
2030Printer/Delivery - Retail (Kinkos, UPS, FedEx, etc.)C
2031Mini-Warehouse, Self-StorageC
2032Day care, Pre-school (Commercial)C
2033MotelC
2034HotelC
2035Parking Garage, Parking StructureC
2036Parking LotC
2037Funeral Home, Mortuary (Commercial)C
2038CasinoC
2039Hotel-ResortC
2040Hotel or MotelC
2041Gas StationC
2042Retail/Residential (mixed use)C
2043Commercial BuildingC
2044Commercial/Office/Residential (mixed use)C
2045Appliance Store (Best Buy, HH Gregg)C
2046KennelC
2047Laundromat (self-service)C
2048Nightclub (Cocktail Lounge)C
2050Farm Supply & Equipment (retail)C
2051Home Improvement, Garden Center (Home Depot, Lowes)C
2052Commercial Condominium (not offices)C
2053Drug Store / Pharmacy (CVS, Walgreens)C
2054Bed & BreakfastC
2055Barber/Hair SalonC
2056Pet Boarding & GroomingC
2057Roadside MarketC
2058Car Wash - AutomatedC
2059Car Wash - Self-ServeC
2060Cannabis DispensaryC
2061Lumberyard, Building MaterialsC
2062Hardware StoreC
2063Furniture, Home FurnishingsC
2064Antiques, Flea MarketC
2065ConsignmentC
2066Thrift Store, Secondhand StoreC
2067Books, StationaryC
2068Computer, SoftwareC
2069Clothing, Shoes, Luggage, Jewelry, etc.C
2070Sporting Goods, Toy & Hobby, MusicC
2071Confectionery, Candy, NutsC
2100CondotelC
3000Commercial Office (General)O
3001Professional Bldg (legal; insurance; real estate; etc.)O
3002Professional Bldg (multi-story)O
3003Office Bldg (General)O
3004Office Bldg (multi-story)O
3005Dental BldgO
3006Medical Bldg/ClinicO
3007Financial BldgO
3008Condominium OfficesO
3009Skyscraper/Highrise (Commercial Offices)O
3010Commercial/Industrial (mixed use)O
3011Common Area (commercial)O
3012Mobile Commercial UnitsO
3013Accounting, Tax, Payroll, Employment ServicesO
3014Professional Schools: Beauty, Trade/Vocational, Driving, FlightO
4000Recreational/Entertainment (General)F
4001Recreation CenterF
4002Public Swimming PoolF
4003Boat slips, Marina, Yacht Club, Boat LandingF
4004Bowling AlleyF
4005Arcades (Amusement)F
4006Skating rink, Ice Skating, Roller SkatingF
4007Clubs, Lodges, Professional AssociationsF
4008Museums, Library, Art GalleryF
4009Country ClubF
4010StadiumsF
4011Arenas, Convention CenterF
4012AuditoriumsF
4013Golf Driving RangeF
4014Race trackF
4015Gym, Health SpaF
4016Dance HallF
4017Riding Stable, TrailsF
4018Campground, RV ParkF
4019FairgroundsF
4020TheaterF
4021Drive-In TheaterF
4022Amusement Park, Tourist AttractionF
4023Piers, WharfF
4024Fish Camps, Game Club, Target ShootingF
4025Outdoor Recreation: Beach, Mountain, DesertF
4026Pool Hall, Billiard ParlorF
4027Park, Playground, Picnic AreaF
4028Golf CourseF
4029Racquet or Tennis CourtF
4030ZooF
4031Go-carts, Miniature Golf, Water slidesF
4032Sports ComplexF
4033ClubhouseF
4034Wedding/Event VenueF
5000Industrial (General)I
5001Manufacturing (light)I
5002Light IndustrialI
5003Warehouse (Industrial)I
5004Storage yard, Open Storage (light equipment, material)I
5005Food Packing, Packing PlantI
5006Assembly (light industrial)I
5007Food ProcessingI
5008Recycling plantI
5009CommunicationsI
5010Condominiums (Industrial)I
5011Laboratory, Research and Development Facility, Cosmetics, PharmaceuticalI
5012Industrial ParkI
5013Multi-Tenant Industrial BldgI
5014Marine Facility/Boat Repairs (small craft or sailboat)I
5015Lumber & Wood Product Manufacturing (including furniture)I
5016Paper Product Manufacturing & related productsI
5017Printing & Publishing (Light Industrial)I
5018Industrial Loft Building, Loft BuildingI
5019Construction/Contracting Services (Industrial)I
5020Common Area (Industrial)I
5021Data CenterI
6000Heavy Industrial (General)I
6001TransportationI
6002Distribution Warehouse (Regional)I
6003Mining facility (oil; gas; mineral, precious metals)I
6004Storage yard (junk; auto wrecking, salvage)I
6005Distillery, Brewery, BottlingI
6006Refinery, Petroleum ProductsI
6007MillI
6008Factory (medium)I
6009Processing PlantI
6010Lumberyard, Building MaterialsI
6011Shipyard/Storage - Built or Repaired (seagoing vessels)I
6012Slaughter House, StockyardI
6013Waste Disposal, Sewage, Treatment facilityI
6014QuarriesI
6015Heavy ManufacturingI
6016Labor Camps (Industrial)I
6017WineryI
6018ChemicalI
6019Foundry, Industrial PlantI
6020CanneryI
6021Gasoline, Fuel Bulk StorageI
6022Grain ElevatorI
6023Dump SiteI
6024Cold StorageI
6025Sugar RefineryI
6500Transportation & Communications (General)T
6501Airport & relatedT
6502Railroad & relatedT
6503Freeways, State HwysT
6504Roads, Streets, BridgesT
6505Bus TerminalT
6506Telegraph, Telephone CommunicationsT
6507Radio or TV Station CommunicationsT
6508Truck Terminal (Motor Freight)T
6509Cable TV Station CommunicationsT
6510Harbor & Marine TransportationT
6511MicrowaveT
6512Commercial Auto Transportation/StorageT
6513Pollution ControlT
6514CellularT
7000Agricultural / RuralA
7001Farm landA
7002RanchA
7003Range land (grazing)A
7004Crop, Field Crops, Row Crops (all soil classes)A
7005Orchard (fruit; nut)A
7006Vineyard (Agricultural)A
7007Poultry FarmA
7008Dairy FarmA
7009Timberland, Forest, Trees (Agricultural)A
7010Wildlife RefugeA
7011Desert or Barren LandA
7012Pasture, MeadowA
7013Misc. Structures - Ranch, Farm, FixturesA
7014Grove (Agricultural)A
7015FeedlotsA
7016Livestock parcelA
7017Horticulture, Growing Houses (Agricultural)A
7018Well Site (Agricultural)A
7019Truck Crops (tobacco; cash crops)A
7020Reservoir, Water SupplyA
7021Irrigation, Flood ControlA
7022Natural ResourcesA
7023Rural Improved / Non-ResidentialA
7024Cannabis Grow FacilityA
8000Vacant Land (General)V
8001Residential-Vacant LandV
8002Commercial-Vacant LandV
8003Industrial-Vacant LandV
8004Private Preserve, Open Space-Vacant Land (Forest Land, Conservation)V
8005Institutional-Vacant LandV
8006Government-Vacant LandV
8007Multi-Family-Vacant LandV
8008Rural/Agricultural-Vacant LandV
8009Waste Land, Marsh, SwampV
8010Recreational-Vacant LandV
8011Water Area (Lakes; River; Shore)V
8012Unusable Land (Remnant, Steep, etc.)V
8013Abandoned Site, Contaminated SiteV
8014Under ConstructionV
8015Vacant Land - Destroyed/Uninhabitable ImprovementV
8016Vacant Land - Unspecified ImprovementV
8017Vacant Land - ExemptV
8500Special PurposeV
8501State Board of Equalization - Special AssessmentsV
8502Regulating Districts & Assessments; Tax AbatementV
8503Redevlopment Agency or ZoneV
8504Centrally AssessedV
9000Exempt (full or partial)E
9001Native American Lands / American Indian LandsE
9100Institutional (General)E
9101Religious, Church, WorshipE
9102Parochial School, Private SchoolE
9103Educational - PRIVATEE
9104Hospital-PRIVATEE
9105Medical ClinicE
9106Retired, Handicap, Convalescent, Nursing HomeE
9107Childrens Home, OrphanageE
9108Cemetery (Exempt)E
9109Crematorium, Mortuary (Exempt)E
9110Charitable organizationE
9111Recreational Non-Taxable (Camps, Boy/Girl Scouts)E
9112Private Utility (electric, water, gas, nuclear, solar, wind, etc.)E
9200Governmental/Public Use (General)E
9201MilitaryE
9202Forest (park; reserve; recreation, conservation)E
9203Public SchoolE
9204Educational Colleges, University-PUBLICE
9205Post OfficeE
9206Cultural, HistoricalE
9207Govt. Administrative OfficeE
9208Emergency (Police; Fire; etc)E
9209Other exempt propertyE
9210City, Municipal, Town, Village OwnedE
9211County OwnedE
9212State OwnedE
9213Federal PropertyE
9214Public Health Care FacilityE
9215Community CenterE
9216Public Utility (electric, water, gas, nuclear, solar, wind, etc.)E
9217Welfare, Social Service, Low Income Housing (Exempt)E
9218Correctional Facility, Jails, Prisons, Insane AsylumE
9219Hospital-PUBLICE
9300Historical-PRIVATE (General)E
9301Historical ResidenceE
9302Historical RetailE
9303Historical WarehouseE
9304Historical OfficeE
9305Historical Transient Lodging (hotel/motel)E
9307Historical Recreation, EntertainmentE
9308Historical Park / SiteE
9309Historical DistrictE
OTHER_ROOMS19 codes
CODEDESCRIPTION
ALanai
BBreakfast Nook
CCellar
DMud room
FFamily room/Den
GGame / Recreation room
HHobby room
ISitting Room
LLAUNDRY ROOM
MMedia room/Home theater
NBonus Room
OHome Office
RATRIUM
SSun, Solarium, Florida room
TGreat room
UStudy/Library
XExercise/Home Gym
YUtility room
MultiCodeMultiCode field ex: FG = Family room/Den and Game / Recreation room
OWNER_OCC3 codes
CODEDESCRIPTION
BProbable owner-occupied property (Legacy Code)
OOwner-occupied property (Legacy Code)
YOwner-occupied property
OWNER_VEST130 codes
CODEDESCRIPTION
99Heirs
ABAlternate Beneficiary
ACGuardian/Custodian
ADAdministrator
AEAssignee (Buyer/Borrower only)
AFName derived from Affidavit
AGAgent or Guardian
AKAlso known as (A/K/A)
ALAll as/Undefined
AOAlter Ego
ARAssignor (Seller only)
ASAssociation
BEBeneficiary / Creditor - Doc Type BD, buyer ID identifies designated to acquire title upon death of Grantor.
BSBrother & Sister
BUBuilder/Developer
CACorporate Trustee
CECorporate Trustee
CFContract Purchasor
CNCorporation
COCompany or Corporation
CPCommunity Property (Marital Community)
CRCommunity Property (Marital Community) with rights of survivorship
CTCorporate Trust
DBDoing business as (DBA)
DCDeceased
DEDECEASED
DFDefendant
DPDomestic Partner
DRDivorced not Remarried
DSDisabled
DVDivorced
DWDower Clause
EAEt al (and others)
ESEstate
EUEt ux (and wife) - vendor data only
EXExecutor / Administrator
FKFormerly known as (F/K/A)
FLFamily Living Trust
FMFamily Trust
FRFamily Revocable Trust
FTFamily Trust
GDGuardian
GNGeneral Partnership
GPGeneral Partner
GVGovernment
HEHeirs
HHHer Husband
HOHomeowners Association
HUHusband and Husband
HWHusband and Wife
IAIRA (Individual Retirement Account)
IDIndividual(s)
ILIrrevocable Living Trust
INincompetent
IRIrrevocable Trust
ITIrrevocable Trust
JSJoint tenants with right of survivorship
JTJoint Tenants
JVJoint Venture
L2Seller is owner on current Assessment File
LBLife Benefit Estate
LCLimited Liability Company
LELife Estate (phased out Spring, 2009, now Buyer/Borrow ID Code = "LT".)
LFLease From
LLLimited Liability Partnership
LPLimited Partner
LSLimited Partnership
LTLife Tenant (holds a life estate interest only)
LVLiving Trust
LWLast Will and Testament
MAMarried
MCMarried Couple
MEMember
MIMinor, Ward or Client (Represented by Trustee)
MMMarried man as his sole and separate property
MNManaging Member
MPMarried Person
MWMarried women as her sole and separate property
NKNow Known as
NMNever Married Person
NPNot Provided (name blurred or missing from document)
NTNon Declared Trust
NVNon-Vested Spouse
PAPartnership
PFPlaintiff
PRPersonal Representative (Attorney in Fact/Power of Attorney)
PSPartnership
PTPersonal Trust
RCReceiver
RLRevocable Living Trust
RMRemainderman
RSRight of Survivorship
RTRevocable Trust
SESeparate Property
SGSingle
SISuccessor in Interest
SJSurviving Joint Tenant
SLSole Proprietorship
SMSingle man
SOSole Member
SPSurvivorship Martial Property (Wisconsin/Alaska with marital property system effective 01/01/1986. )
SSSurviving Spouse
STSuccessor Trustee (LA County only)
SUSurvivor
SVTenants in Severalty
SWSingle woman
SXSeparated
SYSurvivorship Martial Property -- This code will be used primarily in Wisconsin/Alaska who adopted a marital property system effective 01/01/1986.
TCTenants in Common
TDTransfer of Death
TETenants by Entireties
TNTenant
TRTrust, Trustee, or Conservator
TSTrustor/Debtor (Borrower in Default/Foreclosure on Trustee's Deed)
TTTrust
TXTAX PAYER
TYTenants in Entirety
UIUndivided Interest
UMUnmarried Man
UNUnmarried
USUnited States
UWUnmarried Woman
WAWho Acquired Title As
WDWidow or Widower
WFWife
WHHis Wife
WIWife
WRWidower
WWWife and Wife
XXWholly Exempt
PATIO124 codes
CODEDESCRIPTION
1Yes
2NONE
3PATIO
4Patio
5PATIO
6BRICK/FLAGSTONE/TERAZZO PATIO
7BRICK/STONE/SLATE PATIO
8BRICK/TILE PATIO
9MARBLE/SLATE PATIO
10MARBLE/STONE/SLATE PATIO
11BRICK PATIO
12CONCRETE/MASONRY PATIO
13FLAGSTONE PATIO
14ASPHALT PATIO
15PEBBLE PATIO
16TILE PATIO
17CONCRETE BLOCK PATIO
18CHATTAHOOCHEE/RIVERROCK PATIO
19PAVED PATIO
20STONE/TILE PATIO
21STONE/SLATE PATIO
22CUT CORAL PATIO
23WOOD PATIO
24MARBLE PATIO
25TERRAZZO PATIO
26SL1 slab
27SL2 slab
28SL3 slab
29SL4 slab
30SL5 slab
31SL6 slab
32COVERED/DETACHED PATIO
33SL7 slab
34GAZEBO
35SL8 slab
36SL9 slab
37ATTACHED PATIO
38COVERED PATIO
39COVERED ALUMINUM PATIO
40COVERED BRICK PATIO
41COVERED CONCRETE MASONRY PATIO
42COVERED STONE/SLATE PATIO
43DETACHED PATIO
44DETACHED CONCRETE MASONRY PATI
45ENCLOSED PATIO
46ENCLOSED CONCRETE/MASONRY PATI
47ENCLOSED FRAME PATIO
48FINISHED PATIO
49OPEN PATIO
50OPEN BRICK PATIO
51OPEN CONCRETE/MASONRY PATIO
52OPEN FIBERGLASS PATIO
53OPEN PAVED PATIO
54OPEN FRAME PATIO
55SCREENED PATIO
56SCREENED ALUMINUM PATIO
57SCREENED FIBERGLASS PATIO
58ENCLOSED/SCREENED PATIO
59Porch/no step
60BALCONY
61WOOD BALCONY
62ENCLOSED BALCONY
63OPEN BALCONY
64RAILED BALCONY
65RAILED CONCRETE/MASONRY BALCON
66RAILED WOOD BALCONY
67SCREENED BALCONY
68Porch/step
69DECK
70BRICK DECK
71CONCRETE/MASONRY DECK
72CEDAR/REDWOOD DECK
73COOL DECK
74TILE DECK
75MASONRY DECK
76CHATTAHOOCHEE DECK
77FRAME DECK
78STONE/SLATE DECK
79WOOD DECK
80TERRAZZO DECK
81ATTACHED DECK
82COVERED DECK
83COVERED WOOD DECK
84DETACHED DECK
85DETACHED WOOD DECK
86ENCLOSED DECK
87OPEN DECK
88OPEN WOOD DECK
89RAILED DECK
90RAILED WOOD DECK
91UNCOVERED DECK
92Screened
93DECK/CANOPY
94Enclosed
95DECK/BALCONY
96WOOD DECK/BALCONY
97Aluminum
98TERRACE
99CONCRETE/MASONRY TERRACE
100FLAGSTONE TERRACE
101BLOCK TERRACE
102BRICK TERRACE
103WOOD TERRACE
104COVERED TERRACE
105DETACHED TERRACE
106DETACHED MASONRY TERRACE
107Min Carport
108DECK/PORCH
109COVERED DECK/PORCH
110ENCLOSED DECK/PORCH
111FINISHED/OPEN DECK/PORCH
112Balcony
113DECK/TERRACE
114CONCRETE/MASONRY DECK/TERRACE
115STONE/SLATE DECK/TERRACE
116Sundeck
117PATIO/TERRACE
118DECK/PATIO
119WOOD DECK/PATIO
120BYPASS
121COVERED DECK/PATIO
122DECK/PATIO
123WOOD DECK/PATIO
124COVERED DECK/PATIO
POOL12 codes
CODEDESCRIPTION
1Above ground pool
2Pool & Spa (both)
3Community Pool or Spa
4Enclosed
5Heated Pool
6Indoor Swimming Pool
7Solar Heated
8Pool (yes)
9Spa or Hot Tub (only)
10Vinyl In-ground Pool
11Pool, historical value
12In-Ground Pool
PORCH141 codes
CODEDESCRIPTION
1Yes
2NONE
3PORCH
4Patio
5SL1 slab
6SL2 slab
7SL3 slab
8SL4 slab
9SL5 slab
10SL6 slab
11SL7 slab
12SL8 slab
13SL9 slab
14Porch/no step
15Porch/step
16Screened
17Enclosed
18Aluminum
19Min Carport
20Balcony
21Sundeck
22BYPASS
23DETACHED/FINISHED PORCH/CARPOR
24DETACHED/UNFINISHED PORCH/CARP
25SLAB
26CONCRETE/WOOD SLAB
27CONCRETE/MASONRY SLAB
28CONCRETE/METAL SLAB
29COVERED SLAB
30ENCLOSED SLAB
31OPEN SLAB
32SCREENED SLAB
33COLONIAL STYLE
34BALCONY/PATIO
35FLORIDA ROOM
36PORCH
37UNCOVERED PORCH
38CONCRETE/VINYL PORCH
39ALUMINUM PORCH
40BRICK PORCH
41CONCRETE/MASONRY PORCH
42METAL/WOOD/SCREENED PORCH
43METAL/WOOD PORCH
44FLAGSTONE PORCH
45COOL DECK PORCH
46METAL PORCH
47FRAME PORCH
48STONE/SLATE PORCH
49VINYL PORCH
50WOOD PORCH
51WOOD/SCREENED PORCH
52GLASS PORCH
53FINISHED/SCREENED PORCH
54FINISHED/SCREENED CONCRETE/MAS
55FINISHED/SCREENED TILE PORCH
56FINISHED/SCREENED METAL PORCH
57OPEN/SCREENED PORCH
58OPEN/UNFINISHED PORCH
59SCREENED/UNFINISHED PORCH
60SCREENED/UNFINISHED METAL PORC
61DETACHED/ENCLOSED PORCH
62COVERED/FINISHED PORCH
63UNFINISHED OPEN PORCH
64ATTACHED PORCH
65COVERED/ENCLOSED CONCRETE/MASO
66COVERED PORCH
67COVERED ALUMINUM PORCH
68COVERED BRICK PORCH
69COVERED CONCRETE/MASONRY PORCH
70COVERED FLAGSTONE PORCH
71COVERED STONE/SLATE PORCH
72COVERED WOOD PORCH
73COVERED TERRAZZO PORCH
74DETACHED PORCH
75DETACHED CEDAR/REDWOOD PORCH
76DETACHED FRAME PORCH
77ENCLOSED PORCH
78ENCLOSED BRICK PORCH
79ENCLOSED CONCRETE/MASONRY PORC
80ENCLOSED BLOCK PORCH
81ENCLOSED FRAME PORCH
82ENCLOSED STONE/SLATE PORCH
83ENCLOSED VINYL PORCH
84ENCLOSED WOOD PORCH
85ENCLOSED GLASS PORCH
86FINISHED PORCH
87FINISHED METAL PORCH
88FINISHED VINYL PORCH
89ENCLOSED/FINISHED PORCH
90ENCLOSED/FINISHED CONCRETE/MAS
91ENCLOSED/FINISHED WOOD PORCH
92DETACHED/FINISHED PORCH
93DETACHED OPEN PORCH
94COVERED/DETACHED/UNFINISHED PO
95COVERED/DETACHED/FINISHED PORC
96DETACHED/SCREENED PORCH
97DETACHED/FINISHED/SCREENED POR
98ENCLOSED/UNFINISHED PORCH
99ENCLOSED/UNFINISHED CONCRETE/M
100ENCLOSED/UNFINISHED FRAME PORC
101ENCLOSED/UNFINISHED WOOD PORCH
102OPEN PORCH
103OPEN ALUMINUM/FIBERGLASS PORCH
104OPEN BRICK PORCH
105OPEN CONCRETE/MASONRY PORCH
106OPEN FRAME PORCH
107COVERED/OPEN PORCH
108COVERED/OPEN BRICK PORCH
109DETACHED/UNFINISHED
110RAISED PORCH
111SCREENED PORCH
112SCREENED ALUMINUM PORCH
113SCREENED BRICK PORCH
114SCREENED CONCRETE MASONRY PORC
115SCREENED METAL PORCH
116SCREENED TILE PORCH
117SCREENED METAL/WOOD PORCH
118SCREENED VINYL PORCH
119SCREENED WOOD PORCH
120UNFINISHED PORCH
121UNFINISHED VINYL PORCH
122COVERED/UNFINISHED PORCH
123DETACHED/UNFINISHED/SCREENED P
124ENCLOSED/SCREENED PORCH
125FINISHED SCREENED PORCH
126FINISHED/OPEN PORCH
127FINISHED/OPEN CONCRETE MASONRY
128FINISHED/OPEN TILE PORCH
129STOOP
130STOOP
131FRAME STOOP
132COVERED STOOP
133COVERED FRAME STOOP
134BREEZEWAY
135ENCLOSED BREEZEWAY
136ENCLOSED/UNFINISHED BREEZEWAY
137PATIO/PORCH
138ALUMINUM PATIO/PORCH
139COVERED PATIO/PORCH
140COURTYARD
141BRICK COURTYARD
PROP_CL_IND9 codes
CODEDESCRIPTION
RRESIDENTIAL
CCOMMERCIAL
OOFFICE
FRECREATIONAL
IINDUSTRIAL
TTRANSPORTATION
AAGRICULTURAL
VVACANT
EEXEMPT
QUALITY15 codes
CODEDESCRIPTION
1A
2A-
3A+
4B
5B-
6B+
7C
8C-
9C+
10D
11D-
12D+
13E
14E-
15E+
ROOF_COVER28 codes
CODEDESCRIPTION
1Asbestos
2Built-up
3Composition Shingle
4Concrete
5Metal
6Slate
7Rock / Gravel
8Tar & Gravel
9Bermuda
10Masonite/ Cement Shake
11Fiberglass
12Aluminum
13Wood Shake/ Shingles
14Other
15Asphalt
16Roll Composition
17Steel
18Tile
19Urethane
20Shingle (Not Wood)
21Wood
22Gypsum
23Ceramic tile
24Clay tile
25Concrete tile
26Copper
27Tin
28Solar
ROOF_TYPE18 codes
CODEDESCRIPTION
1GABLE
2BOWSTRING TRUSS
3REINFORCED CONCRETE
4DOME
5STEEL FRM/TRUSS
6FLAT
7GABLE OR HIP
8HIP
9IRR/CATHEDRAL
10GAMBREL
11MANSARD
12PRESTRESS CONCRETE
13RIGID FRM BAR JT
14SHED
15SAWTOOTH
16WOOD TRUSS
17MONITOR
18A-Frame
SALE_PRICE44 codes
CODEDESCRIPTION
1Qualifies as a comparable sale as defined by the county.
2Liens Exceed Value or Assumption of Loan exceed market value.
3Sales Price computed from the Transfer Tax, Transfer Tax not keyed.
4Sales Price amount or Transfer Tax unreadable.
5Unable to calculate Sales Price from given Transfer Tax.
6Non-arms length transaction.
7Sales Price or Transfer Tax rounded by county prior to computation.
8Sold for Taxes.
9Unable to calculate Sales Price from given Transfer Tax.
10Transfer Tax on document indicated as EXEMPT.
11Document states price as "0", "None", "No Consideration".
12Sales Price computed using current Excise Tax Rate based on city name (WA)
13Full amount computed from Transfer Tax or Excise Tax.
14Full amount stated on Document.
15Partial amount computed from Transfer Tax.
16Sales price from Transfer Tax.
17Comparable Market Value.
18Exchange (HI)
19Full amount from assessment file, when available.
20Document states that Price/Transfer Tax is not a matter of public record.
21From recorded Affidavit of Value or Verified.
22Full amount from assessment file, when available.
23Unable to compute
24Comparable Market Value.
25Full amount stated on Document.
26Exchange (HI)
27Full amount computed from Transfer Tax or Excise Tax.
28Amount of redemption. Only used for Redemption Deeds. (DocType = “RD”)
29Sales Price computed from transfer tax based on either full consideration or assessed value (NE and Kenosha WI only)
30Judgment Amount
31Liens Exceed Value or Assumption of Loan. Liens/Loans involved in the transaction exceed market value.
32Sales Price computed from Transfer Tax, Transfer Tax not keyed.
33Non-arms length transaction.
34Partial amount computed from Transfer Tax.
35Sales Price or Transfer Tax rounded by county prior to computation.
36Sold for Taxes.
37Transfer Tax on document indicated as EXEMPT.
38Sales price computed from Transfer Tax.
39From recorded Affidavit of Value or Verified.
40Sales Price from Excise Tax Rate (WA only )
41Price/Transfer Tax not public record.
42Document states price as "0", "None", "No Consideration".
43Estimated Sales Price
44Assessor Qualified Sale (Not used for comps)
SEWER5 codes
CODEDESCRIPTION
1Municipal
2None
3Storm
4Septic
5Yes
STORIES124 codes
CODEDESCRIPTION
1001 Story
1251.25 Stories
1501.5 Stories
1751.75 Stories
2002 Stories
2252.25 Stories
2502.5 Stories
2752.75 Stories
3003 Stories
3253.25 Stories
3503.5 Stories
3753.75 Stories
4004 Stories
4254.25 Stories
4504.5 Stories
4754.75 Stories
5005 Stories
5255.25 Stories
5505.5 Stories
5755.75 Stories
6006 Stories
6506.5 Stories
7007 Stories
7507.5 Stories
8008 Stories
8508.5 Stories
9009 Stories
9509.5 Stories
100010 Stories
110011 Stories
120012 Stories
130013 Stories
140014 Stories
150015 Stories
160016 Stories
170017 Stories
180018 Stories
190019 Stories
200020 Stories
210021 Stories
220022 Stories
230023 Stories
240024 Stories
250025 Stories
260026 Stories
270027 Stories
280028 Stories
290029 Stories
300030 Stories
310031 Stories
320032 Stories
330033 Stories
340034 Stories
350035 Stories
360036 Stories
370037 Stories
380038 Stories
390039 Stories
400040 Stories
410041 Stories
420042 Stories
430043 Stories
440044 Stories
450045 Stories
460046 Stories
470047 Stories
480048 Stories
490049 Stories
500050 Stories
510051 Stories
520052 Stories
530053 Stories
540054 Stories
550055 Stories
560056 Stories
570057 Stories
580058 Stories
590059 Stories
600060 Stories
610061 Stories
620062 Stories
630063 Stories
640064 Stories
650065 Stories
660066 Stories
670067 Stories
680068 Stories
690069 Stories
700070 Stories
710071 Stories
720072 Stories
730073 Stories
740074 Stories
750075 Stories
760076 Stories
770077 Stories
780078 Stories
790079 Stories
800080 Stories
810081 Stories
820082 Stories
830083 Stories
840084 Stories
850085 Stories
870087 Stories
880088 Stories
890089 Stories
900090 Stories
910091 Stories
920092 Stories
930093 Stories
940094 Stories
950095 Stories
960096 Stories
970097 Stories
980098 Stories
990099 Stories
10000100 Stories
10400104 Stories
10500105 Stories
11200112 Stories
11400114 Stories
11900119 Stories
12500125 Stories
STYLE65 codes
CODEDESCRIPTION
1TRADITIONAL/OLD
2A-FRAME
3BUNGALOW
4CAPE COD
5COLONIAL
6ENGLISH
7FRENCH PROVINCIAL
8GEORGIAN
9HIGH-RISE
10MODERN
11RANCH\RAMBLER
12SPANISH
13TUDOR
14MEDITERRANEAN
15CONVENTIONAL
16OTHER
17PREFAB, MODULAR
18MANSION
19RAISED RANCH
20DOME
21CONTEMPORARY
22UNFINISHED\UNDER CONSTRUCTION
23VICTORIAN
24COTTAGE
25CUSTOM
26LOG CABIN/RUSTIC
27HISTORICAL
28UNKNOWN
29CONDO
30CLUSTER
31DUPLEX
32QUADPLEX
33MOBILE HOME
34MULTIFAMILY
35TOWNHOUSE
36TRIPLEX
37PATIO HOME
38ROW HOME
39TRI-LEVEL
40BI-LEVEL
41SPLIT LEVEL
42SPLIT FOYER
43TINY HOUSE
44EUROPEAN
45MOBILE/MANUFACTURED
46SHOTGUN
47BAMBOO
48BYPASS
49CENTER HALL
50CHALET/ALPINE
51COACH/CARRIAGE HOUSE
52EUROPEAN
53FEDERALIST
54GARAGE APARTMENT
55GREEK REVIVAL
56H-SHAPE
57LOW RISE
58L-SHAPE
59MISSION
60MULTI-LEVEL
61MID RISE
62NEW ENGLAND
63OLD
64SALT BOX
65UNDERGROUND/BERM
TOPOGRAPHY15 codes
CODEDESCRIPTION
AAbove street level
BBelow street level
ELevel grade
HHigh elevation
IHILLY
LLow Elevation
MMOUNTAIN
OROCKY
PSWAMPY
QMARSH
RROLLING
SSTEEP
WWOODED
XMIXED
YBRUSHY
WATER7 codes
CODEDESCRIPTION
1Cistern
2Municipal
3None
4Spring
5Well
6Yes
7Private