entity_statement

15 rows where "foundingdate" is on date 2007-10-30 and "statementdate" is on date 2023-06-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, incorporatedinjurisdiction_code, incorporatedinjurisdiction_name, publicationdetails_publicationdate, dissolutiondate, replacesstatements, 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
11168 entityStatement registeredEntity 2007-10-30 18124979510584788089 2023-06-20 false BAKTOMA spol. s r.o. CZ Czech Republic 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
11701 entityStatement registeredEntity 2007-10-30 5672863953494652115 2023-06-20 false Farmake s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
13387 entityStatement registeredEntity 2007-10-30 1962623217382955015 2023-06-20 false ARTKE s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14614 entityStatement registeredEntity 2007-10-30 10769477638417463620 2023-06-20 false TS servis s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
20179 entityStatement registeredEntity 2007-10-30 6128628118427473310 2023-06-20 false A - TATRA COLOR, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
22087 entityStatement registeredEntity 2007-10-30 3574518066791238306 2023-06-20 false Mestské lesy Krompachy s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
24640 entityStatement registeredEntity 2007-10-30 3443260716553788576 2023-06-20 false BRUDER, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
27476 entityStatement registeredEntity 2007-10-30 5545806501475854212 2023-06-20 false AMDT AGRO s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
32004 entityStatement registeredEntity 2007-10-30 2854591942271168088 2023-06-20 false Mestský bytový podnik Handlová s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
32175 entityStatement registeredEntity 2007-10-30 4015745390001625658 2023-06-20 false SMS TTSK s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org 2021-12-31    
33456 entityStatement registeredEntity 2007-10-30 12419546397684803576 2023-06-20 false MAPO s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
39516 entityStatement registeredEntity 2007-10-30 16759723517100788508 2023-06-20 false LINAK Slovakia s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40449 entityStatement registeredEntity 2007-10-30 12036686544551402318 2023-06-20 false MAPO s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   12419546397684803576  
7203 entityStatement registeredEntity 2007-10-30 6326934080890089976 2023-06-20 false HORTI s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
7685 entityStatement registeredEntity 2007-10-30 9036853379872865989 2023-06-20 false MO Group, 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]) 
);