entity_statement

13 rows where "foundingdate" is on date 2010-10-14 and "statementdate" is on date 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
11067 entityStatement registeredEntity 2010-10-14 17301473307779258206 2023-06-20 false BIOPELL SK a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16003 entityStatement registeredEntity 2010-10-14 4416117786880810773 2023-06-20 false ERB Solar 1 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16662 entityStatement registeredEntity 2010-10-14 92580024298604488 2023-06-20 false ERB Solar 5 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16881 entityStatement registeredEntity 2010-10-14 10872942812066260226 2023-06-20 false SPV HOLIŠA s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
23218 entityStatement registeredEntity 2010-10-14 11366304597853533359 2023-06-20 false ZIPEX, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
33935 entityStatement registeredEntity 2010-10-14 1509741514206836080 2023-06-20 false Fit Food, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
3700 entityStatement registeredEntity 2010-10-14 18017490768680528331 2023-06-20 false ULTRASTAV s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
3725 entityStatement registeredEntity 2010-10-14 18188842130822053659 2023-06-20 false ADYTON medical devices SK s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40527 entityStatement registeredEntity 2010-10-14 13801513350715316576 2023-06-20 false SPV HOLIŠA s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   10872942812066260226  
40667 entityStatement registeredEntity 2010-10-14 17039037009844431535 2023-06-20 false ERB Solar 1 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   4416117786880810773  
41422 entityStatement registeredEntity 2010-10-14 5252806194940817923 2023-06-20 false ERB Solar 5 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   92580024298604488  
7880 entityStatement registeredEntity 2010-10-14 10264034948374005940 2023-06-20 false CEE COLLECT Slovakia s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
8194 entityStatement registeredEntity 2010-10-14 12689629920560692308 2023-06-20 false ComBuild 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]) 
);