entity_statement

16 rows where dissolutiondate = "2021-09-30", incorporatedinjurisdiction_code = "SK" and statementdate = "2023-06-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: foundingdate (date), statementdate (date), publicationdetails_publicationdate (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
1015 entityStatement registeredEntity 2013-02-01 16941846894530809164 2023-06-20 false Jozef Jagelka SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
11317 entityStatement registeredEntity 1990-06-11 2740114547553324961 2023-06-20 false Michal Šaro Michalovce SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
12856 entityStatement registeredEntity 2013-05-14 14335257108364220448 2023-06-20 false Ján Hanuljak SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
14601 entityStatement registeredEntity 2014-07-26 10632005615847175508 2023-06-20 false Peter Bátora Autodoprava SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
15982 entityStatement registeredEntity 2014-02-06 4274861063859173149 2023-06-20 false Marián Nemec SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
18226 entityStatement registeredEntity 2015-02-24 8192000596707422700 2023-06-20 false Jozef Púčik - AUTODOPRAVA SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
2549 entityStatement registeredEntity 2012-12-21 10691629584224741833 2023-06-20 false Viliam Jarina SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
25630 entityStatement registeredEntity 2015-08-04 9337735017398540667 2023-06-20 false Ivan Čulen SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
26581 entityStatement registeredEntity 2007-04-12 15725987422490606475 2023-06-20 false ATJ Invest, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
2870 entityStatement registeredEntity 2014-01-14 12673113925478102752 2023-06-20 false Dušan Leškanič "Autobusová doprava - nepravidelná" SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
3847 entityStatement registeredEntity 2016-06-08 2252329101993934321 2023-06-20 false Milan Holub SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
5637 entityStatement registeredEntity 2012-12-31 13521937935128992756 2023-06-20 false Jozef Hutár SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
6377 entityStatement registeredEntity 2013-05-10 17965212326690769495 2023-06-20 false Dipl. Ing. Ivan Šlesar - LESINVEST SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
6661 entityStatement registeredEntity 1991-08-13 3043229917906545778 2023-06-20 false Milan Róka SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
7219 entityStatement registeredEntity 2004-02-06 6453140603160470315 2023-06-20 false Jozef Igaz - TLAČIVÁ - PAPIER SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-09-30    
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]) 
);