entity_statement
65 rows where "dissolutiondate" is on date 2022-08-15 sorted by iscomponent
This data as json, CSV (advanced)
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]) );