Population demographics and mortality data

MORGAM logo

Data transfer format: annual population demographics data

  • Form: 11
  • Version: 4
  • Date: 2014-08-21
Valid HTML 4.01Transitional
© National Institute for Health and Welfare and the MORGAM Project investigators
Last updated: 29 June 2015
For more information, please contact Ari Haukijarvi (firstname.lastname@thl.fi) or Kari Kuulasmaa (firstname.lastname@thl.fi)

The purpose of this transfer format is to provide an exact and common format for the MORGAM Participating Centre (MPC) to transfer annual population demographic data to the MORGAM Data Centre (MDC). The data should be provided for each relevant sex in each Reporting Unit for every calendar year of the MORGAM follow-up period.

Contents

Format specification

ITEM NAME SPECIFICATION AND CODES FORMAT OR VALUE
FORM Form identification I2 |_1|_1|
VERSN Form version I1 |_4|
CENTRE MORGAM Participating Centre code I2 |__|__|
RUNIT MORGAM Reporting Unit code I2 |__|__|
YEAR Calendar year I4 |__|__|__|__|
SEX Sex
1 = males
2 = females		 I1 |__|
AGE15 Number of persons in age group 15-19 I6 |__|__|__|__|__|__|
AGE20 Number of persons in age group 20-24 I6 |__|__|__|__|__|__|
AGE25 Number of persons in age group 25-29 I6 |__|__|__|__|__|__|
AGE30 Number of persons in age group 30-34 I6 |__|__|__|__|__|__|
AGE35 Number of persons in age group 35-39 I6 |__|__|__|__|__|__|
AGE40 Number of persons in age group 40-44 I6 |__|__|__|__|__|__|
AGE45 Number of persons in age group 45-49 I6 |__|__|__|__|__|__|
AGE50 Number of persons in age group 50-54 I6 |__|__|__|__|__|__|
AGE55 Number of persons in age group 55-59 I6 |__|__|__|__|__|__|
AGE60 Number of persons in age group 60-64 I6 |__|__|__|__|__|__|
AGE65 Number of persons in age group 65-69 I6 |__|__|__|__|__|__|
AGE70 Number of persons in age group 70-74 I6 |__|__|__|__|__|__|
AGE75 Number of persons in age group 75-79 I6 |__|__|__|__|__|__|
AGE80 Number of persons in age group 80-84 I6 |__|__|__|__|__|__|
AGE85 Number of persons in age group 85-89 I6 |__|__|__|__|__|__|
AGE90 Number of persons in age group 90-94 I6 |__|__|__|__|__|__|
AGE95 Number of persons in age group 95 and older I6 |__|__|__|__|__|__|
INHABIT Total number of inhabitants in the Reporting Unit
9999999 = information not available		 I7 |__|__|__|__|__|__|__|
INFOSOUR Source of information
1 = direct census count
2 = intercensal estimate
3 = population register
4 = other
5 = intercensal estimates produced in MDC		 I1 |__|

Columns of the format specification

ITEM NAME
name used for the item in the MDC.
SPECIFICATION AND CODES
specification and values of the variable. More details can be found in the section "Definitions of the variables" below, or by following the hyperlink in column ITEM NAME.
FORMAT OR VALUE
specifies the format in which the value should be presented in the transfer data set. In the cases where the value of the variable is fixed, the value is also given in this column.
FORMAT Type Format Example Comments
I Integer I3 1
15
180		 Leading zeroes are not obligatory

Instructions for making corrections to data that have already been sent to the MDC are given in Section Data communication between the MPCs and the MDC.

Please contact the MDC for instructions if you cannot provide information as specified in this document or if you have any problems with the interpretation of the coding for any specific items.

Data transfer procedures

