entity_statement

32 rows where incorporatedinjurisdiction_code = "LV" and "statementdate" is on date 2020-03-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
101640 48fd6c8d-6a16-41bb-bf20-bb65e7f65638 entityStatement 2020-03-17 false registeredEntity SIA "Edrair" 2015-04-01 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    
107939 dc20cb24-1b3f-49ad-8c8a-af7e0320c926 entityStatement 2020-03-17 false registeredEntity "IA-LABA" SIA 1994-09-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    
109955 ff3d9033-97b8-4fc6-8b4d-fc079fe51160 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "JK NOMA" 2011-12-12 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    
120165 d3f61d9d-a573-4639-b3f5-0013df97e836 entityStatement 2020-03-17 true registeredEntity SIA "RSLT"   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    
120166 a8575115-6ea9-4d0e-bc14-470030f30f1b entityStatement 2020-03-17 true registeredEntity SIA "K20"   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    
21215 3857112e-c476-4673-93ee-6aba84b12ec6 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "MD Birojs" 2006-08-11 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    
25767 eb055ea9-a9ac-4765-8900-092a710199cd entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "AGroup" 2008-01-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    
26496 9ae913ff-b1c2-435a-8f8c-d9721250d50a entityStatement 2020-03-17 false registeredEntity "OZOLA TRASE" 2000-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    
34453 3feaf309-da72-4783-b702-1df3d9cae06c entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "REGUM NORD" 2009-04-15 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    
35475 0756e5e3-bc64-4a71-ba72-fbd1a707e2bd entityStatement 2020-03-17 false registeredEntity Akciju sabiedrība "SAKRET HOLDINGS" 2009-09-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    
35970 501f18c1-7d0b-40f3-b33d-3dafce953b48 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Yurinat Baltic" 2009-12-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    
38587 ffe213ec-d66d-46af-a430-8a758ce5171e entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "SZ Birojs" 2010-10-01 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    
41024 fd546b20-ba57-4c7b-bc6d-98929bd7cb62 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "A & G Radošā Apvienība" 2011-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    
48480 7de3c4ef-67e2-421f-8ced-a8cc9332e6c9 entityStatement 2020-03-17 false registeredEntity SIA Topogrāfi.lv 2012-05-18 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    
51440 1cb71f14-f7db-4561-88d1-4aa181588a55 entityStatement 2020-03-17 false registeredEntity SIA "A2O" 2012-11-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    
51625 36823fb1-2263-4a9b-bf07-3eebb56f9b32 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Latdare" 2012-12-06 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    
55811 0d3bf2b7-9a9e-4785-b25d-9d723615b9f1 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "AT konsultācijas" 2013-08-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    
5612 79f5ba9f-b78a-440e-9b6b-c602aa21f36f entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "DINO & CO" 1994-08-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    
62318 9f8fea26-81ce-49d2-9e0a-485c398a60c4 entityStatement 2020-03-17 false registeredEntity SIA "Geoline" 2014-09-17 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    
66266 c9faf648-bede-4340-b6aa-64f6691d9abe entityStatement 2020-03-17 false registeredEntity Akciju sabiedrība "Brazen Investments" 2015-05-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    
69228 0702d24b-8141-4570-a6d2-cbe927adbc14 entityStatement 2020-03-17 false registeredEntity SIA Smart energy solutions 2015-11-23 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    
7077 c5d778e8-d195-4bdd-b60e-54d01498e847 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "KRISTĪNE 1" 1996-08-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    
7538 5726ca79-044c-4402-bd9e-f19fd0737d07 entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic Prof Group" 1997-03-06 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    
75932 04ab1e82-f135-4b20-85f5-18221424eef2 entityStatement 2020-03-17 false registeredEntity SIA Valiatrade 2017-02-14 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    
78386 5b9ad727-9d7d-410e-b93c-452a1dfc0ff2 entityStatement 2020-03-17 false registeredEntity SIA A.I. International 2017-07-31 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    
81636 a4ec474a-1163-45f8-861c-1ecbfe04d8b9 entityStatement 2020-03-17 false registeredEntity SIA "TIMBALTIC" 2018-02-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    
83049 c8d88385-5090-4aaa-902d-94a97607b7bc entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "HOTEL COM" 2018-05-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    
83642 13cdd1a3-4c17-42bc-8099-76ba6588bde6 entityStatement 2020-03-17 false registeredEntity SIA RIALIS 2018-06-19 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    
86275 a01c75d1-3ffb-4cc8-a1ca-3d6f00699f74 entityStatement 2020-03-17 false registeredEntity SIA KP INNOVATOR 2018-11-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    
87069 95ffeb5a-c481-4257-9c8b-a57bcc6fc241 entityStatement 2020-03-17 false registeredEntity SIA Deus Ex Machina Resulting 2019-01-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    
87748 809fd95d-9b1e-4ae1-9317-249ccbd581a9 entityStatement 2020-03-17 false registeredEntity SIA "Mayrono Entertainment" 2019-03-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    
9592 69629224-dda1-44c5-a0cb-249dc840e5fd entityStatement 2020-03-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "AV LATS" 1999-04-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    

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