Business DataBusiness 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"
careerPageURLtext

A URL pointing to the career page for the business.

Example:

"careerPageURL": "http://www.searocketbistro.com/employment"
categoriestext

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

Example:

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

The city of this business location.

Example:

"city": "San Diego"
claimedtext

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

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

Example:

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

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."
   }
 ]
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",
     "value": [
       "Street Parking",
       "Valet"
     ]
   }
 ]
hoursnested

The hours of operation for this business location.

Each hour object may contain:

Example:

"hours": [
   {
     "day": "Mon - Fri",
     "hour": "11:00 am - 9:00 pm"
   },
   {
     "day": "Sat - Sun",
     "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",
 ]
isClosedtext

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

Example:

"isClosed": "false"
keystext

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 more about 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"
menuPageURLtext

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

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

Example:

"numEmployeesMin": "5"
numEmployeesMaxtext

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

Example:

"numEmployeesMax": "10"
numRoomtext

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

A list of phone numbers for the business.

Example:

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

The postal or zip code of the business' location.

Example:

"postalCode": "92014"
priceRangeCurrencytext

The currency associated with the price range fields.

Example:

"priceRangeCurrency": "USD"
priceRangeMintext

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

Example:

"priceRangeMin": 25
priceRangeMaxtext

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

Example:

"priceRangeMax": 40
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"
revenueCurrencytext

The currency associated with the revenue fields.

Example:

"revenueCurrency": "USD"
revenueMintext

The minimum known value of the business' annual revenue.

Example:

"revenueMin": 30000
revenueMaxtext

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",
     "dateAdded": "2017-03-20T20:45:49Z",
     "dateSeen": [
       "2016-05-17T00:00:00Z",
       "2016-05-13T00: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",
     "dateAdded": "2017-03-20T20:45:49Z",
     "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"
sourceURLstext

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"
websitestext

A list of websites for the business.

Example:

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

The year the business was incorporated.

Example:

"yearIncorporated": 2004
yearOpenedtext

The year the business opened.

Example:

"yearOpened": 2005