Below are the Historical Sales Fields for Data Graph API:
| Fields | Type | Description |
|---|---|---|
| historicalPropertyAttributeID | String | Unique ID for each record in the product. |
| propertyAttributeID | String | ID to link Precisely Property Attributes Assessment products. |
| preciselyID | String | Unique ID for an addressable location. Not always available. |
| parentPreciselyID | String | The parent ID for the PreciselyID which represents the address for a building with units, apartments, and suites. Only present when applicable. |
| plinkID | String | Link ID between Precisely Parcel Boundaries and Property Attribute datasets. |
| sellerFirstName | String | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). |
| sellerLastName | String | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, such as Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT. Last names such as Mc Neil, O'Brien are entered with no space, apostrophe or any other punctuation, such as OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Seller Name is blurred or missing from document, this field will show: NOT PROVIDED |
| sellerIDCode | String | Used to identify the nature of each grantor keyed from the recorded document. |
| seller2FirstName | String | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). |
| seller2LastName | String | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, such as Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT Last names such as Mc Neil, O'Brien are entered with no space, apostrophe or any other punctuation, such as OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Seller Name is blurred or missing from document, this field will show: NOT PROVIDED |
| seller2IDCode | String | Used to identify the nature of each grantor keyed from the recorded document. |
| sellerMailAddress | String | Full formatted address for the seller |
| sellerMailCity | String | Parsed city name for seller mailing address |
| sellerMailState | String | Parsed state abbreviation for seller mailing address |
| sellerMailPostCode | String | Postal Code for seller mailing address |
| sellerMailPlus4 | String | Postal Code Extension for seller mailing address. This field does not have 100% fill rate. |
| buyerFirstName | String | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). |
| buyerLastCorporationName | String | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, such as Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT. Last names such as Mc Neil, O'Brien are entered with no space, apostrophe or any other punctuation, such as OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Seller Name is blurred or missing from document, this field will show: NOT PROVIDED |
| buyerIDCode | String | Used to identify the nature of each grantee keyed from the recorded document. |
| buyer2FirstName | String | The first name and middle name (when present) without abbreviations, or first name and middle initial (if that is how it appears on the document). |
| buyer2LastCorporationName | String | If the last name is composed of two names, both are entered in the sequence they appear separated with a space, such as Amy B. Jefferson Wright, entered as: JEFFERSON WRIGHT. Last names such as Mc Neil, O'Brien, are entered with no space, apostrophe or any other punctuation, such as OBRIEN, MCNEIL. Names followed by 2nd, 3rd, or 4th are entered in the last name field after the name as roman numerals: 2nd = SMITH II, 3rd = SMITH III, 4th = SMITH IV. All other title designations are entered after the last name, such as: JR, SR, ESQ, PHD If Seller Name is blurred or missing from document, this field will show: NOT PROVIDED |
| buyer2IDCode | String | Used to identify the nature of each grantee keyed from the recorded document. |
| buyerVestCode | ExtendedDetails | The vesting code, when present, indicates how the buyers took title to the subject property. Note: The vesting codes EA and EU should not appear on records being keyed by IDM since we will be picking up all Buyer names involved in the transaction. However, these codes may still apply for transfer data purchased from a third party vendor. |
| buyerMailAddress | String | Full formatted address for the buyer. |
| buyerMailCity | String | Parsed city name for buyer mailing address |
| buyerMailState | String | Parsed state abbreviation for buyer mailing address |
| buyerMailPostCode | ExtendedDetails | Postal Code for buyer mailing address. |
| buyerMailExtension | String | Postal Code Extension for buyer mailing address. This field does not have 100% fill rate. |
| addressLine | String | Formatted first line of the property's physical address |
| city | String | City name |
| state | String | State abbreviation |
| postalCode | String | Postal Code |
| postalCodeExtension | String | Postal Code Extension |
| propertyAPN | String | Formatted assessor's parcel number (APN) or parcel identification number - an identifier assigned by the assessing agency to simplify the identification of parcels. APN formatting and composition vary by agency, but the APN is usually composed of map-book, page, and parcel numbers. Some jurisdictions use section-township-range values as part of the APN. |
| apnSequence | String | Indicates the number of APNs (2-9) appearing on the conveying instrument. Left blank if only one parcel. |
| fips | String | Combination of state FIPS code (first two digits) and county FIPS code (last 3 digits) |
| propertyUseCode | ExtendedDetails | Property use as indicated on the trust deed (mortgage) and/or attached Rider. |
| deedDocumentTypeCode | ExtendedDetails | Deed Document Type Code |
| interFamily | String | Indicates the document is an inter-family transfer |
| recordingDate | Int | The official date of the document recordation in YYYYMMDD format |
| recordersBookNumber | String | Populated when counties use book and page reference without the document number, instead of the document number. |
| recordersPageNumber | String | Populated when counties use book and page reference without the document number, instead of the document number. |
| recordersDocumentNumber | String | Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation. |
| partialInterestTransferred | String | Indicates less than 100% ownership was transferred by the recorded instrument. For example, a partner sells only their 50% interest. This also applies to transfers where the Grantors entire ownership interest is LESS than 100%. For example, the Grantor conveys all of their interest in the property, which is a 25% interest. When the percentage is a single digit (1-9), it is preceded with a zero: 5% = 05. When interest shown is a whole number plus a value after the decimal or fraction, it is rounded to nearest whole number only, such as 75.5% = 76 or 33 1/3% = 33. Note: If there are two or more parties each conveying a partial interest, where the total interest conveyed equals 100% - NOT a partial interest. |
| legalLotCode | String | Identifies properties which include more than one lot or partial lots. |
| legalLotNumbers | String | The individual lots which comprise the property. The actual lot numbers such as in a tract or subdivision. If more than one, as many multiple lot numbers as allowed by the field length are entered, separated with a comma (,) or ampersand (&). A hyphen is used to indicate a range (-). Refer Legal: Lot Code field. |
| legalBlock | String | The block of the subdivision or city in which the property is located |
| legalSection | String | The section of the city in which the property is located. Not the same as the "Section" of a Township-Range. Refer to Legal: Section/Township/ Range/Meridian field. |
| legalDistrict | String | The district in which the property is located. Usually a numeric code corresponding to the literal name in Legal: City, Municipality, Township field. |
| legalLandLot | String | A large portion or tract of land (which may also encompass many individual blocks or lots) in which the property is located. |
| legalUnit | String | The subdivision unit number. Common for properties such as condominiums or town homes. Not necessarily the same as the Property Unit Number field. |
| legalCityTownshipMunicipality | String | The jurisdiction in which the property is located. May be "Unincorporated", if applicable. Often a description of the code provided in Legal: District field. Not necessarily the same as the Property City field. |
| legalSubdivisionName | String | The name of the subdivision, plat, or tract in which the property is located. |
| legalPhaseNumber | String | Generally, the phase of a subdivision or tract development. |
| legalTractNumber | String | The number of the tract in which the property is located. Followed by "POR" (portion of) when applicable. |
| legalShortDescription | String | Lists exceptions, when only a portion of Block, Lot, Tract or Subdivision is entered in the specific field. Or, when legal description components are not fielded, this field will be populated. Refer to Legal Description Code field. |
| legalSection | String | Format: SEC 99 TWN 99A RNG 99A Where "A" = Directional (N/S for TWN and E/W for RNG) |
| legalDescriptionCode | String | Legal description code. |
| recordersMapReference | String | Standardized to identify each portion. Multiples indicated with the ampersand (&), and ranges separated with a hyphen (-). Depending on the length of the Map Reference, spaces may be omitted. |
| deedTransactionType | ExtendedDetails | Current valid deed codes. |
| recorderDocumentNumber | Int | Mortgage info recorded at the time of deed recording. The sequential Document number or the Book/Page number assigned to the Concurrent Mortgage at the time of recording for identification and to establish the order of recordation. Note: The Document number takes priority if both Document number and Book and Page are recorded on the document. Note: If Book and Page values are keyed, separate the values with a slash ('/') Example: "4778/456" = Book 4778, Page 456 |
| contractDate | Int | The date that the document was executed by the parties. Pre-dates the recording date. In some cases, may be the notary date in YYYYMMDD format. |
| salesPriceUSD | Int | Total sale price relating to all properties conveyed by the corresponding instrument. If more than one parcel was included on the conveying instrument there is no way to allot the price to each parcel. Whenever the recorded document (deed) indicates the actual sales price, it will be entered here in whole dollars - see Sales Price Code Field = "D". |
| salesPriceCode | ExtendedDetails | Sales price code. |
| cityTransferTax | String | Applies in only designated cities where they levy a city tax on all purchase money real estate transfers within their jurisdiction. Input format: 99999v99 (implied decimal) |
| stateTransferTax | String | Generally appears in the form of a transfer tax stamp on the deed. The stamp amount represents a rate levied by the state per $1,000 of consideration paid in the transaction. Depending on the individual state, the stamp amount when converted to the actual transaction amount, using the corresponding rate, may represent the full sales price or only the amount of equity transferred, that is cash down plus any new financing. Input format: 99999v99 (implied decimal) |
| totalTransferTax | String | Unique to certain regions where you add the city and county transfer tax amounts to compute the full sales price. Input format: 999999v99 (implied decimal) |
| lenderName | String | Mortgage info recorded at the time of deed recording. Name of the beneficiary to the first trust deed (mortgage). When more that one Lender is reported, only the first Lender appearing on the document is entered. If a Trust, along with Trustees appear as Lender, then only the Trust Name is entered. Note: Whenever we encounter a mortgage/trust deed document that also references an Assignment of Mortgage, our practice is to capture the name of the Lender that ORIGINATED the loan, rather than the name of the Assignee Lender. |
| lenderType | ExtendedDetails | Mortgage info recorded at the time of deed recording. |
| loanAmountUSD | Int | Mortgage info recorded at the time of deed recording. Mortgage (purchase money) recorded concurrently with the conveying instrument. Reported in dollars only, no commas (,). Not calculated when loan made in installments distributed on a monthly or annual basis. Note: On Assumed Loans (Field #78 = "A"), the loan amount being assumed is entered here, if available. |
| loanType | ExtendedDetails | Mortgage info recorded at the time of deed recording. Indicates the type of loan, if able to determine from the recorded document. |
| financingType | ExtendedDetails | Mortgage info recorded at the time of deed recording. When available will indicate the type of interest rate terms for the Mortgage AND/OR see Loan Type (Field #78). Left blank if unknown. Note: 1. When document indicates the loan is initiated at an Adjustable Rate, Type Financing will be "ADJ". 2. When document indicates the loan is initiated with a Fixed Rate, Type Financing will be "FIX". |
| initialRate | Int | Mortgage info recorded at the time of deed recording. When available, initial rate as given on the trust deed or rider. Input Format: 99v99 (implied decimal) |
| dueDate | Int | Mortgage info recorded at the time of deed recording. When available, the date the concurrent trust deed will be paid in full. Format: YYYYMMDD |
| loanAmountSecondUSD | Int | Loan amount of second trust deed concurrent (subject to) to the original (1st) loan. |
| adjustableRateRider | String | Yes = an Adjustable Rate Rider recorded with the trust deed, else blank. |
| adjustableRateIndex | String | Identifies the type of index the adjustable loan is tied to. |
| changeIndex | Int | Identifies the margin (expressed as a percentage) that is added by the Lender to the interest rate derived from the index. If that is not available, then the value represents the maximum change in the interest rate at any one time. Input Format: 99v99 (implied decimal) |
| rateChangeFrequency | String | Indicates the frequency the interest rates may change. |
| interestRateAdjustableMaximum | Int | The maximum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 99v99 (implied decimal) |
| interestRateAdjustableMinimum | Int | The minimum interest rate allowed on the first change date (date when loan switched from a fixed to an adjustable interest rate). Format: 99v99 (implied decimal) |
| interestRateMaximum | Int | The maximum interest rate allowed for the loan. Format: 99v99 (implied decimal) |
| interestOnlyPeriod | Int | If available, the actual interest only period (expressed in years) OR Yes = the loan has an interest-only period. |
| interestRate | String | Indicates initial state of the interest rate, such as fixed or variable, for the concurrent loan, if available. |
| fixedChangeDateYear | Int | The year that the loan converts from a FIXED to ADJUSTABLE interest rate. Format: YY (Two digit year; 2005 = "05") |
| fixedChangeFullDateMonthDay | Int | The Month and Day that the loan converts from a FIXED to ADJUSTABLE interest rate. Format: MMDD |
| prepaymentRider | String | Indicates if a prepayment rider was recorded with the trust deed. |
| prepaymentTermPenalty | String | The number of months that the originated loan must remain active. If the loan is paid off early, the borrower will pay a prepayment penalty. Always expressed in months: 12, 18, 24, 36 are the most common. |
| titleCompanyName | String | Name of Title Company which issues the certificate of title insurance. Taken from the Deed and/or concurrent Trust Deed. Not coded or abbreviated. If more than one Title Company Name is reported on the document, this field will report "Multiple" versus an actual Title Company Name. |
| realEstateOwnedFlag | String | REO-Flag |
| distressedSaleFlag | String | Distressed Sale Flag |
| loanOriginatorOrganizationIDNumber | Int | Loan Originator Company/Organization ID number. Sometimes referenced as NMLSR ID or Originator Company ID. |
| loanOrganizationName | String | Name or Loan Originator Organization/Company as referenced on signature page of Mortgage Document - Also referenced as Creditor. |
| mortgageBrokerNMLSID | String | NMLS ID Recorded on the document for the originating broker |
| mortgageBroker | String | NMLS Broker Name Recorded on the document. |
| loanOfficerNMLSID | String | Loan Originator ID Number assigned to Individual Originating Loan. Sometimes referenced as NMLSR ID or Originator ID |
| loanOfficerName | String | Full name of Individual Loan Originator/Agent as referenced on signature page of Mortgage document |
| loanTransactionType | ExtendedDetails | Current valid codes. |
Note: For more information, see the Historical Sales Data product guide.