Knowledge base | Datafiniti

Business Data Schema

The following table outlines available attributes for our business review data.

Examples show the JSON format of the data.  CSV format is also available. 

Schema NameExampleSearchableNameDescription
address "address": "26 N Main St" Yes Address Street address of an individual business location.
bbbAccredited "bbbAccredited": "True" Yes BBB Accredited Whether or not this business is BBB accredited.
bbbRating "bbbRating": "A" Yes BBB Rating The BBB rating for this business.
categories
"categories": [
 "Real Estate",
 "Real Estate Agents and Managers",
 "Cedar City Real Estate Agent, Residential"
]
Yes Categories A collection of category tags found online for this business.
city "city": "Cedar City" Yes City City of a business.
claimed
"claimed": [
 "businessreviews1.com",
 "localbusinesspages.com"
]
Yes Claimed List of websites where a business has claimed their listing.
country "country": "US" Yes Country Country of a business. Will always be a two-letter country code.
cuisines
"cuisines": [
 "Tacos",
 "Tex-Mex",
 "Mexican"
]
Yes Cuisines A list of cuisines associated with this business. Typically reserved for restaurants.
dateAdded "dateAdded": "2013-01-15T10:01:23Z" Yes Date Added The date this record was added or created.
dateIncorporated "dateIncorporated": "1980-01-01T00:00:00Z" No Date Incorporated The date this business was incorporated.
dateUpdated "dateUpdated": "2013-02-17T01:22:34Z" Yes Date Updated The date this record was most recently updated.
descriptions
"descriptions": [
 {
  "description": "Sonic Drive-In in De Witt, AR is a private company categorized under Drive-In Restaurant.",
  "guid": "5dd27614f9830d957d9546f59447185fdcf61bac5b61e0746ffe086ed3dadd81",
  "sourceURL": "http://www.citysearch.com/location/12345"
 }
]
No Descriptions A list of descriptions for this business.
Description
The description.
GUID
A unique ID for this child object.
Source URL
The source URL of the description.
emails
"emails": [
 "info@company.com",
 "sales@company.com"
]
Yes Emails A list of emails for this business.
encoding "encoding": "UTF-8" Yes Encoding The character encoding for this record.
facebookPageURL "facebookPageURL": "http://facebook.com/ReCellularInc" Yes Facebook URL The primary Facebook URL for this business.
features
"features": [
 {
  "key": "Number of Rooms",
  "value": "432",
  "guid": "7bde8c8617864bd26c67c9653b0dc1b3e361c690b665e88653db531c99a0ed01"
 },
{
  "key": "Catering Availability",
  "value": "Monday - Friday",
  "guid": "716cb9436c102e2996699c8daedb378d5911967f5b688b7fb5e47dff32cdaec4"
 }
]
No Features A list of miscellaneous attributes of the business.
Key
A descriptor for the attribute.
Value
The value of the attribute. Some values may contain an array of information.
financialEvents
"financialEvents": [
 {
  "amount": "USD 15000000",
  "date": "2008-05-01T05:00:00Z",
  "dateSeen": "2015-03-07T08:06:49.253Z",
  "guid": "96f9403503fbf749f6145acb036554dd65593ea96307f535252ee2dd3715c845",
  "investors": "Union Square Ventures, Spark Capital",
  "name": "Series B"
}
]
Existence only Financial Events A list of financial events like investments for this company
Amount
The amount of investment.
Date
The event date.
Date Seen
The date this event was seen by Datafiniti.
GUID
A unique ID for this child object.
Investors
The investment entity involved in the event.
Name
The event name.
hours
"hours": [
 { 
  "day": "Monday - Friday",
  "hour": "8 am - 5 pm",
  "dept": "Sales"
 },
 { 
  "day": "Saturday, Sunday",
  "hour": "Closed",
  "dept": "Sales"
 }
]
No Hours Hour of operation for the business
Day
The day(s) of the week.
Hour
The time of the day.
Department
The department.
images
"images": [
 "http://d306gt4zvs7g2s.cloudfront.net/img/w120h160_v1.jpg",
 "http://ab2498ksd32dkd.cloudfront.net/img/w120h160_v2.jpg"
]
No Images A list of image URLs relevant to this business.
isClosed "isClosed": "true" Yes Is Closed Whether or not this location is closed.
key "key": "us/mi/annarbor/2300traverwooddr/2143842849" Yes Key A unique identifier for this record.
lat "lat": "29.423548" Yes Lat The latitude coordinate for this business.
languages
"languages": [
 "English",
 "Spanish"
]
No Languages A list of languages spoken at this business.
long "long": "-98.48461" Yes Long The longitute coordinate for this business.
mediaEvents
"mediaEvents": [
 {
  "description": "Twitter Closing Its $400M Secondary Offering Tomorrow | TechCrunch",
  "guid": "5dd27614f9830d957d9546f59447185fdcf61bac5b61e0746ffe086ed3dadd81",
  "sourceURL": "http://techcrunch.com/2011/09/08/twitter-closing-its-400m-secondary-offering-tomorrow/"
 }
]
Existence only Media Events A list of media events like articles about this company
Description
A short description of the event.
GUID
A unique ID for this child object.
Source URL
The source URL of the event.
menus
"menus": [
 {
  "categories": "Entrees",
  "dateSeen": "2015-05-01T05:00:00Z",
  "description": "A delicious hamburger with all the fixings",
  "name": "Bison Hamburger",
  "price": "USD 15.00",
  "sourceURL": "http://menuworld.com/restaurant123/menu"
 }
]
Existence only Menu Items A list of menu items at this location or business
Categories
A list of categories for this item
Date Seen
The last time Datafiniti saw this item
Name
The name of the item
Price
The price of the item
Source URL
The source URL of the event.
menuURL "menuURL": "http://www.tacoshack.com/menu" No Menu URL The menu URL for this business. Typically only shown for restaurants, cafes, etc.
naics "naics": "722511" Yes NAICS A collection of NAICS classifications related to this business.
name "name": "Williamson Bros Catering" Yes Name The name of this business.
neighborhood "neigborhood": "Allandale/Brentwood" No Neighborhood The neighborhood of this business.
numEmployees "numEmployees": "12" Yes Number of Employees The number of total employees for this business.
numFields "numFields": "89" Yes Number of Fields The number of fields that are filled out for this record. Fields that have multiple entries (e.g., reviews) are counted more than once.
numRooms "numRooms": "1234" Yes Number of Rooms The number of total rooms at a hotel or other lodging establishment.
parking "parking": "Parking garage available" No Parking Parking details for this business.
paymentTypes
"paymentTypes": [
 "AMEX",
 "Visa",
 "Cash"
]
No Payment Types A list of payment types accepted by this business.
people
"people": [
 {
  "dateSeen": [
    "2015-03-10T08:06:49.253Z",
    "2015-04-10T08:06:49.253Z"
  ]
  "email": "biz@twitter.com",
  "guid": "de6844fc396ac5f1cdeb20283cc9dbaf205eb6106927d49b1cf2611597a07ba9",
  "name": "Biz Stone",
  "title": "Founder"
 }
]
Existence only People A list of people associated with this business.
Date Seen
The date this employee was seen.
email
The email of this employee.
GUID
A unique ID for this child object.
Name
The name of the employee.
Title
The title of the employee.
phones
"phones": [
 "7134103345",
 "7134103350"
]
Yes Phone Numbers A list of phone numbers for this business.
postalCode "postalCode": "30134" Yes Postal Code The postal or zip code for this business.
priceRange "priceRange": "USD 5 - USD 20" Yes Price Range The price range of products, goods, or services offered by this business.
products
"products": [
 "Fabricated beams",
 "Weldings"
]
No Products A list of products offered by the business.
province "province": "NY" Yes Province The state or province for this business.  Where possible, this will be an abbreviation.  E.g., "TX" instead of "Texas".
reservations "reservation": "TRUE" No Reservation A true or false value for whether or not this business takes reservations.
revenue "revenue": "USD 10000000" Yes Revenue An estimate of the annual revenue for the business. Should always be represented in US Dollars.
reviews
"reviews": [
 {
  "date": "2010-07-10T12:00:00Z",
  "dateSeen": "2013-09-21T05:01:37Z", 
  "guid": "17860f631a3eaf802d868dd70ebe17ee64db79d954105ef53d81aa2d9923867a",
  "id": "12345",
  "rating": "3.0",
  "sourceURL": "http://www.reviews.com/WilliamsBrosBBQ",
  "text": "I are here once because it's close to my house and I was in the mood for some barbecue and the smoke coming out of their chimney smelled really good. However the food wasn't so great. Edible, sure, but I think all the smoke flavor went out the chimney because there certainly wasn't any in the barbecue.",
  "title": "Not so great BBQ",
  "userCity": "Atlanta",
  "username": "John M.",
  "userProvince": "GA"
 }
]
Existence only Reviews A list of reviews found for this business.
Date
The date the review was posted.
Date Seen
The date this review was seen
GUID
A unique ID for this child object.
ID
The source URL's id for this review.
Rating
The rating corresponding to this review.
Source URL
The URL where this review was found.
Title
The title for the review, supplied by the reviewer.
Text
The review text.
User City
The city of the reviewer.
Username
The name of the reviewer.
User Province
The state or province of the reviewer.
rooms
"rooms": [ 
 {
  "capacity": "2",
  "dateSeen": [
    "2014-11-06T05:02:47Z",
    "2015-01-06T05:02:47Z"
  ]
  "price": "USD 400.00",
  "roomType": "Double Room"
 }
]
Existence only Rooms A list of rooms available at this location
Capacity
The # of people that can fit in the room.
Date Seen
The date this room was seen.
Price
The price for this room.
Room type
A description for the room
sic "sic": "5610" Yes SIC A collection of SIC classifications for this business.
sourceURLs
"sourceURLs": [
 "http://www.cityviews.com/williamson_bros_bbq.html",
 "http://www.menus.com/Review-Williamson_Bros_BBQ.html"
]
Yes Source URLs A list of source URLs that contributed to this record.
stockSymbol "stockSymbol": "AAPL" Yes Stock Symbol The stock symbol of the business.
technologies
"technologies": [
 "Google Analytics",
 "Magento"
]
Yes Technologies Used A list of technologies used by this company.
twitter "twitter": "WindwardPinot" Yes Twitter Handle The primary twitter username for this business.
type "type": "location" Yes Type The type of record (will always be "location" for business records).
website "website": "http://williamsonbros.com" Yes Website The website for this business
wheelchairAccessible "wheelchairAccessible": "TRUE" No Wheelchair Accessible A true or false value for whether or not this business is wheelchair accessible.
wifiDetails "wifiDetails": "Wi-Fi available" No Wi-Fi Details Wi-Fi details for this business.