In the restaurants database, there are 1,385 records with 2,122 restaurants working times, 201 restaurants menus and 142 more business information. In table restaurant, each record is comprised of title, street address, address locality, postal code, address country, phone number, business website and price. These whole restaurants are from London of the United Kingdom.
The whole UK restaurants data set has 7 tables.
| Name | n3_chennan_restaurant_yelp_com |
|---|---|
| Data | 5.88M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 36 (+ 0) |
| Table Rows | 30,431 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| hour | 2,122 | key |
100%
|
| value |
100%
|
||
| menu | 201 | key |
76.12%
|
| price |
90.05%
|
||
| more_business_info | 142 | key |
100%
|
| value |
100%
|
||
| restaurant | 1,385 | title |
100%
|
| streetaddress |
99.93%
|
||
| addresslocality |
100%
|
||
| postalcode |
99.93%
|
||
| addresscountry |
99.28%
|
||
| phone |
96.39%
|
||
| business_website |
81.88%
|
||
| price |
88.59%
|
||
| restaurant_x_hour | 8,337 | restaurant_id |
100%
|
| hour_id |
100%
|
||
| restaurant_x_menu | 235 | restaurant_id |
100%
|
| menu_id |
100%
|
||
| restaurant_x_more_business_info | 18,009 | restaurant_id |
100%
|
| more_business_info_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.
