本数据库为全球游轮的详细信息。
数据集的两个API主要包括了134条游轮的总体信息，评分信息，餐厅及娱乐设施信息，舱室信息，以及与其相关的2,513条航线旅游公司信息的价格信息。
此外，该国际游轮数据库共有包括了游轮总体照片，餐厅照片，娱乐设施照片，舱室照片在内的36051张高清照片<
两个API保存在一个数据库中
This international ships database has 134 records with description, ship company, weight, capacity, frist voyage, floor, longth, width, speed, overall score, overall mark, service score, service mark, entertainment score, entertainment mark, restaurantment score, etc. in each. All these ships are from 2,513 companies with inner cabin price from, seascape price from, balcony price from, suite price from and destination informations. In table cruise, it has 2,400 cruises with description, line, score overall, comment count, recommend scale, destination and feature in each. Besides, it also contains 439 ship cabin records, ship cabin detail with 4,425 records, 15,596 ship cabin images, ship images with 283 records and etc.
The whole global ships and cruises database totally has 19 tables.
| Name | n3_lyz_cruise.ctrip.com_ship |
|---|---|
| Data | 54.09M (+ 0B) |
| Tables | 19 (+ 0) |
| Columns | 114 (+ 0) |
| Table Rows | 57,075 (+ 0) |
| Media | 1.88G (+ 0B) |
| Files | 36,051 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
Media Files
- ship_cabin_image Bytes: 605.52M / Files: 15,078
- ship_entertainment_image Bytes: 663.97M / Files: 10,868
- ship_image Bytes: 53.19M / Files: 283
- ship_restaurant_image Bytes: 604.07M / Files: 9,822
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| company | 2,513 | inner_cabin_price_from |
89.45%
|
| seascape_price_from |
73.46%
|
||
| balcony_price_from |
87.07%
|
||
| suite_price_from |
70.79%
|
||
| company |
100%
|
||
| destination |
100%
|
||
| cruise | 2,400 | description |
62.5%
|
| title |
100%
|
||
| line |
99.71%
|
||
| score_overall |
85.75%
|
||
| comment_count |
85.75%
|
||
| recommend_scale |
82.71%
|
||
| destination |
100%
|
||
| feature |
12.13%
|
||
| cruise_x_company | 2,513 | cruise_id |
100%
|
| company_id |
100%
|
||
| image_slug | 283 | ship_id |
100%
|
| ship | 134 | ship |
100%
|
| description |
80.6%
|
||
| ship_company_id |
100%
|
||
| weight |
80.6%
|
||
| capacity |
80.6%
|
||
| frist_voyage |
47.76%
|
||
| floor |
80.6%
|
||
| longth |
80.6%
|
||
| width |
80.6%
|
||
| speed |
78.36%
|
||
| overall_score |
78.36%
|
||
| overall_mark |
36.57%
|
||
| service_score |
78.36%
|
||
| service_mark |
34.33%
|
||
| entertainment_score |
78.36%
|
||
| entertainment_mark |
36.57%
|
||
| restaurantment_score |
78.36%
|
||
| restaurantment_mark |
35.07%
|
||
| recommendation_score |
78.36%
|
||
| recommendation_mark |
35.82%
|
||
| ship_cabin | 439 | title |
100%
|
| ship_id |
100%
|
||
| ship_cabin_detail | 4,425 | title |
100%
|
| description |
100%
|
||
| ship_cabin_id |
100%
|
||
| capacity |
100%
|
||
| floor |
98.51%
|
||
| area |
100%
|
||
| window |
100%
|
||
| ship_cabin_image_slug | 15,596 | ship_cabin_detail_id |
100%
|
| ship_company | 27 | ship_company |
100%
|
| ship_entertainment | 2,870 | title |
100%
|
| description |
95.26%
|
||
| ship_id |
100%
|
||
| floor |
100%
|
||
| fee |
100%
|
||
| time |
100%
|
||
| ship_entertainment_image_slug | 11,141 | ship_entertainment_id |
100%
|
| ship_feature | 245 | feature |
100%
|
| ship_id |
100%
|
||
| ship_restaurant | 2,131 | title |
100%
|
| description |
96.48%
|
||
| ship_id |
100%
|
||
| floor |
100%
|
||
| fee |
99.95%
|
||
| time |
100%
|
||
| ship_restaurant_image_slug | 9,958 | ship_restaurant_id |
100%
|
| ship_x_cruise | 2,400 | cruise_id |
100%
|
| ship_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
SHIP_CABIN_IMAGE
| Size (Bytes) | Files |
|---|---|
| 605.52M | 15,078 |
SHIP_ENTERTAINMENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 663.97M | 10,868 |
SHIP_IMAGE
| Size (Bytes) | Files |
|---|---|
| 53.19M | 283 |
SHIP_RESTAURANT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 604.07M | 9,822 |
