About database

Statistical database

Statistical database presents official statistics, produced according to the statistical programme confirmed by the Government of the Republic. The statistical database is meant for all official statistics published by Statistics Estonia.

More detailed information than available in the statistical database can be ordered under the following link: Requests and orders for information.

For further information tel + 372 625 9300 or by e-mail stat@stat.ee.

Updating

New data are continuously added to the public database. Statistics Estonia informs the users about the new statistics being released in the public database in the Release calendar. Updating of the public database is made public at 8.00 a.m. on the day announced in advance. Tables are provided by date of update.

Structure of database

Statistical database is divided into four main areas — economy, environment, population and social statistics. The data on Population and Housing Census and Agricultural Census are presented separately. The statistical areas are divided into sub-areas. All the areas and sub-areas are presented in alphabetical order.

In the database the data are presented in statistical tables. A database table bears a unique code. The list of tables for the sub-area is presented in alphabetical order of codes of tables. Under the title of the table the list of table variables and some values of variables are presented. In the brackets the number of values of the variable is presented. In case no new data will be added to the table, at the end of the title of the table the beginning year and the last year for the data in the table are presented in brackets.

Tables presenting regional statistics are marked with the contour of Estonian map before the table title in the list of tables.

The structure of the database table is described under the headings Statistical indicator and Database table.

Search of data

The database allows you to search for a table via hierarchical structure of subject areas or search for a text (Search of database). The relevant text or code of the table should be entered in the search window on the opening page of database. To make search faster you can select the subject area.

Statistical indicator

Statistical indicator is a data element that represents statistical data for a specified time, place, and other characteristics.

Statistical indicator characterises a class of statistical objects called statistical units. Statistical unit can be described by various statistical characteristics called statistical variables. There are quantifying variables (e.g. total profit and investments of enterprise, income of household) and classifying variables (e.g. economic activity of enterprise, type of household, age and sex of person) describing statistical unit. The value domain of classifying variable is determined by classification or code list. The content of the statistical indicator is determined by quantifying variable, classifying variable concretizes it.

Database table

Traditionally statistical indicators are presented using statistical table. Database table is a multidimensional structure. Every dimension of a structure determines one table variable, usually classifying variable. In case of more than one time period also time variable is required.

Examples

All data elements presented in this structure can be described as Population (count), 1 January by sex, age and year. The values of variable sex are males and females, males, females. The values of variable age are 0, 1, 2, 3. The values of time variable year are 2005, 2006.

Every combination of values of table variables determines one data cell in the table.

In case there is more than one quantifying variable presented in the table, one dimension (table variable) determines quantifying variables. In our tables this table variable is named Indicator to refer to quantifying variables.

In the next table two quantifying variables are presented — Population, 1 January and Mean annual population. Both quantifying variables are presented by classifying variables age and sex. In this case one table variable called Indicator has been added to determine quantifying variables.

All statistical indicators (data elements) in this table can be described as
Population, 1 January by age and sex,
Mean annual population by age and sex.
Reference period is year.

In case there are indicators with different measurement units in the table, the unit follows the label of quantifying variable. In case there is one measurement unit for the whole table, the unit is presented under the table. Measurement unit can also follow the label of value of classifying variable.

Quite large tables are stored in the database. Quantifying variables expressed by the same classifying variables are presented in one table. The user has to select only data that are needed.

Selection

Clicking on the title of table in the list of tables a window for selection values of table variables for your table appears. For the table variables marked with rhomb at least one value has to be selected. Other table variables can be eliminated.

Presentation and downloading

The selected table can be presented on screen and/or downloaded in different formats. To save and reuse queries the user has to register.

When presenting the table with three or more variables in the rows on the screen, layout 2 is more readable. When using selections above the table on the screen, you can download the table in different formats (Excel, PC-Axis, CSV, XML, etc.), to use pivot functions, to make calculations with the data, etc. and to read information. Data can be presented as diagrams and using Google Maps and Google Earth. For using Google Earth you have to install it in your computer.

To use PC-Axis format you have to install PC–Axis. The user can create his own database and operate with the data in the tables using the software PC-Axis. For total download of large tables you should use PC-Axis format, using appropriate check box for total download.

In case of total download (using check box) the title of the table remains the same as in the list of tables. In case selecting values of variables (also all values of all variables) a new title of the table is generated automatically. For selected table the labels of the variables, used in the table, are presented in the title after by in the order corresponding to the variables order in rows and columns.

Two or four dots before the label of value of variable are used to indicate the level of hierarchy. “..” means that we have to deal with the sub-value of the previous value in the meaning of "of which" (for example Harju county, ..Tallinn; public sector, ..state, ..local government).

In data cells “0” means that magnitude is less than half of the unit employed and also magnitude nil. For data not available and unreliable data due to small size of the sample two dots (..) are used. For category not applicable one dot (.) is used.

Due to rounding, the total sums in tables are not always equal with the total.

Metadata (data about data)

In addition to metadata presented in the statistical table you can find metadata under the headings Information, Footnotes and Definitions and Methodology. Under the heading Information date of update and copyright are presented. In case one measurement unit for the whole table, also unit is presented. Under the heading Footnotes important explanations allowing correct understanding of the table are presented. Under the heading Definitions and Methodology terms and definitions, description of methodology used, information about classifications used, references to other sources and contacts are presented to contribute for better understanding of the data in the table.

When using or quoting the data or the database, please indicate the source.

Updated: 01.10.2010