entity_statement

37 rows where "foundingdate" is on date 2015-04-16 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
101652 34f00059-13ac-4b5c-93ef-65e1da60cc89 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MBA Solutions" 2015-04-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    
101653 cab2c654-b860-499d-ba36-1a01e05ad344 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "DAVIDI" 2015-04-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    
101654 91144d66-aef6-42ab-92aa-78954c06af7f entityStatement 2019-07-15 false registeredEntity SIA "Ekoloģija RK" 2015-04-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    
105668 34313b1f-397c-4cbb-aa73-af18ed91831d entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "TAVR" 2015-04-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    
111017 50257d18-72a6-4b92-9a49-d29fdf0db983 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "ToliPharma" 2015-04-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    
111018 28c896c5-aca9-4d8e-aa10-2ea0208b416d entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Romaņi" 2015-04-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    
65811 b4d2f92f-3917-423c-9c81-b46a46a6319d entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "AC Consulting" 2015-04-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    
65812 d682dba4-6f04-48c3-8d2c-812a189fea1c entityStatement 2020-12-22 false registeredEntity SIA "Una Buslines" 2015-04-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    
65813 71430290-75f0-4a5e-adfc-6df52cd236c9 entityStatement 2020-09-08 false registeredEntity SIA "Baltic Investment & Development" 2015-04-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    
65814 700c991d-4b9e-494e-85b1-ee903df3a63c entityStatement 2019-07-15 false registeredEntity "RES BALTIC" SIA 2015-04-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    
65815 884a3a6d-647a-4d52-9764-34138cc857fa entityStatement 2019-02-28 false registeredEntity Sabiedrība ar ierobežotu atbildību "ExMed" 2015-04-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    
65816 95c67d81-474b-4e6b-84ae-93149eccda81 entityStatement 2019-04-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "Taino 1" 2015-04-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    
65817 f33948c0-957a-46a4-83af-2655fe6d955b entityStatement 2019-07-15 false registeredEntity SIA "GLIEMEZIS & CO" 2015-04-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    
65818 147befc8-7b8b-4872-a082-3f6f36f4765c entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Wild Winds" 2015-04-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    
65819 9ff403e3-b4db-44b2-8b5f-6f792108f085 entityStatement 2019-07-15 false registeredEntity FP SERVICE, SIA 2015-04-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    
65820 a4e6ca2b-0cf5-4ca3-bfde-d3adca538749 entityStatement 2019-07-15 false registeredEntity SIA "BETONĒTĀJS" 2015-04-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    
65821 816e06c0-bedc-40b2-806c-f28b171f3819 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Keiser Truck" 2015-04-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    
65822 2af52402-2c2b-4258-993f-25b218a3aa9f entityStatement 2019-07-14 false registeredEntity SIA "TE Service" 2015-04-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    
65823 9584456b-6612-4114-8479-d998216b7f71 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Taino 2" 2015-04-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    
65824 117b2bba-2835-4524-b582-bd355ab55fa0 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "SFE" 2015-04-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    
65825 ba79f7de-08a1-40c3-b1b8-503a9cbc11db entityStatement 2019-02-11 false registeredEntity Sabiedrība ar ierobežotu atbildību "ARSELECT" 2015-04-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    
65826 4901d650-92f2-4901-a77a-1cd2f5e8cf2a entityStatement 2019-07-14 false registeredEntity SIA "SOLVET" 2015-04-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    
65827 56de6029-5a67-4d4a-9911-5831eab82aec entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Munero" 2015-04-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    
65828 0ba778ff-92b4-4a73-b4c4-66810aee80c7 entityStatement 2019-07-15 false registeredEntity SIA "Zivju Gastro" 2015-04-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    
65829 a2fd22ce-f095-4ff5-aa17-88a437d44749 entityStatement 2018-09-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "JPVNAMI.LV" 2015-04-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    
65830 4ecf49e9-9c04-4bb7-aff0-b4cdc45b7132 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "PSJ" 2015-04-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    
65831 e792aca1-de29-4a00-b6fa-8ffc40e65919 entityStatement 2020-09-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "ENGUR" 2015-04-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    
65832 1871bbc4-b40b-450f-b3c9-39652ca3f279 entityStatement 2020-03-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "GM fitness" 2015-04-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    
65833 fc59745e-9858-4fe7-a547-5a0505c41cc6 entityStatement 2019-07-15 false registeredEntity Go For Shapes SIA 2015-04-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    
65834 894141da-4eb1-4df1-9a71-927292e03e63 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Taino 3" 2015-04-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    
65835 4da948c9-d7bb-4754-8cd4-0eb8928068de entityStatement 2018-03-08 false registeredEntity SIA "Baumane & Partners" 2015-04-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    
65836 50141a13-fdda-4942-a3e4-bbb8f30492c9 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Biapharma" 2015-04-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    
65837 7ff58fd1-96db-4941-b9a0-fadb03660799 entityStatement 2020-06-19 false registeredEntity SIA Griffin Baltic Residential 2015-04-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    
65838 13605300-b674-4c95-bdc3-751d4c113336 entityStatement 2020-12-04 false registeredEntity SIA "HOYA Media" 2015-04-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    
65839 194b51ec-2a8a-45d7-8774-45cd268e0aaf entityStatement 2020-09-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "BioFire" 2015-04-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    
65840 4f0aba3f-4262-4e66-b306-f7c35abfd640 entityStatement 2019-07-15 false registeredEntity SIA "R & D Lab" 2015-04-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    
96440 4bffaece-8916-4c26-8f87-e76f2297c5d3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Būvlukss" 2015-04-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    

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