| 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) |
| Last Commit | 2019-09-21 09:26:24 (+ 197 d) |
This 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. From this database, 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 from this 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 database, 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.
| 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%
|
| Size (Bytes) | Files |
|---|---|
| 1.94G | 181,447 |
| Size (Bytes) | Files |
|---|---|
| 23.05G | 403,297 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2019-09-21 (+ 197 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2019-03-07 (+ 43 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2019-01-23 (+ 44 d) | 2.12G (- 0.18G) | 33 (+ 0) | 156 (- 1) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-12-09 (+ 29 d) | 2.30G (+ 126.50M) | 33 (+ 0) | 157 (+ 2) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-11-09 (+ 27 d) | 2.18G (+ 1.24G) | 33 (+ 0) | 155 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-10-12 (+ 29 d) | 0.94G (+ 0B) | 33 (+ 0) | 155 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-09-13 (+ 34 d) | 0.94G (+ 0B) | 33 (+ 0) | 155 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-08-09 (+ 27 d) | 0.94G (+ 0B) | 33 (+ 0) | 155 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-07-12 (+ 31 d) | 0.94G (+ 0B) | 33 (+ 0) | 155 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-06-10 (+ 31 d) | 0.94G (+ 3.53M) | 33 (+ 1) | 155 (+ 6) | 12,169,771 (+ 19,136) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-05-10 (+ 28 d) | 0.94G (+ 0B) | 32 (+ 0) | 149 (+ 0) | 12,150,635 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2018-04-11 (+ 73 d) | 0.94G (+ 0B) | 32 (+ 0) | 149 (+ 0) | 12,150,635 (+ 0) | 24.99G (+ 18.24G) | 584,744 (+ 319,322) |
| 2018-01-27 (+ 29 d) | 0.94G (+ 537.45M) | 32 (+ 0) | 149 (+ 0) | 12,150,635 (- 216) | 6.75G (+ 4.81G) | 265,422 (+ 83,974) |
| 2017-12-29 (+ 20 d) | 420.95M (+ 151.16M) | 32 (- 1) | 149 (- 4) | 12,150,851 (+ 2,119,852) | 1.94G (+ 0B) | 181,448 (+ 0) |
| 2017-12-08 (+ 9 d) | 269.80M (+ 30.78M) | 33 (- 1) | 153 (- 5) | 10,030,999 (+ 1,451,844) | 1.94G (+ 0B) | 181,448 (+ 0) |
| 2017-11-28 (+ 19 d) | 239.02M (+ 8.36M) | 34 (+ 0) | 158 (+ 0) | 8,579,155 (+ 503,286) | 1.94G (+ 1.94G) | 181,448 (+ 181,446) |
| 2017-11-09 (+ 10 d) | 230.66M (+ 0B) | 34 (+ 0) | 158 (+ 0) | 8,075,869 (+ 2,395,029) | 52.90K (+ 0B) | 2 (+ 0) |
| 2017-10-29 (+ 19 d) | 230.66M (+ 72.48M) | 34 (- 1) | 158 (+ 6) | 5,680,840 (+ 3,514,280) | 52.90K (+ 0B) | 2 (+ 0) |
| 2017-10-09 | 158.17M | 35 | 152 | 2,166,560 | 52.90K | 2 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
