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 2011

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

Tables

Column Descriptions

Fact, Statfinpas vaerak pxt 026 201100 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 567936 rows, out of which 104040 are empty, making the null percent 18.32. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 567936 rows, out of which 189312 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 567936 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_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_dec_2011 int Datasource did not contain a description for Population_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_Dec_2011. Column population_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_dec_2011 has 567936 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 5401267.

Dim age, Statfinpas vaerak pxt 026 201100 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.

Fact, Statfinpas vaerak pxt 026 201100 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 567936 rows, out of which 104040 are empty, making the null percent 18.32. Minimum value is 50000 and maximum value is 9929999.
sex int Datasource did not contain a description for Sex. Column sex has 567936 rows, out of which 189312 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 567936 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_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_dec_2011 int Datasource did not contain a description for Population_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_Dec_2011. Column population_in_urban_settlements_and_sparsely_populated_areas_by_age_sex_and_municipality_31_dec_2011 has 567936 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 5401267.
orig_extractdate string The date when the data was originally fetched from the source.

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

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

Dim sex, Statfinpas vaerak pxt 026 201100 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.

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

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

Dim age, Statfinpas vaerak pxt 026 201100 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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019