entity_statement
6 rows where "dissolutiondate" is on date 2019-09-30 and "publicationdetails_publicationdate" is on date 2024-01-03
This data as json, CSV (advanced)
_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
636664 | entityStatement | registeredEntity | 2017-08-07 | 15777408107377430937 | 2024-01-03 | false | FD Transport IVS | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 14845858309487519562 | |
638269 | entityStatement | registeredEntity | 2017-07-18 | 3367090546018220417 | 2024-01-03 | false | Corporate Finance Huset IVS | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 17463742028302965757 | |
643618 | entityStatement | registeredEntity | 2016-01-01 | 6819768936835134680 | 2024-01-03 | false | Totalrengøring I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 16445847636550297038 | |
648638 | entityStatement | registeredEntity | 1970-01-01 | 317085358250200209 | 2024-01-03 | false | CIVILINGENIØR OTTO KIERULFFS FOND | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 2444963032276714177 | |
648948 | entityStatement | registeredEntity | 2013-12-01 | 9770465792588713439 | 2024-01-03 | false | Real Estate Group I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 9140579432701742824 | |
649276 | entityStatement | registeredEntity | 2017-12-25 | 17553399346271257377 | 2024-01-03 | false | Green Home I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2019-09-30 | 520777870539205093 |
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]) );