entity_statement

46 rows where "statementdate" is on date 2017-12-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: foundingdate, 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
106021 d3e969b7-42b1-4f58-9acf-b74e9e25a617 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Zāles uz mājām" 2017-12-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    
10782 1f580045-bcb5-45ee-a8a5-9f9bcd30ea2a entityStatement 2017-12-18 false registeredEntity SIA "NOR Trade Services" 2000-04-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    
10980 bd2f4128-bb36-42f2-8b69-5d6db2a16323 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Reck" 2000-07-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    
111805 d2841b8e-094b-412e-b11b-911892f90b7f entityStatement 2017-12-18 false registeredEntity SIA "Food Tech Trade" 2017-12-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    
111806 ce67b73f-faf9-4993-a01a-b354638b1282 entityStatement 2017-12-18 false registeredEntity SIA "WEST GLOSS" 2017-12-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    
18138 518c28f6-eeb4-4963-970a-d0d1b3eafff7 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Stabu 92" 2005-06-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    
25411 c2ed4207-4f05-48f5-8d8a-1929afe87cfc entityStatement 2017-12-18 false registeredEntity SIA "Carnitec" 2007-12-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    
28196 c6bc9159-7745-48d5-868f-0bc1d0d28946 entityStatement 2017-12-18 false registeredEntity Biedrība "Futbola klubs "ZELTA RĪGA"" 2017-12-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    
34510 538a5b2d-6aa9-4588-a71b-5dc4a6cbcabf entityStatement 2017-12-18 false registeredEntity SIA "Smaids S.U." 2009-04-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    
41041 03ea4b09-32de-4b3c-b9eb-07aebbaa3f18 entityStatement 2017-12-18 false registeredEntity SIA "FORBEST" 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    
4549 91a70ded-7eeb-4c58-9cf5-1e97f1097640 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "KURZEMES SĒKLAS" 1992-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    
51917 0a65b322-f845-49ac-a33c-0b7ea353ade7 entityStatement 2017-12-18 false registeredEntity SIA "Savilina" 2012-12-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    
53624 429e19e1-7e37-456f-8c99-c94e5d304d08 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "REMARDA" 2013-04-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    
54104 b3bf63ce-286c-4548-b3a0-2c6f63371ba4 entityStatement 2017-12-18 false registeredEntity SIA "ITERA" 2013-04-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    
55130 0a84cab9-5a2f-46bf-b37c-a9f85c2a32b3 entityStatement 2017-12-18 false registeredEntity SIA "Mājuserviss.lv" 2013-07-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    
58020 a1fb3c36-ce0d-43ce-9232-1cb3aa3c1ddc entityStatement 2017-12-18 false registeredEntity SIA "OMNI PRO" 2014-01-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    
5858 9e49b853-d041-48d1-afc7-8686fd113a0b entityStatement 2017-12-18 false registeredEntity "ALPHA SHIPPING COMPANY" SIA 1994-12-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    
59361 2dacedd3-4c92-43c0-adaa-e0e04598f4e6 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "KBO" 2014-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    
62397 fcb1eafe-22f7-4759-9c23-6dd5090529ca entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "WOOD IN" 2014-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    
66986 16f519b7-0566-467d-91cb-bff7a46b1cb9 entityStatement 2017-12-18 false registeredEntity SIA "NPBU" 2015-07-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    
70019 2aacc5c2-c3f5-44ba-a128-d49f574bfee6 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Krone Transport" 2016-01-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    
70928 a5fe5eae-6656-47b9-bee5-8076c36aaa2b entityStatement 2017-12-18 false registeredEntity SIA "Global skaistums" 2016-03-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    
73757 8a062618-919e-4737-9bbc-0b561d69546a entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Box Homes Norge" 2016-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    
74611 1fc6ed08-e0c1-468a-8bc1-2ce62265ab8b entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Leveria" 2016-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    
74774 c74b7aea-dd1a-4b5e-b45a-e4339bc8428b entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "AG Investment" 2016-11-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    
75670 31a15280-09ce-4f9f-8a6a-0449822c2866 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "LK Finance" 2017-01-30 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    
79510 789d94c0-8427-4aef-9fed-44fd6c991f2c entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "SPL apsardze" 2017-10-13 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    
80215 d431ec5d-74d2-49c2-870c-18470755b59d entityStatement 2017-12-18 false registeredEntity SIA EmkaTransports&Co 2017-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    
80535 8702bb43-b8cc-4c50-a07a-e73df56df687 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cente Building" 2017-12-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    
80538 6f92027f-d81f-4e23-90a1-6919bf0c4464 entityStatement 2017-12-18 false registeredEntity SIA RBA Consulting 2017-12-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    
80539 fb1b05ba-e320-4dfb-a225-f24f542b8615 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "CIV 4" 2017-12-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    
80541 2d870b32-3266-411f-b50f-7456116211af entityStatement 2017-12-18 false registeredEntity SIA "JURKOMERC I" 2017-12-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    
80544 85a9bee3-6ea3-448f-a6a0-e4851f6442c2 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "AM Accounting" 2017-12-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    
80545 812909a4-0eb1-49bb-8ae4-dd34aabe8fab entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "RK Real Estate" 2017-12-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    
80546 faab66e5-5a70-4f88-965a-d54e36fa643c entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "NBS Holding" 2017-12-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    
80547 331d99d6-200f-4064-85d3-2353da02dcaf entityStatement 2017-12-18 false registeredEntity SIA "F-Optika" 2017-12-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    
80548 b1f7f3d3-58cb-44bd-a136-730281d35528 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Fenster Serviss" 2017-12-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    
80550 816c351b-8d55-4c01-8fe7-b7ba8cce20ac entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "KL Consult" 2017-12-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    
80551 a5245f70-49d8-49e7-9b88-6ad9821624e3 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "OE Parts" 2017-12-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    
80552 679890fa-d315-46ad-a374-885aff934f93 entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Print Preview" 2017-12-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    
80553 19a216f8-add3-42a4-ab94-846721e7dc05 entityStatement 2017-12-18 false registeredEntity SIA "GLOBAL TRADE DEVELOPMENT CO." 2017-12-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    
80554 22c36f7d-a51b-41eb-9e92-e996e2c8a3ec entityStatement 2017-12-18 false registeredEntity SIA "Kristas Ziedi" 2017-12-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    
80555 0be760e1-1e8e-4a96-9e3a-d0226c16c7be entityStatement 2017-12-18 false registeredEntity SIA "Baltic Fox" 2017-12-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    
80556 d4982e40-6e4f-4197-a54c-44da8c999fb8 entityStatement 2017-12-18 false registeredEntity SIA ICP 2017-12-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    
91529 0287615b-3b06-4560-abd3-1418594790c2 entityStatement 2017-12-18 false registeredEntity SIA "RR Concept" 2014-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    
92348 df36a320-f95e-465a-baa2-7d54ef9549ee entityStatement 2017-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "KRF meži" 2017-12-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    

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