entity_statement

34 rows where foundingdate = "2012-12-11" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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
101058 58f26a4f-ac52-4cb0-a2ac-53dd6316a00a entityStatement 2019-02-26 false registeredEntity SIA "BBR 3" 2012-12-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    
101059 24f16456-5d5f-4c0c-9ac8-a28daa3513cd entityStatement 2019-07-15 false registeredEntity SIA "AIP" 2012-12-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    
101060 13704036-c4d0-47ae-9a43-b99a9767f07b entityStatement   false registeredEntity SIA "Baltijas pakalpojumu centrs" 2012-12-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    
101061 3c44972f-dd15-4d6f-8233-c54032095c7c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Will Happen" 2012-12-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    
110251 384c40b8-df8c-4fa2-8516-9bbe9c5fab43 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltais sniegs" 2012-12-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    
110252 8e941211-6e23-48b6-a3ae-8c6e98fa8aa0 entityStatement 2019-07-16 false registeredEntity SIA "RimCi games" 2012-12-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    
51694 d0a627d0-aecd-452c-ab78-ca9f85d6de99 entityStatement 2018-03-01 false registeredEntity Sabiedrība ar ierobežotu atbildību "ACB Projekts" 2012-12-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    
51695 1c592b16-aacd-4bff-9973-f9a191dbef42 entityStatement 2020-07-23 false registeredEntity SIA "EKO Vides Serviss" 2012-12-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    
51696 4819ac15-0dc8-4c34-9a2b-abf7b8ba5465 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "OSStechnical" 2012-12-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    
51697 3e97016b-9cb6-471d-93b9-a78c71ee04de entityStatement 2019-07-13 false registeredEntity SIA "TALSU ESTATE" 2012-12-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    
51698 bc6fc9c3-c39f-4631-89b2-9cf7df036572 entityStatement 2019-03-05 false registeredEntity SIA "Vateris Enviro" 2012-12-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    
51699 a84d53d3-d154-45cf-89c7-403dd71185de entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "DD & C pakalpojumi" 2012-12-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    
51700 a8c3399b-2b8f-43bf-83c2-14c79c5240bf entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Up2datestyle" 2012-12-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    
51701 f1d3a70e-991e-4e5b-81a3-1c2d8cea08b6 entityStatement 2019-07-13 false registeredEntity "Software Development Services" SIA 2012-12-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    
51702 cd81d10f-16a7-4e08-9db8-b53ab423187c entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "RGS TNT" 2012-12-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    
51703 de10eae9-467b-44df-9fda-2bbd2a925cfb entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "MT Management" 2012-12-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    
51704 185f6a54-36f1-4d31-b1ce-0849185035bc entityStatement 2020-12-22 false registeredEntity Sabiedrība ar ierobežotu atbildību "Hotel Experts Services" 2012-12-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    
51705 e089801e-6c4f-4d74-80ca-3f2d9bd80b0d entityStatement 2019-07-13 false registeredEntity SIA "Parkita" 2012-12-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    
51706 ea75fc63-a886-4df3-909b-5dbeee2e5afd entityStatement 2019-07-15 false registeredEntity SIA "BALT DIZARH" 2012-12-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    
51707 b1229c72-7d56-4e3b-b907-1d7d897ca941 entityStatement 2020-10-27 false registeredEntity SIA "BALTFURU" 2012-12-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    
51708 c94c7600-670a-4cb0-980d-c8b2ba4d1f8b entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "VIKANTO" 2012-12-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    
51709 f03a7aae-a18c-412c-b4d3-94bc22abc07a entityStatement 2018-05-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "OZOLS IR" 2012-12-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    
51710 0df1757e-b44a-45f5-895f-dc32242264d6 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "INSTRA NS" 2012-12-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    
51711 aae28635-e336-4201-b793-626f5ee102f6 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Nuteko" 2012-12-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    
51712 cc368c2b-0936-488a-b39f-cd4b8810efe9 entityStatement 2019-07-15 false registeredEntity SIA "S.S. Music" 2012-12-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    
51713 15611fe1-5aa3-4739-a310-a564db5f82c2 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Zap Publishing" 2012-12-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    
51714 f692c514-aa0c-40ac-9f6c-27748391c1f2 entityStatement 2019-07-15 false registeredEntity SIA Cabus 2012-12-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    
51715 2a3e07ce-b3c9-4944-a5da-feb281be8d71 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Advertising Communications" 2012-12-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    
51716 3140ee6f-889b-405a-94d3-86e98d612530 entityStatement 2019-07-15 false registeredEntity SIA "ARDARENI" 2012-12-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    
51717 d9a3f3a6-b4c1-476d-a404-39ffccb6bbb5 entityStatement 2020-02-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "ASSET SALE" 2012-12-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    
51718 20f0c7fc-e5d9-4f26-85c5-a19728e8fcea entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "JS Riepas un Motori" 2012-12-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    
91257 1f91d65d-a71a-4eef-9b0b-028b7f925c11 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "PIERAKSTI" 2012-12-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    
95914 16a7e26b-5fd3-4833-915c-df3a05a04ab1 entityStatement 2019-07-15 false registeredEntity SIA "RISOMA" 2012-12-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    
95915 3d22ea6b-d15a-4ea4-86f2-5a9384a09472 entityStatement 2019-06-26 false registeredEntity SIA "BORUNG D" 2012-12-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    

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