entity_statement

13 rows where "foundingdate" is on date 1997-03-10 and publicationdetails_publicationdate = "2023-06-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, incorporatedinjurisdiction_code, incorporatedinjurisdiction_name, replacesstatements, foundingdate (date), 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
11837 entityStatement registeredEntity 1997-03-10 6632838215298332779 2023-06-20 false MATADOR HOLDING, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14678 entityStatement registeredEntity 1997-03-10 11205142528830380972 2023-06-20 false LEON DESIGN, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
16526 entityStatement registeredEntity 1997-03-10 8254588027281585852 2023-06-20 false J & T REAL ESTATE, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
17770 entityStatement registeredEntity 1997-03-10 3496579764027019505 2023-06-20 false SUPRO Marcelová, akciová spoločnosť SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
18034 entityStatement registeredEntity 1997-03-10 6330726222013255219 2023-06-20 false GRAMM spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
2116 entityStatement registeredEntity 1997-03-10 7905375648767671519 2023-06-20 false I.K.M. REALITY - STAVING Banská Bystrica, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
26228 entityStatement registeredEntity 1997-03-10 13161824115946257698 2023-06-20 false URPE, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
28048 entityStatement registeredEntity 1997-03-10 9601645618106390747 2023-06-20 false FORLIT, a.s. CZ Czech Republic 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
31561 entityStatement registeredEntity 1997-03-10 16720643292344523454 2023-06-20 false WESTBROEK s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
3790 entityStatement registeredEntity 1997-03-10 1942665481217954260 2023-06-20 false V.P.F. MEDIUM s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
39083 entityStatement registeredEntity 1997-03-10 16361454918814028379 2023-06-20 false FORLIT, a.s. CZ Czech Republic 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   9601645618106390747  
6911 entityStatement registeredEntity 1997-03-10 4596289888176682022 2023-06-20 false A.S.E.P., spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
8924 entityStatement registeredEntity 1997-03-10 18047128274025905784 2023-06-20 false Brantner Poprad, 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]) 
);