History Aggregates

Provides historical aggregate views for AVM, sales and transfer, assessor, and mortgage activity to support trend and change analysis over time.

AVM History Aggregate

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

Field Name	Description	Data Type
CID	CID.	string
CountyFipsCode	County Fips Code.	string
ParcelNumber	Parcel Number.	string
UnparsedAddress	Unparsed Address.	string
UnitType	Unit Type.	string
UnitNumber	Unit Number.	string
City	City.	string
StateOrProvince	State Or Province.	string
PostalCode	Postal Code.	string
PostalCodePlus4	Postal Code Plus4.	string
Country	Country.	string
StreetNumber	Street Number.	string
StreetDirPrefix	Street Dir Prefix.	string
StreetName	Street Name.	string
StreetSuffix	Street Suffix.	string
StreetDirSuffix	Street Dir Suffix.	string
CarrierRoute	Carrier Route.	string
CountyOrParish	County Or Parish.	string
AvmYear	Avm Year.	number
AvmLow01	Avm Low01.	number
AvmHigh01	Avm High01.	number
AvmValue01	Avm Value01.	number
ConfidenceScore01	Confidence Score01.	number
MomPercentChange01	Mom Percent Change01.	number
AvmLow02	Avm Low02.	number
AvmHigh02	Avm High02.	number
AvmValue02	Avm Value02.	number
ConfidenceScore02	Confidence Score02.	number
MomPercentChange02	Mom Percent Change02.	number
AvmLow03	Avm Low03.	number
AvmHigh03	Avm High03.	number
AvmValue03	Avm Value03.	number
ConfidenceScore03	Confidence Score03.	number
MomPercentChange03	Mom Percent Change03.	number
AvmLow04	Avm Low04.	number
AvmHigh04	Avm High04.	number
AvmValue04	Avm Value04.	number
ConfidenceScore04	Confidence Score04.	number
MomPercentChange04	Mom Percent Change04.	number
AvmLow05	Avm Low05.	number
AvmHigh05	Avm High05.	number
AvmValue05	Avm Value05.	number
ConfidenceScore05	Confidence Score05.	number
MomPercentChange05	Mom Percent Change05.	number
AvmLow06	Avm Low06.	number
AvmHigh06	Avm High06.	number
AvmValue06	Avm Value06.	number
ConfidenceScore06	Confidence Score06.	number
MomPercentChange06	Mom Percent Change06.	number
AvmLow07	Avm Low07.	number
AvmHigh07	Avm High07.	number
AvmValue07	Avm Value07.	number
ConfidenceScore07	Confidence Score07.	number
MomPercentChange07	Mom Percent Change07.	number
AvmLow08	Avm Low08.	number
AvmHigh08	Avm High08.	number
AvmValue08	Avm Value08.	number
ConfidenceScore08	Confidence Score08.	number
MomPercentChange08	Mom Percent Change08.	number
AvmLow09	Avm Low09.	number
AvmHigh09	Avm High09.	number
AvmValue09	Avm Value09.	number
ConfidenceScore09	Confidence Score09.	number
MomPercentChange09	Mom Percent Change09.	number
AvmLow10	Avm Low10.	number
AvmHigh10	Avm High10.	number
AvmValue10	Avm Value10.	number
ConfidenceScore10	Confidence Score10.	number
MomPercentChange10	Mom Percent Change10.	number
AvmLow11	Avm Low11.	number
AvmHigh11	Avm High11.	number
AvmValue11	Avm Value11.	number
ConfidenceScore11	Confidence Score11.	number
MomPercentChange11	Mom Percent Change11.	number
AvmLow12	Avm Low12.	number
AvmHigh12	Avm High12.	number
AvmValue12	Avm Value12.	number
ConfidenceScore12	Confidence Score12.	number
MomPercentChange12	Mom Percent Change12.	number
AnnualizedAverageSqftValue	Annualized Average Sqft Value.	number
SquareFootage	Square Footage.	number
YoyAveragePercentChange	Yoy Average Percent Change.	number
NetAnnualMonthOverMonthChange	Net Annual Month Over Month Change.	number
ModificationTimestamp	Modification Timestamp.	date-time

Sales And Transfer History

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

