ooc_statement
1 row where "statementdate" is on date 2018-12-10 sorted by interestedparty_describedbypersonstatement
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50500 | e50e3455-823d-441a-8582-35d036779c69 | ownershipOrControlStatement | 2018-12-10 | false | 09150399-6acc-4dbf-9999-95373c92c060 | f46d2e5d-fd0b-4bdd-a79d-33696b132ea2 | 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]) );