entity_statement

27 rows where foundingdate = "2017-10-17" and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publicationdetails_publicationdate, statementdate (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
102258 fcacbb07-4641-4b48-a79f-b0b5ef4dfcd0 entityStatement 2019-07-16 false registeredEntity SIA "SVSA" 2017-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    
111754 82687bf5-6e6c-497e-bf61-a0cb189bbae8 entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "Lex Consult Latvia" 2017-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    
28148 89c51643-aa0b-4e1b-88a6-1c2e4653484e entityStatement 2019-07-27 false registeredEntity Fonds "Dzīves ABC" 2017-10-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    
28149 10b85a53-b5ae-40b9-ad05-7ab6aa1623b7 entityStatement 2019-07-27 false registeredEntity Fonds "Life ABC" 2017-10-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    
28150 338bd2a4-b973-4ee2-acd1-95fe3a549db9 entityStatement 2020-10-19 false registeredEntity "Skolēns LV" 2017-10-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    
79553 19685152-f4d1-4caf-addc-9a93eb351295 entityStatement 2018-02-01 false registeredEntity SIA "SOFI TRANS" 2017-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    
79554 3f3b4d3d-46ab-45cc-b443-c27a18499a4b entityStatement 2019-07-15 false registeredEntity SIA "RRR FOOD" 2017-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    
79555 373be80a-88c6-442d-9789-24ae2e92885c entityStatement 2020-03-13 false registeredEntity SIA "Incompany" 2017-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    
79556 8ebc4154-9b34-4138-bf76-fed5d3073847 entityStatement 2018-09-12 false registeredEntity SIA High Voltage Digital 2017-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    
79557 afb62a05-bcfb-4075-8620-32bcbe535ee2 entityStatement 2019-07-14 false registeredEntity SIA "Eiropas tranzīts loģistika" 2017-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    
79558 1f4fef29-c8af-43ba-8f18-d04018737041 entityStatement 2020-10-26 false registeredEntity SIA PEM properties 2017-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    
79559 b8ffdae3-223e-47b1-a4f1-51ca4614e8f2 entityStatement 2019-03-05 false registeredEntity Sabiedrība ar ierobežotu atbildību "WOOD TOUCH" 2017-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    
79560 8f800df6-e106-4768-8bee-910182e7bc7a entityStatement 2020-04-22 false registeredEntity SIA "R.C.Security" 2017-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    
79561 12bcdc05-3dbb-43c0-85cb-ea992e0abe37 entityStatement 2019-07-15 false registeredEntity SIA "NEXT bouw" 2017-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    
79562 52c0212a-b84a-4c92-973b-9842311232e8 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "ALBERTS 2017" 2017-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    
79563 6c2f8bdc-8f94-42f1-899e-38cc253f2fe3 entityStatement 2019-04-11 false registeredEntity SIA Jūlijas Katkevičas zobārstniecība 2017-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    
79564 7e4ae16b-29f8-4c61-9694-75efdcca3234 entityStatement 2019-07-15 false registeredEntity SIA TIRC 2017-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    
79565 9f6b1771-1e98-4980-8694-33870d316901 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Netteca" 2017-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    
79566 06a3688c-3f2e-4bd8-9747-2250bcdb55e5 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "SA Universal" 2017-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    
79567 2182b3ec-c36a-403f-9572-479ef3e01ef4 entityStatement 2020-12-08 false registeredEntity Bill.me LTD Latvijas filiāle 2017-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    
79568 5873cf1c-a87c-47d2-af8d-a47a38e3306b entityStatement   false registeredEntity SIA "Sociālā sporta aģentūra" 2017-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    
79569 6124cd03-a87f-4c5f-9727-7e1d089a453a entityStatement 2018-06-21 false registeredEntity SIA "DBS Celtniecība" 2017-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    
79570 bd9bae36-6479-4f75-8c18-ad7ef930eadb entityStatement 2019-07-14 false registeredEntity SIA "PARRE ESTATE" 2017-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    
79571 8c523df2-1d26-4261-b6ef-1526c58d0012 entityStatement 2018-03-06 false registeredEntity SIA "Buran Ventures Latvia" 2017-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    
79572 4b3238ed-fe34-470f-882b-a33e2bc205ba entityStatement 2018-06-08 false registeredEntity Sabiedrība ar ierobežotu atbildību "AMZrelated" 2017-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    
79573 2d315cc5-75b6-4581-b879-d88b5a5d1d8f entityStatement 2019-07-15 false registeredEntity SIA Penta Africa Energy development 2017-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    
96975 9863892f-7c0b-4960-b88e-a907d31b936e entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Mērniecības risinājumi Latgale" 2017-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    

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