ooc_statement
3 rows where iscomponent = "true" and "statementdate" is on date 2019-07-25
This data as json, CSV (advanced)
Suggested facets: interestedparty_describedbypersonstatement, statementdate (date), publicationdetails_publicationdate (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8349 | caaefbe7-c62d-4fc7-8dc1-c5c281f7fad1 | ownershipOrControlStatement | 2019-07-25 | true | 9309528c-c7a9-4230-b301-01fef95fdd6a | 32bd0edd-fa1a-47dc-a7f2-e4a2854649ff | 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 | ||||
8350 | 14db8b68-52b7-4258-a970-1d94b6cc268d | ownershipOrControlStatement | 2019-07-25 | true | 016780c0-d722-4239-8bd2-0ec115af543c | 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 | 4d8c603c-58ce-4096-82f5-977696b0836b | ||||
8351 | ee4b49ae-5e71-4ed9-9927-a310657369ae | ownershipOrControlStatement | 2019-07-25 | true | 016780c0-d722-4239-8bd2-0ec115af543c | 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 | 9309528c-c7a9-4230-b301-01fef95fdd6a |
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]) );