Skip to Content
InsightsDictionariesMortgage Property Aggregate

Mortgage Property Aggregate

Provides aggregated mortgage and property summary metrics that combine related loan and property signals into a condensed view for analysis.

Mortgage Property Aggregate

Field NameDescriptionData Type
Property identification
CIDUnique property identifier / composite ID.
Example:‘060004759687’		string
CountyFipsCodeFederal Information Processing Standard code for the county.
Example:‘06107’		string
ParcelNumberAssessor’s parcel number for the property.
Example:‘219-190-001-000’		string
PropertyTypeGeneral classification of the property (e.g., Residential, Commercial).
Example:‘Residential’		string
PropertySubTypeMore granular property classification.
Example:‘Single Family Residence’		string
Property address
UnparsedAddressFull street address in a single string.
Example:‘38641 BALCH PARK RD’		string
UnitTypeType of unit (e.g., Apt, Suite, Unit).
**Example:**NULL		string
UnitNumberUnit or apartment number.
**Example:**NULL		string
CityCity where the property is located.
Example:‘SPRINGVILLE’		string
StateOrProvinceTwo-letter state or province abbreviation.
Example:‘CA’		string
PostalCodeFive-digit ZIP / postal code.
Example:‘93265’		string
PostalCodePlus4Four-digit ZIP+4 extension.
Example:‘9763’		string
StreetNumberNumeric portion of the street address.
Example:‘38641’		string
StreetDirPrefixDirectional prefix of the street (e.g., N, S, E, W).
**Example:**NULL		string
StreetNameName of the street.
Example:‘BALCH PARK’		string
StreetSuffixStreet suffix type (e.g., Road, Ave, Blvd).
Example:‘Road’		string
StreetDirSuffixDirectional suffix of the street.
**Example:**NULL		string
CarrierRouteUSPS carrier route code.
Example:‘H002’		string
CountyOrParishName of the county or parish.
Example:‘Tulare’		string
Geographic coordinates
LatitudeGeographic latitude of the property.
**Example:**36.17432000		number
LongitudeGeographic longitude of the property.
Example:-118.79834900		number
LatLongPrecisionPrecision level of the geocoded coordinates.
Example:‘Street’		string
CensusTractCensus tract identifier for the property location.
Example:‘061070027.011033’		string
Property characteristics
NumberOfUnitsTotalTotal number of units in the property.
**Example:**0		number
OccupantTypeIndicates who occupies the property (Owner, Tenant, Vacant).
Example:‘Owner’		string
YearBuiltYear the structure was originally built.
**Example:**1978		number
Tax & valuation
TaxAssessedYearYear of the most recent tax assessment.
**Example:**2025		number
TaxAssessedValueAssessed value for tax purposes (in USD).
**Example:**255839		number
MarketValueYearYear of the most recent market valuation.
**Example:**NULL		number
MarketValueEstimated market value of the property (in USD).
**Example:**0		number
Sale information
SalesPriceRecorded sale price of the property (in USD).
**Example:**NULL		number
SalesPriceCodeQualifier for the sales price (e.g., exact, estimated, county rounded).
Example:‘County Rounded’		string
TitleCompanyNameName of the title company that handled the transaction.
Example:‘FIRST AMERICAN TITLE COMPANY’		string
SaleRecordingDateDate the sale was officially recorded.
**Example:**NULL		date
IntraFamilyYnIndicates if the transaction was between family members.
**Example:**FALSE		boolean
CashPurchaseYnIndicates if the property was purchased with cash (no mortgage).
**Example:**FALSE		boolean
DistressedSaleYnIndicates if the sale was a distressed sale (foreclosure, short sale).
**Example:**FALSE		boolean
Buyer information
BuyerFnameMname1First/middle name of the primary buyer.
**Example:**NULL		string
BuyerLnameOrCorpName1Last name or corporate name of the primary buyer.
**Example:**NULL		string
BuyerType1Entity type of the primary buyer (Individual, Corporation, Trust, etc.).
**Example:**NULL		string
BuyerFnameMname2First/middle name of the secondary buyer.
**Example:**NULL		string
BuyerLnameOrCorpName2Last name or corporate name of the secondary buyer.
**Example:**NULL		string
Seller information
SellerFnameMname1First/middle name of the primary seller.
**Example:**NULL		string
SellerLnameOrCorpName1Last name or corporate name of the primary seller.
**Example:**NULL		string
SellerType1Entity type of the primary seller.
**Example:**NULL		string
SellerFnameMname2First/middle name of the secondary seller.
**Example:**NULL		string
SellerLnameOrCorpName2Last name or corporate name of the secondary seller.
**Example:**NULL		string
SellerType2Entity type of the secondary seller.
**Example:**NULL		string
Mortgage flags
ResidentialYnIndicates if the mortgage is for a residential property.
**Example:**TRUE		boolean
ConstructionLoanYnIndicates if the mortgage is a construction loan.
**Example:**FALSE		boolean
StandaloneYnIndicates if this is a standalone mortgage (not linked to a sale).
**Example:**FALSE		boolean
EquityCreditLineYnIndicates if the mortgage is a home equity line of credit (HELOC).
**Example:**FALSE		boolean
PurchaseMoneyMortgageYnIndicates if the mortgage was used to purchase the property.
**Example:**FALSE		boolean
Mortgage details
MortgageDocumentNumberRecording document number for the mortgage.
Example:‘2011-0049532’		string
MortgageRecordingDateDate the mortgage was officially recorded.
Example:‘2011-08-25’		date
LoanAmountOriginal loan amount (in USD).
**Example:**182000		number
LoanTermMonthsDuration of the loan in months.
Example:‘360’		string
DueDateMaturity / due date of the loan.
Example:‘2041-09-01’		date
LoanTypeType of loan (e.g., Conventional, FHA, VA).
Example:‘Conventional’		string
TypeFinancingFinancing type description.
**Example:**NULL		string
InterestRateInterest rate on the mortgage (percentage).
**Example:**4.5		number
PrepaymentRiderIndicates if a prepayment rider exists on the loan.
**Example:**NULL		string
PrepaymentTermPenaltyRiderTerm or penalty details for prepayment.
**Example:**NULL		string
OriginalDateOfContractDate the original mortgage contract was signed.
Example:‘2011-08-13’		date
Borrower information
BorrowerFnameMname1First/middle name of the primary borrower.
Example:‘MARGARET E’		string
BorrowerLnameOrCorpName1Last name or corporate name of the primary borrower.
Example:‘WILSON’		string
BorrowerFnameMname2First/middle name of the secondary borrower.
**Example:**NULL		string
BorrowerLnameOrCorpName2Last name or corporate name of the secondary borrower.
Example:‘MARGARET E WILSON LIVING TRUST’		string
BorrowerVestingCodeVesting code describing how the borrower holds title.
Example:‘Living Trust’		string
Lender information
LenderNameBeneficiaryName of the lender or beneficiary.
Example:‘JPMORGAN CHASE BANK NA’		string
LenderDbaNameLender’s “doing business as” name.
**Example:**NULL		string
LenderTypeType of lending institution (Bank, Credit Union, etc.).
Example:‘Bank’		string
LenderMailPostalCodePostal code of the lender’s mailing address.
Example:‘43240’		string
LoanOfficerNmlsIdNMLS ID of the loan officer.
**Example:**NULL		string
MortgageBrokerNmlsIdNMLS ID of the mortgage broker.
**Example:**NULL		string
LoanCompanyNmlsIdNMLS ID of the loan company.
**Example:**NULL		string
Loan purpose & metadata
LoanPurposePurpose of the loan (e.g., Purchase, Refinance).
**Example:**NULL		string
MortgageTransactionIdUnique identifier for the mortgage transaction.
Example:‘229475706’		string
OrphanIndicates if this mortgage record has no matching sale/property record.
**Example:**FALSE		boolean
ModificationTimestampTimestamp of the last modification to this record.
Example:‘2026-03-19 17:55:21.226’		date-time

