Baselight

Global Transshipment Behaviour

This dataset includes data on transshipment from Frontiers in Marine Science

@kaggle.sayansh001_global_transshipment_behaviour

Transshipment Vessels
@kaggle.sayansh001_global_transshipment_behaviour.transshipment_vessels

  • 58.01 KB
  • 1124 rows
  • 7 columns
mmsi

Mmsi

shipname

Shipname

callsign

Callsign

flag

Flag

imo

Imo

first_timestamp

First Timestamp

last_timestamp

Last Timestamp

306117000SIERRALAURELPJBQANT91634032018-03-29T08:34:21Z2018-06-30T17:08:41Z
306873000SIERRALEYREPJJZANT91358222012-01-01T01:06:00Z2012-06-26T08:58:28Z
309681GREENBRAZILC6WH6BHS90457922018-06-29T10:34:00Z2018-06-30T23:47:40Z
308735000NOVA BRETAGNEC6JI7BHS90003642012-01-01T00:39:08Z2013-09-12T10:03:48Z
311000682SIERRA LARAC6DI3BHS91202052017-07-03T10:28:05Z2018-06-30T23:35:36Z
311000433SILVER PEARLC6CC5BHS84000502015-08-19T10:00:02Z2018-06-30T23:57:13Z
311000709SIERRA LEYREC6DL3BHS91358222017-10-12T08:51:41Z2018-06-30T06:08:40Z
311043900GREENCONCORDIAC6YS7BHS90110382012-01-03T22:17:16Z2013-09-09T11:44:22Z
308572000RUNAWAY BAYC6PX2BHS90196402012-01-01T00:28:40Z2017-02-08T06:13:05Z
308228000GREEN OCEANC6VY8BHS90019162012-01-03T11:20:45Z2018-06-30T23:57:00Z

CREATE TABLE transshipment_vessels (
  "mmsi" DOUBLE,
  "shipname" VARCHAR,
  "callsign" VARCHAR,
  "flag" VARCHAR,
  "imo" DOUBLE,
  "first_timestamp" VARCHAR,
  "last_timestamp" VARCHAR
);

Share link

Anyone who has the link will be able to view this.