Skip to contents

Mapping variables to outputs

data_mapping.Rmd

There are several civil registration variables required to create the tables and figures included in a Vital Statistics report. This vignette presents all of the necessary variables and maps them to the corresponding tables and figures.

Table 1 shows all of the civil registration variables needed to populate the tables and figures required in a Vital Statistics report. The rows can be expanded by event registration type (Birth, Death, Marriage, Divorce) and by characteristic (Newborn, Mother, Decedent, Bride, Groom, Wife and Husband).

Table 1: Variables required for Vital Statistics outputs

The input data from civil registration systems need to be structured following the variable names and data types listed in Table 1.

The tables and figures for the vital statistics report are split by event registration type: Birth, Death, Marriage and Divorce. Filter Table 2 by event and characteristic then click to expand the row to show the variables required for each output. Each table has a number in brackets which refers to the number of variables needed to build it.

Table 2: Mapping variables to Vital Statistics outputs

Once the appropriate variables have been prepared you can start to generate the tables. For example, if you want to create Table 4.7 which is ‘Live births by site of occurrence’. If you enter ‘T4.7’ into the search box in Table 2 you will see that there are 5 variables required:

  • birth1a (Date of occurrence, Event)
  • birth1b (Date of registration, Event)
  • birth1c (Place of occurrence, Event)
  • birth1h (Attendant at birth, Event)
  • birth1i (Type of place of occurrence (hospital, home, etc.), Event)

Each of these variables correspond to the Birth registration event rather than characteristics of the Newborn or Mother.

To create Table 4.7 we can run:

t4_07 <- create_table_4.7(bth_data, 
                         dobyr, 
                         2022, 
                         tablename = "Table_4_7")

Further resources