entity_statement

9 rows where "foundingdate" is on date 2013-12-13 and "publicationdetails_publicationdate" is on date 2023-06-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dissolutiondate, foundingdate (date), statementdate (date), dissolutiondate (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
11435 entityStatement registeredEntity 2013-12-13 3620562911346717999 2023-06-20 false ENERGY DISTRIBUTION, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
11646 entityStatement registeredEntity 2013-12-13 5281647082838829853 2023-06-20 false LAND, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
25092 entityStatement registeredEntity 2013-12-13 6056398336515774691 2023-06-20 false Corefin, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
269 entityStatement registeredEntity 2013-12-13 11966352734375262901 2023-06-20 false Radovan Dobša SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-10-23    
29112 entityStatement registeredEntity 2013-12-13 16570805462301934939 2023-06-20 false Sportnet Media SK, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
29625 entityStatement registeredEntity 2013-12-13 3648111019193876950 2023-06-20 false TENDER-S, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
29909 entityStatement registeredEntity 2013-12-13 5416200584589739704 2023-06-20 false FLORASYSTEM, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
3212 entityStatement registeredEntity 2013-12-13 14964161177931695764 2023-06-20 false CESTY MOSTY, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
9022 entityStatement registeredEntity 2013-12-13 2132965533302499523 2023-06-20 false Jaroslav Prekop AUTOŠKOLA SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    

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