In this restaurants database, there are 82,126 records by 22,139 categories from the United States. Each record is comprised of title, street address, locality, phone number and over all rating. This US restaurants data also comes with 448,632 restaurants images with URL in the 11.51G media set. The whole America restaurants data set has 5 tables.
| Name | n3_chennan_restaurant_tripadvisor_com_us |
|---|---|
| Data | 226.31M (+ 0B) |
| Tables | 5 (+ 0) |
| Columns | 22 (+ 0) |
| Table Rows | 1,363,652 (+ 0) |
| Media | 17.82M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 22,139 | title |
100%
|
| category_1_x_restaurant | 810,755 | category_1_id |
100%
|
| restaurant_id |
100%
|
||
| image | 448,632 | image_url |
100%
|
| restaurant_id |
100%
|
||
| restaurant | 82,126 | title |
100%
|
| street_address |
99.91%
|
||
| locality |
99.99%
|
||
| phone |
96.66%
|
||
| overallrating |
99.99%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
RESTAURANT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 17.82M | 300 |
