entity_statement
52 rows where "foundingdate" is on date 2016-03-10
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), publicationdetails_publicationdate (date)
_link ▼ | statementid | statementtype | statementdate | iscomponent | entitytype | name | foundingdate | incorporatedinjurisdiction_name | incorporatedinjurisdiction_code | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type | unspecifiedentitydetails_reason | unspecifiedentitydetails_description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101860 | 44658f66-dee5-4ef4-ac72-e101f854995a | entityStatement | 2018-04-04 | false | registeredEntity | SIA "CP GROUP" | 2016-03-10 | Latvia | LV | 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 | ||
101861 | 061deb2b-2537-4c2a-bab4-f14822ed10b1 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "HBH Latvija" | 2016-03-10 | Latvia | LV | 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 | ||
105789 | 7f103b2b-6962-40af-8c6d-7aab4d060d53 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Allex Service" | 2016-03-10 | Latvia | LV | 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 | ||
111330 | 2536e069-6755-4de7-8b38-935f9c322b82 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Meža Dimzas" | 2016-03-10 | Latvia | LV | 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 | ||
111331 | 59eaf342-1e7e-4ab6-a621-3098b8f99e23 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "REGUL-A" | 2016-03-10 | Latvia | LV | 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 | ||
111332 | e1c797e4-4bac-4aee-9029-a2b8fc4be05d | entityStatement | 2019-07-16 | false | registeredEntity | SIA "MIXJAN" | 2016-03-10 | Latvia | LV | 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 | ||
70939 | d667e72c-525e-43a2-a067-1569beae5c28 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AUTO DITS" | 2016-03-10 | Latvia | LV | 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 | ||
70940 | bfb960e9-4294-4fad-af6d-0b9349c16ba8 | entityStatement | 2019-02-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TEMPO TIME" | 2016-03-10 | Latvia | LV | 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 | ||
70941 | b6153ab7-1ae8-4a15-9ce3-25b94a745c7f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GO SMART" | 2016-03-10 | Latvia | LV | 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 | ||
70942 | 5b3fb37c-0e1e-49e6-be75-ce9808111aad | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Arts Company" | 2016-03-10 | Latvia | LV | 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 | ||
70943 | 2a5d2790-c38a-4cd5-a566-ee19575994c1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Agora Metals" | 2016-03-10 | Latvia | LV | 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 | ||
70944 | f48a8b41-2d69-4cca-8172-29ebd69663de | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CLOUD STORAGE" | 2016-03-10 | Latvia | LV | 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 | ||
70945 | fb8ad428-00f8-4e9a-97e3-6d89cb3aa8af | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PINO GIARDINO COSTRUZIONI" | 2016-03-10 | Latvia | LV | 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 | ||
70946 | 133675b3-383f-4207-9b6d-4e3374af5b69 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Lācīša namiņš" | 2016-03-10 | Latvia | LV | 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 | ||
70947 | e79a1ba7-c0fa-4089-9a4b-dfd4bd9f1c7d | entityStatement | 2018-12-11 | false | registeredEntity | SIA "PIN it" | 2016-03-10 | Latvia | LV | 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 | ||
70948 | d99c2ff5-a75f-4a45-9bb9-da0f445500cf | entityStatement | 2019-07-15 | false | registeredEntity | SIA Mini Mode | 2016-03-10 | Latvia | LV | 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 | ||
70949 | 85bd31a2-e9b5-4314-b49a-05031105d030 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību HCI | 2016-03-10 | Latvia | LV | 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 | ||
70950 | 3959366e-912a-4308-af68-4ecce10a3d7d | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SOFIA CONSULTING SERVICE" | 2016-03-10 | Latvia | LV | 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 | ||
70951 | 41cfd2ab-38f7-44f1-90af-cde31c910652 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "LPH" | 2016-03-10 | Latvia | LV | 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 | ||
70952 | 52541230-0d6a-48e0-9906-523ccd4bdd4f | entityStatement | 2019-07-14 | false | registeredEntity | SIA "AA Baltic Invest" | 2016-03-10 | Latvia | LV | 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 | ||
70953 | 20f39c27-0b89-4218-90ff-d5fde448c9e4 | entityStatement | 2019-03-08 | false | registeredEntity | SIA "Jupojas technika Latvija" | 2016-03-10 | Latvia | LV | 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 | ||
70954 | 3a28a1d2-aadc-4bea-be87-8e6718eb6173 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ANTARES VK" | 2016-03-10 | Latvia | LV | 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 | ||
70955 | 0159b708-0d54-4566-b9bb-1bb472373d4e | entityStatement | 2019-03-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Vecrīgas stūris" | 2016-03-10 | Latvia | LV | 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 | ||
70956 | 1af081a6-9d90-46a7-8188-f2614d9985d5 | entityStatement | 2018-06-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "T.P.C. SA" | 2016-03-10 | Latvia | LV | 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 | ||
70957 | df55f626-26c3-409d-91f0-e6e0397b69c9 | entityStatement | 2018-02-27 | false | registeredEntity | SIA "Kwakin" | 2016-03-10 | Latvia | LV | 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 | ||
70958 | 29843913-d9e2-44e2-a6c8-ec8859d4a602 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "ŽANETE DRONE" | 2016-03-10 | Latvia | LV | 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 | ||
70959 | 8ce1f401-b5e1-4aa3-9220-03db3f379c5d | entityStatement | 2018-09-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IL NESPOLO SA" | 2016-03-10 | Latvia | LV | 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 | ||
70960 | bbd5fe46-3c65-44e9-8ca9-12fdb6f84105 | entityStatement | 2018-12-14 | false | registeredEntity | "VaV" SIA | 2016-03-10 | Latvia | LV | 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 | ||
70961 | c49fb502-3eaa-4f6e-846c-3bc981d29a37 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PJ AUTO" | 2016-03-10 | Latvia | LV | 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 | ||
70962 | 371385d9-653a-4a98-89db-f2e7f6ea6e63 | entityStatement | 2019-06-04 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Riga Gaming Company" | 2016-03-10 | Latvia | LV | 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 | ||
70963 | ad3ab598-8e32-4126-afe1-2981529663cf | entityStatement | 2020-08-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "R-44" | 2016-03-10 | Latvia | LV | 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 | ||
70964 | 664f0ff7-a9e0-42d5-b40f-03f579fe8f42 | entityStatement | 2019-11-08 | false | registeredEntity | SIA SHIPLEART | 2016-03-10 | Latvia | LV | 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 | ||
70965 | 570d9ffe-852a-454d-8a4d-a911427fcfba | entityStatement | 2019-07-15 | false | registeredEntity | SIA "GSM Centrs" | 2016-03-10 | Latvia | LV | 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 | ||
70966 | 16e98a54-c54b-419d-b36a-8635868c4c5d | entityStatement | 2019-07-14 | false | registeredEntity | SIA "Fooders" | 2016-03-10 | Latvia | LV | 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 | ||
70967 | f696d5d9-37d9-465d-8f1f-ec16183264ae | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TARVENA" | 2016-03-10 | Latvia | LV | 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 | ||
70968 | f3b7e7ee-5bb2-4200-93c9-ad96509b787d | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Office R" | 2016-03-10 | Latvia | LV | 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 | ||
70969 | 8f4b7dc1-da97-4a18-8f12-48e281a2d821 | entityStatement | 2018-11-02 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Global Media" | 2016-03-10 | Latvia | LV | 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 | ||
70970 | 11b13e88-4240-4e44-87cb-774bab90e95f | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SERVICE SEA GIARDINO GIUSEPPE" | 2016-03-10 | Latvia | LV | 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 | ||
70971 | 5ee7623d-9cbb-4de7-a013-06a447b944d0 | entityStatement | 2020-01-06 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GREEN BLOC" | 2016-03-10 | Latvia | LV | 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 | ||
70972 | 3b8a300e-fdf8-48fd-a2ad-ca67ed2ac34d | entityStatement | 2018-06-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Clinica del Sorriso San Luigi SA" | 2016-03-10 | Latvia | LV | 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 | ||
70973 | c8a8ebad-23d1-48a5-8d93-ad6d9160b49b | entityStatement | 2020-08-11 | false | registeredEntity | SIA Terratu investments | 2016-03-10 | Latvia | LV | 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 | ||
70974 | 2306e48b-fd70-438c-adce-95f4d3a810b2 | entityStatement | 2019-07-14 | false | registeredEntity | SIA "AK Catering" | 2016-03-10 | Latvia | LV | 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 | ||
70975 | d548eedb-bb0b-46ec-9ce3-20970f7cbbee | entityStatement | 2019-07-14 | false | registeredEntity | SIA "VRM-16" | 2016-03-10 | Latvia | LV | 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 | ||
70976 | f4421e54-ddf8-495e-9488-062ee3c1a396 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tested Solutions" | 2016-03-10 | Latvia | LV | 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 | ||
70977 | 1551e1ca-3797-4930-85c9-dbd251ca494e | entityStatement | 2019-01-03 | false | registeredEntity | SIA "SERVOG" | 2016-03-10 | Latvia | LV | 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 | ||
70978 | 71b2e71c-acbb-4e4c-a107-cf93b90673d0 | entityStatement | false | registeredEntity | AS "Skulte LNG Terminal" | 2016-03-10 | Latvia | LV | 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 | |||
70979 | 6b3decff-596d-4508-b6ef-25229e93c443 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ZOOM OFF" | 2016-03-10 | Latvia | LV | 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 | ||
70980 | f8347dea-1bfd-46b2-baf7-21b4f2c0a6f1 | entityStatement | 2018-02-27 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MV8" | 2016-03-10 | Latvia | LV | 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 | ||
70981 | 7d996f04-822b-44dc-ade0-c801aae314de | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AKO Dominium" | 2016-03-10 | Latvia | LV | 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 | ||
70982 | 02947b4a-bdae-421d-80f5-aefcdac56004 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Restour" | 2016-03-10 | Latvia | LV | 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 | ||
70983 | 392c71a5-1883-42b5-946c-2f58cffe3075 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Acountess" | 2016-03-10 | Latvia | LV | 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 | ||
96624 | 888bac17-2c71-4f50-aea1-dd08f5bf5848 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Latgales Gaļsaimnieks" | 2016-03-10 | Latvia | LV | 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
CREATE TABLE [entity_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [entitytype] TEXT , [name] TEXT , [foundingdate] TEXT , [incorporatedinjurisdiction_name] TEXT , [incorporatedinjurisdiction_code] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [source_type] TEXT , [unspecifiedentitydetails_reason] TEXT , [unspecifiedentitydetails_description] TEXT , PRIMARY KEY ([_link]) );