Skip to contents

Codelist diagnostics

Source: vignettes/a09_RunCodelistDiagnostics.Rmd
a09_RunCodelistDiagnostics.Rmd

This vignette presents a set of functions to explore the use of codes in a codelist. We will cover the following key functions:

Let’s start by loading the required packages, connecting to a mock database, and generating a codelist for example purposes. We’ll use getCandidateCodes() to find our codes.

library(DBI)
library(duckdb)
library(dplyr)
library(CDMConnector)
library(CodelistGenerator)
library(CohortConstructor)
library(omopgenerics)

# Connect to the database and create the cdm object
con <- dbConnect(duckdb(), 
                      eunomiaDir("synpuf-1k", "5.3"))
cdm <- cdmFromCon(con = con, 
                  cdmName = "Eunomia Synpuf",
                  cdmSchema   = "main",
                  writeSchema = "main", 
                  achillesSchema = "main")

# Create a codelist for depression
depression <- getCandidateCodes(cdm,
                                keywords = "depression")
depression <- newCodelist(list("depression" = depression$concept_id))

Running diagnostics for a codelist

Summarise code use using ACHILLES tables

This function uses ACHILLES summary tables to count the number of records and persons associated with each concept in a codelist. Notice that it requires that ACHILLES tables are available in the CDM.

achilles_code_use <- summariseAchillesCodeUse(depression, 
                                              cdm, 
                                              countBy = c("record", "person"))

From this, we will obtain a summarised result object. We can easily visualise the results using tableAchillesCodeUse():

tableAchillesCodeUse(achilles_code_use,
                     type = "gt")
Database name
Eunomia Synpuf
Codelist name Domain ID Standard concept name Standard concept ID Vocabulary ID
Estimate name
Record count Person count
depression condition Arteriosclerotic dementia with depression 374326 SNOMED 19 11
Presenile dementia with depression 377527 SNOMED 10 10
Senile dementia with depression 379784 SNOMED 21 18
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 SNOMED 10 10
Recurrent major depressive episodes 432285 SNOMED 60 41
Recurrent major depressive episodes, moderate 432883 SNOMED 203 88
Recurrent major depressive episodes, severe, with psychosis 434911 SNOMED 61 31
Bipolar affective disorder, currently depressed, moderate 437528 SNOMED 11 9
Severe major depression, single episode, with psychotic features 438406 SNOMED 10 9
Recurrent major depressive episodes, mild 438998 SNOMED 27 24
Bipolar affective disorder, currently depressed, in full remission 439251 SNOMED 13 13
Bipolar affective disorder, currently depressed, mild 439253 SNOMED 16 16
Severe major depression, single episode, without psychotic features 441534 SNOMED 25 18

Notice that concepts with zero counts will not appear in the result table.

Summarise code use using patient-level data

This function performs a similar task as above but directly queries patient-level data, making it usable even if ACHILLES tables are not available. It can be configured to stratify results by concept (byConcept), by year (byYear), by sex (bySex), or by age group (byAgeGroup). We can further specify a specific time period (dateRange).

code_use <- summariseCodeUse(depression,
                             cdm,
                             countBy = c("record", "person"),
                             byYear  = FALSE,
                             bySex   = FALSE,
                             ageGroup =  list("<=50" = c(0,50), ">50" = c(51,Inf)),
                             dateRange = as.Date(c("2010-01-01", "2020-01-01")))

tableCodeUse(code_use, type = "gt")
Database name
Eunomia Synpuf
Codelist name Age group Standard concept name Standard concept ID Source concept name Source concept ID Source concept value Type concept id Type concept name Domain ID Table
Estimate name
Person count Record count
depression <=50 overall – – – – – – – – 7 10
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 2 3
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 2
>50 overall – – – – – – – – 51 82
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000234 Outpatient header - 5th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 10 11
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 12 12
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756844 Carrier claim detail - 2nd position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 4 4
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 3
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 3 3
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
overall overall – – – – – – – – 58 92
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000234 Outpatient header - 5th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 12 13
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 14 15
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756844 Carrier claim detail - 2nd position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 4 4
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 3
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 3 3
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 3
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1

Identify orphan codes

Orphan codes are concepts that might be related to our codelist but that have not been included. It can be used to ensure that we have not missed any important concepts. Notice that this function uses ACHILLES tables.

summariseOrphanCodes() will look for descendants (via concept_descendants table), ancestors (via concept_ancestor table), and concepts related to the codes included in the codelist (via concept_relationship table). Additionally, if the cdm contains PHOEBE tables (concept_recommended table), they will also be used.

