Query report conditions

In the query environment the public can inquire statistics about property transactions.

Type of publication

General statistics

General statistics includes overall information of all real property transactions registered in the transactions database, but it is also possible to select only purchase and sale data.

Select either All transactions or Purchase-Sale:

  • All transactions - all real property transactions (purchase-sale, gift, exchange, other transaction);
  • Purchase-Sale - only purchase and sale data.

These options are available for all publications in the general statistics. By default All transactions is selected.

Price statistics

Price statistics includes only purchase and sale data in order to display information about average transaction prices.

Terms of report

Cut percentage

In price statistics Cut percentage can be selected. The user can define to which extent he wants extremums (transactions with very low and very high prices) to be removed from the sample. Cut percentage can be between 0 and 49%. For each report the cut percentage is calculated on the basis of price per unit area, only for the report Transactions of immovables with buildings, the cut percentage is calculated on the basis of the overall price.

Location options

It is possible to select any location of interest.

Simple location options - queries can be made for one or more locations at a time. User can select from the list one or more counties, municipalities, villages/parts of town. At least county must be selected to generate a report.

Detailed location options – in the advanced search several regions can be searched, the box Detailed search for several regions must be checked.

Options for several locations:

  • select county - county for which the report will be generated;
  • All municipalities - the report will be generated for all municipalities in the selected county;
  • All municipalities except towns - the report will be generated for all municipalities except towns in the selected county;
  • Towns - the report will be generated for all towns in the selected county;
  • Region - the report will be generated for one or more selected regions.

Region options:

  • Estonia;
  • Estonia without Tallinn;
  • Northern Estonia - Harju county including Tallinn;
  • Central Estonia - Järva, Lääne-Viru ja Rapla counties;
  • North-Eastern Estonia - Ida-Viru county;
  • Western Estonia - Hiiu, Lääne, Pärnu ja Saare counties;
  • Southern Estonia- Jõgeva, Tartu, Põlva, Valga, Viljandi ja Võru counties;
  • All counties;
  • All counties (except towns).

Time period options

Any time periods of interest can be selected by last month, current year and last year. It is also possible to select several time periods. Year/quarter should be selected from the list. To obmit quarters, select only years.

Reports

Reports will be displayed in the same browser window. The name of the selected report will be displayed as the title of report. Location and time period will be shown as subtitles. Subtitles include also additional selected options (only purchase-sale in general statistics or cut percentage in price statistics).

Numeric data fields can be sorted by an ascending or descending value.

Button Select fields - it is possible to select/remove fields to be shown in the report. If more than 3 fields are selected, the title of the button will be the number of fields (e.g. 11 selected).

Button Update table - selected fields will be displayed after updating the table.

Button Rotate table - rotates the table, the titles of table columns will be displayed in the first column to the left.

Button Export to Excel - report will be displayed in Excel format.

Definitions of statistical terms

Average (arithmetic mean) - the sum of a list of numbers divided by the number of numbers in the list.

Median - the number separating the higher half of a data set from the lower half. The median of a list of numbers can be found by arranging all the data from the lowest value to the highest value and picking the middle one. If there is an even number of samples, then the median is defined to be the mean of the two middle values.

Standard deviation - is used to quantify the amount of variation or dispersion of a set of data values. A low standard deviation indicates that the data points tend to be very close to the mean of the set, while a high standard deviation indicates that the data points are spread out over a wider range of values.



Last updated: 01.10.2019