Sold by: Yelp
Deployed on AWS
This trial dataset contains 65,395 Yelp business listings in San Francisco City, available via CSV and JSON formats. Supporting 7B+ annual searches on Yelp, this dataset contains more than 100 business attributes including names, hours, locations, ratings, reviews, photos, etc. This dataset can be used to uncover a variety of insights about business for retail, real estate, finance use cases.
Overview
Leverage Yelp’s First-Party Data to generate business intelligence. This listing contains business attributes, including business names, address, category, hours, ratings and reviews.
This trial dataset provides a wealth of information on 65,395 businesses in San Francisco city, across different industries, including restaurants, financial services, counseling and mental health services, cleaning services, real estate agents, and more.
Yelp data is…
- Trusted - 73M+ monthly unique visitors conduct 7B+ annual searches on Yelp and rely on Yelp to make purchase decisions
- Up to Date - 250K+ business updates every 24 hours and 8M+ updates every month in the U.S. and Canada
- Comprehensive - 11M licensable locations with 265M cumulative reviews in the US and Canada
Key Features:
- Business Information: Each record includes 252 columns including business name, address, contact information, category, and average rating. *Review Texts: The dataset includes the text of individual customer reviews, providing rich qualitative feedback.
- Ratings: Ratings are provided for each business, allowing for sentiment analysis and overall performance evaluation.
- Dates and Times: The dataset includes timestamps for reviews and business operations, enabling temporal analysis and trend identification.
- Additional Attributes: Various attributes like business hours, online reservations, service descriptions, and images provide further context for analysis.
Metadata
Examples include but are not limited to the below attributes. We have more than 100 data attributes and can tailor per your request. For inquiries, please contact AWSDataLicensing@yelp.com
| Description | Value |
|---|---|
| business_id | unique Yelp identifier that represents a unique business location aka Yelp profile page |
| name | name of this business |
| location | location of this business, including address, city, state, zip code and country |
| is_closed | is the location permanently closed |
| categories | list of category title and alias pairs associated with this business |
| phone | phone number of the business |
| hours | regular business hours |
| lat/long | latitude and longitude of the business |
| is_claimed | is this location is claimed by a business owner |
| Yelp_rating | rating for this business (value ranges from 1, 1.5, ... 4.5, 5) |
| review_count | number of recommended reviews for the business |
| review_text | review text, timestamp of the review, rating of the review |
| photo | photo urls of the business |
| MenuURL | url link to the business's menu |
| popularity_score | attribute framing a location’s page views relative to other similar businesses in the same category & geography |
| account | what parent account this location is a part of |
| number_of_locations | number of locations in the same account as this location |
| is_franchise | is the location part of a franchise |
Potential Use Cases
Sales Intelligence
- Discover New Customers: Contact newly opened and opening soon businesses across categories & geos
- Build the Ideal Customer Profile (ICP): Understand operating behavior, including product & services offered at customer locations
- Identify Healthy Businesses: Use page views & consumer traffic metrics as signals for high producing locations
- Enrich CRM Data: Use Yelp as the source of truth for business details and keep data parity across internal systems
Market Intelligence
- Compare Performance of Client vs. Comp Set: Ingest data on full categories and geographies to benchmark performance
- Understand Throughput: Yelp’s proprietary popularity score, rooted in consumer page views, translates to foot traffic
- Inform Site Selection: Understand where brands are opening /closing and which services are offered in each location
- Develop Actionable Insights: e.g., Restaurants offering curbside pick-up & delivery generate 2x revenue than those that do not.
Risk Assessment
- Inform AI & ML-based Underwriting: Integrate Yelp data into underwriting models to determine credit and policy risk of SMBs
- Predict Cash Flow: Yelp’s proprietary engagement metrics are proven proxies for SMB revenue; popularity score in development
- Understand Overall Health of a Business: Leverage Yelp’s dataset to assess a business’s ability to stay in business long-term
- Expedite Form & Application Processing: Use firmographic data from 11m POIs to pre-populate business details on prospects
Social Analytics
- Respond to Reviews: Social listening partners offer scalable ways for brands to respond to reviews via API
- Perform Sentiment Analysis: Understand what consumers are saying by ingesting a location’s most recent 200 Yelp reviews
- Analyze Historical Performance: Star rating and consumer engagement trends; roll-up views of performance across regions
- Push Data to Yelp: Pair a Yelp Knowledge license with a Listing Management integration and push content changes to Yelp
Additional Information
- If you want to find out more about Yelp Knowledge offering, go to our website
- If you are interested in using API for customer analytics & insights, you can find out details from here
- If you want to access to our location data for your application development, you can find out more about Yelp Fusion offering here
About Your Company
Yelp connects people with great local businesses website
Details
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Pricing
This product is available free of charge. Free subscriptions have no end date and may be canceled any time.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Dimensions summary
This listing is a free sample dataset covering all San Francisco points of interest. Pricing has one dimension: Product Access (Units), which grants subscribers access to the product. There is no charge and no commitment term to weigh. You subscribe to unlock the sample data. The single unit-based access model means you do not choose between tiers, location volumes, or usage add-ons. This gives you a way to review the point of interest data before considering a paid data license.
Top-of-mind questions for buyers
It grants access to the free sample dataset covering all San Francisco points of interest. You subscribe to unlock the data. There is no per-location charge and no metering. The single unit simply turns on access so you can review the point of interest data.
The sample covers San Francisco points of interest and firmographic and operational business data. This can include business name, open or close status, and hours of operation. It lets you review the data format and coverage before considering a paid data license.
This sample supports business-to-business use and internal, back-end analysis. There are no display rights tied to this data license. You can use it for internal review and analysis, not for showing the data in public apps or websites.
knowledge.yelp.com
Helpful?
Vendor refund policy
Not applicable - product available free of charge.
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
AWS Data Exchange (ADX)
AWS Data Exchange is a service that helps AWS easily share and manage data entitlements from other organizations at scale.
Additional details
You will receive access to the following data sets.
Data set name | Type | Historical revisions | Future revisions | Sensitive information | Data dictionaries | Data samples |
|---|---|---|---|---|---|---|
San Francisco City Sample | Last 1 revisions | All future revisions | Not included | Not included |
Resources
Vendor resources
Similar products
This sample contains start ratings and 20,000 full review texts from 100 restaurant listings in Miami. This data set is good for social analytics and sentiment analysis.
This sample dataset has intel data products for 100 restaurants in Miami, and more than 1000 columns for each location. It includes all the business attributes and also our unique intel products such as is_franchise, parent ownership, year to year growth rate, online popularity score, that can power sales intel, market intel and use intel use cases.
Use our Yelp dataset to discover and review local businesses, such as restaurants, hotels, and more.
This trial data set provides 5 year historical business data for 100 restaurants in Miami from 2018-2023. You can use the sample to understand how these businesses evolve in the 5 years. If you want more data to analyze trends for a neighborhood, a city, or a business category, please contact our sales team.