entity_statement

33 rows where foundingdate = "2014-06-30"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (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
105553 7b90882c-b18f-4a68-a929-78d01e542ce2 entityStatement 2020-09-29 false registeredEntity SIA "ZEL & K" 2014-06-30 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    
27758 acaf6a7b-329d-4208-bf2c-6f83977bef9a entityStatement   false registeredEntity Latvijas zolītes federācija 2014-06-30 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    
60930 d5579d66-c2eb-44c2-8580-930feeff0f2a entityStatement 2017-12-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "EZERLOKI" 2014-06-30 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    
60931 b8428753-fb33-492d-a9d6-a70f4bee7e31 entityStatement 2020-11-03 false registeredEntity Sabiedrība ar ierobežotu atbildību "AVEŅU ZEME" 2014-06-30 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    
60932 310f87e0-6bd6-460e-9f42-53521ca6dfdd entityStatement 2018-09-28 false registeredEntity Sabiedrība ar ierobežotu atbildību "LATINVEST HOLDING" 2014-06-30 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    
60933 31decf38-72a3-4dd3-9643-a7d4a0151491 entityStatement 2017-12-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALT REGION INVEST" 2014-06-30 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    
60934 cb57e6f4-ce03-4b6c-a670-8fd44c97b238 entityStatement 2017-12-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "SAULESSTARU ZEME" 2014-06-30 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    
60935 6d88e98a-ad32-4f1f-879f-ca5aaf630ef5 entityStatement 2018-01-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "LATINVEST RĪGA" 2014-06-30 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    
60936 08efb93b-78af-458c-8e69-4af5ab62ac86 entityStatement 2019-07-13 false registeredEntity SIA "VeloBox" 2014-06-30 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    
60937 4cfffba2-579e-49d5-a0be-4614af2da553 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SV darbi" 2014-06-30 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    
60938 667cd6c3-3c79-486c-b199-da7a8b9f9857 entityStatement 2019-07-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "LATINVEST INDUSTRY" 2014-06-30 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    
60939 25d929cb-24a7-4ce4-bb31-d0b617b601d3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "LFT Garments" 2014-06-30 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    
60940 99d9ae3c-8c4e-4589-83f9-0acd72decd71 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Betibellas Apģērbi" 2014-06-30 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    
60941 692afd92-7821-464c-9b3a-3e1bd30b9c5a entityStatement 2018-03-07 false registeredEntity "Vecāķu 205" SIA 2014-06-30 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    
60942 3cb2bde6-8b27-4dd4-8e67-afcca10a5e21 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MERA GO auto" 2014-06-30 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    
60943 715542d1-7efe-400e-a338-97138b11965e entityStatement 2019-07-15 false registeredEntity SIA "GW home" 2014-06-30 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    
60944 936b0dfa-c2f1-4078-8bb3-119381ebc794 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "LiDu" 2014-06-30 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    
60945 9eae2fd4-3169-4eb8-96b3-78d41d438686 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Promid" 2014-06-30 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    
60946 ea6bb98c-9122-4d6a-a65f-2900991456e9 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALESSANDRO" 2014-06-30 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    
60947 2dfadcde-26e7-4ad6-8634-bb11fb129c8a entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Aluston A2B" 2014-06-30 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    
60948 c094edcd-2eae-4aa3-9a1b-5b89bf1627b3 entityStatement 2019-07-15 false registeredEntity SIA Alpha Vela 2014-06-30 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    
60949 82435914-9e9c-498e-b199-670f80fda857 entityStatement 2019-07-15 false registeredEntity SIA "LAKURA" 2014-06-30 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    
60950 7b503a4f-1b8d-4922-a5ff-1cff8b589a5e entityStatement 2019-07-15 false registeredEntity "HELLAS-AKROPOLIS" SIA 2014-06-30 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    
60951 3607040a-cd88-4fe7-a2a4-1089c9321ec6 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "CLARA RASS" 2014-06-30 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    
60952 a2feeb52-fbcd-44df-9232-4560593d4d10 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Gulbju terase" 2014-06-30 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    
60953 7894b628-79f5-4580-8a4f-73dc08be8b99 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "LATRIGA TOURS" 2014-06-30 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    
60954 1e2dfa29-18ba-498a-ac47-bb6b9a723d5a entityStatement 2019-07-13 false registeredEntity SIA "INDLOVU HOLDINGS" 2014-06-30 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    
60955 3a44e22b-3ce7-4717-acd6-04450f190bac entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mežsili A" 2014-06-30 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    
60956 4912959d-0fcb-4853-9348-9500a1f0b695 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ASU Projekts" 2014-06-30 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    
60957 8f5f6fe4-54a8-4f1a-9c61-1c0a9959fffc entityStatement 2018-01-03 false registeredEntity SIA TF 2014-06-30 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    
60958 5969cf76-67e8-4794-a8f5-59caecfebf69 entityStatement 2018-12-18 false registeredEntity SIA "ALPPROM" 2014-06-30 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    
60959 c2733351-d867-476f-a900-a4e4e53ae83f entityStatement 2019-07-13 false registeredEntity SIA RIMPEX LATVIA 2014-06-30 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    
96253 4dfc36a2-4ebe-44bd-8037-05d72b195194 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MG Interactive" 2014-06-30 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]) 
);