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.
| Field Name | Example Value (in JSON) | Description |
|---|---|---|
address | "address": "3382 30th St" | The physical street address for this business location. Field type: text |
categories | "categories": [ "Seafood Restaurant", "Fish & Seafood Retail", "restaurant" "thing" ] | A list of category keywords used for this business across multiple sources. Field type: text |
city | "city": "San Diego" | The city of this business location. Field type: text |
claimed | "claimed": [ "http://yellowpages.com/", "http://foursquare.com/" ] | A list of websites where the business location has been claimed by the business' owner. Field type: keyword |
country | "country": "US" | The two-letter country code for the business location's country. Field type: text |
cuisines | "cuisines": [ "Seafood Restaurants", "Sandwich Shop", "Seafood, Vegetarian / Vegan, Mediterranean" ] | A list of cuisines offered by this business location. This field will only show for restaurants or other eating locations. Field type: text |
dateAdded | "dateAdded": "2016-03-24T09:27:02Z" | The date this business was first added to the business database. Field type: date |
dateUpdated | "dateUpdated": "2017-03-20T20:45:49Z" | The most recent date this business was updated or seen by our system. Field type: date |
descriptions | "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 descriptions for this business from various sources. Each description contains: Field type: nested dateSeen: The date when this description has been seen for this business.Field type: date sourceURLs: A list of source URLs where this specific description was seen.Field type: keyword value: A unique description for this business.Field type: text |
domains | "domains": [ "www.superpages.com", "foursquare.com", "www.zagat.com" ] | A list of each unique domain found in the sourceURLs field.Field type: domain |
emails | "emails": [ "[email protected]" ] | A list of emails belonging to the business. Field type: text |
facebookPageURL | "facebookPageURL": "http://www.facebook.com/pages/Sea-Rocket-Bistro/114213985293774" | A URL pointing to the Facebook page for the business. Field type: text |
faxes | "faxes": [ "3135619486" ] | A list of fax numbers for the business. Field type: text |
features | "features": [ { "key": "attire", "value": [ "Casual Dress" ] }, { "key": "parking", "replace": "true", "value": [ "Street Parking", "Valet" ] } ] | 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. Field type: nested Each feature contains: key: A label for this feature.Field type: text replace: Flag indicating value field is replaced versus appended.Field type: boolean value: A list of possible values for this feature.Field type: text |
geoLocation | "geoLocation": "POINT (-119.5094 37.229366)" | A location value that stores the latitude and longitude in a format that allows geospatial querying. Field type: geo_shape The value is stored as Well-Known Text format, which resembles an (x, y) value, i.e. (longitude latitude). |
hours | "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" }, ] | The hours of operation for this business location. Field type: nested Each hour object may contain: day: The day(s) for this hour of operation.Field type: text dept: The department or business unit related to this hour of operation.Field type: text meal: The mealtime associated with these hours. Typically reserved for restaurant locations.Field type: text hour: The hours of operation.Field type: text |
imageURLs | "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 list of image URLs associated with this business. Field type: text |
isClosed | "isClosed": "false" | A true or false value for whether or not the business location is closed.Field type: boolean |
keys | "keys": [ "us/ca/sandiego/338230thst/2075732923" ] | 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 worksField type: keyword |
languagesSpoken | "languagesSpoken: [ "English", "Spanish" ] | A list of the languages spoken at this business. Field type: text |
latitude | "latitude": "32.740654" | The latitude coordinates for this business location. Field type: text |
longitude | "longitude": "-117.129482" | The longitude coordinates for this business location. Field type: text |
menuPageURL | "menuPageURL": "http://www.citysearch.com/profile/menu/648254644" | A URL pointing to the menu for the business. This field will only show for restaurants or other eating locations. Field type: keyword |
menus | "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" ] } ] | A list of menu items offered by the business. This field will only show for restaurants or other eating locations. Field type: nested Each menu item may include: amountMin: The minimum price value of the item.Field type: float amountMax: The maximum price value of the item. This is typically the same as amountMin, except in cases where a price range is listed.Field type: float category: The menu section this item belongs to.Field type: text currency: The currency listed for amountMin and amountMax.Field type: keyword dateSeen: The date when this item was seen.Field type: date description: A description for the item.Field type: text name: The item's name on the menu.Field type: text sourceURLs: A list of URLs where this item was seen.Field type: keyword |
name | "name": "Pete's Seafood & Sandwich" | The business location's name. Field type: text |
neighborhoods | "neighborhoods": [ "North Park, Western San Diego", "North Park" ] | 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. Field type: text |
numEmployeesMin | "numEmployeesMin": "5" | The lower bound on the number of people possibly employed by this business. Field type: integer |
numEmployeesMax | "numEmployeesMax": "10" | The upper bound on the number of people employed by this business. Field type: integer |
numRoom | "numRoom": 10 | The number of rooms available at this business. This field typically shows for hotels or other similar businesses. Field type: integer |
paymentTypes | "paymentTypes":[ "American Express", "Mastercard", "Visa" ] | A list of payment options accepted by the business. Field type: text |
people | "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 known people associated with or employed by this business. Field type: nested Each person may contain: dateSeen: The date when this person was last seen.Field type: date email: The person's email.Field type: text name: The person's name.Field type: text title: The person's title.Field type: text |
phones | "phones": [ "6192558940", "6195734102" ] | A list of phone numbers for the business. Field type: keyword |
postalCode | "postalCode": "92014" | The postal or zip code of the business' location. Field type: keyword |
priceRangeCurrency | "priceRangeCurrency": "USD" | The currency associated with the price range fields. Field type: keyword |
priceRangeMin | "priceRangeMin": 25 | The lower bound of the business' price range. This field is typically used for retail businesses. Field type: float |
priceRangeMax | "priceRangeMax": 40 | The upper bound of the business' price range. This field is typically used for retail businesses. Field type: float |
primaryCategories | "primaryCategories": [ "Retail" ] | A list of standardized categories to which this business belongs. Category values can be found here. Field type: text |
productsOrServices | "productsOrServices": [ "Food", "Catering" ] | A list of products or services offered by this business. Field type: text |
province | "province": "CA" | The province or state for this business location. Field type: text |
revenueCurrency | "revenueCurrency": "USD" | The currency associated with the revenue fields. Field type: keyword |
revenueMin | "revenueMin": 30000 | The minimum known value of the business' annual revenue. Field type: integer |
revenueMax | "revenueMax": 100000 | The maximum known value of the business' annual revenue. Field type: integer |
reviews | `"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 reviews for this business location. Field type: nested Review objects may contain: date: The date the review was posted.Field type: date dateSeen: The date when the review was seen by Datafiniti.Field type: date doRecommend: A true/false for whether or not the reviewer recommends the product.Field type: boolean id: The website ID associated with this review.Field type: keyword rating: A 1 to 5 star value for the review.Field type: double sourceURLs: A list of URLs where this review was seen.Field type: keyword text: The full (or available) text of the review.Field type: text title: The review's title.Field type: text userCity: The reviewer's city.Field type: text username: The reviewer's username.Field type: text userProvince: The reviewer's province or state.Field type: text |
rooms | "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 room types available at the business' location. This field is typically associated with hotels and other similar businesses. Field type: nested Room objects may contain: amountMin: The minimum price value listed for the room.Field type: text _ amountMax: The maximum price value listed.Field type: text capacity: The maximum number of people that can occupy this room.Field type: text currency: The currency listed for amountMin and amountMax.Field type: text dateSeen: A list of dates when this room was seen.Field type: text roomType: A classification for the type of room.Field type: text |
sic | "sic": "5610" | The SIC code for the business. Learn more about SIC codes. Field type: text |
sourceURLs | "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", ] | A list of URLs used to generate data for this business location. Field type: keyword |
twitter | "twitter": "sdpark2park" | The twitter username for the business. Field type: text |
websites | "websites": [ "http://www.bostonpetes.com/", "http://www.searocketbistro.com" ] | A list of websites for the business. Field type: keyword |
yearIncorporated | "yearIncorporated": 2004 | The year the business was incorporated. Field type: integer |
yearOpened | "yearOpened": 2005 | The year the business opened. Field type: integer |
Updated over 1 year ago