Baselight

Respiratory Conditions In The Medicaid And CHIP Population

U.S. Department of Health & Human Services

@usgov.hhs_gov_respiratory_conditions_in_the_medicaid_and_chi_53952c1f

Loading...
Loading...

About this Dataset

Respiratory Conditions In The Medicaid And CHIP Population

This data set includes monthly counts and percentages of Medicaid and CHIP beneficiaries, by state, who received at least one service for each of the following conditions: acute bronchitis, acute respiratory distress, bronchitis not other specified (NOS), COVID-19 (based on the presence of diagnosis code U07.1), influenza, lower or acute respiratory infection, pneumonia, respiratory infection NOS, and suspected COVID-19 (based on the presence of diagnosis code B97.29).

These metrics are based on data in the T-MSIS Analytic Files (TAF). Some states have serious data quality issues for one or more months, making the data unusable for calculating COVID-related conditions measures. To assess data quality, analysts adapted measures featured in the DQ Atlas. Data for a state and month are considered unusable if at least one of the following topics meets the DQ Atlas threshold for unusable: Total Medicaid and CHIP Enrollment, Claims Volume - IP, Claims Volume - OT, Claims Volume - IP, Diagnosis Code - IP, Diagnosis Code - OT, Procedure Codes - OT Professional. Please refer to the DQ Atlas at http://medicaid.gov/dq-atlas for more information about data quality assessment methods. Cells with a value of “DQ” indicate that data were suppressed due to unusable data.

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:36:57.787303
Tags: chip, covid-19, dq-atlas, medicaid, t-msis-analytic-files

Tables

Respiratory Conditions In The Medicaid And CHIP Population

@usgov.hhs_gov_respiratory_conditions_in_the_medicaid_and_chi_53952c1f.respiratory_conditions_in_the_medicaid_and_chip_population
  • 119.8 KB
  • 28620 rows
  • 7 columns
Loading...

CREATE TABLE respiratory_conditions_in_the_medicaid_and_chip_population (
  "state" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "condition" VARCHAR,
  "beneficiarycount" VARCHAR,
  "percentageofbeneficiaries" VARCHAR,
  "dataquality" VARCHAR
);

Share link

Anyone who has the link will be able to view this.