entity_statement

38 rows where foundingdate = "2014-07-16", "foundingdate" is on date 2014-07-16 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, 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
101467 66ff7d05-ed07-4b76-bf43-e87c70ca8dca entityStatement 2019-11-29 false registeredEntity Sabiedrība ar ierobežotu atbildību "invest grupa"REGAL" 2014-07-16 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    
105563 c9345593-db50-4c2b-a1a4-6aa85821b652 entityStatement 2018-08-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "AUTOSKOLA KRISTĪNE" 2014-07-16 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    
110754 5ce2ceaa-b772-4405-90b5-ccbda631371e entityStatement 2019-07-16 false registeredEntity SIA "TranzNet" 2014-07-16 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    
110755 1b34c3ef-2099-46a4-9e50-fc36b567b2d8 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltu galerija" 2014-07-16 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    
61226 23ced292-b8fd-44dc-9151-31e3bfe5ca0c entityStatement 2019-07-14 false registeredEntity Veģu Auto Jūrmala SIA 2014-07-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    
61227 5929cbf3-df0c-4fe6-931b-70517cd34be1 entityStatement 2020-10-30 false registeredEntity SIA "WE connect" 2014-07-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    
61228 3bcdfdad-18ac-48ab-a3e0-c2a901bb31e6 entityStatement 2019-07-15 false registeredEntity SIA "Artspace" 2014-07-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    
61229 e9896a91-bdd9-4456-930c-133c4d647588 entityStatement 2019-07-15 false registeredEntity "Slim IT" SIA 2014-07-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    
61230 64548f89-4b45-4c82-83d9-06845f7f8b68 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "GM Finance" 2014-07-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    
61231 8cfaac14-df02-46f2-bfb7-2f0c2e00bf48 entityStatement 2019-10-24 false registeredEntity Sabiedrība ar ierobežotu atbildību "Light Finance" 2014-07-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    
61232 8c2b06e7-919c-412e-983c-8f51e4d41b6e entityStatement 2019-07-14 false registeredEntity SIA "Dīzeļu Remonts" 2014-07-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    
61233 18402258-dc3c-4103-8dd8-418e2e42c408 entityStatement 2019-07-15 false registeredEntity SIA "Z Creative" 2014-07-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    
61234 b7c3cc24-990c-4a6f-b639-e4908883266a entityStatement 2019-10-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "ORDO DEVELOPMENT" 2014-07-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    
61235 07a378df-e1fb-45bd-ad9c-ae3f2cee5380 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "EVIO VIVENDI" 2014-07-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    
61236 384569e3-2ecc-4baf-8706-dab4e4e2e72d entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Dainis EL" 2014-07-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    
61237 4ef8edef-f075-46c6-9509-85b038739b24 entityStatement 2019-03-28 false registeredEntity Agritrading SIA 2014-07-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    
61238 6aa88c82-b266-4e75-935b-9f2932ff1c9d entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Elitremont" 2014-07-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    
61239 4b42e210-925b-4ae4-8dc9-ec8dab07038d entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "VITA HOME" 2014-07-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    
61240 7ea53576-b356-46ff-9d9d-24d679b8400a entityStatement 2018-10-23 false registeredEntity SIA "STABO" 2014-07-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    
61241 b3f0488f-5acc-4761-8dba-ec89ebb6d011 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "YourCAM" 2014-07-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    
61242 a64c5d93-e5ab-408a-b02c-e988c262356b entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MDZ Sistēmas" 2014-07-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    
61243 44f4b764-47ae-4aee-8169-548985197ebc entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "I.Kerubiņas fizioterapijas centrs un Baby Spa" 2014-07-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    
61244 909796e8-2740-4c08-92c9-4a142d8c7779 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "RS84" 2014-07-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    
61245 a97452e1-fbc4-4c30-86e1-39e6acaefdcc entityStatement 2019-07-15 false registeredEntity SIA "Data Research" 2014-07-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    
61246 a6d9602c-ca29-45f0-b813-495607f36b3d entityStatement 2019-06-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "UZ SVARU" 2014-07-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    
61247 06693f9d-f58b-4984-a6c2-c557906d0df6 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Eironika" 2014-07-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    
61248 939fcc24-79b2-46d2-800c-fc54f507a81e entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "DML Building" 2014-07-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    
61249 e3024d36-e9c4-4cc7-9696-b17749e03623 entityStatement 2018-04-12 false registeredEntity SIA "SimBalt Trans Group" 2014-07-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    
61250 84fd343c-c484-4362-aba2-8e21d2f5da46 entityStatement 2019-07-15 false registeredEntity SIA "EVOKE" 2014-07-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    
61251 30ff778e-8160-4ab7-af96-6102f0fb8aeb entityStatement 2019-07-15 false registeredEntity "AM PR Services" SIA 2014-07-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    
61252 c889a115-c79b-41b6-a335-1ff406992cbb entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "GP Financial Management and Investments" 2014-07-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    
61253 db1ba094-9869-4501-a7aa-dfb549736a7f entityStatement 2019-07-14 false registeredEntity Veģu Auto Serviss SIA 2014-07-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    
61254 e78e5055-65f4-49d2-9b43-39d7652c862b entityStatement 2019-07-14 false registeredEntity SIA "Green Pharma" 2014-07-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    
61255 9281e4ef-9072-4e78-bf61-d7d2372986cc entityStatement 2019-01-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "4 REASON" 2014-07-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    
61256 d9a1b302-6a76-40ad-b373-c2836b292151 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Spectra Planet" 2014-07-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    
61257 81926368-1b6c-4c6c-a76e-aa2500cd2bc0 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALISTERRA" 2014-07-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    
61258 16b0d57e-dd2f-4058-b0c9-15822abc50e1 entityStatement 2018-03-06 false registeredEntity Sabiedrība ar ierobežotu atbildību "KAFEJNĪCA" 2014-07-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    
61259 382c37ba-2aac-4ff0-8ddc-4963dd2335f3 entityStatement 2018-06-12 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lucky thirteen" 2014-07-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    

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