This is a hotels database with 18,685 hotels by 50 categories around the world. It makes someone who loves to travel life convenient and enjoyable. Each hotel contains of title, city, neighborhood or city name, province, country, description, structure type, hotel type, star rating, latitude, longitude, telephone number, brand name and decoration.
The whole world hotels database consists of 4 tables.
| Name | n3a2_orbitz_com_hotel |
|---|---|
| Data | 31.02M (+ 0B) |
| Tables | 4 (+ 0) |
| Columns | 30 (+ 0) |
| Table Rows | 39,130 (+ 0) |
| Media | 1.85G (+ 0B) |
| Files | 15,333 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 50 | title |
100%
|
| category_1_x_hotel | 20,395 | category_1_id |
100%
|
| hotel_id |
100%
|
||
| hotel | 18,685 | title |
100%
|
| neighborhood_or_city_name |
100%
|
||
| city |
100%
|
||
| province |
95.54%
|
||
| country |
97.06%
|
||
| description |
98.76%
|
||
| structure_type |
100%
|
||
| hotel_type |
100%
|
||
| star_rating |
100%
|
||
| latitude |
97.06%
|
||
| longitude |
97.06%
|
||
| telephonenumber |
99.95%
|
||
| brand_name |
100%
|
||
| decoration |
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 |
|---|---|
| 1.85G | 15,333 |
