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 2012

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

Tables

Column Descriptions

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

Column Type Comment
code int The code for the dimension value. Column code has 1799 rows, out of which 324 are empty, making the null percent 18.01. Minimum value is 50000 and maximum value is 9929999.
label string The label for the dimension value. Column label has 1799 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 201200 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 550494 rows, out of which 99144 are empty, making the null percent 18.01. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 550494 rows, out of which 183498 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 550494 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 int Datasource did not contain a description for Population. Column population has 550494 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 5426674.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vaerak pxt 026 201200 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 550494 rows, out of which 99144 are empty, making the null percent 18.01. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 550494 rows, out of which 183498 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 550494 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 int Datasource did not contain a description for Population. Column population has 550494 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 5426674.

Dim sex, Statfinpas vaerak pxt 026 201200 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 201200 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 1799 rows, out of which 324 are empty, making the null percent 18.01. Minimum value is 50000 and maximum value is 9929999.
label string The label for the dimension value. Column label has 1799 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.

Dim sex, Statfinpas vaerak pxt 026 201200 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 July 20, 2019
Created July 16, 2019