To download the data set, please sign up or log in

Vieraskieliset ja ulkomaan kansalaiset 1980 - 2010

Vieraskieliset ja ulkomaan kansalaiset 1980 - 2010

Tables

Column Descriptions

Dim vaestotieto, Ulkomaalaiset fi px, Latest

Column Type Comment
code int 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 value is 1 and maximum value is 5.
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. First 25 characters of minimum string: Ulkomaan kansalaiset... and first 25 characters of maximum string: Ulkomaan kansalaisten osu...

Dim alue, Ulkomaalaiset fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 337 rows, out of which 1 are empty, making the null percent 0.30. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 337 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.

Dim alue, Ulkomaalaiset fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 337 rows, out of which 1 are empty, making the null percent 0.30. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 337 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Ulkomaalaiset fi px, Full history

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

Dim vuosi, Ulkomaalaiset fi px, Latest

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

Fact, Ulkomaalaiset fi px, Latest

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 52235 rows, out of which 155 are empty, making the null percent 0.30. Minimum value is 5 and maximum value is 992.
vaestotieto int Datasource did not contain a description for Vaestotieto. Column vaestotieto has 52235 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 5.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 52235 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1980 and maximum value is 2010.
vieraskieliset_ja_ulkomaan_kansalaiset int Datasource did not contain a description for Vieraskieliset_ja_ulkomaan_kansalaiset. Column vieraskieliset_ja_ulkomaan_kansalaiset has 52235 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5375276.

Dim vaestotieto, Ulkomaalaiset fi px, Full history

Column Type Comment
code int 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 value is 1 and maximum value is 5.
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. First 25 characters of minimum string: Ulkomaan kansalaiset... and first 25 characters of maximum string: Ulkomaan kansalaisten osu...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Ulkomaalaiset fi px, Full history

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 52235 rows, out of which 155 are empty, making the null percent 0.30. Minimum value is 5 and maximum value is 992.
vaestotieto int Datasource did not contain a description for Vaestotieto. Column vaestotieto has 52235 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 5.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 52235 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1980 and maximum value is 2010.
vieraskieliset_ja_ulkomaan_kansalaiset int Datasource did not contain a description for Vieraskieliset_ja_ulkomaan_kansalaiset. Column vieraskieliset_ja_ulkomaan_kansalaiset has 52235 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5375276.
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