entity_statement

42 rows where "statementdate" is on date 2020-09-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: iscomponent, incorporatedinjurisdiction_name, incorporatedinjurisdiction_code, publicationdetails_publicationdate, statementdate (date), 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
102426 79b66cba-237b-459e-99e5-c88966bac504 entityStatement 2020-09-17 false registeredEntity SIA "VG Nams" 2018-04-11 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    
102602 2c0125dc-c90d-44f0-84a9-2b17f0919f1d entityStatement 2020-09-17 false registeredEntity SIA "TZ CLEAN" 2018-11-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    
105893 88dc9b28-213d-44b0-bec9-24c2f8b9b9a3 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "TIMOBŪVE" 2017-01-05 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    
109436 21be1be7-e096-487d-b978-6b56546fc388 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "unolex" 2009-12-23 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    
110427 723b31b9-37dd-41f9-9f01-df2e9ac20e9b entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mindset" 2013-06-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    
111329 97bd0daf-a116-452c-b830-00be6e94c090 entityStatement 2020-09-17 false registeredEntity SIA "Cattus" 2016-03-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    
112040 56d53332-2b9f-48cb-b13a-90ce41e043b6 entityStatement 2020-09-17 false registeredEntity SIA "GB8" 2018-07-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    
112054 cb200d76-67cb-4787-8635-cc49b6447ec3 entityStatement 2020-09-17 false registeredEntity SIA PA MEŽU 2018-07-18 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    
118560 5cdb597a-1139-413d-9df9-ba2056225dc8 entityStatement 2020-09-17 true registeredEntity Aquatech B.V.   Netherlands NL 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    
118561 19e9c86d-0a00-406c-b2c0-336d178dc40e entityStatement 2020-09-17 true registeredEntity Urban Renewal SIA   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    
13280 328b79f4-e741-42a4-a20b-9c32b7c9a318 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIJAS TEHNIKA UN VIDE" 2002-06-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    
15462 fdd18633-261e-4fdb-b1fd-183f9f92a7a7 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "LOTMARKA" 2004-02-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    
16995 6be81373-1afb-4de2-a7e4-1c5d5d9d233d entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "SEALTH UNLIMITED" 2004-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    
17215 722eb681-9e51-42ef-8731-69654f3511c8 entityStatement 2020-09-17 false registeredEntity SIA "CREATIVE MEDIA BALTIC" 2004-12-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    
21877 d0f8a4f4-aab1-4bfa-8293-2631966fb9a8 entityStatement 2020-09-17 false registeredEntity SIA "TIZ Holding" 2006-10-27 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    
27154 23f735b5-0a4b-4a53-8732-78e698f95c6e entityStatement 2020-09-17 false registeredEntity "Futbola klubs "Veina"" 2009-11-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    
28814 817bdc2b-22c3-429f-8c9b-af1e2452c454 entityStatement 2020-09-17 false registeredEntity "Aslbek Mussin garīgā mantojuma fonds" 2018-08-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    
28917 61a98440-8d5c-499d-8eaa-5dd2b47fa534 entityStatement 2020-09-17 false registeredEntity "Jelgavnieku veselības veicināšanas fonds" 2018-09-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    
29042 c65d13c2-358a-421b-a667-ed157d7a5c06 entityStatement 2020-09-17 false registeredEntity "Peldēšanas Sporta atbalsta fonds" 2018-11-02 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    
29175 6d2df355-cc4e-48f6-ad23-9756b79ae437 entityStatement 2020-09-17 false registeredEntity "Pedvāles mākslas parka fonds" 2018-12-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    
34239 15a97af0-cbf3-46f5-94c2-bd8018d5f221 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "HOT DOG" 2009-03-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    
34830 8fcd0ecd-50c7-42dd-9322-577dfba51da4 entityStatement 2020-09-17 false registeredEntity SIA "DAEG" 2009-06-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    
36160 59cf38a3-041b-43ec-8deb-ea98f9e69718 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Bistroff" 2010-01-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    
44503 5338fe73-371e-4926-8cc0-f86189913106 entityStatement 2020-09-17 false registeredEntity SIA "SV Variant" 2011-09-13 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    
49329 16b9c79b-d6d0-4525-a5ac-4a7fac914715 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "LIMED Serviss" 2012-07-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    
50568 3491f3ae-3e28-4cff-8d98-82d342ac9c74 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "BP būvniecība" 2012-09-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    
50808 959bebd6-82ca-4f9e-9198-63cf4494d075 entityStatement 2020-09-17 false registeredEntity SIA "Diasteel" 2012-10-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    
52295 3f7db419-78af-4cf1-b405-c9402add1742 entityStatement 2020-09-17 false registeredEntity SIA "Rūpniecības 11" 2013-01-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    
53485 59d5515d-4d93-4312-a75d-1bd7437d1456 entityStatement 2020-09-17 false registeredEntity SABIEDRĪBA AR IEROBEŽOTU ATBILDĪBU "RAUDAS ĪPAŠUMI" 2013-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    
56085 7f331be1-6943-4e68-9ef1-14cbd3510bce entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Leadership management centre" 2013-09-02 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    
58478 2d6fd23b-917f-49ef-b95b-0b70493211a7 entityStatement 2020-09-17 false registeredEntity SIA "Chapman 114" 2014-02-04 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    
6118 384c9b1b-0f84-473e-b82d-31f7e028429d entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību firma "BALTIJAS KRAVAS TRANSPORTS" 1995-03-27 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    
64374 7d785ea6-45ed-4df1-8dfa-94aef4e587f8 entityStatement 2020-09-17 false registeredEntity SIA LEKOR AM 2015-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    
70396 03c65cdb-b955-437e-aaa5-e21866772f05 entityStatement 2020-09-17 false registeredEntity IT2 SIA 2016-02-04 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    
7207 03e5da11-7c22-4fad-8a5e-4623f97904b5 entityStatement 2020-09-17 false registeredEntity SIA Propio 1996-10-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    
73483 0b59c09b-c71d-4e3f-9a9c-fc61f5375093 entityStatement 2020-09-17 false registeredEntity SIA "DSR 19" 2016-08-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    
77420 2bf04e0e-d6a0-4f0c-b627-540c8e05c154 entityStatement 2020-09-17 false registeredEntity SIA "Junior Bulk Shipping" 2017-05-23 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    
81983 c2d101dc-f187-4620-8943-4cfe0765eb50 entityStatement 2020-09-17 false registeredEntity SIA "Autoluck" 2018-03-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    
82724 fd2e0cbf-cdab-4677-b3b9-33b64b2e30e8 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Intelligent Export 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    
83446 a7079f2f-5e3d-4b1a-8897-b9d3420f7738 entityStatement 2020-09-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "VITALY BEACH" 2018-06-07 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    
83935 524ff740-5c28-4a23-a295-3f9d86eeb102 entityStatement 2020-09-17 false registeredEntity SIA "EKRA Group" 2018-07-11 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    
94621 b5a7fae3-04b8-478a-870f-a70e7f938991 entityStatement 2020-09-17 false registeredEntity SIA "Muflonu dārzs AUĻI" 2004-11-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    

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