This world tourism database is a great one to find more informations of attractions, hotel and other traval informations around the world. It has 22,606 attractions records from 108,546 popular cities. Each attarcation includes title, city, address, phone, type and attraction slug. It also has 219,580 hotels with price, address, phone number, E-mail, commission, room number, index and etc. in each. In this global city tourism data set, there are 6 other tables related with these hotels, they are hotel amenities with 219,580 records, hotel facilities with 33 records, hotel overview with 1,318,554 records, 1,069,964 hotel rate records, 168 hotel recreation records and hotel region with 11 records.
Besides, there are 150,355 local infomations with description, location, nearest street and hotel in each, 239,810 localinfo airport records, 129,868 localinfo dining records and 150,778 localinfo sightseeing records. About rooms in this global city tourism database, it includes 1,030,087 meeting room detail records, 98,248 room event records with meeting capacity, exhibit space, meeting space, largest meeting room and hotel and room name with 122,405 records. In the media sets of this data, it contains the 1.94G hotel cover images and 23.05G hotel photo images.
The whole world attractions with hotels database consists of 33 tables.
| Name | n3_lyz_travelweekly.com |
|---|---|
| Data | 2.12G (+ 0B) |
| Tables | 33 (+ 0) |
| Columns | 156 (+ 0) |
| Table Rows | 12,169,771 (+ 0) |
| Media | 24.99G (+ 0B) |
| Files | 584,744 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
- http://n3.datasn.io/data/api/v1/n3_lyz/global_city_tourism_information_1/ (By Table)
- http://n3.datasn.io/data/api/v1/n3_lyz/globe_hotel_1/ (By Table)
Media Files
- hotel_cover_image Bytes: 1.94G / Files: 181,447
- hotel_photo_detail Bytes: 23.05G / Files: 403,297
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| attraction | 22,606 | title |
99.92%
|
| city |
99.16%
|
||
| address |
95.82%
|
||
| phone |
78.19%
|
||
| type |
100%
|
||
| attraction_slug_id |
100%
|
||
| attraction_slug | 630 | attraction_slug |
100%
|
| city_name |
0%
|
||
| business_service | 14 | title |
100%
|
| business_service_x_hotel | 344,819 | business_service_id |
100%
|
| hotel_id |
100%
|
||
| city | 108,546 | title |
100%
|
| hotel_region_sub_id |
100%
|
||
| city_x_hotel | 2,840,891 | hotel_id |
100%
|
| city_id |
100%
|
||
| hotel | 219,580 | title |
100%
|
| address |
100%
|
||
| class |
43.33%
|
||
| type |
43.33%
|
||
| room_num |
80.51%
|
||
| commission |
50.09%
|
||
| price |
73.72%
|
||
| post |
97.15%
|
||
| index |
92.29%
|
||
| e_mail |
76.58%
|
||
| phone |
96.47%
|
||
| fax |
80.16%
|
||
| latitude |
94.68%
|
||
| longitude |
94.68%
|
||
| toll_free |
30.98%
|
||
| hotel_amenities | 45 | title |
100%
|
| hotel_amenities_x_hotel | 1,390,480 | hotel_amenities_id |
100%
|
| hotel_id |
100%
|
||
| hotel_facilities | 33 | title |
100%
|
| hotel_facilities_x_hotel | 1,010,703 | hotel_facilities_id |
100%
|
| hotel_id |
100%
|
||
| hotel_overview | 1,318,554 | key |
100%
|
| value |
100%
|
||
| hotel_id |
100%
|
||
| hotel_rate | 1,069,964 | key |
100%
|
| value |
93.8%
|
||
| hotel_id |
100%
|
||
| hotel_recreation | 168 | title |
100%
|
| hotel_recreation_x_hotel | 471,551 | hotel_recreation_id |
100%
|
| hotel_id |
100%
|
||
| hotel_region | 11 | title |
100%
|
| hotel_region_sub | 354 | title |
100%
|
| hotel_region_id |
100%
|
||
| letter | 28 | title |
100%
|
| localinfo | 150,355 | description |
70.8%
|
| location |
78.93%
|
||
| nearest_street |
16.73%
|
||
| hotel_id |
100%
|
||
| localinfo_airport | 239,810 | title |
100%
|
| localinfo_airport_x_hotel | 539,915 | localinfo_airport_id |
100%
|
| hotel_id |
100%
|
||
| localinfo_dining | 129,868 | title |
100%
|
| localinfo_dining_x_hotel | 278,408 | localinfo_dining_id |
100%
|
| hotel_id |
100%
|
||
| localinfo_sightseeing | 150,778 | title |
100%
|
| localinfo_sightseeing_x_hotel | 191,567 | localinfo_sightseeing_id |
100%
|
| hotel_id |
100%
|
||
| meeting_room_detail | 1,030,087 | key |
100%
|
| value |
89.11%
|
||
| room_name_id |
100%
|
||
| phone_detail | 18,565 | phone_type |
100%
|
| phone_number |
99.99%
|
||
| attraction_id |
100%
|
||
| phone_mark |
3.65%
|
||
| photos_url | 417,353 | hotel_id |
100%
|
| region_sub_x_letter | 3,435 | hotel_region_sub_id |
100%
|
| letter_id |
100%
|
||
| room_event | 98,248 | meeting_capacity |
100%
|
| exhibit_space |
16.24%
|
||
| meeting_space |
52.92%
|
||
| largest_meeting_room |
43.01%
|
||
| hotel_id |
100%
|
||
| room_name | 122,405 | title |
100%
|
| hotel_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
HOTEL_COVER_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.94G | 181,447 |
HOTEL_PHOTO_DETAIL
| Size (Bytes) | Files |
|---|---|
| 23.05G | 403,297 |
