entity_statement

34 rows where iscomponent = "false" and "statementdate" is on date 2020-01-09

✎ View and edit SQL

This data as json, CSV (advanced)

_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
1045 10ce3b18-16e6-4045-aa2b-c2d932cb59cf entityStatement 2020-01-09 false registeredEntity SIA "EGĻU" 1993-11-02 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    
105583 1a319cd2-1981-4f0b-a288-7bff1819cd1b entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "BOLTAIS KRŪGS" 2014-09-09 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    
108248 79ee0a31-6525-4169-96b8-3d37e025b5e9 entityStatement 2020-01-09 false registeredEntity Akciju sabiedrība "EFEKTS AJV" 1994-05-17 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    
14633 afa02cad-51c3-45aa-8c6e-2aa1e50b85a4 entityStatement 2020-01-09 false registeredEntity AS "TRIMEN TRACTORS" 2003-07-21 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    
14855 0c68981a-dcc7-4950-9e6e-434cf421e513 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Konsultāciju Tilts" 2003-09-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    
18477 c7779c4c-1627-45a7-baee-eca4182c4789 entityStatement 2020-01-09 false registeredEntity AS "NIPO" 2005-08-05 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    
20811 ef4d1891-52a2-4cdd-ae0b-26d9e338cd03 entityStatement 2020-01-09 false registeredEntity SIA "Akmenskalnu karjers" 2006-06-19 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    
22921 aa90217c-a6c5-45eb-951c-0fce9b3be115 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltik Ester Group" 2007-02-23 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    
25529 77358f18-26d9-4c61-af32-87e546bece14 entityStatement 2020-01-09 false registeredEntity SIA "KaDiRo" 2007-12-20 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    
26176 c79d3d50-892f-4f8c-9dad-05072eb8417b entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Baltik IT" 2008-03-10 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    
27724 c3d314a4-2d4f-4a15-860f-a98b0adefde4 entityStatement 2020-01-09 false registeredEntity Vangažu pārvaldnieks 2014-02-25 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    
3972 89ab9a1f-6503-4e0d-9008-f916b65678fe entityStatement 2020-01-09 false registeredEntity SIA "RIX MRO" 1991-11-22 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    
43892 d790f16d-0a94-4f47-8cad-49e71c6483bd entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "ITKS" 2011-08-05 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    
50288 ce5d55d5-5d2b-4a6e-8b8c-7a28e4b0fea2 entityStatement 2020-01-09 false registeredEntity LATTROC SIA 2012-09-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    
51290 db97dd1f-a1a2-4f26-8bf8-7873fe5f5d80 entityStatement 2020-01-09 false registeredEntity SIA "BALTIC SERVICE NETWORK" 2012-11-14 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    
5620 daefb13f-98c7-4771-ae94-7f39bec01e29 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "CENTRĀLĀ LABORATORIJA" 1994-08-17 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    
57116 535d5f6e-c73e-47e0-8642-c61046fc96f0 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "DIU MED" 2013-11-04 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    
60382 79a0ab75-9086-4bc5-b51b-e3da689e913f entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "MMF Consult" 2014-05-26 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    
60666 7d754f00-cfab-4b8a-9604-0085e34b609f entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "JUMTS" 2014-06-09 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    
62005 a2f61cfb-c40d-41cc-ad0e-193b945b6327 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lietuvis" 2014-09-01 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    
6222 532a3991-3cb1-40d4-9d79-d267d0c3e582 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "BALTVEN RĪGA" 1995-06-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    
63173 b356cc16-5a05-4440-a27b-0482fee0ea2a entityStatement 2020-01-09 false registeredEntity SIA "Ambisky" 2014-11-06 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    
63346 6310b8d7-370b-42ac-91d9-dbed1ad384fd entityStatement 2020-01-09 false registeredEntity SIA "Franko serviss" 2014-11-19 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    
6628 7810f452-9e93-4a5a-88cf-68d06586a9fd entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Balt Aliance" 1996-01-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    
71607 7f60fc14-eca3-49fb-883e-66840ce74b6d entityStatement 2020-01-09 false registeredEntity SIA "LiLī Bodīte" 2016-04-19 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    
72256 2e56909c-b2a2-474f-9169-0c6726fa1054 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Paysera Latvia" 2016-05-26 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    
77615 77fe7486-8239-4283-9d8a-21787c62eb82 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Vertexo" 2017-06-05 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    
77717 8a9f5040-874b-41af-980e-ab697e356657 entityStatement 2020-01-09 false registeredEntity SIA "Latzemes nekustamie īpašumi" 2017-06-12 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    
81030 1482ff48-6c1c-442e-a4e0-ae3c1ed1f223 entityStatement 2020-01-09 false registeredEntity Amber Hostel SIA 2018-01-18 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    
84248 3be1fd1e-0551-44f7-a67c-6d5cc3e7ddfc entityStatement 2020-01-09 false registeredEntity SIA "Target Audit" 2018-07-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    
85646 5785d6a1-a994-4334-8406-020ac66d94f2 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "TWL Trade" 2018-10-17 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    
9322 fb454435-cfc2-42db-b1f9-b9c6dc446cc5 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Karšu izdevniecība Jāņa sēta" 1999-01-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    
93799 ca9382d1-f0de-421c-b842-d078e08865e7 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "Meristēmas" 1996-09-04 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    
9686 9e23ed6e-532d-4254-8e03-b11b8ca31691 entityStatement 2020-01-09 false registeredEntity Sabiedrība ar ierobežotu atbildību "C.T.CO" 1999-05-14 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]) 
);