1. Home
  2. Datasets
  3. 909 -- Kulttuurin tuotos, ...
To download the data set, please sign up or log in

909 -- Kulttuurin tuotos, arvonlisäys ja työlliset maakunnittain ja toimialoittain 2001-2007 (TOL 2002)

909 -- Kulttuurin tuotos, arvonlisäys ja työlliset maakunnittain ja toimialoittain 2001-2007 (TOL 2002)

Tables

Column Descriptions

Dim maakunta, Statfinpas klts pxt 909 200700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 23 rows, out of which 3 are empty, making the null percent 13.04. Minimum value is 1 and maximum value is 21.
label string 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 string is 01a Pääkaupunkiseutu and maximum string is Koko maa.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas klts pxt 909 200700 fi px, Full history

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 53130 rows, out of which 6930 are empty, making the null percent 13.04. Minimum value is 1 and maximum value is 21.
toimialaryhma string Datasource did not contain a description for Toimialaryhma. Column toimialaryhma has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alosuusb1gphkult and maximum string is Alosuuse1kult.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
kulttuurisatelliitin_alueelliset_tiedot_tol_2002 int Datasource did not contain a description for Kulttuurisatelliitin_alueelliset_tiedot_TOL_2002. Column kulttuurisatelliitin_alueelliset_tiedot_tol_2002 has 53130 rows, out of which 2655 are empty, making the null percent 5.00. Minimum value is -16 and maximum value is 5288720.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas klts pxt 909 200700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alosuusb1gphkult and maximum string is Alosuuse1kult.
label string The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alueen osuus kaikista työ... and first 25 characters of maximum string: Osuus alueen kaikista kul...

Fact, Statfinpas klts pxt 909 200700 fi px, Latest

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 53130 rows, out of which 6930 are empty, making the null percent 13.04. Minimum value is 1 and maximum value is 21.
toimialaryhma string Datasource did not contain a description for Toimialaryhma. Column toimialaryhma has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alosuusb1gphkult and maximum string is Alosuuse1kult.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 53130 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
kulttuurisatelliitin_alueelliset_tiedot_tol_2002 int Datasource did not contain a description for Kulttuurisatelliitin_alueelliset_tiedot_TOL_2002. Column kulttuurisatelliitin_alueelliset_tiedot_tol_2002 has 53130 rows, out of which 2655 are empty, making the null percent 5.00. Minimum value is -16 and maximum value is 5288720.

Dim tiedot, Statfinpas klts pxt 909 200700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alosuusb1gphkult and maximum string is Alosuuse1kult.
label string The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alueen osuus kaikista työ... and first 25 characters of maximum string: Osuus alueen kaikista kul...
orig_extractdate string The date when the data was originally fetched from the source.

Dim maakunta, Statfinpas klts pxt 909 200700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 23 rows, out of which 3 are empty, making the null percent 13.04. Minimum value is 1 and maximum value is 21.
label string 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 string is 01a Pääkaupunkiseutu and maximum string is Koko maa.

Dim toimialaryhma, Statfinpas klts pxt 909 200700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...

Dim vuosi, Statfinpas klts pxt 909 200700 fi px, Full history

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

Dim vuosi, Statfinpas klts pxt 909 200700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
label int The label for the dimension value. Column label has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 2001 and maximum value is 2006.

Dim toimialaryhma, Statfinpas klts pxt 909 200700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arkkitehti- ja taideteoll... and first 25 characters of maximum string: Väkiluku...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 19, 2019