Provides aggregated mortgage and property summary metrics that combine related loan and property signals into a condensed view for analysis.
Mortgage Property Aggregate
| Field Name | Description | Data Type |
|---|---|---|
| Property identification | ||
| CID | Unique property identifier / composite ID. Example: '060004759687' |
string |
| CountyFipsCode | Federal Information Processing Standard code for the county. Example: '06107' |
string |
| ParcelNumber | Assessor's parcel number for the property. Example: '219-190-001-000' |
string |
| PropertyType | General classification of the property (e.g., Residential, Commercial). Example: 'Residential' |
string |
| PropertySubType | More granular property classification. Example: 'Single Family Residence' |
string |
| Property address | ||
| UnparsedAddress | Full street address in a single string. Example: '38641 BALCH PARK RD' |
string |
| UnitType | Type of unit (e.g., Apt, Suite, Unit). Example: NULL |
string |
| UnitNumber | Unit or apartment number. Example: NULL |
string |
| City | City where the property is located. Example: 'SPRINGVILLE' |
string |
| StateOrProvince | Two-letter state or province abbreviation. Example: 'CA' |
string |
| PostalCode | Five-digit ZIP / postal code. Example: '93265' |
string |
| PostalCodePlus4 | Four-digit ZIP+4 extension. Example: '9763' |
string |
| StreetNumber | Numeric portion of the street address. Example: '38641' |
string |
| StreetDirPrefix | Directional prefix of the street (e.g., N, S, E, W). Example: NULL |
string |
| StreetName | Name of the street. Example: 'BALCH PARK' |
string |
| StreetSuffix | Street suffix type (e.g., Road, Ave, Blvd). Example: 'Road' |
string |
| StreetDirSuffix | Directional suffix of the street. Example: NULL |
string |
| CarrierRoute | USPS carrier route code. Example: 'H002' |
string |
| CountyOrParish | Name of the county or parish. Example: 'Tulare' |
string |
| Geographic coordinates | ||
| Latitude | Geographic latitude of the property. Example: 36.17432000 |
number |
| Longitude | Geographic longitude of the property. Example: -118.79834900 |
number |
| LatLongPrecision | Precision level of the geocoded coordinates. Example: 'Street' |
string |
| CensusTract | Census tract identifier for the property location. Example: '061070027.011033' |
string |
| Property characteristics | ||
| NumberOfUnitsTotal | Total number of units in the property. Example: 0 |
number |
| OccupantType | Indicates who occupies the property (Owner, Tenant, Vacant). Example: 'Owner' |
string |
| YearBuilt | Year the structure was originally built. Example: 1978 |
number |
| Tax & valuation | ||
| TaxAssessedYear | Year of the most recent tax assessment. Example: 2025 |
number |
| TaxAssessedValue | Assessed value for tax purposes (in USD). Example: 255839 |
number |
| MarketValueYear | Year of the most recent market valuation. Example: NULL |
number |
| MarketValue | Estimated market value of the property (in USD). Example: 0 |
number |
| Sale information | ||
| SalesPrice | Recorded sale price of the property (in USD). Example: NULL |
number |
| SalesPriceCode | Qualifier for the sales price (e.g., exact, estimated, county rounded). Example: 'County Rounded' |
string |
| TitleCompanyName | Name of the title company that handled the transaction. Example: 'FIRST AMERICAN TITLE COMPANY' |
string |
| SaleRecordingDate | Date the sale was officially recorded. Example: NULL |
date |
| IntraFamilyYn | Indicates if the transaction was between family members. Example: FALSE |
boolean |
| CashPurchaseYn | Indicates if the property was purchased with cash (no mortgage). Example: FALSE |
boolean |
| DistressedSaleYn | Indicates if the sale was a distressed sale (foreclosure, short sale). Example: FALSE |
boolean |
| Buyer information | ||
| BuyerFnameMname1 | First/middle name of the primary buyer. Example: NULL |
string |
| BuyerLnameOrCorpName1 | Last name or corporate name of the primary buyer. Example: NULL |
string |
| BuyerType1 | Entity type of the primary buyer (Individual, Corporation, Trust, etc.). Example: NULL |
string |
| BuyerFnameMname2 | First/middle name of the secondary buyer. Example: NULL |
string |
| BuyerLnameOrCorpName2 | Last name or corporate name of the secondary buyer. Example: NULL |
string |
| Seller information | ||
| SellerFnameMname1 | First/middle name of the primary seller. Example: NULL |
string |
| SellerLnameOrCorpName1 | Last name or corporate name of the primary seller. Example: NULL |
string |
| SellerType1 | Entity type of the primary seller. Example: NULL |
string |
| SellerFnameMname2 | First/middle name of the secondary seller. Example: NULL |
string |
| SellerLnameOrCorpName2 | Last name or corporate name of the secondary seller. Example: NULL |
string |
| SellerType2 | Entity type of the secondary seller. Example: NULL |
string |
| Mortgage flags | ||
| ResidentialYn | Indicates if the mortgage is for a residential property. Example: TRUE |
boolean |
| ConstructionLoanYn | Indicates if the mortgage is a construction loan. Example: FALSE |
boolean |
| StandaloneYn | Indicates if this is a standalone mortgage (not linked to a sale). Example: FALSE |
boolean |
| EquityCreditLineYn | Indicates if the mortgage is a home equity line of credit (HELOC). Example: FALSE |
boolean |
| PurchaseMoneyMortgageYn | Indicates if the mortgage was used to purchase the property. Example: FALSE |
boolean |
| Mortgage details | ||
| MortgageDocumentNumber | Recording document number for the mortgage. Example: '2011-0049532' |
string |
| MortgageRecordingDate | Date the mortgage was officially recorded. Example: '2011-08-25' |
date |
| LoanAmount | Original loan amount (in USD). Example: 182000 |
number |
| LoanTermMonths | Duration of the loan in months. Example: '360' |
string |
| DueDate | Maturity / due date of the loan. Example: '2041-09-01' |
date |
| LoanType | Type of loan (e.g., Conventional, FHA, VA). Example: 'Conventional' |
string |
| TypeFinancing | Financing type description. Example: NULL |
string |
| InterestRate | Interest rate on the mortgage (percentage). Example: 4.5 |
number |
| PrepaymentRider | Indicates if a prepayment rider exists on the loan. Example: NULL |
string |
| PrepaymentTermPenaltyRider | Term or penalty details for prepayment. Example: NULL |
string |
| OriginalDateOfContract | Date the original mortgage contract was signed. Example: '2011-08-13' |
date |
| Borrower information | ||
| BorrowerFnameMname1 | First/middle name of the primary borrower. Example: 'MARGARET E' |
string |
| BorrowerLnameOrCorpName1 | Last name or corporate name of the primary borrower. Example: 'WILSON' |
string |
| BorrowerFnameMname2 | First/middle name of the secondary borrower. Example: NULL |
string |
| BorrowerLnameOrCorpName2 | Last name or corporate name of the secondary borrower. Example: 'MARGARET E WILSON LIVING TRUST' |
string |
| BorrowerVestingCode | Vesting code describing how the borrower holds title. Example: 'Living Trust' |
string |
| Lender information | ||
| LenderNameBeneficiary | Name of the lender or beneficiary. Example: 'JPMORGAN CHASE BANK NA' |
string |
| LenderDbaName | Lender's "doing business as" name. Example: NULL |
string |
| LenderType | Type of lending institution (Bank, Credit Union, etc.). Example: 'Bank' |
string |
| LenderMailPostalCode | Postal code of the lender's mailing address. Example: '43240' |
string |
| LoanOfficerNmlsId | NMLS ID of the loan officer. Example: NULL |
string |
| MortgageBrokerNmlsId | NMLS ID of the mortgage broker. Example: NULL |
string |
| LoanCompanyNmlsId | NMLS ID of the loan company. Example: NULL |
string |
| Loan purpose & metadata | ||
| LoanPurpose | Purpose of the loan (e.g., Purchase, Refinance). Example: NULL |
string |
| MortgageTransactionId | Unique identifier for the mortgage transaction. Example: '229475706' |
string |
| Orphan | Indicates if this mortgage record has no matching sale/property record. Example: FALSE |
boolean |
| ModificationTimestamp | Timestamp of the last modification to this record. Example: '2026-03-19 17:55:21.226' |
date-time |