Mortgage Property Aggregate Delete History

Delete history is an audit trail of rows that were removed from the live Mortgage Property Aggregate dataset. It is useful when you need to explain why a mortgage or property row no longer appears in the current aggregate, reconcile downstream systems after cleanup jobs, or investigate orphan records that were later matched and resolved.

How to use it

  • Access: Query the delete-history entity exposed for this product in OData $metadata (entity set name may appear as MortgagePropertyAggregateDeleteHistory or similar). Use the same host and Authorization: Bearer pattern as other Insights entities.
  • Look up by property: Filter on CID, ParcelNumber, CountyFipsCode
  • Look up by transaction: Filter on MortgageTransactionID when you still have the old transaction id (including values prefixed with ORPHAN_).
  • Time windows: Filter on DeletedAt
  • Reason codes: Use DeleteReason to narrow results-for example ORPHAN_RESOLVED when an orphan was linked to a real aggregate row NewMortgageTransactionID NMLS_DELETED or MORTGAGE_DELETED when upstream source data was dropped or superseded.

Example Request:

GET https://insights.cdatalabs.com/odata/MortgagePropertyAggregateDeleteHistory?$filter=CID eq '060004759687'&$orderby=DeletedAt desc&$top=50
Field NameDescriptionData Type
DeleteReasonWhy the row was removed.
Example:
ORPHAN_RESOLVED, NMLS_DELETED, MORTGAGE_DELETED		string
DeletedAtTimestamp when the row was archived by cleanup macro.
Example:
2026-04-03 15:05:26		date-time
CIDCID. Null for orphan rows (no matched CID).
Example:
470003122185		string
MortgageTransactionIDTransaction ID of the deleted row. Orphans carry an ORPHAN_ prefix.
Example:
ORPHAN_673a54eddbb5ed30…		string
NewMortgageTransactionIDORPHAN_RESOLVED only: links to the resolved record in the live aggregate. Null otherwise.
Example:
502085186		string
ParcelNumberAssessor Parcel Number (APN). Null for orphans when missing APN is why they were orphaned.
Example:
113 06200		string
CountyFipsCode5-digit county FIPS code.
Example:
47013		string
CountyOrParishCounty name.
Example:
Campbell		string
UnparsedAddressFull property street address as received from source.
Example:
131 E DOGWOOD TRL		string
CityProperty city.
Example:
LA FOLLETTE		string
State2-letter state code.
Example:
TN		string
MortgageRecordingDateDate the mortgage was recorded with the county recorder.
Example:
2024-10-31 00:00:00		date-time
MortgageDocumentNumberRecorder document number assigned by the county at recording.
Example:
24005257		string
OriginalDateOfContractDate the mortgage contract was originally signed, prior to recording.
Example:
2024-10-29 00:00:00		date-time

Full Detail information Confidential. Not for Distribution.

BoundariesBase Properties