Baselight

Global Transshipment Behaviour

This dataset includes data on transshipment from Frontiers in Marine Science

@kaggle.sayansh001_global_transshipment_behaviour

Loitering Events
@kaggle.sayansh001_global_transshipment_behaviour.loitering_events

  • 3.52 MB
  • 46569 rows
  • 9 columns
transshipment_mmsi

Transshipment Mmsi

starting_latitude

Starting Latitude

starting_longitude

Starting Longitude

ending_latitude

Ending Latitude

ending_longitude

Ending Longitude

starting_timestamp

Starting Timestamp

ending_timestamp

Ending Timestamp

median_speed_knots

Median Speed Knots

total_event_duration

Total Event Duration

25606400012.793800354-69.503234863312.7279500961-69.73912048342017-09-06T02:11:32Z2017-09-06T15:44:15Z1.09106466872583413.915555555555551
25606400025.4050133333-56.302825.39335-56.488252017-07-22T13:19:49Z2017-07-22T23:59:17Z1.548334588600319710.897638888888888
25606400010.6934133333-78.512810.4845-78.88432017-11-29T14:48:51Z2017-11-30T07:43:36Z1.503455833559385318.00138888888889
25606400011.8589334488-75.553382873512.0076266667-75.53562666672017-09-07T23:39:03Z2017-09-08T14:59:26Z0.650354928079793316.19361111111111
25606400045.9387466667-23.7969645.97696-23.44938666672017-08-17T23:18:21Z2017-08-18T17:56:30Z1.00987367595809719.74833333333333
2560640003.1001066667-80.50906666673.1707466667-80.430642017-09-11T03:02:21Z2017-09-11T08:45:09Z1.11135236076214988.163333333333332
35424000027.23595619234.97352600127.200517654435.0138854982012-08-12T04:13:42Z2012-08-12T09:44:52Z1.462092720296283714.67625
3542400003.168129921-26.87706565863.1643483639-27.06981086732016-02-25T02:20:49Z2016-02-25T11:50:56Z1.38381895211274499.916666666666666
354240000-19.7107658386-79.4093093872-19.5103054047-79.5426788332016-12-06T10:15:00Z2016-12-07T12:15:09Z0.63920962747435126.8198611111111
354240000-19.5012454987-79.9913864136-19.3689041138-80.09829711912016-12-13T13:19:49Z2016-12-14T06:48:59Z0.601948179900202617.875

CREATE TABLE loitering_events (
  "transshipment_mmsi" BIGINT,
  "starting_latitude" DOUBLE,
  "starting_longitude" DOUBLE,
  "ending_latitude" DOUBLE,
  "ending_longitude" DOUBLE,
  "starting_timestamp" VARCHAR,
  "ending_timestamp" VARCHAR,
  "median_speed_knots" DOUBLE,
  "total_event_duration" DOUBLE
);

Share link

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