entity_statement

17 rows where "foundingdate" is on date 2013-10-15 and statementdate = "2023-06-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, 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
10145 entityStatement registeredEntity 2013-10-15 10282353189433153953 2023-06-20 false MEDIAX s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14896 entityStatement registeredEntity 2013-10-15 12700976166733052414 2023-06-20 false Clinical Research Associate Slovakia s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
15133 entityStatement registeredEntity 2013-10-15 14555613963756376202 2023-06-20 false BENU SK 3, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16883 entityStatement registeredEntity 2013-10-15 10902631515092653778 2023-06-20 false BENU SK 38, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
17037 entityStatement registeredEntity 2013-10-15 12477679732537126933 2023-06-20 false Farma Babindol, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
1911 entityStatement registeredEntity 2013-10-15 6520539902253984239 2023-06-20 false DUMAR-SK s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19428 entityStatement registeredEntity 2013-10-15 17541661849980184908 2023-06-20 false SAGAP, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19463 entityStatement registeredEntity 2013-10-15 17846162258078672188 2023-06-20 false BENU SK 41, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19722 entityStatement registeredEntity 2013-10-15 2957128933452262495 2023-06-20 false BYIMPEX s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
23728 entityStatement registeredEntity 2013-10-15 1453691092784070164 2023-06-20 false NaturePharm s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
2487 entityStatement registeredEntity 2013-10-15 10322688230568588765 2023-06-20 false PHYSICUS s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
26744 entityStatement registeredEntity 2013-10-15 16918871618453904066 2023-06-20 false ELRES s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
34917 entityStatement registeredEntity 2013-10-15 3667593013743204358 2023-06-20 false Bussines Start, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
36682 entityStatement registeredEntity 2013-10-15 15189007496170659378 2023-06-20 false IFREEZONE, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
37965 entityStatement registeredEntity 2013-10-15 10088661138455302590 2023-06-20 false BENU SK 38, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   10902631515092653778  
38000 entityStatement registeredEntity 2013-10-15 10771283724592001782 2023-06-20 false BENU SK 3, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   14555613963756376202  
38789 entityStatement registeredEntity 2013-10-15 7214963694436958844 2023-06-20 false BENU SK 41, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   17846162258078672188  

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