ooc_statement
1 row where interestedparty_describedbyentitystatement = "b3c7907d-df29-4d47-9c1c-329ed38ffb67" and "statementdate" is on date 2019-07-05
This data as json, CSV (advanced)
_link ▼ | statementid | statementtype | statementdate | iscomponent | subject_describedbyentitystatement | interestedparty_describedbypersonstatement | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type | interestedparty_describedbyentitystatement | componentstatementids | interestedparty_unspecified_reason | interestedparty_unspecified_description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9937 | 89aff040-11df-41e3-bbb2-528067015e58 | ownershipOrControlStatement | 2019-07-05 | true | d399b383-5d3a-4eb1-baa7-a8a66c1944a5 | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | b3c7907d-df29-4d47-9c1c-329ed38ffb67 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [ooc_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [subject_describedbyentitystatement] TEXT , [interestedparty_describedbypersonstatement] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [source_type] TEXT , [interestedparty_describedbyentitystatement] TEXT , [componentstatementids] TEXT , [interestedparty_unspecified_reason] TEXT , [interestedparty_unspecified_description] TEXT , PRIMARY KEY ([_link]) );