Business Data Schema
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.
The physical street address for this business location.
Example:
"address": "3382 30th St"
A list of category keywords used for this business across multiple sources.
Example:
"categories": [
"Seafood Restaurant",
"Fish & Seafood Retail",
"restaurant"
"thing"
]
The city of this business location.
Example:
"city": "San Diego"
A list of websites where the business location has been claimed by the business' owner.
Example:
"claimed": [
"http://yellowpages.com/",
"http://foursquare.com/"
]
The two-letter country code for the business location's country.
Example:
"country": "US"
A list of cuisines offered by this business location. This field will only show for restaurants or other eating locations.
Example:
"cuisines": [
"Seafood Restaurants",
"Sandwich Shop",
"Seafood, Vegetarian / Vegan, Mediterranean"
]
The date this business was first added to the business database.
Example:
"dateAdded": "2016-03-24T09:27:02Z"
The most recent date this business was updated or seen by our system.
Example:
"dateUpdated": "2017-03-20T20:45:49Z"
A list of descriptions for this business from various sources. Each description contains:
Example:
"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 each unique domain found in the sourceURLs field.
Example:
"domains": [
"www.superpages.com",
"foursquare.com",
"www.zagat.com"
]
A list of emails belonging to the business.
Example:
"emails": [
"elena@searocketbistro.com"
]
A URL pointing to the Facebook page for the business.
Example:
"facebookPageURL": "http://www.facebook.com/pages/Sea-Rocket-Bistro/114213985293774"
A list of fax numbers for the business.
Example:
"faxes": [
"3135619486"
]
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.
Each feature contains:
Example:
"features": [
{
"key": "attire",
"value": [
"Casual Dress"
]
},
{
"key": "parking",
"replace": "true",
"value": [
"Street Parking",
"Valet"
]
}
]
A location value that stores the latitude and longitude in a format that allows geospatial querying.
The value is stored as Well-Known Text format, which resembles an (x, y) value, i.e. (longitude latitude).
Example:
"geoLocation": "POINT (-119.5094 37.229366)"
The hours of operation for this business location.
Each hour object may contain:
Example:
"hours": [
{
"day": "Mon - Fri",
"dept": "Sales",
"hour": "11:00 am - 9:00 pm"
},
{
"day": "Sat - Sun",
"meal": "Brunch",
"hour": "11:00 am - 10:00 pm"
},
]
A list of image URLs associated with this business.
Example:
"imageURLs": [
"https://irs0.4sqi.net/img/general/200x200/118688231_EmfdW9_8FpBrxsa5WDVektvkubj-XpCW5ln6s6pnClo.jpg",
"https://irs0.4sqi.net/img/general/200x200/1556291_gjOF8nnudHh_ICSWXoTs75_FxtcKt25nZtwbqjaHtKQ.jpg",
]
A true or false value for whether or not the business location is closed.
Example:
"isClosed": "false"
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
Example:
"keys": [
"us/ca/sandiego/338230thst/2075732923"
]
A list of the languages spoken at this business.
Example:
"languagesSpoken: [
"English",
"Spanish"
]
The latitude coordinates for this business location.
Example:
"latitude": "32.740654"
The longitude coordinates for this business location.
Example:
"longitude": "-117.129482"
The business location's name.
Example:
"name": "Pete's Seafood & Sandwich"
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.
Example:
"neighborhoods": [
"North Park, Western San Diego",
"North Park"
]
The lower bound on the number of people possibly employed by this business.
Example:
"numEmployeesMin": "5"
The upper bound on the number of people employed by this business.
Example:
"numEmployeesMax": "10"
The number of rooms available at this business. This field typically shows for hotels or other similar businesses.
Example:
"numRoom": 10
A list of payment options accepted by the business.
Example:
"paymentTypes":[
"American Express",
"Mastercard",
"Visa"
]
A list of known people associated with or employed by this business.
Each person may contain:
Example:
"people": [
{
"dateSeen": "2014-08-22T03:48:23Z",
"name": "Cody Jones",
"title": "Owner"
},
{
"dateSeen": [
"2014-08-22T03:48:23Z"
],
"name": "Chaseee Ewing",
"title": "Head Chef"
}
]
A list of phone numbers for the business.
Example:
"phones": [
"6192558940",
"6195734102"
]
The postal or zip code of the business' location.
Example:
"postalCode": "92014"
The currency associated with the price range fields.
Example:
"priceRangeCurrency": "USD"
The lower bound of the business' price range. This field is typically used for retail businesses.
Example:
"priceRangeMin": 25
The upper bound of the business' price range. This field is typically used for retail businesses.
Example:
"priceRangeMax": 40
A list of standardized categories to which this business belongs. Category values can be found here.
Example:
"primaryCategories": [
"Retail"
]
A list of products or services offered by this business.
Example:
"productsOrServices": [
"Food",
"Catering"
]
The province or state for this business location.
Example:
"province": "CA"
The currency associated with the revenue fields.
Example:
"revenueCurrency": "USD"
The minimum known value of the business' annual revenue.
Example:
"revenueMin": 30000
The maximum known value of the business' annual revenue.
Example:
"revenueMax": 100000
A list of reviews for this business location.
Review objects may contain:
Example:
"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 room types available at the business' location. This field is typically associated with hotels and other similar businesses.
Room objects may contain:
Example:
"rooms": [
{
"amountMin": 90,
"amountMax": 90,
"capacity": 3,
"currency": "USD",
"dateSeen": [
"2016-05-04T00:00:00Z"
],
"roomType": "Standard Room"
},
{
"amountMin": 119,
"amountMax": 119,
"capacity": 4,
"currency": "USD",
"dateSeen": [
"2016-05-04T00:00:00Z"
],
"roomType": "Superior Room"
}
]
A list of URLs used to generate data for this business location.
Example:
"sourceURLs": [
"http://www.superpages.com/bp/san-diego-ca/petes-seafood-sandwich-L2615943735.htm",
"https://foursquare.com/v/petes-seafood--sandwich/56391bfacd105fac6c403c63",
"https://www.zagat.com/r/petes-seafood-and-sandwich-san-diego",
]
The twitter username for the business.
Example:
"twitter": "sdpark2park"
A list of websites for the business.
Example:
"websites": [
"http://www.bostonpetes.com/",
"http://www.searocketbistro.com"
]
The year the business was incorporated.
Example:
"yearIncorporated": 2004
The year the business opened.
Example:
"yearOpened": 2005