This project will update current and define new community indicators for the publicly-available Opioid Environment Policy Scan (OEPS) Data Warehouse, a JCOIN-funded open data warehouse that explores the multi-dimensional risk environment impacting opioid use and health outcomes across the U.S. OEPS incorporates over 100 variables at census tract, zip, county, and state scales, and has been used in similar studies to the proposed work. 

Planned updates to the OEPS will focus on key indicators identified via literature review as tract-level estimates from publicly available data for all census tracts (N=84,414) for the entire U.S. and expand updated Census records to include 2023 5-year estimates to supplement OEPS records. Data output will be aggregated to county-level estimates, and cross-walked to 5-digit zip code tabulation area (ZCTA) measures using HUD Crosswalks to facilitate ease of public use. Code used to extract measures will be retained and shared to enable reproducible, updated input as new Census estimates become available. Community indicators will be derived from a variety of publicly available data sources including five-year estimates from the American Community Survey (ACS); provider locations from current and historic public Substance Abuse and Mental Health Services Administration (SAMHSA) surveys; primary care provider data from Health Resources and Services Administration (HRSA) public databases; multiple measures on urbanicity and small area crosswalk from the U.S Department of Housing and Urban Development (HUD); opioid-related mortality from the Centers for Disease Control (CDC) Wonder database; policy measures such as Medicaid expansion via the Law Atlas; jobs data from the Longitudinal Employer-Household Dynamics (LEHD) database; and small area estimates of health from the CDC PLACE database. We will also consider other sources of data recommended by the literature and panel review process.