orphan <- summariseOrphanCodes(depression, cdm)
tableOrphanCodes(orphan, type = "gt")
Database name
Eunomia Synpuf
Codelist name Domain ID Standard concept name Standard concept ID Vocabulary ID Relationship
Estimate name
Record count Person count
depression condition Electrocardiogram abnormal 320536 SNOMED Ancestor, Subsumes 106 95
Disorder of brain 372887 SNOMED Ancestor, Subsumes 82 61
Central nervous system complication 373087 SNOMED Ancestor, Subsumes 3 3
Disorder of the central nervous system 376106 SNOMED Ancestor, Subsumes 19 17
Presenile dementia 378125 SNOMED Ancestor, Subsumes, Is a 13 12
Cerebrovascular disease 381591 SNOMED Due to of, Has due to 47 44
Emotional state finding 4025215 SNOMED Ancestor, Subsumes 4 4
General finding of observation of patient 4041283 SNOMED Ancestor, Subsumes 4 4
Mental disorders during pregnancy, childbirth and the puerperium 4060424 SNOMED Ancestor, Subsumes 1 1
procedure Surgical procedure 4301351 SNOMED Follows, Occurs before 2 2
condition Single major depressive episode 432284 SNOMED Is a, Concept same_as to, Maps to, Subsumes 64 45
Bipolar I disorder 432876 SNOMED Ancestor, Subsumes 28 22
Single major depressive episode, in full remission 433750 SNOMED Concept same_as to, Maps to 7 7
Schizophrenia 435783 SNOMED Occurs before, Follows 52 42
Psychotic disorder 436073 SNOMED Ancestor, Subsumes 110 79
Bipolar disorder 436665 SNOMED Ancestor, Subsumes 129 83
Single major depressive episode, mild 436945 SNOMED Concept same_as to, Maps to 14 12
Single major depressive episode, moderate 437837 SNOMED Concept same_as to, Maps to 27 24
Atypical depressive disorder 438727 SNOMED Ancestor, Subsumes 9 9
Viral disease 440029 SNOMED Occurs before, Follows 25 20
Recurrent major depressive episodes, in full remission 440075 SNOMED Is a, Concept same_as to, Maps to, Subsumes 32 20
Depressive disorder 440383 SNOMED Ancestor, Subsumes 440 288
Anxiety disorder 442077 SNOMED Ancestor, Subsumes 257 189

Run diagnostics within a cohort

You can also evaluate how the codelist is used within a specific cohort. First, we will define a cohort using the conceptCohort() function from CohortConstructor package.

cdm[["depression"]] <- conceptCohort(cdm, 
                                     conceptSet = depression, 
                                     name = "depression")

Then, we can summarise the code use within this cohort:

cohort_code_use <- summariseCohortCodeUse(cdm,
                                          cohortTable = "depression",
                                          countBy = c("record", "person"))
