entity_statement
2 rows where "dissolutiondate" is on date 2018-06-30 and "publicationdetails_publicationdate" is on date 2022-10-20
This data as json, CSV (advanced)
_link ▼ | statementid | statementtype | statementdate | iscomponent | entitytype | name | dissolutiondate | foundingdate | incorporatedinjurisdiction_name | incorporatedinjurisdiction_code | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | replacesstatements | source_type | source_description | source_url | source_retrievedat | source_assertedby |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2821 | 5260547281096896428 | entityStatement | 2022-10-20 | false | registeredEntity | KM&JA Holding ApS | 2018-06-30 | 2018-06-20 | Denmark | DK | 2022-10-20 | 0.2 | https://register.openownership.org/terms-and-conditions | OpenOwnership Register | https://register.openownership.org | ||||||
7177 | 928284714128632052 | entityStatement | 2022-10-20 | false | registeredEntity | AAGE PETERSEN OFFSET EFTF I/S | 2018-06-30 | 1984-01-23 | Denmark | DK | 2022-10-20 | 0.2 | https://register.openownership.org/terms-and-conditions | OpenOwnership Register | https://register.openownership.org |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [entity_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [entitytype] TEXT , [name] TEXT , [dissolutiondate] TEXT , [foundingdate] TEXT , [incorporatedinjurisdiction_name] TEXT , [incorporatedinjurisdiction_code] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [replacesstatements] TEXT , [source_type] TEXT , [source_description] TEXT , [source_url] TEXT , [source_retrievedat] TEXT , [source_assertedby] TEXT , PRIMARY KEY ([_link]) );