本数据库为全球游轮航线信息数据集。
数据集的两个API主要包括了航线名称，游轮名称，航线评分，航线简介，沿途行程景点信息，不同旅游公司的详细的价格信息以及游轮的舱室设施环境信息。
此外，该全球游轮旅游航线数据库包含游轮以及沿途景点照片16832张
两个API保存在一个数据库中
This is a global cruises database with 1,926 records from 98 cities of 6 regions around the world. Each record consists of title, line, description, score overall, comment count, recommend scale, destination and feature. All these cruise lines are offered by 1,929 companies having inner cabin price from, seascape price from, balcony price from, suite price from, company and destination details. There are 115 ships in this data. Beside, it contains 3,612 cruise fee records, 27,217 cruise schedule records with location, arrive, leave, description, etc. and 6,578 room records. It also comes with 17,248 images and these images are in the 755.79M media set.
There are 18 tables in total of this world cruises database.
| Name | n3_lyz_cruise.ctrip.com_line_international |
|---|---|
| Data | 59.30M (+ 0B) |
| Tables | 18 (+ 0) |
| Columns | 105 (+ 0) |
| Table Rows | 112,894 (+ 0) |
| Media | 755.79M (+ 0B) |
| Files | 16,832 (+ 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: 755.79M / Files: 16,832
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bank_attractions | 94 | attractions |
100%
|
| description |
100%
|
||
| bank_content_detail_id |
100%
|
||
| bank_content | 103 | mark |
100%
|
| cruise_schedule_id |
100%
|
||
| bank_content_detail | 103 | title |
100%
|
| description |
91.26%
|
||
| bank_content_id |
100%
|
||
| mark |
100%
|
||
| fee |
100%
|
||
| duration |
11.65%
|
||
| catering |
100%
|
||
| city | 98 | city |
100%
|
| region_id |
100%
|
||
| city_x_cruise | 1,926 | city_id |
100%
|
| cruise_id |
100%
|
||
| company | 1,929 | inner_cabin_price_from |
55.94%
|
| seascape_price_from |
49.92%
|
||
| balcony_price_from |
53.71%
|
||
| suite_price_from |
49.51%
|
||
| company |
63.61%
|
||
| destination |
100%
|
||
| cruise | 1,926 | description |
61.16%
|
| title |
100%
|
||
| line |
99.74%
|
||
| score_overall |
52.08%
|
||
| comment_count |
52.08%
|
||
| recommend_scale |
49.74%
|
||
| destination |
100%
|
||
| feature |
0.1%
|
||
| cruise_fee | 3,612 | title |
100%
|
| value |
100%
|
||
| cruise_id |
100%
|
||
| cruise_schedule | 27,217 | day |
100%
|
| cruise_id |
100%
|
||
| location |
99.99%
|
||
| arrive |
43.69%
|
||
| leave |
43.88%
|
||
| description |
12.28%
|
||
| cruise_x_company | 1,929 | cruise_id |
100%
|
| company_id |
100%
|
||
| cruise_x_ship | 1,926 | cruise_id |
100%
|
| ship_id |
100%
|
||
| image_slug | 17,248 | cruise_id |
100%
|
| region | 6 | region |
100%
|
| room | 6,578 | title |
100%
|
| company_id |
100%
|
||
| room_price | 40,986 | room |
100%
|
| description |
100%
|
||
| type |
100%
|
||
| room_id |
100%
|
||
| original_price |
100%
|
||
| price |
100%
|
||
| schedule_time | 7,098 | time |
100%
|
| cruise_schedule_id |
100%
|
||
| event |
100%
|
||
| ship | 115 | 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 |
|---|---|
| 755.79M | 16,832 |
