entity_statement

11 rows where "foundingdate" is on date 2005-11-05

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
14564 entityStatement registeredEntity 2005-11-05 10310123312881152507 2023-06-20 false PPFARM, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16183 entityStatement registeredEntity 2005-11-05 5649561358351178217 2023-06-20 false REALSTAV Čachtice s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
17986 entityStatement registeredEntity 2005-11-05 581772898636093347 2023-06-20 false HUGODENT, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
21099 entityStatement registeredEntity 2005-11-05 12497726763150057153 2023-06-20 false EKO OR, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
33645 entityStatement registeredEntity 2005-11-05 13491268016849185212 2023-06-20 false PROXENTA Private Equity, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
37310 entityStatement registeredEntity 2005-11-05 3958059635137534125 2023-06-20 false LKW Komponenten s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
38304 entityStatement registeredEntity 2005-11-05 1552937357023912130 2023-06-20 false MAN Components s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   3958059635137534125  
39527 entityStatement registeredEntity 2005-11-05 17154371770987783476 2023-06-20 false Kupkár, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40685 entityStatement registeredEntity 2005-11-05 17434467762075797786 2023-06-20 false PROXENTA Private Equity, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   13491268016849185212  
45423 entityStatement registeredEntity 2005-11-05 2311128365973613398 2024-03-02 false MAN Components s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2024-03-02 OpenOwnership Register https://register.openownership.org   1552937357023912130  
8610 entityStatement registeredEntity 2005-11-05 15505580307170468258 2023-06-20 false ORIS PLUS SK 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]) 
);