entity_statement
23 rows where foundingdate = "2014-12-16" and "statementdate" is on date 2019-07-15
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101558 | 85e6f11d-3249-4921-ab86-e2337ef71d8a | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "CLEVUS" | 2014-12-16 | 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 | ||
| 63820 | 946097f8-b478-4cf1-865d-6f8b6f7fa78f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "POLYFAB GRUPA" | 2014-12-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 | ||
| 63823 | 65a0bd2f-b948-4852-802c-9a00fada56a9 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Earth House" | 2014-12-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 | ||
| 63824 | f969a84b-6ea9-4be8-be6c-ea292f735abc | entityStatement | 2019-07-15 | false | registeredEntity | SIA "E-Brain" | 2014-12-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 | ||
| 63831 | b209b8c3-8bb8-4506-a446-833f21d936f5 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Finansists un Co" | 2014-12-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 | ||
| 63833 | a3261460-94ce-4e5a-a15d-d7bf73b096f2 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Poledan" | 2014-12-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 | ||
| 63834 | 9df6cd38-19ea-412b-8205-efa4e231bcd3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AME Trophy" | 2014-12-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 | ||
| 63835 | 856d5cde-6523-4ff3-b356-9cefe8fb3af7 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "KARI serviss" | 2014-12-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 | ||
| 63836 | 7361b079-3607-4aa3-aca3-30894c93fde0 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RMSK" | 2014-12-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 | ||
| 63837 | f03dcff5-a37e-4f56-853f-fe8aa6aa714e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Escape room Export" | 2014-12-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 | ||
| 63838 | e732f106-5a1f-4c67-932b-5c7dd8862d6f | entityStatement | 2019-07-15 | false | registeredEntity | AETERNO SIA | 2014-12-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 | ||
| 63839 | a51d1d9e-7fba-4fa5-9218-f40e5f7fab53 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Celosia" | 2014-12-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 | ||
| 63840 | e020deb7-f08e-42d9-9914-51ff0927eeaa | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ALVENAS" | 2014-12-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 | ||
| 63841 | 97092c59-719c-4bc6-901e-1ba30d7f5b3f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KEEP CALM" | 2014-12-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 | ||
| 63842 | 314ce39e-9370-4a94-b29c-9fe3be464288 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "GV DIAMONDS" | 2014-12-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 | ||
| 63843 | 3c300ee2-88c4-4d25-9207-ffafafd09880 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Led Way" | 2014-12-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 | ||
| 63844 | e1ff465a-9120-489d-99b7-a84b43fba1a3 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Locītavu ķirurģija" | 2014-12-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 | ||
| 63847 | cca27614-b27d-4924-83af-fed3534c7c4e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "TECHNICUS" | 2014-12-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 | ||
| 63849 | c532c0f5-d388-438a-891d-e15f57d8374d | entityStatement | 2019-07-15 | false | registeredEntity | SIA "CEF Recruitment & Consulting" | 2014-12-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 | ||
| 63850 | e7fe48d1-e2fb-463d-8cd8-12beabbaa660 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "NiceGNT" | 2014-12-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 | ||
| 63851 | 4f9e030a-c47b-45f2-97b1-e7cfedde3dfc | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Masaurum" | 2014-12-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 | ||
| 63852 | 3abdb328-8bf6-4955-8f7c-4fadabb5600a | entityStatement | 2019-07-15 | false | registeredEntity | SIA "UKTR" | 2014-12-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 | ||
| 96350 | 0293c797-1edf-49c7-9d61-2e8e7d3a1cf5 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "LIGHT SOLUTIONS" | 2014-12-16 | 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]) );