Yelp Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.


Name	Description
AutocompleteBusinesses	A list of business autocomplete suggestions based on the input text.
AutocompleteTerms	A list of term autocomplete suggestions based on the input text.
BusinessDetails	Returns detailed business content.
BusinessMatch	This table lets you match business data from other sources against businesses on Yelp, based on provided business information. For example, if you know a business's exact address and name, and you want to find that business and only that business on Yelp.
BusinessSearch	Returns up to 1000 businesses based on the provided search criteria. It has some basic information about the business.
Categories	returns all Yelp business categories across all locales by default.
EventSearch	Returns events based on the provided search criteria.
FeaturedEvent	Returns the featured event for a given location. Featured events are chosen by Yelp's community managers.
PhoneSearch	Returns a list of businesses based on the provided phone number.
Reviews	Returns up to three review excerpts for a given business ordered by Yelp's default sort order.
TransactionSearch	Returns a list of businesses which support food delivery transactions. Currently, this table only supports food delivery in the US.