ooc_statement
1 row where componentstatementids = "02ecb84f-796f-468b-9128-1e27b3655c82,071b67e7-24e5-4a73-b2fd-aecc2e197c69,7e9664d4-bc6f-474a-a1a2-d4af370c3179,5acae89d-de62-407c-88f4-0d5b9342b470,dd5aa574-d836-4de6-9ef0-d1070758d2fc" and "statementdate" is on date 2019-07-26
This data as json, CSV (advanced)
Suggested facets: statementdate (date)
_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18330 | 468a7e7e-4d71-4d4a-9719-cbea5fb2e528 | ownershipOrControlStatement | 2019-07-26 | false | 5ccec7d5-4c9b-4757-aa1e-ffdcb15df1ab | 0fe1233f-c5b8-4a28-bc90-6a8e393e0be0 | 2021-01-18 | 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 | 02ecb84f-796f-468b-9128-1e27b3655c82,071b67e7-24e5-4a73-b2fd-aecc2e197c69,7e9664d4-bc6f-474a-a1a2-d4af370c3179,5acae89d-de62-407c-88f4-0d5b9342b470,dd5aa574-d836-4de6-9ef0-d1070758d2fc |
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]) );