entity_statement

12 rows where "foundingdate" is on date 2004-06-09 and "publicationdetails_publicationdate" is on date 2023-06-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, incorporatedinjurisdiction_code, replacesstatements, foundingdate (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
10425 entityStatement registeredEntity 2004-06-09 12204681705744192390 2023-06-20 false EURO CERT SK, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16118 entityStatement registeredEntity 2004-06-09 5245872009264092661 2023-06-20 false EMINA, spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
1636 entityStatement registeredEntity 2004-06-09 4653794347872233873 2023-06-20 false ALCONET, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16485 entityStatement registeredEntity 2004-06-09 7948763521555774586 2023-06-20 false Lakeside Office 1, a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
20242 entityStatement registeredEntity 2004-06-09 6514966900998635623 2023-06-20 false AGROSLUŽBY VK Giraltovce, spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
22362 entityStatement registeredEntity 2004-06-09 5553899716910176985 2023-06-20 false EURO CERT SK, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   12204681705744192390  
26818 entityStatement registeredEntity 2004-06-09 17406145996610713354 2023-06-20 false SENIOR PLUS, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
31219 entityStatement registeredEntity 2004-06-09 14388860930940109293 2023-06-20 false Analytica Design spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
33064 entityStatement registeredEntity 2004-06-09 10292894784549741232 2023-06-20 false REAL STYLE, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   15818293753988717235  
3338 entityStatement registeredEntity 2004-06-09 15818293753988717235 2023-06-20 false REAL STYLE, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
7301 entityStatement registeredEntity 2004-06-09 6909147055040467918 2023-06-20 false SMAPS s.r.o. CZ Czech Republic 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
7465 entityStatement registeredEntity 2004-06-09 7799372825983511192 2023-06-20 false STEFE ECB, 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]) 
);