tableCohortCodeUse(cohort_code_use)
Database name
Eunomia Synpuf
Cohort name Codelist name Standard concept name Standard concept ID Source concept name Source concept ID Source concept value Type concept id Type concept name Domain ID Table
Estimate name
Person count Record count
depression depression overall – – – – – – – – 182 486
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 38000204 Inpatient header - 5th position condition condition_occurrence 1 1
38000238 Outpatient header - 9th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
45756843 Carrier claim detail - 1st position condition condition_occurrence 5 6
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000230 Outpatient header - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 3
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000206 Inpatient header - 7th position condition condition_occurrence 1 1
38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000232 Outpatient header - 3rd position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
45756850 Carrier claim detail - 8th position condition condition_occurrence 1 1
45756851 Carrier claim detail - 9th position condition condition_occurrence 1 1
45756852 Carrier claim detail - 10th position condition condition_occurrence 1 1
45756853 Carrier claim detail - 11th position condition condition_occurrence 1 1
45756854 Carrier claim detail - 12th position condition condition_occurrence 1 1
45756855 Carrier claim detail - 13th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000240 Outpatient header - 11th position condition condition_occurrence 2 2
45756844 Carrier claim detail - 2nd position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 21 23
45756836 Carrier claim header - 2nd position condition condition_occurrence 6 6
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 10 11
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000234 Outpatient header - 5th position condition condition_occurrence 1 1
38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756840 Carrier claim header - 6th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 10 10
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756846 Carrier claim detail - 4th position condition condition_occurrence 2 3
45756847 Carrier claim detail - 5th position condition condition_occurrence 2 3
45756848 Carrier claim detail - 6th position condition condition_occurrence 2 3
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 2 2
45756837 Carrier claim header - 3rd position condition condition_occurrence 2 2
45756849 Carrier claim detail - 7th position condition condition_occurrence 2 2
45756850 Carrier claim detail - 8th position condition condition_occurrence 2 2
45756851 Carrier claim detail - 9th position condition condition_occurrence 2 2
45756852 Carrier claim detail - 10th position condition condition_occurrence 2 2
45756848 Carrier claim detail - 6th position condition condition_occurrence 3 3
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 37 47
45756836 Carrier claim header - 2nd position condition condition_occurrence 4 4
45756845 Carrier claim detail - 3rd position condition condition_occurrence 4 5
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756843 Carrier claim detail - 1st position condition condition_occurrence 43 60
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756847 Carrier claim detail - 5th position condition condition_occurrence 6 6
45756846 Carrier claim detail - 4th position condition condition_occurrence 7 7
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756844 Carrier claim detail - 2nd position condition condition_occurrence 8 9
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
45756845 Carrier claim detail - 3rd position condition condition_occurrence 8 8
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 22 26
45756847 Carrier claim detail - 5th position condition condition_occurrence 3 4
45756846 Carrier claim detail - 4th position condition condition_occurrence 4 5
45756845 Carrier claim detail - 3rd position condition condition_occurrence 6 7
45756844 Carrier claim detail - 2nd position condition condition_occurrence 7 8
45756835 Carrier claim header - 1st position condition condition_occurrence 9 9
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756843 Carrier claim detail - 1st position condition condition_occurrence 12 14
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 7 7
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 9
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 11 15
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6

Summarise code use at cohort entry

Use the timing argument to restrict diagnostics to codes used at the entry date of the cohort.

cohort_code_use <- summariseCohortCodeUse(cdm,
                                          cohortTable = "depression",
                                          countBy = c("record", "person"),
                                          timing = "entry")
tableCohortCodeUse(cohort_code_use)
Database name
Eunomia Synpuf
Cohort name Codelist name Standard concept name Standard concept ID Source concept name Source concept ID Source concept value Type concept id Type concept name Domain ID Table
Estimate name
Person count Record count
depression depression overall – – – – – – – – 182 486
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 38000204 Inpatient header - 5th position condition condition_occurrence 1 1
38000238 Outpatient header - 9th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
45756843 Carrier claim detail - 1st position condition condition_occurrence 5 6
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000230 Outpatient header - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 3
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000206 Inpatient header - 7th position condition condition_occurrence 1 1
38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000232 Outpatient header - 3rd position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
45756850 Carrier claim detail - 8th position condition condition_occurrence 1 1
45756851 Carrier claim detail - 9th position condition condition_occurrence 1 1
45756852 Carrier claim detail - 10th position condition condition_occurrence 1 1
45756853 Carrier claim detail - 11th position condition condition_occurrence 1 1
45756854 Carrier claim detail - 12th position condition condition_occurrence 1 1
45756855 Carrier claim detail - 13th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000240 Outpatient header - 11th position condition condition_occurrence 2 2
45756844 Carrier claim detail - 2nd position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 21 23
45756836 Carrier claim header - 2nd position condition condition_occurrence 6 6
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 10 11
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000234 Outpatient header - 5th position condition condition_occurrence 1 1
38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756840 Carrier claim header - 6th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 10 10
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756846 Carrier claim detail - 4th position condition condition_occurrence 2 3
45756847 Carrier claim detail - 5th position condition condition_occurrence 2 3
45756848 Carrier claim detail - 6th position condition condition_occurrence 2 3
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 2 2
45756837 Carrier claim header - 3rd position condition condition_occurrence 2 2
45756849 Carrier claim detail - 7th position condition condition_occurrence 2 2
45756850 Carrier claim detail - 8th position condition condition_occurrence 2 2
45756851 Carrier claim detail - 9th position condition condition_occurrence 2 2
45756852 Carrier claim detail - 10th position condition condition_occurrence 2 2
45756848 Carrier claim detail - 6th position condition condition_occurrence 3 3
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 37 47
45756836 Carrier claim header - 2nd position condition condition_occurrence 4 4
45756845 Carrier claim detail - 3rd position condition condition_occurrence 4 5
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756843 Carrier claim detail - 1st position condition condition_occurrence 43 60
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756847 Carrier claim detail - 5th position condition condition_occurrence 6 6
45756846 Carrier claim detail - 4th position condition condition_occurrence 7 7
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756844 Carrier claim detail - 2nd position condition condition_occurrence 8 9
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
45756845 Carrier claim detail - 3rd position condition condition_occurrence 8 8
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 22 26
45756847 Carrier claim detail - 5th position condition condition_occurrence 3 4
45756846 Carrier claim detail - 4th position condition condition_occurrence 4 5
45756845 Carrier claim detail - 3rd position condition condition_occurrence 6 7
45756844 Carrier claim detail - 2nd position condition condition_occurrence 7 8
45756835 Carrier claim header - 1st position condition condition_occurrence 9 9
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756843 Carrier claim detail - 1st position condition condition_occurrence 12 14
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 7 7
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 9
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 11 15
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6

