Data Table: Deed Owner Transfer Records

Description
This data includes compiled public records of deed transfers across the country. It includes both arms-length and non-arms-length transactions.

Columns

1. buyer1_corporate_indicator

  • data_type: text
  • description: Indicator that the BUYER has been recognized as a corporation or business.

2. buyer1_firstname_middle_initial

  • data_type: text
  • description: First name of the BUYER – 1st occurrence.

3. buyer1_fullname

  • data_type: text
  • description: Full name of the BUYER at the time of transfer – 1st occurrence.

4. buyer1_lastname

  • data_type: text
  • description: Last name of the BUYER – 1st occurrence.

5. buyer2_corporate_indicator

  • data_type: text
  • description: Indicator that the BUYER has been recognized as a corporation or business.

6. buyer2_firstname_middle_initial

  • data_type: text
  • description: First name of the BUYER – 2nd occurrence.

7. buyer2_fullname

  • data_type: text
  • description: Full name of the BUYER – 2nd occurrence.

8. buyer2_lastname

  • data_type: text
  • description: Last name of the BUYER – 2nd occurrence.

9. buyer3_corporate_indicator

  • data_type: text
  • description: Indicator that the BUYER has been recognized as a corporation or business.

10. buyer3_firstname_middle_initial

  • data_type: text
  • description: First name of the BUYER – 3rd occurrence.

11. buyer3_fullname

  • data_type: text
  • description: Full name of the BUYER – 3rd occurrence.

12. buyer3_lastname

  • data_type: text
  • description: Last name of the BUYER – 3rd occurrence.

13. buyer4_corporate_indicator

  • data_type: text
  • description: Indicator that the BUYER has been recognized as a corporation or business.

14. buyer4_firstname_middle_initial

  • data_type: text
  • description: First name of the BUYER – 4th occurrence.

15. buyer4_fullname

  • data_type: text
  • description: Full name of the BUYER – 3rd occurrence. (Note: Possibly a typo in original—“3rd” might mean 4th occurrence in context.)

16. buyer4_lastname

  • data_type: text
  • description: Last name of the BUYER – 4th occurrence.

17. buyer_care_of_name

  • data_type: text
  • description: Care of Name for mail delivery.

18. buyer_etal_code

  • data_type: text
  • description: A code appearing in this field indicates additional ownership, whose name(s) were not provided by our sources.

19. buyer_mail_carrier_route

  • data_type: text
  • description: This is the four digit code used by the local mail carrier to identify the delivery path.

20. buyer_mail_city

  • data_type: text
  • description: The city associated with the mailing address.

21. buyer_mail_direction

  • data_type: text
  • description: This field represents the direction found to the left of the street name.

22. buyer_mail_house_num

  • data_type: text
  • description: The digits found to the left of a street name, representing the house number for the mailing address.

23. buyer_mail_house_num2

  • data_type: text
  • description: The second set of numbers in an address range.

24. buyer_mail_house_num_suffix

  • data_type: text
  • description: The characters found to the immediate right of a house number.

25. buyer_mail_mode

  • data_type: text
  • description: The Mode or Type of street found to the right of the street name.

26. buyer_mail_opt_out_indicator

  • data_type: text
  • description: Represents a record where buyer has contacted the DMA.

27. buyer_mail_quadrant

  • data_type: text
  • description: The quadrant found to the right of Mailing Mode.

28. buyer_mail_state

  • data_type: text
  • description: The two-letter USPS postal abbreviation associated with the state / protectorates / commonwealth.

29. buyer_mail_street_address

  • data_type: text
  • description: Full mail address.

30. buyer_mail_street_name

  • data_type: text
  • description: The name or number of the street of the mailing address.

31. buyer_mail_unit_num

  • data_type: text
  • description: The unit or suite number of the mailing address.

32. buyer_mail_zipcode

  • data_type: text
  • description: Code assigned by the USPS.

33. buyer_occupancy_code

  • data_type: text
  • description: CoreLogic derived code that indicates if the property buyer intends to reside at the situs (property site).

34. buyer_ownership_rights_code

  • data_type: text
  • description: Form or method of property ownership (e.g., Joint Tenants, Living Trust).

35. buyer_relationship_type_code

  • data_type: text
  • description: Relationship between multiple owners or marital status.

36. cash_purchase_indicator

  • data_type: text
  • description: CoreLogic proprietary value that identifies if the property was a cash-based arms-length transaction.

