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

902 -- Teollisuus toimialoittain ja maakunnittain 2006-2012

902 -- Teollisuus toimialoittain ja maakunnittain 2006-2012

Tables

Column Descriptions

Fact, Statfinpas alyr pxt 902 201200 fi px, Latest

Column Type Comment
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu and maximum string is Kulkatav.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.
teollisuus_toimialoittain_ja_maakunnittain_20062012 int Datasource did not contain a description for Teollisuus_toimialoittain_ja_maakunnittain_20062012. Column teollisuus_toimialoittain_ja_maakunnittain_20062012 has 264880 rows, out of which 93750 are empty, making the null percent 35.39. Minimum value is -290870 and maximum value is 56585903.

Fact, Statfinpas alyr pxt 902 201200 fi px, Full history

Column Type Comment
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu and maximum string is Kulkatav.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 264880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.
teollisuus_toimialoittain_ja_maakunnittain_20062012 int Datasource did not contain a description for Teollisuus_toimialoittain_ja_maakunnittain_20062012. Column teollisuus_toimialoittain_ja_maakunnittain_20062012 has 264880 rows, out of which 93750 are empty, making the null percent 35.39. Minimum value is -290870 and maximum value is 56585903.
orig_extractdate string The date when the data was originally fetched from the source.

Dim maakunta, Statfinpas alyr pxt 902 201200 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...

Dim maakunta, Statfinpas alyr pxt 902 201200 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tilastovuosi, Statfinpas alyr pxt 902 201200 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 2006 and maximum value is 2012.
label int The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.

Dim toimiala, Statfinpas alyr pxt 902 201200 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
label string The label for the dimension value. Column label has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Statfinpas alyr pxt 902 201200 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
label string The label for the dimension value. Column label has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...

Dim tiedot, Statfinpas alyr pxt 902 201200 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu and maximum string is Kulkatav.
label string The label for the dimension value. Column label has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineet ja tarvikkeet tili... and first 25 characters of maximum string: Kauppatavaroiden hankinta...

Dim tilastovuosi, Statfinpas alyr pxt 902 201200 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 2006 and maximum value is 2012.
label int The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas alyr pxt 902 201200 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu and maximum string is Kulkatav.
label string The label for the dimension value. Column label has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineet ja tarvikkeet tili... and first 25 characters of maximum string: Kauppatavaroiden hankinta...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 1, 2019