Cohort code use with a different codelist

By default we’ll get cohort code use for the codes that were used for creating the cohort. But we could change this to another cohort. Here we’d get counts for anxiety codes that occur on the same day as entry into the depression cohort.

anxiety <- getCandidateCodes(cdm,
                             keywords = "anxiety")
anxiety <- newCodelist(list("anxiety" = anxiety$concept_id))

cohort_code_use <- summariseCohortCodeUse(cdm,
                                          cohortTable = "depression",
                                          x = anxiety,
                                          countBy = c("record", "person"),
                                          timing = "entry")
tableCohortCodeUse(cohort_code_use)
Database name
Eunomia Synpuf
Cohort name Codelist name Standard concept name Standard concept ID Source concept name Source concept ID Source concept value Type concept id Type concept name Domain ID Table
Estimate name
Person count Record count
depression anxiety overall – – – – – – – – 20 25
Acute stress disorder 440083 Other acute reactions to stress 44820738 3083 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
Unspecified acute reaction to stress 44819559 3089 38000232 Outpatient header - 3rd position condition condition_occurrence 1 1
Anxiety disorder 442077 Anxiety state, unspecified 44832239 30000 38000231 Outpatient header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 4 4
Generalized anxiety disorder 434613 Generalized anxiety disorder 44829926 30002 38000233 Outpatient header - 4th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
45756837 Carrier claim header - 3rd position condition condition_occurrence 3 3
Obsessive-compulsive disorder 440374 Obsessive-compulsive disorders 44822985 3003 38000236 Outpatient header - 7th position condition condition_occurrence 1 1
Panic disorder without agoraphobia 4211231 Panic disorder without agoraphobia 44826503 30001 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
Posttraumatic stress disorder 436676 Posttraumatic stress disorder 44836990 30981 45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756836 Carrier claim header - 2nd position condition condition_occurrence 3 3

Stratify cohort code use

You can also stratify cohort code use results by year (byYear), by sex (bySex), or by age group (byAgeGroup):

cohort_code_use <- summariseCohortCodeUse(cdm = cdm,
                                          cohortTable = "depression",
                                          countBy = c("record", "person"),
                                          byYear = FALSE,
                                          bySex = TRUE,
                                          ageGroup = NULL)