37. clip

  • data_type: text
  • description: Unique identification number assigned to each property.

38. foreclosure_reo_indicator

  • data_type: text
  • description: CoreLogic proprietary value that indicates whether the transaction was a completed foreclosure where the bank took back ownership of the property (REO).

39. foreclosure_reo_sale_indicator

  • data_type: text
  • description: CoreLogic proprietary value that indicates that the bank sold the REO to a third party.

40. global_tracking_id

  • data_type: text
  • description: Tracking ID to backtrack the loading in case of issues.

42. investor_purchases_indicator

  • data_type: text
  • description: CoreLogic proprietary value that indicates if the buyer bought the property for investment purposes.

43. is_arms_length

  • data_type: boolean
  • description: Indicator to identify the transaction.

44. loc_land_use_code

  • data_type: text
  • description: A CoreLogic established Land Use code converted from various county Land Use codes to aid in search and extract functions.

45. mortgage_purchase_indicator

  • data_type: text
  • description: CoreLogic proprietary value that identifies if the property has a mortgage.

46. new_construction_indicator

  • data_type: text
  • description: CoreLogic standardized value that indicates the ownership transfer/sale is for a newly constructed property.

47. partial_interest_indicator

  • data_type: text
  • description: An indicator showing the Owner/Buyer has a partial interest in the property.

48. pid_apn_seq_num

  • data_type: text
  • description: This internal sequence number is used to ensure uniqueness of the Assessor’s Parcel Number.

49. pid_fips_code

  • data_type: text
  • description: Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.

50. pid_online_fmt_parcel_id

  • data_type: text
  • description: APN that would link to CoreLogic online products.

51. pid_original_apn

  • data_type: text
  • description: Original Assessor’s Parcel Number (APN) in raw format provided on the assessor tax roll.

52. pid_property_linkage_key

  • data_type: text
  • description: Unique property key, which can be used to link to other files associated with the property.

53. pid_tax_account_num

  • data_type: text
  • description: The county or source number used primarily for billing.

54. pid_unformatted_apn

  • data_type: text
  • description: Assessor’s Parcel Number in an unformatted form.

55. previous_clip

  • data_type: text
  • description: Previous CLIP (identification number for properties) which has had a change in CLIP.

56. prop_actual_year_built

  • data_type: text
  • description: The construction year of the original building on the parcel as provided by the county.

57. prop_county_use_desc

  • data_type: text
  • description: Primary (e.g. highest) Land Use as established by the county or local taxing administration.

58. prop_effective_year_built

  • data_type: text
  • description: This field reflects the first year the building was assessed with its current components.

59. prop_indicator_code

  • data_type: text
  • description: A CoreLogic general code used to easily recognize specific property types (e.g. Single Family Residence, Condominium, Commercial).

60. prop_mobile_home_indicator

  • data_type: text
  • description: Mobile Home is present on the property.

61. prop_state_use_desc

  • data_type: text
  • description: State-specific secondary Land Use provided by the county.

62. prop_total_num_bldgs

  • data_type: text
  • description: Total number of buildings on the parcel.

63. prop_zoning_code

  • data_type: text
  • description: The data contained in this field is based upon County and/or Local established Zoning Codes and is not converted by CoreLogic.

64. propaddr_deed_situs_carrier_route

  • data_type: text
  • description: This is the four digit code used by the local mail carrier to identify the delivery path.

65. propaddr_deed_situs_city

  • data_type: text
  • description: The city associated with the property address.

66. propaddr_deed_situs_county

  • data_type: text
  • description: Situs county name.

67. propaddr_deed_situs_direction

  • data_type: text
  • description: This field represents the direction found to the left of the street name.

68. propaddr_deed_situs_house_num

  • data_type: text
  • description: The digits found to the left of a street name.

69. propaddr_deed_situs_house_num2

  • data_type: text
  • description: The second set of numbers in an address range.

70. propaddr_deed_situs_house_num_suffix

  • data_type: text
  • description: The characters found to the immediate right of a house number.

71. propaddr_deed_situs_mode

  • data_type: text
  • description: The Mode or Type of street found to the right of the street name.

72. propaddr_deed_situs_quadrant

  • data_type: text
  • description: The quadrant is found to the right of Situs Mode.

