Name | n3_lyz_travelweekly_cruise.com |
---|---|
Data | 111.62M (+ 0B) |
Tables | 32 (+ 0) |
Columns | 155 (+ 0) |
Table Rows | 196,424 (+ 0) |
Media | 2.37G (+ 0B) |
Files | 76,712 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
This is a most comprehensive gloabl cruise tourism information database with 1,925 cruises records. Each cruise and cruise old has class, type, title, ship, departure date, introduce, price, image url and ship/deck/cabin/photos/review slug. All these cruise are sorted by 13 categories (Africa & Middle East Cruise Destinations, Africa & Middle East River Cruise Destinations, Alaska Cruise Destinations, Asia Cruise Destinations, Asia River Cruise Destinations, Pacific-Australia Cruise Destinations, Caribbean Cruise Destinations, Europe Cruise Destinations, Europe River Cruise Destinations, Mediterranean Cruise Destinations, United States & Canada Cruise Destinations, United States & Canada River Cruise Destinations and Trans-Oceanic & World Cruise Destinations) of 10 regions (Africa/ Middle East, Alaska, Asia, Australia/ South Pacific, Caribbean, Europe, Mediterranean, Mexico, United States/ Canada, Trans-Oceanic & World).
In this world cruise tourism information database, there are 579 ports with description, image slug and hotel slug in each. It also includes 38,547 port hotels, port hotel slug with 529 records and 585 port slug records. There are 7 tables related with ship of these cruises, they are 52,065 ship cabin records with name, introduce, image URL and cruise; 18,273 ship deck records with deck and deck url; ship dining wiht 5,170 records, ship entertainment with 7,001 records, 7,385 ship photos, 1,920 ship profile records with cruise line, ship type, line class, registry, year built, capacity, deck, gross tonnage, length, beam, average speed, outside cabin, nationality officer, nationality crew, etc. in each and 1,920 ship recreation records with indoor pool, outdoor pools, spa, casino and cruise. Besides, there are 441 departure port records with destination, destination with 33 records, 19,043 itinerary records and line with 296 records. In the media file, there are deck / destination/ port / ship cabin / ship photo images in the 1.28G / 270.51K / 13.58M / 684.62M / 415.53M media sets of each.
The whole global cruises database consists of 32 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
category | 13 | title |
100%
|
category_x_region | 13 | category_id |
100%
|
cruise_region_id |
100%
|
||
cruise | 1,925 | class |
100%
|
type |
100%
|
||
title |
100%
|
||
ship |
100%
|
||
ship_slug |
99.74%
|
||
departure_date |
94.96%
|
||
introduce |
99.06%
|
||
price |
94.96%
|
||
img_url |
99.9%
|
||
deck_slug |
93.35%
|
||
cabin_slug |
91.17%
|
||
photos_slug |
96.42%
|
||
review_slug |
78.86%
|
||
cruise_region | 10 | title |
100%
|
cruise_x_port | 0 | cruise_id |
0%
|
port_id |
0%
|
||
departure_port | 441 | port |
100%
|
destination_id |
100%
|
||
departure_port_x_cruise | 2,939 | departure_port_id |
100%
|
cruise_id |
100%
|
||
destination | 33 | destination |
100%
|
img_url |
100%
|
||
category_x_region_id |
100%
|
||
itinerary | 19,043 | day |
98.28%
|
location |
99.97%
|
||
cruise_id |
100%
|
||
line | 296 | title |
100%
|
destination_id |
100%
|
||
line_cruise | 269 | title |
100%
|
destination |
89.96%
|
||
line_cruise_x_cruise | 2,083 | cruise_id |
100%
|
line_cruise_id |
100%
|
||
line_key | 33 | key |
100%
|
destination_id |
100%
|
||
port | 579 | title |
100%
|
description |
86.7%
|
||
img_slug |
88.95%
|
||
hotel_slug |
100%
|
||
port_hotel | 38,547 | title |
100%
|
hotel_slug |
100%
|
||
port_id |
100%
|
||
port |
100%
|
||
port_hotel_slug | 529 | hotel_slug |
100%
|
port_id |
100%
|
||
port |
100%
|
||
port_slug | 585 | title |
100%
|
port_x_cruise | 8,598 | cruise_id |
100%
|
port_slug_id |
100%
|
||
ship_cabin | 52,065 | title |
100%
|
name |
100%
|
||
introduce |
87.29%
|
||
img_url |
99.23%
|
||
cruise_id |
100%
|
||
ship_deck | 18,273 | deck |
100%
|
deck_url |
100%
|
||
cruise_id |
100%
|
||
ship_dining | 5,170 | title |
100%
|
cruise_id |
100%
|
||
ship_dining_detail | 9,246 | key |
100%
|
value |
100%
|
||
ship_dining_id |
100%
|
||
ship_entertainment | 7,001 | title |
100%
|
cruise_id |
100%
|
||
ship_entertainment_detail | 17,508 | key |
100%
|
value |
100%
|
||
ship_entertainment_id |
100%
|
||
ship_photo | 7,385 | photo_slug |
100%
|
cruise_id |
100%
|
||
ship_profile | 1,920 | cruise_line |
100%
|
ship_type |
100%
|
||
line_class |
100%
|
||
registry |
84.58%
|
||
year_built |
99.9%
|
||
capacity |
100%
|
||
deck |
92.14%
|
||
gross_tonnage |
94.11%
|
||
length |
94.84%
|
||
beam |
91.61%
|
||
average_speed |
89.43%
|
||
outside_cabin |
94.38%
|
||
nationality_officer |
69.69%
|
||
nationality_crew |
91.61%
|
||
number_crew |
89.11%
|
||
cruise_id |
100%
|
||
ship_recreation | 1,920 | indoor_pool |
25.68%
|
outdoor_pools |
87.24%
|
||
spa |
100%
|
||
casino |
100%
|
||
cruise_id |
100%
|
Size (Bytes) | Files |
---|---|
1.28G | 18,231 |
Size (Bytes) | Files |
---|---|
270.51K | 33 |
Size (Bytes) | Files |
---|---|
13.58M | 537 |
Size (Bytes) | Files |
---|---|
684.62M | 50,526 |
Size (Bytes) | Files |
---|---|
415.53M | 7,385 |
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2023-01-01 (+ 95 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2022-09-27 (+ 271 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2021-12-30 (+ 115 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2021-09-05 (+ 150 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2021-04-08 (+ 68 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2021-01-29 (+ 120 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2020-10-01 (+ 38 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2020-08-23 (+ 141 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2020-04-04 (+ 196 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2019-09-21 (+ 197 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2019-03-07 (+ 43 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2019-01-23 (+ 44 d) | 111.62M (+ 0B) | 32 (+ 0) | 155 (+ 0) | 196,424 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-12-09 (+ 29 d) | 111.62M (- 0.61M) | 32 (- 2) | 155 (- 19) | 196,424 (- 3,014) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-11-09 (+ 27 d) | 112.23M (+ 27.05M) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-10-13 (+ 29 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-09-13 (+ 34 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-08-09 (+ 27 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-07-12 (+ 31 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-06-10 (+ 31 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-05-10 (+ 28 d) | 85.19M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 199,438 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2018-04-11 (+ 73 d) | 85.19M (+ 6.78M) | 34 (+ 0) | 174 (+ 0) | 199,438 (- 4,174) | 2.37G (- 3.71K) | 76,712 (+ 0) |
2018-01-27 (+ 29 d) | 78.41M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 203,612 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2017-12-29 (+ 20 d) | 78.41M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 203,612 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2017-12-08 (+ 9 d) | 78.41M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 203,612 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2017-11-28 (+ 19 d) | 78.41M (+ 0B) | 34 (+ 0) | 174 (+ 0) | 203,612 (+ 0) | 2.37G (+ 0B) | 76,712 (+ 0) |
2017-11-09 (+ 10 d) | 78.41M (+ 96K) | 34 (+ 0) | 174 (+ 0) | 203,612 (- 5) | 2.37G (+ 0B) | 76,712 (+ 0) |
2017-10-29 (+ 19 d) | 78.31M (+ 11.38M) | 34 (+ 3) | 174 (+ 15) | 203,617 (+ 39,659) | 2.37G (+ 13.56M) | 76,712 (+ 536) |
2017-10-10 | 66.94M | 31 | 159 | 163,958 | 2.35G | 76,176 |
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.