The data should be prepared in ASCII comma-delimited format using semicolon (;) as delimiter, with the names of the variables in the first row. If the value of a variable includes the delimiter inside the text then the value should be surrounded by double quotes ("). A dot (.) should be used as a decimal point. Here is an example of a ASCII comma-delimited data file of Form 11:

form;versn;centre;runit;year;sex;age15;age20;age25;age30;age35;age40;age45;age50;age55;age60;age65;age70;age75;age80;age85;age90;age95;inhabit;infosour
 

To avoid errors in naming the variables, copy and paste the first row from the example above.

To simplify the tracing of data transfers between the MPC and the MDC, the files should be named as follows:

F11_MPCxx_YYYYMMDD_N.CSV, where:

The data files should be sent by e-mail message to MDC (Ari Haukijarvi (firstname.lastname@thl.fi)). In MDC the data will be checked for consistency and quality, and after any problems have been resolved, they will be entered into the MORGAM database and acknowledgement will be sent to the MPC.

Specific instructions for each item

Follow these instructions carefully when creating a computer file.

FORM Form identification I2 |_1|_1|

Number 11 indicates the "Data transfer format: annual population demographics data".

VERSN Form version I1 |_3|

Version number of this form.

CENTRE MORGAM Participating Centre code I2 |__|__|
RUNIT MORGAM Reporting Unit code I2 |__|__|
YEAR Calendar year I4 |__|__|__|__|

Calendar year for which information was provided.

SEX Sex
1 = males
2 = females		 I1 |__|

Sex for which the information was provided.

AGE15 Number of persons in age group 15-19 I6 |__|__|__|__|__|__|

Official count of age group 15-19 years of the SEX in the Reporting Unit.

AGE20 Number of persons in age group 20-24 I6 |__|__|__|__|__|__|

Official count of age group 20-24 years of the SEX in the Reporting Unit.

AGE25 Number of persons in age group 25-29 I6 |__|__|__|__|__|__|

Official count of age group 25-29 years of the SEX in the Reporting Unit.

AGE30 Number of persons in age group 30-34 I6 |__|__|__|__|__|__|

Official count of age group 30-34 years of the SEX in the Reporting Unit.

AGE35 Number of persons in age group 35-39 I6 |__|__|__|__|__|__|

Official count of age group 35-39 years of the SEX in the Reporting Unit.

AGE40 Number of persons in age group 40-44 I6 |__|__|__|__|__|__|

Official count of age group 40-44 years of the SEX in the Reporting Unit.

AGE45 Number of persons in age group 45-49 I6 |__|__|__|__|__|__|

Official count of age group 45-49 years of the SEX in the Reporting Unit.

AGE50 Number of persons in age group 50-54 I6 |__|__|__|__|__|__|

Official count of age group 50-54 years of the SEX in the Reporting Unit.

AGE55 Number of persons in age group 55-59 I6 |__|__|__|__|__|__|

Official count of age group 55-59 years of the SEX in the Reporting Unit.

AGE60 Number of persons in age group 60-64 I6 |__|__|__|__|__|__|

Official count of age group 60-64 years of the SEX in the Reporting Unit.

AGE65 Number of persons in age group 65-69 I6 |__|__|__|__|__|__|

Official count of age group 65-69 years of the SEX in the Reporting Unit.

AGE70 Number of persons in age group 70-74 I6 |__|__|__|__|__|__|

Official count of age group 70-74 years of the SEX in the Reporting Unit.

AGE75 Number of persons in age group 75-79 I6 |__|__|__|__|__|__|

Official count of age group 75-79 years of the SEX in the Reporting Unit.

AGE80 Number of persons in age group 80-84 I6 |__|__|__|__|__|__|

Official count of age group 80-84 years of the SEX in the Reporting Unit.

AGE85 Number of persons in age group 85-89 I6 |__|__|__|__|__|__|

Official count of age group 85-89 years of the SEX in the Reporting Unit.

AGE90 Number of persons in age group 90-94 I6 |__|__|__|__|__|__|

Official count of age group 90-94 years of the SEX in the Reporting Unit.

AGE95 Number of persons in age group 95 and older I6 |__|__|__|__|__|__|

Official count of age group 95 years and older of the SEX in the Reporting Unit.

INHABIT Total number of inhabitants in the Reporting Unit
9999999 = information not available		 I7 |__|__|__|__|__|__|__|

Total number of inhabitants in the MORGAM Reporting Unit, including all ages and sexes without any exclusions. Code '9999999' in this field if the information is not available.

INFOSOUR Source of information
1 = direct census count
2 = intercensal estimate
3 = population register
4 = other
5 = intercensal estimates produced in MDC		 I1 |__|

Code 5 is reserved for possible special cases where the intercensal estimation is done in the MDC.

Updates

Date Update
2005-11-24 Version 3.
2014-08-21 Version 4: added new age groups AGE15, AGE20, AGE75, AGE80, AGE85, AGE90, AGE95.