entity_statement
52 rows where iscomponent = "false" and "statementdate" is on date 2018-04-24
This data as json, CSV (advanced)
Suggested facets: publicationdetails_publicationdate, statementdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106133 | b723a048-f123-416c-8f2c-1aef6b35129e | entityStatement | 2018-04-24 | false | registeredEntity | SIA Abra M | 2018-04-24 | 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 | ||
| 111959 | 809bbb72-344a-44b7-9d48-82be41c3e233 | entityStatement | 2018-04-24 | false | registeredEntity | SIA EK Tech | 2018-04-24 | 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 | ||
| 111960 | 0c3dcc2a-2338-43ef-81d8-d6fdbde67707 | entityStatement | 2018-04-24 | false | registeredEntity | SIA STELLA5 & LTD | 2018-04-24 | 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 | ||
| 11671 | edbb4f98-7921-4552-b92f-690f2c6c93c7 | entityStatement | 2018-04-24 | false | registeredEntity | Dzīvokļu īpašnieku kooperatīvā sabiedrība "BIĶERNIEKU 93" | 2001-02-05 | 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 | ||
| 13864 | cb6b13fd-f4d4-4188-91bd-b665f0cb5d7b | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IT MAKSIMUSS" | 2002-12-05 | 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 | ||
| 17781 | 90d88959-5088-46ea-a1ab-4f346f1fe29e | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTA TREND" | 2005-04-07 | 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 | ||
| 18908 | 39950609-cd49-43ce-967f-326476c73f6c | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KRONOSPAN Riga" | 2005-10-12 | 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 | ||
| 20010 | d51ebc89-7ed8-4abe-9b32-6d4bab443991 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Panbaltica Latvija" | 2006-03-14 | 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 | ||
| 22639 | 8201a9c9-b95e-4e8d-ad90-f11cdeb47948 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "R.KOMPĀNIJA" | 2007-01-26 | 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 | ||
| 25901 | a2de4a23-edab-462d-b0bd-1ff468fd7e05 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Inženierkomunikācijas" | 2008-02-07 | 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 | ||
| 28548 | e67d7ddd-f10b-429d-af0f-d91e144f2941 | entityStatement | 2018-04-24 | false | registeredEntity | SASKARSMES GARŠA | 2018-04-24 | 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 | ||
| 28550 | a8c32d53-0fb9-4d72-8a95-2de38e8671b7 | entityStatement | 2018-04-24 | false | registeredEntity | "Tūrists Savā Pilsētā" | 2018-04-24 | 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 | ||
| 28551 | ad6b5c08-da33-4d18-829b-e726edd48921 | entityStatement | 2018-04-24 | false | registeredEntity | Arts and Crafts Latvia | 2018-04-24 | 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 | ||
| 31458 | 45d6684d-b78c-4b47-8ab2-584925771688 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LASI" | 1993-07-28 | 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 | ||
| 33181 | bd53d6ff-2a25-4668-9f2a-8f34fbedc5ea | entityStatement | 2018-04-24 | false | registeredEntity | SIA "Tavs Pārvaldnieks" | 2008-09-08 | 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 | ||
| 35288 | aa609978-9332-4697-8265-a1121a4af417 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SV UNION" | 2009-08-31 | 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 | ||
| 41811 | 63e032c2-ad58-49a9-8c18-34e9dd9e362b | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ankila" | 2011-03-25 | 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 | ||
| 43080 | 91e5f76b-6612-4866-824f-76338cd5b0ab | entityStatement | 2018-04-24 | false | registeredEntity | SIA "VKA Systems" | 2011-06-08 | 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 | ||
| 43668 | 5ce508ea-38bd-4e72-aea5-c41b9912e435 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "MOPS" | 2011-07-21 | 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 | ||
| 45692 | c3d311c8-d7c6-41b6-a628-63eee470e6e0 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RemKo" | 2011-11-28 | 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 | ||
| 45813 | 7a19a13f-fd6e-4947-ab5e-2649e511d96b | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "JUVEKO GROUP" | 2011-12-05 | 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 | ||
| 4672 | fd938f02-aa9a-44ce-aeb2-a9cfcaf88b9c | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GEVUS" | 1993-02-16 | 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 | ||
| 54646 | 742e9d44-639e-48d3-bc0b-77f79ca0c23c | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ANTHRACITE" | 2013-05-30 | 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 | ||
| 55479 | 5fc28ddc-7266-41b2-985c-23220deb49a7 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sprintfilter Latvia" | 2013-07-25 | 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 | ||
| 55950 | 99c9c689-c6ef-4c6a-b104-8a373530e20d | entityStatement | 2018-04-24 | false | registeredEntity | KZ konsultācijas SIA | 2013-08-26 | 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 | ||
| 58436 | 4e1750b9-01b4-40d2-bf3d-657ed0bb3b45 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "KPBS" | 2014-01-31 | 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 | ||
| 59619 | 7aaca800-49d7-4fa7-ab27-f1d0a35825b9 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Horeca EMSI Group" | 2014-04-09 | 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 | ||
| 60471 | ef91162a-c0ac-4ac8-92c6-0deeb7ddfb35 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ASIRIUS" | 2014-05-29 | 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 | ||
| 65488 | 1aa3d9f3-b419-45ba-8b70-8fc42cc9a3a1 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "COUNTRY HELI" | 2015-03-26 | 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 | ||
| 71240 | f4fe4e15-9d51-4d5f-b472-a3b62557684e | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WIMS" | 2016-03-30 | 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 | ||
| 76560 | 645d3ed9-603e-4726-953f-b1c9cb7f76df | entityStatement | 2018-04-24 | false | registeredEntity | SIA "SDL" | 2017-03-28 | 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 | ||
| 7742 | e6964acc-a719-4dfb-b88b-ef68653144de | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LAUKSAIMNIECĪBAS UZŅĒMUMS STRIKI" | 1997-05-22 | 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 | ||
| 80621 | 058bdbca-a08f-43b3-933d-00a14d2ad655 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "ISL Transports" | 2017-12-21 | 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 | ||
| 82721 | c0cb1474-37d6-4e41-9267-82f81f1cf5e7 | entityStatement | 2018-04-24 | false | registeredEntity | SIA Ink&Press | 2018-04-24 | 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 | ||
| 82723 | fecf13b2-3e1e-4701-a2ea-12db7b499c0c | entityStatement | 2018-04-24 | false | registeredEntity | SIA "XM5" | 2018-04-24 | 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 | ||
| 82725 | 8f6a832f-d001-411b-8cdd-440facb9f98a | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Tidass" | 2018-04-24 | 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 | ||
| 82726 | 957b3a0a-85d0-4a0a-b88d-07d886026190 | entityStatement | 2018-04-24 | false | registeredEntity | SIA 8.brīnums | 2018-04-24 | 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 | ||
| 82727 | cfdc4a93-03ab-43e9-8597-4092d0b62718 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Smilšu animācijas teātris" | 2018-04-24 | 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 | ||
| 82728 | ce92c5af-c314-48de-98c8-cf94e8fe2c59 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Finatem" | 2018-04-24 | 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 | ||
| 82729 | 68c7fa5c-0383-4bb4-8cb2-0122390a0b41 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AVT Furniture" | 2018-04-24 | 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 | ||
| 82731 | 5e22de8d-434c-44ac-80ad-62959f2abd8d | entityStatement | 2018-04-24 | false | registeredEntity | Modulekspert SIA | 2018-04-24 | 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 | ||
| 82732 | 9ff588bb-182e-4faa-a0bd-63fc46d6858a | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WTM Solutions" | 2018-04-24 | 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 | ||
| 82733 | ab4cfe6b-6645-44fa-902e-3d0d5f369d09 | entityStatement | 2018-04-24 | false | registeredEntity | Nenista, SIA | 2018-04-24 | 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 | ||
| 82734 | 8da77ed7-8284-4b03-80a4-ceb3b6cdba26 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "CMB Housing Solutions" | 2018-04-24 | 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 | ||
| 92457 | 114ad68f-46e0-4b11-af5b-9a95dae5d5c1 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AC Pērles" | 2018-04-24 | 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 | ||
| 96402 | fdfd8bca-6ae0-4e9c-83fa-4e8d41b31932 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "MD Group" | 2015-03-02 | 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 | ||
| 96937 | e3e4d29a-5eec-4dfd-a4f3-09f3fe26bedc | entityStatement | 2018-04-24 | false | registeredEntity | SIA "V.I.P.buss" | 2017-08-08 | 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 | ||
| 97130 | febfe0ed-88bb-4aac-97e6-d26dfce87da0 | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību SAPSAN | 2018-04-24 | 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 | ||
| 97132 | ffdf36a1-c917-4e3b-b83b-a3dea9d082aa | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Aberto" | 2018-04-24 | 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 | ||
| 97133 | 1d603f82-6b6c-49bc-9abe-b1abac18b7dc | entityStatement | 2018-04-24 | false | registeredEntity | SIA "QUANTUM CONSTRUCTION" | 2018-04-24 | 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 | ||
| 97134 | e635588d-b2c7-4364-95c3-dd7f475e5eeb | entityStatement | 2018-04-24 | false | registeredEntity | SIA "ADLER" | 2018-04-24 | 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 | ||
| 99640 | 10a9dc0f-5f6a-4cee-8d79-492eba969c36 | entityStatement | 2018-04-24 | false | registeredEntity | SIA "Vēju paradīze" | 2002-04-09 | 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]) );