1. Home
  2. Datasets
  3. 001 -- Palvelualojen ...
To download the data set, please sign up or log in

001 -- Palvelualojen liikevaihtokuvaaja 2010=100 (TOL 2008)

001 -- Palvelualojen liikevaihtokuvaaja 2010=100 (TOL 2008)

Tables

Column Descriptions

Dim ajanjakso, Statfinpas plv pxt 001 201712 fi px, Full history

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

Dim vuosi, Statfinpas plv pxt 001 201712 fi px, Full history

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

Fact, Statfinpas plv pxt 001 201712 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso int Datasource did not contain a description for Ajanjakso. Column ajanjakso has 74290 rows, out of which 27370 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2386 and maximum value is 2423.
sarja string Datasource did not contain a description for Sarja. Column sarja has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
palvelualojen_liikevaihtokuvaaja_2010100_tol_2008 int Datasource did not contain a description for Palvelualojen_liikevaihtokuvaaja_2010100_TOL_2008. Column palvelualojen_liikevaihtokuvaaja_2010100_tol_2008 has 74290 rows, out of which 646 are empty, making the null percent 0.87. Minimum value is -32 and maximum value is 331.

Dim sarja, Statfinpas plv pxt 001 201712 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperäinen sarja and maximum string is Trendisarja.

Dim toimiala, Statfinpas plv pxt 001 201712 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2386 and maximum value is 2423.
label string The label for the dimension value. Column label has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 49 Maa- ja rautatieliiken... and first 25 characters of maximum string: 96 Muut henkilökohtaiset ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim ajanjakso, Statfinpas plv pxt 001 201712 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 19 rows, out of which 7 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. puolivuosi and maximum string is Vuosi.

Dim vuosi, Statfinpas plv pxt 001 201712 fi px, Latest

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

Fact, Statfinpas plv pxt 001 201712 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso int Datasource did not contain a description for Ajanjakso. Column ajanjakso has 74290 rows, out of which 27370 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2386 and maximum value is 2423.
sarja string Datasource did not contain a description for Sarja. Column sarja has 74290 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
palvelualojen_liikevaihtokuvaaja_2010100_tol_2008 int Datasource did not contain a description for Palvelualojen_liikevaihtokuvaaja_2010100_TOL_2008. Column palvelualojen_liikevaihtokuvaaja_2010100_tol_2008 has 74290 rows, out of which 646 are empty, making the null percent 0.87. Minimum value is -32 and maximum value is 331.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Statfinpas plv pxt 001 201712 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2386 and maximum value is 2423.
label string The label for the dimension value. Column label has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 49 Maa- ja rautatieliiken... and first 25 characters of maximum string: 96 Muut henkilökohtaiset ...

Dim sarja, Statfinpas plv pxt 001 201712 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperäinen sarja and maximum string is Trendisarja.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated June 13, 2019
Created June 12, 2019