entity_statement
5 rows where "dissolutiondate" is on date 2021-01-01
This data as json, CSV (advanced)
Suggested facets: incorporatedinjurisdiction_code, incorporatedinjurisdiction_name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10782 | entityStatement | registeredEntity | 2009-11-21 | 15009297111861155055 | 2023-06-20 | false | BINIL, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-01-01 | ||
12710 | entityStatement | registeredEntity | 2002-03-28 | 13283924432827952074 | 2023-06-20 | false | FERMAT Group, a.s. | CZ | Czech Republic | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-01-01 | ||
27715 | entityStatement | registeredEntity | 1993-07-21 | 7092077808049146059 | 2023-06-20 | false | Vema, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-01-01 | ||
5139 | entityStatement | registeredEntity | 2004-06-30 | 10384819653366651501 | 2023-06-20 | false | SMZ - Služby, a.s. Jelšava | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-01-01 | ||
8652 | entityStatement | registeredEntity | 1996-02-28 | 15882919948661738 | 2023-06-20 | false | WBI, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-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]) );