entity_statement

37 rows where iscomponent = "false" and "statementdate" is on date 2019-06-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publicationdetails_publicationdate

_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
108187 dc6c7e6d-cb86-4c40-b26d-653f1e606d03 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "IVETA" 1992-06-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    
109800 5472d8ff-b4b8-4df3-880a-4f955d43e79d entityStatement 2019-06-18 false registeredEntity SIA "Augusta dārzeņi" 2011-06-15 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    
110439 eb8f75cc-ff43-4b16-baea-2d7aecefa674 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "EXTERNA" 2013-06-27 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    
113730 70acb7a3-3d93-4456-9f7a-4b4f0a112aad entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "JAUNMĀRAS" 1999-10-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    
13528 ef30b273-05d8-4c0a-afdd-e829437fdf73 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "CARLLS" 2002-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    
17416 3e06cd47-fd24-46f9-8dd7-e31112456cf3 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALDERMANIS" 2005-01-31 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    
18654 e6dea4bc-47bc-4af1-a565-b10e4b666ea8 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "MG Baltic" 2005-09-05 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    
19678 3a360ebb-a3a1-4a47-a876-eaed527f941a entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Kraftpapīrs" 2006-01-31 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    
21525 4d01052c-8966-43b9-b568-67fb7771bd3c entityStatement 2019-06-18 false registeredEntity SIA "GLD Company" 2006-09-19 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    
22618 92d6f66e-0a77-4902-ae9b-6ffbd6cf35cc entityStatement 2019-06-18 false registeredEntity SIA "SAVA AUTO" 2007-01-25 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    
25391 415b71b7-7578-4f18-8182-20ed39a004e3 entityStatement 2019-06-18 false registeredEntity SIA "MSD AUTO" 2007-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    
27232 a563226e-f1c8-4f59-a8a8-4e7c5b31887a entityStatement 2019-06-18 false registeredEntity "Teiču dabas fonds" 2010-05-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    
33910 2f476762-a4cb-4e8a-b4ca-2b8ee1219300 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Optical Service Group" 2009-01-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    
38671 4a5d13fa-a629-4406-a5f5-fb323e435cc2 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "SKAMOL" 2010-10-07 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    
40056 bf362b15-638b-429c-be81-de0c72618a02 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "AUSTRUMU TRADE" 2010-12-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    
40625 821dde5a-f81d-43fa-9f34-dfab7da86a95 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "CENTRS A" 2011-01-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    
43541 b5d2985b-8e98-4f2c-93b0-de908bde586b entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "DZINTARU 36" 2011-07-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    
44962 45a1d9dc-ed0d-4ee8-bb79-0f73caf60b31 entityStatement 2019-06-18 false registeredEntity SIA MAL TRANS 2011-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    
47827 fb9afec8-0e41-40cd-8f0b-0f49aeec9835 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Strauby" 2012-04-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    
52024 3548275d-8cc3-46e1-acde-88775f18398a entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cube 8" 2013-01-08 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    
5490 b4741f39-11e3-41b7-88c1-ab4751386919 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "LETORS" 1994-05-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    
57749 0428ca36-ef95-4b1a-955b-fcd5ccecf339 entityStatement 2019-06-18 false registeredEntity SIA "Ladamore" 2013-12-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    
58864 26641792-1d69-46f9-b652-df9d29a719a7 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "BBK VELO" 2014-02-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    
65090 1db15fc8-93a9-4b3a-998f-68103d76ecb8 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "LV CARGO" 2015-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    
70568 960b71f6-90fa-4be1-8e44-32704604b373 entityStatement 2019-06-18 false registeredEntity SIA "POLARIS TLC" 2016-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    
70800 3f6c53fd-6c15-4338-86d9-d31635f41822 entityStatement 2019-06-18 false registeredEntity SIA "CORVUS CONSULTING" 2016-03-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    
73087 17ef2e6c-1f60-4d40-ba9a-2f83dd01c8f1 entityStatement 2019-06-18 false registeredEntity SIA "Clean Up Group" 2016-07-29 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    
73940 f5130548-9b54-4c2c-a5bb-e3503a7ffa97 entityStatement 2019-06-18 false registeredEntity SIA ENCATA 2016-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    
74337 be71e581-c544-4922-92d8-c892370098a5 entityStatement 2019-06-18 false registeredEntity SIA "LV Stonedge" 2016-10-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    
75544 327bf64e-a7f1-4742-8e57-aa712abb1c63 entityStatement 2019-06-18 false registeredEntity SIA "EdRol" 2017-01-20 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    
80189 9b44abef-ab19-4f5c-8a86-12ce558be907 entityStatement 2019-06-18 false registeredEntity SIA Spanga 2017-11-27 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    
80770 59701adc-4167-45b6-97e6-2b160a7fa35b entityStatement 2019-06-18 false registeredEntity SIA Labella 2018-01-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    
8543 ac361bfa-412a-40d3-bde8-63165d32731f entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Penta Maritime Agencies Ltd." 1998-03-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    
88256 6c9b3d2c-cfff-458f-8587-09f72e83c864 entityStatement 2019-06-18 false registeredEntity SIA Cehs M8 2019-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    
90409 61ba5db3-1ecb-4c57-aa67-6139c7b26648 entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Biznesa Izaugsme" 2007-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    
94257 e519d7e7-fb5a-4ef0-8432-0ecba2c12c6c entityStatement 2019-06-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "ŠAFRANS" 1999-10-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    
99401 338514b3-6153-4475-9a8c-f73de8331464 entityStatement 2019-06-18 false registeredEntity SIA "ADS Baltic" 1997-10-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    

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