1. Home
  2. Datasets
  3. 011 -- Average prices of ...
To download the data set, please sign up or log in

011 -- Average prices of commodities

011 -- Average prices of commodities

Tables

Column Descriptions

Fact, Statfinpas khi pxt 011 201812 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.
commodity int Datasource did not contain a description for Commodity. Column commodity has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 1200600.
information string Datasource did not contain a description for Information. Column information has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Keskihinta.
month string Datasource did not contain a description for Month. Column month has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M01-M12.
average_prices_of_commodities_2002_2018 int Datasource did not contain a description for Average_prices_of_commodities_2002_2018. Column average_prices_of_commodities_2002_2018 has 44642 rows, out of which 11990 are empty, making the null percent 26.86. Minimum value is 0 and maximum value is 2486.

Fact, Statfinpas khi pxt 011 201812 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.
commodity int Datasource did not contain a description for Commodity. Column commodity has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 1200600.
information string Datasource did not contain a description for Information. Column information has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Keskihinta.
month string Datasource did not contain a description for Month. Column month has 44642 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M01-M12.
average_prices_of_commodities_2002_2018 int Datasource did not contain a description for Average_prices_of_commodities_2002_2018. Column average_prices_of_commodities_2002_2018 has 44642 rows, out of which 11990 are empty, making the null percent 26.86. Minimum value is 0 and maximum value is 2486.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas khi pxt 011 201812 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.
label int The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.

Dim year, Statfinpas khi pxt 011 201812 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.
label int The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim commodity, Statfinpas khi pxt 011 201812 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 1200600.
label string The label for the dimension value. Column label has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ALCOHOLIC BEVERAGES, TOBA... and first 25 characters of maximum string: Train journey Helsinki-Ta...

Dim commodity, Statfinpas khi pxt 011 201812 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 1200600.
label string The label for the dimension value. Column label has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ALCOHOLIC BEVERAGES, TOBA... and first 25 characters of maximum string: Train journey Helsinki-Ta...
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfinpas khi pxt 011 201812 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Keskihinta.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Average price.
orig_extractdate string The date when the data was originally fetched from the source.

Dim month, Statfinpas khi pxt 011 201812 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M01-M12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Annual average and maximum string is December.

Dim month, Statfinpas khi pxt 011 201812 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M01-M12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Annual average and maximum string is December.
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfinpas khi pxt 011 201812 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Keskihinta.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Average price.

Additional Info

Last Updated August 2, 2019
Created July 29, 2019