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

11 ad -- Vital statistics and population, 1749-2017

11 ad -- Vital statistics and population, 1749-2017

Tables

Column Descriptions

Dim year, Statfin muutl pxt 11ad px, Latest

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

Dim year, Statfin muutl pxt 11ad px, Full history

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

Fact, Statfin muutl pxt 11ad px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1749 and maximum value is 2017.
live_births int Datasource did not contain a description for Live_births. Column live_births has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16700 and maximum value is 108168.
deaths int Datasource did not contain a description for Deaths. Column deaths has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10475 and maximum value is 137720.
natural_increase int Natural increase, or excess of births is the difference between the number of live births and deaths. If the number of live births is lower than that of deaths, natural population increase is negative. . Column natural_increase has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -93963 and maximum value is 64091.
intermunicipal_migration int Migration between municipalities according to the regional division of the statistical reference year. As concerns intermunicipal migration, the figures differ from regional vital statistics tables, because there intermunicipal migrations are changed to correspond to the latest regional division. . Column intermunicipal_migration has 269 rows, out of which 129 are empty, making the null percent 47.96. Minimum value is 34448 and maximum value is 293204.
immigration_to_finland int Datasource did not contain a description for Immigration_to_Finland. Column immigration_to_finland has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is 1634 and maximum value is 34905.
emigration_from_finland int Datasource did not contain a description for Emigration_from_Finland. Column emigration_from_finland has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is 5687 and maximum value is 54107.
net_migration int Net migration is the difference between immigration and emigration. . Column net_migration has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is -40499 and maximum value is 18048.
marriages int In 1749 to 1989: Marriages contracted by females permanently resident in Finland. Starting from 1990: Marriages where at least one of the spouses has resided permanently in Finland on the day the marriage was contracted. Includes also marriages of same-sex couples starting from 2017. . Column marriages has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3721 and maximum value is 49743.
divorces int In 1878 to 1989: Divorces refer to the divorces of females permanently resident in Finland. Starting from 1990: Divorces where at least one of the spouses has resided permanently in Finland on the day the divorce was granted. Includes also divorces of same-sex couples starting from 2017. . Column divorces has 269 rows, out of which 129 are empty, making the null percent 47.96. Minimum value is 28 and maximum value is 14365.
total_change int Total change is the difference between the population at the end of the statistical reference year and the previous year. . Column total_change has 269 rows, out of which 1 are empty, making the null percent 0.37. Minimum value is -96660 and maximum value is 190073.
population int Population at the end of the year 31 December. . Column population has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 410400 and maximum value is 5513130.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin muutl pxt 11ad px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1749 and maximum value is 2017.
live_births int Datasource did not contain a description for Live_births. Column live_births has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16700 and maximum value is 108168.
deaths int Datasource did not contain a description for Deaths. Column deaths has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10475 and maximum value is 137720.
natural_increase int Natural increase, or excess of births is the difference between the number of live births and deaths. If the number of live births is lower than that of deaths, natural population increase is negative. . Column natural_increase has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -93963 and maximum value is 64091.
intermunicipal_migration int Migration between municipalities according to the regional division of the statistical reference year. As concerns intermunicipal migration, the figures differ from regional vital statistics tables, because there intermunicipal migrations are changed to correspond to the latest regional division. . Column intermunicipal_migration has 269 rows, out of which 129 are empty, making the null percent 47.96. Minimum value is 34448 and maximum value is 293204.
immigration_to_finland int Datasource did not contain a description for Immigration_to_Finland. Column immigration_to_finland has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is 1634 and maximum value is 34905.
emigration_from_finland int Datasource did not contain a description for Emigration_from_Finland. Column emigration_from_finland has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is 5687 and maximum value is 54107.
net_migration int Net migration is the difference between immigration and emigration. . Column net_migration has 269 rows, out of which 196 are empty, making the null percent 72.86. Minimum value is -40499 and maximum value is 18048.
marriages int In 1749 to 1989: Marriages contracted by females permanently resident in Finland. Starting from 1990: Marriages where at least one of the spouses has resided permanently in Finland on the day the marriage was contracted. Includes also marriages of same-sex couples starting from 2017. . Column marriages has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3721 and maximum value is 49743.
divorces int In 1878 to 1989: Divorces refer to the divorces of females permanently resident in Finland. Starting from 1990: Divorces where at least one of the spouses has resided permanently in Finland on the day the divorce was granted. Includes also divorces of same-sex couples starting from 2017. . Column divorces has 269 rows, out of which 129 are empty, making the null percent 47.96. Minimum value is 28 and maximum value is 14365.
total_change int Total change is the difference between the population at the end of the statistical reference year and the previous year. . Column total_change has 269 rows, out of which 1 are empty, making the null percent 0.37. Minimum value is -96660 and maximum value is 190073.
population int Population at the end of the year 31 December. . Column population has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 410400 and maximum value is 5513130.

Additional Info

Last Updated July 20, 2019
Created July 20, 2019