This database comes with 204,265 hotels in 2,578 cities from 176 locations around the world.
Each hotel record consists of price, description, hotel location, street address, address locality and address country. There are 3 tables closely related with these hotels, they are table amenity with 376 records, 2,341 hotel policy records and 5,889,704 images in the 233.64M media set.
The whole world hotels data set has 10 tables.
| Name | n3_chennan_hotel_priceline_com |
|---|---|
| Data | 1.77G (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 46 (+ 0) |
| Table Rows | 10,570,604 (+ 0) |
| Media | 233.64M (+ 0B) |
| Files | 10,000 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| amenity | 376 | value |
100%
|
| city | 2,578 | title |
100%
|
| location_id |
100%
|
||
| location |
100%
|
||
| city_x_hotel | 204,265 | city_id |
100%
|
| hotel_id |
100%
|
||
| hotel | 204,265 | title |
100%
|
| price |
77.01%
|
||
| description |
100%
|
||
| hotel_location |
91.68%
|
||
| street_address |
91.68%
|
||
| address_locality |
100%
|
||
| address_country |
96.9%
|
||
| hotel_policy | 2,341 | key |
89.62%
|
| value |
100%
|
||
| hotel_x_amenity | 3,869,543 | hotel_id |
100%
|
| amenity_id |
100%
|
||
| hotel_x_hotel_policy | 397,356 | hotel_id |
100%
|
| hotel_policy_id |
100%
|
||
| image | 5,889,704 | alt |
100%
|
| hotel_id |
100%
|
||
| location | 176 | 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 |
|---|---|
| 233.64M | 10,000 |
