ooc_statement
3 rows where "statementdate" is on date 2019-09-25 sorted by interestedparty_describedbypersonstatement
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63778 | 54bf811a-1ed4-4129-aa07-50aeff23778e | ownershipOrControlStatement | 2019-09-25 | false | fbfb5d3b-ce22-4e25-89fe-674f86e3082e | 0c72d9ca-3d9b-4f6c-8312-bc2718ba1a00 | 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 | ||||
104872 | 48ce1f3b-fe80-4485-9c2d-45fc86046ffd | ownershipOrControlStatement | 2019-09-25 | false | a746e9d1-9e08-4043-8c49-b9a8103cc6c5 | 38cba1d0-3334-48d8-a68a-4aca3d1d502d | 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 | ||||
37375 | 5a87faac-95bb-4843-afb0-4603304ea889 | ownershipOrControlStatement | 2019-09-25 | false | b11f8abc-846c-4dcc-b1ae-597ffc640b6b | 895d947b-80a5-45a2-a28c-af7160570ef4 | 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 |
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]) );