entity_statement
9 rows where "dissolutiondate" is on date 2023-01-01
This data as json, CSV (advanced)
Suggested facets: foundingdate, name, publicationdetails_publicationdate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10027 | entityStatement | registeredEntity | 2008-07-01 | 9270686630480669609 | 2023-06-20 | false | Agroinštitút Nitra, štátny podnik | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
13702 | entityStatement | registeredEntity | 1988-07-01 | 4081811666112319485 | 2023-06-20 | false | Lesopoľnohospodársky majetok Ulič, štátny podnik | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
15549 | entityStatement | registeredEntity | 2017-02-04 | 175944657922083154 | 2023-06-20 | false | Ferroenergy s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
29723 | entityStatement | registeredEntity | 1998-10-06 | 4349547680777359663 | 2023-06-20 | false | DENAX, a.s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
31678 | entityStatement | registeredEntity | 1994-11-23 | 17414143035853822303 | 2023-06-20 | false | U. S. Steel Košice – Labortest, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
32093 | entityStatement | registeredEntity | 2013-12-17 | 3426484554788943158 | 2023-06-20 | false | Neuman Aluminium Services Slovakia, s.r.o | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
321 | entityStatement | registeredEntity | 1992-11-20 | 12307790546482765293 | 2023-06-20 | false | UNOTECH, spol. s r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | ||
41041 | entityStatement | registeredEntity | 2017-02-04 | 8726415894258591931 | 2023-06-20 | false | Ferroenergy s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 | 175944657922083154 | |
6879 | entityStatement | registeredEntity | 1993-09-30 | 4339333327566530435 | 2023-06-20 | false | BIOHEM, spol. s r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2023-01-01 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]) );