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 (most of them) may not contain every field.

Business Operation Fields

hoursnested

The hours of operation for this business location.

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

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

Example:

"isClosed": false
languagesSpokentext

A list of the languages spoken at this business.

Example:

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

A list of payment options accepted by the business.

Example:

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

A list of products or services offered by this business.

Example:

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

Classification Fields

categoriestext

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

Example:

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

The business location's name.

Example:

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

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

Example:

"primaryCategories": [
  "Retail"
]
sictext

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

Example:

"sic": "5610"
yearIncorporatedinteger

The year the business was incorporated.

Example:

"yearIncorporated": 2004
yearOpenedinteger

The year the business opened.

Example:

"yearOpened": 2005

Contact Fields

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

A list of phone numbers for the business.

Example:

"phones": [
  "6192558940",
  "6195734102"
]
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"
]

Firmographic Fields

numEmployeesMaxinteger

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

numEmployeesMininteger

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

peoplenested

A list of known people associated with or employed by this business.

revenueCurrencykeyword

The currency associated with the revenue fields.

revenueMaxinteger

The maximum known value of the business' annual revenue.

revenueMininteger

The minimum known value of the business' annual revenue.

Geographic Fields

addresstext

The physical street address for this business location.

citytext

The city of this business location.

countrytext

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

geoLocationgeo_shape

A location value that stores the latitude and longitude in a format that allows geospatial querying.

latitudetext

The latitude coordinates for this business location.

longitudetext

The longitude coordinates for this business location.

neighborhoodstext

A list of neighborhoods where this business is located.

postalCodekeyword

The postal or zip code of the business' location.

provincetext

The province or state for this business location.

Generic Fields

dateAddeddate

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

dateUpdateddate

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

descriptionsnested

A list of descriptions for this business from various sources.

featuresnested

A list of features associated with this business location.

keyskeyword

A list of internal Datafiniti identifiers for this business.

Hospitality Fields

numRoominteger

The number of rooms available at this business.

roomsnested

A list of room types available at the business' location.

Restaurant Fields

cuisinestext

A list of cuisines offered by this business location.

menuPageURLkeyword

A URL pointing to the menu for the business.

menusnested

A list of menu items offered by the business.

priceRangeCurrencykeyword

The currency associated with the price range fields.

priceRangeMaxfloat

The upper bound of the business' price range.

priceRangeMinfloat

The lower bound of the business' price range.

Reviews Fields

reviewsnested

A list of reviews for this business location.

Source Fields

claimedkeyword

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

domainsdomain

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

imageURLstext

A list of image URLs associated with this business.

sourceURLskeyword

A list of URLs used to generate data for this business location.