Methods for integrating public datasets: insights from youth disaster mental health research

Introduction: Weather-related disasters pose significant risks to youth mental health. Exposure to multiple disasters is becoming more common; however, the effects of such exposure remain understudied. This study demonstrates the application of integrative data approaches and FAIR (Findable, Accessible, Interoperable, Reusable) data principles to evaluate the relationship between cumulative disaster exposure and youth depression and suicidality in the United States, taking into account contextual factors across levels of social ecology.Methods: We combined data from five public sources, including the Youth Risk Behavior Surveillance System (YRBS), Federal Emergency Management Agency (FEMA), United States Census Bureau, Center for Homeland Defense and Security School Shooting Safety Compendium, and Global Terrorism Database. The integrative dataset included 415,701 youth from 37 districts across the United States who completed the YRBS between 1999 and 2021. The YRBS served as the core dataset.Results: This data note highlights strategies for harmonizing diverse data formats, addressing geographic and temporal inconsistencies, and validating integrated datasets. Automated data cleaning and visualization techniques enhance accuracy and efficiency. Planning for sensitivity analyses before data cleaning is recommended to improve the data integration process and enhance the robustness of findings.Discussion: This integrative approach demonstrates how leveraging FAIR principles can advance trauma research by facilitating large-scale analyses of complex public health questions. The methods provide a replicable framework for examining population-level impacts of phenomena and highlight opportunities for expanding trauma research.