This is a database of accommodations with 3,708 records by 13 categories (self-catering, bed and breakfast, guest houses, lodges, hotels, safari, tented camps, camping and caravanning,backpackers, country houses, resorts, boutique hotels, houseboats and mobile camps). Each accommodation is comprised of title, price, type, sleep, description and etc. It also has 729 details, facility with 18 records, grading with 11 records and 31 language spoken records. In the media file of this accommodations database, there are 26,248 images of houses.
The whole accommodations data set consists of 13 tables.
| Name | n3_chennan_accommodation_safarinow_com_1 |
|---|---|
| Data | 20.34M (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 52 (+ 0) |
| Table Rows | 77,842 (+ 0) |
| Media | 18.15M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| accommodation | 3,708 | title |
100%
|
| price |
99.68%
|
||
| type |
100%
|
||
| sleep |
100%
|
||
| description |
99.76%
|
||
| important_information |
47.71%
|
||
| accommodation_x_detail | 19,899 | accommodation_id |
100%
|
| detail_id |
100%
|
||
| accommodation_x_facility | 17,130 | accommodation_id |
100%
|
| facility_id |
100%
|
||
| accommodation_x_grading | 153 | accommodation_id |
100%
|
| grading_id |
100%
|
||
| accommodation_x_languages_spoken | 6,189 | accommodation_id |
100%
|
| languages_spoken_id |
100%
|
||
| category_1 | 13 | title |
100%
|
| category_1_x_accommodation | 3,713 | category_1_id |
100%
|
| accommodation_id |
100%
|
||
| detail | 729 | key |
100%
|
| value |
99.86%
|
||
| facility | 18 | value |
100%
|
| grading | 11 | value |
100%
|
| image | 26,248 | image_url |
100%
|
| accommodation_id |
100%
|
||
| languages_spoken | 31 | value |
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
ACCOMMODATION_IMAGE
| Size (Bytes) | Files |
|---|---|
| 18.15M | 300 |
