entity_statement

12 rows where "foundingdate" is on date 2013-12-11 and incorporatedinjurisdiction_code = "SK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, name, publicationdetails_publicationdate, replacesstatements, foundingdate (date), statementdate (date)

_link ▼ statementtype entitytype foundingdate statementid statementdate iscomponent name incorporatedinjurisdiction_code incorporatedinjurisdiction_name publicationdetails_bodsversion publicationdetails_license publicationdetails_publicationdate publicationdetails_publisher_name publicationdetails_publisher_url dissolutiondate replacesstatements alternatenames
15878 entityStatement registeredEntity 2013-12-11 353467745317212265 2023-06-20 false Akadémia vzdelávania vodičov, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16431 entityStatement registeredEntity 2013-12-11 7507570337667316116 2023-06-20 false REDING s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19894 entityStatement registeredEntity 2013-12-11 4116675764912261566 2023-06-20 false Dr.Max 137 T, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
22017 entityStatement registeredEntity 2013-12-11 3104806673212824220 2023-06-20 false Salexcontrol s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
22352 entityStatement registeredEntity 2013-12-11 5473406854448326559 2023-06-20 false Akadémia vzdelávania vodičov, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   353467745317212265  
2674 entityStatement registeredEntity 2013-12-11 1137468066408557183 2023-06-20 false Cykloprojekt s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
28817 entityStatement registeredEntity 2013-12-11 14587056639071761576 2023-06-20 false Cestovná kancelária DAKA, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
35265 entityStatement registeredEntity 2013-12-11 5613173898130824722 2023-06-20 false SIMLES s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
36065 entityStatement registeredEntity 2013-12-11 10181063104780767678 2023-06-20 false WR system, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
46586 entityStatement registeredEntity 2013-12-11 10470191689121926979 2024-03-02 false ERINI, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2024-03-02 OpenOwnership Register https://register.openownership.org      
5382 entityStatement registeredEntity 2013-12-11 11831908029165980011 2023-06-20 false Innovatio, spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
564 entityStatement registeredEntity 2013-12-11 13899736125168149689 2023-06-20 false AdVision Systems s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      

Advanced export

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

CSV options: 

CREATE TABLE [entity_statement] ( [_link] TEXT 
 , [statementtype] TEXT 
 , [entitytype] TEXT 
 , [foundingdate] TIMESTAMP 
 , [statementid] TEXT 
 , [statementdate] TIMESTAMP 
 , [iscomponent] BOOL 
 , [name] TEXT 
 , [incorporatedinjurisdiction_code] TEXT 
 , [incorporatedinjurisdiction_name] TEXT 
 , [publicationdetails_bodsversion] NUMERIC 
 , [publicationdetails_license] TEXT 
 , [publicationdetails_publicationdate] TIMESTAMP 
 , [publicationdetails_publisher_name] TEXT 
 , [publicationdetails_publisher_url] TEXT 
 , [dissolutiondate] TIMESTAMP 
 , [replacesstatements] TEXT 
 , [alternatenames] TEXT 
 , PRIMARY KEY ([_link]) 
);