entity_statement

32 rows where "foundingdate" is on date 2015-02-19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, statementdate (date), foundingdate (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
101601 f9a2c168-d2a0-4197-b664-491864f9ab3e entityStatement 2019-07-15 false registeredEntity SIA "PŪCE JK" 2015-02-19 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    
27843 1d0649c7-1ed6-4aed-b2fb-b826bc95f8fb entityStatement 2019-01-11 false registeredEntity "Buredo" 2015-02-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    
64768 09cf563e-7433-4fe6-b057-601f154dde6f entityStatement 2019-02-06 false registeredEntity SIA "S-MEN" 2015-02-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    
64769 79887113-55d2-4744-8c29-735614465037 entityStatement 2019-07-15 false registeredEntity SIA "VIKTALLA" 2015-02-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    
64770 3f11b6f1-1076-440e-9d3a-8d76a3c6b7d7 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "AKRA System" 2015-02-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    
64771 8df8c9b3-34a7-4450-af17-8c5442c02313 entityStatement 2018-11-08 false registeredEntity SIA "GameStation" 2015-02-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    
64772 5891cdef-a653-4664-bfea-29b5f094f07d entityStatement 2019-08-28 false registeredEntity SIA "Golden Fleece" 2015-02-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    
64773 26b26c7e-1843-41db-8620-de11deace6f7 entityStatement 2018-05-10 false registeredEntity SIA Koka Paletes Latvija 2015-02-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    
64774 8c1dc014-8c2b-47c6-b677-bba27be1cd46 entityStatement 2019-07-14 false registeredEntity SIA "BIZPAK" 2015-02-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    
64775 4a5f4fcc-2f34-446f-88e3-7a7601c52f77 entityStatement 2019-07-15 false registeredEntity SIA VAVV 2015-02-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    
64776 33258d5a-b409-4843-a631-707c868e1845 entityStatement 2019-03-19 false registeredEntity Sabiedrība ar ierobežotu atbildību "MC Properties" 2015-02-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    
64777 71402ae4-35a4-4694-9b14-cb0afc01d4eb entityStatement 2019-07-15 false registeredEntity SIA "L-Appetito" 2015-02-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    
64778 8c38a573-ecfb-44e6-bee3-2ef076d39191 entityStatement 2018-03-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "Nami un būves" 2015-02-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    
64779 2a4d78cf-79be-43ae-9514-ff30125e88f3 entityStatement 2018-01-11 false registeredEntity SIA "InvestPlus" 2015-02-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    
64780 ef011cad-4b9d-46fa-bd95-92fc5db3fd63 entityStatement 2020-01-30 false registeredEntity Sabiedrība ar ierobežotu atbildību "Oxford Research Baltics" 2015-02-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    
64781 22a8645c-5b8c-418b-bb83-a2cc631b7864 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ANGAR" 2015-02-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    
64782 ca6491b9-9cbe-4b3c-a47f-92ebd1429127 entityStatement 2018-09-06 false registeredEntity SIA "AMMONIT" 2015-02-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    
64783 25a43b2e-8f12-4fd7-9227-2988b17a3c45 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "RANGERS" 2015-02-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    
64784 3314eabb-16d5-4aa2-a14e-376ff7db8bb5 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "OM Grāmatvedība" 2015-02-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    
64785 f9ab443a-867b-410e-9e82-81d82816f11f entityStatement 2019-07-14 false registeredEntity SIA "BSB būve" 2015-02-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    
64786 cea04f64-7f64-4ff2-acf9-cc998ba72088 entityStatement 2019-07-15 false registeredEntity SIA "HEMI" 2015-02-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    
64787 07167248-3c75-4d3c-9c33-b0b88315e3b5 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MS Rent" 2015-02-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    
64788 d93d0718-b401-4a18-ab09-1669b5e0c933 entityStatement 2020-04-08 false registeredEntity SIA "M.H. Consulting" 2015-02-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    
64789 d7d46330-0433-4bc9-bf06-a392952958ce entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Nik expo" 2015-02-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    
64790 277f2922-42f8-455c-811d-46d1fe7de171 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību JSP LATVIA 2015-02-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    
64791 99b751e8-108b-46e6-842e-d9e63a0060d5 entityStatement 2019-11-28 false registeredEntity SIA TMG 2015-02-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    
64792 6b39a985-e1ea-412d-a221-cd9237389c1e entityStatement 2019-07-15 false registeredEntity SIA "LAIKA ELPA" 2015-02-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    
64793 0c2f0bf9-16c7-4ef0-9714-f0b2f696516b entityStatement 2019-12-18 false registeredEntity SIA "Caffedra" 2015-02-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    
64794 cda1da8e-306b-4a2d-9090-eaea8266b873 entityStatement 2018-05-03 false registeredEntity SIA "Escape fransize" 2015-02-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    
64795 07bb8ce2-052e-4ec4-8997-7d9564006d28 entityStatement 2020-02-27 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lux auto noma" 2015-02-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    
91777 a6ca0631-31e3-49ab-8a62-8616261c121b entityStatement 2019-07-15 false registeredEntity SIA "7th sky" 2015-02-19 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    
96390 ec400e0c-439e-4f11-acca-5adb5f948d3a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Apdruka LV" 2015-02-19 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]) 
);