Field Name	Description	Data Type
CID	CID.	string
TransactionId	Transaction Id.	string
CountyFipsCode	County Fips Code.	string
ParcelNumber	Parcel Number.	string
UnparsedAddress	Unparsed Address.	string
UnitType	Unit Type.	string
UnitNumber	Unit Number.	string
City	City.	string
StateOrProvince	State Or Province.	string
PostalCode	Postal Code.	string
PostalCodePlus4	Postal Code Plus4.	string
Country	Country.	string
StreetNumber	Street Number.	string
StreetDirPrefix	Street Dir Prefix.	string
StreetName	Street Name.	string
StreetSuffix	Street Suffix.	string
StreetDirSuffix	Street Dir Suffix.	string
CarrierRoute	Carrier Route.	string
CountyOrParish	County Or Parish.	string
DocumentType	Document Type.	string
RecordingDate	Recording Date.	date
OriginalDateOfContract	Original Date Of Contract.	date
RecordersBookNumber	Recorders Book Number.	string
RecordersPageNumber	Recorders Page Number.	string
RecordersDocumentNumber	Recorders Document Number.	string
SalesPrice	Sales Price.	number
SalesPriceCode	Sales Price Code.	string
PricePerSquareFoot	Price Per Square Foot.	number
PricePerSquareFootBuilding	Price Per Square Foot Building.	number
PricePerSquareFootLot	Price Per Square Foot Lot.	number
CityTransferTax	City Transfer Tax.	number
CountyTransferTax	County Transfer Tax.	number
TotalTransferTax	Total Transfer Tax.	number
TitleCompanyName	Title Company Name.	string
IntraFamilyYN	Intra Family YN.	boolean
CashPurchaseYN	Cash Purchase YN.	boolean
DistressedSaleYN	Distressed Sale YN.	boolean
ReoStatus	Reo Status.	string
PartialInterestTransferred	Partial Interest Transferred.	string
PropertySubType	Property Sub Type.	string
ResidentialIndicator	Residential Indicator.	string
PropertyType	Property Type.	string
SellerFNameMName1	Seller F Name M Name1.	string
SellerLNameOrCorpName1	Seller L Name Or Corp Name1.	string
SellerFullName1	Seller Full Name1.	string
SellerFNameMName2	Seller F Name M Name2.	string
SellerLNameOrCorpName2	Seller L Name Or Corp Name2.	string
SellerFullName2	Seller Full Name2.	string
SellerMailUnparsedAddress	Seller Mail Unparsed Address.	string
SellerMailUnitNumber	Seller Mail Unit Number.	string
SellerMailCity	Seller Mail City.	string
SellerMailStateOrProvince	Seller Mail State Or Province.	string
SellerMailPostalCode	Seller Mail Postal Code.	string
SellerMailPostalCodePlus4	Seller Mail Postal Code Plus4.	string
BuyerFNameMName1	Buyer F Name M Name1.	string
BuyerLNameOrCorpName1	Buyer L Name Or Corp Name1.	string
BuyerFullName1	Buyer Full Name1.	string
BuyerFNameMName2	Buyer F Name M Name2.	string
BuyerLNameOrCorpName2	Buyer L Name Or Corp Name2.	string
BuyerFullName2	Buyer Full Name2.	string
BuyerVestingCode	Buyer Vesting Code.	string
BuyerMailUnparsedAddress	Buyer Mail Unparsed Address.	string
BuyerMailUnitType	Buyer Mail Unit Type.	string
BuyerMailUnitNumber	Buyer Mail Unit Number.	string
BuyerMailCity	Buyer Mail City.	string
BuyerMailStateOrProvince	Buyer Mail State Or Province.	string
BuyerMailPostalCode	Buyer Mail Postal Code.	string
BuyerMailPostalCodePlus4	Buyer Mail Postal Code Plus4.	string
ModificationTimestamp	Modification Timestamp.	date-time
CdlTransactionID	Cdl Transaction ID.	string

Assessor History Aggregate

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

