entity_statement

35 rows where foundingdate = "2013-09-26" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), foundingdate (date), 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
101271 06f6ea3d-b64b-46bb-aec6-88d62eaea6d9 entityStatement 2019-07-15 false registeredEntity SIA "S.A.E.S." 2013-09-26 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    
105458 73a18a06-0aad-4f13-90d7-0c0436cd0ec2 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "BĒRZA ČIEKURS" 2013-09-26 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    
110514 39265139-9628-4807-8883-5acefe83880d entityStatement 2019-07-16 false registeredEntity SIA "Jumpravas koks" 2013-09-26 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    
110515 b243885d-0a24-4494-896e-594a006f2960 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rento LB" 2013-09-26 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    
56462 3e36aeb3-bc61-4ebc-a949-02a78384f484 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ciparu mākonis" 2013-09-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    
56463 e7567498-2723-400e-985c-fb5783f62155 entityStatement 2019-01-17 false registeredEntity Sabiedrība ar ierobežotu atbildību "Delicato" 2013-09-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    
56464 428de946-e995-4f67-8046-affa664bb849 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Business balancer" 2013-09-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    
56465 1d085af9-846b-40ff-9e5e-042fe3d6e9fb entityStatement 2018-05-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "A-Logistic" 2013-09-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    
56466 92ef6c50-0f0f-48d2-93bc-093a17b898fb entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Jusmarg" 2013-09-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    
56467 86327676-4018-4fbd-bdcb-797cf5b6fafe entityStatement 2019-07-15 false registeredEntity SIA "VINTAGE V" 2013-09-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    
56468 e8c8e041-e4e4-4eae-ba56-7197504ce143 entityStatement 2019-10-21 false registeredEntity SIA "CARMAX" 2013-09-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    
56469 8e518ec2-c6ae-4b98-89e7-fcd47702f364 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "NEMIZ-Initiative" 2013-09-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    
56470 62e678ce-f88a-43f2-a895-ec620262bb9c entityStatement 2017-12-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "Del Dorido" 2013-09-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    
56471 e688d595-6960-4d03-8923-52b9fa61cb80 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Vostok Forwarding & Logistics" 2013-09-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    
56472 2cdd4ec3-27ed-4583-9afe-3b777a5a77ce entityStatement 2020-12-30 false registeredEntity SIA "NIOLO" 2013-09-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    
56473 9e9e1cf5-5292-4b46-96f0-0c7f0753f4a0 entityStatement 2020-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "CIKLOMENA" 2013-09-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    
56474 226f54a6-332e-4aaf-9918-cee605b42659 entityStatement 2019-07-15 false registeredEntity KD SIA 2013-09-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    
56475 8d9fbb20-5bd0-4cd2-aae1-512a130e0b78 entityStatement 2018-03-02 false registeredEntity SIA "Konkas" 2013-09-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    
56476 99117706-8a85-4cab-80b8-238038cb048b entityStatement 2020-03-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "SKY Investment Holding" 2013-09-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    
56477 2b8a2a4a-3e8b-452a-a63e-1e1f751c5a8b entityStatement 2019-07-15 false registeredEntity SIA "Durov Global Group" 2013-09-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    
56478 e737c3ee-542e-4dc5-97ea-79b39d80248b entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "MNEVIS" 2013-09-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    
56479 ea7f5179-8d74-48c2-a274-f7712ec0997e entityStatement 2018-02-15 false registeredEntity SIA "TUDARE" 2013-09-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    
56480 aae14703-c002-4061-aee4-cf9e9de96534 entityStatement 2020-08-18 false registeredEntity SIA "AG Buss" 2013-09-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    
56481 cdef16eb-f88c-4d91-8a1a-ad37bc0be196 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "GLOBAL AMBER" 2013-09-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    
56482 186bf90f-d22c-4a22-bcac-be0bd5a362de entityStatement 2019-07-15 false registeredEntity SIA "AS1 studija" 2013-09-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    
56483 8eb3a389-d474-40c4-b07d-aed19e74ef15 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "RUSS-EL" 2013-09-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    
56484 23ae0956-25c6-403c-9db6-18f1d43d3f81 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "RADONTA" 2013-09-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    
56485 8d60ed0e-6a3c-4881-83d2-7fa388d55f77 entityStatement 2020-08-27 false registeredEntity SIA "YAGO" 2013-09-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    
56486 5a20102f-caf7-412d-9792-64331a6d6be6 entityStatement 2018-03-08 false registeredEntity Sabiedrība ar ierobežotu atbildību "Buļļu inženiertīkli" 2013-09-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    
56487 c3054d86-43ac-4011-b321-e38422588b82 entityStatement 2018-05-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Erabika GD" 2013-09-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    
56488 ccb207e8-b566-4a29-8d25-02742e70ff28 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "DOP Birojs" 2013-09-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    
56489 56a81119-a569-4a02-91f1-1038aabfb523 entityStatement 2019-07-15 false registeredEntity SIA "LTF 1" 2013-09-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    
56490 bdf8c823-3254-43bc-b01c-de483cae53c0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MVP PROF" 2013-09-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    
56491 bcc3ae2c-b5ca-4bd6-97bb-a5e069ab3451 entityStatement 2019-03-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "FINGLOBAL" 2013-09-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    
91470 ec918cc9-c995-4e21-899f-dde1cfd6d705 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "OsisR" 2013-09-26 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]) 
);