entity_statement

37 rows where foundingdate = "2013-11-05" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate

_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
105469 32bbb581-80ae-4417-aba0-59861a22eca8 entityStatement 2019-07-16 false registeredEntity SIA "Ascension" 2013-11-05 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    
110545 1d13532b-d470-4c12-83bc-e4d11df85db4 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "T & M būve" 2013-11-05 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    
57122 503097e3-9a52-412f-826f-6529e9dab472 entityStatement 2018-03-07 false registeredEntity SIA DENKIS 2013-11-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    
57123 885030dc-cf7e-4f41-aed3-137bed83768a entityStatement 2019-07-15 false registeredEntity SIA "ADVENTA" 2013-11-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    
57124 8788beaf-51d9-4add-9e99-741eab3a2282 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "PB-furnit" 2013-11-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    
57125 6982043a-3369-493c-8a98-662183ceb5d3 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Esteori" 2013-11-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    
57126 154a89c1-03b5-4a85-9e69-ef1760319806 entityStatement 2020-03-30 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rewood Kuurland" 2013-11-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    
57127 6ccd55e9-02bf-4f8f-8e04-1461b98c1002 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "DANASTAR" 2013-11-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    
57128 950a3fc4-af95-40ba-8f34-470921ba9b4e entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "SAINT TROPEZ s.r.l." 2013-11-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    
57129 4073c92a-1329-4ed4-a57c-dd01e27b438d entityStatement 2018-08-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIC PILGRIM" 2013-11-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    
57130 c8de3659-c4db-4f7b-a244-8f8cc2a4cf60 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Konstrukciju Montāžas Serviss" 2013-11-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    
57131 73839f5f-65e5-460a-b5ea-61d133c345ea entityStatement 2019-07-15 false registeredEntity SIA "H2B CAPITAL" 2013-11-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    
57132 af9cb560-b29d-455f-b377-48c0af655541 entityStatement 2019-07-15 false registeredEntity SIA "Portmet" 2013-11-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    
57133 d807599c-a06a-4369-aa09-035fbc25c32e entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "MAX VILLAGGIO GLOBALE" 2013-11-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    
57134 7620849a-491b-4b47-b213-2e30ab602364 entityStatement 2018-09-20 false registeredEntity SIA "BLISSTIME LV" 2013-11-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    
57135 cf43b1e9-d445-40c1-a506-7f6c08473315 entityStatement 2019-04-05 false registeredEntity SIA Apex Alliance Grecinieku 2013-11-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    
57136 809539fe-6773-4c8d-a938-9853f3b86acc entityStatement 2019-07-15 false registeredEntity SIA "LK TEA TRADE" 2013-11-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    
57137 1183484c-1fd7-4501-86e9-c8def78aee31 entityStatement 2018-11-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "IS Klīnika" 2013-11-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    
57138 92dbc9ba-7040-4683-8c0c-2f8385343bc4 entityStatement 2018-04-16 false registeredEntity SIA "Skanlika" 2013-11-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    
57139 b96b0564-97f5-44d9-8b5f-998977d5e0eb entityStatement 2019-07-13 false registeredEntity SIA "Five Gen Software Inc." 2013-11-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    
57140 a3dc7f2a-730a-4659-aaaa-2c6c3b022af5 entityStatement 2020-12-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "ARTALEX.SA" 2013-11-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    
57141 e75891e4-755b-483d-aebd-58d3c9f820cd entityStatement 2019-07-15 false registeredEntity Hillgate SIA 2013-11-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    
57142 27dce0bd-dd0d-49dc-8c66-4eb4e7079f06 entityStatement 2019-03-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "JV Arbor" 2013-11-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    
57143 d17b94bb-be4b-458e-af06-2b3eed2f4a96 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTIC INDEPENDENCE AGENCY" 2013-11-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    
57144 7dd98da4-f39f-484e-b37a-9142931bf127 entityStatement 2019-07-13 false registeredEntity SIA "Liquid IT Services" 2013-11-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    
57145 495ece73-b861-4bab-b4dd-04ca5cfd4582 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "GIE Company" 2013-11-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    
57146 c9d6f789-51f1-4392-a9c8-616187246e52 entityStatement 2021-01-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "Optika Pluss" 2013-11-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    
57147 b3d6f9c5-e9f9-4955-a54d-b881195a3ad6 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ausekļa 5" 2013-11-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    
57148 580b9097-3331-49cd-a457-d62ebb498b7c entityStatement 2019-07-13 false registeredEntity Baltic Import & Export SIA 2013-11-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    
57149 9f7b2cd7-20c6-4627-ada4-54d4e8a08fbf entityStatement 2019-07-13 false registeredEntity SIA "AB eksperts" 2013-11-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    
57150 fe856f91-ee81-491f-b39b-cfe13c3d5a18 entityStatement 2019-07-13 false registeredEntity 1 LB Serviss SIA 2013-11-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    
57151 0bac98b1-4607-4111-a772-6e71d692caba entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību GOLDENEYE 2013-11-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    
57152 0de6cf06-4571-46b9-88cf-bdfde3e50cbb entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "JANBERGS" 2013-11-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    
57153 02998400-1b45-4c57-96b5-215a6ce85941 entityStatement 2020-12-01 false registeredEntity SIA "RG TRANS" 2013-11-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    
57154 463a8d34-eb33-436a-8097-f3079e726af8 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "GKS CONSULTING & LOGISTICS" 2013-11-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    
91499 dcda7bfa-024c-48e9-b076-a6651f527002 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "COGORA" 2013-11-05 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    
96119 ef791a2a-4a3e-4632-a466-33147eb8befb entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "VNVG-Daugavpils" 2013-11-05 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]) 
);