Field Name	Description	Data Type
CID	CID.	string
RecordId	Record Id.	string
CountyFipsCode	County Fips Code.	string
ParcelNumber	Parcel Number.	string
UnparsedAddress	Unparsed Address.	string
UnitType	Unit Type.	string
UnitNumber	Unit Number.	string
City	City.	string
StateOrProvince	State Or Province.	string
PostalCode	Postal Code.	string
Country	Country.	string
StreetNumber	Street Number.	string
StreetDirPrefix	Street Dir Prefix.	string
StreetName	Street Name.	string
StreetSuffix	Street Suffix.	string
StreetDirSuffix	Street Dir Suffix.	string
CountyOrParish	County Or Parish.	string
TaxYear	Tax Year.	number
TaxAnnualAmount	Tax Annual Amount.	number
TaxExemptionCodes	Tax Exemption Codes.	string
CertificationDate	Certification Date.	date
TaxAssessedYear	Tax Assessed Year.	number
TaxAssessedValue	Tax Assessed Value.	number
TaxAssessedValueImprovements	Tax Assessed Value Improvements.	number
TaxAssessedValueLand	Tax Assessed Value Land.	number
MarketValueYear	Market Value Year.	number
MarketValue	Market Value.	number
MarketValueImprovements	Market Value Improvements.	number
MarketValueLand	Market Value Land.	number
AssessedValuePerSqftTotal	Assessed Value Per Sqft Total.	number
AssessedValuePerSqftImprovements	Assessed Value Per Sqft Improvements.	number
AssessedValuePerSqftLand	Assessed Value Per Sqft Land.	number
MarketValuePerSqftTotal	Market Value Per Sqft Total.	number
MarketValuePerSqftImprovements	Market Value Per Sqft Improvements.	number
MarketValuePerSqftLand	Market Value Per Sqft Land.	number
YoyCTaxesAmount	Yoy C Taxes Amount.	number
YoyCTaxesPercent	Yoy C Taxes Percent.	number
YoyCAssessedAmount	Yoy C Assessed Amount.	number
YoyCAssessedPercent	Yoy C Assessed Percent.	number
YoyCMarketAmount	Yoy C Market Amount.	number
YoyCMarketPercent	Yoy C Market Percent.	number
AvmAnnualMedian	Avm Annual Median.	number
AvmAnnualAverage	Avm Annual Average.	number
AvmLow	Avm Low.	number
AvmHigh	Avm High.	number
AvmCount	Avm Count.	number
DefaultYN	Default YN.	string
SaleYN	Sale YN.	string
SaleRecordingDate	Sale Recording Date.	date
SaleContractDate	Sale Contract Date.	date
SalePrice	Sale Price.	number
ModificationTimestamp	Modification Timestamp.	date-time

Mortgage History Aggregate

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

