1. Home
  2. Datasets
  3. 026 -- Population in urban ...
To download the data set, please sign up or log in

026 -- Population in urban settlements and sparsely populated areas by age, sex and municipality, 31 Dec 2015

026 -- Population in urban settlements and sparsely populated areas by age, sex and municipality, 31 Dec 2015

Tables

Column Descriptions

Dim municipality and urban settlement, Statfinpas vaerak pxt 026 201500 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 1783 rows, out of which 317 are empty, making the null percent 17.78. Minimum value is 50000 and maximum value is 9929999.
label string The label for the dimension value. Column label has 1783 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 .. Alajärvi cl and maximum string is 992 .. Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vaerak pxt 026 201500 px, Full history

Column Type Comment
municipality_and_urban_settlement int All clusters of buildings with at least 200 inhabitants where the distance between buildings does not exceed 200 metres are defined as localities or urban settlements. In defining localities, not only residential but also business, office and other buildings used as workplaces are taken into account. Administrative regional divisions do not have an effect on the formation of localities. pv = parish village cl = central locality rsa = railway station area . Column municipality_and_urban_settlement has 545598 rows, out of which 97002 are empty, making the null percent 17.78. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 545598 rows, out of which 181866 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 545598 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 000 and maximum string is 100.
population_31_12 int Datasource did not contain a description for Population_31_12. Column population_31_12 has 545598 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 5487308.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfinpas vaerak pxt 026 201500 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 102 rows, out of which 1 are empty, making the null percent 0.98. Minimum value is 0 and maximum value is 100.
label int The label for the dimension value. Column label has 102 rows, out of which 2 are empty, making the null percent 1.96. Minimum value is 0 and maximum value is 99.

Dim sex, Statfinpas vaerak pxt 026 201500 px, Full history

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

Dim municipality and urban settlement, Statfinpas vaerak pxt 026 201500 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 1783 rows, out of which 317 are empty, making the null percent 17.78. Minimum value is 50000 and maximum value is 9929999.
label string The label for the dimension value. Column label has 1783 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 .. Alajärvi cl and maximum string is 992 .. Unknown.

Fact, Statfinpas vaerak pxt 026 201500 px, Latest

Column Type Comment
municipality_and_urban_settlement int All clusters of buildings with at least 200 inhabitants where the distance between buildings does not exceed 200 metres are defined as localities or urban settlements. In defining localities, not only residential but also business, office and other buildings used as workplaces are taken into account. Administrative regional divisions do not have an effect on the formation of localities. pv = parish village cl = central locality rsa = railway station area . Column municipality_and_urban_settlement has 545598 rows, out of which 97002 are empty, making the null percent 17.78. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 545598 rows, out of which 181866 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 545598 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 000 and maximum string is 100.
population_31_12 int Datasource did not contain a description for Population_31_12. Column population_31_12 has 545598 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 5487308.

Dim age, Statfinpas vaerak pxt 026 201500 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 102 rows, out of which 1 are empty, making the null percent 0.98. Minimum value is 0 and maximum value is 100.
label int The label for the dimension value. Column label has 102 rows, out of which 2 are empty, making the null percent 1.96. Minimum value is 0 and maximum value is 99.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfinpas vaerak pxt 026 201500 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Both sexes and maximum string is Females.

Additional Info

Last Updated June 13, 2019
Created June 12, 2019