entity_statement

40 rows where foundingdate = "2016-03-11", incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, publicationdetails_publicationdate, 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
101862 3a1d9523-0c23-4c52-a5e0-9079a4cadf06 entityStatement 2019-07-16 false registeredEntity SIA A.Z. Truck 2016-03-11 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    
104013 79ed052b-a36a-496b-8780-a4b3ca98fbba entityStatement 2019-07-25 false registeredEntity Sakstagala pagasta zemnieka saimniecība "Māli 2" 2016-03-11 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    
104014 efd04eb9-7654-4d60-a3da-affee2e5895f entityStatement 2019-07-25 false registeredEntity Nagļu pagasta zemnieka saimniecība "Ašu sils 1" 2016-03-11 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    
111333 4af36783-54d4-4681-946b-ffd414fa93a4 entityStatement 2019-04-03 false registeredEntity SIA "Corn Maze" 2016-03-11 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    
70984 69c2589f-7d04-4db0-9fc2-5b596b8c9ecf entityStatement 2019-07-15 false registeredEntity SIA "ATL būve" 2016-03-11 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    
70985 af68aa78-dc7d-4b76-b846-38197fd1c1f6 entityStatement 2020-08-17 false registeredEntity SIA "Serdes" 2016-03-11 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    
70986 782cf408-2131-49c5-8d0f-64d626f7fb81 entityStatement 2019-02-13 false registeredEntity SIA "Finsputnik platforma" 2016-03-11 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    
70987 eb0c96c5-7a58-4426-b24f-ed039993689c entityStatement 2019-09-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "EP transports" 2016-03-11 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    
70988 3d8bcdef-1329-4416-8b73-6868dfc53db6 entityStatement 2019-07-15 false registeredEntity SIA "Arvla" 2016-03-11 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    
70989 f77725e5-f45a-4c98-9d04-a9ec6ce1351b entityStatement 2019-07-14 false registeredEntity SIA "AVK System" 2016-03-11 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    
70990 6d8c24c8-bf8a-4f8c-a67c-2ce815125bed entityStatement 2018-08-31 false registeredEntity Sabiedrība ar ierobežotu atbildību "VARPU Tennis Club" 2016-03-11 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    
70991 4cac2a09-32b9-4298-b904-b9800c00d34a entityStatement 2019-07-15 false registeredEntity SIA "AMMERS projekti un grāmatvedība" 2016-03-11 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    
70992 e2a0b166-32da-44f5-92bd-b9aa83550751 entityStatement 2019-07-15 false registeredEntity SIA "AMBRE FURS" 2016-03-11 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    
70993 11a760a4-2703-42f5-a4ac-7ec926d9d2a8 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ArAuto 24" 2016-03-11 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    
70994 db2e36de-a062-4a28-a6ee-f026ca0c7203 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "PIRMĀ MIOFUNKCIONĀLĀ KLĪNIKA" 2016-03-11 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    
70995 478f5097-0deb-4d73-8de3-688628367192 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "DETOX BOX" 2016-03-11 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    
70996 6459e72d-1cc3-476b-b4b9-b12422599d2a entityStatement 2019-01-02 false registeredEntity Sabiedrība ar ierobežotu atbildību "SUPER M" 2016-03-11 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    
70997 e51e7a62-73a2-43a1-9d64-5bc16bdbf72b entityStatement 2019-07-14 false registeredEntity SIA "KASK Composites" 2016-03-11 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    
70998 696ceedc-a0fc-4bf3-93f4-bdcac941c91e entityStatement 2019-07-15 false registeredEntity SIA "Bleizit" 2016-03-11 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    
70999 7400d376-fb25-4c16-9e93-22d6e559746a entityStatement 2020-08-10 false registeredEntity GG Management SIA 2016-03-11 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    
71000 1702b855-e256-439d-b664-64ed39de836a entityStatement 2019-07-15 false registeredEntity SIA MB Serviss 2016-03-11 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    
71001 7417b104-62c5-4193-80e9-ccb5af982809 entityStatement 2019-07-15 false registeredEntity SIA DRV Auto 2016-03-11 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    
71002 d4c17017-6914-4dd2-919f-615f776972fb entityStatement 2019-07-15 false registeredEntity SIA Remonts ar prieku 2016-03-11 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    
71003 011ac7d1-9f9f-40ad-80eb-82d81e7e4f3f entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mestre" 2016-03-11 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    
71004 8d1de500-af13-471a-be7b-4e879d18c786 entityStatement 2019-07-14 false registeredEntity SIA "Kandavas Kartinga Centrs" 2016-03-11 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    
71005 9aa9d940-a5c4-4d8f-9a70-e3f4de73ec67 entityStatement 2019-07-15 false registeredEntity SIA ECO BIRD 2016-03-11 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    
71006 801f8bcb-ce03-40ba-9a70-c3f1fb8de621 entityStatement 2020-11-12 false registeredEntity "Bitum LV" SIA 2016-03-11 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    
71007 86868720-0f52-4c3d-9ddb-92ef0d24e3cb entityStatement 2018-09-27 false registeredEntity SIA "Media Nams Vesti" 2016-03-11 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    
71008 26d6a95d-124c-416f-ba9c-1ea2891f4e31 entityStatement 2019-07-15 false registeredEntity SIA "Kunkri" 2016-03-11 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    
71009 0431104d-1b5e-4933-b978-c48b62685dad entityStatement 2019-07-15 false registeredEntity SIA SF Eksperts 2016-03-11 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    
71010 53472b5f-8632-41f6-8dda-5e77044aabc3 entityStatement 2019-07-15 false registeredEntity SIA "AKMENS APSTRĀDES EKSPERTS" 2016-03-11 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    
71011 4f663a46-c035-4b34-9c5a-cd57bb75e529 entityStatement 2019-02-22 false registeredEntity SIA "H2O Pluss" 2016-03-11 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    
71012 7179b3a4-b75e-4c71-bf90-dbd8ca817e35 entityStatement 2019-07-14 false registeredEntity SIA "HOT HOLDING" 2016-03-11 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    
71013 bcfa0b93-fc6d-44ef-8bda-3b1361c75d58 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Medini Latvia" 2016-03-11 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    
71014 13e2254d-f227-471c-95db-e7670c6fbf26 entityStatement   false registeredEntity AFLATEK SIA 2016-03-11 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    
93608 588323a8-f0e5-460a-b6aa-0a68f64fba11 entityStatement 2019-07-25 false registeredEntity Rudzātu pagasta zemnieku saimniecība "Vilcāni" 2016-03-11 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    
96625 ee664bfc-eb8e-46b3-8a62-21d10120ff3b entityStatement 2019-12-10 false registeredEntity Sabiedrība ar ierobežotu atbildību "Roberto K" 2016-03-11 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    
96626 ed13b765-2bc9-4f60-97c6-15ca902ff6f2 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Oltija" 2016-03-11 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    
96627 92e05b03-1c25-488c-8977-66804b857060 entityStatement 2019-12-18 false registeredEntity Sabiedrība ar ierobežotu atbildību "01 Autoskola Impērija" 2016-03-11 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    
96628 3234676c-f189-4d84-8aa9-97574177ec7d entityStatement 2019-07-15 false registeredEntity SIA "VPasaule" 2016-03-11 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]) 
);