GuidesAPI ReferenceDiscussions

Property Data Schema

Suggest Edits

The property data schema below lists all available fields in a property record. Note that actual property records (actually, most of them) may not have every field present.

Field Name

Example Value (in JSON)

Description

address

"address": "7206 Walling Ln"

The physical street address for this property.
Field type: text

brokers

"brokers": [
  {
    "agent": "Frances Zuckerman",
    "company": "Fillmore",
    "dateSeen": "2017-01-17T09:47:16Z",
    "emails": [
      "[email protected]"
    ],
    "phones": [
      "3214561234"
    ]
  }
]

A list of brokers that have represented this property over time. Each broker may contain:
Field type: nested

  • agent: The name of the real estate agent representing this property.
    Field type: text

  • company: The company this agent works for (or the company representing this property).
    Field type: text

  • dateSeen: The date this agent/company was seen representing the property.
    Field type: date

  • emails: A list of email addresses associated with the agent or company.
    Field type: keyword

  • phones: A phone number associated with the agent or company.
    Field type: keyword

  • websites: A list of websites associated with the agent or company.
    Field type: keyword

buildingName

"buildingName":"Castle Beach Club"

The name of the building where this property is located. This field is specific to apartments, condos, and similar property types.
Field type: text

city

"city": "Dallas"

The city where the property is located.
Field type: text

country

"country": "US"

The two-letter country code for the business location's country.
Field type: text

dateAdded

"dateAdded": "2017-01-08T19:12:13Z"

The date this property was first added to the property database.
Field type: date

dateUpdated

"dateUpdated": "2017-01-08T19:12:13Z"

The most recent date this property was updated or seen by our system.
Field type: date

deposits

"deposits": [
  {
    "amount": 104,
    "currency": "USD",
    "dateSeen": [
      "2016-08-07T18:07:05Z"
    ],
  }
]

A list of deposit fees that have been seen for this property. Each deposit contains:
Field type: nested

  • amount: The fee amount.
    Field type: float

  • currency: The currency for the amount.
    Field type: keyword

  • dateSeen: A list of dates this deposit fee was seen.
    Field type: date

descriptions

"descriptions": [
  {
    "dateSeen": "2016-08-07T18:07:05Z",
    "value": "charming starter home priced to sell. full finished basement with bath and with separate entrance."
  }
]

A list of descriptions for this property from various sources. Each description contains:
Field type: nested

  • dateSeen: The date when this description has been seen for this property.
    Field type: date

  • value: A unique description for this property.
    Field type: text

domains

"domains": [
""www.airbnb.com"
]

A list of each unique domain found in the sourceURLs field.
Field type: domain

features

"features": [
  {
    "key": "Community District",
    "replace": "true",
    "value": [
      "318"
    ]
  }              
]

A list of features associated with this property. The feature list can be collected from specific feature sections available on listings for this property. It can also serve as a catch-all field for miscellaneous characteristics of this property that don't make sense to include as top-level fields.
Field type: nested

Each feature contains:

  • key: A label for this feature.
    Field type: text

  • replace: Flag indicating value field is replaced versus appended.
    Field type: boolean

  • value: A list of possible values for this feature.
    Field type: text

fees

"fees": [
  {
    "amountMax": 11,
    "amountMin": 11,
    "currency": "USD",
    "dateSeen": [
      "2016-08-07T18:07:05Z"
    ],
     "type": "Cleaning Fee"
   }
]

A list of various fees that have been seen for this property. Each fee will contain:
Field type: text

  • amountMax: The minimum fee value listed.
    Field type: float

  • amountMin: The maximum fee value listed.
    Field type: float

  • currency: The currency listed for amountMin and amountMax
    Field type: keyword

  • dateSeen: A list of dates when this fee was seen.
    Field type: date

  • type: A classification value for the fee.
    Field type: text

floorSizeValue

"floorSizeValue": 947

The size of the walkable area of the property. For apartments and condos, this is the size of the property. For homes and buildings, this is the combined size of each floor and does not include lot size.
Field type: float

floorSizeUnit

"floorSizeUnit": "Sq. ft"

The units of measurement for floorSize.
Field type: keyword

geoLocation

"geoLocation": "POINT (-119.5094 37.229366)"

A location value that stores the latitude and longitude in a format that allows geospatial querying.
Field type: geo_shape

The value is stored as Well-Known Text format, which resembles an (x, y) value, i.e. (longitude latitude).

