本数据库为全球旅游景点票务信息。
本数据集包括了全球6大洲，103个城市，485个景点，2600个票务价格信息。
其中，景点信息包括了景点简介，景点地址，景点联系方式，景点营业时间，景点热度，景点类别以及景点经纬度等信息。
票务信息主要包括了票务价格和票务类别。
此外，此旅游景点数据库还包含了1536张高清景点照片
In the world sights database, there are 485 records by 23 topics from 103 popular cities of 6 regions around the world. Each sight is comprised of description, tag, address, telephone, open time, latitude, longitude and month sale. In table sight ticket, it has 2,600 records with title, price, kind in each. It also comes with 1,589 images and these sights images are stored in the 263.82M media sets. The whole international sights database has 9 tables in total.
| Name | n3_lyz_fliggy.com_piao_international |
|---|---|
| Data | 4.11M (+ 0B) |
| Tables | 9 (+ 0) |
| Columns | 46 (+ 0) |
| Table Rows | 5,596 (+ 0) |
| Media | 263.82M (+ 0B) |
| Files | 1,536 (+ 0) |
Data Samples
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/tickets_information_of_attraction_international_2/ (By Table)
Media Files
- sight_image Bytes: 263.82M / Files: 1,536
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 103 | city |
100%
|
| region_id |
100%
|
||
| city_x_sight | 489 | city_id |
100%
|
| sight_id |
100%
|
||
| image_slug | 1,589 | sight_id |
100%
|
| region | 6 | region |
100%
|
| sight | 485 | description |
84.74%
|
| tag |
2.06%
|
||
| sight |
100%
|
||
| address |
99.38%
|
||
| telepone |
61.86%
|
||
| open_time |
97.32%
|
||
| lat |
100%
|
||
| long |
100%
|
||
| month_sale |
100%
|
||
| sight_ticket | 2,600 | title |
100%
|
| price |
100%
|
||
| sight_id |
100%
|
||
| kind |
100%
|
||
| sight_x_topical | 301 | sight_id |
100%
|
| topical_id |
100%
|
||
| topical | 23 | topical |
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
SIGHT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 263.82M | 1,536 |
