ooc_statement
47 rows where "statementdate" is on date 2019-06-05 sorted by interestedparty_describedbypersonstatement
This data as json, CSV (advanced)
Suggested facets: subject_describedbyentitystatement, publicationdetails_publicationdate, publicationdetails_publicationdate (date)
_link | statementid | statementtype | statementdate | iscomponent | subject_describedbyentitystatement | interestedparty_describedbypersonstatement ▼ | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type | interestedparty_describedbyentitystatement | componentstatementids | interestedparty_unspecified_reason | interestedparty_unspecified_description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
124258 | 8ba15fa9-daa9-4f60-a31a-9dc2b6ac7f9c | ownershipOrControlStatement | 2019-06-05 | false | 2045b066-f277-43a4-bc1a-52a849592353 | 0820a177-c311-4204-9ef5-11a61c808531 | 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 | ||||
104334 | 93662f58-a787-4338-9700-6998ae49bb7b | ownershipOrControlStatement | 2019-06-05 | false | 916694da-ccc4-48a4-9ff6-92c673b183c3 | 0dd48c67-c1f2-4322-a864-ae04256ee639 | 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 | ||||
78405 | 804db080-3ff8-46fa-97f3-1f1c7e683d4c | ownershipOrControlStatement | 2019-06-05 | false | fac65241-0720-4464-aebe-ac47c7ab6d93 | 1252b8a8-298e-4c9c-9ec8-9674045afcdc | 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 | ||||
73856 | eb3e04a2-c584-436d-96b0-a6010b96d549 | ownershipOrControlStatement | 2019-06-05 | false | aa9f5fe8-c459-4c48-9c53-10100cd23b6b | 142d841f-73dd-4346-b151-14b11cb6d4a7 | 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 | ||||
40198 | c4076605-a940-4c6f-b84a-7a6c8e467e5d | ownershipOrControlStatement | 2019-06-05 | false | 8510eff7-4796-4898-a4ac-5c06691c1ce8 | 16a218a8-8d90-40b9-99b2-f0e0946cac59 | 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 | ||||
76541 | 284bd411-3bc9-4ef0-9bff-8dbb308f65f5 | ownershipOrControlStatement | 2019-06-05 | false | 958edbd8-86b6-4398-96d1-5f9d302d933e | 1a977582-6459-4a40-9e8f-03ec21bc1a1c | 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 | ||||
26211 | 6203c5a9-0ca8-467b-80b3-8947430c2e37 | ownershipOrControlStatement | 2019-06-05 | false | 66293a1e-5a9c-4a62-bea1-f42b7b8aa99c | 237edb13-baf9-436a-bb36-b51bd47495c4 | 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 | ||||
141385 | 92d630d8-0c43-4f96-8f68-ea3d04a3e72e | ownershipOrControlStatement | 2019-06-05 | false | b6368eeb-9f10-4567-9dfd-9d64ed7a4838 | 2b1c67d6-28b6-434c-8b95-afafc716fa47 | 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 | ||||
141386 | c52fa24a-5a4e-4af1-add4-4ed07dd7c5a4 | ownershipOrControlStatement | 2019-06-05 | false | b6368eeb-9f10-4567-9dfd-9d64ed7a4838 | 2b1c67d6-28b6-434c-8b95-afafc716fa47 | 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 | ||||
70503 | 8d0e07bc-0d8a-486f-9b97-42d7a1e08665 | ownershipOrControlStatement | 2019-06-05 | false | f8328b30-0008-47b6-9ddb-3ccbf8500fea | 2c64d9da-1b12-4414-aa94-f00f7df924ed | 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 | ||||
76540 | 0a616c86-9768-441d-b08d-00b0802d9782 | ownershipOrControlStatement | 2019-06-05 | false | 958edbd8-86b6-4398-96d1-5f9d302d933e | 2e330cfe-0a77-45df-bf43-c0ef35eea687 | 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 | ||||
112450 | 4e2db573-8321-4222-ad3f-cf45fbf8c477 | ownershipOrControlStatement | 2019-06-05 | false | f5d772d0-3d5a-45d1-8037-12387d96127e | 3956a8e6-0a84-4592-8a2c-b5b8994db160 | 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 | ||||
85871 | 69f30a6b-cc98-4ad2-a91d-951d993d395b | ownershipOrControlStatement | 2019-06-05 | false | 45d7078c-148d-40ff-9418-e279009e4fc6 | 46206cfa-6d4b-4936-a2f4-7f3fca9c1536 | 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 | ||||
141383 | 7350903a-d14a-4e7b-87a4-3565657dfdfd | ownershipOrControlStatement | 2019-06-05 | false | b6368eeb-9f10-4567-9dfd-9d64ed7a4838 | 51312e3b-0cd4-44aa-8f5a-e0eba0b33bf2 | 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 | ||||
141384 | cf01e9ce-d510-4331-b82c-6cba4b955c7e | ownershipOrControlStatement | 2019-06-05 | false | b6368eeb-9f10-4567-9dfd-9d64ed7a4838 | 51312e3b-0cd4-44aa-8f5a-e0eba0b33bf2 | 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 | ||||
75088 | bf3a525a-0eea-4994-b9f6-2467e569171c | ownershipOrControlStatement | 2019-06-05 | false | 75da11d3-f965-4503-9db5-78aff103454c | 57abde7f-90f9-463d-817f-af29593e1ea8 | 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 | ||||
100435 | 338dc768-c98a-4911-a3ff-951d3f03a21d | ownershipOrControlStatement | 2019-06-05 | false | 8e08915d-17ea-4136-b03e-a28112fca0ec | 5bc1be2f-c55f-4aec-b376-253fd97fe171 | 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 | ||||
70502 | 86eef054-9a9e-407a-ba2d-68fecf1ce78a | ownershipOrControlStatement | 2019-06-05 | false | f8328b30-0008-47b6-9ddb-3ccbf8500fea | 63ceee40-9b57-43f8-9486-1818435e7d5f | 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 | ||||
64376 | 6a90d400-7cb9-42ee-afa4-409f70c526fc | ownershipOrControlStatement | 2019-06-05 | false | c7821281-8a36-4532-9174-43c99b6c72b6 | 642e8913-b39e-4f6c-9d3e-46c903332306 | 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 | ||||
124259 | 669e3c1a-d9d7-4249-b0bd-0dfd1e86b2d6 | ownershipOrControlStatement | 2019-06-05 | false | 2045b066-f277-43a4-bc1a-52a849592353 | 68fab89c-8269-473f-8d6b-798c072cd05d | 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 | ||||
105374 | 56be98cd-d4d2-448c-9dfc-7ae4e823f00d | ownershipOrControlStatement | 2019-06-05 | false | e8474bae-a3dd-463f-a868-f2707e75e438 | 757e8c65-7b4f-497a-9655-8121f1d46389 | 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 | ||||
22385 | b5b33ae8-0fb2-42f3-b969-6d5f930b616a | ownershipOrControlStatement | 2019-06-05 | false | bc1e832d-e9bd-4ca5-88c1-82d5a3cb535a | 7c9ae6da-4f20-4d6c-854f-d730cc93d80e | 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 | ||||
68998 | 00f49998-f64c-46d5-93e3-f9479957ab59 | ownershipOrControlStatement | 2019-06-05 | false | 53a46d97-8f40-46bc-a710-9f8820793cea | 7dbc9f11-9228-4396-8fec-b041124bc138 | 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 | ||||
15113 | 1d61de54-1a55-4a8c-ad01-6cbef7a67140 | ownershipOrControlStatement | 2019-06-05 | false | 202d079a-ce13-4a8e-8055-6a31b3bdb161 | 81b64e15-2fa0-4cdc-802e-0348ff6808a6 | 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 | ||||
136711 | 7d2060b6-bd18-4ed6-9e63-29c411e0858d | ownershipOrControlStatement | 2019-06-05 | false | 4186efe7-c723-4b3c-b964-a3a15fa6cf8b | 82a06dcd-716b-473d-877a-d775741ebe99 | 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 | ||||
73983 | 5794e1ca-1f06-4069-8841-c72fc4a46a31 | ownershipOrControlStatement | 2019-06-05 | false | 4485668f-a43a-47be-9592-d1bbdff28132 | 8d85fe60-de9d-4e38-a228-dd1430627187 | 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 | ||||
79904 | 1bc0e4fd-a650-40a0-88af-f9bd9b6d9a12 | ownershipOrControlStatement | 2019-06-05 | false | fd222597-7028-4b59-9be3-e02dc77d295a | 8e85fc06-eaf7-49a8-87e5-40dae38559e8 | 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 | ||||
70716 | 7608d796-90da-4c38-9168-d93fe3c4e7c3 | ownershipOrControlStatement | 2019-06-05 | false | 495198cb-ced3-4228-84af-0ed68d7c21dd | 921ce274-374e-4e82-9516-624fd7f21494 | 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 | ||||
15115 | 9bb25288-50fc-41f8-af7c-f4288760620a | ownershipOrControlStatement | 2019-06-05 | false | 202d079a-ce13-4a8e-8055-6a31b3bdb161 | 92a6ab23-f5d3-47be-bba2-497c59183b4a | 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 | ||||
96768 | ca761cf2-07bb-45e3-8ab6-604660362598 | ownershipOrControlStatement | 2019-06-05 | false | cfa3a7fe-677d-4c5b-8970-bb01e5213d85 | 9c2a8f1f-858d-435f-ac6a-753706b6c51e | 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 | ||||
133878 | ed262c9b-c25f-47ac-ab0e-133e70c2358a | ownershipOrControlStatement | 2019-06-05 | false | 873ac88d-c0ce-479c-8ce6-bfb439dcdcac | 9c4b5cf7-624d-4885-95cd-c4a0c7f2e81a | 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 | ||||
100434 | 3a5eda27-8ac7-4c65-88f3-5432c6cb510d | ownershipOrControlStatement | 2019-06-05 | false | 8e08915d-17ea-4136-b03e-a28112fca0ec | a33d9399-b42c-4a1c-addb-8b25be04c5c3 | 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 | ||||
79903 | 1444ffa8-4a55-440a-99cd-fadee82a170c | ownershipOrControlStatement | 2019-06-05 | false | fd222597-7028-4b59-9be3-e02dc77d295a | ad4aa983-d3d3-4509-83ce-906ac8987066 | 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 | ||||
17976 | 0fa88165-98a1-424f-be8a-f1aa25b1769b | ownershipOrControlStatement | 2019-06-05 | false | aa3c1d3c-cc07-4af3-aec0-358434a8f95b | b2c1aaf2-f1cf-4340-9cf6-f232900246cf | 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 | ||||
110852 | 6fb6b666-bf6a-4cfa-88ec-c6493518fd34 | ownershipOrControlStatement | 2019-06-05 | false | 497bc929-5b49-4dd3-8a26-21ccc65a7a5f | b3418720-a68b-46c5-a3ff-06ed44ffce74 | 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 | ||||
60942 | 0461cf57-83ae-4d29-a13e-8f1790d962fc | ownershipOrControlStatement | 2019-06-05 | false | 09ea2c80-70df-42a5-84d1-aa0ccc06dde5 | b7813552-7074-4a5c-b609-beca28ba737c | 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 | ||||
60801 | 584fe43a-1b57-4a01-bfdb-3d486499d54c | ownershipOrControlStatement | 2019-06-05 | false | 8ca7b2cb-fa5e-4747-907e-a239ae267933 | bf78eca3-92b6-4a67-b09f-c52fedc414ab | 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 | ||||
15112 | caa81e41-f35e-4814-9919-6fc1e37a16ac | ownershipOrControlStatement | 2019-06-05 | false | 202d079a-ce13-4a8e-8055-6a31b3bdb161 | c19298e7-c555-469f-8b16-70ce7992eee9 | 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 | ||||
125758 | f134d16a-3412-41b9-b990-8c1a57d269e4 | ownershipOrControlStatement | 2019-06-05 | false | 30f21850-6cc5-4aec-9cdc-d7bb01e24de6 | c24e6124-0304-4ef1-9330-312c9d018c07 | 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 | ||||
41206 | 61d4abd0-886e-4fde-9405-c1a74ddc2363 | ownershipOrControlStatement | 2019-06-05 | false | fad661c8-634e-47ba-a96a-119790ef3525 | c6a25aa1-299a-4ea7-b5dc-351f07afce73 | 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 | ||||
140043 | 16559857-796f-4b3d-afda-e7e9006c6dc3 | ownershipOrControlStatement | 2019-06-05 | false | 91361e60-8896-4235-ad16-abd56f2767db | d81a4612-3fd4-482f-9de8-2d8fc22933a3 | 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 | ||||
15114 | e7421062-85e6-438e-a726-e1da4582d6fb | ownershipOrControlStatement | 2019-06-05 | false | 202d079a-ce13-4a8e-8055-6a31b3bdb161 | e006995b-3d31-4618-9fd4-33f4eae1e0a4 | 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 | ||||
96769 | 78085cbe-9b32-4151-bdcd-76eed6209b33 | ownershipOrControlStatement | 2019-06-05 | false | cfa3a7fe-677d-4c5b-8970-bb01e5213d85 | ebf6903e-c3f2-4428-bcc7-0d77b3582d95 | 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 | ||||
140044 | 77dd07e4-5e31-4e31-b9a6-67731b12fe3e | ownershipOrControlStatement | 2019-06-05 | false | 91361e60-8896-4235-ad16-abd56f2767db | ec6dc419-fa30-4849-b7a3-0a56ee86436a | 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 | ||||
22386 | 978949f0-6cfc-43e0-9463-8746399e002a | ownershipOrControlStatement | 2019-06-05 | false | bc1e832d-e9bd-4ca5-88c1-82d5a3cb535a | eda02e09-7dcc-4ce3-9733-20b6f85cd6fa | 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 | ||||
85870 | 9b4675ba-425e-43c4-8cde-1e79ab7b9326 | ownershipOrControlStatement | 2019-06-05 | false | 45d7078c-148d-40ff-9418-e279009e4fc6 | f965a80b-2760-4320-b6c2-dbb51e6e9e0b | 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 | ||||
15111 | 3938cfe5-23cc-4a9e-b95b-7d2f551aa75b | ownershipOrControlStatement | 2019-06-05 | false | 202d079a-ce13-4a8e-8055-6a31b3bdb161 | fb8804c4-3b52-48f8-8d5b-1802edad3216 | 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 [ooc_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [subject_describedbyentitystatement] TEXT , [interestedparty_describedbypersonstatement] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [source_type] TEXT , [interestedparty_describedbyentitystatement] TEXT , [componentstatementids] TEXT , [interestedparty_unspecified_reason] TEXT , [interestedparty_unspecified_description] TEXT , PRIMARY KEY ([_link]) );