ooc_statement
3 rows where iscomponent = "true" and "statementdate" is on date 2018-02-27
This data as json, CSV (advanced)
Suggested facets: subject_describedbyentitystatement, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5578 | 923cc568-c1d1-4359-8c68-739d467e4151 | ownershipOrControlStatement | 2018-02-27 | true | d615f034-b477-43ed-afd8-0c729ededdc7 | 1b89bc73-3fd6-4a7f-8d03-c98d7eb0628d | 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 | ||||
5579 | 16a65715-c644-4fa2-8b05-6af6ae6bd008 | ownershipOrControlStatement | 2018-02-27 | true | 58290e23-f4ba-4c04-87d8-abc228bace79 | 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 | 240eb900-843a-480e-933e-5036c18af930 | ||||
5580 | 64405ebf-9328-42ff-9cf0-a9b2bc86e3e3 | ownershipOrControlStatement | 2018-02-27 | true | 58290e23-f4ba-4c04-87d8-abc228bace79 | 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 | d615f034-b477-43ed-afd8-0c729ededdc7 |
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]) );