entity_statement

35 rows where foundingdate = "2013-01-23"

✎ 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
101088 dd59b8d2-6a39-4652-80a2-40313e9ab4bf entityStatement 2019-07-15 false registeredEntity SIA "Golden Truck" 2013-01-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    
105378 e298a8de-8e90-4d16-8349-f8aaa93f3162 entityStatement 2019-07-16 false registeredEntity SIA "RUFS DR" 2013-01-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    
110277 81f07558-e85a-461a-8a84-8a7bde281b6a entityStatement 2019-02-27 false registeredEntity Sabiedrība ar ierobežotu atbildību "Inotech Solutions" 2013-01-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    
110278 7120e57f-bda0-49a3-9183-86f54b80b1d7 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Susanna plus" 2013-01-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    
27572 1cf6e7a6-cfcb-49f3-aefa-39de61a55c96 entityStatement 2019-07-27 false registeredEntity "Afganistānā kritušo piemiņas fonds" 2013-01-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    
52287 d4cc83fa-96c9-4771-ab90-458fc1253f66 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "KomercRīga" 2013-01-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    
52288 0f6c90c4-64b2-45c8-9e28-79cdb091ceed entityStatement 2018-08-20 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mētras zemes" 2013-01-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    
52289 67364cc8-2fb2-4d07-98dc-22958c7eb8b3 entityStatement 2019-04-25 false registeredEntity Sabiedrība ar ierobežotu atbildību "ELEMENT FURNITURE" 2013-01-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    
52290 1a99504e-1495-4209-b0b2-d8c4e89b55c5 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Murano1" 2013-01-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    
52291 aeafed6a-d40b-4b79-b814-6c6dc7d97d0a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALUBUILD CONSULTING" 2013-01-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    
52292 cccfa3e0-aadb-492e-b18c-4df4273541e4 entityStatement 2020-11-19 false registeredEntity SIA "EuroMail" 2013-01-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    
52293 7f02b90b-e5c0-4bb3-bbe3-4343869164b9 entityStatement 2020-02-28 false registeredEntity Sabiedrība ar ierobežotu atbildību "L studia" 2013-01-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    
52294 5524201d-f0b6-4543-bcd1-d893a4a8b4bb entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTEX TRAVEL" 2013-01-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    
52295 3f7db419-78af-4cf1-b405-c9402add1742 entityStatement 2020-09-17 false registeredEntity SIA "Rūpniecības 11" 2013-01-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    
52296 6e168428-c2d0-49fb-b0fb-034ab5ba0990 entityStatement 2018-01-04 false registeredEntity SIA "LaRo Būve" 2013-01-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    
52297 27d34050-8dde-4016-8463-e1d7f2da9df2 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rikedom būve" 2013-01-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    
52298 35d849eb-428b-4868-938b-12c4f34e391b entityStatement 2018-02-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "TSM Construction" 2013-01-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    
52299 6d2624c4-0d37-43a3-aff1-2bf0f405efa4 entityStatement   false registeredEntity Sabiedrība ar ierobežotu atbildību "UPRENT" 2013-01-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    
52300 56b5e81a-acde-4cad-b95e-e1cee264192d entityStatement 2018-12-03 false registeredEntity SIA "Labie Instrumenti" 2013-01-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    
52301 998bb3ca-8095-4a71-b2cd-9067ea0d6401 entityStatement 2019-07-15 false registeredEntity Naviget SIA 2013-01-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    
52302 a845dd6d-60eb-4bee-bdc2-417b6a9f4ab8 entityStatement 2019-01-24 false registeredEntity "Victorem" SIA 2013-01-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    
52303 abe7d57c-4fc2-43f7-a58b-0ff2962f3148 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "NB.LV" 2013-01-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    
52304 4af87c1c-fc97-4cab-9033-62b3ef2780d9 entityStatement 2020-08-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Artera" 2013-01-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    
52305 668ae761-bf26-45d6-82d0-41e37129eb94 entityStatement 2019-07-13 false registeredEntity SIA "BV Capital" 2013-01-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    
52306 bcb112c8-1e8b-4bd6-ab25-5099269da943 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rinopal" 2013-01-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    
52307 bd650860-ba52-4428-a55e-701b40465205 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Instinct" 2013-01-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    
52308 84c571bb-f0b3-4df6-9949-79760ce5ef57 entityStatement 2019-02-01 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltic International Holdings LTD" 2013-01-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    
52309 735536f3-a116-4bd2-a15c-d346dd649807 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "SysAdmin" 2013-01-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    
52310 80b1ffe2-3625-436c-9ea2-6e157ae50690 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "PROMO KODI" 2013-01-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    
52311 0f9617f0-bb15-4ff1-bc18-fc816eaf7e60 entityStatement 2018-12-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Neoprofile" 2013-01-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    
52312 12f4906f-b002-4efa-981b-7b64d0d9e8e4 entityStatement 2018-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Argisty Marine Services" 2013-01-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    
52313 b36b852b-9cba-4c21-ac99-2898fa4040f3 entityStatement 2019-07-15 false registeredEntity SIA "LED BALTIC.LV" 2013-01-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    
52314 c4414926-cc58-478e-922a-2562793ee447 entityStatement 2018-08-20 false registeredEntity Sabiedrība ar ierobežotu atbildību "Ekis & Co-Positioning and Consulting" 2013-01-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    
52315 a35c892f-3b82-455d-b8fd-92e0a6194946 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GRITEKO" 2013-01-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    
95945 5040fbe8-e7c1-470b-b4d1-6bb2bfd1cb68 entityStatement 2019-07-15 false registeredEntity SIA "EVAS EXPERTS" 2013-01-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    

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