imageURLs

"imageURLs": [
"http://image.rent.com/imgr/61bbc9f535f0e180bc804ac8f4c50067"
]

A list of image URLs for this property.
Field type: keyword

keys

"keys": [
  "us/ca/nhills/9411brightwoodct"
]

A list of internal Datafiniti identifiers for this property. The keys field is used to merge raw data from individual sources into the master Datafiniti record. Learn how this works
Field type: keyword

languagesSpoken

"languagesSpoken: [
  "French",
  "English"
]

A list of the languages spoken at this property.
Field type: text

latitude

"latitude": "32.860858"

The latitude coordinates for this property.
Field type: text

leasingTerms

"leasingTerms: [
  {
    "dateSeen": "2016-07-30T20:41:01Z",
    "value": "12 Months"
  }
]

A list of leasing terms that have been associated with this property. Each leasing term will contain:
Field type: nested

  • dateSeen: The date when this term was seen.
    Field type: date

  • value: The leasing term description.
    Field type: text

listingName

"listingName": "Antico Appartamento"

The name of the property listing. This isn't the name of the building. It's a descriptive name supplied for the listing itself.
Field type: text

longitude

"longitude": "-96.735808"

The longitude coordinates for this property.
Field type: text

lotSizeValue

"lotSizeValue": 2219

The lot size for the property. This is the ground area covered by the property.
Field type: integer

lotSizeUnit

"lotSizeUnit": "Sq. ft"

The units of measurement for lotSize.
Field type: keyword

managedBy

"managedBy": [
  {
    "dateSeen": [
      "2016-03-03T15:02:13Z"
    ],
     "value": "ROM Investments"
  }
]

A list of companies or people that have managed this property. Each managedBy object will contain:
Field type: nested

  • dateSeen: A list of dates when this information was seen.
    Field type: date

  • value: The name of the company or person.
    Field type: text

mlsNumber

"mlsNumber": "16177277"

The MLS number for the property. Learn more about MLS numbers.
Field type: keyword

mostRecentStatus

"mostRecentStatus": "For Sale"

The most recent value for statuses.type for this property. See possible values here.
Field type: keyword

mostRecentStatusDate

"mostRecentStatus": "2017-01-10T20:12:16Z"

The date that corresponds to the mostRecentStatus for this property.
Field type: date

mostRecentStatusFirstDateSeen

"mostRecentStatusFirstDateSeen": "2021-09-09T00:00:00.000"

This date corresponds to the earliest date seen from the source of the property listing.
Field type: date

neighborhoods

"neighborhoods": [
  "Canarsie"
]

A list of neighborhoods where this property is located. Sometimes an area can belong to multiple neighborhoods, which is why this field is a list.
Field type: text

numBathroom

"numBathroom": 1.25

The number of bathrooms in this property. Can be a whole number (e.g. "1") or a float (e.g., 1.25).
Field type: float

numBedroom

"numBedroom": 3

The number of bedrooms in this property.
Field type: integer

numFloor

"numFloor": 2

The number of floors or stories in this property.
Field type: integer

numPeople

"numPeople": 6

The number of people that can occupy this property.
Field type: integer

numRoom

"numRoom": 2

The number of rooms in this property.
Field type: integer

numUnit

"numUnit": 1

The number of units available in this property.
Field type: integer

parking

"parking": [
  "Garage"
]

A list of details regarding parking at this property.
Field type: text

paymentTypes

"paymentTypes": [
  "Visa"
]

A list of payment options accepted by the property.
Field type: text

people

"people": [
  {
    "dateSeen": "2017-06-11T11:40:54Z",
    "name": "Pulcano Yvonne",
    "title": "Owner"
  }
]

A list of known people associated with or employed by this property.
Field type: nested

Each person may contain:

  • dateSeen: The date when this person was seen.
    Field type: date

  • email: The person's email.
    Field type: text

  • name: The person's name.
    Field type: text

  • phone: The person's phone number.
    Field type: text

  • title: The person's title.
    Field type: text

petPolicy

"petPolicy": "Pets are not allowed."

The pet policy for the property.
Field type: text

phones

"phones": [
  "5058982700"
]

A list of phone numbers for the property.
Field type: keyword

postalCode

"postalCode": "75231"

The postal or zip code of the property.
Field type: keyword

prices

