The business data schema below lists all available fields in a business record. Note that actual business records (actually, most of them) may not have every field present.
Field Name
Example Value (in JSON)
Description
address
"address": "3382 30th St"
The physical street address for this business location.
Field type: text
A list of cuisines offered by this business location. This field will only show for restaurants or other eating locations.
Field type: text
dateAdded
"dateAdded": "2016-03-24T09:27:02Z"
The date this business was first added to the business database.
Field type: date
dateUpdated
"dateUpdated": "2017-03-20T20:45:49Z"
The most recent date this business was updated or seen by our system.
Field type: date
descriptions
"descriptions": [
{
"dateSeen": "2016-06-18T01:17:41Z",
"sourceURLs": [
"https://www.zagat.com/r/petes-seafood-and-sandwich-san-diego"
],
"value": "Sizable made-to-order sandwiches, including lobster rolls, meatball Parmesan heroes and a variety of vegetarian options, are served at this East Coast–style sandwich shop nestled in the heart of North Park."
}
]
A list of descriptions for this business from various sources. Each description contains:
Field type: nested
dateSeen: The date when this description has been seen for this business.
Field type: date
sourceURLs: A list of source URLs where this specific description was seen.
Field type: keyword
value: A unique description for this business.
Field type: text
A list of features associated with this business location. The feature list can be collected from specific feature sections available on listings for this business. It can also serve as a catch-all field for miscellaneous characteristics of this business 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
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).
A list of internal Datafiniti identifiers for this business. 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: [
"English",
"Spanish"
]
A list of the languages spoken at this business.
Field type: text
latitude
"latitude": "32.740654"
The latitude coordinates for this business location.
Field type: text
longitude
"longitude": "-117.129482"
The longitude coordinates for this business location.
Field type: text
A list of menu items offered by the business. This field will only show for restaurants or other eating locations.
Field type: nested
Each menu item may include:
amountMin: The minimum price value of the item.
Field type: float
amountMax: The maximum price value of the item. This is typically the same as amountMin, except in cases where a price range is listed.
Field type: float
category: The menu section this item belongs to.
Field type: text
currency: The currency listed for amountMin and amountMax.
Field type: keyword
dateSeen: The date when this item was seen.
Field type: date
description: A description for the item.
Field type: text
name: The item's name on the menu.
Field type: text
sourceURLs: A list of URLs where this item was seen.
Field type: keyword
name
"name": "Pete's Seafood & Sandwich"
The business location's name.
Field type: text
neighborhoods
"neighborhoods": [
"North Park, Western San Diego",
"North Park"
]
A list of neighborhoods where this business is located. Sometimes an area can belong to multiple neighborhoods, which is why this field is a list.
Field type: text
numEmployeesMin
"numEmployeesMin": "5"
The lower bound on the number of people possibly employed by this business.
Field type: integer
numEmployeesMax
"numEmployeesMax": "10"
The upper bound on the number of people employed by this business.
Field type: integer
numRoom
"numRoom": 10
The number of rooms available at this business. This field typically shows for hotels or other similar businesses.
Field type: integer
A list of known people associated with or employed by this business.
Field type: nested
Each person may contain:
dateSeen: The date when this person was last seen.
Field type: date
email: The person's email.
Field type: text
name: The person's name.
Field type: text
title: The person's title.
Field type: text
phones
"phones": [
"6192558940",
"6195734102"
]
A list of phone numbers for the business.
Field type: keyword
postalCode
"postalCode": "92014"
The postal or zip code of the business' location.
Field type: keyword
priceRangeCurrency
"priceRangeCurrency": "USD"
The currency associated with the price range fields.
Field type: keyword
priceRangeMin
"priceRangeMin": 25
The lower bound of the business' price range. This field is typically used for retail businesses.
Field type: float
priceRangeMax
"priceRangeMax": 40
The upper bound of the business' price range. This field is typically used for retail businesses.
Field type: float
primaryCategories
"primaryCategories": [
"Retail"
]
A list of standardized categories to which this business belongs. Category values can be found here.
Field type: text
productsOrServices
"productsOrServices": [
"Food",
"Catering"
]
A list of products or services offered by this business.
Field type: text
province
"province": "CA"
The province or state for this business location.
Field type: text
revenueCurrency
"revenueCurrency": "USD"
The currency associated with the revenue fields.
Field type: keyword
revenueMin
"revenueMin": 30000
The minimum known value of the business' annual revenue.
Field type: integer
revenueMax
"revenueMax": 100000
The maximum known value of the business' annual revenue.
Field type: integer
reviews
"reviews": [
{
"date": "2016-02-27T00:00:00Z",
"dateSeen": "2016-05-17T00:00:00Z",
"sourceURLs": [
"https://foursquare.com/v/petes-seafood--sandwich/56391bfacd105fac6c403c63"
],
"text": "best fried ipswich clams in san diego! large portions- not just the 6-8 clams you get at other local eateries. great service! i will be back!",
"username": "Colleen Alarcon"
},
{
"date": "2016-02-15T00:00:00Z",
"dateSeen": [
"2016-05-17T00:00:00Z",
"2016-05-13T00:00:00Z",
],
"sourceURLs": [
"https://foursquare.com/v/petes-seafood--sandwich/56391bfacd105fac6c403c63"
],
"text": "the lobster roll is simply amazing!!!",
"username": "P. Chunyi Hsu"
}
]
A list of reviews for this business location.
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
id: The website ID associated with this review.
Field type: keyword
rating: A 1 to 5 star value for the review.
Field type: double
sourceURLs: A list of URLs where this review was seen.
Field type: keyword
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
A list of room types available at the business' location. This field is typically associated with hotels and other similar businesses.
Field type: nested
Room objects may contain:
amountMin: The minimum price value listed for the room.
Field type: text
amountMax: The maximum price value listed.
Field type: text
capacity: The maximum number of people that can occupy this room.
Field type: text
currency: The currency listed for amountMin and amountMax.
Field type: text
dateSeen: A list of dates when this room was seen.
Field type: text
roomType: A classification for the type of room.
Field type: text
