person_statement
6 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2020-05-07
This data as json, CSV (advanced)
| _link ▼ | statementid | statementtype | statementdate | iscomponent | persontype | birthdate | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type | unspecifiedpersondetails_reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46731 | 0ba15af3-2628-4bf7-9d89-f0fe38dd846e | personStatement | 2020-05-07 | false | knownPerson | 1992-08 | 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 | |
| 61045 | 34789a3a-4646-4e7a-85cf-4caf69b65b12 | personStatement | 2020-05-07 | false | knownPerson | 1970-05 | 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 | |
| 6623 | a82a4ff1-48dd-4aa1-8f72-1c2fe5e7e346 | personStatement | 2020-05-07 | false | knownPerson | 1999-08 | 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 | |
| 82467 | f6663cef-239e-4bda-a211-92c08260cd81 | personStatement | 2020-05-07 | false | knownPerson | 1993-10 | 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 | |
| 85947 | 216f6cf1-aaf0-4b00-82ca-c4715822f058 | personStatement | 2020-05-07 | false | knownPerson | 1962-08 | 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 | |
| 86731 | 03769082-824f-4755-a4dc-7da58eaa7745 | personStatement | 2020-05-07 | false | knownPerson | 1972-09 | 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 [person_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [persontype] TEXT , [birthdate] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [source_type] TEXT , [unspecifiedpersondetails_reason] TEXT , PRIMARY KEY ([_link]) );