Provides delete-history records that identify when assessor, deed, mortgage, assignment, release, pre-foreclosure, base properties, mortgage property aggregate, sales and transfer, and loan records were removed from the live datasets.
Assessor Delete History
OData endpoint: https://insights.cdatalabs.com/odata/AssessorDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| RecordId | Record Id. | string |
Deed Delete History
OData endpoint: https://insights.cdatalabs.com/odata/DeedDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |
Mortgage Delete History
OData endpoint: https://insights.cdatalabs.com/odata/MortgageDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |
Assignment Delete History
OData endpoint: https://insights.cdatalabs.com/odata/AssignmentDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| TransactionId | Transaction Id. | string |
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
Release Delete History
OData endpoint: https://insights.cdatalabs.com/odata/ReleaseDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |
PreForeclosure Delete History
OData endpoint: https://insights.cdatalabs.com/odata/PreForeclosureDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| RecordDeleteDate | Record Delete Date. | date-time |
| TransactionId | Transaction Id. | string |
Base Properties Delete History
OData endpoint: https://insights.cdatalabs.com/odata/BasePropertiesDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| CID | CID. | string |
| DeletedDate | Deleted Date. | date-time |
Mortgage Property Aggregate Delete History
OData endpoint: https://insights.cdatalabs.com/odata/MortgagePropertyAggregateDeleteHistory
Audit records for rows removed from the live Mortgage Property Aggregate dataset.
| Field Name | Description | Data Type |
|---|---|---|
| DeleteReason | Reason the row was removed. | string |
| DeletedAt | Timestamp when the row was archived. | date-time |
| CID | Constellation identifier; null for unmatched orphan rows. | string |
| MortgageTransactionID | Transaction identifier of the deleted row. | string |
| NewMortgageTransactionID | Resolved transaction identifier when an orphan was matched. | string |
| ParcelNumber | Assessor parcel number. | string |
| CountyFipsCode | Five-digit county FIPS code. | string |
| CountyOrParish | County or parish name. | string |
| UnparsedAddress | Full property street address received from the source. | string |
| City | Property city. | string |
| State | Two-letter state code. | string |
| MortgageRecordingDate | Date the mortgage was recorded. | date-time |
| MortgageDocumentNumber | Document number assigned at recording. | string |
| OriginalDateOfContract | Date the mortgage contract was originally signed. | date-time |
Sales And Transfer Delete History
OData endpoint: https://insights.cdatalabs.com/odata/SalesAndTransferDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| Cdltransactionid | Cdltransactionid. | string |
| DeletedDate | Deleted Date. | date-time |
Loan Delete History
OData endpoint: https://insights.cdatalabs.com/odata/LoanDeleteHistory
| Field Name | Description | Data Type |
|---|---|---|
| LoanId | Loan Id. | string |
| DeletedDate | Deleted Date. | date-time |