This database is a great one to find more informations of attractions around the world. It has 22,606 attractions records from 108,546 popular cities. There are 219,580 hotels with price, address, phone number, E-mail and etc. in each in these cities. Each attraction is comprised of title, city, address, phone number, type and attraction slug id.
The whole database consists of 33 tables.
| Data | 0.94G (+ 0B) |
|---|---|
| Tables | 33 (+ 0) |
| Columns | 155 (+ 0) |
| Table Rows | 12,169,771 (+ 0) |
| Media | 24.99G (+ 0B) |
| Files | 584,744 (+ 0) |
| Last Commit | 2018-10-12 23:43:38 (+ 29 d) |
| 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%
|
||
| cover_image_url |
100%
|
||
| meeting_slug |
47.58%
|
||
| index |
92.29%
|
||
| post |
97.15%
|
||
| e_mail |
76.58%
|
||
| phone |
96.47%
|
||
| fax |
80.16%
|
||
| toll_free |
30.98%
|
||
| photos_slug |
54.4%
|
||
| localinfo_slug |
97.16%
|
||
| review_slug |
3.48%
|
||
| 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 | photos_url |
100%
|
| 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 |
|---|---|---|---|---|---|---|
| 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 |
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Make 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 get notified of promotional offers, official content, and data releases.
STAY IN THE LOOP.
