MIT-LCP / MIT-LCP/mimic-code

Minor oddities in d_icd_diagnoses: same long_title for multiple ICD-9 codes

Open
#936 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

mimic-iv
Dominant language
Jupyter Notebook
Stars
3.4k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

This actually looks like a bug in the ICD-9 coding standard, since I find the same sharing of long_title for a few different codes from the CMS https://www.cms.gov/Medicare/Coding/ICD9ProviderDiagnosticCodes/codes

select long_title, group_concat(distinct icd_code), group_concat(distinct icd_version), count(*) c from d_icd_diagnoses group by long_title, icd_version  having c>1;
+-------------------------------------------------------------------------------------------------------------------------------------+---------------------------------+------------------------------------+---+
| long_title                                                                                                                          | group_concat(distinct icd_code) | group_concat(distinct icd_version) | c |
+-------------------------------------------------------------------------------------------------------------------------------------+---------------------------------+------------------------------------+---+
| Counseling for perpetrator of spousal and partner abuse                                                                             | V6112,V6122                     | 9                                  | 2 |
| Longitudinal deficiency, phalanges, complete or partial                                                                             | 75529,75539                     | 9                                  | 2 |
| Other multiple birth (three or more), mates liveborn and stillborn, born in hospital, delivered without mention of cesarean section | V3600,V3601                     | 9                                  | 2 |
| Suicide and self-inflicted injury by other specified means                                                                          | E9538,E9588                     | 9                                  | 2 |
| Suicide and self-inflicted injury by unspecified means                                                                              | E9539,E9589                     | 9                                  | 2 |
+-------------------------------------------------------------------------------------------------------------------------------------+---------------------------------+------------------------------------+---+
5 rows in set (0.50 sec)

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by rerunning the provided query against d_icd_diagnoses and compare the duplicate long_title values and ICD-9 codes with the linked CMS coding source. Determine whether the duplicates reflect source-standard behavior or an error in the repository data; done means documenting that conclusion and identifying any required correction.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.