In the hotels database, there are 32,516 records from 2,826 cities of 54 states in America. Each record has title, address, overview note, price, check in and check outc. It also contains 195,499 hotels images with URL in the 2.87G media set of this data.
The whole America hotels data set has 6 tables.
| Name | n3_chennan_hotel_hotelguides_com_us |
|---|---|
| Data | 77.08M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 29 (+ 0) |
| Table Rows | 273,637 (+ 0) |
| Media | 10.54M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 2,826 | title |
100%
|
| state |
100%
|
||
| state_id |
100%
|
||
| city_x_hotel | 42,742 | city_id |
100%
|
| hotel_id |
100%
|
||
| hotel | 32,516 | address |
100%
|
| title |
100%
|
||
| check_in |
42.57%
|
||
| check_out |
42.57%
|
||
| overview_note |
99.96%
|
||
| price |
99.98%
|
||
| image | 195,499 | image_url |
100%
|
| hotel_id |
100%
|
||
| state | 54 | 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 |
|---|---|
| 10.54M | 300 |
