entity_statement

28 rows where "foundingdate" is on date 2013-01-29 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
101092 f30e1d43-f94c-467e-a3e1-646218bf58f5 entityStatement 2019-07-15 false registeredEntity SIA "BO CONSULTING" 2013-01-29 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    
101093 582dddf2-e9c9-4dc8-83a5-6914b030d8dd entityStatement 2019-07-15 false registeredEntity GS Furnitūra SIA 2013-01-29 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    
101094 209599e4-2e9b-4690-af16-77f330e787c0 entityStatement 2019-07-15 false registeredEntity SIA "PILAT Real Estate" 2013-01-29 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    
101095 e7b8d104-2073-4230-81f1-846bddc6dec4 entityStatement 2019-03-15 false registeredEntity SIA "UMBO Baltika" 2013-01-29 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    
110287 dd3c77ca-c009-4135-9d0e-c5cbc41c8c1f entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Agro RB" 2013-01-29 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    
52385 cab04a09-482e-4f0a-aa61-9d770b1bb6c9 entityStatement 2019-01-31 false registeredEntity Sabiedrība ar ierobežotu atbildību "Laba Daba 2" 2013-01-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    
52386 0fc3f8a3-6460-4843-90e0-c6c17ef9baf5 entityStatement 2019-07-15 false registeredEntity SIA "Vecozoliņš" 2013-01-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    
52387 ffb5f204-ecd6-4af6-b3af-19a0a847626d entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Jaroslavna Dizains" 2013-01-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    
52388 f9a0f8fc-608c-4467-bd00-5f36910f97e3 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "BRISTOL" 2013-01-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    
52389 cba1795d-22b4-4d2f-b23f-0b29c4380c9a entityStatement 2017-12-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "VT-MED" 2013-01-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    
52390 51b8d0c1-e7e8-479f-ba9a-4ffe731aad24 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Medaurum" 2013-01-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    
52391 1df6e60a-084a-4211-b594-e226e70c10bd entityStatement 2019-07-15 false registeredEntity SIA "Baltic AdCom" 2013-01-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    
52392 a1bec439-ec21-447a-81a4-670431731645 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "3D Sports" 2013-01-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    
52393 6c863f99-61d9-49bb-a907-a2a45cfc64c3 entityStatement 2020-05-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "FSQ" 2013-01-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    
52394 8a7fbed1-53a8-4973-9203-7f9cfa69748d entityStatement 2018-06-27 false registeredEntity SIA "MRS INVESTMENTS" 2013-01-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    
52395 9cc37b05-deca-4c4f-a31d-4550dd52d80b entityStatement 2018-02-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "NORDCENTRIX" 2013-01-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    
52396 6d5165b6-efd2-4cff-9274-d5e9460edf9c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "EKOM FINANCE" 2013-01-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    
52397 d5f766ed-664a-44c3-8277-649d87660bf3 entityStatement 2018-10-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "LARLV" 2013-01-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    
52398 f4abe300-de28-4b7e-b300-60a9ce694a98 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "JR15" 2013-01-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    
52399 ef843d5c-99ce-4088-9517-bf92bb85d748 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Jaundubults" 2013-01-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    
52400 c17189e7-4598-4061-89fa-fcefeabb815e entityStatement 2018-06-29 false registeredEntity Sabiedrība ar ierobežotu atbildību "SUNS UN PIRKSTS" 2013-01-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    
52401 95bc4982-64de-4d43-899e-d0d3b6a164da entityStatement 2020-03-11 false registeredEntity SIA "ISA X" 2013-01-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    
52402 bf97e355-4881-4c55-9c33-46d6d7c20fdc entityStatement 2019-07-15 false registeredEntity SIA "EASY HIRE" 2013-01-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    
52403 440101fa-b9ff-45f3-9bc9-2998a309a797 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Even Keel" 2013-01-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    
52404 8a169e6d-086d-4061-b514-c1ce4834ba95 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "KD Service" 2013-01-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    
52405 6a6203a3-cfc0-4839-97f9-5b5243eebdb5 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "RixTrans" 2013-01-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    
52406 929d65e9-666d-44c9-a1be-203d470de021 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tree Climbers" 2013-01-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    
95953 1916fcb2-c9ec-4e88-9b00-3bf92e2b7743 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "FM konsaltings" 2013-01-29 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]) 
);