entity_statement
3 rows where "dissolutiondate" is on date 2022-03-14 and "foundingdate" is on date 2020-01-23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148040 | entityStatement | registeredEntity | 2020-01-23 | 1409572881311306722 | 2023-06-20 | false | Goodbrands ApS | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2022-03-14 | ||
581378 | entityStatement | registeredEntity | 2020-01-23 | 2584255640743124494 | 2023-06-20 | false | Goodbrands ApS | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-12-18 | OpenOwnership Register | https://register.openownership.org | 2022-03-14 | 1409572881311306722 | Goodbrands Sverige ApS,Goodbrands Norge ApS,Goodbrands Germany ApS,Goodbrands Europe ApS,Goodbrands Skandinavia ApS |
636600 | entityStatement | registeredEntity | 2020-01-23 | 1517278827369490464 | 2024-01-03 | false | Goodbrands ApS | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-01-03 | OpenOwnership Register | https://register.openownership.org | 2022-03-14 | 2584255640743124494 | Goodbrands Skandinavia ApS,Goodbrands Europe ApS,Goodbrands Germany ApS,Goodbrands Norge ApS,Goodbrands Sverige ApS |
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]) );