Minor oddities in d_icd_diagnoses: same long_title for multiple ICD-9 codes
Nobody has claimed this yet.
- 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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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