Criminal Justice Relational Database
2015 - 2023
Overview
Summary
The Criminal Justice Relational Database (CJRD) was created to allow multivariate analyses on the demographic and socioeconomic factors associated with (repeated) criminal justice system involvement in Canada. It consists of anonymized, integrated criminal justice data, as well as other integrated social data sources (e.g., economic, health, and education data).
Concordance files (latest year shown):
- DAD, NACRS, OMHRS - 2022/2023
- PSIS, RAIS - 2022/2023
- Census - 2006, 2011(NHS), 2016, 2021
- T1FF 2022
- Canadian Vital Statistics Deaths (CVSD) Database 2023
- IMDB 2021
The CJRD consists of three types of files: Core Datasets, Supplementary Datasets, and Concordance Key Files.
Core Datasets constitute the base of the CJRD. They are longitudinal, administrative criminal justice system surveys and are updated annually. Core Datasets currently include the Integrated Criminal Court Survey (ICCS) from 2005/2006 to 2022/2023 and the Canadian Correctional Services Survey (CCSS) from 2015/2016 to 2022/2023. The ICCS includes information on appearances, charges, and cases in youth courts and adult criminal courts from all provinces and territories across Canada. The CCSS collects data from correctional services across Canada, including characteristics of persons being supervised and their legal hold statuses. The CCSS Core Dataset includes data on adult correctional records from five provincial correctional programs: Nova Scotia, Ontario, Saskatchewan, Alberta, and British Columbia.
Supplementary Datasets are special extracts from non-criminal justice datasets that are not already available in the RDCs in their full form. They contain only records that linked to one of the Core Datasets and may be updated annually or less frequently. Supplementary Datasets include special extracts from the T1 Family file (T1FF) from 2002 to 2022, the National Ambulatory Care Reporting System (NACRS) from 2005/2006 to 2023/2024, the Discharge Abstract Database (DAD) from 2005/2006 to 2022/2023, the Ontario Mental Health Reporting System (OMHRS) from 2006/2007 to 2022/2023, and the Longitudinal Immigration Database (IMDB) from 1980 to 2021. The T1FF Supplementary Dataset includes select variables on income, employment, and family composition. The NACRS, DAD, and OMHRS Supplementary Datasets include all releasable variables collected by those administrative surveys, including information on the use of medical emergency rooms and ambulatory services, discharges from acute inpatient institutions, and visits to select psychiatric institutions. The IMDB Supplementary Dataset includes only the landing date and the first permit effective date for permanent and non-permanent residents, respectively.
Concordance Key Files allow the Core Datasets to be integrated with non-criminal justice datasets that are already published in the RDCs in their full form. Each Concordance Key File contains only the record identifiers required to merge one of the Core Datasets with one additional target dataset. Concordance Key Files are provided to allow the Core Datasets to be integrated with the Canadian Vital Statistics -Deaths (2005 to 2023), the Postsecondary Student Information System (2008/2009 to 2022/2023), the Registered Apprenticeship Information System (2008 to 2023), the 2006 Census of Population Long-Form, the 2011 National Household Survey, and the 2016 and 2021 Census of Population Long-Forms.
Available Cycles
| Years | Name |
|---|---|
| 2005-2022 | Criminal Justice Relational Database |
Publication Note
All publications (e.g. scientific articles, reports, dissertations, theses) and presentations based on a dataset available in the RDCs should include an acknowledgement of the support provided by granting councils (SSHRC, CIHR, CFI), Statistics Canada and host university. See a sample