person_statement
64 rows where "statementdate" is on date 2018-06-14 sorted by source_type
This data as json, CSV (advanced)
Suggested facets: iscomponent, persontype, birthdate, publicationdetails_publicationdate, unspecifiedpersondetails_reason, publicationdetails_publicationdate (date)
_link | statementid | statementtype | statementdate | iscomponent | persontype | birthdate | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type ▼ | unspecifiedpersondetails_reason |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4724 | 51929e4a-e0c0-43e1-b449-f2a9b3cbe6b8 | personStatement | 2018-06-14 | false | knownPerson | 1979-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 | |
8666 | 5dbabad4-a227-4657-8f39-d4c9d9d536ff | personStatement | 2018-06-14 | false | knownPerson | 1959-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 | |
8705 | 625ac10d-68d8-4253-ac03-53f4ef1b24c8 | personStatement | 2018-06-14 | false | knownPerson | 1953-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 | |
14665 | 8fa1d457-6d75-4856-bf00-58aceb3b2e7f | personStatement | 2018-06-14 | 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 | |
14666 | b72121ec-c695-4485-bdd8-bdc2afcc1dec | personStatement | 2018-06-14 | false | knownPerson | 1958-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 | |
14736 | 2c01d763-3b1e-4b51-aee2-687c1b203fc5 | personStatement | 2018-06-14 | false | knownPerson | 1941-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 | |
14737 | 25513370-3644-48cc-a524-349a1d0b728f | personStatement | 2018-06-14 | false | knownPerson | 1961-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 | |
17319 | 34b35764-ee80-4ad9-8f0e-c1f824b333ac | personStatement | 2018-06-14 | false | knownPerson | 1964-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 | |
17704 | 60656999-afc4-4193-b1d8-a4fa75ee9fc3 | personStatement | 2018-06-14 | false | knownPerson | 1995-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 | |
19764 | 976592bd-1ebb-49c2-99ef-2221cabacb79 | personStatement | 2018-06-14 | false | knownPerson | 1976-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 | |
19765 | 9bc44ea2-1cd2-4982-8380-b1d1260c2613 | personStatement | 2018-06-14 | false | knownPerson | 1984-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 | |
30583 | 75f8f9e1-bbc3-4b77-8566-46d3c011ad1b | personStatement | 2018-06-14 | false | knownPerson | 1988-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 | |
40718 | 7d98aceb-75a1-4511-99a5-8e867b86898e | personStatement | 2018-06-14 | false | knownPerson | 1983-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 | |
44634 | edf60be0-7b05-4b9e-ac98-e1c00f0933a1 | personStatement | 2018-06-14 | false | knownPerson | 1960-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 | |
44635 | 7c1738ee-2c99-4e4e-a524-21658686acd8 | personStatement | 2018-06-14 | false | knownPerson | 1960-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 | |
44999 | ab791d89-e94a-4102-8b2a-8ae945e46298 | personStatement | 2018-06-14 | false | knownPerson | 1968-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 | |
54014 | 8d7d8b2e-7e69-439c-bbb9-35823043f8f2 | personStatement | 2018-06-14 | false | knownPerson | 1971-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 | |
64557 | 45a78c8b-1e0a-418a-b141-b751fc2628cb | personStatement | 2018-06-14 | false | knownPerson | 1981-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 | |
67758 | 074e0271-549c-4747-b4be-23735fd03796 | personStatement | 2018-06-14 | false | knownPerson | 1984-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 | |
70645 | 2b339fd7-a9aa-44ed-beed-6edf4c7e9a6b | personStatement | 2018-06-14 | false | knownPerson | 1975-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 | |
71721 | e8c48aac-6edc-4d71-bed0-5cd5e8e234d2 | personStatement | 2018-06-14 | false | knownPerson | 1988-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 | |
78930 | 71f3c82d-77d1-4194-a577-d85ed1306757 | personStatement | 2018-06-14 | false | knownPerson | 1978-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 | |
84036 | 94dc172b-828f-4bd6-8eca-bac6b51a00e5 | personStatement | 2018-06-14 | false | knownPerson | 1976-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 | |
87177 | e9c21450-932d-47a0-9782-38562a991958 | personStatement | 2018-06-14 | false | knownPerson | 1932-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 | |
90317 | 3be6d32e-43b5-4016-9d61-cefd8f6e62b8 | personStatement | 2018-06-14 | false | knownPerson | 1981-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 | |
92988 | 6e2ab7e8-0ed4-4871-b088-c4394df25cc2 | personStatement | 2018-06-14 | false | knownPerson | 1956-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 | |
92989 | b5f9cd26-037b-4c24-a10e-4b6fa4576027 | personStatement | 2018-06-14 | false | knownPerson | 1967-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 | |
97585 | 2fd0ae40-f137-42fd-9d55-289079eae13d | personStatement | 2018-06-14 | false | knownPerson | 1952-10 | 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 | |
99845 | 32e4767c-e7e4-41b3-b54f-c979eea9bbf5 | personStatement | 2018-06-14 | false | knownPerson | 1984-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 | |
99846 | d8c6e065-1fa9-457d-937f-a72d059efde7 | personStatement | 2018-06-14 | false | knownPerson | 1977-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 | |
100512 | 7f66f35f-3c15-4f0f-bc22-dfe932486ca5 | personStatement | 2018-06-14 | false | knownPerson | 1984-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 | |
100513 | c7de1904-5089-482c-bb8d-f067518632ae | personStatement | 2018-06-14 | false | knownPerson | 1992-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 | |
100514 | b516e03b-3841-4954-8881-3284f3aa8728 | personStatement | 2018-06-14 | false | knownPerson | 1994-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 | |
100515 | 80c94bc2-97e3-4fa5-a0f5-cbae537d94c8 | personStatement | 2018-06-14 | false | knownPerson | 1986-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 | |
100516 | e4dd097e-3db6-4b4a-94f9-f003cb1b3ec7 | personStatement | 2018-06-14 | false | knownPerson | 1961-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 | |
100517 | 0ba0b5f5-b349-49a7-85c1-ce041d37a386 | personStatement | 2018-06-14 | false | knownPerson | 1992-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 | |
100518 | 3795e788-0a53-4a5a-8510-766522fbe3a5 | personStatement | 2018-06-14 | false | knownPerson | 1969-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 | |
100519 | 117c8cef-546a-4ce8-a310-8124946faedd | personStatement | 2018-06-14 | false | knownPerson | 1989-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 | |
100520 | 98ef01c7-bd74-4b39-b73d-535e4d26b8ab | personStatement | 2018-06-14 | false | knownPerson | 1989-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 | |
100521 | 75d0a848-9114-4f3f-b66b-444cdd795458 | personStatement | 2018-06-14 | false | knownPerson | 1974-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 | |
100522 | c5c62746-8e72-4f19-abd7-c797467c0d42 | personStatement | 2018-06-14 | false | knownPerson | 1993-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 | |
100523 | 8560c94b-b3e9-4222-b40f-1671ffb6c66b | personStatement | 2018-06-14 | false | knownPerson | 1960-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 | |
100524 | 4cdc1604-f212-491a-9e96-23019601bdc2 | personStatement | 2018-06-14 | false | knownPerson | 1996-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 | |
100525 | 7d5d9a20-f987-44e7-a0be-d869a3910f54 | personStatement | 2018-06-14 | false | knownPerson | 1973-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 | |
100526 | 6f0c8284-9ba4-4f88-a0fa-edf867641c83 | personStatement | 2018-06-14 | false | knownPerson | 1973-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 | |
100530 | 61302f00-b2d9-4ff3-8805-6c17cf6bf8e9 | personStatement | 2018-06-14 | false | knownPerson | 1989-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 | |
100531 | 3fef1636-9e53-4628-b4ea-1467c0644e28 | personStatement | 2018-06-14 | false | knownPerson | 1983-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 | |
100533 | a966d19e-8cee-47f4-9a86-8b5cfe121892 | personStatement | 2018-06-14 | false | knownPerson | 1989-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 | |
100534 | 0a8551f2-4cf9-432e-ba4b-172b47caa649 | personStatement | 2018-06-14 | false | knownPerson | 1989-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 | |
100535 | 379feb0b-e86c-4c10-8d36-6826a7fa9a38 | personStatement | 2018-06-14 | false | knownPerson | 1996-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 | |
100536 | 1037f41b-da25-4d30-9cd9-9f091827a136 | personStatement | 2018-06-14 | false | knownPerson | 1956-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 | |
100537 | b170388f-4383-4164-b985-e507f95ec1be | personStatement | 2018-06-14 | false | knownPerson | 1985-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 | |
100538 | 77327e39-baaa-4c50-96c0-b3aba6a01546 | personStatement | 2018-06-14 | false | knownPerson | 1993-01 | 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 | |
100539 | fba9b3c2-ac30-483f-bd13-5e3e1fc51218 | personStatement | 2018-06-14 | false | knownPerson | 1962-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 | |
100541 | 9777d7f9-9bbb-49bc-bf21-5b60b11354db | personStatement | 2018-06-14 | false | knownPerson | 1985-01 | 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 | |
100542 | ccd54a60-a913-4b36-a54a-adb8d790bcaa | personStatement | 2018-06-14 | false | knownPerson | 1966-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 | |
100543 | 37c95bf0-667e-4dd0-844b-28767f7a6bbc | personStatement | 2018-06-14 | false | knownPerson | 1975-10 | 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 | |
100545 | 752bdd36-c6aa-4b08-8c14-7536c1723a53 | personStatement | 2018-06-14 | false | knownPerson | 1980-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 | |
100546 | 99edce10-62f2-4520-b782-cea9bf67149b | personStatement | 2018-06-14 | false | knownPerson | 1988-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 | |
100547 | 7b8de57d-1990-414e-9047-30bcc8e23575 | personStatement | 2018-06-14 | false | knownPerson | 1980-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 | |
109933 | bc2438a1-0785-4101-9a51-d7e32c2934e0 | personStatement | 2018-06-14 | false | knownPerson | 1982-10 | 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 | |
111178 | f183899c-8578-425f-bcde-f5ab55482351 | personStatement | 2018-06-14 | false | knownPerson | 1968-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 | |
127569 | be9716bc-38d9-4541-8370-e454e038bf5d | personStatement | 2018-06-14 | false | knownPerson | 1963-01 | 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 | |
135580 | 48f06670-9f32-4c24-a1be-fd4378f053bf | personStatement | 2018-06-14 | true | anonymousPerson | 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 | interested-party-exempt-from-disclosure |
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]) );