entity_statement

40 rows where foundingdate = "2015-03-24" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate (date), foundingdate (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
101628 3bcd5cca-dc3c-48da-9ef8-9831a82afedd entityStatement 2018-09-20 false registeredEntity SIA "Art Baltic Spa" 2015-03-24 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    
101629 109ebec6-0257-4bf7-9068-c7d20b547dd0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Pelni" 2015-03-24 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    
101630 8db02ae9-e523-4ff6-b64e-ee093bea4b96 entityStatement 2018-09-10 false registeredEntity SIA "BA Services" 2015-03-24 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    
101631 adf0da7a-12e3-4bd1-9400-46db17f641c9 entityStatement 2019-07-15 false registeredEntity SIA "Kompleksbūve GM" 2015-03-24 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    
101632 87aec8ab-4f1d-47ca-85e9-43825524cb7f entityStatement 2019-07-15 false registeredEntity SIA "SEVEN SISTERS" 2015-03-24 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    
105656 29d9a6aa-662c-4897-9e3b-d3f3693b61fc entityStatement 2018-04-23 false registeredEntity Sabiedrība ar ierobežotu atbildību "Meistars-R" 2015-03-24 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    
110992 b44081aa-e31b-4894-b07f-895f87834972 entityStatement 2019-07-16 false registeredEntity SIA "Briga 58" 2015-03-24 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    
110993 149b503a-4843-4f4d-bed8-92592dbef9fa entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "G SERVISS" 2015-03-24 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    
110994 67a07f88-50b9-4434-b55f-eb03ca86ad40 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "ECO WIND LATVIA" 2015-03-24 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    
65403 a7bd26a4-08da-435b-91c8-179d1ba7e599 entityStatement 2019-07-14 false registeredEntity SIA "T & M Connect" 2015-03-24 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    
65404 444d9f73-38fc-4cda-9c3d-b3e3a0237ed1 entityStatement 2019-12-16 false registeredEntity SIA "Global Success Solutions" 2015-03-24 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    
65405 a1ef32ab-6955-4bcf-9a40-a7e77c923ca8 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SMS Service" 2015-03-24 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    
65406 c64cfe5f-0b2b-46c2-8b1d-d365c7831233 entityStatement 2019-07-15 false registeredEntity SIA "A.N. Siltumprojekti" 2015-03-24 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    
65407 4fa2a37a-fe5a-4be2-8477-2ff2e8ec5436 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SHINE STORM" 2015-03-24 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    
65408 e8c29508-e2a7-4ec4-b9c1-1713729e426c entityStatement 2019-07-15 false registeredEntity SIA "VALNAST" 2015-03-24 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    
65409 02b25c5a-250f-4858-9368-b0a913b2dd0e entityStatement 2019-07-14 false registeredEntity SIA "MKRIGA" 2015-03-24 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    
65410 4aea3bbc-0edf-49a0-9b9b-826dec3116db entityStatement 2019-01-18 false registeredEntity SIA LAGE GROUP 2015-03-24 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    
65411 86d9d134-3d9e-43ea-85de-585989ee8673 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Bureza" 2015-03-24 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    
65412 fd9d06b3-c9e1-4e4c-9b21-5270dbb1a66a entityStatement 2019-04-03 false registeredEntity "Ieteikumi biznesam" SIA 2015-03-24 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    
65413 03d058ac-4e37-43d9-8613-7f90b88a35d8 entityStatement 2020-10-26 false registeredEntity SIA "Alutrade" 2015-03-24 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    
65414 a3aeb7ce-7e71-4b72-beb7-3771e72fa019 entityStatement 2019-07-15 false registeredEntity SIA "KILIMALIS" 2015-03-24 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    
65415 94bbaf3b-77e2-437e-b1d5-0b0e42667a88 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "CITY CAMPING" 2015-03-24 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    
65416 09a9b115-4219-46c5-b6b7-88730746d886 entityStatement 2019-05-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "Pribalt Express" 2015-03-24 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    
65417 0d4b057d-ad9e-49c6-926d-14e4b18d20a8 entityStatement 2020-09-15 false registeredEntity Hausbauer SIA 2015-03-24 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    
65418 7d66bc6d-f8a9-4b57-b6c7-ccdc8efda980 entityStatement 2018-03-23 false registeredEntity "MP Holdings" SIA 2015-03-24 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    
65419 ee5b1ccc-df5e-4fa9-b11e-f636d29b7c7d entityStatement   false registeredEntity SIA "AB Dizains" 2015-03-24 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    
65420 7ded9d84-7440-4ab1-9cb0-f13fdbb27584 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Spectrum Pay" 2015-03-24 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    
65421 b458a3e0-7bf0-4e49-bed7-73903a11729d entityStatement 2019-07-15 false registeredEntity SIA "SVET 741" 2015-03-24 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    
65422 af7f0626-c55e-4e6b-85a7-781063c93a23 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Visikums" 2015-03-24 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    
65423 6561883e-6bf5-4c98-b3ce-7506cf151b9e entityStatement 2019-07-14 false registeredEntity SIA "ZEMAN" 2015-03-24 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    
65424 b4857d3a-d079-43c6-9e22-671c78ca8d32 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "SHOUSE" 2015-03-24 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    
65425 41d349ab-c6be-4194-adee-08bcffceece7 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "JPS atbalsts" 2015-03-24 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    
65426 b115886d-220d-4844-89ea-dd8354d0845a entityStatement 2019-07-15 false registeredEntity SIA "Mpatīk" 2015-03-24 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    
65427 1d6ab67e-815a-4215-aa7b-b37e99d697f8 entityStatement 2020-07-24 false registeredEntity Sabiedrība ar ierobežotu atbildību "Etno Dzērieni" 2015-03-24 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    
65428 59a1a103-ac4c-488e-8c7a-fae152aa520e entityStatement 2020-02-26 false registeredEntity SIA "HRH" 2015-03-24 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    
65429 c6c66f97-1415-4b06-b298-08a0d82e66ee entityStatement 2020-10-09 false registeredEntity SIA "Nord Direct" 2015-03-24 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    
65430 d49258b0-667f-4b4e-8dc5-22b15b9511cf entityStatement 2019-07-15 false registeredEntity SIA "Washit" 2015-03-24 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    
65431 fc94d4fb-e705-4932-9535-25ba6e627ced entityStatement 2019-07-14 false registeredEntity SIA "VF Home" 2015-03-24 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    
65432 75295a70-0491-4f13-bb8d-8031dad8c271 entityStatement 2019-04-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "OMEGA-Service" 2015-03-24 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    
65433 20790741-b62e-4d1b-82e7-8f6bf4e9c6be entityStatement 2019-07-15 false registeredEntity SIA "InStellar" 2015-03-24 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]) 
);