entity_statement

42 rows where foundingdate = "2014-12-16"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, foundingdate (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
101556 1828451e-8479-4b78-a6ff-0898fd03c8d6 entityStatement 2019-04-17 false registeredEntity SIA "MP WOOD COMPANY" 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    
101557 bf151daa-d2ac-4104-9674-ad26b0a808c5 entityStatement 2019-02-05 false registeredEntity SIA "Afabs" 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    
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    
110899 e28490ce-ad25-4580-9ad0-5065919dbbd3 entityStatement 2019-07-16 false registeredEntity SIA "Rich Media" 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    
27817 be006d4e-35ad-4e11-9aa6-bc3d21f6d409 entityStatement 2020-03-25 false registeredEntity "Uzņēmēju asociācija WISE-Baltija" 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    
63818 01b6fde7-ca82-4785-82cb-40bcb314da23 entityStatement 2019-07-14 false registeredEntity SIA "WLAY COMPANY" 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    
63819 cf819c88-2866-4827-82fe-cd8ea689c55a entityStatement 2019-03-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "CULTE BIZARRE" 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    
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    
63821 7ef4785d-de82-4a76-8c74-1847e779ad8e entityStatement 2019-07-14 false registeredEntity "ABM Investment" 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    
63822 dc778018-20d1-4e08-bfae-ceefdd8dba0a entityStatement 2020-11-19 false registeredEntity SIA "VIKORA 8" 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    
63825 f9d5dae0-46b2-4cfd-86b7-b037074bc2c4 entityStatement 2020-02-25 false registeredEntity SIA "Your Solution" 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    
63826 62a2fd49-7d78-4c8d-bffe-9e44179789c8 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "BAGE" 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    
63827 dc5b19e9-7730-49a6-b3ba-71d3baf50d61 entityStatement 2020-09-25 false registeredEntity SIA "AGLM PERSONAL" 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    
63828 7340a7d7-e908-4d32-a8bb-0a1609a86262 entityStatement 2018-02-05 false registeredEntity SIA "GOLD PICTURES" 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    
63829 356d8020-506e-45cf-98ca-a4f06381d468 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "TS Plus" 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    
63830 541ce6c8-7609-4019-9410-cbad48fecc8d entityStatement 2019-06-27 false registeredEntity SIA "Finnera Capital" 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    
63832 3a3ee258-bb00-4940-ac71-2f6b57ebb064 entityStatement 2020-01-28 false registeredEntity SIA "MN Invest" 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    
63845 d8828eb9-5000-46cc-93eb-970e39d3d2bd entityStatement 2019-07-14 false registeredEntity SIA SG Investments 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    
63846 79b0ac22-a7c3-40c5-b5ca-b254d4c9c97b entityStatement 2019-07-14 false registeredEntity SIA "BrandBox Vision" 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    
63848 f18e7979-fe03-4b64-bf4e-1337bc34cc9a entityStatement 2019-04-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "DIGI MEDIA" 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    
63853 593d2150-118a-4948-be04-262314f3dfb0 entityStatement 2019-07-14 false registeredEntity SIA "Arktika 24" 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

CSV options: 

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]) 
);