"prices": [
  {
    "amountMax": 289000,
    "amountMin": 289000,
    "availability": "true",
    "comment": ""Listed by Awaye Realty Management",
    "currency": "USD",
    "date": "2017-10-21T00:00:00Z",
    "dateSeen": [
      "2017-10-09T00:00:00Z"
    ],
    "isSale": "false",
    "isSold": "false",
    "pricePerSquareFoot": 197,
  },
  {
    "amountMax": 817,
    "amountMin": 817,
    "currency": "USD",
    "dateSeen": [
      "2016-01-20T00:00:00Z"
    ],
    "isSale": "false",
    "minStay": "7 nights",
    "period": "Per week",
  }
]

A list of prices for this property.
Field type: nested

Price objects may contain:

  • amountMin: The minimum price value listed.
    Field type: float

  • amountMax: The maximum price value listed. This is typically the same as amountMin, except in cases where a price range is listed.
    Field type: float

  • availability: The property's availability at this price.
    Field type: keyword

  • comment: A note related to this price.
    Field type: text

  • currency: The currency listed for amountMin and amountMax.
    Field type: text

  • date: A list of date when the property was set to this price.
    Field type: date

  • dateSeen: A list of dates when this price was seen.
    Field type: date

  • dateValidStart: The date when this price becomes valid.
    Field type: date

  • dateValidEnd: The date when this price is no longer valid.
    Field type: date

  • isSale: A true/false for whether or not this is a sale price.
    Field type: boolean

  • isSold: A true/false for whether or not this is the sold price.
    Field type: boolean

  • minStay: The minimum length of stay required for this price.
    Field type: text

  • period: The calendar period for which this price is valid.
    Field type: text

  • pricePerSquareFoot: The price divide by the square footage.
    Field type: float

propertyTaxes

"propertyTaxes": [
  {
    "amount": 1582,
    "currency": "USD",
    "dateSeen": [
      "2016-08-09T09:34:15Z"
    ],
  }
]

A list of property taxes that have been seen for this property. Each property tax will include:
Field type: nested

  • amount: The tax amount.
    Field type: float

  • currency: The amount's currency.
    Field type: text

  • dateSeen: A list of dates when this tax has been seen for this property.
    Field type: date

propertyType

"propertyType": "Condo"

A classification for the property type. See possible values here.
Field type: text

province

"province": "TX"

The province or state for this property.
Field type: text

reviews

"reviews": [
  {
    "dateSeen": "2016-08-17T00:00:00Z",
    "text": "We love this place a lot!",
    "username": "Yuwei"
  }
]

A list of reviews for this property.
Field type: nested

Review objects may contain:

  • date: The date the review was posted.
    Field type: date

  • dateSeen: The date when the review was seen by Datafiniti.
    Field type: date

  • doRecommend: A true/false for whether or not the reviewer recommends the product.
    Field type: boolean

  • rating: A 1 to 5 star value for the review.
    Field type: float

  • text: The full (or available) text of the review.
    Field type: text

  • title: The review's title.
    Field type: text

  • userCity: The reviewer's city.
    Field type: text

  • username: The reviewer's username.
    Field type: text

  • userProvince: The reviewer's province or state.
    Field type: text

rules

"rules": [
  "No smoking"
]

A list of rules for living or staying at this property.
Field type: text

statuses

"statuses": [
  {
    "dateSeen": [
      "2017-10-10T20:12:16Z"
    ],
    "date":  "2017-01-10T20:12:16Z",
    "isUnderContract": "false",
    "type": "Sold"
  }
]

A list of statuses for this property. This field is used to indicate when the property is for sale, etc.
Field type: nested

Each status includes:

  • date: Date the status occurred
    Field type: date

  • dateSeen: A list of dates when this status was seen by Datafiniti.
    Field type: date

  • isUnderContract: A true/false value to indicate if this status is under contract.
    Field type: boolean

  • type: The status. See possible values here.
    Field type: keyword

taxID

"taxID": "30-9011-019-0029758"

The tax ID for the property.
Field type: keyword

websiteIDs

"websiteIDs": [
  "domain.com-123",
  "website.com-4567"
]

A list of website IDs for this product. Website IDs are tied to a specific online retailer. They are the unique identifier used by website. They are used by Datafiniti when other unique identifiers are not available for a product.
Field type: keyword

yearBuilt

"yearBuilt": 2021

The year the property was built.
Field type: integer

Updated 6 months ago