In this restaurants database, there are 14,937 records of Canada with title, street address, locality, phone number and overall rating in each. This Canada restaurants data also comes with 70,793 restaurant images in the 4.47G media set. The whole Canada restaurants data set has 5 tables.
| Name | n3_chennan_restaurant_tripadvisor_com_canada |
|---|---|
| Data | 73.31M (+ 0B) |
| Tables | 5 (+ 0) |
| Columns | 22 (+ 0) |
| Table Rows | 189,906 (+ 0) |
| Media | 4.47G (+ 0B) |
| Files | 70,742 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 2,406 | title |
100%
|
| category_1_x_restaurant | 101,770 | category_1_id |
100%
|
| restaurant_id |
100%
|
||
| image | 70,793 | image_url |
100%
|
| restaurant_id |
100%
|
||
| restaurant | 14,937 | title |
100%
|
| street_address |
99.82%
|
||
| locality |
99.98%
|
||
| phone |
95.54%
|
||
| overallrating |
99.98%
|
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 |
|---|---|
| 4.47G | 70,742 |
