entity_statement

34 rows where publicationdetails_publicationdate = "2021-01-18", "publicationdetails_publicationdate" is on date 2021-01-18 and "statementdate" is on date 2019-06-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unspecifiedentitydetails_description, 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
114112 677b2d32-f451-44cb-a090-f771c04845ea entityStatement 2019-06-04 true registeredEntity Sabiedrība ar ierobežotu atbildību "PATA"   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    
114113 810d0da8-3a4b-49f3-b03a-e8c203c34548 entityStatement 2019-06-04 true registeredEntity Sabiedrība ar ierobežotu atbildību "SALDUS MEŽRŪPNIECĪBAS UZŅĒMUMS"   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    
12295 f5ff23ba-8c23-4420-99b4-448312c0c125 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "SKAI PLUSS" 2001-08-13 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    
13403 94aa3250-632d-40ea-bda3-1f4a98a175f2 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "CVH" 2002-07-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    
16947 8a8a7cb9-1f25-4e50-bc9c-4cfa787d36b3 entityStatement 2019-06-04 false registeredEntity "Schillhorn" SIA 2004-11-12 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    
20525 ff33cdc0-a1f3-4fea-ad07-d2111540ff28 entityStatement 2019-06-04 false registeredEntity SIA Rīgas 90 2006-05-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    
21320 7e5ba7ce-d0ff-4bc0-82ad-81b40a475004 entityStatement 2019-06-04 false registeredEntity SIA "AMIT Baltic" 2006-08-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    
22671 cef6c94a-e64f-4267-aff0-2bd69c7a28e5 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "ARTindustrija" 2007-01-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    
29723 29215c84-c443-4141-9068-526b9a7668d8 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "TANTRA-L" 1991-02-28 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    
31933 081ec9e8-02be-4aa8-b6e6-ec8b442a14a8 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "IGALANS" 1995-01-13 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    
32933 17b84619-6aa0-4c69-a9ef-94b51bdb187a entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Sky Rent" 2008-07-28 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    
37133 5e8558fc-b2c3-4e0d-b28f-229c6636fac9 entityStatement 2019-06-04 false registeredEntity SIA "GD Enterprise" 2010-05-18 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    
37363 d98bd0cd-e05c-466b-87a2-7681db870f7a entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Viland AV" 2010-06-08 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    
3738 fc697a27-2d01-4c68-ac91-bfd65169718c entityStatement 2019-06-04 false registeredEntity Akciju sabiedrība "PATA Saldus" 1991-08-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    
3739 17f4856f-ee2f-41b9-9d30-1809b3db32d6 entityStatement 2019-06-04 false registeredEntity Unknown Publicly Listed Company       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 interested-party-exempt-from-disclosure This is a company whose shares are admitted to the regulated market. Shareholders of this company are not disclosable as beneficial owners
37897 221586b2-ee33-4790-9123-b4e6792e556f entityStatement 2019-06-04 false registeredEntity SIA "BALTIC ROYAL WOOD" 2010-08-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    
3976 0ec84077-359d-469f-a285-95ff116df044 entityStatement 2019-06-04 false registeredEntity Akciju sabiedrība "KURZEMES ATSLĒGA 1" 1991-11-29 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    
43245 19672a47-e223-4eda-988a-212c45470329 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "BaltService" 2011-06-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    
45087 d254e1b5-e1d0-424f-9de4-a886249f9946 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "KM Research" 2011-10-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    
45960 ae8446b3-0b8e-486f-9be1-20145143326c entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "ESFIRA" 2011-12-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    
46917 18db980e-6cc2-4b04-911e-953c523b506d entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "workshop Nr.1" 2012-02-15 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    
49454 e9df0061-c76e-4828-b6f4-bfdc3570c878 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Liberto" 2012-07-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    
51508 6f7923b5-b65b-4d1c-9c20-ccca2d9b547a entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "GJK Inkasso" 2012-11-29 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    
57900 bbf7694f-16bf-4d9c-9773-b9dac299f699 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "MERID" 2013-12-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    
6149 5691dae7-6140-4bdd-9308-1114c1dfca48 entityStatement 2019-06-04 false registeredEntity "JOGITA" SIA 1995-03-31 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    
63538 ab331c50-a9f3-4c3c-b9af-06c102b86870 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "GP6" 2014-11-28 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    
64818 49b0428b-563b-40ab-bd32-ef47efb2d1d9 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "SODBI" 2015-02-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    
65306 351038d2-e733-4f96-9abb-eb01e4c43811 entityStatement 2019-06-04 false registeredEntity SIA "Stila māja" 2015-03-18 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    
66706 249ce739-47f0-4bad-87dd-3ebd337cf713 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Cold Wind" 2015-06-08 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    
68722 ac852670-22d7-460e-8981-3e975506be2e entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Scandic service partner" 2015-10-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    
70962 371385d9-653a-4a98-89db-f2e7f6ea6e63 entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "Riga Gaming Company" 2016-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    
71102 fa300898-39c3-4199-a4bc-d014aa15b32e entityStatement 2019-06-04 false registeredEntity Sabiedrība ar ierobežotu atbildību "TechTrans" 2016-03-18 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    
71391 de1d69d3-7149-4f4e-acda-9b925f0db029 entityStatement 2019-06-04 false registeredEntity SIA "Investment Estates" 2016-04-07 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    
73494 a6ca03c7-49f3-416c-9195-f257197df6e0 entityStatement 2019-06-04 false registeredEntity SIA "MFKS" 2016-08-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    

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