Constellation Data LabsDocs

Loan Analytics data dictionary

Last updated

Loan Analytics

OData endpoint: https://insights.cdatalabs.com/odata/LoanAnalytics

Date fields (Loan1RecordingDate, Loan2RecordingDate, Loan3RecordingDate and EstimationDate) are returned as yyyyMMdd strings, for example '20240315'. Amounts are in USD.

Field Name Description Data Type
Property identification
CID Unique property identifier (Constellation ID).

Example:
'530000637006'
string
CountyFipsCode Federal Information Processing Standard code for the county. First 2 digits = state, last 3 digits = county.

Example:
'53011'
string
ParcelNumber Assessor's parcel number for the property.

Example:
'063472-160'
string
Property address
UnparsedAddress Full street address in a single string.

Example:
'1512 W B AVE'
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:
'LA CENTER'
string
StateOrProvince Two-letter state or province abbreviation.

Example:
'WA'
string
PostalCode Five-digit ZIP / postal code.

Example:
'98629'
string
PostalCodePlus4 Four-digit ZIP+4 extension.

Example:
'9519'
string
Country Country code.

Example:
'US'
string
StreetNumber Numeric portion of the street address.

Example:
'1512'
string
StreetDirPrefix Directional prefix of the street (e.g., N, S, E, W).

Example:
'W'
string
StreetName Name of the street.

Example:
'B'
string
StreetSuffix Street suffix type (e.g., Road, Avenue, Boulevard).

Example:
'Avenue'
string
StreetDirSuffix Directional suffix of the street.

Example:
NULL
string
CarrierRoute USPS carrier route code.

Example:
'R005'
string
CountyOrParish Name of the county or parish.

Example:
'Clark County'
string
Borrower names
BorrowerName1 Full name of the primary borrower.

Example:
'ARLENE A ARNOLD'
string
BorrowerFNameMName1 First/middle name of the primary borrower.

Example:
'ARLENE A'
string
BorrowerLNameOrCorpName1 Last name or corporate name of the primary borrower.

Example:
'ARNOLD'
string
BorrowerName2 Full name of the secondary borrower.

Example:
NULL
string
BorrowerFNameMName2 First/middle name of the secondary borrower.

Example:
NULL
string
BorrowerLNameOrCorpName2 Last name or corporate name of the secondary borrower.

Example:
NULL
string
BorrowerVestingCode Vesting code describing how the borrowers hold title.

Example:
'Living Trust'
string
Borrower mailing address
OwnerMailUnparsedAddress Full mailing street address in a single string.

Example:
'1512 W B AVE'
string
OwnerMailUnitType Mailing address unit type.

Example:
NULL
string
OwnerMailUnitNumber Mailing address unit number.

Example:
NULL
string
OwnerMailCity Mailing address city.

Example:
'LA CENTER'
string
OwnerMailStateOrProvince Mailing address two-letter state or province abbreviation.

Example:
'WA'
string
OwnerMailPostalCode Mailing address five-digit ZIP / postal code.

Example:
'98629'
string
OwnerMailPostalCodePlus4 Mailing address four-digit ZIP+4 extension.

Example:
'9519'
string
OccupantType Indicates who occupies the property (Owner, Tenant, Vacant).

Example:
'Owner'
string
Open loan totals
LoanAmountTotal Total original amount of the open loans on the property (in USD).

Example:
0.0
number
EstimatedPrincipalPaid Estimated principal paid across the open loans (in USD).

Example:
NULL
number
EstimatedPrincipalOutstanding Estimated principal still outstanding across the open loans (in USD).

Example:
NULL
number
Open loan 1
Loan1TransactionId Unique identifier of the mortgage transaction for open loan 1.

Example:
NULL
string
Loan1LoanPurpose Purpose of open loan 1 (e.g., Purchase, Refinance).

Example:
NULL
string
Loan1RecordingDate Date open loan 1 was recorded (yyyyMMdd).

Example:
NULL
date
Loan1Amount Original amount of open loan 1 (in USD).

Example:
NULL
number
Loan1EstimatedPrincipalPaid Estimated principal paid on open loan 1 (in USD).

Example:
NULL
number
Loan1EstimatedPrincipalOutstanding Estimated principal outstanding on open loan 1 (in USD).

Example:
NULL
number
Loan1MultiPropertyTransferId Identifier shared by loans recorded against several properties in one transaction.

Example:
NULL
string
Open loan 2
Loan2TransactionId Unique identifier of the mortgage transaction for open loan 2.

Example:
NULL
string
Loan2LoanPurpose Purpose of open loan 2 (e.g., Purchase, Refinance).

Example:
NULL
string
Loan2RecordingDate Date open loan 2 was recorded (yyyyMMdd).

Example:
NULL
date
Loan2Amount Original amount of open loan 2 (in USD).

Example:
NULL
number
Loan2EstimatedPrincipalPaid Estimated principal paid on open loan 2 (in USD).

Example:
NULL
number
Loan2EstimatedPrincipalOutstanding Estimated principal outstanding on open loan 2 (in USD).

Example:
NULL
number
Loan2MultiPropertyTransferId Identifier shared by loans recorded against several properties in one transaction.

Example:
NULL
string
Open loan 3
Loan3TransactionId Unique identifier of the mortgage transaction for open loan 3.

