entity_statement

9 rows where "foundingdate" is on date 2012-06-29 and incorporatedinjurisdiction_code = "SK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, publicationdetails_publicationdate, replacesstatements, 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
10953 entityStatement registeredEntity 2012-06-29 16348089162288058825 2023-06-20 false Applied Technologies s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
11443 entityStatement registeredEntity 2012-06-29 3691933853515003019 2023-06-20 false KOLBACH, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
1846 entityStatement registeredEntity 2012-06-29 6003212468074787589 2023-06-20 false Saradam s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
1933 entityStatement registeredEntity 2012-06-29 6622354939854541125 2023-06-20 false PALMA a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
21337 entityStatement registeredEntity 2012-06-29 14272322822607432746 2023-06-20 false PALMA a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   6622354939854541125  
25833 entityStatement registeredEntity 2012-06-29 10529614322115694391 2023-06-20 false Q-PRODUCTS a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
2861 entityStatement registeredEntity 2012-06-29 12624024321763702647 2023-06-20 false Neito, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40519 entityStatement registeredEntity 2012-06-29 13737362742097223123 2023-06-20 false PALMA a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   14272322822607432746  
40828 entityStatement registeredEntity 2012-06-29 417358115498451623 2023-06-20 false Q-PRODUCTS a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   10529614322115694391  

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]) 
);