tableCohortCodeUse(cohort_code_use)
Database name
Eunomia Synpuf
Cohort name Codelist name Sex Standard concept name Standard concept ID Source concept name Source concept ID Source concept value Type concept id Type concept name Domain ID Table
Estimate name
Person count Record count
depression depression overall overall – – – – – – – – 182 486
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 38000204 Inpatient header - 5th position condition condition_occurrence 1 1
38000238 Outpatient header - 9th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
45756843 Carrier claim detail - 1st position condition condition_occurrence 5 6
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000230 Outpatient header - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 3
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000206 Inpatient header - 7th position condition condition_occurrence 1 1
38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000232 Outpatient header - 3rd position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
45756850 Carrier claim detail - 8th position condition condition_occurrence 1 1
45756851 Carrier claim detail - 9th position condition condition_occurrence 1 1
45756852 Carrier claim detail - 10th position condition condition_occurrence 1 1
45756853 Carrier claim detail - 11th position condition condition_occurrence 1 1
45756854 Carrier claim detail - 12th position condition condition_occurrence 1 1
45756855 Carrier claim detail - 13th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 11 11
38000240 Outpatient header - 11th position condition condition_occurrence 2 2
45756844 Carrier claim detail - 2nd position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 21 23
45756836 Carrier claim header - 2nd position condition condition_occurrence 6 6
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 10 11
45756835 Carrier claim header - 1st position condition condition_occurrence 12 12
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000234 Outpatient header - 5th position condition condition_occurrence 1 1
38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756840 Carrier claim header - 6th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 10 10
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756846 Carrier claim detail - 4th position condition condition_occurrence 2 3
45756847 Carrier claim detail - 5th position condition condition_occurrence 2 3
45756848 Carrier claim detail - 6th position condition condition_occurrence 2 3
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 2 2
45756837 Carrier claim header - 3rd position condition condition_occurrence 2 2
45756849 Carrier claim detail - 7th position condition condition_occurrence 2 2
45756850 Carrier claim detail - 8th position condition condition_occurrence 2 2
45756851 Carrier claim detail - 9th position condition condition_occurrence 2 2
45756852 Carrier claim detail - 10th position condition condition_occurrence 2 2
45756848 Carrier claim detail - 6th position condition condition_occurrence 3 3
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 37 47
45756836 Carrier claim header - 2nd position condition condition_occurrence 4 4
45756845 Carrier claim detail - 3rd position condition condition_occurrence 4 5
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756843 Carrier claim detail - 1st position condition condition_occurrence 43 60
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756847 Carrier claim detail - 5th position condition condition_occurrence 6 6
45756846 Carrier claim detail - 4th position condition condition_occurrence 7 7
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756844 Carrier claim detail - 2nd position condition condition_occurrence 8 9
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756835 Carrier claim header - 1st position condition condition_occurrence 8 8
45756845 Carrier claim detail - 3rd position condition condition_occurrence 8 8
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 22 26
45756847 Carrier claim detail - 5th position condition condition_occurrence 3 4
45756846 Carrier claim detail - 4th position condition condition_occurrence 4 5
45756845 Carrier claim detail - 3rd position condition condition_occurrence 6 7
45756844 Carrier claim detail - 2nd position condition condition_occurrence 7 8
45756835 Carrier claim header - 1st position condition condition_occurrence 9 9
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756843 Carrier claim detail - 1st position condition condition_occurrence 12 14
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 7 7
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 8 9
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 11 15
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Female overall – – – – – – – – 97 228
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 3 4
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 45756835 Carrier claim header - 1st position condition condition_occurrence 7 7
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000206 Inpatient header - 7th position condition condition_occurrence 1 1
38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 14 16
38000240 Outpatient header - 11th position condition condition_occurrence 2 2
45756836 Carrier claim header - 2nd position condition condition_occurrence 3 3
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 3 3
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756840 Carrier claim header - 6th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 19 26
45756845 Carrier claim detail - 3rd position condition condition_occurrence 2 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 23 27
45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
45756845 Carrier claim detail - 3rd position condition condition_occurrence 3 3
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756844 Carrier claim detail - 2nd position condition condition_occurrence 3 3
45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756844 Carrier claim detail - 2nd position condition condition_occurrence 5 5
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 11 12
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 2
45756845 Carrier claim detail - 3rd position condition condition_occurrence 3 3
45756844 Carrier claim detail - 2nd position condition condition_occurrence 4 4
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
45756843 Carrier claim detail - 1st position condition condition_occurrence 5 5
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 5 6
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
45756843 Carrier claim detail - 1st position condition condition_occurrence 9 13
Male overall – – – – – – – – 85 258
Arteriosclerotic dementia with depression 374326 Vascular dementia, with depressed mood 44829914 29043 38000204 Inpatient header - 5th position condition condition_occurrence 1 1
38000238 Outpatient header - 9th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Bipolar affective disorder, currently depressed, in full remission 439251 Bipolar I disorder, most recent episode (or current) depressed, in full remission 44822977 29656 38000230 Outpatient header - 1st position condition condition_occurrence 2 2
45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
Bipolar affective disorder, currently depressed, mild 439253 Bipolar I disorder, most recent episode (or current) depressed, mild 44826500 29651 45756836 Carrier claim header - 2nd position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 9 9
Bipolar affective disorder, currently depressed, moderate 437528 Bipolar I disorder, most recent episode (or current) depressed, moderate 44835786 29652 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 3
45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Presenile dementia with depression 377527 Presenile dementia with depressive features 44836954 29013 45756843 Carrier claim detail - 1st position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
Recurrent major depressive episodes 432285 Major depressive affective disorder, recurrent episode, unspecified 44831089 29630 38000232 Outpatient header - 3rd position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 1
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 1
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 1
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
45756850 Carrier claim detail - 8th position condition condition_occurrence 1 1
45756851 Carrier claim detail - 9th position condition condition_occurrence 1 1
45756852 Carrier claim detail - 10th position condition condition_occurrence 1 1
45756853 Carrier claim detail - 11th position condition condition_occurrence 1 1
45756854 Carrier claim detail - 12th position condition condition_occurrence 1 1
45756855 Carrier claim detail - 13th position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 3 3
45756835 Carrier claim header - 1st position condition condition_occurrence 5 5
45756843 Carrier claim detail - 1st position condition condition_occurrence 7 7
Recurrent major depressive episodes, mild 438998 Major depressive affective disorder, recurrent episode, mild 44829923 29631 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
45756844 Carrier claim detail - 2nd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 6 6
45756843 Carrier claim detail - 1st position condition condition_occurrence 7 8
Recurrent major depressive episodes, moderate 432883 Major depressive affective disorder, recurrent episode, moderate 44831090 29632 38000234 Outpatient header - 5th position condition condition_occurrence 1 1
45756837 Carrier claim header - 3rd position condition condition_occurrence 1 1
45756845 Carrier claim detail - 3rd position condition condition_occurrence 1 2
45756846 Carrier claim detail - 4th position condition condition_occurrence 1 2
45756847 Carrier claim detail - 5th position condition condition_occurrence 1 2
45756848 Carrier claim detail - 6th position condition condition_occurrence 1 2
45756849 Carrier claim detail - 7th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 38000230 Outpatient header - 1st position condition condition_occurrence 1 1
38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756843 Carrier claim detail - 1st position condition condition_occurrence 14 20
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756837 Carrier claim header - 3rd position condition condition_occurrence 2 2
45756848 Carrier claim detail - 6th position condition condition_occurrence 2 2
45756849 Carrier claim detail - 7th position condition condition_occurrence 2 2
45756850 Carrier claim detail - 8th position condition condition_occurrence 2 2
45756851 Carrier claim detail - 9th position condition condition_occurrence 2 2
45756852 Carrier claim detail - 10th position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 24 34
Major depressive affective disorder, recurrent episode, moderate 44831090 29632 45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
45756836 Carrier claim header - 2nd position condition condition_occurrence 3 3
45756844 Carrier claim detail - 2nd position condition condition_occurrence 3 4
Major depressive affective disorder, recurrent episode, severe, without mention of psychotic behavior 44835785 29633 45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
45756846 Carrier claim detail - 4th position condition condition_occurrence 5 5
45756847 Carrier claim detail - 5th position condition condition_occurrence 5 5
45756845 Carrier claim detail - 3rd position condition condition_occurrence 6 6
45756844 Carrier claim detail - 2nd position condition condition_occurrence 7 7
Recurrent major depressive episodes, severe, with psychosis 434911 Major depressive affective disorder, recurrent episode, severe, specified as with psychotic behavior 44827655 29634 38000240 Outpatient header - 11th position condition condition_occurrence 1 1
45756843 Carrier claim detail - 1st position condition condition_occurrence 11 14
45756846 Carrier claim detail - 4th position condition condition_occurrence 2 3
45756847 Carrier claim detail - 5th position condition condition_occurrence 2 3
45756844 Carrier claim detail - 2nd position condition condition_occurrence 3 4
45756845 Carrier claim detail - 3rd position condition condition_occurrence 3 4
45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
Senile dementia with depression 379784 Senile dementia with depressive features 44819534 29021 45756835 Carrier claim header - 1st position condition condition_occurrence 1 1
45756836 Carrier claim header - 2nd position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 7 9
Severe bipolar II disorder, most recent episode major depressive, in partial remission 4283219 Bipolar I disorder, most recent episode (or current) depressed, in partial or unspecified remission 44820721 29655 45756835 Carrier claim header - 1st position condition condition_occurrence 4 4
Severe major depression, single episode, with psychotic features 438406 Major depressive affective disorder, single episode, severe, specified as with psychotic behavior 44820717 29624 45756835 Carrier claim header - 1st position condition condition_occurrence 3 3
Severe major depression, single episode, without psychotic features 441534 Major depressive affective disorder, single episode, severe, without mention of psychotic behavior 44835784 29623 45756838 Carrier claim header - 4th position condition condition_occurrence 1 1
45756835 Carrier claim header - 1st position condition condition_occurrence 2 2
45756843 Carrier claim detail - 1st position condition condition_occurrence 2 2