本数据库为中国国内出发的游轮航线信息数据集。
数据集的两个API主要包括了航线名称，游轮名称，航线评分，航线简介，沿途行程景点信息，不同旅游公司的详细的价格信息以及游轮的舱室设施环境信息。
此外，该中国游轮旅游航线数据库包含游轮以及沿途景点照片三千多张。
两个API保存在一个数据库中。
In the cruises database, there are 505 companies offering 386 cruises with 87 ships of 9 port cities in China. Each cruise has description, line, title, score overall, comment count, recommend scale, destination and feature. There are 3,537 images and these images are keeped in the 167.60M media sets. The whole China cruises database consists of 17 tables.
| Name | n3_lyz_cruise.ctrip.com_line |
|---|---|
| Data | 15.62M (+ 0B) |
| Tables | 17 (+ 0) |
| Columns | 100 (+ 0) |
| Table Rows | 22,220 (+ 0) |
| Media | 167.60M (+ 0B) |
| Files | 3,470 (+ 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
- image Bytes: 167.60M / Files: 3,470
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bank_attractions | 61 | attractions |
100%
|
| description |
100%
|
||
| bank_content_detail_id |
100%
|
||
| bank_content | 158 | mark |
100%
|
| cruise_schedule_id |
100%
|
||
| bank_content_detail | 223 | title |
100%
|
| description |
27.35%
|
||
| bank_content_id |
100%
|
||
| mark |
100%
|
||
| fee |
87%
|
||
| duration |
45.29%
|
||
| catering |
100%
|
||
| company | 505 | inner_cabin_price_from |
87.92%
|
| seascape_price_from |
60.4%
|
||
| balcony_price_from |
88.12%
|
||
| suite_price_from |
49.9%
|
||
| company |
100%
|
||
| destination |
100%
|
||
| cruise | 386 | description |
76.17%
|
| title |
100%
|
||
| line |
98.96%
|
||
| score_overall |
79.27%
|
||
| comment_count |
79.27%
|
||
| recommend_scale |
79.27%
|
||
| destination |
100%
|
||
| feature |
56.99%
|
||
| cruise_fee | 766 | title |
100%
|
| value |
100%
|
||
| cruise_id |
100%
|
||
| cruise_schedule | 4,719 | day |
100%
|
| cruise_id |
100%
|
||
| location |
99.7%
|
||
| arrive |
33.06%
|
||
| leave |
33.14%
|
||
| description |
76.37%
|
||
| cruise_x_company | 520 | cruise_id |
100%
|
| company_id |
100%
|
||
| cruise_x_ship | 386 | cruise_id |
100%
|
| ship_id |
100%
|
||
| image_slug | 3,537 | cruise_id |
100%
|
| port_city | 9 | city |
100%
|
| port_city_x_cruise | 394 | port_city_id |
100%
|
| cruise_id |
100%
|
||
| room | 1,501 | title |
100%
|
| company_id |
100%
|
||
| room_price | 8,297 | room |
100%
|
| description |
100%
|
||
| type |
83.23%
|
||
| room_id |
100%
|
||
| original_price |
100%
|
||
| price |
100%
|
||
| schedule_time | 671 | time |
100%
|
| cruise_schedule_id |
100%
|
||
| event |
100%
|
||
| ship | 87 | ship |
100%
|
| ship_company |
100%
|
||
| description |
0%
|
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
IMAGE
| Size (Bytes) | Files |
|---|---|
| 167.60M | 3,470 |
