entity_statement

8 rows where "foundingdate" is on date 1993-02-08, incorporatedinjurisdiction_code = "SK" and statementdate = "2023-06-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, publicationdetails_publicationdate, replacesstatements, foundingdate (date), statementdate (date), publicationdetails_publicationdate (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
25964 entityStatement registeredEntity 1993-02-08 11465846664105065842 2023-06-20 false Software602 Slovensko, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
26080 entityStatement registeredEntity 1993-02-08 12253181276124056800 2023-06-20 false OPTIMA a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
2873 entityStatement registeredEntity 1993-02-08 1268556391586950348 2023-06-20 false MGM Žilina s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
32271 entityStatement registeredEntity 1993-02-08 4605389819599061610 2023-06-20 false GEBRÜDER WEISS, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
33568 entityStatement registeredEntity 1993-02-08 13046823880663942129 2023-06-20 false STRABAG BMTI s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
41703 entityStatement registeredEntity 1993-02-08 16018336580778235055 2023-06-20 false Software602 Slovensko, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   11465846664105065842  
6124 entityStatement registeredEntity 1993-02-08 16542941255527202027 2023-06-20 false HOSPIMED - Slovakia, spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
6138 entityStatement registeredEntity 1993-02-08 16603880656614130301 2023-06-20 false PN print 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]) 
);