Home Data Travel & Tourism Cruises

1,925 Global Cruises Tourism API: Type, Ship, Price & 3,014 Cruise Old of 10 Regions

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.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_lyz/global_cruise_tourism_information_1/ (By Table)

Media Files

deck_image ^{Bytes: 1.28G / Files: 18,231}
destination_image ^{Bytes: 270.51K / Files: 33}
port_image ^{Bytes: 13.58M / Files: 537}
ship_cabin_image ^{Bytes: 684.62M / Files: 50,526}
ship_photo_detail ^{Bytes: 415.53M / Files: 7,385}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category	13	title	100%
category_x_region	13	category_id	100%
category_x_region	13	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%
cruise_x_port	0	port_id	0%
departure_port	441	port	100%
departure_port	441	destination_id	100%
departure_port_x_cruise	2,939	departure_port_id	100%
departure_port_x_cruise	2,939	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%
line	296	destination_id	100%
line_cruise	269	title	100%
line_cruise	269	destination	89.96%
line_cruise_x_cruise	2,083	cruise_id	100%
line_cruise_x_cruise	2,083	line_cruise_id	100%
line_key	33	key	100%
line_key	33	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_x_cruise	8,598	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%
ship_dining	5,170	cruise_id	100%
ship_dining_detail	9,246	key	100%
		value	100%
		ship_dining_id	100%
ship_entertainment	7,001	title	100%
ship_entertainment	7,001	cruise_id	100%
ship_entertainment_detail	17,508	key	100%
		value	100%
		ship_entertainment_id	100%
ship_photo	7,385	photo_slug	100%
ship_photo	7,385	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%

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

deck_image

Size (Bytes)	Files
1.28G	18,231

destination_image

Size (Bytes)	Files
270.51K	33

port_image

Size (Bytes)	Files
13.58M	537

ship_cabin_image

Size (Bytes)	Files
684.62M	50,526

ship_photo_detail

Size (Bytes)	Files
415.53M	7,385

Commits / Updates

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

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

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.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.