person_statement
12 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-19 and "statementdate" is on date 2020-07-20
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100290 | 0f438f8c-b8f7-4b58-9d40-2172c39006a0 | personStatement | 2020-07-20 | false | knownPerson | 1978-11 | 2021-01-19 | 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 | |
| 100348 | 47b02957-b1de-4799-90d3-d38c2d3b3310 | personStatement | 2020-07-20 | false | knownPerson | 1990-04 | 2021-01-19 | 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 | |
| 101231 | 184347a6-22ff-46bd-bb89-40173a2572a3 | personStatement | 2020-07-20 | false | knownPerson | 1984-09 | 2021-01-19 | 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 | |
| 101232 | 7568390c-4d86-47be-84ed-f8e28c560144 | personStatement | 2020-07-20 | false | knownPerson | 1951-02 | 2021-01-19 | 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 | |
| 114841 | 62254922-e4b1-4d71-a20d-b0cfb1bc602f | personStatement | 2020-07-20 | false | knownPerson | 1961-04 | 2021-01-19 | 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 | |
| 124688 | 32676153-7ec9-4cb0-b546-ac053eb923d5 | personStatement | 2020-07-20 | false | knownPerson | 1964-03 | 2021-01-19 | 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 | |
| 125573 | cb9e44c9-7482-4147-9738-0fe0bd6f216b | personStatement | 2020-07-20 | false | knownPerson | 1968-07 | 2021-01-19 | 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 | |
| 125574 | b3e3a204-bcd7-4e6f-bbfb-2799745a9f37 | personStatement | 2020-07-20 | false | knownPerson | 1982-12 | 2021-01-19 | 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 | |
| 129417 | f3435372-60e7-4878-868f-5990fc1d2398 | personStatement | 2020-07-20 | false | knownPerson | 1982-08 | 2021-01-19 | 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 | |
| 131430 | 17c804dd-eff9-4e95-a1a1-064294201df9 | personStatement | 2020-07-20 | false | knownPerson | 1986-07 | 2021-01-19 | 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 | |
| 93395 | f440c299-2ab4-417d-8594-30da912035d4 | personStatement | 2020-07-20 | false | knownPerson | 1956-02 | 2021-01-19 | 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 | |
| 96028 | 11b32b58-f920-480c-b1ba-8d9b826dd129 | personStatement | 2020-07-20 | false | knownPerson | 1951-11 | 2021-01-19 | 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]) );