Shipping Ports Around The World

Dataset containing useful data of 450+ ports around the world

@kaggle.sanjeetsinghnaik_ship_ports

Table List

1 table(32.42 KB)

Port Data

@kaggle.sanjeetsinghnaik_ship_ports.port_data

32.42 KB
480 rows
12 columns

unnamed_0 Unnamed: 0	country Country	port_name Port Name	un_code UN Code	vessels_in_port Vessels In Port	departures_last_24_hours Departures(Last 24 Hours)	arrivals_last_24_hours Arrivals(Last 24 Hours)	expected_arrivals Expected Arrivals	type Type	area_local Area Local	area_global Area Global	also_known_as Also Known As
	China	SHANGHAI	CNSHG	2420	1376	1626	644	Port	East China Sea	Central China	['SHANG HAI', ' YANGSHAN', ' CNSHA', ' CNSGH']
1	China	NANTONG	CNNTG	1572	1173	1287	234	Port	East China Sea	Central China	['NAN TONG']
2	China	CJK	CNCJK	1529	343	370	310	Anchorage	East China Sea	Central China	['CHANGJIANGKOU', ' CHANGJIANG KOU', ' CJK CN']
3	China	NANJING	CNNKG	1414	667	1060	203	Port	East China Sea	Central China	['NAN JING', ' NAN JIN', ' NANJIN']
4	China	JIANGYIN	CNJIA	1112	1076	1070	166	Port	East China Sea	Central China	['-', ' JANG JIN', ' JIANG YIN']
5	Singapore	SINGAPORE	SGSIN	1109	1682	1748	1205	Port	Singapore Area	Indonesia	['SPORE', ' SINGPORE', ' SIN EBGA', ' SIN PEBGA']
6	China	ZHANGJIAGANG	CNZJG	1094	653	608	120	Port	East China Sea	Central China	['ZHANG JIA GANG', ' ZHANG GIAN GANG', ' ZHAN JIANG']
7	China	ZHOUSHAN	CNZOS	1064	791	839	463	Port	East China Sea	Central China	['ZHOU SHAN', ' DINGHAI', ' DING HAI', ' ZHOUSAN']
8	China	YANGZHOU	CNYZH	945	654	786	47	Port	East China Sea	Central China	['YANG ZHOU']
9	China	TIANJIN	CNTXG	868	409	428	225	Port	Bohai Sea	North China	['TIAN JIN', ' XINGANG', ' XIN GANG', ' TIANG JIN']


CREATE TABLE port_data (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "port_name" VARCHAR,
  "un_code" VARCHAR,
  "vessels_in_port" BIGINT,
  "departures_last_24_hours" BIGINT,
  "arrivals_last_24_hours" BIGINT,
  "expected_arrivals" BIGINT,
  "type" VARCHAR,
  "area_local" VARCHAR,
  "area_global" VARCHAR,
  "also_known_as" VARCHAR
);