How to work with reports in Kelasto

What is the Kelasto statistical database?

Kelasto is a statistical database that contains key statistical information about the social security schemes administered by Kela, the Social Insurance Institution of Finland. Kelasto provides access to dynamic reports containing statistical data compiled by Kela, which users can use to generate their own reports with whatever criteria they wish. Kelasto is intended for everyone interested in the statistical data compiled by Kela.

What kind of information is included?

Kelasto primarily includes information about recipients of Kela benefits, total benefit expenditures, and averages rates of benefit. Additionally, it contains data on claims for benefit received as well as claims determinations and turnaround times. Besides the national level, data is also available at various regional levels, including municipalities.

Reports are grouped in the table of contents according to topic and benefit. The following topics are included: Conscripts, Housing benefits, Pensioners, Rehabilitation, Families with children, Sickness and incapacity, Social assistance, Students, Unemployed persons and Disability benefits.

Selecting search criteria from a list

Specify the criteria you want to create a report

You can select criteria from a list to create the type of report you want.

Select several rows at a time by holding down the Ctrl key and clicking on the rows you want to include. Alternatively, you can drag across several rows to select them. By clicking on ‘All' in the top right-hand corner of the selection list you can select or de-select all of the rows.

To change the height or width of the selection list, click and drag the triangle in the bottom right-hand corner of the list.

To go back to the default selection, click the link titled ‘Default selections'.

To create a report, click on " Create report >> " to the bottom right.

Location of variables and variable settings

You can change the location of the variables shown in the report (differentiators, rows and columns). The report data (i.e., the content of the first menu) are always presented in the form of a column variable.

First, select a variable under ‘Location of variables'. You can then move it up or down on the list or remove it, in which case the variable is transferred to the first list, where it can be selected as a differentiator, row or column variable.

Variables removed from the report are not shown on the report. However, if you select a variable that is on the list of removed variables, the content of the report is modified to reflect your selection.

You can also make the following selections under ‘Regional settings':

  • Reference year for the regional classification. Here you can specify for instance the year that the report should refer to when presenting data arranged regionally.
  • Whether numerical codes should be displayed in the regional selection (default is off).

You can also change the following settings:

  • Chronological order of the data: descending (default) or ascending. Descending means that the most recent data are shown first (for example, newest months first)
  • Format: whether the report is displayed on the screen or presented as a PDF or Excel file.
  • PDF page orientation: vertical or horizontal

Saving your report

You can save your report as a PDF or Excel file by clicking on the icons and links in the Actions menu.

Excel files should first be saved to your computer's hard disk and then opened in Excel. If you open it in Excel right away, the file will be opened inside your browser, and you will not be able to access all Excel functions.

Link to the report

You can create a link to a generated report

Once you have made the selections you want and created a report, you can create a link to the report , which allows you open the report you want without going through the creation process again. The link includes all of the selections and changes to the settings you have made.

The data included in the linked report are updated automatically, which means for example that data for the most recent month are added to the report automatically.

You can bookmark the link or forward it as an e-mail message.

Additional information

By clicking on Details about the report, you can access a more detailed description of a selected report as well as look up contact details in case you need further information.

Updating of reports

Monthly data is updated on the 21st of each month (the data for December is e.g. updated on 21 January). Annual data is updated in the month specified in the section 'Updating frequency' on the page 'Details about the report'. Most of the annual data is updated in January.

Data access

Statistics Database Kelasto is licensed under a Creative Commons Attribution 4.0 International License (CC BY 4.0). Source: The Social Insurance Institution of Finland, Kela, must be mentioned.

Privacy protection

When the number of recipients in a municipality is fewer than four, it is displayed as two dots to prevent the indirect identification of individuals.

Reports requiring a log-in

Certain Kelasto reports intended for a limited range of users require users to log in with their personal online bank user ID and password. These include the drug prescription reports, whose intended target group are doctors.

 

Last modified 22/02/2017
Updated 22/10/2012