Related Experiment Video

Updated: Jun 6, 2025

Integrating Computerized Linguistic and Social Network Analyses to Capture Addiction Recovery Capital in an Online Community

Integrating Computerized Linguistic and Social Network Analyses to Capture Addiction Recovery Capital in an Online Community

Published on: May 31, 2019

Creating an 11-year longitudinal substance use harm cohort from linked health and census data to analyse social

Anousheh Marouzi¹, Charles Plante^1,2, Barbara Fornssler³

¹Research Department, Saskatchewan Health Authority, Saskatoon, Canada.

International Journal of Population Data Science

|December 2, 2024

Abstract

Introduction:

Research on substance use harm in Canada has been hampered by an absence of linked data to analyse and report on the social drivers of substance use harm.

Objectives:

This study aims to address this gap by providing a fully annotated Stata do-file that links sociodemographic data to 11 years of hospitalisation and death outcomes. This do-file will greatly facilitate the creation of provincial and national substance use cohorts using line-level data available through Statistics Canada's Research Data Centres (RDC) program.

Methods:

We used Canadian Census Health and Environment Cohorts (CanCHEC) 2006 to create a cohort of Saskatchewanians followed from 2006 to 2016. We linked sociodemographic information of the 2006 Census (long-form) respondents to their hospitalisation data captured in the Discharge Abstract Database (DAD) (2006 to 2016) and their mortality records in the Canadian Vital Statistics Death Database (CVSD) (2006 to 2016). We developed an algorithm to identify Saskatchewanians who experienced a substance use harm event. We validated the cohort by comparing our descriptive findings with those from other Canadian studies on substance use.

Results:

We used CanCHEC, a national data resource, whereas most previous studies have used provincial data resources. Despite this difference in constructing the cohorts, our results showed trends consistent with previous studies, including an overrepresentation of individuals with lower socioeconomic status among the people who experienced substance use harm (PESUH). Similar to other Canadian studies, our results indicate an increasing rate of substance use harm from 2006 to 2016.

Conclusion:

This study provides a Stata do-file that compiles a validated substance use cohort using CanCHEC, enabling comprehensive substance use research by linking sociodemographic data with health outcomes. The do-file is likely to save researchers hundreds of hours and accelerate research on the drivers of substance use harms in Canada.

Keywords:

censuses cohort studies electronic health records hospital records longitudinal studies medical record linkage mortality routinely collected health data social determinants of health socioeconomic disparities in health socioeconomic factors substance-related disorders

More Related Videos

Investigating Drivers of Antireward in Addiction Behavior with Anatomically Specific Single-Cell Gene Expression Methods

Investigating Drivers of Antireward in Addiction Behavior with Anatomically Specific Single-Cell Gene Expression Methods

Published on: August 4, 2022

Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index

Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index

Published on: January 8, 2020

Related Concept Videos

Longitudinal Research

Longitudinal Research

Sometimes we want to see how people change over time, as in studies of human development and lifespan. When we test the same group of individuals repeatedly over an extended period of time, we are conducting longitudinal research. Longitudinal research is a research design in which data-gathering is administered repeatedly over an extended period of time. For example, we may survey a group of individuals about their dietary habits at age 20, retest them a decade later at age 30, and then again...

Longitudinal Studies

Longitudinal Studies

Longitudinal studies are also widely used in other medical and social science fields. For instance, in cardiovascular research, they can monitor patients' health over decades to identify risk factors for heart disease, such as high cholesterol or smoking, and evaluate the long-term effectiveness of preventive measures. Similarly, in mental health studies, researchers might follow individuals from adolescence into adulthood to understand the development and progression of conditions like...

Observational Studies

Observational Studies

Observational studies are a type of analytical study where researchers observe events without any interventions. In other words, the researcher does not influence the response variable or the experiment's outcome.
There are three types of observational studies – Prospective, retrospective, and cross-sectional.
Prospective Study
Prospective studies, also known as longitudinal or cohort studies, are carried out by collecting future data from groups sharing similar characteristics. One...

Statistical Methods for Analyzing Epidemiological Data

Statistical Methods for Analyzing Epidemiological Data

Epidemiological data primarily involves information on specific populations' occurrence, distribution, and determinants of health and diseases. This data is crucial for understanding disease patterns and impacts, aiding public health decision-making and disease prevention strategies. The analysis of epidemiological data employs various statistical methods to interpret health-related data effectively. Here are some commonly used methods:

Substance Use Disorders Affecting Sleep

Substance Use Disorders Affecting Sleep

Substance use disorders involve a pattern of using drugs more extensively than intended and continuing use despite harmful consequences. This includes legal substances like alcohol and nicotine, as well as illegal drugs. These disorders often involve both physical and psychological dependence, reflecting compulsive use of substances that significantly alter thoughts, feelings, and behaviors, contributing to a major public health issue.
Understanding the concepts of physical dependence,...

Genome-wide Association Studies-GWAS

Genome-wide Association Studies-GWAS

Genome-wide association studies or GWAS are used to identify whether common SNPs are associated with certain diseases. Suppose specific SNPs are more frequently observed in individuals with a particular disease than those without the disease. In that case, those SNPs are said to be associated with the disease. Chi-square analysis is performed to check the probability of the allele likely to be associated with the disease.
GWAS does not require the identification of the target gene involved in...

Articles linked to this work by shared authors, journal, and citation graph.

Saskatoon, Saskatchewan's safe consumption site provides a sizeable social and economic return on investment.

Frontiers in public health·2026

Substance use stabilization model: A proposed framework for addressing substance use concerns in Canada.

Canadian journal of public health = Revue canadienne de sante publique·2026

Multilevel Estimation of the Relative Impacts of Social Determinants on Income-Related Health Inequalities in Urban Canada: Protocol for the Canadian Social Determinants Urban Laboratory.

JMIR research protocols·2025

Enablers and barriers to public health practice during COVID-19: Perspectives from local public leadership from across Canada.

Canadian journal of public health = Revue canadienne de sante publique·2025

Feasibility and acceptability of inserts promoting virtual overdose monitoring services (VOMS) in naloxone kits: a qualitative study.

Harm reduction journal·2023

Surveying the local public health response to COVID-19 in Canada: Study protocol.

PloS one·2021

See all related articles