entity_statement

9 rows where "foundingdate" is on date 1991-12-20 and incorporatedinjurisdiction_code = "SK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, dissolutiondate, replacesstatements, foundingdate (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
17894 entityStatement registeredEntity 1991-12-20 4743445021875110669 2023-06-20 false VESTILE, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19716 entityStatement registeredEntity 1991-12-20 2878127693321338856 2023-06-20 false AVANTEK spol. s r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
22410 entityStatement registeredEntity 1991-12-20 5897613745904167864 2023-06-20 false Otto Smik SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-10-23 15843842981372911862  
2273 entityStatement registeredEntity 1991-12-20 9033732107029220129 2023-06-20 false RYBA Košice spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-11-01    
24916 entityStatement registeredEntity 1991-12-20 4997516859493415771 2023-06-20 false ASPARAGUS spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
25348 entityStatement registeredEntity 1991-12-20 7749950162738144397 2023-06-20 false AGROREAL spol. s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
3261 entityStatement registeredEntity 1991-12-20 15312340532019874566 2023-06-20 false INDRA Slovakia, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
45321 entityStatement registeredEntity 1991-12-20 1539247781920188403 2024-03-02 false INNDRA consulting, a. s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2024-03-02 OpenOwnership Register https://register.openownership.org   15312340532019874566  
6009 entityStatement registeredEntity 1991-12-20 15843842981372911862 2023-06-20 false Ing. Otto Smik SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-10-23    

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