Georgetown University

Charlson Index & International Classification of Diseases

Course Home Page 

Assigned Reading

Assignment for Scoring

Instruction for Submission of Assignments: Assignments should be submitted directly on Blackboard.  In rare situations assignments can be sent directly by email to the instructor. Submission should follow these rules:

  1. Submit your answers in a Jupyter Notebook Download► YouTube► Slides►
  2. Submit you answers in Blackboard.

Task 1: Using PubMed, find original Charlson, Deyo's version of Charlson, and the Romano's version of Charlson indices.  For each index, identify how many articles have cited the work.  Describe the number of diagnoses used by each of these three approaches.  Which index best predicts mortality risks?

Task 2: Please note this assignment is tedious and time consuming.  Allocate sufficient time.  The purpose of this assignment is to show you how you can mix methods that could save you time.  Another purpose of the assignment is to familiarize you with the underlying procedures for creating Charlson index within EHR.  Using the International Classification of Diseases, list out all codes that correspond to the truncated diagnosis codes.  Truncated codes are the codes that start with numbers but end with one or two "x".  For example, in the first row, the code 410.xx will convert to a number of codes not listed including 410.01, 410.02, and so on.  After removing truncated codes, convert the diagnoses codes in the table to a new table, where each diagnosis is listed in a separate row.  For example, the first two diagnosis listed in the second row convert to two rows, each containing one of the diagnosis.  The end result of these conversions is a new table with hundreds of rows, where each row has one diagnosis and one category.  Because this contains many diagnosis and many rows, you need to come up with a strategy that saves you time in these conversion.  Use Microsoft Word's convert text to table to make the conversions faster.  

Categories Dartmouth-Manitoba ICD-9 Codes
Myocardial Infarction 41O.xx, 412
Congestive heart failure 402.01, 402.11, 402.91, 425.x. 428.x, 429.3, 404.01, 494.03, 404.11, 404.13, 404.91, 404.93
Peripheral vascular disease 440.x, 441.x, 442.x, 443.1 - 443.9, 447.1, 785.4, 38.13-38.14, 38.16, 38.18, 38.33-38.34, 38.36, 38.38, 38.43-38.44, 38.46, 38.48, 39.22-39.26, 39.29
Cerebrovascular disease 362.34, 430-436, 437-437.1, 437.9, 438, 781.4, 784.3, 997.0, 38.12, 38.42
Dementia 290.x, 331-331.2
Chronic pulmonary disease  415.0, 416.8-416.9, 491.x-494, 496
Peptic ulcer disease 531.xx-534.xx



Copyright 2021 Farrokh Alemi, Ph.D. Most recent revision 04/21/2021.  This page is part of the course on Electronic Health Record Configuration and Data Analysis.