CYSTAT-DB User Manual

The online database of Statistical Service of Cyprus (CYSTAT-DB) gives the user the ability to produce the desired table, to format the presentation, to edit and make calculations and to save it in any form available. Also, the request can be saved and used at a later stage to get the updated table with the latest available statistics.

Access CYSTAT-DB from the home page of CYSTAT’s Portal (Statistics > Related Links > CYSTAT-DB).

The available tables are included in a tree diagram with the statistical subthemes on the landing page of CYSTAT-DB or search the database through "Search in CYSTAT-DB":

CYSTAT-DB contains tables allocated in statistical subthemes. In the tree view, you can open (by clicking on the folder icon) individual subthemes (e.g. Labour Market) and proceed to the next level that contains themes of "Labour Market" and with subsequent click at the folder level of the theme that might interest you (e.g. Registered Unemployment) you reach the list of folders (Registered Unemployed, Placements of Registered Unemployed, Archive) that contains the available tables, as can be seen at the screenshot below:

The tree view displays tables that are updated regularly. Tables that are no longer being updated are archived. Archived tables can be found within each subtheme under Archive. By clicking on the Archive, a list of tables from that subtheme that are for various reasons no longer being updated regularly with new time series will be displayed.

To select the desired table, click on its title. A tool for working with tables, PX-Web, will open in a new browser window:

Can I choose the data for the desired table?

Yes, the PX-Web tool gives the opportunity to the user to select the categories for each variable (sex, year, economic activity, etc.) that you want to display on the table.

Clicking on the table title in the table list will open the selection fields for each variable (sex, year, economic activity, etc.) in the PX-Web tool and you can select the desired category (one or more categories) in the table. For variables marked with star (*) you have to select at least one value.

Useful tips:

To select more than one categories, hold Ctrl and left click the desired categories.
To select consecutive, hold Shift and left click the first and last desired categories.
To select all values at the same time, click the icon with the checkmark (v).
To clear the selection, click the empty square icon (-).
The categories can be sorted alphabetically or arithmetically (e.g. year) using the icons with arrows (up and down).
In order to search for a category within a variable you can use the option of "Search" below the box with the categories. The search will present all the categories that contain the word or phrase you enter at the search box.

After selecting the desired categories you should click on the Continue button. If the option in the list is "Show Table", the table will be displayed with the selected categories and variables.

The data presented in the table can be also shown on charts, sorted and/or exported in various file formats, as it can be seen on the image above.

The options "Show Table" or "Table - Layout 2", lead to the production of the table and subsequently there are different options under "Edit and Calculate" for restructure like pivot table, change value order, change decimals, change texts etc. and for calculations like sum, subtract, division, multiplication, percentage, as it can be seen on the image below:

Under "Show table" there different option for presentation like table or chart:

How to save the table?

The table can be saved as any form (e.g. excel, csv, json) that you prefer using the option "Save table as":

Using "Table settings" you can hide the rows with "0" values or the rows with statistical signs that are replacing the statistical data:

You can also save the selected variables as a query for further use, or save a link to a saved query. An advantage of doing this is that next time you search for the desired data you will get them with the updated time series onscreen or export them into various file formats with only one click.

You can save a query by first selecting the appropriate values, then displaying the table on-screen and clicking on the "Save Query" option where you then select the appropriate settings.

Can I find methodological information for the table or the contact person's details?

Yes, you can find methodological information and contact details for the person(s) responsible for the statistical data included in the table at the bottom of the table or simply by selecting the option "About Table".

What is the meaning of the symbols?

SYMBOL	MEANING
u	Data with low reliability
c	Confidential data
…	Data not available
N.A.	Not applicable
r	Revised data
p	Provisional/ Preliminary data
b	Break in time series

How to use APIs?

You can use Application Programming Interface (API), which enables you to automate the reading and use of the data (machine readable data). You can access the API information for a single table by selecting the values you want in the table data selection fields and clicking "Continue". You will be taken to a new page. On that page click the "About table" tab. You will then notice the "API query for this table" link.

By clicking the link, you will get information about the URL address and the JSON query that you need to use to get the same data layout via the API as shown in the table. According to the instructions provided, you must POST the JSON query to the URL address provided, in order to access the defined table from your application.

For more information follow the link: https://www.scb.se/en/services/open-data-api/api-for-the-statistical-database/.

Do you still need help?

If you cannot find the information you are looking for or encounter difficulties in producing the table you are interested in, do not hesitate to contact us.

Related files:

CYSTAT-DB User Manual

Cookie Use