person_statement

28 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2020-09-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: birthdate, statementdate (date)

_link ▼ statementid statementtype statementdate iscomponent persontype birthdate publicationdetails_publicationdate publicationdetails_bodsversion publicationdetails_license publicationdetails_publisher_name publicationdetails_publisher_url source_type unspecifiedpersondetails_reason
12967 53cb7cd2-6243-4f08-84c2-a3c2a3e8ba49 personStatement 2020-09-18 false knownPerson 1979-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  
18383 47f7e4a9-d2d4-429c-b86f-a6257907c197 personStatement 2020-09-18 false knownPerson 1974-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  
23904 a6f33c5a-16bd-4f41-851e-c879d6e48fec personStatement 2020-09-18 false knownPerson 1956-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  
24220 1f0bee24-1f9c-4ffa-abbf-89d305f4df07 personStatement 2020-09-18 false knownPerson 1979-12 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  
26570 1adb87c9-fa65-47b7-9f9e-2168268bda56 personStatement 2020-09-18 false knownPerson 1980-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  
30660 89fa6974-77ab-4d24-9f95-ab8ebd793fbb personStatement 2020-09-18 false knownPerson 1978-04 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  
4260 e5e7c750-afb6-4341-b832-48822b2e4f23 personStatement 2020-09-18 false knownPerson 1963-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  
4261 e9b05cca-4e48-4ce2-b86d-e25b26f30b1d personStatement 2020-09-18 false knownPerson 1947-04 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  
4262 2057b6e0-982e-46c4-aa0b-bfd89e93a13c personStatement 2020-09-18 false knownPerson 1956-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  
4263 007f6f33-670c-43fa-bcf2-8f01dad98348 personStatement 2020-09-18 false knownPerson 1974-12 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  
43978 c45e319e-6af2-40dd-8ab6-6dd978d56a38 personStatement 2020-09-18 false knownPerson 1979-02 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  
44566 c55b8f7c-1a6a-4fc7-a496-60b3cd89dc0c personStatement 2020-09-18 false knownPerson 1961-02 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  
47109 e79c565b-a34b-4945-8d47-fa32ed0ff622 personStatement 2020-09-18 false knownPerson 1985-12 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  
47110 e64ba089-d952-489a-826b-e32d6bac19a6 personStatement 2020-09-18 false knownPerson 1964-07 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  
48758 d47116bf-2374-40cd-9323-f4c8bab892a9 personStatement 2020-09-18 false knownPerson 1985-12 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  
48759 e1aec2a4-94eb-42e1-8760-9e5a385b5c0b personStatement 2020-09-18 false knownPerson 1964-07 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  
54132 deef9c05-fa80-47bc-b894-a8e97df7b196 personStatement 2020-09-18 false knownPerson 1965-11 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  
56366 42fa9f0c-6bd7-4b7e-897f-65b6f8150352 personStatement 2020-09-18 false knownPerson 1985-12 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  
56367 ad484e41-2cce-430a-8ef8-dd61ebf3b3a8 personStatement 2020-09-18 false knownPerson 1964-07 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  
59459 ba3f807f-2315-4098-a0cd-618af0624ba7 personStatement 2020-09-18 false knownPerson 1973-03 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  
59460 b2352320-f7fb-4a5d-917d-a758a42f5901 personStatement 2020-09-18 false knownPerson 1985-01 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  
6432 25d97ab9-9e18-4b1c-9a3b-96e3a0d065d6 personStatement 2020-09-18 false knownPerson 1968-03 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  
67772 b21218af-c888-4550-a7ca-1cb14785abe0 personStatement 2020-09-18 false knownPerson 1992-03 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  
71359 e1b14dc8-30c4-4fc9-a394-7865f00e53b4 personStatement 2020-09-18 false knownPerson 1986-01 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  
71786 284fa197-9bce-4786-91ea-4880123ed671 personStatement 2020-09-18 false knownPerson 1946-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  
73310 a22ba88b-d9a2-41a8-999f-97f3f93d7cf2 personStatement 2020-09-18 false knownPerson 1980-07 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  
83675 63ebc78b-f6db-41f6-9d5d-894b3ad210ae personStatement 2020-09-18 false knownPerson 1969-02 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  
8508 08831251-374b-4025-ae6f-3aae138b80b1 personStatement 2020-09-18 false knownPerson 1965-04 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

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