entity_statement

38 rows where "foundingdate" is on date 2013-03-22 and iscomponent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate

_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
101149 146a6e8f-8392-47d9-a2ad-96769b3e42be entityStatement 2018-04-10 false registeredEntity SIA "MP BŪVSERVISS" 2013-03-22 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    
101150 bb76a07a-2609-4d6a-98cf-7d7e75e9400e entityStatement 2018-10-10 false registeredEntity SIA "DARETTA" 2013-03-22 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    
101151 25e51091-e3a4-4622-9df4-bca9a2714dd3 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "ZK Timber" 2013-03-22 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    
103985 955bd27a-d281-439a-9fd7-3697e3a34ce5 entityStatement 2019-07-25 false registeredEntity VIĻĀNU NOVADA VIĻĀNU PAGASTA ZEMNIEKU SAIMNIECĪBA "JAKUBKI" 2013-03-22 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    
105403 d8caf95a-694d-4fa9-89cf-443b12b11c5e entityStatement 2019-07-16 false registeredEntity Sabiedrība ar ierobežotu atbildību "ELIT HAUS" 2013-03-22 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    
110338 bebb9028-4e8d-4dbc-b6d3-f3004d136a96 entityStatement 2019-07-16 false registeredEntity SIA "ASTRON" 2013-03-22 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    
53407 9c6d7d2e-ec00-40ae-aa2a-f0b4e06da414 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "VIEDAM" 2013-03-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    
53408 0d8256df-08ff-43a5-b020-410e11022b92 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Alirana" 2013-03-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    
53409 9fec2600-4753-47df-bcb1-5a7925bca9bb entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Natali un kompanija" 2013-03-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    
53410 88ef3c2a-e5b9-44c6-bf7f-c27fca70de97 entityStatement 2019-07-13 false registeredEntity SIA "VILLA MARIA" 2013-03-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    
53411 914e5655-59b6-4348-94ca-718ce8522d15 entityStatement 2019-07-15 false registeredEntity SIA "AGIROOF" 2013-03-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    
53412 d1c5bae3-3cec-40ad-9148-5093e006e256 entityStatement 2019-07-15 false registeredEntity SIA "Prauto" 2013-03-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    
53413 9eaf08b6-df27-46a8-9265-e87981e82143 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību MOBIUS BO 2013-03-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    
53414 49c1c181-f357-4393-ab29-356f099585a0 entityStatement 2018-06-29 false registeredEntity SIA "LatInvest Group" 2013-03-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    
53415 e2b64c1f-fdcc-46db-b1ba-e050581ee90b entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "A & A Style" 2013-03-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    
53416 a2adc119-641b-4861-9152-ce2ba02f1fb2 entityStatement 2019-07-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "ADR" 2013-03-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    
53417 03ae8114-c5fc-4ebf-bd73-39269a4e913c entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "INDESIGNER" 2013-03-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    
53418 06ab7ea7-d02e-4b67-a50f-cd110c1d0e02 entityStatement 2019-07-15 false registeredEntity SIA "Freedom Solutions" 2013-03-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    
53419 c2dc5ce8-9cbd-4159-b479-1453a2668898 entityStatement 2020-07-21 false registeredEntity Sabiedrība ar ierobežotu atbildību "PAMB" 2013-03-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    
53420 98de817d-0d56-4758-bf2f-5e2692244dc9 entityStatement 2018-03-13 false registeredEntity SIA "Finance Invest" 2013-03-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    
53421 392f383e-5d07-4dcc-9149-4a846fb1ce6a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Margaret.Ko" 2013-03-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    
53422 5352b2e1-ebdf-4b31-95f8-1c8e17942573 entityStatement 2018-12-05 false registeredEntity SIA "MAXLOG" 2013-03-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    
53423 4abe4fd7-838b-4aec-9891-f66370ab20aa entityStatement 2019-07-15 false registeredEntity SIA "Ilreto" 2013-03-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    
53424 6d537f16-7b0b-4f76-93ef-e68524a412a4 entityStatement 2019-07-15 false registeredEntity SIA "I & M co." 2013-03-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    
53425 2e97240c-a144-4481-9b8c-46eb4e916633 entityStatement 2019-08-27 false registeredEntity Sabiedrība ar ierobežotu atbildību "Multi nams" 2013-03-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    
53426 41d17e62-00b0-4708-8f1e-a6fbcf699769 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "FAM consulting" 2013-03-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    
53427 2eaef657-4fcb-4e50-9058-4dfe354e58b4 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "CUBE Mobile" 2013-03-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    
53428 18297961-9f4f-4d6f-a0b2-137a5c3bd9ed entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Energotronix" 2013-03-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    
53429 af62986b-08bb-4848-8af1-c1033f21c44b entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "MOTTRA CAVIAR" 2013-03-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    
53430 be6a0772-ab5f-4c45-bf98-f7fc45f4b231 entityStatement 2018-03-02 false registeredEntity SIA "DGI LAT" 2013-03-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    
53431 9a2af20e-a086-4170-b383-dcc1ac530d67 entityStatement 2019-07-15 false registeredEntity SIA "KARGO PLUS" 2013-03-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    
53432 f7b6f6bb-bb59-49ee-8410-83a57846b3b5 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "BLC Partners" 2013-03-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    
53433 d0cd1254-d318-490b-a5b5-0eef4bf9746d entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "KABALA" 2013-03-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    
53434 e86e2d0e-d276-40fa-8237-addc0f806c9a entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Tomrens" 2013-03-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    
53435 037f4d4a-3845-4117-bea5-e90bb24161e8 entityStatement 2019-07-15 false registeredEntity SIA GRAY RAINBOW 2013-03-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    
91330 c5d3628d-7707-4a6a-aa37-60b9d4250b78 entityStatement 2019-07-14 false registeredEntity Sabiedrība ar ierobežotu atbildību "Rojas laivu darbnīca" 2013-03-22 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    
95989 ce044262-3140-4681-97f7-6b228b434488 entityStatement 2019-07-15 false registeredEntity Sabiedrība ar ierobežotu atbildību "Silene GeoSystems" 2013-03-22 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    
95990 43bdf014-b3d4-4e07-b34a-92473345666f entityStatement 2020-10-13 false registeredEntity Sabiedrība ar ierobežotu atbildību "Minipalīgs" 2013-03-22 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]) 
);