In the hotels database, there are 121,848 records of 7,590 cities from 53 states in the United States. This US hotels database includes 4.69G media file with 214,946 images. Each hotel has title, city, about, feature, location, guest favorite, information, star and address. It also comes with 625 amenity records of these hotels in this data. The whole America hotels data set consists of 7 tables.
| Name | n3a2_priceline_com_hotel |
|---|---|
| Data | 219.14M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 35 (+ 0) |
| Table Rows | 619,046 (+ 0) |
| Media | 4.69G (+ 0B) |
| Files | 192,440 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| amenity | 625 | title |
100%
|
| city | 7,590 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| hotel | 121,848 | title |
100%
|
| city_id |
100%
|
||
| about |
0.02%
|
||
| feature |
0.01%
|
||
| location |
0.01%
|
||
| guest_favorite |
0.01%
|
||
| information |
0.01%
|
||
| star |
6.04%
|
||
| address |
6.22%
|
||
| hotel_x_amenity | 273,984 | hotel_id |
100%
|
| amenity_id |
100%
|
||
| image | 214,946 | hotel_id |
100%
|
| state | 53 | 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 |
|---|---|
| 4.69G | 192,440 |
