Property Data Schema
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]" ], "licenseNumber": "XXXX #0171717" "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 licenseNumber: The license number of the agent representing the property.Field type: text 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 amountMaxField 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 worksField 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 |
mostRecentPriceAmount | "mostRecentPriceAmount": 85 | The product's most recent price amount scraped. Field type: BigDecimal |
mostRecentPriceCurrency | "mostRecentPriceCurrency": "USD" | The currency listed for mostRecentPriceAmount. Field type: text |
mostRecentPriceDomain | "mostRecentPriceDomain": "www.nordstrom.com" | The domain of the most recent price scraped by Datafiniti Field type: domain |
mostRecentPriceDate | "mostRecentPriceDate": "2022-03-29T19:26:49.157Z" | The most recent price date of the product record. Field type: date |
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 occurredField 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 |
transactions | "transactions": [ { saleDate: 2023-01-04T12:00:00Z, firstDateSeen: 2023-01-04T12:00:00Z, lastDateSeen: 2023-01-04T12:00:00Z, documentType: Warranty Deed, price: 112900.00, sellerFirstName: Anita, sellerMiddleName: Brian, sellerLastName: Powell, buyerFirstName: Ben, buyerMiddleName: Cherelle, buyerLastName: Emaline, lenderName: Ameris Bank, loanType: Conventional, loanAmount: 10725.00, mortgageTerm: 360, interestType: Adjustable, parcelNumber: 17-07-26-0-001-005.000, ownerType: Company, contactOwnerMailAddressFull: 2337 JULIAN DR } ], county: Calhoun, countyFIPS: 1015, subdivision: Crescent Heights Sub, congressionalDistrictHouse: 4, legalDescription: SEC 26 TSP 15S RNG 07E, legalRange: 08E, currentOwnerType: Company, instrumentNumber: 3312-0576 } ] | A list of transactional data for this property. This field is used to indicate when the property was purchased and by who. Field type: nested Each transaction includes: saleData: Date the when transaction occurredField type: date firstDateSeen: Earliest date seen from the source of the property listing by Datafiniti.Field type: date lastDateSeen: Latest date seen from the source of the property listing by Datafiniti.Field type: date documentType: Contains all documents attached in this transaction.Field type: string price: Price of the property for this transaction.Field type: double sellerFirstName: First name of the seller.Field type: string sellerMiddleName: Middle name of the seller.Field type: string sellerLastName: Last name of the seller.Field type: string buyerFirstName: First name of the buyer.Field type: string buyerMiddleName: Middle name of the buyer.Field type: string buyerLastName: Last name of the buyer.Field type: string lenderName: Name of the lender.Field type: string loanType: Type of loan for this transaction.Field type: string loanAmount: Loan amount by lending company.Field type: double mortgageTerm: Length in months of the loan.Field type: integer interestType: interest rate by the lender.Field type: string parcelNumber: Number parcel was created.Field type: string ownerType: Type of owner for transaction.Field type: string contactOwnerMailAddressFull: Mailing address of the owner of the property.Field type: string county: County of the property.Field type: string countyFIPS: County FIPS # of the property.Field type: integer subdivision: Subdivision / neighborhood of the property.Field type: string congressionalDistrictHouse: District of the property.Field type: string legalDescription: Legal description of the property.Field type: string legalRange: Legal range of the property.Field type: string currentOwnerType: Current owner type of the property.Field type: string instrumentNumber: Instrument # of the property.Field type: string |
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 about 2 months ago