person_statement
22 rows where iscomponent = "false", "publicationdetails_publicationdate" is on date 2021-01-18 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14457 | 4ebaaada-cf76-42e1-b4f8-c5d81c239a6f | personStatement | 2020-07-20 | 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 | |
| 15460 | 5b30337c-5721-402c-96d6-f5f706b98f0a | personStatement | 2020-07-20 | false | knownPerson | 1955-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 | |
| 15461 | 32170a63-7617-49e5-81e2-69483d4cf68c | personStatement | 2020-07-20 | false | knownPerson | 1962-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 | |
| 16150 | 820a55a4-09eb-4aff-98e2-10de89b8bb99 | personStatement | 2020-07-20 | false | knownPerson | 1983-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 | |
| 18350 | be85ea55-75c3-4e8f-96ac-8049ddd29e65 | personStatement | 2020-07-20 | false | knownPerson | 1958-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 | |
| 19150 | 9a078f91-f9a1-404f-a879-45a763ec9433 | personStatement | 2020-07-20 | false | knownPerson | 1960-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 | |
| 20238 | d04c1ae0-b4f3-4213-9557-abb4697ee8cd | personStatement | 2020-07-20 | false | knownPerson | 1973-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 | |
| 20475 | 3c744c9f-629e-4d45-94fd-11f0431781c0 | personStatement | 2020-07-20 | false | knownPerson | 1961-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 | |
| 28825 | af53fa0a-029c-4251-9c9e-082254a99ef4 | personStatement | 2020-07-20 | false | knownPerson | 1976-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 | |
| 3832 | bea0a9ff-218e-4f76-a308-e3bb6f14a2a1 | personStatement | 2020-07-20 | false | knownPerson | 1990-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 | |
| 42399 | 00f83615-3305-4180-99b3-d1e53057455a | personStatement | 2020-07-20 | false | knownPerson | 1982-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 | |
| 59186 | 5da3146a-6950-424f-943a-ff8b897c3ee8 | personStatement | 2020-07-20 | false | knownPerson | 1974-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 | |
| 69715 | 9087181b-ee6d-4683-b0eb-bc298110a167 | personStatement | 2020-07-20 | false | knownPerson | 1986-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 | |
| 69862 | 8d9b1d02-0e53-4897-a083-0ad3e549aeb4 | personStatement | 2020-07-20 | false | knownPerson | 1976-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 | |
| 70589 | 27d93086-b45b-449e-b5fe-2b43825550be | personStatement | 2020-07-20 | false | knownPerson | 1957-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 | |
| 73662 | bb0ea449-2331-4222-96ef-4dfcd1d1155f | personStatement | 2020-07-20 | false | knownPerson | 1977-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 | |
| 73919 | f180f665-fe44-4ff7-b477-d3fad5a1059b | personStatement | 2020-07-20 | false | knownPerson | 1966-06 | 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 | |
| 75491 | d2da04b8-a6ce-41e0-aed7-0ef964bb5b65 | personStatement | 2020-07-20 | false | knownPerson | 1972-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 | |
| 75492 | 6b65f5cf-250a-4f28-816f-abd6603c9968 | personStatement | 2020-07-20 | 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 | |
| 80710 | 19f68239-200d-4d18-9f79-edab6f8545d9 | personStatement | 2020-07-20 | false | knownPerson | 1997-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 | |
| 85037 | 0c3796d9-6961-4250-907e-fd0c76b58d4b | personStatement | 2020-07-20 | false | knownPerson | 1985-06 | 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 | |
| 86175 | 10f69396-49b8-4639-918c-44f0db825982 | personStatement | 2020-07-20 | false | knownPerson | 1975-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
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]) );