In the hotels database, there are 2,183 records from 368 cities of 13 provinces in Canada. Each hotel is comprised of title, address, overview note, price, check in and check out. It also contains 9,433 hotels images in the 332.06M media set of this data.
The whole Canada hotels data set has 6 tables.
| Name | n3_chennan_hotel_hotelguides_com_canada |
|---|---|
| Data | 13.59M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 29 (+ 0) |
| Table Rows | 14,764 (+ 0) |
| Media | 332.06M (+ 0B) |
| Files | 9,433 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 368 | title |
100%
|
| province_id |
100%
|
||
| province |
100%
|
||
| city_x_hotel | 2,767 | city_id |
100%
|
| hotel_id |
100%
|
||
| hotel | 2,183 | title |
100%
|
| check_in |
52.82%
|
||
| check_out |
52.82%
|
||
| address |
100%
|
||
| overview_note |
99.91%
|
||
| price |
99.95%
|
||
| image | 9,433 | image_url |
100%
|
| hotel_id |
100%
|
||
| province | 13 | title |
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
HOTEL_IMAGE
| Size (Bytes) | Files |
|---|---|
| 332.06M | 9,433 |