Field Name	Description	Data Type
RecordId	Record Id.	string
CID	CID.	string
CountyFipsCode	County Fips Code.	string
ParcelNumber	Parcel Number.	string
UnparsedAddress	Unparsed Address.	string
UnitType	Unit Type.	string
UnitNumber	Unit Number.	string
City	City.	string
StateOrProvince	State Or Province.	string
PostalCode	Postal Code.	string
PostalCodePlus4	Postal Code Plus4.	string
Country	Country.	string
StreetNumber	Street Number.	string
StreetDirPrefix	Street Dir Prefix.	string
StreetName	Street Name.	string
StreetSuffix	Street Suffix.	string
StreetDirSuffix	Street Dir Suffix.	string
CarrierRoute	Carrier Route.	string
CountyOrParish	County Or Parish.	string
BorrowerName1	Borrower Name1.	string
BorrowerFnameMname1	Borrower Fname Mname1.	string
BorrowerLnameOrCorpname1	Borrower Lname Or Corpname1.	string
BorrowerName2	Borrower Name2.	string
BorrowerFnameMname2	Borrower Fname Mname2.	string
BorrowerLnameOrCorpname2	Borrower Lname Or Corpname2.	string
BorrowerVestingCode	Borrower Vesting Code.	string
OwnerMailUnparsedAddress	Owner Mail Unparsed Address.	string
OwnerMailUnitType	Owner Mail Unit Type.	string
OwnerMailUnitNumber	Owner Mail Unit Number.	string
OwnerMailCity	Owner Mail City.	string
OwnerMailStateOrProvince	Owner Mail State Or Province.	string
OwnerMailPostalCode	Owner Mail Postal Code.	string
OwnerMailPostalCodePlus4	Owner Mail Postal Code Plus4.	string
OccupantType	Occupant Type.	string
DocumentType	Document Type.	string
RecordingDate	Recording Date.	date
OriginalDateOfContract	Original Date Of Contract.	date
RecordersBookNumber	Recorders Book Number.	string
RecordersPageNumber	Recorders Page Number.	string
RecordersDocumentNumber	Recorders Document Number.	string
LoanAmount	Loan Amount.	number
TermMonths	Term Months.	number
TermYears	Term Years.	number
DueDate	Due Date.	date
LoanPurpose	Loan Purpose.	string
LoanType	Loan Type.	string
FinancingType	Financing Type.	string
InterestRate	Interest Rate.	number
ConstructionLoanYN	Construction Loan YN.	boolean
StandaloneYN	Standalone YN.	boolean
EquityCreditLineYN	Equity Credit Line YN.	boolean
PurchaseMoneyMortgageYN	Purchase Money Mortgage YN.	boolean
TitleCompanyName	Title Company Name.	string
MultiPropertyTransferId	Multi Property Transfer Id.	number
MultiApnValue	Multi Apn Value.	number
MultiApnRatio	Multi Apn Ratio.	number
AdjustableRateRider	Adjustable Rate Rider.	string
AdjustableRateIndex	Adjustable Rate Index.	string
ChangeIndex	Change Index.	string
RateChangeFrequency	Rate Change Frequency.	string
InterestRateNotGreaterThan	Interest Rate Not Greater Than.	string
InterestRateNotLessThan	Interest Rate Not Less Than.	string
MaximumInterestRate	Maximum Interest Rate.	string
InterestOnlyPeriod	Interest Only Period.	string
FixedStepConversionRateRider	Fixed Step Conversion Rate Rider.	string
AdjustableRateChangeDate	Adjustable Rate Change Date.	date
PrepaymentRider	Prepayment Rider.	string
PrepaymentTermPenaltyRider	Prepayment Term Penalty Rider.	string
LenderNameBeneficiary	Lender Name Beneficiary.	string
LenderDbaName	Lender Dba Name.	string
LenderType	Lender Type.	string
LenderMailUnparsedAddress	Lender Mail Unparsed Address.	string
LenderMailUnit	Lender Mail Unit.	string
LenderMailCity	Lender Mail City.	string
LenderMailStateOrProvince	Lender Mail State Or Province.	string
LenderMailPostalCode	Lender Mail Postal Code.	string
LenderMailPostalCodePlus4	Lender Mail Postal Code Plus4.	string
LenderNMLSID	Lender NMLSID.	string
Lender	Lender.	string
MortgageBrokerNMLSID	Mortgage Broker NMLSID.	string
MortgageBroker	Mortgage Broker.	string
LoanOfficerNMLSID	Loan Officer NMLSID.	string
LoanOfficer	Loan Officer.	string
AssignmentDocumentType	Assignment Document Type.	string
AssignmentMersIndicator	Assignment Mers Indicator.	string
AssignmentRecordingDate	Assignment Recording Date.	date
AssignmentDocumentNumber	Assignment Document Number.	string
AssignmentBookNumber	Assignment Book Number.	string
AssignmentPageNumber	Assignment Page Number.	string
AssignmentAssignor	Assignment Assignor.	string
AssignmentAssignee	Assignment Assignee.	string
AssignmentAssigneePoolNumber	Assignment Assignee Pool Number.	string
MatchedOrOrphanIndicator	Matched Or Orphan Indicator.	string
ReleaseDocumentTypeCode	Release Document Type Code.	string
ReleaseRecordingDate	Release Recording Date.	date
ReleaseDocumentNumber	Release Document Number.	string
ReleaseBookNumber	Release Book Number.	string
ReleasePageNumber	Release Page Number.	string
ReleaseOriginalLender	Release Original Lender.	string
ReleaseCurrentLender	Release Current Lender.	string
DefaultIndicator	Default Indicator.	string
FirstStage	First Stage.	string
FirstStageRecordingDate	First Stage Recording Date.	date
SecondStage	Second Stage.	string
SecondStageRecordingDate	Second Stage Recording Date.	date
AuctionDate	Auction Date.	date
LoanId	Loan Id.	string
TransactionId	Transaction Id.	string
RecordCreationDate	Record Creation Date.	date
ModificationTimestamp	Modification Timestamp.	date-time

Full Detail information Confidential. Not for Distribution.