这是一个来自全国88个城市，4个地区的旅游及景点线路大全，共包含有1,001个公司的18,938个旅游信息及4,040个旅游行程。每个旅游信息中有描述，简介，原价，基础价格，出发地，得分，评论数和月销售量。在旅游行程中包含有日期和总结。整个旅游及景点线路数据库中还有其它5个表，分别是24,724个旅游评价记录，12,068个旅游特色，34,189个旅游政策，20,875个旅游产品以及37,037个行程详情。在图片表中共有29,753张旅游景点图片。该全国旅游景点和路线数据库共有14个表。
This is a tourism information database having 18,938 records with description, short information, price original, price base, place from, month sale count and etc. in each from 1,001 companies in 88 cities of 4 regions of China. In this China tourism database, there are 6 tables mostly related these tourism, they are 24,724 comment records with date, time; 12,068 features with content in each; tourism policy with 34,189 records; tourism production with 20,875 records; tourism schedule with 4,040 records and 37,037 schedule detail records. The whole China tourism data also comes with 29,753 images in the media file. The whole China tourism data set totally has 14 tables.
| Name | n3_lyz_huodong.ctrip.com |
|---|---|
| Data | 132.08M (+ 46.20M) |
| Tables | 14 (+ 0) |
| Columns | 75 (+ 0) |
| Table Rows | 213,552 (+ 0) |
| Media | 1.31G (+ 0B) |
| Files | 24,637 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 88 | city |
100%
|
| region_id |
100%
|
||
| city_x_tourism | 26,273 | tourism_id |
100%
|
| city_id |
100%
|
||
| company | 1,001 | company |
100%
|
| image_slug | 29,753 | tourism_id |
100%
|
| region | 4 | region |
100%
|
| schedule_detail | 37,037 | time |
89.29%
|
| title |
90.91%
|
||
| description |
60.27%
|
||
| tourism_schedule_id |
100%
|
||
| content |
90.67%
|
||
| duration |
84.78%
|
||
| tourism | 18,938 | title |
100%
|
| description |
14.85%
|
||
| short_info |
99.87%
|
||
| price_original |
71.54%
|
||
| price_base |
100%
|
||
| place_from |
67.88%
|
||
| score |
25.55%
|
||
| comment_count |
25.55%
|
||
| month_sale_count |
26.52%
|
||
| tourism_comment | 24,724 | uniq |
100%
|
| comment |
100%
|
||
| tourism_id |
100%
|
||
| date |
100%
|
||
| time |
100%
|
||
| tourism_feature | 12,068 | content |
99.97%
|
| tourism_id |
100%
|
||
| tourism_policy | 34,189 | title |
100%
|
| content |
99.99%
|
||
| tourism_id |
100%
|
||
| tourism_production | 20,875 | title |
100%
|
| price_base |
100%
|
||
| tourism_id |
100%
|
||
| price_original |
61.15%
|
||
| tourism_schedule | 4,040 | date |
24.88%
|
| summary |
100%
|
||
| tourism_id |
100%
|
||
| tourism_x_company | 4,562 | tourism_id |
100%
|
| company_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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.31G | 24,637 |