73. propaddr_deed_situs_state

  • data_type: text
  • description: The two-letter USPS postal abbreviation associated with the state / protectorates / commonwealth.

74. propaddr_deed_situs_street_address

  • data_type: text
  • description: Full Situs address.

75. propaddr_deed_situs_street_name

  • data_type: text
  • description: The name or number of the street where a parcel is located.

76. propaddr_deed_situs_unit_number

  • data_type: text
  • description: The unit or suite number of the property address.

77. propaddr_deed_situs_zipcode

  • data_type: text
  • description: Code assigned by the USPS.

78. propaddr_standardized_address_confidence_code

  • data_type: text
  • description: Standardized code that describes the confidence of the situs (property site) address standardization match.

79. record_action_indicator

  • data_type: text
  • description: A CoreLogic system generated indicator used to advise customers how to process records contained in delta files.

80. resale_indicator

  • data_type: text
  • description: CoreLogic standardized value that indicates whether the transaction is considered a resale of an existing property.

81. residential_indicator

  • data_type: text
  • description: Indicates whether the property is residential.

82. seller1_firstname

  • data_type: text
  • description: CoreLogic standardized first name of the seller who is listed first on the deed for the most recent sale transaction.

83. seller1_fullname

  • data_type: text
  • description: CoreLogic standardized full seller name of the first seller who is listed on the deed for the most recent sale transaction.

84. seller1_lastname

  • data_type: text
  • description: CoreLogic standardized last name of the seller who is listed first on the deed for the most recent sale transaction.

85. seller2_fullname

  • data_type: text
  • description: CoreLogic standardized full seller name of the second seller who is listed on the deed for the most recent sale transaction.

86. short_sale_indicator

  • data_type: text
  • description: CoreLogic proprietary indicator that identifies if the property sale is considered a short sale.

87. tid_owner_transfer_composite_trans_id

  • data_type: text
  • description: The Mode or Type of street found to the right of the street name. (Note: Possibly a mismatch with the label; original PDF text might vary.)

88. tid_pending_record_indicator

  • data_type: text
  • description: Indicator which identifies transactions which could not be matched to the county’s tax roll file.

89. tid_transaction_batch_date

  • data_type: text
  • description: CoreLogic internal date number in YYYYMMDD format – can be used in the creation of unique keys.

90. tid_transaction_batch_sequence_num

  • data_type: text
  • description: CoreLogic internal sequence number – can be used in the creation of unique keys.

91. tid_transaction_fips_code

  • data_type: text
  • description: Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction.

92. title_company_code

  • data_type: text
  • description: This is a CoreLogic internal code used to identify the Title Company that was associated with the sales transaction.

93. title_company_name

  • data_type: text
  • description: This is the Title Company associated with the sales transaction.

94. tpid

  • data_type: text
  • description: Vendor neutral unique ID.

95. trans_deed_category_type_code

  • data_type: text
  • description: CoreLogic proprietary deed category type code that identifies the class of recorded legal document.

96. trans_multi_or_split_parcel_code

  • data_type: text
  • description: Indicates either that the transaction involves multiple parcels, or the split of an existing parcel.

97. trans_ownership_transfer_percentage

  • data_type: number(38,0)
  • description: A percentage showing the percentage of ownership transferred.

98. trans_primary_category_code

  • data_type: text
  • description: CoreLogic proprietary transaction classification code that identifies the type of transaction.

99. trans_sale_amount

  • data_type: number(38,0)
  • description: Dollar amount of the most recent sale of the property.

100. trans_sale_derived_date

  • data_type: date
  • description: CoreLogic proprietary sale date derived from the original public record filing in YYYYMMDD format.

101. trans_sale_derived_recording_date

  • data_type: date
  • description: CoreLogic proprietary sale recording date derived from the original public record filing in YYYYMMDD format.

102. trans_sale_document_type_code

  • data_type: text
  • description: The type of deed used to record the sales transaction.

103. trans_sale_recorded_document_book_num

  • data_type: text
  • description: The Book number used by some counties to catalog their sales recordings.

104. trans_sale_recorded_document_number

  • data_type: text
  • description: The document number used by some counties to record sales transactions.

105. trans_sale_recorded_document_page_num

  • data_type: text
  • description: The Page number used by some counties to catalog their sales recordings.

106. trans_sale_type_code

  • data_type: text
  • description: This field indicates what the financial consideration is – if a Deed record represents a change of ownership (Sale).