Example:
NULL
string
Loan3LoanPurpose Purpose of open loan 3 (e.g., Purchase, Refinance).

Example:
NULL
string
Loan3RecordingDate Date open loan 3 was recorded (yyyyMMdd).

Example:
NULL
date
Loan3Amount Original amount of open loan 3 (in USD).

Example:
NULL
number
Loan3EstimatedPrincipalPaid Estimated principal paid on open loan 3 (in USD).

Example:
NULL
number
Loan3EstimatedPrincipalOutstanding Estimated principal outstanding on open loan 3 (in USD).

Example:
NULL
number
Loan3MultiPropertyTransferId Identifier shared by loans recorded against several properties in one transaction.

Example:
NULL
string
Automated valuation model
EstimatedValue The derived valuation for the property (in USD).

Example:
NULL
number
PriceRangeMin Low limit of the valuation range (in USD).

Example:
NULL
number
PriceRangeMax High limit of the valuation range (in USD).

Example:
NULL
number
ConfidenceScore 100 - FSD score. Higher values mean a more reliable estimate.

Example:
NULL
integer
FSD Forecasted Standard Deviation. If the FSD is 10, there is a 68% (one standard deviation) probability that the actual market value falls within +/-10% of the estimated value.

Example:
NULL
number
EstimationDate Date the valuation was created (yyyyMMdd).

Example:
NULL
date
Equity & loan-to-value
EstimatedEquity Estimated equity in the property: estimated value less estimated principal outstanding (in USD).

Example:
NULL
number
EstimatedEquityLow Low end of the estimated equity range (in USD).

Example:
NULL
number
EstimatedEquityHigh High end of the estimated equity range (in USD).

Example:
NULL
number
EstimatedLTV Estimated loan-to-value ratio: estimated principal outstanding compared to estimated value.

Example:
NULL
number
EstimatedLTVLow Low end of the estimated loan-to-value range.

Example:
NULL
number
EstimatedLTVHigh High end of the estimated loan-to-value range.

Example:
NULL
number
Metadata
ModificationTimestamp Timestamp of the last modification to this record.

Example:
'2026-11-12T13:36:50+00:00'
date-time

Sample Request

GET https://insights.cdatalabs.com/odata/LoanAnalytics?$filter=CID eq '530000637006'

Sample Response

{
  "CID": "530000637006",
  "CountyFipsCode": "53011",
  "ParcelNumber": "063472-160",
  "UnparsedAddress": "1512 W B AVE",
  "UnitType": null,
  "UnitNumber": null,
  "City": "LA CENTER",
  "StateOrProvince": "WA",
  "PostalCode": "98629",
  "PostalCodePlus4": "9519",
  "Country": "US",
  "StreetNumber": "1512",
  "StreetDirPrefix": "W",
  "StreetName": "B",
  "StreetSuffix": "Avenue",
  "StreetDirSuffix": null,
  "CarrierRoute": "R005",
  "CountyOrParish": "Clark County",
  "BorrowerName1": "ARLENE A ARNOLD",
  "BorrowerFNameMName1": "ARLENE A",
  "BorrowerLNameOrCorpName1": "ARNOLD",
  "BorrowerName2": null,
  "BorrowerFNameMName2": null,
  "BorrowerLNameOrCorpName2": null,
  "BorrowerVestingCode": null,
  "OwnerMailUnparsedAddress": "1512 W B AVE",
  "OwnerMailUnitType": null,
  "OwnerMailUnitNumber": null,
  "OwnerMailCity": "LA CENTER",
  "OwnerMailStateOrProvince": "WA",
  "OwnerMailPostalCode": "98629",
  "OwnerMailPostalCodePlus4": "9519",
  "OccupantType": null,
  "LoanAmountTotal": 0.0,
  "EstimatedPrincipalPaid": null,
  "EstimatedPrincipalOutstanding": null,
  "Loan1TransactionId": null,
  "Loan1LoanPurpose": null,
  "Loan1RecordingDate": null,
  "Loan1Amount": null,
  "Loan1EstimatedPrincipalPaid": null,
  "Loan1EstimatedPrincipalOutstanding": null,
  "Loan1MultiPropertyTransferId": null,
  "Loan2TransactionId": null,
  "Loan2LoanPurpose": null,
  "Loan2RecordingDate": null,
  "Loan2Amount": null,
  "Loan2EstimatedPrincipalPaid": null,
  "Loan2EstimatedPrincipalOutstanding": null,
  "Loan2MultiPropertyTransferId": null,
  "Loan3TransactionId": null,
  "Loan3LoanPurpose": null,
  "Loan3RecordingDate": null,
  "Loan3Amount": null,
  "Loan3EstimatedPrincipalPaid": null,
  "Loan3EstimatedPrincipalOutstanding": null,
  "Loan3MultiPropertyTransferId": null,
  "EstimatedValue": null,
  "PriceRangeMin": null,
  "PriceRangeMax": null,
  "ConfidenceScore": null,
  "FSD": null,
  "EstimationDate": null,
  "EstimatedEquity": null,
  "EstimatedEquityLow": null,
  "EstimatedEquityHigh": null,
  "EstimatedLTV": null,
  "EstimatedLTVLow": null,
  "EstimatedLTVHigh": null,
  "ModificationTimestamp": "2026-11-12T13:36:50+00:00"
}
Full Detail information Confidential. Not for Distribution.