This is a fields-rich vacation rentals database of 104,437 records categorized into 110 classifications by cities around the world. Each record has title, price, detail, bedroom, bathroom, sleep, house type, tripadvisor property number, response rate, update and language spoken.
In the whole world vacation rentals data, there are 7 vacation rentals related tables, they are entertainment table with 8 records, kitchen table with 7 records, outdoor table with 11 records, phone or internet talbe with 4 records, pool spa table with 9 records, general table with 13 records and property feature table with 11 records. It also comes with 2,503,640 vacation rental images in the 1.80G media set of this database.
The whole world vacation rentals data set consists of 20 tables.
| Name | n3_chennan_house_flipkey_com |
|---|---|
| Data | 772.09M (+ 0B) |
| Tables | 20 (+ 0) |
| Columns | 83 (+ 0) |
| Table Rows | 4,594,824 (+ 0) |
| Media | 883.37K (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 110 | title |
100%
|
| category_2 | 523 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_2_x_vacation_retal | 443,874 | category_2_id |
100%
|
| vacation_retal_id |
100%
|
||
| entertainment | 8 | value |
100%
|
| general | 13 | value |
100%
|
| image | 2,503,640 | image_url |
100%
|
| vacation_retal_id |
100%
|
||
| kitchen | 7 | value |
100%
|
| outdoor | 11 | value |
100%
|
| phone_or_internet | 4 | value |
100%
|
| pool_spa | 9 | value |
100%
|
| property_feature | 11 | value |
100%
|
| vacation_retal | 104,437 | title |
99.96%
|
| price |
100%
|
||
| detail |
100%
|
||
| bedroom |
96.49%
|
||
| bathroom |
99.58%
|
||
| sleep |
99.99%
|
||
| house_type |
100%
|
||
| tripadvisor_property_no |
100%
|
||
| response_rate |
77.52%
|
||
| update |
100%
|
||
| language_spoken |
100%
|
||
| vacation_retal_x_entertainment | 224,549 | vacation_retal_id |
100%
|
| entertainment_id |
100%
|
||
| vacation_retal_x_general | 426,829 | vacation_retal_id |
100%
|
| general_id |
100%
|
||
| vacation_retal_x_kitchen | 359,629 | vacation_retal_id |
100%
|
| kitchen_id |
100%
|
||
| vacation_retal_x_outdoor | 175,345 | vacation_retal_id |
100%
|
| outdoor_id |
100%
|
||
| vacation_retal_x_phone_or_internet | 138,255 | vacation_retal_id |
100%
|
| phone_or_internet_id |
100%
|
||
| vacation_retal_x_pool_spa | 95,381 | vacation_retal_id |
100%
|
| pool_spa_id |
100%
|
||
| vacation_retal_x_property_feature | 122,189 | vacation_retal_id |
100%
|
| property_feature_id |
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
VACATION_RETAL_IMAGE
| Size (Bytes) | Files |
|---|---|
| 883.37K | 300 |
