Yelp businesses reviews
Use our Yelp Businesses Reviews dataset to explore ratings and reviews for local businesses, including restaurants, bars, cafes, and hotels. Popular use cases include analyzing customer sentiment, benchmarking business performance, and gaining insights into local market trends. Use it for enrichment, market research, and lead generation — sample the fields free, then pull the records you need on demand.
Data-fields
22
Total records
204.93M
Price
up to $0.005/record
Min order
$350
Data sample
Description
Statistics
Dictionary
Related
Data sample
| Date | Rating | Content | db_source | timestamp | business_id | Review_image | review_order |
|---|---|---|---|---|---|---|---|
| 25/04/2024 | 1 | Terrible service! I scheduled the plumber to come out on my day off to | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 8 | |
| 22/04/2024 | 1 | they steal from dead people and lie. they refuse to refund money they | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 9 | |
| 13/06/2025 | 1 | Very poor costumer service, Unqualified rude stuff, long wait on phone | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 3 | |
| 04/04/2024 | 1 | Called to submit claim, lady (could not speak good English) lots of no | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 1 | |
| 18/03/2024 | 1 | Avoid by all means, totally a scam company. Tried to report a leak a | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 2 | |
| 15/03/2024 | 1 | terrible customer service.....after hours on hold waiting for a superv | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 3 | |
| 14/03/2024 | 1 | I have been waiting for a refund on my waterline protection program. S | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 4 | |
| 04/03/2024 | 1 | I paid $12.80/month to NJ American water for years for a Water Line Pr | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 5 | |
| 04/03/2024 | 1 | These guys are thieves - RUN - they send out incompetent workmen, such | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 6 | |
| 21/02/2024 | 1 | DO NOT USE THIS COMPANY!!!!!! They will give you the runaround and wil | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 7 | |
| 29/01/2024 | 1 | Worst company out there! They will take your premiums every month for | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | 8 | |
| 02/01/2024 | 1 | This is the worst experience I think I have ever had with a company. I | 1784609420782 | 2026-07-21 | american-water-resources-mount-laurel-2 | ["https://s3-media0.fl.yelpcdn.com/bphoto/rHqM4quy | 9 |
Description
The Yelp businesses reviews dataset standardizes yelp.com data into analysis-ready fields:
business_id, Review_auther, Rating, Date, Content, Review_image, Reactions, Replies, and more.
Use our Yelp Businesses Reviews dataset to explore ratings and reviews for local businesses, including restaurants, bars, cafes, and hotels. Popular use cases include analyzing customer sentiment, benchmarking business performance, and gaining insights into local market trends.
Common uses include enrichment, lead generation, market and competitor research, and feeding downstream AI models.
204.93M records available, refreshed monthly, from $0.005 per record — minimum order $350. Preview a sample free before you buy.
Record updates over time
Data dictionary
| Column name | Description | Type | Fill rate |
|---|---|---|---|
| business_id | A unique identifier for the business | Text |
100%
|
| Review_auther | The author or user who wrote the review | Object |
100%
|
| Rating | The rating given by the reviewer | Number |
100%
|
| Date | The date when the review was posted | Date |
99.23%
|
| Content | The textual content of the review | Text |
100%
|
| Review_image | An image associated with the review | Array |
18.55%
|
| Reactions | Reactions received from other users on the review | Array |
98.46%
|
| Replies | Replies or responses to the review | Array |
9.96%
|
| review_order | The order or sequence of the review among others for the same business | Number |
76.16%
|
| Eelite_status | Indicates whether the author of the review has elite status | Text |
1.3%
|
| check-in_status | Indicates whether the author checked in at the business | Text |
8.3%
|
| business_name | The name of the business being reviewed | Text |
98.4%
|
| url | The URL or link to the business page | Url |
9.92%
|
| recommended_review | Is it recommended | Boolean |
7.04%
|
| unrecommended_reviews | Column indicates if a review is not recommended. Contains boolean values with null values present, where true means the review is not recommended. | Boolean |
0.03%
|
| profile_pic_url | Column stores URL links to user profile pictures. All values in this column are NULL, indicating missing or non-existent profile picture URLs. | Url |
0.17%
|
| sort_by | Column for specifying sorting preferences in queries. Contains NULL values, likely accepts sorting direction indicators or field names for sorting operations. | Text |
0.08%
|
| start_date | Column stores the beginning date of an event or period. Values are dates in standard format, with all values being NULL in the sample. | Date |
0.03%
|
| end_date | Column stores the end date of an event or period. Contains only NULL values in datetime format, indicating all records have no specified end date. | Date |
0.03%
|
| review_id | Text |
4.89%
|
|
| date_iso_format | Date |
4.96%
|
|
| timestamp | Date |
%
|