person_statement

10 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-19 and "statementdate" is on date 2020-09-15

✎ View and edit SQL

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
100810 7aff072d-4114-4f32-8e1e-5c0a85b35dae personStatement 2020-09-15 false knownPerson 1987-06 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  
102210 023cd576-8daf-4efb-b7a9-d603928632f8 personStatement 2020-09-15 false knownPerson 1981-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  
104133 0ae9296a-a56b-4c20-8a44-666b398d9e48 personStatement 2020-09-15 false knownPerson 1962-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  
106092 be426b3c-8580-48d4-b10d-0fcdfa811160 personStatement 2020-09-15 false knownPerson 1989-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  
130910 cb8025a1-4745-4b4d-8a49-43269baba7d3 personStatement 2020-09-15 false knownPerson 1987-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  
133657 0a426943-2a68-49f6-955f-07d08a959804 personStatement 2020-09-15 false knownPerson 1977-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  
91999 f4dfb0cb-9dd4-4a4b-b422-4cf4592d4d05 personStatement 2020-09-15 false knownPerson 1999-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  
96005 d84988e5-bf81-40b8-86f5-6a839e5df4f4 personStatement 2020-09-15 false knownPerson 1988-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  
96140 7b797298-e85d-41c8-bb2b-d558419877da personStatement 2020-09-15 false knownPerson 1959-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  
98795 6c5d40a4-94dd-4530-94b7-047810ceb63b personStatement 2020-09-15 false knownPerson 1982-05 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

CSV options: 

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]) 
);