Many states are continuing to struggle with opioids and other commonly abused drugs. Alabama, being the highest opioid prescription per-capita state since 2012, has pulled together state agencies, private companies, academia, and community organizations to form a data council and repository to provide unified insights and information to the public and partner stakeholders. The lessons learned in constructing this data environment are documented so that other states and organizations can benefit from the challenges and success that Alabama has experienced. The centralized data repository consists of almost a dozen data streams from public agencies and private companies. The data are transformed and linked within the repository to provide geo-temporal linkages between data sources. The data are stored in a secure multi-tiered environment in a Microsoft SQL Server database, de-identified, aggregated, and then published to a public web portal for open consumption. The public-facing website from the project successfully integrates multiple disparate data sources into a common platform for streamlined and cohesive data communications. Drug addiction cannot be easily quantified, viewed, or otherwise examined when only looking at a portion of society. By bringing together multiple data sources and linking them, a more clear picture of trends, influences, and metrics can be obtained. A statewide drug use data partnership between public and private entities is both possible as well as beneficial to all parties involved. Items like legal contracts can inhibit data sharing, but certain best practices can help scale and streamline multiple agreements.
Keywords: best practice; dashboard; data; integration; opioid.
© The Author(s) 2022. Published by Oxford University Press on behalf of the American Medical Informatics Association.