Business Data SchemaBusiness Data Schema

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.

addresstext

The physical street address for this business location.

Example:

"address": "3382 30th St"
categoriestext

A list of category keywords used for this business across multiple sources.

Example:

"categories": [
     "Seafood Restaurant",
     "Fish & Seafood Retail",
     "restaurant"
     "thing"
 ]
citytext

The city of this business location.

Example:

"city": "San Diego"
claimedkeyword

A list of websites where the business location has been claimed by the business' owner.

Example:

"claimed": [
   "http://yellowpages.com/",
   "http://foursquare.com/"
 ]
countrytext

The two-letter country code for the business location's country.

Example:

"country": "US"
cuisinestext

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"
 ]
dateAddeddate

The date this business was first added to the business database.

Example:

"dateAdded": "2016-03-24T09:27:02Z"
dateUpdateddate

The most recent date this business was updated or seen by our system.

Example:

"dateUpdated": "2017-03-20T20:45:49Z"
descriptionsnested

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."
   }
 ]
domainsdomain

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

Example:

"domains": [
   "www.superpages.com",
   "foursquare.com",
   "www.zagat.com"
 ]
emailstext

A list of emails belonging to the business.

Example:

"emails": [
   "elena@searocketbistro.com"
 ]
facebookPageURLtext

A URL pointing to the Facebook page for the business.

Example:

"facebookPageURL": "http://www.facebook.com/pages/Sea-Rocket-Bistro/114213985293774"
faxestext

A list of fax numbers for the business.

Example:

"faxes": [
   "3135619486"
 ]
featuresnested

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"
     ]
   }
 ]
geoLocationgeo_shape

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)"
hoursnested

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"
   },
 ]
imageURLstext

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",
 ]
isClosedboolean

A true or false value for whether or not the business location is closed.

Example:

"isClosed": "false"
keyskeyword

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"
 ]
languagesSpokentext

A list of the languages spoken at this business.

Example:

"languagesSpoken: [
   "English",
   "Spanish"
 ]
latitudetext

The latitude coordinates for this business location.

Example:

"latitude": "32.740654"
longitudetext

The longitude coordinates for this business location.

Example:

"longitude": "-117.129482"
menuPageURLkeyword

A URL pointing to the menu for the business. This field will only show for restaurants or other eating locations.

Example:

"menuPageURL": "http://www.citysearch.com/profile/menu/648254644"
menusnested

A list of menu items offered by the business. This field will only show for restaurants or other eating locations.

Each menu item may include:

Example:

"menus": [
   {
     "amountMin": 12,
     "amountMax": 12,
     "category": "sample menu",
     "currency": "USD",
     "dateSeen": "2017-03-22T01:03:56Z",
     "name": "Fish Carpaccio",
     "sourceURLs": [
   "http://www.superpages.com/bp/san-diego-ca/petes-seafood-sandwich-L2615943735.htm"
     ]
   },
   {
     "amountMin": 7,
     "amountMax": 7,
     "category": "sample menu",
     "currency": "USD",
     "dateSeen": [
       "2017-03-22T01:03:56Z"
     ],
     "description": "A dense bread pudding recipe served cold with butterscotch sauce",
     "name": "Seasonal Pumpkin Bread Pudding",
     "sourceURLs": [
   "http://www.superpages.com/bp/san-diego-ca/petes-seafood-sandwich-L2615943735.htm"
     ]
   }
 ]
nametext

The business location's name.

Example:

"name": "Pete's Seafood & Sandwich"
neighborhoodstext

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"
 ]
numEmployeesMininteger

The lower bound on the number of people possibly employed by this business.

Example:

"numEmployeesMin": "5"
numEmployeesMaxinteger

The upper bound on the number of people employed by this business.

Example:

"numEmployeesMax": "10"
numRoominteger

The number of rooms available at this business. This field typically shows for hotels or other similar businesses.

Example:

"numRoom": 10
paymentTypestext

A list of payment options accepted by the business.

Example:

"paymentTypes":[
   "American Express",
   "Mastercard",
   "Visa"
 ]
peoplenested

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"
   }
 ]
phoneskeyword

A list of phone numbers for the business.

Example:

"phones": [
   "6192558940",
   "6195734102"
 ]
postalCodekeyword

The postal or zip code of the business' location.

Example:

"postalCode": "92014"
priceRangeCurrencykeyword

The currency associated with the price range fields.

Example:

"priceRangeCurrency": "USD"
priceRangeMinfloat

The lower bound of the business' price range. This field is typically used for retail businesses.

Example:

"priceRangeMin": 25
priceRangeMaxfloat

The upper bound of the business' price range. This field is typically used for retail businesses.

Example:

"priceRangeMax": 40
primaryCategoriestext

A list of standardized categories to which this business belongs. Category values can be found here.

Example:

"primaryCategories": [
   "Retail"
 ]
productsOrServicestext

A list of products or services offered by this business.

Example:

"productsOrServices": [
   "Food",
   "Catering"
 ]
provincetext

The province or state for this business location.

Example:

"province": "CA"
revenueCurrencykeyword

The currency associated with the revenue fields.

Example:

"revenueCurrency": "USD"
revenueMininteger

The minimum known value of the business' annual revenue.

Example:

"revenueMin": 30000
revenueMaxinteger

The maximum known value of the business' annual revenue.

Example:

"revenueMax": 100000
reviewsnested

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"
   }
 ]\
roomsnested

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"
   }
 ]
sictext

The SIC code for the business. Learn more about SIC codes.

Example:

"sic": "5610"
sourceURLskeyword

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",
 ]
twittertext

The twitter username for the business.

Example:

"twitter": "sdpark2park"
websiteskeyword

A list of websites for the business.

Example:

"websites": [
   "http://www.bostonpetes.com/",
   "http://www.searocketbistro.com"
 ]
yearIncorporatedinteger

The year the business was incorporated.

Example:

"yearIncorporated": 2004 
yearOpenedinteger

The year the business opened.

Example:

"yearOpened": 2005