Skip to main content

CDC Asthma CCDD v1

Query purpose:

The purpose of this definition is to capture potential emergency department visits related to asthma.

How it works:

The Chief Complaint Discharge Diagnosis (CCDD) parsed field is used to query both the discharge diagnosis codes and chief complaint free text, and exclusions are incorporated as necessary.

  • Inclusion based on complaint free text terms related to severe asthma:
    • The visit is included if it contains:
      1. A chief complaint related to asthma – (“asthma” or “ asma” or “asthama” or “asthma” or “asthmia”) OR
      2. A chief complaint for bronchospasm – (“bronchospasm”) OR
    • The visit is included if it contains the following set of terms nested together:
      1. A chief complaint nested terms related to reactive airway disease – (“airway” or “disease” and “reactive”) OR
      2. Another chief complaint nested terms related to reactive airway disease – (“airway” and “disease”) OR
  • Inclusion based on ICD-10 discharge diagnosis codes related to severe asthma:
    • The visit is included if it contains:
      1. A discharge diagnosis code related to asthma – (J45) OR
  • Inclusion based on SNOMED discharge diagnosis codes related to severe asthma:
    • The visit is included if it contains:
      1. A discharge diagnosis code related to asthma – (281239006 or 195967001 or 708038006 or 708090002 or 304527002 or 312453004 or 390798007) OR
      2. A discharge diagnosis code related to asthmatic bronchitis – (405944004 or 442025000 or 195949008) OR
      3. A discharge diagnosis code for Wheezing – (56018004) OR
      4. A discharge diagnosis code for Acute exacerbation of chronic obstructive pulmonary disease with asthma – (1751000119100) OR
      5. A discharge diagnosis code for Asthma with irreversible airway bronchitis – (401000119107) OR
      6. A discharge diagnosis code related to mild persistent asthma – (426979002 or 135181000119109 or 370218001 or 707445000) OR
      7. A discharge diagnosis code for Cough variant asthma – (409663006) OR
      8. A discharge diagnosis code for Asthma attack – (266364000) OR
      9. A discharge diagnosis code for Exercise-induced asthma – (31387002) OR
      10. A discharge diagnosis code related to allergic asthma – (389145006 or 708093000) OR
      11. A discharge diagnosis code related to moderate persistent asthma – (135171000119106 or 707446004 or 427295004 or 370219009 or 707980005) OR
      12. A discharge diagnosis code for Acute exacerbation of asthma co-occurrent with allergic rhinitis – (99031000119107) OR
      13. A discharge diagnosis code for Exacerbation of intermittent asthma – (425969006) OR
      14. A discharge diagnosis code for Asthma with status asthmaticus – (57546000) OR
      15. A discharge diagnosis code for Childhood asthma – (233678006) OR
      16. A discharge diagnosis code related to Severe persistent asthma – (707447008 or 426656000
      17. A discharge diagnosis code for Hay fever with asthma – (233683003) OR
      18. A discharge diagnosis code for Acute exacerbation of intrinsic asthma – (708094006) OR
      19. A discharge diagnosis code for Asthma without status asthmaticus – (55570000) OR
      20. A discharge diagnosis code for Persistent asthma – (5281000124103) OR
      21. A discharge diagnosis code for Severe asthma – (370221004) ANDNOT
  • All of the above must exclude:
    • Chief complaint free-text term for visits that are not asthma – (“not asthma”)
Syndrome Definition

(,^asthma^,or,^[;/ ]asma^,or,asma^,or,^asthama^,or,^asthma^,or,^asthmia^,or,^bronchospasm^,or,(,(,(,^Airway^,or,^Disease^,),AND,^Reactive^,),or,(,^Airway^,AND,^Disease^,),),or,^J45^,or,^[;/ ]281239006^,or,^[;/ ]195967001^,or,^[;/ ]708038006^,or,^[;/ ]405944004^,or,^[;/ ]708090002^,or,^[;/ ]56018004^,or,^[;/ ]304527002^,or,^[;/ ]1751000119100^,or,^[;/ ]401000119107^,or,^[;/ ]426979002^,or,^[;/ ]409663006^,or,^[;/ ]266364000^,or,^[;/ ]31387002^,or,^[;/ ]389145006^,or,^[;/ ]442025000^,or,^[;/ ]708093000^,or,^[;/ ]135171000119106^,or,^[;/ ]99031000119107^,or,^[;/ ]135181000119109^,or,^[;/ ]425969006^,or,^[;/ ]370218001^,or,^[;/ ]57546000^,or,^[;/ ]312453004^,or,^[;/ ]707446004^,or,^[;/ ]427295004^,or,^[;/ ]370219009^,or,^[;/ ]233678006^,or,^[;/ ]195949008^,or,^[;/ ]707447008^,or,^[;/ ]707445000^,or,^[;/ ]233683003^,or,^[;/ ]708094006^,or,^[;/ ]55570000^,or,^[;/ ]426656000^,or,^[;/ ]707980005^,or,^[;/ ]390798007^,or,^[;/ ]5281000124103^,or,^[;/ ]370221004^,),ANDNOT,^not asthma^

Submitting Author Email
nssp@cdc.gov
Referenced File
Submitted by rtugan on