About this Dataset

Beneficiaries Receiving A Physical Hlth Serv Among Beneficiaries Receiving A Mental Hlth Serv, By Physical Hlth Cond, 2017-2021

This table presents beneficiaries who received a service for a physical health condition among beneficiaries who received a service for a mental health condition, by physical health condition, 2017-2021.

Some states have serious data quality issues, making the data unusable for identifying this population. To assess data quality, analysts used measures featured in the DQ Atlas. Data for a state are considered unusable based on DQ Atlas thresholds for the following topics: Total Medicaid and CHIP Enrollment, Claims Volume - IP, Claims Volume - OT, Claims Volume - IP, Diagnosis Code - IP, Diagnosis Code - OT, Procedure Codes - OT Professional, Gender, Age, Zip code, Race and ethnicity, Eligibility group code, Enrollment in CMC Plans.

Data from Maryland, Tennessee, and Utah are omitted for the tables due to data quality concerns. Maryland was excluded in 2017 due to unusable diagnosis codes in the IP file and the OT file. Tennessee was excluded due to unusable diagnosis codes in the IP file in 2017 - 2019. Utah was excluded due to unusable procedure codes on OT professional claims in 2017 - 2020. In addition, states with a high data quality concern on one or more measures are noted in the table in the "Data Quality" column. Please refer to the DQ Atlas at http://medicaid.gov/dq-atlas for more information about data quality assessment methods.

Some cells have a value of “DS”. This indicates that data were suppressed for confidentiality reasons because the group included fewer than 11 beneficiaries.
Organization: U.S. Department of Health & Human Services
Last updated: 2024-01-19T17:41:47.048405
Tags: behavioral-health-care, chip, integrated-care, medicaid, mental-health-condition, physical-health-condition

Tables

Beneficiaries Receiving A Physical Hlth Serv Among Beneficiaries Receiving A Mental Hlth Serv, By Physical Hlth Cond, 2017-2021

@usgov.hhs_gov_beneficiaries_receiving_a_physical_hlth_serv_a_ba100ad6.beneficiaries_receiving_a_physical_hlth_serv_among_ben_ba7f3ccc

33.98 kB
5,565 rows
6 columns

CREATE TABLE beneficiaries_receiving_a_physical_hlth_serv_among_ben_ba7f3ccc (
  "state" VARCHAR,
  "year" BIGINT,
  "condition" VARCHAR,
  "n__number_of_beneficiaries" VARCHAR  -- Number Of Beneficiaries,
  "percent_of_beneficiaries_with_specific_condition_out_o_368832b1" VARCHAR  -- Percent Of Beneficiaries With Specific Condition (out Of Those With Any Mental Health Condition In Each State, By Year),
  "data_quality" VARCHAR
);