Power of Linked Administrative Data

Introduction Linking administrative data provides valuable information about individuals using government services and can be very useful for policy-makers in improving and developing services and policies. The Child and Youth Data Laboratory (CYDL) links and analyses administrative data from Albert...

Full description

Bibliographic Details
Main Authors: Hesam Izakian, Hitesh Bhatt, Robert Jagodzinski, Leslie Twilley, Xinjie Cui
Format: Article
Language:English
Published: Swansea University 2018-08-01
Series:International Journal of Population Data Science
Online Access:https://ijpds.org/article/view/647
_version_ 1827612562520276992
author Hesam Izakian
Hitesh Bhatt
Robert Jagodzinski
Leslie Twilley
Xinjie Cui
author_facet Hesam Izakian
Hitesh Bhatt
Robert Jagodzinski
Leslie Twilley
Xinjie Cui
author_sort Hesam Izakian
collection DOAJ
description Introduction Linking administrative data provides valuable information about individuals using government services and can be very useful for policy-makers in improving and developing services and policies. The Child and Youth Data Laboratory (CYDL) links and analyses administrative data from Alberta Government ministries to provide evidence for policy and program development. Objectives and Approach Data from 20 programs of six Government of Alberta ministries (Advanced Education, Education, Health, Children’s Services, Community and Social Services, and Justice and Solicitor General) were linked anonymously. The data spans six years from 2005/06 to 2010/11 and consists of almost 50 million records corresponding to over 2 million unique Albertans aged 0 to 25 years. A data visualization tool called the Program Overlap Matrix summarises the overlap rates among the programs. It is comprised of a matrix of squares, where each cell represents the overlap between two programs. Results The Program Overlap Matrix is publically available at https://visualization.policywise.com/P2matrix/. It consists of overlap rates between programs in any study year (2005/06 to 2010/11), individual years, the first year vs. future years, and the last year vs. previous years which can be used to answer many policy-related questions such as: other service use (e.g., what other services do ESL students use?), over-represented programs (e.g., in what programs are Child Care Subsidy clients over-represented?), resilience (e.g., what is the proportion of Child Intervention clients in post-secondary institutions?), transitions (e.g., what types of services do students with special needs receive as they transition to adulthood?), and time trend (e.g., what types of services did Income Support clients receive in the past?) Conclusion/Implications The program overlap matrix is a powerful tool to discover relationships between programs. It is a useful instrument to inform public and policy-makers about the overlap rates between government programs. It can be used to answer a variety of policy-related questions.
first_indexed 2024-03-09T08:25:03Z
format Article
id doaj.art-e6eb7fc3175a4fe1a409042ec972c247
institution Directory Open Access Journal
issn 2399-4908
language English
last_indexed 2024-03-09T08:25:03Z
publishDate 2018-08-01
publisher Swansea University
record_format Article
series International Journal of Population Data Science
spelling doaj.art-e6eb7fc3175a4fe1a409042ec972c2472023-12-02T21:20:54ZengSwansea UniversityInternational Journal of Population Data Science2399-49082018-08-013410.23889/ijpds.v3i4.647Power of Linked Administrative DataHesam Izakian0Hitesh Bhatt1Robert Jagodzinski2Leslie Twilley3Xinjie Cui4PolicyWise for Children & FamiliesPolicyWise for Children & FamiliesPolicyWise for Children & FamiliesEntelechy Resources Consulting Inc.PolicyWise for Children & FamiliesIntroduction Linking administrative data provides valuable information about individuals using government services and can be very useful for policy-makers in improving and developing services and policies. The Child and Youth Data Laboratory (CYDL) links and analyses administrative data from Alberta Government ministries to provide evidence for policy and program development. Objectives and Approach Data from 20 programs of six Government of Alberta ministries (Advanced Education, Education, Health, Children’s Services, Community and Social Services, and Justice and Solicitor General) were linked anonymously. The data spans six years from 2005/06 to 2010/11 and consists of almost 50 million records corresponding to over 2 million unique Albertans aged 0 to 25 years. A data visualization tool called the Program Overlap Matrix summarises the overlap rates among the programs. It is comprised of a matrix of squares, where each cell represents the overlap between two programs. Results The Program Overlap Matrix is publically available at https://visualization.policywise.com/P2matrix/. It consists of overlap rates between programs in any study year (2005/06 to 2010/11), individual years, the first year vs. future years, and the last year vs. previous years which can be used to answer many policy-related questions such as: other service use (e.g., what other services do ESL students use?), over-represented programs (e.g., in what programs are Child Care Subsidy clients over-represented?), resilience (e.g., what is the proportion of Child Intervention clients in post-secondary institutions?), transitions (e.g., what types of services do students with special needs receive as they transition to adulthood?), and time trend (e.g., what types of services did Income Support clients receive in the past?) Conclusion/Implications The program overlap matrix is a powerful tool to discover relationships between programs. It is a useful instrument to inform public and policy-makers about the overlap rates between government programs. It can be used to answer a variety of policy-related questions.https://ijpds.org/article/view/647
spellingShingle Hesam Izakian
Hitesh Bhatt
Robert Jagodzinski
Leslie Twilley
Xinjie Cui
Power of Linked Administrative Data
International Journal of Population Data Science
title Power of Linked Administrative Data
title_full Power of Linked Administrative Data
title_fullStr Power of Linked Administrative Data
title_full_unstemmed Power of Linked Administrative Data
title_short Power of Linked Administrative Data
title_sort power of linked administrative data
url https://ijpds.org/article/view/647
work_keys_str_mv AT hesamizakian poweroflinkedadministrativedata
AT hiteshbhatt poweroflinkedadministrativedata
AT robertjagodzinski poweroflinkedadministrativedata
AT leslietwilley poweroflinkedadministrativedata
AT xinjiecui poweroflinkedadministrativedata