This restaurants database has 3,424 records from all over the world and 15,300 restaurants images in the media set. All these restaurants are classified by 40 categories and grouped by 40 international areas (such as Dubai, AE; Ottawa, CA; Dublin, IE; Monterrey, MX; Sydney, NSW, AU; Derlin, DE; Tokyo, JP; Kyoto, JP; Kent, UK; Calgary, CA; etc.). In table restaurant, it consists of title, latitude, longitude, description, address locality, street address, postal code, address country, etc. in each. In the restaurants api, it also has 18,340 details. The whole world restaurants data set has 7 tables.
| Name | n3_chennan_restaurant_opentable_com_internation |
|---|---|
| Data | 21.28M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 43 (+ 0) |
| Table Rows | 74,697 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 40 | location_id |
100%
|
| link_slug |
97.5%
|
||
| metroid |
100%
|
||
| location |
100%
|
||
| category_1_x_restaurant | 3,424 | category_1_id |
100%
|
| restaurant_id |
100%
|
||
| detail | 18,340 | key |
100%
|
| value |
99.97%
|
||
| image | 15,300 | restaurant_id |
100%
|
| location | 40 | title |
100%
|
| restaurant | 3,424 | title |
100%
|
| latitude |
100%
|
||
| longitude |
100%
|
||
| description |
79.67%
|
||
| address_locality |
91.21%
|
||
| street_address |
91.21%
|
||
| address_region |
74.68%
|
||
| postal_code |
91.21%
|
||
| address_country |
91.21%
|
||
| dining_style |
4.64%
|
||
| cuisines |
4.64%
|
||
| restaurant_x_detail | 34,129 | restaurant_id |
100%
|
| detail_id |
100%
|
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
No media sets.
