entity_statement

9 rows where incorporatedinjurisdiction_code = "CY" and "statementdate" is on date 2020-11-09

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ statementid statementtype statementdate iscomponent entitytype name foundingdate incorporatedinjurisdiction_name incorporatedinjurisdiction_code publicationdetails_publicationdate publicationdetails_bodsversion publicationdetails_license publicationdetails_publisher_name publicationdetails_publisher_url source_type unspecifiedentitydetails_reason unspecifiedentitydetails_description
116437 dc6ce28f-f429-4428-80b9-1bd14d3b2b5b entityStatement 2020-11-09 true registeredEntity OFFCY MANAGEMENT SERVICES LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116438 c17aba23-f044-4f54-8a9b-c87908a07ff6 entityStatement 2020-11-09 true registeredEntity COASTLEY TRADING LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116738 1d15394e-2280-42d6-9ad4-7edc12a525c1 entityStatement 2020-11-09 true registeredEntity ZULU HOLDING LIMITED   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116739 08cf75e0-df2e-49e4-a79d-4fececdb0403 entityStatement 2020-11-09 true registeredEntity B.T. LARSEN & CO LIMITED   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116740 fb0860b5-1bb3-44b9-a0a1-b9a7a7c3e9ab entityStatement 2020-11-09 true registeredEntity SHIPHOLD LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116741 3f03ac87-1a1e-4aaa-9bca-2171169b6df2 entityStatement 2020-11-09 true registeredEntity OSM MARITIME PARTNERS LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116742 b33c2253-8543-4fc1-9ba5-495298786db0 entityStatement 2020-11-09 true registeredEntity OMH OPTIMUM MARITIME HOLDINGS LIMITED   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116743 61250ed9-c6d0-4de9-af1e-175bd0e7f991 entityStatement 2020-11-09 true registeredEntity OSM MARITIME GROUP LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    
116744 f1967ca5-6a69-43aa-afb5-fbaa6b4911bf entityStatement 2020-11-09 true registeredEntity OSM INTERNATIONAL HOLDING LTD   Cyprus CY 2021-01-18 0.2 http://creativecommons.org/publicdomain/zero/1.0/ The Register of Enterprises of the Republic of Latvia https://www.ur.gov.lv/ selfDeclaration,officialRegister    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [entity_statement] ( [_link] TEXT 
 , [statementid] TEXT 
 , [statementtype] TEXT 
 , [statementdate] TEXT 
 , [iscomponent] BOOL 
 , [entitytype] TEXT 
 , [name] TEXT 
 , [foundingdate] TEXT 
 , [incorporatedinjurisdiction_name] TEXT 
 , [incorporatedinjurisdiction_code] TEXT 
 , [publicationdetails_publicationdate] TEXT 
 , [publicationdetails_bodsversion] TEXT 
 , [publicationdetails_license] TEXT 
 , [publicationdetails_publisher_name] TEXT 
 , [publicationdetails_publisher_url] TEXT 
 , [source_type] TEXT 
 , [unspecifiedentitydetails_reason] TEXT 
 , [unspecifiedentitydetails_description] TEXT 
 , PRIMARY KEY ([_link]) 
);