entity_statement

28 rows where iscomponent = "false" and "statementdate" is on date 2020-10-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
102032 fa084ed5-cc92-4f5e-be76-c164231114f4 entityStatement 2020-10-26 false registeredEntity Liepājas speciālās ekonomiskās zonas SIA "Baltic Solar Factory" 2016-12-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    
10234 ec5f2b37-27f5-49f1-9ab6-8948179afce0 entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Diamedica" 1999-11-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    
106148 01563249-5537-413b-a5fd-841790e52bd3 entityStatement 2020-10-26 false registeredEntity POLLEO Commercial Cleaning SIA 2018-05-17 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    
110170 c4fb0f90-e5c4-4168-bc1a-b6c6bff40ed5 entityStatement 2020-10-26 false registeredEntity SIA "COL" 2012-08-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    
15337 7727bc3f-6942-45dc-9163-05d61b0ce315 entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Norwex Baltic" 2004-01-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    
17635 3ec0200a-ae1f-4919-85c8-9ef9c3ee9260 entityStatement 2020-10-26 false registeredEntity Eterna Law SIA 2005-03-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    
24372 c98e85ea-6eca-4463-82bb-56d05681e70a entityStatement 2020-10-26 false registeredEntity "B-COMS" SIA 2007-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    
26230 30436c72-ee16-448b-bc16-4314a9b112fb entityStatement 2020-10-26 false registeredEntity Ārvalsts komersanta Sabiedrība ar ierobežotu atbildību "MZ MARKETING & PROMOTIONS LTD" pārstāvniecība 2016-07-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    
38937 a086e933-d2c6-4c6b-b27c-1864b557744f entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "SEA-AROMA" 2010-10-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    
44153 124b0701-7d93-43c4-a4c4-22925afaf40b entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "JV MARITIME CONSULTING" 2011-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    
47096 46a5ff26-2287-4501-a070-ae9b0e206d60 entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "ADAPT VS" 2012-02-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    
47751 8e7c1756-3cee-49e3-9ded-8956f071c4ab entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lindas Nami" 2012-04-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    
55410 d990e843-4cd9-4fa3-a669-96b10a7acb7d entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "GlobalPack" 2013-07-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    
58147 8ddb452e-1f55-4da1-87eb-959de379f2b3 entityStatement 2020-10-26 false registeredEntity "OSVI WORK" SIA 2014-01-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    
59862 4483e81c-d276-490e-98ba-90615f8c5bfb entityStatement 2020-10-26 false registeredEntity SIA "LEMSAL AGRO" 2014-04-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    
65265 623101db-087d-4230-8acc-e8721e0fa5b5 entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cits Budzis" 2015-03-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    
65413 03d058ac-4e37-43d9-8613-7f90b88a35d8 entityStatement 2020-10-26 false registeredEntity SIA "Alutrade" 2015-03-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    
68540 742a638e-6cdd-4b1d-b14b-df79257caea2 entityStatement 2020-10-26 false registeredEntity SIA "CakeBake" 2015-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    
74214 967b93cb-82d7-4d5c-bdc1-6254576143f9 entityStatement 2020-10-26 false registeredEntity Belpromizolacija Baltia filiāle 2016-10-14 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    
7812 daecba57-7454-4786-88c8-03d4320171a4 entityStatement 2020-10-26 false registeredEntity Akciju sabiedrība "Latzemes aktīvi" 1997-06-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    
78536 50b62bba-f3a2-4212-b675-b2520e627772 entityStatement 2020-10-26 false registeredEntity SIA Media Solutions 2017-08-10 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    
79558 1f4fef29-c8af-43ba-8f18-d04018737041 entityStatement 2020-10-26 false registeredEntity SIA PEM properties 2017-10-17 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    
80893 4b6261f6-a0a4-4ebc-b6e7-5446f7129d5e entityStatement 2020-10-26 false registeredEntity USKALEX TRANS SIA 2018-01-10 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    
81487 df974998-d5e3-494a-967c-ce76812c89a6 entityStatement 2020-10-26 false registeredEntity SIA "VELKO GROUP" 2018-02-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    
85016 b1736328-aebf-4067-b855-d2e01ec64d96 entityStatement 2020-10-26 false registeredEntity SIA SENJORITA 2018-09-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    
8549 498b6fb6-161f-4730-883d-1406a74ecebe entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "RINNI" 1998-03-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    
85660 14604ca8-e4db-4870-bd3b-47ec349bed25 entityStatement 2020-10-26 false registeredEntity SIA "Vangažu māja" 2018-10-17 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    
97027 3e88e1c0-0599-4c18-94a3-6adfc5c60790 entityStatement 2020-10-26 false registeredEntity Sabiedrība ar ierobežotu atbildību "ERMAANT" 2018-01-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    

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