This is a fields-rich hotels database with 250,286 records from 26,927 cities of 194 countries around the world. Each hotel is comprised of title, rating, description, street address, address region, address country, check in, check out and etc. There are 4 tables closely related with these hotels, they are table amenity with 9 records, 324 detail, room with 168,891 records and 199 room amenity records. It also comes with 4,725,373 images in the 147.33M media set of this data. The whole world hotels data set has 14 tables.
| Name | n3_chennan_hotel_cleartrip_ae |
|---|---|
| Data | 1.91G (+ 0B) |
| Tables | 14 (+ 0) |
| Columns | 62 (+ 0) |
| Table Rows | 12,644,831 (+ 0) |
| Media | 147.33M (+ 0B) |
| Files | 6,965 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| amenity | 9 | value |
100%
|
| city | 26,927 | title |
100%
|
| country |
100%
|
||
| country_id |
100%
|
||
| city_x_hotel | 250,286 | city_id |
100%
|
| hotel_id |
100%
|
||
| country | 194 | title |
100%
|
| detail | 324 | value |
100%
|
| hotel | 250,286 | title |
100%
|
| rating |
100%
|
||
| description |
98.68%
|
||
| street_address |
98.73%
|
||
| address_locality |
25.5%
|
||
| address_region |
99.43%
|
||
| address_country |
99.43%
|
||
| phone |
86.21%
|
||
| check_in |
99.65%
|
||
| check_out |
99.65%
|
||
| total_room |
76.21%
|
||
| hotel_x_amenity | 1,001,117 | hotel_id |
100%
|
| amenity_id |
100%
|
||
| hotel_x_detail | 3,442,226 | hotel_id |
100%
|
| detail_id |
100%
|
||
| hotel_x_room | 1,077,737 | hotel_id |
100%
|
| room_id |
100%
|
||
| image | 4,725,373 | image_url |
100%
|
| hotel_id |
100%
|
||
| room | 168,891 | title |
100%
|
| room_amenity | 199 | value |
100%
|
| room_x_room_amenity | 1,701,262 | room_id |
100%
|
| room_amenity_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
HOTEL_IMAGE
| Size (Bytes) | Files |
|---|---|
| 147.33M | 6,965 |
