| Name | n3_lyz_travelweekly.com |
|---|---|
| Data | 2.40G (- 1.29G) |
| Tables | 9 (- 33) |
| Columns | 111 (- 187) |
| Table Rows | 2,675,304 (- 12,136,007) |
| Media | 61.83G (- 22.70G) |
| Files | 1,106,297 (- 542,790) |
| Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
This is a world hotels database including 185,816 public houses of 43,017 popular cities from 10 regions (Africa, Asia, Australia & South Pacific, Canada, Caribbean, Europe, Latin America, Mexico, Middle East & United States). Each hotel has address detail, rate policy, start from, suit, credit cards, reservation policy, included meals, deposit policy, cancellation policy, restrictions, discounts offered, amenities, on site recreation, nearby recreation, services facilities, security services, worldspan gds, phone, fax, toll free, meeting capacity, meeting space, exhibit space, largest capacity, service, renovated, website, email, latitude, longitude, title, overview, sabre gds, ga ap gds, amadeus gds, chain website, chain，number of floors, check out time, check in time, year built, price, commission, room num, class, class number and address.
Apart from this, there are 63,470 meeting room records with title, hotel id, location, flooring, por walls available, size and capacities in each, and there are 1,106,297 files of these hotel images in the 61.83G media set.
The whole global hotels database consists of 9 tables.
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 43,017 | city |
100%
|
| region |
100%
|
||
| subregion |
100%
|
||
| city_x_hotel | 1,052,478 | hotel_id |
100%
|
| city_id |
100%
|
||
| hotel | 185,816 | title |
99.99%
|
| address |
97.72%
|
||
| class_number |
55.87%
|
||
| class |
55.87%
|
||
| room_num |
87.39%
|
||
| commission |
100%
|
||
| price |
100%
|
||
| overview |
39.29%
|
||
| year_built |
60.79%
|
||
| check_in_time |
79.08%
|
||
| check_out_time |
79.61%
|
||
| number_of_floors |
76.58%
|
||
| chain |
33.54%
|
||
| chain_website |
33.52%
|
||
| amadeus_gds |
46.52%
|
||
| ga_ap_gds |
50.31%
|
||
| sabre_gds |
61.1%
|
||
| worldspan_gds |
47.63%
|
||
| rate_policy |
47.56%
|
||
| start_from |
47.4%
|
||
| suit |
21.03%
|
||
| credit_cards |
90.69%
|
||
| reservation_policy |
89.45%
|
||
| included_meals |
47.57%
|
||
| deposit_policy |
23.3%
|
||
| cancellation_policy |
35.63%
|
||
| restrictions |
6.58%
|
||
| discounts_offered |
31.51%
|
||
| amenities |
93.91%
|
||
| on_site_recreation |
68.48%
|
||
| nearby_recreation |
68.33%
|
||
| services_facilities |
93.83%
|
||
| security_services |
44.56%
|
||
| address_detail |
98.85%
|
||
| phone |
97.39%
|
||
| fax |
82.54%
|
||
| toll_free |
36.65%
|
||
| meeting_capacity |
45.39%
|
||
| meeting_space |
25.31%
|
||
| exhibit_space |
6.21%
|
||
| largest_capacity |
19.2%
|
||
| service |
43.53%
|
||
| renovated |
46.16%
|
||
| website |
93.24%
|
||
|
46.81%
|
|||
| latitude |
60.83%
|
||
| longitude |
60.83%
|
||
| image_slug | 1,110,630 | title |
99.41%
|
| hotel_id |
100%
|
||
| meeting_room | 63,470 | title |
100%
|
| hotel_id |
100%
|
||
| location |
91.72%
|
||
| flooring |
71.02%
|
||
| por_walls_available |
100%
|
||
| size |
87.99%
|
||
| capacities |
86.63%
|
||
| region | 10 | region |
100%
|
| subregion | 303 | subregion |
100%
|
| region |
100%
|
| Size (Bytes) | Files |
|---|---|
| 61.83G | 1,106,297 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 2.40G (- 1.29G) | 9 (- 33) | 111 (- 187) | 2,675,304 (- 12,136,007) | 61.83G (- 22.70G) | 1,106,297 (- 542,790) |
| 2023-01-01 (+ 95 d) | 3.69G (+ 314.95M) | 42 (+ 1) | 298 (+ 57) | 14,811,311 (+ 187,594) | 84.54G (+ 59.54G) | 1,649,087 (+ 1,064,342) |
| 2022-09-27 (+ 271 d) | 3.38G (+ 1.26G) | 41 (+ 8) | 241 (+ 85) | 14,623,717 (+ 2,453,946) | 24.99G (+ 92.07K) | 584,745 (+ 1) |
| 2021-12-30 (+ 115 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2021-09-05 (+ 150 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2021-04-08 (+ 68 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2021-01-29 (+ 120 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2020-10-01 (+ 38 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2020-08-23 (+ 141 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 2020-04-04 (+ 196 d) | 2.12G (+ 0B) | 33 (+ 0) | 156 (+ 0) | 12,169,771 (+ 0) | 24.99G (+ 0B) | 584,744 (+ 0) |
| 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-13 (+ 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-10 | 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.
STAY IN THE LOOP.
