Help using the SiStat Database
How to search for data in the SiStat Database?
You can access the data in the SiStat Database in two ways: with the search engine or with a tree view of statistical themes.
You use the search engine by entering the desired string in the search box and clicking the search button.
You can use the search engine to search for a specific text and/or codes (e.g. 0701011S). Specifically, the search engine can search by table titles, category names, and codes. The search functions are based on the Lucene.Net script.
The search engine displays search results as table titles equipped with codes whose content corresponds to the search string, e.g. "population" or 0701011S. Select a table from the list of results by clicking on the table title.
You can also use different Boolean logical operators, such as AND, OR, and NOT, which enable a more detailed search. The logical operators must be written in uppercase letters.You can also use search operators (e.g., quotation marks and asterisk).
When writing Ljubljana AND Maribor AND Tržič, the search engine will display only links to tables containing the words Ljubljana and Maribor and Tržič in the table title or the table content. The search engine uses the AND operator by default, which means that the search string can be written as Ljubljana Maribor Tržič.
The OR operator specifies the “or” relationship between the search words. When writing Tržič OR men, the search engine will display only links to tables containing Tržič or men (or both) in the table title or the table content. The OR operator is useful for expanding the number of results.
NOT or AND NOT
The search operator NOT specifies the “and not” relationship between search words. When writing Gross NOT net, the search engine will display only links to tables containing the word gross in the table title or the table content, but not the word net. You can also use AND NOT (gross AND NOT net) or a minus sign (gross −net).
You can use multiple logical operators at the same time:
When writing (waste OR potatoes) AND Kranj, the search engine will display only links to tables containing either the word waste or the word potato and the word Kranj in the title or content. When combining two or more logical operators, you have to put the keywords being grouped inside the parentheses. So they will be dealt with first.
(...NOT...) AND (...OR...)
When writing (Ljubljana NOT Maribor) AND (men OR women), the search engine will display only links to tables containing the word Ljubljana, but not the word Maribor, and the word men or the word women (or both) in the table title or the table content. When combining two or more logical operators, you have to put the keywords being grouped inside the parentheses. So they will be dealt with first.
The search engine also enables using search operators:
"..." (quotation marks)
"Gross domestic product, Slovenia, annually”: the use of quotation marks enables you to search for a specific search string. The search engine will display only links to tables containing the exact order of words in the table title or the table content. Other search operators will not work within the quotation marks.
Averag*: asterisk extends the search to all words that begin with the same sequence of letters. This will allow you to search for multiple forms of the same word at the same time. For example, average, averages, averaging.
The SiStat Database is divided into 21 statistical themes. On the landing page 10 most popular and searched tables are displayed in the Highlighted category, and 10 recently published in the Last Updated category.
By clicking on an individual statistical theme in the navigation (e.g. Industry), a theme page opens that consists of two categories; Highlighted and Review of data by fields. Five tables from the selected statistical theme are displayed in the first category and a tree view with a more detailed content division of the field in the second one.
In the tree view, you can open (by clicking on the plus icon) and close (by clicking on the minus icon) individual themes, or you can open the entire tree at once (by clicking on the Expand all icon).
When you expand the tree, a list of theme titles and table titles is displayed. The table titles are equipped with a table code, e.g. 0701011S, and the icon. You can click on the icon if you would like to see more information about the table (date of last release, link to methodological explanations, data revision status).
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 (sub)theme under Archive. By clicking on the Archive, a list of tables from that (sub)theme 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.
Hint: You can also edit the table on your computer (locally). In this case, click on the i icon and then click on the PX file link in the displayed information window. This will save the table in px format to your computer, where you can view or edit it with the PX-Win tool. This tool is for viewing files in PX format.
How to choose data to display in the table?
In the PX-Web tool, you can select the categories (Kranj, men, 2019) for each variable (municipalities, gender, year, etc.) that you want to display in the table.
Clicking on the table title in the table list will open the selection fields for each variable (municipalities, gender, year, etc.) in the PX-Web web tool and you can select the desired category (one or more categories) in the table.
Example:: If you are interested in how many residents were employed in the municipality of Šenčur in 2015, you have to select values from the following variables: municipality, year, and persons in employment, within the selected table, Persons in employment by municipalities of employment, Slovenia, annually. In this case, you have to select: Šenčur, 2015, and Working population - TOTAL.
After selecting the values, you have to click the Continue button. If the dropdown list shows the option Table - Layout 2, a table will be generated on-screen with the variables and values that you selected in the previous step.
The presentation of data on-screen is limited to 1,000 rows and 150 columns. For a more extensive display of data, you need to export them to your computer in various available formats (Excel, CSV, PX).
For variables marked with an asterisk (*), at least one value has to be selected (e.g. for the variable year you select 2015).
Within each variable, you can select one, several, or all values (e.g. all years).
To select several values, hold CTRL, and left-click the desired values.
To select a group of consecutive values, hold SHIFT, and left-click the first value and the last value.
To select all values at the same time, click the icon with the checkmark.
To clear the selection, click the empty square icon.
Values can be sorted alphabetically or by number (e.g. year) by clicking one of the arrow icons (up or down).
Value(s) can also be selected by using the search below the list of values. The search will show all values containing the entered string of characters.
How to present, edit, and calculate the data in the table?
The data presented in the table can be edited and calculated, shown on charts, sorted and/or exported in various file formats (Excel, CSV, JSON, etc.).
You can hide the rows with "0" values or the rows with statistical signs that are replacing the statistical data.
Hint: The appearance of the table can be changed as you wish, pivoted with the Edit, Calculate, and Pivot manual options. The data in the table can be calculated with basic mathematical functions (sum, subtract, percent, etc.).
How to save data?
Data can be exported into various file formats (Excel, CVS, JSON, etc.).
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 (by clicking on the plus icon), where you then select the appropriate settings.
How to find methodological explanations and information?
More information and notes on the variables in the table can be seen in the About table tab. Methodological explanations on the data in the table are available under Footnotes (by clicking on the plus icon). Methodological explanations can also be found on the landing page and the theme pages. You can access them by clicking on the icon next to the table title.
What is the meaning of various statistical signs?
|-||no occurrence of event|
|M||less reliable estimate – use with caution|
|N||too unreliable estimate to be published|
How to use APIs?
You can also access the data in the SiStat Database using the API, which enables you to automate the reading and use of the 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.
More about the API can be found here.